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.
Database administration, data integration, application development and validation
Data integration approach
Legacy records and NISC data
Read-only access and staged refreshes
Web lookup, reports and project maps
Preserve the source while serving a specific operational need.
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.
Engineering and Records could use the retained information through newer interfaces rather than depend on the legacy lookup workflow.
Connect budgets to geography
Developed capital-budget maps with Finance and the departments responsible for the projects, bringing location, cost, department and scope together.
The maps supported annual capital-project reporting. Esri’s published customer story also describes the utility’s use of dashboards for capital budgets.
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.
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