Data Governance Case study – Medical Device Manufacturer
The Opportunity
Client, a medical device manufacturer, had attempted a formal Data Governance program using an Industry leading Tool. While the program, in their own words, had failed to get traction outside of IT, the team, including some of the shared services business functional leaders, were very knowledgeable about DG and what worked at the company and what didn’t.
Therefore their goal, as reiterated by the executive sponsor, was to build a good Data Governance operating model and use a new and sophisticated tool to aid in that process.
As mentioned above, they had already tried this once and there was a fatigue in the ranks about trying again. They had implemented a well-known DG tool as a standalone glossary repository. Without formal guidance and vision for Data Governance, this tool was pretty much unused except for some weekly extracts to feed data warehouse. All the business rules, DQ rules were maintained in ExcelTM, while all the policies and SOPs were maintained in a document repository
The Problem
PDM Strategy
The client had already kicked off a master data management program . This alone was enough a driver to get DG program off the ground if we could tie the two together, create dependencies and tie business drivers to them. We not only did that, but also used the functional integrations into data warehouse and larger analytics program to create a delivery plan that everyone can rally around.
We implemented the DGO operating model as well as the DG tool in parallel, using the tool to drive pieces of the DGO operating model ahead and cement them with business. Using leading practices, but tailored to this client’s needs, the list of deliverable was kept in tandem with MDM delivery. We started with business glossaries, and implemented many other data elements required to improve data discovery. We also integrated the DG tool into the enterprise architecture, from MDM till data warehouse to cover lineages.
PDM Solution
Product MDM Case study – A large Consumer Goods Manufacturer
The Opportunity
The client wanted to overhaul their Product Information Management (PIM) system to better manage their supplier parts as well as production. The current system was archaic and hard to integrate automatically not to mention they expected more catalog management features. Bottomline, they needed to streamline the PLM ops. They sought an industry leading MDM product.
Team working on this project focused on the MDM product and related standard flows. They implemented those flows very fast. But, after repeated test cycles, the solution did not meet the business expectations.
The Problem
PDM Strategy
I came in, and through my templated approaches asked probing Qs and analyzed the existing processes. Also, using our document templates I quickly created collateral that gave client IT executives as well as both business and IT teams confidence that we understood the business requirements.
I came back with a solution based on the already implemented MDM product and tweaked this solution to completely meet client requirements, rather than other way around.
“We worked with Lochan on an MDM implementation project and he was excellent. Extremely focused on identifying and documenting our project goals and then executing to those goals. He took the time to really understand what we needed from the software and then worked with our offshore team to design and implement the best solution for us in just a few months. Director, Product Development.”
Customer MDM Case study – High-tech Electronics Corporation
The Opportunity
The client is a $3 billion publicly listed company. They wanted to drive 2 objectives through customer MDM, lead to cash challenges and analytics.
Specifically, opportunity in operations was to tie MQLs to SALs, opportunities to sales orders, and improve sales compensation efficiencies. While the opportunity in analytics was around counting Net New Customers.
Company had recently come out of IPO, and still had a startup DNA that relied on heroes in each area to make sure that operations ran.
Analytics was siloed program with most reports supported by IT through Kanban, i.e. first-come-first-serve.
The Problem
PDM Strategy
I worked at the intersection of IT and business. First thing I did was to create a MDM steering committee and perform business discovery with its support and guidance. In few weeks we were ready with approved roadmap across operations and analytics.
In phase1 we connected Salesforce*1 CRM to Oracle*2 ERP through Informatica*3 MDM and leading practices for improving opportunity to cash (O2C) flow.
PDM Solution
MDM tool was used to aggregate for accounts netting against Dun & Bradstreet*4 to get Net New Customers.
We also fed MDM data into 3rd party SaaS analytics tool for clustering to create profiles
*1 About Salesforce: About Salesforce: Salesforce, the global CRM leader, empowers companies of every size and industry to digitally transform and create a 360° view of their customers. For more information about Salesforce (NYSE: CRM), visit: www.salesforce.com.
*2 About Oracle: Oracle offers integrated suites of applications plus secure, autonomous infrastructure in the Oracle Cloud. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.
*3 About Informatica: Informatica (NYSE: INFA), an Enterprise Cloud Data Management leader, brings data to life by empowering businesses to realize the transformative power of their most critical assets. We have pioneered a new category of software, the Informatica Intelligent Data Management Cloud™ (IDMC), powered by AI and an end-to-end data management platform that connects, manages and unifies data across any multi-cloud, hybrid system, democratizing data to modernize and advance their business strategies. Customers in more than 100 countries and 85 of the Fortune 100 rely on Informatica to drive data-led digital transformation. Informatica. Where data comes to life. For more information, visit www.informatica.com.
*4 About Dun & Bradstreet: Dun & Bradstreet helps companies around the world improve their business performance. The global leader in commercial data and analytics, we glean insight from data to enable our customers to connect with the prospects, suppliers, clients and partners that matter most. Since 1841, companies of every size rely on Dun & Bradstreet to help them manage risk and reveal opportunity.