SUMMARY

• Over 13+ years of experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e - Business Suite Applications Release R12 (12.2.2.4), 11i (11.5.10.2).
• Worked extensively in Oracle EBS RICEW (Reports, Interfaces, Conversions, Extensions and workflow) and OAF pages custom design and development.
• Profound knowledge in implementation, Migration, Customization and Production support of various EBS modules of Trading Community Architecture (TCA), Order Management (OM), Shipping (WSH), Advanced Pricing (QP), Inventory (INV), General Ledger (GL), Fixed Assets (FA), Oracle Projects (PA), Purchasing (PO), Accounts Receivable (AR), Bill of Materials (BOM), eBtax, XLA, HRMS and Application Object Library (AOL).
• Sound knowledge of Order to cash (O2C), Account to Close (ATC) and Procure to Pay (P2P) life cycles.
• Proficient in forms customization using Custom.pll and Personalization.
• Experience in workflow Business Events and XML publisher Bursting.
• Experienced in Tuning of SQL queries and PL/SQL code.
• Proficient in writing UNIX shell scripting.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Sound knowledge of Oracle Application tables, Schema, Interfaces, Application Program Interface (APIs) and MOAC.
• Experienced in Oracle Sysadmin and AOL - Registering Concurrent Programs, Request Sets, Form Functions, Creating Users, Defining Profile options and creating context sensitive DFFs using Application Developer & System Administration.
• Ability to work on Oracle ADF and Oracle SOA 11g Mediator, DB Adapter, BPEL and OSB.
• Well experienced in writing custom classes using core Java API, including JDBC, input/output streams and Servlets classes.
• Experience in using HPQC test management tool.
• Experienced in various test cycles like Unit Testing (UT), System Integration Testing (SIT), User Acceptance Testing (UAT) and Testing Strategy like entry/exit criteria, test plan, test scenarios and test cases.
• Good understanding of Agile Scrum methodology and Oracle AIM methodology.
• Experience in creating, managing Oracle Service Requests through Meta link.
• Extensively used Technical Reference Manual and Metalink to debug technical issues.
• Excellent team lead skills and ability to plan and meet milestones.
• Ability to work directly with business users to elicit business requirements, analyze/translate into functional requirements and develop specifications to meet deadlines and handle multiple tasks.
• Decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS

RDBMS: Oracle 11g, Oracle10G & Oracle 9i

Languages & Frameworks: PL/ Sql, Java, JavaScript, HTML, JDBC, OAF and Oracle ADF.

Tools: Oracle Workflow Builder, Jdeveloper, Oracle Reports Developer, Oracle Forms Developer, SQL Developer, TOAD, SQL*Plus, SQL Loader, Kintana, WinSCP, Putty and HP Quality Centre.

Operating Systems: Windows, UNIX, DOS.

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

Sr. Technical Consultant

Responsibilities:

• Involved in coding and unit testing of sales order, customer, and RMA Receipts inbound interfaces.
• Developed new conversion programs to load teh Sales Order Attachments, Price Lists, Item On-hand, Item UDA conversion programs.
• Coding of encrypt and decrypt password utility program.
• Coding of Drop Ships associated PO’s auto approval extension program.
• Worked on multiple CUSTOM.pll changes like defaulting values, populating teh DFF values at header and line level and releasing teh holds.
• Customization of order header (OEOH) and order line (OEOL) workflows for building new approval process for eContract items, applying and releasing holds in case of eSoftware and eContracts items.
• Building common utility programs of value set loader, lookups loader, common data loader and email distribution.
• Developed new XML publisher reports for end customers to provide teh shipping details of teh previous day.
• Trigger program to populate teh IR ISO order line/header DFF values.
• Designed and Developed File Upload OAF page.
• Responsible for setups related to Order import (e.g. Profiles, Value Sets, Defining context sensitive DFFs, Transaction Types, Document Sequence, and Order Import Sources).
• Preparation of Technical Design Documents (MD070), Installation Documents (MD120) and Unit Test Plan (UTP) Documents.

Environment: Oracle EBS R12.2.4, Oracle Workflow Builder, OAF, Jdeveloper, JAVA, UNIX (Shell Scripting), SQL, PL/SQL.

Confidential, Cincinnati, OH

Sr. Technical Consultant

Responsibilities:

• Involved in coding and unit testing of Projects, Tasks and Fixed Assets conversion programs.
• Developed GL Exchange Rate interface program.
• Design and development of custom MOA (Matrix of Authority) approval hierarchy associated OAF pages.
• Customized teh Journal Batch approval workflow for employee supervisor and custom MOA approval hierarchy.
• Developed new public OAF region for Journal Batch approval workflow approval notification.
• Developed new concurrent programs for posting teh journals, launching teh approval batch workflow for recurring, reversal and WEB ADI associated journals.
• Custom extension for integrating OTL timecard details to Oracle Projects in case of over time entered by teh employees.
• Bug fixing and enhancements during CAT and Integration testing.
• Preparation of migration scripts.

Environment: Oracle EBS R12.1.2, Oracle Workflow Builder, OAF, Jdeveloper, JAVA, UNIX (Shell Scripting), SQL, PL/SQL.

Confidential, Houston, TX

Sr. Technical Consultant

Responsibilities:

• Designed and developed Customer Conversion/Interface, AR Transactions inbound, GL Balances Conversion/Interface, Journal import interfaces.
• Based on teh business requirements Customized teh Purchase Order and Requisition account generator workflows.
• Designed and developed approval based Asset retirement OAF page and associated workflow.
• Coded new extension programs related to Install Base/Asset Tracking modules for calculating special depreciation amounts and retiring items from Install Base.
• Built multiple new Asset Audit, Asset Detail and Asset Sold to XML publisher reports.
• Preparation of Technical Design Documents (MD070), Installation Documents (MD120) and Unit Test Plan (UTP) Documents.
• Post Go-live support and implementing teh enhancement changes.

Environment: Oracle EBS R12.1.2, Oracle Workflow Builder, OAF, Jdeveloper, JAVA, UNIX (Shell Scripting), SQL, PL/SQL.

Confidential, Plano, TX

Sr. Technical Consultant

Responsibilities:

• Involved in development of custom RMS forms for global setup data across different divisions.
• Designed and delivered transitional data entry forms for different divisions.
• Coded shell scripts for calling teh PL/SQL programs and mailing teh error reports.
• Fine-tuning of SQL queries and PL/SQL code.
• Reviewing and Testing teh Code. Perform peer reviews.
• Post Go-Live support.

Environment: Oracle RMS Version 12, Oracle Forms Builder, SQL, PL/SQL, UNIX Shell Scripting.

Confidential, Santa Monica, CA

Technical Consultant

Responsibilities:

• Provided technical support for teh OM, INV, Shipping and Pricing modules interfaces and Reports.
• Debugging of packages, functions, procedures and triggers.
• Provided one time fix programs.
• Addressing teh issues raised by teh users and providing relevant information to them as needed.
• Modification of Technical Design Documents for CRs (Change Requests) and bugs.
• Preparation of Unit Test Plan (UTP) Documents.
• Prepare teh interface status reports and send to onsite lead and offshore manager and actively participated in project status calls and project quality auditing.

Environment: Oracle EBS 11.5.10, ORACLE 9i, SQL, PL/SQL, REPORTS 6i.

Confidential

Technical Consultant

Responsibilities:

• Technical design and coding of Purchase Requisitions custom Interface.
• Technical design and coding of Mass Additions (Fixed Assets), Sourcing Rule Assignments, Employee, Pay Scale, Pay Value (HRMS Work Structures), Employee Positions, Employee Termination, Employee Qualification, Employee Assignment Costing, Employee Assignment Grade Rates, Employee Salary and Employee Contacts conversions.
• Preparation and validation of migration scripts and Unit Test Plan (UTP) Documents.
• Bug fixing and enhancements during Integration and CAT testing cycles.

Environment: Oracle EBS 11.5.10, SQL, PL/SQL.

Confidential

Technical Consultant

Responsibilities:

• Designed and developed teh programs which calculates teh special depreciation amounts for Japan country specific depreciation methods JP 250 DB and JP STL EXTD.
• Developed special depreciation rules (One time, Yearly, Monthly) entry form.
• Modified teh standard ‘Mass Additions Post Program’ and ‘Upload Tax Book Interface Program’ to reflect teh depreciation methods JP 250 DB and JP STL EXTD.
• Developed custom program which creates receiving transactions for inter-company sales orders associated internal purchase order is interfaced to AR.
• Design and development of Asset detail, Asset summary and country specific tax xml publisher reports.
• Creation of Patch for teh Objects.

Environment: Oracle EBS R12I, SQL, PL/SQL, ORACLE FORMS, ORACLE REPORTS.

Confidential

Technical Consultant

Responsibilities:

• Modification of teh order header workflow for close order process.
• Complete development of custom rebates process solution, which includes calculation of rebate amounts for teh customers, creation of credit memos, payable invoices and journal entries.
• Coding and technical design of blanket sales order and receipts interface.
• Coding and technical design of price list and qualifiers conversions.
• Preparation and validation of migration scripts and Unit Test Plan (UTP) Documents.
• Bug fixing and enhancements during Customer Acceptance Testing (CAT) cycle.

Environment: Oracle EBS R11.5.10, Workflow Builder, SQL, PL/SQL, Oracle Forms, Oracle Reports.

Confidential, Pittsburgh, PA

Technical Consultant

Responsibilities:

• Based on teh standard data model changes from 10.7 to 11i, modified teh custom code associated reports, interfaces and extension objects.
• Involved in coding of new extension programs and reports in AR module.
• Modification of Technical Design Documents for CRs (Change Requests) and bugs.
• Preparation of migration scripts and Unit Test Plan (UTP) Documents.

Environment: Oracle EBS R11.5.9, Workflow Builder, SQL, PL/SQL, Oracle Forms, Oracle Reports.