.png)
Research-Driven Pharma Company
September 20th, 2024 WRITTEN BY Fresh Gravity Tags: data management, Life Sciences
Fresh Gravity was engaged to assess the client’s current implementation of Semarchy xDM-based Drug Brand and SKU Master. We helped downshift the client from a higher license tier of golden record count >500K to a lower license tier of sub 500K golden records. Additionally, we helped the client with a ~30% reduction in capital expenditure cost (license fee) and a ~50% reduction time required for on-going data loads to MDM from third-party data service providers.
Problem
The absence of an ETL tool for data ingestion led to the use of makeshift Canonical files manually curated by an operational service provider. The operational service provider created input data at a pre-defined frequency from third-party data sources procured by the client. Changes to the business transformation rules were very time-consuming and the system was prone to manual errors. Moreover, the non-hierarchical data model resulted in integrity constraint violations, such as a single Stock Keeping Unit (SKU) being mapped to multiple brands. There was duplication of master data leading to client’s paying increased license costs as Semarchy xDM licensing is based on count of golden data. Additionally, replicating the reporting structure required by downstream systems in the existing Master Data Management (MDM) system meant that any changes to the reporting structure required modifications to the data model in MDM, causing disruptions to exist data and requiring ongoing cleanup and maintenance.
Solution
Fresh Gravity assessed the existing implementation of client and recommended several key improvements. They proposed developing direct data pipelines between third-party source data using ETL tools such as Informatica to eliminate manual canonical file creation thus saving upto 50% time spent on manual data load. To support downstream, we recommended transforming the necessary data into a separate staging layer. In this setup, master data would feed into the staging layer. Master data fed staging layer and staging layer fed data to dashboards. Additionally, Semarchy Enrichers, web hooks, match merge rules were fine tuned for performance improvements and data model was optimized through use of minimal fuzzy entities and elimination of duplication of master data thus optimizing Semarchy license costs.
Impact
Capital expenditure on Semarchy license costs reduced. Earlier Semarchy license was tier 2 (Golden records >500K), Fresh Gravity helped reduce golden records to less than 500K thus downshifting to a lower tier of licensing costs. The turnaround was achieved through architectural revisions to the data model and the elimination of the downstream reporting data warehouse replica originally created in the master data management system.
We eliminated the downstream impact of inaccurate reporting thus enabling client’s C-suite to have an accurate view of the company product sales in different geographies. At the same time, downstream dashboard format changes did not require dashboard structure replicated in MDM anymore. This solution was made scalable for anticipated growth in future data volumes without the need for further IT investments or additional data stewards.
