- South African local government
- Investment Banking Client Static and Data Governance
- Corporate Real Estate Management
- National Integrated Social information System
A South African local authority received a qualifeid audit due in part to data inconsistencies with billing, customer and services data. MDM were contracted to identify key data issues for remediation in order to address the audit findings.
The customer, services, materials, and billing data sourced from SAP, the Venus municipal billing system, the GIS application and various others
MDM delivered a dfocussed data quality assessment that allowed the municipality to identify and remediate data discrepencies across its customer, account, billing, properties and services data.
As a result the municiaplity were able to cut their outstanding debt by nearly 50%, gained insight into business process failing impacting key service delivery and revenue collection, and address many of the audit finding
Inconsistent client static data across multiple systems and business units was exposing the client to unnecessary risk, adding unnecessary costs and reducing the ability to leverage client activity to drive additional revenue.
This needed to be resolved urgently in order to comply with the terms of the Basel II AIRB Waiver, as well as to improve operating efficiency on an ongoing basis.
Multiple client data sources, across multiple geographies, including: a COBOL mainframe application, MS Dynamics CRM, and various custom built trading and customer management platforms.
Microsoft SSIS was the preferred data integration solution.
Master Data Management CC implemented a solution to verify, standardise and consolidate existing client data across the major client systems, leveraging Microsoft SSIS for extract and load, and the Trillium Software System for advanced data matching, exception management and data consolidation (the "single view").
We also assisted with embedding data governance principles, including an ongoing data monitoring solution, in order to ensure that data remained in line with business requirements. For more information please download the case study
Key focus: Customer master data. Data Governance, Data Quality, Master Data Management
The client, a major financial services corporation, has a property portfolio of hundreds of units costing more than R2billion per annum to run.
The challenge? Poor data quality made it impossible to answer the fundamental question: :"How much does it cost to run each building?"
The core system being used by this client was SAP - holding a subset of lease, building, vendoir and related payments. However, a number of home built solutions, including a GIS system, SQL databases and Excel spreadsheets were being used to plug core property management gaps in functionality.
The disconnects between theses systems, combined with the disconnects between variable expenses and l;eases, were the primary problem.
Master Data Management CC delivered a data quality audit to idenitfy key data issues causing the BI solution to fail. This gap analysis was used to scope the requirements to enhance the exisitng data to provide an improved reporting capability manage key metrics.
Key Focus: Business Intelligence, BI, Data Profiling, Data Quality, SAP, Product master data
The client, on behalf of a number of government departments, wanted to improve the delivery of services to the indigent community. At the time planning for service delivery was based on the extrapolated results of the 2001 census - with no real understanding of how population demographics had shifted since then.
Social grants, of various kinds, are offered by 18 separate government departments, and can be offered at national, regional and local government levels. At the time no consolidated view was available to ensure that persons eligible grants were receiving these.
Most operational systems were mainframe based Natural Adabas systems. However, a range of other data sources including SQL RDMS systems and delimited text files were also accessed.
Master Data Management CC provided data management consulting and the Trillium Software System® to build a consolidated, single view of the citizen. Data from various operational systems was matched, using the Trillium Software System® and the best elements from each source were combined to create a single, best record for each system.
These records were loaded into the NISIS Hub, a custom MDM application built by the project team. The initial requirement was delivered within three months.
Over 70 million South African name and address records were parsed and matched during the project.
Of these, over 65% were geocoded to suburb level allowing departmental planners to more accurately identify the location of registered indigents - critical for planning purposes.
The consolidated view also enables a one stop operational view to idenitfy whether citizens are receiving the correct support.
Key Focus: Customer Master Data, Master Data Management, MDM, Data Quality, Data Governance