Systems analyst/ Sr. Developer

Start Date: 1997-01-01End Date: 1999-01-01

MAIN is a data warehouse consisting of various sub systems. • Created DB2 batch jobs and SQL loader for migrating data from mainframe DB2 to Oracle on HPUnix. migrating weekly 40GB data. • Responsible for the analysis, design, implementation and integration of a data reconciliation module between the data warehouse and the database on the IBM mainframe for the MIDB (Michigan information database). • Reduced the batch job running from 30 hours to four hours by using internal temporary tables.