Global Consulting ServicesInformatics Pick-n-Mix

Erin Bolstad

Consulting Team

Tim DudgeonHead of Global Consulting

Erin BolstadHead of US Consulting

Not the only faces….

ArgentinaDedicated consulting developers

USAConsultants

AppScisCzech Republic

Dedicated consulting developers

HungaryConsultants

AppScisDevelopers (100+)

Skills, Resources, Experience:

● Project Management● Solutions/packaging● Customizations/Integration of

existing/3rd party software● Rich scientific background● Software design and development

(Java, Groovy, JS, .NET, mobile, etc.)● Toolkit development (ETL, DSL, API,

ORM, etc)

Project Examples: Small to LargeShort

Long

Training: End-user, Dev, Admin

Custom forms/scripts Form/workflow migration + training

Cartridge/DB migrationMini-Reg

Mini-Reg

● Simple registration system handling chemistry (salts, structures,

batches, samples, properties) and biology (assays, aggregation at

db level) data

● IJC + customized forms and scripts

● All customizable/flexible

● (In about 10 companies now)

Project Examples: Small to LargeShort

Long

Training: End-user, Dev, Admin

Custom forms/scripts Form/workflow migration + training

Cartridge/DB migrationMini-Reg

Patent-mining workflow/tool development

Patent Mining Workflow

● Toolbase for extracting structures and relevant chemical text from

project-specific patents and putting into a relational DB.

● Query interface across linguistic based calculated information and

chemical structures.

● Semi-automated Markush extraction

● Exploring chemical space and potential enumerated white space

DuPont Doc2DB Database

● System to trawl DuPont ELN + stored documents (PDF, Doc, etc)

● WebApp for complex queries

● Based on Doc2DB technology

Project Examples: Small to LargeShort

Long

Training: End-user, Dev, Admin

Custom forms/scripts Form/workflow migration + training

Cartridge/DB migrationMini-Reg

Patent-mining workflow/tool development

SpotFire Integration

Project Examples: Small to LargeShort

Long

Training: End-user, Dev, Admin

Custom forms/scripts Form/workflow migration + training

Cartridge/DB migration

Basic SAR DB + access

Mini-Reg

Patent-mining workflow/tool development

European Lead Factory (E.L.F.) Novartis Reactions Database

SpotFire Integration

Novartis Reactions Database

● Reactions data warehouse

○ Import from various legacy databases (ISIS)

○ Live feed from CambridgeSoft ELN

● Database migration: ISIS -> ChemAxon

● CambridgeSoft ELN chemistry -> ChemAxon

● AJAX-style web application providing query and filtering capabilities

● Web services interface for fitting into SOA

Project Examples: Small to LargeShort

Long

Training: End-user, Dev, Admin

Custom forms/scripts Form/workflow migration + training

Cartridge/DB migration

Basic SAR DB + access

Mini-Reg

Patent-mining workflow/tool development

European Lead Factory (E.L.F.) Novartis Reactions Database

Large scale project management for global pharma

SpotFire Integration

Large Scale PM for Global Pharma

● GSK: IJC rollout as a global reporting tool, assisted/trained,

customization of IJC, additional admin software creation. (3+ yrs)

● BMS: IJC customization/development for global roll-out needs,

training, migration of data, consulting on data-mart integration. Thin

client development. (2+ yrs)

BINGO!

● Product development

● Product customization

● Product Integration

● Workflow design/management

● Project management

● Creative solutions