Public Utilities

Public Utilities

Roseville Electric, City of Roseville

Touchpoints has provided Data Architecture and Project Management services to the City of Roseville, Electric Department. Our team worked closely with the Risk Management Section of Roseville Electric to help them streamline their financial, performance, and regulatory reporting data. Before this project, all of their reporting data and business logic was haphazardly distributed across different data sources. We lead the effort to build a relational database repository which once populated, would be used as the primary source of reporting data. Apart from implementation of the new database model, we also provided ETL support and training/mentoring of technical staff regarding the usage of the newly developed model. Our scope of services to the city included:

  • Database Architecture
  • Technical Knowledge Transfer and Training
  • Project Oversight and Management

casestudy-icon