Oracle Application Developer Resume
Greenwood Village, CO
PROFESSIONAL STRENGTHS
PL/SQL Developer12 years, SQL 15 years, Oracle Reporting 6 years, Application Database Administration 3 years
TOOLS
Oracle Reports , DBVisualizer, SQL*Plus, Toad, Crystal Reports, SQL Developer, SQL Developer Modeler
Environment: PL/SQL development in Microsoft Windows and Database on Linux Server
PROFESSIONAL EXPERIENCE
Senior Software Engineer / Oracle Application Developer 1988 to 2009
I have 21 years development experience with an insurance corporate entity that transferred ownership four times - Confidential
Confidential, Senior Software Engineer, Greenwood Village, CO, April 2005 to November 2009
- PL/SQL programming includes using SQL in Oracle Packages, Procedures, Functions and Triggers.
- Insurance Rating System, PL/SQL application developer and acting Application DBA. Responsible for major data and database conversions for product releases using Oracle 11i database. Exporting and Importing database tables.
- Created XML result sets to for web application or XML files by using UTL_FILE utility in PL/SQL.
- Crystal Reports, Versions 11 and 10
Confidential, Denver, CO, July 2000 to April 2005
- Technical lead in Denver for the retirement, conversion and integration of a subsidiary’s Claims processing system of team of 4 other developers.
- Technical lead and programmer in Denver for the integration of a Premium processing system into parent company’s Premium processing system.
- Provided technical leadership, expertise and mentoring through entire life cycle of application design and development utilizing ORACLE Designer and Developer 2000. Applications were developed on Windows NT, and production applications ran on a DEC ALPHA machine. 1997 to 2005
Confidential, Englewood, CO, December 1999 to July 2000
- Technical lead and programmer in Denver for the integration of a Premium processing system into parent company’s Premium processing system.
Confidential, Englewood, CO, July 1998 to December 1999 and
Confidential, Englewood, CO, December 1988 to July 1998
Environment: Development in Microsoft Windows and Database on UNIX Server
- PL/SQL and SQL. Developed stored objects: packages, procedures and functions.
- ORACLE REPORTS 6.0 and 2.5 in Windows and UNIX, Since 1996
Developed reports with multiple level groups and linked queries. Developed sophisticated Parameter Forms and SQL to provide customers optimum reporting capabilities. Utilized Parameter Lists variables passed from Oracle Forms within Parameter Forms, Report Triggers, SQL and Report Layout fields. Developed Unix ORACLE REPORTS and Korn shell scripts to launch the report from UNIX crontab scheduler. - Oracle Designer 6.0, Since January 2000 and Oracle Designer 1.3, July 1997
- Created and maintained database entities and relationships. Created and maintained logical and physical tables.
- Utilized PL/SQL and SQL in Form Triggers and Named Routines. Forms and Menu generation.
- ORACLE FORMS, Since June 1997
Utilized PL/SQL and SQL in Form Triggers and Named Routines. - Created Parameter Lists for Oracle Reports called by Run Product utility.
- FoxPro 2.6, SQL
- Architect and lead developer of a policy issuance system used nationwide by 75 Managing General Agencies.
- Created and maintained a California private passenger insurance premium processing system.
- Image System project, Systems Manager of Digital Equipment Corporation and Kodak Image system.
- COBOL, Maintained batch and TP programs, Honeywell/Bull mainframe.
Confidential, Denver, CO, June. 1983-December 1988
- BASIC programming and System Manager
EDUCATION
C#, UNIX, ORACLE Designer Forms Generation, ORACLE Package programming, ORACLE SQL Tuning, ORACLE Reports 2.5, ORACLE PL/SQL courses
Several courses from Digital Equipment Corporation, 1990 to 1991
C programming classes, Beginning, Intermediate and Advanced, Confidential of Denver, 1990
Bachelor of Science, Computer Based Information Systems,Confidential, Boulder Colorado