A large investor-owned utility, with multiple geographic and business unit operations, was utilizing Excel spreadsheet reports from over 30 separate data sources and measuring various business drivers from their customer facing operations. This client requested an automated and simplified visual display of trends and alerts for key customer facing business drivers.
The client requested a KPI based dashboard providing O&M, Capital, and HR information on a monthly basis.
Corporate executives did not have visibility into a broad range of Human Capital measurements. Although a Human Capital module operated within the company’s ERP framework, the reports were cumbersome and inefficient.
A plan was developed to enable proper backups, reconfigure memory allocation as needed, and dump and reload the database to remove fragmentation at both the index and data levels.
Engineering consultants developed the project, created cut-over and roll-back plans, designed and deployed switch configurations, and implemented the new system alongside the client’s full-time engineers. As part of the conversion, we also tested and deployed the new equipment and assisted with technical support.