Jennifer Wainner

**** * **** *** * Centennial, CO 80121 303-***-****

Education: Bachelor of Science, University of Oklahoma, 1986

Major: Software Engineer

Technical Summary:

Oracle Forms 3.0, 4.5, 6i

UNIX (SVR4/SVR3, SCO, HP, Sun OS, Solaris)

Oracle Reports 1.1.2, 2.0, 2.5, 5.0, 6i

Toad / SQL Navigator / SQL Developer

Oracle 6.0, 7.0, 8.0, 8i, 9i, 10g, 11g Perl/ORA*Perl

Oracle Apps 7, 8, 10.7, 11i, R12 HTML/XML

PL/SQL Java

SQL Visual Basic 4.0/5.0

Clearcase/Cleartool

Openscript and Java

Oracle’s Application Object Library (AOL) standards

Experience:

1/2002-7/2014 Senior Software Engineer, P2ES, Denver, CO

P2ES provides an integrated upstream oil and gas product using an Oracle database. I primarily work on the Regulatory

Reporting Project, which provides reporting for various states and federal agencies. PL/SQL packages extract the data from

multiple application tables and the end-user can modify the data using forms, or create paper/EDI/XML reports. Redesign

Regulatory Reporting module to use standard modules, make more efficient, and code for consistency.

Analyze/Create/Modify/Debug/Troubleshoot Forms 6i, Reports 6i, Packages using Oracle 8, 9, 10g, 11g.

Set up custom applications using Oracle’s Application Object Library standards.

Use Oracle Applications Coding Standards in Forms and Reports.

Create/Modify PL/SQL complex packages.

Use Cleartool (UNIX) for version control.

Perform performance tuning for Forms/Reports/Packages, clients have large tables in billions of rows.

Create/Modify tables, views, indexes.

Use Dynamic SQL processing in packages

Create PL/SQL Reports for EDI/XML reports.

Use Openscript and Java to create Autmated Testing scripts for regression testing of Oracle Applications.

Analyze/Design client requests for new reporting modules and modifications to existing modules. Prepare and write up

solutions and estimates.

8/2000-12/2001 Oracle Developer, Maxim Group, on contract to P2ES. Denver. CO

See description above

6/1998-8/2000 Software Engineer, TV Guide International, Littleton, CO

TV Guide provides Electronic Program Guides to Comcast Digital Cable Boxes. The system is used by millions of subscribers

365 days a year. System also provides a data entry system for entering TV Guide data. System is a multi-platform database

back end that shares data between Oracle and MSSQL.

Analyze/Create/Modify Forms 4.5, Reports 2.5, Packages using Oracle 7.3.4 on Windows NT and SUN OS Unix.

Used PL/SQL extensively using either Windows or UNIX system.

Performed all maintenance to procedures that transfer data between Oracle and MSSQL.

Performed design and implementation of enhancements and performance improvements.

Provided constant production support.

Department wide technical resource.

1/1989-6/1998 Senior Programmer/Analyst, Great West Life, Englewood, CO

Great West Life provides a variety of financial products including health, life, flexible benefits, and retirement accounts. I

primarily supported the health provider directories, the flexible benefits system, and Benlink, an online claims and eligibility

system.

Analyze/Create/Modify Forms 2.3 and 3.0, Reports 2.5 on Windows and SUN OS Unix.

Used PL/SQL extensively using either Windows or UNIX system.

Developed interface using PL/SQL and Perl/ORA*Perl to load/retrieve data to/from different Oracle instances for

Employee Benefits Booklet system.

Reworked PL/SQL code on eligibility system for scalability and performance.

For provider directories, used PL/SQL for Oracle back end, and Visual Basic 4.0/5.0 with Perl, ORA*Perl, and HTML

for front end interface.

For flexible benefits system, converted from a PC database to a IBM Mainframe Oracle environment. I later migrated

the system to Oracle 7.0 on Sun OS UNIX and converted interface to Forms 3.0

7/88-4/89 Programmer/Analyst, Vanguard Technologies, Wheatridge, CO

Vanguard provided consulting services to the Bureau of Land management at the Federal Center in Lakewood, CO. I worked

on the Finance and Payroll systems.

Participated in the conversion of the systems from one database to another, utilizing Oracle and COBOL.

Provided maintenance, enhancements and trouble shooting of systems after conversion.

8/87-7/88 Programmer/Analyst, UNIPAC, Aurora, CO

UNIPAC provided servicing for government student loans. I developed ad-hoc reports using COBOL on an IBM mainframe.

1/87-8/87 Contract Programmer, Kerr McGee, Oklahoma City, OK

Kerr McGee is an Oil and Gas company. I provided reports using COBOL on an IBM Mainframe.

Training: Oracle Performance Tuning

Visual Basic 5.0

HTML

XML

Perl

Platforms: Sun - Sun OS/Solaris

HP – UNIX

Windows 7

References and credentials available upon request.

Contact this candidate