South African Local government

Business Driver

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.

Read More: South African Local government

Investment Banking Client Static and Data Governance

Absa Capital implements Data GovernanceAbsa Capital Reduces Risk with Data Governance and Data Quality

Business Driver:

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.

Read More: Investment Banking Client Static and Data Governance

Corporate Real Estate Management

Business driver:

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 fundmental question: :"How much does it cost to run each building?"

The environment

The core system being used by this client was SAP - holding a subset of lease, building, vendoir and related payments. However, a number of homebuilt solutions, inclduing 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.

The solution:

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

Business driver:

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.

The environment:

Social grants, of various kinds, are offered by 18 seperate 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 eligilefor grants werereceiving these.

Most operational systems were mainframe based Natural Adabase systems. However, a range of other data sources including SQL RDMS systems and delimted text files were also accessed.

The solution:

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 singl, best record for each system.

These records were loaded into the NISIS Hub, a custom MDM application built by the project team. The inital requirement was delivered within three months.

Key benefits:

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.

- See more at: http://www.masterdata.co.za/index.php/case-studies#sthash.Cx73452a.dpuf

Business driver:

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.

The environment:

Social grants, of various kinds, are offered by 18 seperate 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 eligilefor grants werereceiving these.

Most operational systems were mainframe based Natural Adabase systems. However, a range of other data sources including SQL RDMS systems and delimted text files were also accessed.

The solution:

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 singl, best record for each system.

These records were loaded into the NISIS Hub, a custom MDM application built by the project team. The inital requirement was delivered within three months.

Key benefits:

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.

- See more at: http://www.masterdata.co.za/index.php/case-studies#sthash.Cx73452a.dpufBusiness driver:

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.
The environment:

Social grants, of various kinds, are offered by 18 seperate 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 eligilefor grants werereceiving these.

Most operational systems were mainframe based Natural Adabase systems. However, a range of other data sources including SQL RDMS systems and delimted text files were also accessed.
The solution:

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 singl, best record for each system.

These records were loaded into the NISIS Hub, a custom MDM application built by the project team. The inital requirement was delivered within three months.
Key benefits:

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.
- See more at: http://www.masterdata.co.za/index.php/case-studies#sthash.Cx73452a.dpuf

Business driver:

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.

The environment:

Social grants, of various kinds, are offered by 18 seperate 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 eligilefor grants werereceiving these.

Most operational systems were mainframe based Natural Adabase systems. However, a range of other data sources including SQL RDMS systems and delimted text files were also accessed.

The solution:

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 singl, best record for each system.

These records were loaded into the NISIS Hub, a custom MDM application built by the project team. The inital requirement was delivered within three months.

Key benefits:

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.

- See more at: http://www.masterdata.co.za/index.php/case-studies#sthash.Cx73452a.dpuf

Business driver:

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.

The environment:

Social grants, of various kinds, are offered by 18 seperate 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 eligilefor grants werereceiving these.

Most operational systems were mainframe based Natural Adabase systems. However, a range of other data sources including SQL RDMS systems and delimted text files were also accessed.

The solution:

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 singl, best record for each system.

These records were loaded into the NISIS Hub, a custom MDM application built by the project team. The inital requirement was delivered within three months.

Key benefits:

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.

- See more at: http://www.masterdata.co.za/index.php/case-studies#sthash.Cx73452a.dpuf

National Integrated Social information System

Business driver:

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.

Read More: National Integrated Social information System
No events

Follow Us on Facebook Google+ Follow Follow Us on Twitter Follow Us On LinkedInyoutube

MDM is committed to the protection of personal information.

For our Privacy Policy, click here

Subscribe to our monthly newsletter for data management tips, updates and news
Country *
We will not share you details
Unsubscribe at any time
Please wait

This Site uses Cookies. Ignoring this message implies acceptance