Mercury Software Consulting


Welcome to Mercury Software Consulting, Inc.
Home About Us Solutions Services Case Studies Clients Contact
 
 
Pharmaceutical Business Intelligence

The following is a case study of the Business Intelligence, Data Warehouse implementation at a pharmaceutical company.

Business Need

The company was a pre-IPO startup and was conceived to RADICALLY transform the process of pharmaceutical development. They are dedicated to maximizing the value of pharmaceutical pipelines by using proprietary and revolutionary formulation technology platforms in drug formulation and chemical research.

The key functional areas identified for the BI implementation are Formulation Assay Systems Technology (FAST), CrystalMAX, CORE Data warehouse and ODS (Operational Data Store).

The ability to search not only by compound name and structure, but also by molecular descriptors and the ability to direct multiple experiments on multiple machines simultaneously have been identified as critical needs.

Business Value

The Business Intelligence System has helped The Company in the following manner:

  • Interact continuously with users at every stage of the experiment.
  • Each step will involve tracking.
  • All phases and results of any experiment will be tied together.
  • Graphical and Pictorial Analysis.
  • Experiments will also be searchable for similarity searches.
  • Historical Information will be stored in detail for each experimental process and result sets.
  • Experimental result data sets enabled for data mining.
  • Storage and searching by empirical formulas.
  • Storage of informatics analysis results and linking the results to original input data and allowing searches of the result sets.
  • Allow for differentiation between polymorphic structures and orientation.
  • Enhance data mining and analysis of experimental result sets.
  • Enable Knowledge Discovery through accurate data collection and data mining.
  • Data consolidation which reduced data redundancy and increased data quality.
  • Dramatic increases in productivity, particularly in the area of decision support and    analysis due to the more efficient data access methods and reduced data retrieval time.

Receive case study via email