SUMMARY

• Over 22 years of diverse Oracle experience designing, modeling, and developing full life cycle custom applications using Oracle database and tools, along with configuring, extending, and customizing Oracle E-Business Suite applications.
• U.S. citizen with an active Public Trust Clearance and an inactive DOD Secret Clearance.

EXPERIENCE

Confidential

• Assisted FDIC government personnel in gathering and analyzing the application requirements from the stakeholders and users.
• Designed entire logical and physical database models for all applications using Erwin Data Modeler R7 or ER Studio Data Architect V9.1 tools.
• Developed, coded, and tested all four applications using Oracle APEX 4.0 and 4.2.
• Created and edited all database objects, including tables, triggers, views, sequences and PL/SQL packages using SQL Workshop within Oracle APEX and Oracle SQL Developer.
• APEX development included data entry screens, classic and interactive reports, workflow management and processing of external data feeds from other FDIC applications into the APEX application.
• Assisted in documenting all applications, including scope, requirements, design, and test plan documents.

Confidential

• Perform maintenance work on ONR's main procurement application. Utilizes Oracle Web Forms V6i, PL/SQL, PL/SQL Web Toolkit, Oracle Applications Express V3.1 V4.0, and Oracle Workflow for customization and extension of the application.
• Designed and developed an intranet web application for the Acquisitions group that tracks the receiving and distribution of Award file folders from the ONR File Room. Application was built using Oracle Applications Express V3.1, Oracle PL/SQL, Oracle SQL Developer Data Modeler, and replaces an outdated Microsoft Access application.
• Designed and developed an intranet-based Contract Log Application for the ONR Office of General Counsel to track incoming and outgoing awards that are sent to the counsel office for legal review. Application was built using Oracle Applications Express V3.1, Oracle PL/SQL and replaces an outdated Microsoft Access application.
• Designed and developed a streamlined and intuitive custom application within Oracle Applications to replace the Project Contracts modules used by the ONR Science Technology business area's Program Officers.
• Participated in a full life-cycle implementation, configuration, and customization of an Oracle E-Business Suite application, including custom forms extensions and intricate workflow creation and administration during a three-year transition and deployment period. Utilized Oracle Web Forms V6i, PL/SQL, and Oracle Workflow for customization and extension of the application.
• Led the design and development of an Oracle Portal project that allows users to access all business applications and reporting tools through one website. Utilizes the Oracle 9iAS Portal Tool.
• Led the design and development for a Naval Science Award Program NSAP website. Allows users to register their science fairs to receive NSAP awards. Includes creation of administrative and reporting tools for administrative users. Utilizes Oracle's 9i Application Server and the PL/SQL Web Toolkit.
• Developed a ProposalWeb application that allows universities and institutions to prepare and submit their grant proposals to ONR via the web. Also allows Program Officers/evaluators to evaluate and process the proposals using their browsers. Utilizes J2EE component-based architecture, consisting of Java classes, Java Server pages, an ORACLE database, and more.
• Led the design and development for an AdminWeb Award Close-out application that allows performers and field offices to submit their final technical reports associated with an award via the web. Allows ONR's Program Officers to download and approve these reports from the web site. Utilizes the Oracle Application Server V 4.0.8 with the PL/SQL cartridge.
• Created several PL/SQL package modules to facilitate querying capabilities and on-line management reports for a Configuration Management Tool, utilizing the Oracle Application Server 3.0 4.0..
• Led the development team for the design, development and implementation of an application designed to accommodate purchases using credit cards by ONR personnel, utilizing Designer 2000, Developer 2000 Forms 5.0, Reports 3.0 , Oracle 8 database, and PL/SQL packages, procedures, functions, triggers .

Confidential

• Led the development of the Intellectual Property Management Information System IPMIS application used by all Navy legal offices that tracks the disclosure of inventions by entities universities, companies, etc. receiving grant money from the Navy. Complete life cycle project, utilizing Designer 2000, Developer 2000 Forms 4.5, Reports 2.5 , Oracle 7.3 database, and PL/SQL packages, procedures, functions, triggers . Accessed by remote sites through Citrix Winframe.
• Provided ADP analysis, design, process flows, entity relationship diagrams, functional diagrams and programming support necessary for the development and data standardization of the Integrated Naval Research Information System INRIS application. Complete life cycle project, utilizing Oracle's CASE Dictionary, CASE Designer, Oracle Forms 3.0 4.0, SQL Reportwriter 1.1, Oracle Reports 2.0, Developer 2000 Forms 4.5, Reports 2.5 , SQR Reporting Tool, Oracle 7.X, SQL Plus 3.X, PL/SQL 1.X 2.X.

Confidential

• Provided in-house technical support and overall system maintenance support, including software development on a Sequent S2000/250 client-server system.
• Programmed menu systems, data entry screens, reports, and data tables for the customer and in-house personnel using UNIX Korn shell scripts, ORACLE RDBMS 6.0 and its tools SQL Forms 3.0, SQL Menus 5.0, SQL Report, SQL Reportwriter 1.1, SQL Plus 3.0, PL/SQL 1.0, and SQL Loader.