Integrating Clinical Research Data from Multiple Vendors and Sources into an Enterprise Data Warehouse Enabled Improved Clinical Research Analysis

Established in 1997, the client is a world leader in developing and commercializing first-or-best-in-class therapies for rare genetic diseases. Headquartered in California, US, the client has operations spread across 20+ countries and has 2500+ employees worldwide.

Background

The customer was collecting clinical research data from multiple sources and in various formats, which was making it difficult to integrate and analyze the data. This was leading to data inconsistencies and errors, which was compromising the accuracy and completeness of the study results. Hence, the customer conducted a due diligence exercise to determine the best mechanism to analyze the clinical research data received from multiple sources.

DiLytics’ Solution

DiLytics implemented a solution on Oracle Analytics that involved:

  • Extended EDW to create new tables and add columns to existing tables
  • Developed shell script to move data files from SFTP server location to Data Integration server so that extract, transform, and load process (ETL) can pick up the data from flat files for loading into EDW
  • Developed Data Integration layer using Informatica to extract clinical research data from flat files provided by the customer vendors into staging tables
  • Developed data validation logic to validate the data in the flat files provided by the customer vendors
  • Developed ETL code using Informatica to load clinical research data from the EDW staging tables into the designed data model
  • Collaborated with the customer in integrating data from EDW into Board

Business Benefits

Key business benefits to the client included:

  • Improved decision-making
  • Improved accuracy and completeness of clinical research data
  • Increased efficiency in the clinical research process
  • Superior competitive advantage due to improved collaboration among customer and clinical research data vendors

DiLytics Delivers

View all Success Stories →

Manufacturing Analytics

DiLytics implemented a Manufacturing Analytics solution for a Biotechnology Company in a short period of 100 days.

Enterprise Data Warehouse Implementation Enabled Better Business Performance

DiLytics implemented a custom data warehouse solution for a Leading Container Leasing Company in a short span of 150 days.

Center of Excellence

DiLytics established a Business Intelligence Center of Excellence to help a Video Game and Digital Entertainment Company maximize RoI.