About Client:

One of the world's largest providers of biopharmaceutical development and commercial outsourcing services, focused primarily on Phase I-IV clinical trials and associated laboratory and analytical services, including consulting services.

The Challenge:

Currently the client offers limited reporting functionality by each study independently, requires users to access several different in-app locations to export reports by module, and often requires more time & effort from PS or Dev to gain additional insights when current reporting is unable to answer questions. By centralizing an analytical solution, sponsors will efficiently gain insights to all their studies on the same report, consume information from dashboards, and reduce the time required to get answers.

Why AWS:

AWS was a go-to choice for the client because they already have an AWS ecosystem, as their entire clinical operations suite is built using Ruby on Rails application running on Amazon EC2 instances and Amazon Aurora databases as the backend. The analytical solution built also integrates easily with their existing suite of Amazon Web Services. The below figure demonstrates the centralized analytical solution on AWS.

The Benefits:

AWS Glue provides the client with the flexibility to focus on the data model, data transformation logic in the data pipelines, error handling, and scheduling in a managed service that runs on a serverless Apache Spark environment. This allowed the team to not worry about configuring and managing the underlying compute resources.

Amazon Redshift reporting infrastructure enables uniform standards for data across all TDSE modules which provided a single point of data access for integration to the customer’s internal systems such as CTMS, thus decreasing time/effort for integrations. Furthermore significantly eliminating the need for manual data entry and quality risk associated with entry errors.

Amazon Quicksight: decreases TDSE development and Professional Services staff time spent on building/creating reports, improves customer ability to monitor, study, deliver, and generate data-driven insights based on access to near real-time cross-trial and cross-module reports, and enables TDSE executives to demonstrate the value of client solutions in support of competitive positioning, marketing, and sales.

Disclaimer: Workload Type: Dev/Test