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.