Global Integration of Pre-clinical Chemistry and Biology Data – Challenges and Benefits.

1. Global Integration of Pre-clinical Chemistry and Biology Data – Challenges and Benefits. Jayne Cartmell Bowden, Ph.D. Global Program Manager Abbott Laboratories.

2. Overview • Discovery IT at Abbott - 1999 • Project deployment and timelines • Status details • Impact • TDB savings • TDB metrics • Lessons learned

3. Abbott Discovery IT - 1999 • Biologists, chemists or ‘Paper-shufflers’? • Frequent duplicate, manual entry of data -slow, tedious, error-prone. • Limited viewing and sharing of data. • Out-of date Structure-Activity Relationships. • Data scattered through-out Discovery • Lack of standard tools made data sharing a challenge… • Excel, 4D, Ark, Access, Word, Accord, etc.

4. Consultant Report • Tripos conducted IT analysis of Discovery data manipulation. • Abbott needed a system for projects to store and retrieve all project-related data… • …make project decisions wisely and quickly via ready access to accurate information. • Reduce ‘time-to-market’ and increase time under patent protection. • Reduce project costs via increased productivity. • Abbott would save between $1.25 MM and $10 MM per year if such a database system was in place.

5. “Integration”…. • ‘…a process in which separately produced components are combined…’

6. Integration of Discovery data • “In which assays has this compound/structure been run?” • Effective access to project compound information - structures, chemical properties and biological data is critical for productive drug discovery. Chemical Structure Chemical Properties Biology Data In vitro In vivo PK ADME

7. Requirements • Central, shared data repository. • Easy desktop access. • Creation of SARs including chemical structures and data. • Standard report generation by the scientists. • Data should be secure but not restricted. • Distinction made between published and unpublished data. • Storage of raw data avoids having to re-load data and provides data context. • Agreed on terminology. • Minimal customization. • Flexible – configurable by scientists.

8. Therapeutic Area Database (TDB) ISIS/Base Data Assay Explorer Reader Format Calculation Model Export ISIS forExcel Curve Fit

9. 1 2 3 4 5 6 7 8 9 10 11 Rollout Process and Timelines TDB rollout cycle (9 weeks) 2 Projects deployed in parallel (23 AP Projects in total) DEV PRD Requirements Development Test Final Train Train Go Live 1.5 days training for each scientist (detailed user manuals)

10. Global TDB Status • Abbott Park Deployment to all 23 projects complete (07/03) • Germany - Deployed October, 2002 • Massachusetts - Deployed March, 2003 • Support ramp-down and subsequent roll-outs on-going • Positive feedback from Discovery scientists… “…TDB is a huge time-saver…” “…far superior to our old database…” “…searching..is a huge improvement…”

11. TDB Impact • Automated data entry (= less error). • Updated data immediately accessible (= accurate). • On-the-fly generation of SAR tables (= current). • More time to focus on science. • Broadens scope of data review. • Facilitates research collaborations. • Allows Discovery executives to monitor progress. • Access to all Discovery data – globally. • Terminology and standards applied across all sites. • Data permanently accessible and understandable. • Ability to perform tasks not possible before TDB.

12. TDB Impact – Hard Savings • Estimate that IT support costs have been halved. • Scientists at AP were queried one month after TDB launch. • Based on 40 hour week, 48 weeks/year; on average, for one project, hours saved…

13. TDB Usage 2003

14. Lessons Learned • Ensure accurate and realistic scope verification. • Thorough user testing is critical. • Use realistic cost estimates. • Do not underestimate the requirement for detailed scientist training. • Take frequent ‘reality-checks’. • Effectively manage the scientists expectations and the importance of their role in the deployment process.

15. Factors that helped us • Executive support • TDB team dedication and work ethic • Scientific administrator • TDB team experience and knowledge • In-house trainers • Documentation • Support process • Scientists on board

16. Thank-you…. Abbott Park Albert Crescenzo (MDL) Brett Erkman Brian Devendorf Cynthia Collins Dan Mendro Devin Ridge Diana Pell (MDL) Eric Schaefer Faisal Waheed Jack Zhi John Burns (MDL) John Crary (MDL) John McCarthy (MDL) Julia Donavant Karunakar Chikoti Kelly Below (MDL) Kim Davis Larry Buchanan Leonard Sagalov Matt Gianni (MDL) Mike Edwards (MDL) Ron Delmendo (MDL) Subhash Nigam Zafar Ahmed Abbott Park - Sponsors Don Halbert Jim Summers Juergen Seega Randy Chen Bob Hogan MDL - Sponsors Bill Balke Debra Toburen Lars Barfod Mike Drake Roger Abraham Sara Bertsch Seth Pinsky Ludwigshafen Agnes Metanomski Alfred Stefan Gunther Stumpf Heinz-Peter Vogel Jonathan Bosley (MDL) Martine Heinrich Peter Gruener Peter Hellmann Susanne Buechler Tom Marron Uwe Christman Worcester Alan Williams Bill George Chris Sprangel Joanne Kamens Keith Glavin Keith Huss

17. Thank-you…. Chris Butler David Bacino Fernando Egea Gary Young Grace Chiou Jin Liu (MDL) Karen Alexander Manli Zheng Martin Markley Mike Karrmann Omar Kazi Ramesh Thangarajan Tom Brady (MDL) Kalyan Chintagunta