Case Study: Syneos Health cuts ETL and reporting time by over 90% with KPI Partners' Big Data and Analytics Solution

Syneos Health cuts ETL load time by over 90% with KPI Partners

Syneos Health, a multi-billion dollar biopharmaceutical solutions organization, faced significant performance issues processing large volumes of data from its Oracle EBS modules. Their traditional data warehouse and Informatica ETL processes were unable to handle the data load in a timely manner, and generating reports in OBIEE was slow. To overcome this challenge, they selected KPI Partners and their KPI Cloud Analytics solution through a rigorous RFP process.

KPI Partners delivered a comprehensive big data solution by migrating the data warehouse to an on-premise HDFS data lake and converting ETL code to Hive and then Scala. This optimized the ETL process, cutting load time by over 90%. KPI migrated over 150 reports from OBIEE to SAS Viya and Power BI, which reduced report execution time by more than 90% and improved the look and feel of reporting with self-service capabilities. The solution implemented by KPI Partners allowed Syneos Health to automate manual processes, improve data reliability, and discontinue support for Oracle BI Applications.

Syneos Health