City of Ekurhuleni: Mater Data – Single view of the customer
The project entailed creating a central repository for master data, and thus creating single view of a customer from the Metro’s disparate legacy systems.
The project also entailed creating and implementing data governance rules, as well as cleaning up the data using technical tools.
We proposed the adoption of a new data governance framework.
In terms of technical architecture solution, we analysed each database in terms of (customer record) structure and technical characteristics. We consolidated all the data into staging database from which the data would be reconstructed into an Oracle MDM database.
The rest of the system would then refer the customer data from here.