Independent Consultant Resume Profile, FL - Hire IT People

Professional Strengths

Extensive COBOL and SQL experience as Developer and Conversion Analyst with DB2 and Oracle databases.

Work History

Self-employed Independent Consultant:

Confidential

Company

Developed ETL processes for large mainframe DB2 to DB2 application conversion using Business Objects Data Integrator. Wrote complex DB2 SQL queries as needed to support custom ETL processes.
Developed and tested financial reports using Windows hosted Oracle Data Warehouse and Business Objects WEBI.
Developed and tested a variety of inbound and outbound IBM mainframe batch data interfaces using COBOL with DB2 embedded SQL. Developed and unit tested JCLs to sequence batch processes.
Converted and unit tested Computer Assisted Collections System for Government CACS-G database with 180 tables and 237 COBOL batch programs from DB2 to Oracle. COBOL compiler used was Micro Focus Net Express targeting an Oracle database on an AIX platform.

Confidential

Company:

The following projects were implemented on i-Series AS/400 platforms targeting a PowerMHS claims system.
Implemented claims translation processes for X12 837 medical and hospital electronic files using the Extol integrator product.
Developed and tested AS400 CL procedures needed to automate the electronic claims translation and load processing. Developed COBOL programs and DB2 queries as needed to fix various claim file issues after translation to MHS proprietary file formats.
Implemented electronic translation processes for inbound and outbound X12 834 enrollment files using the Extol integrator product. Wrote COBOL programs and DB2 queries to create custom extracts for outbound enrollment files.
Developed Visual Basic application that used AS400 CL and DB2 stored procedure to query electronic claims.

Self-employed Independent Consultant: Confidential

Developed and enhanced COBOL applications on IBM mainframes and Windows NT servers.
Assisted in data mapping and converting legacy databases to relational databases. Conversions included CA/IDMS to DB2 VSAM to DB2, Unisys DMSII and DOS based databases to Oracle.
Performed name and address standardization and data scrubbing using MS Access and Visual Basic.
Wrote reports, scripts and loader scripts using Oracle SQL Plus and SQLLDR, DB2 and QMF, MS SQL Server and MS Access.
Developed PC applications using MS Access. Projects included Insurance Client Lookup System and General Ledger.
Developed web site for local Property Appraiser's office using Cold Fusion with search functions supported by a SQL Server database.