Using RealTime Watson LIMS Data Integration and Analytics

Using Real-Time Watson LIMS Data Integration and Analytics to Monitor Data Quality and Productivity, An Application of the Business Integration Program in the Bioanalytical Lab Ann Hoffman, Business Development Director Shane Needham, Ph. D. Co-Founder and Laboratory Director Alturas Analytics, Inc.

Streamlining: Manual Information Transfers within Laboratory Operations RFP & Quotation generation is disconnected from lab operations Knowledge of sample shipment schedules Lab Start Lab managed with 15 -20 spreadsheets & individual databases Key resource decisions rely on manually generated project updates Difficult to forecast backlog or revenue No real-time performance indicators to proactively identify risk Lab End Project managers and lab operations staff spend time manually gathering information for tracking, analyzing, and reporting QC Data No project triggers from completion of analysis to QC and QA data QA Data Revenue Recognition & Billing timing Issues Client status updates, primarily using static data which are manually re-entered Draft Report Extreme administrative burden on highest paid staff (Ph. D level) Reprioritizing reports to meet timeline commitments Timely sample disposition/ storage notice difficult to track . Redundancy throughout the operation results in decreased efficiency and increase to overall timelines

CRM – KEY DATA INPUT AND FLOW

INFORMATION SHARING: FROM CRM TO OPERATIONS Master Schedule Project Management Services and Pricing Schedules Assay List (Test Methods) Laboratory Supplies Protocol (timelines, study design) Sample Management Receipt, Archive, Disposition Quality Assurance Reference Standards CRM (Business) Proposal Generation Contract Full Execution Shipment, Timelines, Terms Finance (Quickbooks) Invoicing Projections MSAs, CDAs Conferences Equipment Inventory

OBJECTIVES: ü Database integration across all functions ü Eliminate Redundancy ü Information sharing ü Data accessible in a single location ü All critical steps contain triggers and notifications ü Resource allocation scheduling ü Target timeline w/ alerts ü Expiration alerts ü Generation of metrics, summaries, reports ü Accurate projections for planning the future Executive Management Facilities Management, QC, IT, Archives Report Writing Project Management Quality Assurance Finance Invoicing Projections Sample Management

Alturas Laboratory -Manages timelines for data delivery Interface -Interfaces with Watson for real-time data Communications-Internal and external communications Equipment -Tracks maintenance and calibration of equipment

Laboratory Interface Communications

Assay/Test Method List

SOUP NUTS SIMPLIFICATION OF BIOA DATA, PROJECT AND COMMUNICATION MAN

ACKNOWLEDGEMENTS Those on ALICE Team at Alturas § Bo Cheng, Cindy Barnhart, Heidi Schmuck, Jennifer Zimmer, Lawrie Malsack, Ann Hoffman Metrendalytics – Jan Miotto