← All work

Clallam PUD / 2017–2026

Enterprise data & modernization

The work starts with where information lives and how a department uses it. My projects include legacy records access, NISC reporting, capital-budget maps and a defined phase of SQL Server reporting migration.

My role

Database administration, data integration, application development and validation

Data integration approach

01Source systems

Legacy records and NISC data

02Read and prepare

Read-only access and staged refreshes

03Make usable

Web lookup, reports and project maps

Preserve the source while serving a specific operational need.

2022–2023

Keep legacy records accessible

Modernized access to an AS/400 transformer database through a read-only dataset and web front end, covering equipment information, maintenance, location and testing. Also supported modernization of box-inventory and microfilm records.

Operational purpose

Engineering and Records could use the retained information through newer interfaces rather than depend on the legacy lookup workflow.

2023–2026

Connect budgets to geography

Developed capital-budget maps with Finance and the departments responsible for the projects, bringing location, cost, department and scope together.

Use in the utility

The maps supported annual capital-project reporting. Esri’s published customer story also describes the utility’s use of dashboards for capital budgets.

2026

Migrate reports and integrate analytics

Imported 92 SSRS reports into SQL Server 2022 Reporting Services, updated data-source connections and validated a representative budget report. Built a separate SQL reporting database using read-only NISC Oracle access, staged refreshes and scheduled synchronization.

Defined scope

The report import and representative rendering were verified. Subscriptions, legacy item-level permissions and final cutover were outside that migration phase.

Technical environment

SQL Server · Oracle · SSRS · SQL Agent · PowerShell · Legacy AS/400 data · ArcGIS