Skill Sets

Hardware/ Software: 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, Subversion, Open Source Kuali Financial Systems, Pentaho ETL tool, JaspersoftiReports
DEC: 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
IBM: 370 Series – 4331 - Series 1 – DOS - DOS/VSE - TSO/ISPF – COBOL - RPGII – EDL - EDX
ICL: ME29 – TME – COBOL
PC: Microsoft Office (Word, Excel, Access, Power Point)

Experience

Dec 2009 – Present Confidential, Phoenix, AZ
Permanent – Data & Integration Specialist

Support of an Open Source Financial system (Kuali), both on and off-site.Kuali was developed by higher education facilities for higher education facilities. Help schools implement Kuali (KFS) and convert their legacy data to the KFS system. Using Oracle 10g, PL/SQL, SQL Developer, Pentaho Data Integration module (ETL), MySQL, subversion.
Developing Oracle scripts to load the legacy data to the KFS system and Oracle views to facilitate the clients reporting requirements. Providing PL/SQL scripts to update client databases to the latest release of KFS. Providing clients with PL/SQL / SQL code to customize their use of the KFS product. PL/SQL scripts to identify problem / specific data that client is interested in. Report definitions in Jaspersoftireports. Testing scripts and reports to ensure that quality is being delivered to the clients.

Aug 2004 – November 2008 Confidential, Phoenix AZ
Contract Team Lead

Production support of Returns Processing portion of the BRITS system being implemented by Accenture.
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. Unit testing of these fixes and enhancements.
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.

Jul 2001 – Jun 2004 Confidential, Phoenix, AZ
Contract (Yoh IT)

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.
Unit testing system to ensure quality deliverables.
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.

Nov 2000 – Mar 2001 Confidential, St Louis, MO
Contract (Contractor’s Resources)

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

Mar 2000 – Nov 2000 Confidential, Irvine, CA
Contract (Contractor’s Resources)

Maintenance and enhancement of a data warehouse database using DEC 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.

Jul 1999 – Mar 2000 Confidential, Fort Worth, TX
Contract (ACSYS IT)

Maintenance and enhancement of a billing system for directory listings on DEC 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.

Aug 1997 – Jun 1999 Confidential, Richardson, TX
Contract (COMFORCE IT)

Maintenance programming and enhancement of a Margin Reporting and Shipments in Process Tracking systems on DEC VAX equipment utilizing COBOL, SQLPLUS, PL/SQL and Oracle database.
Y2K analysis, programming, testing, implementation and documentation of the above Legacy systems.
Some exposure to Oracle Developer 2000 (Forms 4.5 and Reports 2.3).
Minimum exposure to SAP FI and CO modules. Microsoft Office.

Aug 1995 – Aug 1997 Confidential, Springdale, AR
Contract (COMFORCE IT)

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.

Mar 1995 - Jul 1995 Confidential, Woodland Hills, CA
Contract (COMFORCE IT)

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.

Oct 1991 - Mar 1995 Confidential, Bradford, England
Contract

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 DEC 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).

Nov 1990 - Mar 1991 Confidential, Nigg, Scotland
Contract (Senior Analyst/Programmer )

Development and implementation of an Estimating Database, for Oil Rig construction parts.
DEC VAX, CorVision, SQL and Rdb.

Oct 1988 - Sep 1990 Confidential, Bristol, England
Consultant - Permanent

Various responsibilities from Consultancy, Project Management to programming, performed at User sites.
DEC VAX ,CorVision, SQL, Rdb, RMS and COBOL.

Oct 1987 - Sep 1988 Confidential, Widnes, England
Contract - Analyst/Programmer

Conversion and enhancement of an existing PDP based system to a DEC VAX environment utilisingCorVision and RMS.

Oct 1986 - Sep 1987 Confidential, Leamington Spa, England
Contract - Analyst/Programmer

Accounting system for Holiday package tour operator.
DEC VAX, CorVision, RMS and COBOL.

Jan 1985 - Sep 1986 Confidential, Edinburgh, Scotland
Contract - Analyst/Programmer

Accounting system using COBOL and RAPPORT-4 database.

Jul 1983 - Dec 1984 Confidential, Knutsford, England
Senior Analyst/Programmer - Permanent

Conversion and enhancement of an existing IBM based Accounting system on to a DEC VAX using COBOL, FMS and RMS. User liaison and training.

Oct 1981 - Jun 1983 Confidential, Peterborough, England
Systems Engineer - Permanent

Support and enhancement of the ICL COBOL version of UNIPAY (a payroll processing system).
IBM 4331, DOS/VSE, ICCF, VSAM and Assembler, ICL, ME29, TME, COBOL.

Apr 1975 - Sep 1981 Confidential, Huntingdon, England
Junior Operator / Analyst Programmer – Permanent

Development of Accounting; suite for pharmaceutical wholesalers.
IBM 370 series, DOS, DOS/VSE, VSAM, CICS, IBM Series 1, EDL, EDX, JCL.

Education

5 G.C.E. ‘O’ Levels United Kingdom
Technical Education:
Operations Supervision 1977
DEC RMS Design Concepts 1984
DEC RMS Advanced 1985
CorVision Fundamentals 1986
CorVision Intermediate 1987
DEC Rdb Internals 1988
Project Planning, Estimating and Control 1989
DEC VMS System Management 1989
DEC VAXSET Case Tools 1989
DEC Advanced Rdb Design Concepts 1991