SUMMARY:

• I have had over 40 years Oracle Applications implementation experience with technical knowledge of Oracle Applications in Releases 7 through 12.2.5.
• Experience in development team management
• Strong experience in Oracle database design and implementation
• Expertise in many Oracle Application modules
• Preparation of migration documents
• Advanced PL/SQL, C, Pascal and UNIX scripting programming skills
• Written many interfaces between non - Oracle and Oracle Applications using Oracle Application Programming Interfaces (API)
• Expertise in Oracle Forms (FMB)
• Experience in developing reports using Oracle Report Builder (RDF)
• Expertise in developing BI Publisher (XML Publisher) reports
• Experience in Oracle Forms customization and enhancements
• Debugging PL/SQL Scripts and UNIX Shell Scripts
• Strong in writing the SQL queries and optimizing SQL queries
• Interacting with the users to understand the requirements and design strong business solutions
• Developed various critical business processes
• Global Business experience in United States, Taiwan and China

TECHNICAL SKILLS:

Operating Systems: HPUX 9 - 11, SunOS 4.1.3, Linux x86-64 - OS Version Oracle Linux 5

Developmental Software Tools: Oracle Database versions 6 through 12c, SQL*Plus, PL/SQL, SQL*Loader, Oracle Pro*C, Oracle Forms 2.3 through 10g, Oracle Menu 5.0, Oracle Reports 2.5 through 10g, SQL*Navigator and Toad, Java 2, J2EE, Bourne, Korn, and C Shells, Pascal

Oracle Applications Experience: Applications DBA (AD), Common Modules - AK (AK), Alert (ALR), Payables (AP), Receivables (AR), Application Utilities (AU), Bills of Material (BOM), Cash Management (CE), Cost Management (CST), Enterprise Asset Management (EAM), Advanced Product Catalog (EGO), Application Object Library (FND), General Ledger (GL), Process Manufacturing (GMA, GMD, GME, GMF, GMI, GML), Inventory (INV), Manufacturing (MFG), Assets (OFA), Order Management (ONT), Human Resources (PER), Purchasing (PO), Quality (QA), Advanced Pricing (QP), System Administration (SYSADMIN), Work in Process (WIP), Shipping Execution (WSH), Shop Floor Management (WSM), XML Publisher (XDO)

PROFESSIONAL EXPERIENCE:

Confidential, Forest Grove, OR

Responsibilities:

• Shop Floor Management (WSM)
• Discrete manufacturing (WIP)
• Quality (QA)
• Inventory (INV)
• Advanced Product Catalog (EGO)
• Technologies used:
• Quest Toad - 12.10.0.30
• Oracle Applications - 12.2.5
• Oracle 12c database - 12.1.0.2.0
• Oracle Forms 10g - 10.1.2.0.2
• BI Publisher - 10.1.3.4.2
• JDeveloper - 11.1.2.1.0

Confidential, Tigard OR

Responsibilities:

• Oracle Module:
• General Ledger (GL)
• Inventory (INV)
• Cash management (CE)
• Accounts Payable (AP)
• Technologies used:
• Quest Toad though version 10.6.1.3
• Oracle Applications version 11.5.10
• Oracle 10g r2 database
• Oracle Forms 6i
• BI Publisher

Confidential, Portland OR

Responsibilities:

• Oracle Module:
• Cash Management (CE)
• Technologies used:
• Quest Toad though version 10.5.0.41
• Oracle Applications version 11.5.10
• Oracle 10g r2 database
• BI Publisher

Confidential, Vancouver WA

Senior Developer

Responsibilities:

• Enterprise Asset management (EAM)
• Trading Community Architecture (TCA)
• Accounts Receivables (AR)
• Human Resources (PER)
• Technologies used:
• Quest Toad though version 10.5.1.3
• Oracle Applications version 12.0.4
• Oracle 10g r2 database
• BI Publisher

Confidential

Senior Developer

Responsibilities:

• Technologies used:
• SYBASE PowerBuilder version 6.5
• Quest Toad though version 9.6.1
• Oracle 8i database

Confidential

Senior Developer

Responsibilities:

• Advanced Product Catalog (EGO), Order Management (ONT), Shipping (WSH), Inventory (INV), Advanced Pricing (QP), Human Resources (PER)
• Technologies used:
• Oracle 10g R2 database
• PL/SQL
• SQL*Plus
• Quest Toad though version 9.6.1
• Oracle Reports
• BI Publisher

Confidential, Vancouver WA

Technical Lead Developer

Responsibilities:

• Designed and created reports and interfaces involving Oracle Applications version 11.5.10 using the modules:
• ONT, WSH, INV
• Technologies used:
• Oracle 10g R2 database
• Oracle 6i Reports, data model and layout
• Korn Shell
• PL/SQL
• SQL*Plus
• Quest Toad though version 9.6.1
• SQL*Navigator through version 5.5.2

Confidential

Software Development Engineer IV

Responsibilities:

• Designed and created over 90 Oracle reports, forms and interfaces for Oracle Applications version 11.5.10 using the modules:
• ALR, AP, AR, CST, EGO, FND, INV, OE, ONT, PO, WIP, WSH, XDO
• Technologies used:
• Discoverer version 10.1.2 Admin, Desktop and Viewer
• Optio Label and Barcoding Software
• Oracle Forms Personalizations
• Oracle 10g R2 database
• Oracle 6i Forms
• Oracle 6i Reports, data model and layout
• Oracle 6i Reports, data model and XML Publisher layout
• PL/SQL
• Interface between Oracle and legacy systems using PL/SQL calling Oracle APIs and open interfaces.
• Quest Toad though version 9.6.1
• Oracle SQL Developer 1.5.3

Confidential, Albany

Programming Manager

Responsibilities:

• Programming supervisor and Oracle mentor in charge of four staff members and contractors as required.
• Designed and developed reporting systems and forms personalizations for Oracle Process Manufacturing (OPM) system.
• Designed and implemented legacy data to OPM data conversion interfaces and initial data loads using Oracle PL/SQL and Oracle Application Program Interfaces (API).
• Created denormalized views of OPM data and Oracle PL/SQL packaged functions to enforce reporting consistency and reduce programming maintenance efforts.
• Designed and implemented robust interface between Laboratory Information Management System (LIMS) and Quality portion of OPM.
• Designed and implemented a Cold Fusion front end / Oracle back end product Generation System (CGS) that combines information from several disparate systems into XML and PDF files documenting quality and purity of product. Enhanced system to automatically extract LIMS data for use in CGS documents.
• Designed and implemented several custom applications. Most recently converted my legacy Computer Aided Ingot Generation System (CAIGS), a metals alloy blending system, to an Oracle Forms 6i-based application of my database design using Oracle Forms 6i. Also interfaced OPM inventory data and LIMS chemistry data with CAIGS.
• Aided in the conversion of Oracle Applications upgrade from version 10.7 to 11i (11.5.10) directing customized programming and report activities of my development team.
• Created documentation standards for final programs and the process to create and maintain programs.

Confidential, Lake Oswego OR

Oracle Consultant

Responsibilities:

• Taught Oracle DBA techniques to Roseburg Forest Products DBA.
• Created a 401(K) data warehouse based on Oracle HR and Payroll (11.0) system at Denkor Dental in Beaverton using Oracle Forms 4.5.

Confidential, Albany

Senior Developer

Responsibilities:

• Maintained material blending system, CAIGS, which I originally wrote in 1989.
• Maintained Perkin-Elmer LIMS system.
• Corrected and certified several Confidential Oracle based applications, including the LIMS system, to Y2K compliance.

Confidential

Senior Developer

Responsibilities:

• Senior systems analyst responsible for C programs to transfer data between MES using a DB2 database and SAP financials system.
• Designed and wrote a facility maintenance database using Oracle version 8.1.5, PL/SQL, and Oracle Forms and Report 6.0.
• Designed and developed an integrated circuit foundry scheduling system and material forecasting system for Industrial Engineering using Oracle version 8i, PL/SQL, and MS Access 97.
• Rewrote numerous Oracle Forms 3.0 legacy applications in Oracle Forms 5.0.
• Maintained legacy Oracle-based Financials system until SAP ERP could be implemented.

Confidential, Albany

Developer

Responsibilities:

• Team member for the planning of Oracle Applications upgrades from MPL 7 through 10.3.
• Senior Systems Analyst responsible for the maintenance, customization and customer support of Oracle Applications Purchasing, Receiving, Accounts Payable and Human Resources modules starting with MPL 6 through 9.7
• Backup system and Oracle database administrator for Confidential - Confidential based Laboratory Information Management System using Oracle 7.3. Designed and implemented several custom systems including an employee Tracking System using Oracle 6 and Forms 3.0
• Implemented, re-engineered and integrated (with existing Confidential systems) a purchased Laboratory Information Management System (LIMS) package from Perkin Elmer-Nelson using Oracle 7.2.3, Forms 3.0 and Oracle SQL*Report replacing my own 1989 LIMS system.

Confidential, Albany

Research Analytical Chemist and Programming Developer

Responsibilities:

• Designed and led a team to create a metals alloy blending system that merged data from an Oracle based inventory and a non-Oracle testing results system to optimize the use of material during the blending process. The program used linear algebra algorithms to minimize product cost and reduce on hand inventory. The system completely replaced the technician who performed the task manually.
• Designed, developed and managed team to create Confidential ’s first Laboratory Information System using a Texas Instruments 990/12 mini-computer.
• Team member to design data capture systems to transfer analytical test results from various test devices to a DEC PDP 11.