TECHNICAL SKILLS:

• PL/SQL - SQL*PLUS - Oracle 7i, 8i, 9i, 10g - Oracle
• Developer 2000 (Forms 4.5/6i, Reports 2.3/6i) - Oracle
• Forms 9i / Reports 9i - PL/SQL Developer / SQL Navigator - Brio / SQR - TOAD - UNIX
• Virtual Source Safe
• VAX/VMS - DCL - COBOL - RDB (RDO & SQL) - RMS - FMS -
• Utilities & Editors (CMS, EDT, TPU) - CorVision (I-Case tool) - Oracle d/b and Rapport-4 - SQLPLUS
• 370 Series - 4331 - Series 1 - DOS - DOS/VSE - TSO/ISPF - COBOL - RPGII - EDL - EDX
• ME29 - TME - COBOL
• Microsoft Office (Word, Excel, Access, Power Point)

EXPERIENCE:

Confidential, Phoenix, AZ

Technical Consultant

Responsibilities:

• Support of an Open Source Financial system ( Confidential ), both on and off-site.
• Confidential was developed by higher education facilities for higher education facilities.
• Help schools implement Confidential (KFS) and convert their legacy data to the KFS system.
• Using Oracle, SQL Developer, Pentaho Data Integration module (ETL).

Confidential, Phoenix, AZ

Contract Team Lead

Responsibilities:

• Production support of Returns Processing portion of the BRITS system being implemented by Confidential .
• Use Oracle Forms and reports, PL/SQL (Stored procedures, functions and triggers), T.O.A.D, SQL*PLUS, UNIX and COBOL. System was converted from Oracle9i to Oracle10g.
• Simple display forms and complex data entry forms were programmed and supported. Ad-hoc and formal reports were also implemented and supported.
• Developing minor enhancements and bug-fixes to the current system. Data from an existing legacy system was ported to the new system database..
• User support.
• Analyzing data input to the system. from external sources and analyzing the data converted from the legacy system for data integrity and translation from old codes to new codes. Also interpreting the legacy data to determine the meaning and creating the corresponding data in the new system.
• Writing PL/SQL scripts to correct bad data.
• Writing PL/SQL scripts to extract data for User interrogation.
• Analysis and documentation of User requirements.

Confidential, Phoenix, AZ

Responsibilities:

• Design, Development and Implementation of a payroll system utilizing Oracle database, Oracle Forms and Reports and PL/SQL. (stored procedures / functions, packages and triggers) SQL*PLUS, PL/SQL Developer.
• The data entry screens were mainly simple forms but there were a few which were very complex in operation.
• The reporting was mainly simple straight forward reports using Oracle reports.
• Converting data from Legacy COBOL system, using SQR (Brio) and SQL Loader.
• Interpretation and conversion of the legacy system data to create corresponding data in the new database.
• Subsequent maintenance of the implemented system, including troubleshooting, tuning and enhancing.
• System was converted from Oracle8i to Oracle10g and subsequently to Oracle11i.
• Responsible for User support - fixing and explaining modules.
• Assisting and advising junior contractors and permanent staff in their understanding of the system.

Confidential, St Louis, MO

Responsibilities:

• Maintenance and enhancement of a Marketing database and reporting system.
• Using Confidential ALPHA, OpenVMS, Cobol, PL/SQL, SQL Loader, SQL. TOAD.
• Updating COBOL programs with minor enhancements and bug fixes.
• Full life cycle documentation and support.

Confidential, Irvine, CA

Responsibilities:

• Maintenance and enhancement of a data warehouse database using Confidential ALPHA and VAX, OpenVMS, Cobol, PL/SQL, SQL Loader, SQL and Oracle Forms.
• Updating COBOL programs with enhancements and bug fixes, document the changes and full unit testing.

Confidential, Dallas-Fort Worth, TX

Responsibilities:

• Maintenance and enhancement of a billing system for directory listings on Confidential VAX, DEC ALPHA using COBOL, DCL and AMDOCS software.
• Microsoft Office.
• Liaising with AMDOCS staff regarding their software and how to use it.
• Update COBOL programs to include calls to AMDOCS.
• Document changes and fixes prior to implementation.

Confidential, Richardson, TX

Responsibilities:

• Maintenance programming and enhancement of a Margin Reporting and Shipments in Process Tracking systems on Confidential VAX equipment utilizing COBOL, SQLPLUS, PL/SQL and Oracle database.
• Confidential analysis, programming, testing, implementation and documentation of the above Legacy systems.

Oracle Developer

Confidential, Springdale, AR

Responsibilities:

• Maintenance programming and enhancement of a Sales History, Sales Accrual, Margin and Journal entry systems on a VAX platform, using COBOL, SQL, Rdb, CMS and DCL. Updating COBOL programs with minor enhancements and bug fixes also coding new COBOL programs with embedded SQL.
• Documentation of changes / new programs.

Confidential, Woodland Hills, CA

Responsibilities:

• Programming of a Medical Insurance Policyholder Bill Arrangement system, to provide a flexible and
• ‘User-friendly’ method of allowing customization of billing arrangements and details. COBOL, Rdb and SQL.

Confidential

Responsibilities:

• Designing, programming and Implementation of an Asset Management Plan Database to plan the next 20 years of scheduled maintenance to the Water Mains and Sewer systems utilising Confidential VAX, CorVision, SQL, Rdb and COBOL.
• Also provided the permanent staff with consultancy in their use of CorVision. Supervision of 3 members of staff (both contract and permanent).