Microsoft Office (Excel, Word, Power Point, and Access), Visio, InstallShield, Clearcase and Dreamweaver

UNIX, Windows 95/98/NT/2000/XP, Linux

PL/SQL, SQL, HTML, JavaScript, PL/1

Oracle RDBMS V7, 8, 8i, 9i, and 10g

Oracle Application Web Server (OAS) 4, 9iAS, 10gAS

Oracle Forms 10g, 9i, 6i, 6.0, 5.0, 4.5, 3.0, Reports 10g, 9i, 6i, 6.0, 3.0, 2.5, Designer 9i, SQL*Plus, SQL*Loader, Toad, WebAlchemy, Oracle Portal 3.02, 9.04, HTMLDB

Project management. Excellent problem-solving, organization and leadership skills. Quick learner.

Project Lead

Senior Oracle Developer - Analyst

PL/SQL Programmer - Analyst

Oracle Portal Developer

Environment: PL/SQL; SQL; SQL*Plus; Oracle 9i, 10g; Oracle Forms 10g, 6i; 10gAS; Sun Solaris Unix; Windows XP; TOAD; Oracle Portal, HTMLDB; Oracle Reports 10g, 6i; Oracle Developer

• Designed and created an interface between custom application and accounting application, Summit.font>

• Mentored junior programmers in Oracle database design and development.

• Upgraded 6i client server Oracle Forms and Reports application to web based 10g and ran the application through Oracle Portal and Single Sign-on.

• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.

Environment: PL/SQL; SQL; SQL*Plus; Oracle 9i, 10g; TOAD; 9iAS; Sun Solaris Unix; Windows XP; Oracle Forms 10g, 6i; Oracle Reports 10g, 6i; Oracle Developer

• Wrote Advanced Queuing database package to send messages to clients based on events.

• Lead the upgrade process of Oracle Forms and Reports 6i to 10g including the setup of the 10g Oracle Development environment.

• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.

• Only developer for 3 different projects.

Environment: Oracle Forms 9i; Oracle Reports 9i; Oracle Developer; Designer 9i; PL/SQL; SQL; SQL*Plus; Oracle 9i; Sun Solaris Unix; Windows 2000; TOAD

• Member of the team that setup the project standards for development.

• Used Designer for design and database object generation.

• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.

• Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.

Environment: Oracle Forms 9i; Oracle Reports 9i; Oracle Developer; Designer 9i; PL/SQL; SQL; SQL*Plus; Oracle 9i; Sun Solaris Unix; Windows XP; TOAD; 9iAS; Oracle Workflow

• Generated Oracle Forms and database objects through Designer.

• Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application.

• Created Oracle Reports with Java Barcodes.

• Assisted in setting up the Forms and Reports Services on 9iAS.

• Documented business rules, functional and technical designs, test cases, and user guides.

• Lead the implementation of Oracle Workflow for processing applications.

Environment: Oracle Forms 6i; Oracle Reports 6i; Oracle Developer; PL/SQL; SQL;SQL*Plus; Oracle 8i; Sun Solaris Unix; Windows 2000; Clearcase; TOAD

• Developed PL/SQL packages for electronic Document Exchange Manager

• Designed, created and maintained Web-enabled Oracle Forms & Reports for NetWORKS Procurement.

• Generated SQL and PL/SQL scripts to install, create and drop Trading Exchange Connection database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.

• Troubleshooted performance issues and bugs within packages, forms, and reports using dbms_output, Forms debugger, explain plan and TKPROF.

• Documented business rules, functional and technical designs, test cases, and user guides.

Environment: Oracle Forms 3/6i; Oracle Reports 1.1/6i; PL/SQL; SQL; SQL*Plus; Oracle 7.3.4/9i; SQL*Loader; Sun Solaris Unix; Windows NT; TOAD

• Lead team of 6 through the development life cycle of an electronic interface to the Department of Justice for the processing of fingerprint information.

• The interface reduced the time to license a security guard from 2 months to a week.

• Required coordination with 3 different teams and migration into current licensing system (ATS) that itself was being upgraded.

• Developed Oracle Forms and Reports for the user interface; a data load using PL/SQL and SQL*Loader; and cron jobs calling Unix scripts to download and manipulate files.

• Upgraded Forms and Reports from 3.0/1.1 to 6i.

• Created documentation for all aspects of the project including training the end users.

Environment: Oracle Forms 4.5, 6, 6i; Oracle Reports 2.5, 6, 6i; Oracle Developer; PL/SQL; Web Toolkit; SQL; SQL*Loader; SQL*Plus; Oracle 7.3.4, 8, 8i; 9iAS; Unix; Windows NT; Oracle Portal; InstallShield; TOAD; Visio

• Lead in analysis and development of a foreign currency back-office system. The back-office included generating journal entries to be loaded into Oracle Financials; maintaining exchange rates, mark-up percentages and shipping costs; tracking inventory of multiple currencies and denominations for different locations; and several custom reports for invoicing, packing and auditing.

• Participated in the full software life cycle.

Environment: Oracle Portal, WebDB; PL/SQL Web Toolkit; SQL; SQL*Plus; Oracle 8;
Windows NT; Unix

• Created and implemented an intranet WebDB application for management on employee time and rates based on their Ceridian system.

• Development included using the security access from the Ceridian system on user login and different menus for different access levels.

• Effort also included development of stored packages with Oracle's Web Toolkit for creation of menus, security and data load pieces.

• Upgraded the WebDB application to Oracle Portal.

• Provided technical and user documentation.

Environment: Oracle Forms 5, 6; Oracle Reports 3, 6; Oracle Developer; PL/SQL; SQL;
Web Toolkit; SQL; SQL*Plus; HTML; JavaScript; WebAlchemy; Dreamweaver;
Oracle 7.3.4; OAS 4; Windows NT; Unix

• Upgraded, maintained and troubleshooted Oracle Forms and Reports.

• Oracle Reports were deployed in PDF format over the Internet for direct access by auto dealers throughout the United States on OAS using the PL/SQL cartridge. Oracle Forms created the back-end system for administrators.

• Development of PL/SQL and Web PL/SQL stored procedures. Also created Web PL/SQL stored procedures by creating Web pages through Dreamweaver and then used WebAlchemy to convert the HTML to PL/SQL.

Environment: Oracle Forms 4.5, 5; Oracle Reports 2.5, 3; Oracle Developer; PL/SQL;
SQL*Loader; SQL; SQL*Plus; Oracle 7.3.4; Windows NT; Unix

• Wrote the functional design requirements and performed custom development for the scheduling and golf management modules: accounting, inventory and property management.

• Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL.

• Analyzed, developed and maintained Oracle Forms and Reports for a newly designed General Merchandise Retail System.

• Designed coding specification and documentation.

• Technical lead Oracle programmer for training and task assignment for entry-level programmers.