EXPERIENCE SUMMARY:

Over 12+ years of experience in Information Technology as application developer, systems analyst, administrator including 10 years in Oracle ERP (10.7 to 11i) using Oracle Developer 6i and Discoverer (4.1, 4i, 9i, 10g). Strong experience in Oracle tools SQL, PL/SQL, SQL*Loader and Toad. Experienced in preparing projects related documentation and all phases of system development. Knowledge of XML Publisher, R12, and OA Framework.

PROFESSIONAL STRENGTHS:

• Strong experience in Oracle PL/SQL database Analysis & Programming.
• Application development using Oracle Developer 6i & Discoverer, Toad in 11i environment.
• Hands on experience in data warehouse development.
• Experience with the following Oracle Apps modules - Financials, OM, WMS, OPM, PA, and Contracts.
• Experienced in gathering requirements from users, and make recommendations to facilitate business processes.
• Experienced in preparing projects related documentation, test plans, functional and technical design docs according to standard(AIM) .
• Unix shell scripting.
• Knowledge and experience in XML Publisher (Oracle training class in March 2009)
• Knowledge of JAVA programming 

PROFESSIONAL EXPERIENCE:

Oracle Technical Consultant

Confidential, Pasadena, CA

Responsibilities:

• Second engagement at the company.
• Technical development for an R12 Field Service implementation.
• Developing customizations, extensions to 11i (Forms, BI Publisher, Reports, PL/SQL, OAF, etc) in Project Accounting,, and Financials modules.
• Convert projects data from a third-party legacy system to Oracle PA including project header, classifications, key members, tasks, budgets, and terms & conditions using APIs such as PA PROJECT PUB.CREATE PROJECT, PA BUDGET PUB.CREATE DRAFT BUDGET and other custom programs.

Oracle Technical Consultant

Confidential, Irvine, CA

Responsibilities:

• Second engagement at the company.
• Develop customizations, extensions in 11i OPM, AR, PO, AP, GL, WMS, Inventory modules in the manufacturing facility (Levlad in Chatsworth, CA) for Confidential using 6i Forms, Reports, and Discoverer 10g. Major tasks worked on include sales and production forecast, sales forecast to actual, supply and demand, indented BOM, lab formula explosion, inventory item reservation delete, intransit inventory, lot disposal aging, lot disposal tracking form, onhand quantity reporting, shipping reports - BOL, picking, packing list, commercial invoice, etc.
• Upgrade Discoverer from 4i to 10g with 300+ custom EUL folders and 200+ workbooks.

Oracle Technical Consultant

Confidential, Long Beach, CA

Responsibilities:

• Develop data conversion programs for the fixed assets module for an 11i to SAP conversion.
• Develop a Payables interface from Oracle 11i to SAP.
• Develop and support the Confidential Global Data Warehouse (GDW) consisting of shipping, inventory, sales, and finance information using PL/SQL, Unix scripts, and Discoverer 9i.

Oracle Technical Consultant

Confidential, Irvine, CA

Responsibilities:

• Develop interfaces (outbound) in order management and warehouse management modules in an Oracle 11i implementation project which uses IBM Websphere MQ ESB as the messaging backbone. The interface involves sending order statuses from OM, shipping statuses from WMS, and payment info from AR to a legacy MLM (Multi-Layer Marketing) system.
• Development tools used for building the interfaces are PL/SQL, packages, and triggers.
• Develop a custom application Integrated Message Tracking Framework ( Confidential ) using 6i Forms and Reports (three custom forms with multiple tabs and two reports) which provides the foundation for setting up new distribution centers, configuring and managing the interface ESB messaging system.
• Confidential also manages and tracks interface performance, issues and errors.

Senior Oracle Developer

Confidential, Carson, CA

Responsibilities:

• Develop customizations, extensions to 11i using Forms, Reports, Discoverer in Financials, OM and WMS such as AR/AP invoice, taxes, aging, trial balance, custom PO return form, shipping reports.
• Develop conversions, interfaces such as customer price list extract, price list lines auto creation, inventory item reservation maintenance using various Oracle APIs.
• Develop Discoverer reports in all modules mentioned above.

Oracle Technical Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Develop a decision support system by first gather reporting requirements from the District Special Education managers and administrators and then analyze, translate, and formulate the requirements into Oracle Discoverer reports.

Oracle Technical Consultant

Confidential, Pasadena, CA

Responsibilities:

• Participate in the 11.0.3 to 11i (11.5.9) post-upgrade activities by developing customizations, extensions to 11i (Forms, Reports, Discoverer) in Financials, Project Accounting such as AR/AP invoice, taxes, aging, trial balance, bank EFT interface, and various PA reports and forms.

Oracle Technical Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Oracle 11i technical development (Forms, Reports, Discoverer) in Financials, OM and WMS business areas