SUMMARY

Informatics Specialist and Software Developerwith extensive experience indata management and datasharing among various disciplineswithin healthcare organizations.Core competency inscientific database applications design with demonstrated experience in delivering enterprise level multi-tiered informatics solutions. Committed to delivering integrated decision support solution across the enterprise and specific departments including Development, Research, Commercial, Accounting and HR.

SKILLS

Programming: Java, C , C, Python, JDBC, ADO.NET, Hibernate, SQL, PL/SQL

Databases: Oracle, SQL Server, PostgreSQL

IDE: Eclipse, Visual Studio, JBoss Studio

Applications: AccelrysIsentris, Accelrys Compound Registration, Accelrys ELN, Accelrys Pipeline Pilot, IDBS ActivityBase, TIBCO Spotfire, TOAD, Subversion, Seapine, Bugzilla, Ant, Maven

EXPERIENCE

Confidential

Senior Informatics Engineer II

Provide support for database creation, loading and reporting of Clinical database content for managing multiple phase III trials. Created a processing program for Standard Accounting extracts from Concur application to be loaded into SAP. Designed and implemented an applications for HCP and HCO expense reports to produceFederal Aggregate Spend reports.Provided weekly automated Head Count Reports as requested by HR, IT and Accounting groups.

Confidential

Manager, Research Informatics

Provided informatics support to 100 Elan scientists in chemistry and biology departments. Led the design and development of database applications for biological and chemical entities. Providedcustomization, support and administration of commercial applications for compound registration and biological assay data capture. Assisted project leaders in their efforts to create weekly reports from various database contents.

• Designed highly usable customized chemistry electronic notebooktemplates for medicinal, process and analytical chemistry users that reached 100 adoptionin less than a month.Customization projects included the direct compound registration, reagent lookup, upload of analytical instrument raw files, and archival of experiment documents to SharePoint repository.
• Designed and implemented integrated applications for registration, inventory and process workflow for biological entities to fulfill migration of excel data to centralized Oracle database.
• Led the architectural team during the development of RISe Program suite for Biological/Chemical database applications for Proteins, Reagents, Antibodies, Cell Lines and Plasmids.
• Contributed in RISe biology applications user interface and functionality design and discussions to make these applications simple to use by presenting allowed data values instead of open text field.
• Created one-click project reports using Isentris SAR application features and Oracle views to present aggregatedassay data along with calculated compound properties savingover 4 hours of project leaders' time per week.
• Streamlined the integration of Chemistry and Biology datausing Oracle materialized views and optimized datasource configuration in Isentris applicationdrastically reducing work from 3 - 5 days to under an hour per assay.
• ProvidedDMPK dashboard inSpotfireWebPlayer application thatdynamically polled from the database, thusmaking the data availableto scientists in rich data analytics form immediately.
• Created an Isentrisdatasource from the ActivityBase XE's HTS assays allowing more efficient searching than tools provided by IDBS.
• Provided several iteration of ActivityBase XE custom Fit Validator to meet the needs of group of XE users saving time and consultant fees.
• Led the data transfer of compound registration system to theSymyx Registration database in less than 2 weeks instead of projected 6 - 10 weeks.
• Developed a chemical property calculation service within the Compound Registration system using Pipeline Pilot WebService allowing integration of third party calculators to be dynamically configured.

Confidential

Principal Scientific Programmer

• Developed the Isentris middle tier relational datasource implementation using JDBC to interact with Oracle and Sql Server databases. Relational datasource capabilities were extended beyond JDBC data access to include efficient implementations of list savings, list operations, recordset filtering, and clustering of recordsets.
• Implemented the Isentris client side recordsetswith resizable buffered data transfer from the server side eliminating many server round trips to make the data presented with smooth scrolling.
• Designed and developed several Isentris client UI code such as personal datasource archive and import operations and recordset clusters.

Advisory Scientific Programmer

• Led the compound Index database design and ETLtools. This large warehouse database provided single query access to disparate commercial chemical databases, a novel concept at the time.
• Led theReagent Selector server tier implementation and Concordance database design. Concordance database consolidates commercially available reagent database with customers' in-house reagents thus providing easy access to reagent information to its users.
• Developed the Server QA automation suite for testing ISIS on multiple platforms VMS, UNIX, NT making a single test script to be launched and results validated automatically saving many hours of tester time.

Senior Scientific Programmer

• Designed and implementedConformationally Flexible Searching. ISIS was one of the two commercial applications introducing the advanced 3D searching functionally when it was released in 1993.
• Development suite of API programs for server QA group testing the generic structure features in ISIS.