Planning, Designing & Developing Data Warehouse & several Data Marts
A global healthcare, pharmaceutical and medical device manufacturer was in dire need to upgrade its data mart and BI to improve the efficiency and effectiveness of its clinical trials data management and meet the FDA regulation requirements. The firm also had to tackle multiple challenges in the process of capturing, storing and providing highly regulated access to adverse effects, efficacy and safety metrics.
Business Challenge
-
Analysts at the firm needed accurate, timely and secure access to highly sensitive operational and clinical trial information for operational reports as well as regulatory authorities submissions for product approval. Additionally, physicians participating in trials needed the capability to run mining algorithms to perform predictive, demographic, and trending analysis of patients participating in the clinical trials.
Technology Components
-
Oracle, Cognos and Informatica
Approach
-
Trianz consultants led the overall planning, architecture, design and development of the engagement to build a data warehouse and business intelligence program to meet these exacting requirements.
-
Trianz also constructed multiple, focused data marts during an aggressive four-month initiative that was delivered on-time and met the business requirements.
Transformational Effects
-
The solution has proven to be a model for other, similar efforts and is providing enormous benefits to the client to manage clinical trials effectively and efficiently.
