Pharmaceuticals CASE STUDIES

Application Development for Robust Analytics on Data

stethoscope syntelli solutions inc
Syntelli’s team designed an application to provide payers with robust analytics on data contained in the client’s Reimbursement Manager system.


A large Fortune 20 U.S. pharmaceutical distributor

Business Need:

Enhance company’s Explore product built on Spotfire and develop Contract Modeling content using TIBCO Spotfire. The application is being designed to provide payers with robust analytics on data contained in our Reimbursement Manager system.

  • There is currently not a uniform and time efficient method for displaying medical claim information and quoting different claim rates.
  • The data collected is not modeled in any schema and needs to be modeled.
  • Syntelli team created data models, data extracts, data transformations, and information links to load the data into Spotfire
  • Created Interactive dashboards to display and quote insurance claim rates
  • Integrate Spotfire dashboards with the product website for same look and feel
  • Created dynamic price comparison dashboards that allowed users to compare various rate schedules real-time
  • Created tool tips, pop outs to show drill down information
Value Added:
  • Tool for team to quickly and accurately display insurance claim information and quote rates
  • Fully monetize-able product to sell to customers
  • Modeled data will be easier to access when using it and will allow for the creation of complex reporting views

TIBCO Spotfire 7.0, Oracle DB, R, TERR

Become our next Success Story