As the leading door hardware wholesale distributor, Banner Solutions experienced substantial growth in both its expansive product portfolio and customer base. While expansion is good, the increase presented growth challenges, primarily centered around data quality and integration issues. As their customer base grew, this organization found itself grappling with the issue of duplicate customer data, exacerbated by disparate source systems retaining different customer elements. The complexity was further heightened by acquisitions, contributing to inconsistency in data definitions, rules, and values.
Compounding these issues were the intricacies of managing pricing options that changed and expired per customer record. The process of rectifying duplicate and inconsistent pricing for customers with multiple accounts is a challenge on its own. Banner Solutions knew they wouldn’t be able to continue at the current pace without implementing a modern enterprise program and enforcing governance around the definitions and use of data.
D3Clarity implemented a Customer Master solution that centralized the curation of customer elements, enabled customer rollups through organizational hierarchies, and implemented custom filters to enable a search of pricing libraries, books, and pages by effective dates. The benefits of implementing a Customer Master solution increased the accuracy and insight for operational and sales reporting through higher data quality and integrated data points silos that occurred through the different acquisition activities.
As part of the modernization platform, Semarchy’s Unified Data Platform was chosen as the master data management (MDM) platform, and D3Clarity was selected as Banner Solution’s implementation partner of choice.
Enrichments that added completeness and accuracy to address information, validated business rules, and provided governance on data values were included. Multi-person workflows were created to reduce the manual errors that were previously missed during the onboarding of new customers. Utilizing Semarchy’s xDI component, new ETL jobs were created to process inbound feeds from multiple customer sources into an MDM staging location. ETL routines were developed for both initial and delta loads. Golden record information from the MDM solution was published to downstream systems. Knowledge transfer sessions were provided throughout the engagement on the technology, customizations, deployments, data stewardship capabilities, and business user tasks. After the initial deployment, D3Clarity’s solution support was engaged to provide continued enhancements and architecture guidance.
Through the implementation of a Customer Master solution, D3Clarity laid the foundation for a modern enterprise program that promises to ease the management and governance of customer data and other essential domain information, ensuring enhanced efficiency and effectiveness for years to come.
I’ve been working with D3Clarity since 2017. They've helped us migrate over our very first application from Azure to AWS and have been with us since. They have a very knowledgeable & professional staff that have helped us in our digital migration from our on-prem data centers to the AWS cloud.
D3Clarity provided us with invaluable insights, visualizations, topography maps and tools to help us make better decisions with our cloud infrastructure.
We selected D3Clarity to architect and migrate our Customer Services application to AWS and I can confidently say that their services are “top notch.”
D3Clarity went above and beyond. They are great to work with and create long lasting relationships!
Great partnership with D3Clarity!
D3Clarity’s experience with multiple MDM vendors, helped make the implementation a success.
D3Clarity was asked to help a very large client in the oil and gas industry with a digital data transformation
Assisted in the establishment of the Enterprise Data Governance Framework
Choosing the Right Master Data Management Platform