Addressing Customer Data Challenges for Global Leader in Paints and Coatings

To achieve this organization’s desired results in a sustainable, repeatable, scalable, and long-term supportable manner, D3Clarity used an agile, use-case-focused approach.

• Use cases were established based on integration sources and business needs.

Solving the requirement for a turnkey solution that facilitates the alignment of business operations at a global level based on a trusted, consistent set of customer data, the implementation was performed within D3Clarity’s Data Management as a Service construct.

• D3Clarity provided a hosted environment that can scale on demand as the client’s volume increases and was designed for maximum security.
• Installation, implementation, and continued hyper-care support were performed by D3Clarity MDM experts.
• Integration access points were established for data transactions between source systems and the MDM-hosted platform.

D3Clarity conducted a 6-week Discovery phase to define and understand the phase 1 requirements to make critical decisions for the initial configuration and overall project impact. The goal was not to have every detailed requirement outlined but to have the initial alignment of pain points, use cases, and strategic advisory group cadences.

• D3Clarity provided a roadmap of the project phases including key activities with their start and end dates, assigned resources and dependencies between tasks, and project milestones/sprints. This project plan was reviewed by the combined project team and published to stakeholders monthly. This allowed the combined project teams to have insights into dependencies, data gaps, key milestones, and overall project deliverables and status.

Utilizing robust data modeling capabilities, a unified data model was created that represented a person and organization record object and supported complex and dynamic queries. Relationship modeling enabled data users to perform hierarchical rollups based on the necessary view they needed.

• Survivorship rules were configured to identify potential customer duplicates from the multiple ERP source systems and create a consolidated view across all customer data.

As part of the comprehensive solution, a suite of flexible workflows was developed to seamlessly accommodate various customer data operations, including updates, deletes, and an approval process for changes. User-friendly UI forms were meticulously designed, prioritizing efficient ease of use and data manipulation, empowering data stewards to manage and maintain data with ease.

• During the implementation phase, an innovative approach allowed business users to access and review their data in real-time within a live environment. This capability enabled them to actively participate in the cleansing, organization, and structuring of data, ensuring it became coherent and actionable across multiple entities and diverse use cases.

Integration pipelines were established to facilitate the smooth and secure flow of data in and out of the MDM system, enhancing data accessibility and interoperability across the organization.

• These pipelines also ensured the secure transfer of data, safeguarding sensitive information.

In harnessing D3Clarity’s Solution Support Services, this valued customer secured a steadfast partner as they pursue other initiatives on their journey towards mastering their data landscape.

• With ongoing access to MDM subject matter expertise, they are primed for future initiatives that will drive efficiency and innovation.
• Maintenance support for the customer solution and enhancement services ensure that their data management ecosystem remains robust, adaptable, and capable of meeting the evolving needs of their organization.