UMB
Insight into how D3Clarity implemented a customer and product MDM that centralized customer profiles and created visibility for complex customer relationships.
Insight into how D3Clarity implemented a customer and product MDM that centralized customer profiles and created visibility for complex customer relationships.
01 BUSINESS CHALLENGES
We specializes in helping organizations establish strong data governance practices that supports your business goals and drives innovation.
02 APPROACH
We specializes in helping organizations establish strong data governance practices that supports your business goals and drives innovation.
03 BUSINESS IMPACT
We specializes in helping organizations establish strong data governance practices that supports your business goals and drives innovation.
Insight into how D3Clarity implemented a customer and product MDM that centralized customer profiles and created visibility for complex customer relationships.
01 BUSINESS CHALLENGES
UMB is a provider of financial services for individuals and institutions.
UMB was facing challenges of:
– Duplicate customer records which led to inaccurate customer profiles
– Different versions of product information
UMB desires a commercially available Master Data Management (MDM) to provide a universal system of truth for customer and product data with line of sight across all transactional and decision support systems.
UMB was facing challenges of:
– Duplicate customer records which led to inaccurate customer profiles
– Different versions of product information
UMB desires a commercially available Master Data Management (MDM) to provide a universal system of truth for customer and product data with line of sight across all transactional and decision support systems.
02 APPROACH
D3C was chosen as the implementation partner for their skill set with Semarchy xDM. Implemenation involved with establishment of a central repository for product information, line of business consolidation and enterprise customer SOR.
Inbound data feeds were loaded into Semarchy via IBM DataStage ETL. Semarchy xDI was used as the integration platform between Semarchy xDM and Salesforce.
Golden record management will combine data sources for Customer/account, product and line of business to make use of the best data elements from their respective systems of records. UMB Data Stewards own the responsibility to resolve conflicts and manage account hierarchies as the business requires.
The MDM system allows many disparate systems to be onboarded and offboarded more seamlessly. The golden records remain intact. As transactional/source systems are onboarded, they would need to have an integration with MDM to inform the golden record, while very little change would be required of the downstream data flows. Similarly, new downstream systems would integrate with MDM reusing components built for other dependent systems.
To further enforce the MDM process, data governance was implemented to include matching, survivorship and business validations rules that are monitored and enhanced by Data Stewards.
Inbound data feeds were loaded into Semarchy via IBM DataStage ETL. Semarchy xDI was used as the integration platform between Semarchy xDM and Salesforce.
Golden record management will combine data sources for Customer/account, product and line of business to make use of the best data elements from their respective systems of records. UMB Data Stewards own the responsibility to resolve conflicts and manage account hierarchies as the business requires.
The MDM system allows many disparate systems to be onboarded and offboarded more seamlessly. The golden records remain intact. As transactional/source systems are onboarded, they would need to have an integration with MDM to inform the golden record, while very little change would be required of the downstream data flows. Similarly, new downstream systems would integrate with MDM reusing components built for other dependent systems.
To further enforce the MDM process, data governance was implemented to include matching, survivorship and business validations rules that are monitored and enhanced by Data Stewards.
03 BUSINESS IMPACT
As a result of MDM,
– UMB now has a universal customer number which encompasses all customer systems of record. MDM retains lineage in order to traverse back to the corresponding source system’s unique identifiers.
– The new system will ease the onboarding and offboarding of systems more seamlessly by having a unified identifier outside of each source system.
– UMB now has visibility to complex customer relationships and those relationships are compatible with SalesForce. The Salesforce data has now become more trusted.
– Product data is now managed by product SMEs within the MDM tool and automatically flows into dependent systems. Additions/changes to products have less negative impact to downstream systems.
– UMB now has a universal customer number which encompasses all customer systems of record. MDM retains lineage in order to traverse back to the corresponding source system’s unique identifiers.
– The new system will ease the onboarding and offboarding of systems more seamlessly by having a unified identifier outside of each source system.
– UMB now has visibility to complex customer relationships and those relationships are compatible with SalesForce. The Salesforce data has now become more trusted.
– Product data is now managed by product SMEs within the MDM tool and automatically flows into dependent systems. Additions/changes to products have less negative impact to downstream systems.
