This project included the migration of data from flat files(VSAM) to a relational database (DB2) and from an operational data store to a data warehouse. It was conducted on behalf of a major pharmaceutical benefit management firm. The result contained the required business features and was used to improve the decision making of health care management firms. Areas of contribution include:

• Project Management
• Data Architecture, Modeling and Design
• Programming, Testing, and Documenting
• Using DBMS utilities to load and unload
• Using sort utilities to sort and select
• Tuning of database applications and queries
• Tuning of database structures (indexes, keys, storage, ...)
• Building a Control Process
• Training

Further database and file migration projects include:

• Using Industry Standard Integration Tools
• Creating Database Independent APIs and Applications
• Integrating Network Databases with Relational Databases
• from Hierarchical Databases to Relational Databases
• Migrating from File Systems to Relational Databases
• Migrating between SQL Databases (DB2, Oracle, Sybase, ODBC, ...)
• Modifying data while migrating (data cleaning, data scrubbing, data validating, data sampling, ...)

The following software is used to support these projects: XML, Data Modeling/CASE tools, Access, DB2, Informix, Interbase, Oracle, Sybase, DL/I, IMS, CA-DATACOM/DB, CA-IDMS, C, C+, COBOL, Delphi, PowerBuilder, OS/2, MS-DOS,MVS, UNIX, and Windows.