They help people live a long and healthy life. One such Fortune 500 pharma company wanted to analyse the biomarker data and unmined clinical trial. Modak Analytics, along with a consultant team, undertook this transformation. There were many challenge:

1. Large amount of legacy trial data – The biopharmaceutical company had thousands of legacy datasets ranging from past 10 years to a constantly-growing set of new clinical trial data, to be integrated.
2. No schema alignment across the trial data – Each study had a unique set of datasets and variables which varied in therapeutic area and trial type. In addition, internal data standards had changed over time and had different implementations.

Modak's solution

Modak developed a system for integrating new studies that has already been standardized to SDTM (Study Data Tabulation Model) format. This helps to scale the larger number of legacy studies that could not be addressed and where ETL and statistical programming could not keep up. Modak combined machine learning and expert analytical tools to map legacy clinical trials to the master schema by :

• Automatically ingesting thousands of study datasets and associated metadata from SAS binary files
• Applying machine learning-guided mapping of source datasets to the custom standard implementation
• Providing a point-and-click user interface for simple and complex transformations (e.g. pivoting)
• Automatically generating documentation of all the mapping and transformations performed in the system
• Plugging data into an existing data loading pipeline after it had been aligned to a standard schema

Modak’s Novel approach of preparing data for downstream analytics enables scientists to access more data to make better, faster and accurate decisions. Moreover, it enables biopharmaceutical organizations to finally see a return on their enormous data investment.