Data base design activities were accomplished in Microsoft SQLServer, MS Access, Sybase, Informix, and Oracle systems. SQLServer was used in a comprehensive call center application. The application integrated customer inquiry information with account information extracted from IBM and Unisys legacy systems. The data base then drove the completion of the customer’s requests for new accounts or changes to status.

Another SqlServer data base handled safe deposit accounts and transactions such as annual billing and profit planning. New functionality was developed in MS Access and then converted to SQLServer through Erwin or other translation products.

Informix was used as the data base for a branch automation application. The data base accepted transactions through DEC Pathworks, and passed these on to legacy systems as parced transactions which would be not be rejected by an edit, as the hand-written predecessor transactions often were.

Oracle data base activity consisted mainly of extracts for data warehouse applications, with some development using Designer 2000.

Access database development, across many generations of the product (version 1.0, 2.0, and 6.0) performed complex data storage, data extract, and reporting for Home Mortgage systems. The data base served about 60 users for extract, and 6 for data entry, that tracked mortgage processing through the stages from initiation, inspection, appraisal, legal tracking, and the other steps in a reengineering of the traditional hand-off of physical documents. Processing steps were reduced from 80 to 12, while closing time decreased and staff utilization improved.

In order to determine if we can help you with your data base issues, please consult the attached resume, or request additional information using the links below: