{"id":14367,"date":"2020-01-31T00:07:30","date_gmt":"2020-01-31T00:07:30","guid":{"rendered":"https:\/\/oxfordcorp.com\/?p=14367"},"modified":"2026-11-11T12:18:45","modified_gmt":"2026-11-11T12:18:45","slug":"performance-management-tool-to-prepare-scorecards","status":"publish","type":"post","link":"https:\/\/www.oxfordcorp.com\/es\/insights\/case-study\/performance-management-tool-to-prepare-scorecards\/","title":{"rendered":"Performance Management Tool to Prepare Scorecards"},"content":{"rendered":"

INDUSTRY<\/strong>
\nCable Provider<\/p>\n

SERVICES<\/strong>
\nETL
\nBusiness Intelligence
\nSDLC
\nScorecards<\/p>\n

SKILLS<\/strong>
\nETL Development
\nData Management
\nBusiness Analysis
\nSystems Analysis
\nQA and Testing<\/p>\n

The Challenge<\/strong>
\nOur client required a performance management tool to prepare scorecards to support their effort of monitoring the performance of frontline employees against business objectives. The Employee Information Database required enhancements to integrate employee data from various systems including billing, telephone, survey, sales, scheduling, timesheet and quality. The employee data needed to be populated into various data marts to support a variety of reporting needs (e.g. scorecards, management reporting, dashboards, and compensation).<\/p>\n

The Solution<\/strong>
\nWe provided consulting services to support project throughout during the entire system development life cycle, including requirements definition; database design; employee data mart and data import requirements; ETL code and systems administration documentation; and quality assurance. Upon completion of the project, the client engaged our team to provide maintenance and analysis.<\/p>\n

The Result<\/strong>
\nWe partnered with our client to provide a next generation platform for development and support for their Employee Information Database and reporting system. The project was completed on time and met all budgetary objectives. Our work provided our client with the following results:<\/p>\n