Post-merger data consolidation reduces reporting time from days to minutes

Author: Wavicle Data Solutions

Following a series of acquisitions, Vyaire Medical turned to Wavicle Data Solutions for help consolidating data from nine ERP systems. We talked with Wavicle’s big data lead Ranjith Ramachandran to learn how a new cloud data architecture drives a holistic view of enterprise data and near real-time reporting.

 

One of the biggest challenges that arises 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,” Ramachandran explains.

 

“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.”

 

Wavicle and Vyaire built a data warehouse using Amazon Redshift 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 on 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 complete within minutes.

 

Watch our webinar to learn more about Vyaire’s journey to a data-driven business.

 

This blog was previously published in B2e Media’s Vyaire medical: technology intersection in the medical device market.