Data management services case study

Post-Merger Data Consolidation Reduces Reporting Time From Days to Minutes

Business needs fast access to consolidated data

One of the biggest challenges that arise when companies merge, is the merger of their data. Each company brings its own valuable data and each has its own systems for storing, managing, and reporting on this data.

Each of these systems will have its own way of defining a customer, naming a product, or calculating financial metrics. As a result, it won’t be long before the organization is frustrated by the time and effort it takes to get consolidated reports across all systems – perhaps daily sales or inventory for all products.

This was the challenge faced by Vyaire Medical, a global manufacturer and marketer of products for respiratory diagnostics, ventilation, airway management, and operative care consumables. After a series of acquisitions, the organization found itself with nine enterprise resource planning (ERP) systems, including SAP, Microsoft, and several other applications, some of which had been in production for at least 20 years.

“It was really difficult for the company to consolidate data from its many legacy systems,” said Ranjith Ramachandran, Wavicle big data lead.

“It would take two to three hours to create standard enterprise reports. Other reports could take five or six days of gathering data from the multiple systems and combining it manually using Excel spreadsheets. Clearly, this wasn’t sustainable. All areas of the business needed faster access to consolidated data for order management, sales analytics, inventory management, and accounts payable and receivable, to name a few.”

“Vyaire invited Wavicle to collaborate on a data strategy and architecture to aggregate and standardize the data from its many ERP systems,” Ramachandran continued.

“This is a global company with 27,000 unique products and a desire for near real-time consolidated data. The solution had to store and process massive volumes of data; move the data fast; translate multiple country languages; and standardize master data from all systems.”

Cloud data warehouse drives single view of data

Wavicle and Vyaire built a data warehouse using Amazon Redshift, AWS Lambda, Amazon QuickSight, Amazon S3, and Amazon Aurora on the Amazon Web Services (AWS) cloud platform. Along with data integration and orchestration using Talend, this solution gives Vyaire a massively scalable infrastructure that can quickly capture data from around the world, store it in a single location, and feed it to a single unified reporting platform. The solution synchronizes master data to ensure customers are defined and accounted for consistently across all data.

This three-month project has given Vyaire a single, consolidated view of its data from all ERP systems in a scalable environment that will easily and cost-effectively grow as the company and its data requirements grow. Standard reports and queries that used to take anywhere from 3 hours to 6 days, can now be completed within minutes.

“This is a global company with 27,000 unique products and a desire for near real-time consolidated data. The solution had to store and process massive volumes of data; move the data fast; translate multiple country languages; and standardize master data from all systems.“