In a phased approach, Nagarro created a solution to help the drug safety group meet its needs. First, Nagarro developed a web based application to generate study level tables on summary and individual data from toxicity studies. ETL tools were used to build the data warehouse from backend LIMS systems. The solution enabled data extraction, statistical analysis using SAS, data summarization, and report generation. Further, the system was compliant with all 21 CFR Part 11 requirements including data backup archival and retention, audit trail for changes, data security, and data retrieval.
The next phase of development allowed for cross-study tabulated summaries to be created by users. In addition, development allowed the system to have the flexibility of ad-hoc report generation and enabled users to further analyze the data at various levels of detail and granularity. Finally, to keep the client ahead of the curve, Nagarro added XML exports into the system, which can be use for future eCTD submissions.