A leading pharmaceutical company was facing data management and integration challenges with their serialized product tracking (SPT) data within the supply chain. The company stored the entire SPT data within SAP, and for operational efficiency they further bifurcated the data (as per the business verticals) and stored in three different systems within SAP namely,

For smooth serialization product tracking operations there is a need for a consolidated view of all the data residing in the above systems. Previously, due to the lack of such a view, the serialization manager, quality assurance manager, regulatory compliance manager and the supply chain manager manually monitored and checked the data from different SAP sources. This process was tedious and time consuming.


The stakeholders also required a consolidated report where they can track business and product information such as location, batch, lot status, transaction, serialization and regulatory events for reporting. Previously, the stakeholders manually downloaded data from the different SAP systems and consolidated using Microsoft excel. Due to the huge data load, this manual processing was tedious, and since these reports were not on demand, it took weeks to generate a single report. The vice president of the SPT team wanted to streamline data management and eliminated the manual data processing.

The company trusted i2e Consulting to design a datalake for all the SAP data sources, and integrate data as per specifications such as lot and batch size, product transaction events, serialized product information tracking, etc.

Our data experts examined the data sources, understood the client’s requirements and built a data lake that successfully consolidated the product tracking data from all three data sources into a single data lake.