Project details

  • Date

     November 2, 2014

  • Client

     Ekurhuleni Metro

  • Task

     Mater Data Management

The Solution

NTo support effective data governance, Ntiyiso-BCX proposed the adoption of a data governance framework by the Data Governance Institute (DGI) as it meets the requirements for implementation of effective data governance. The intellectual property was freely available for any organisation to utilise. We understood that implementing data governance and a data governance forum is a process that requires maturing over time and needs to be specific to the implementing organisation; and that data governance must also take into account the maturity of the organisation as well as existing governance and risk management policies and processes.

In terms of technical architecture, the solution of analyses each and every database in terms of (customer record) structure and technical characteristics. We would then work out a plan to pull the data into staging database from which the data would be reconstructed into an Oracle MDM database. The rest of the system would refer the customer data from here.

The Ntyiso Effect

However with the support of the internal team with insight on some of the assumptions around certain data structuring, we managed to reconstruct the single customer. Howver, this data was cleaned at database level in terms of structure. However it was not verified, in particulars, some of the records where obsolete (e.g. person died, moved out of the Metro etc). This required verification through a call centre operation, deeds and home affairs searches. Phase 2 on the project was planed to carry out the process. Contact: Lazarus Sikhwetha (Boksburg), Tel. +27 (0) 11 999 7113