Bank strengthens data integrity and quality
How a South African bank improved data quality and integrity with advanced data management solutions.

Client
Accurate data management is crucial for operational efficiency and customer satisfaction. Our client, one of the big five banks in South Africa, faced challenges with disparate data models across various business units. They needed a comprehensive solution to define customer, employee, and location data models aligned with industry best practices to support future business growth and understand their customers' multifaceted roles.
Challenge
Disconnected data sets across core banking, mortgage, and credit card systems.
A need to discern the diverse roles customers play in their interactions with the bank.
Inconsistencies in employee and location data from HRMS systems and manual records, leading to significant manual intervention for mapping and managing appointments.
Solution
Establishing a unified data model for customers, employees, and locations based on industry best practices.
Conducting thorough data analysis and integrating a fuzzy logic matching algorithm for customer deduplication.
Implementing data validations using reference data and standard business rules.
Onboarding core banking customers to a Master Data Management (MDM) system in phase 1.
Integrating employee and location data from HRMS and other sources, with MDM serving as an aggregator.
Defining workflows and business rules to ascertain employee eligibility for customer appointments and appropriate locations.
Ensuring daily data synchronization with the online appointment booking system, covering:
Onboarding of new or promoted employees and their location data.
Relocation updates for currently eligible employees.
Deactivation of terminated employees.
Updates for location address changes and operating hours.
Impact
Significantly improved customer data quality, reducing duplicate records by 8% and invalid data by nearly 30%.
Enabled the marketing team to leverage MDM data for successful advertising campaigns on online platforms.
Ensured the availability of accurate information on eligible employees and locations for customer use.
Achieved cost savings by automating updates to the online appointment booking system, eliminating the need for manual intervention.