MAoS ( Manage Availability of Supply) KPIs

Client

Eskom

Contact Person: Aumkar Sukhoo

Project Number: ES029

Project Duration: 4 Months (Dec 2012 – Mar 2013)))

Description of Situation

The MAoS data is coming from four different source systems – Maximo, CNL, CC&B and NEPS. The challenge was to build KPIs using the data from these systems.

Dake played a pivotal role in gathering the requirement from the business owners and prepared a detailed designed document. Also, built complex SaS ETLs that can read data from all the three source systems and display the MAoS KPI’s.

Technology Used

Roles Performed

Project Manager

Oracle DBA

Systems Analyst

SAP Business Objects Developer

SAS DI Developer

Key Achievements

Successfully analyzed the source data in Maximo, CNL and CC&B and prepared a detailed design document
Complex mathematical calculations were performed on large volumes of data and set new records in the ETL performances
Built complex KPI’s reading from three different source systems
Performed UAT with the business user
Our Team was appreciated on numerous occasions for the good work done on the ETLs
Successfully completed the project within time and budget

Related Cases

Analytics CoE, Exxaro

Client Exxaro Contact Person: Alfred Raulinga Project Number: EX002 Project Duration: Ongoing

Analytics Center of Excellence

Client Eskom Contact Person: Dika Modise Project Number: ES003 Project Duration: 2017

Mobility via Service Suit (HDB)

Client Eskom Contact Person: Sarel Marais Project Number: ES030 Project Duration: 8

Talk to an Expert