John R. Crary

*** ****** *****, **** ******, IL *0047

847-***-****

aceky2@r.postjobfree.com

http://www.linkedin.com/in/johncrary

SUMMARY

Discovery informatics and analytics professional with extensive software and data management

expertise. Acting in various roles as a strategic analyst, technical lead, and developer for discovery

projects my career has focused on providing the user community with a variety of software

solutions to streamline their data management, analysis, and workflow operations. The scope of

this experience includes the full range of software lifecycle responsibilities from requirements,

system design, project management, quality assurance, and delivery of global software solutions.

This extensive experience has now been augmented Siebel (OBIEE) expertise having designed,

developed, and deployed a corporate orders-to-cash data warehouse for business analytics.

CRARY INFORMATION SOLUTIONS LLC Aug 2012 - Current

Independent data analytics and application developer service provider.

Data Workflow/Data Warehouse Developer

Developed scientific workflow applications using the Accelrys EKB/Pipeline Pilot software

for purposes of data collection of process parameter and generation of process reports.

Developed ETL solutions for data transfer into the EKB data mining solution.

Customized the EKB data mining solution to handle multi-dimensional data analysis

including complex graphics, multiple report formats, and a novel user interface to extend the

usability of the data mining solution.

FOLLETT SOFTWARE COMPANY, (McHenry, IL) 2010-2012

A provider of K-12 education software for managing school administration tasks and facilitating the

teacher/student relationship with new technologies.

Systems Analyst/Developer

Supported internal operations by designing, developing, and implementing a data warehouse

solution to replace their current outdated and maintenance intensive data reporting methodologies.

Developed and deployed a Siebel/Oracle Business Intelligence Enterprise Edition (OBIEE)

business analytics application by customizing the physical database, logical database, and

presentation layers to address corporate needs.

Developed and configured the Siebel/OBIEE Client Interface application for EBS

authentication, APEX for authorization, dashboard presentations, performance and variety

of screen displays.

Developed, tested, and deployed customized Informatica ETL data pipelines and workflows

to provide the underlying dimension data model required by the Siebel application.

Developed web-based registration/reporting applications using Oracle Application Express

(APEX) and BI Publisher to meet short term data management issues for internal clients.

Developed Excel VBA applications to provide for automated data entry and validation of

quota and budget data targeted for the data warehouse.

SYMYX TECHNOLOGIES, (Now Accelrys, Inc) 1990-2010

A software provider of scientific data management and workflow solutions to the pharmaceutical

industry, now part of Accelrys, Inc.

Principal Consultant

Provided strategic, technical, and software services to support the delivery of business critical

applications to the global pharmaceutical and chemical industries.

Provided technical leadership for a software development team, including outsourced code

developers, to deliver a time-critical registration system to the customer for on-schedule

deployment to their scientific user community.

Performed application programming with Visual Studio .NET C# and VB source code

development to facilitate assembly and on-time delivery of core applications.

Integrated application components and streamlined the downstream workflows between a

variety of in-house and third-party applications for delivery of a fully functional processes.

Aligned software products with customer requirements for a chemical registration system by

performing a functional gap analysis, risks evaluations, and then proposing technical

solutions to address the product limitations without adversely affecting the customer’s

expectations or the product infrastructures.

Developed and executed quality assurance programs for testing thick client and web-based

applications prior to delivery to the customers for deployment.

Designed, revised, and deployed Oracle databases in support of scientific application

development.

o Planned, implemented, and tested a variety of Oracle database solutions for use in

scientific applications including chemical informatics, biological informatics,

inventory, and workflow applications.

o Performed extensive development of Oracle SQL/PL to implement the target

database objectives to reduce application coding efforts, centralize data business

rules, and improve database structure for improved searching ability.

o Developed Oracle Row-Level Security systems for a variety of applications to

consolidate record security at the database level rather than in the application code

for improved modularity and reduced code complexity.

Worked as the project manager for delivery of several small projects including write-up of

the initial proposals, determination of project timetables, resource allocations, problem

management, delivery, and acceptance by the clients.

Produced administrative manuals, installation manuals, user manuals, end user training

courses, and application help files as part of the software deliverables for customer

satisfaction.

Senior Consultant

Responsible for the global data migration (ETL) of mission critical biological data from a

variety of data sources into a consolidated biological registration system including the

transfer of HTS, in vitro and in vivo assay data.

Successfully ran a team effort to designed, developed, and deployed sample and reagent

inventory systems as part of a chemical registration, biological registration, inventory, and

sample workflow application using VB 6 and C++, including storage of complex multi-

component formulations.

Designed, developed, and deployed java web-based application to replace a paper-based

submission process for sample analysis, after which the customer experienced a complete

ROI within one year after deployment of the application to their end user community.

G. D. SEARLE PHARMACEUTICALS 1982 - 1990

A Skokie, IL based pharmaceutical company acquired by Pfizer and dissolved as a business entity.

Analytical Chemist (Medicinal Chemistry)

Developed analytical HPLC methods for identification and purification of chemical entities.

Worked in support of synthetic chemists to purify chemicals and intermediates for potential

use as drug candidates.

Designed, proposed, built, and deployed automated preparative liquid chromatography

(PLC) systems to better facilitate process workflows and improve laboratory safety.

1976 – 1982

Archer-Daniels-Midland

A leading producer of agricultural products to the world.

Research Chemist (Carbohydrate Chemistry)

Performed general research on natural products, mostly carbohydrate chemistry.

Optimized chromatography methods to maximize the production of High-Fructose Corn

Syrups in the production plant operations.

Performed kinetic studies for Glucose Isomerase immobilized on DEAE Cellulose.

EDUCATION

M.S., Computer Science, 1988 – Illinois Institute of Technology

B.S., Chemistry and Biology minor, 1975 – St. Cloud State University

Contact this candidate