toolbar - leftHomeLoginContacttoolbar - right

Bonex Data Systemss

Custom Software Development
Contact
Contact

Services >  Database Development >  Pharmacy Benefit Manager

Pharmacy Benefit Manager

Projections - Market Share Forecasting - Database Decision System:

  • MS SQL Server 2000.
  • 11 Databases and 220 Tables.
  • 1,400 stored procedures and 40 user defined functions.

RxPlorer - Database Management System:

  • MS SQL Server 2000.
  • 4 Databases and 1,500 Tables.
  • 800 stored procedures.

Teradata - scheduled process:

  • 1 DTS package - Teradata to MS SQL Server 2000.
  • 1 Database; 20 Tables with 40 million records.
  • 20 stored procedures.

Wizard - Data mining tool:

  • MS SQL Server 2000.
  • 4 stored procedures with 1,600 lines of code.
  • 83 input parameters.

Formulary - scheduled process:

  • MS SQL Server 2000.
  • Auto load 3 GB ASCII file every 24 hours.
  • 1 Database; 2 tables with 20 million records.

Cost Per Day Report - Crystal Report:

  • MS SQL Server 2000.
  • 1 stored procedure with 1,200 lines of code.
  • 34 input parameters.

IMS Health ASCII Data loader:

  • MS SQL Server 2000.
  • 1.4 GB input ASCII files on 2 CDs monthly.
  • 1 Database and 19 Tables.