The client is a world leader in life sciences solutions and laboratory instruments, operating across 65 worldwide locations. The organization has a rich history of acquisitions — both large and small — and has experienced recent hypergrowth due to increasing demand during the global pandemic.
The Challenge
With pandemic-induced hypergrowth, the client was challenged by large amounts of unstructured clinical and research data. Moreover, multiple acquisitions over the years had resulted in several data silos, leading to the creation of 70+ ERP instances for Analytics Instruments Group (AIG).
The Solution
The client wanted Persistent to help them consolidate data from multiple sources, including purchase orders, purchase orders receipt, and supplier invoices. Persistent’s solution focused on consolidating data from multiple ERPs to provide 360° view and insights using AWS S3-based Data Lake.
Persistent executed the consolidation in a strategic manner that included a common consolidation framework for 10+ ERP systems covering a $2 billion spending with a target to achieve $1 billion spent in the current fiscal year.
With Persistent’s support, the client could store, process, and analyze data in a central repository with a costeffective, secure, and scalable data lake. A data catalog was also developed to enable metadata discovery.
The Outcome
Consolidation of data from all ERPs ensured a single source of truth for the client. The implementation of a data lake enabled rapid data movement with the ability to ingest data from all sources quickly. The solution gave unprecedented flexibility to business owners and analysts who could now extract rich insights from data.
