CASE STUDY

Unlocking Customer Data for a Security Hardware Wholesaler

bannersolutions_hires_4c.633b47f8b7814

CLIENT:

Banner Solutions

EMPLOYEES:

250 - 499

INDUSTRIES:

Automotive
Construction

SERVICES:

Data Architecture Service
MDM Implementation Service
MDM Solution Support Service

PLATFORMS:

Master Data Management

DATA DOMAINS:

Customer

ABOUT:

Banner Solutions is a wholesaler of security hardware products for commercial, residential, access control and automotive applications. They are a one-stop shop for all door hardware, locking, access control products and other parts and accessories. Customers range from large retail enterprises to small locksmiths.

CHALLENGE:

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.

Questions?

Schedule a free call with a senior solution architect,
not a sales person, to answer questions,
provide a second option, or help you take the right next step.

SOLUTION:

What we delivered:

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.

How we delivered:

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.

D3Clarity conducted discovery workshops to flush out detailed requirements and priorities for the project.  This included defining the top 7 business use cases which were later expanded with testable scenarios for user acceptance testing. Within the confines of an Agile methodology, solution development occurred through an iterative and collaborative process. Project management cadences ensured all parties were working together, hurdles were unblocked, and priorities were defined for each functional sprint.

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.

 

 

RESULTS:

Deliverables:

Business Value:

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.

every size. every industry.

Recent Case Studies

TALK TECH WITH DATA DAVE
PODCAST

RECENT BLOG POSTS

Schedule a free meeting with an Expert.

Let's Talk.

An expert, not a sales person, will contact you quickly.
Usually in less than 20 minutes during business hours.

We will never sell, share or misuse your personal information.