In this project we implemented a collection of interactive data capture and analysis workflows for a DMPK team at a pharma company.
Our Client had centralized plate inventory, chemical and assay registration databases already in place. The DMPK team needed to preprocess their assay results through multiple steps of data capture, reformatting and reconciliation in order to finally upload into a LIMS used to store and share the results with the rest of the R&D organization. A panel of assays was being run weekly thus providing a basis for a repeatable data capture workflow.
Practice makes perfect
Saber Informatics worked with DMPK scientists to determine a repeatable sequence of steps to be connected into data capture / analytics workflows. To get it right, we had to iterate a number of times and finally built an optimized application that we implemented as a collection of interactive webpages for the different workflows, logically linked together through a single home screen. During data capture and analysis the application in real time retrieves annotation information from multiple corporate databases, transforming the data into a format that is readily uploaded into an existing LIMS to be shared with other teams.
Attention to data quality translates into reliable results
Throughout the data workflows scientists have printable PDF and Excel reports available for review at every step of the process. Updated Control Charts are also automatically generated in real time for every DMPK assay to help QC results in a consistent, objective, and meaningful manner. Since control charts are delivered as a centralized webservice the most recent information is always at hand no matter who runs an assay and where.
As a result of this project the DMPK team have been able to increase their productivity while also markedly improving the quality of results reported to the rest of the R&D organization. Step-by-step data analytics reports and historical control charts help deliver results that are consistent, defensible, and reliable.
