SUMMARY

• Over 9+ years of experience in Oracle Application E - Business Suite R12/11i as Oracle Apps Consultant expertise in leading a team of consultants and managing work delivery
• Played an Active role in Design, Development, Tuning, Testing, and Delivery of RICE components in Oracle Applications.
• Extensively experienced in Development of Interfaces, development of conversions, customization of interfaces.
• Profession in programming using SQL, PL/SQL, Report 6i, Oracle 9i/10g.
• Experience in importing data to Oracle Applications through SQL * Loader.
• Experience in Customization of Reports and Forms.
• Development of AOL, Form personalization, System Administration and Coding Standards in Oracle Applications.
• Good Experience in Working on XML Publisher reports, Oracle workflow Builder.
• Experienced in development of Object level Tuning and code level tuning by Tuning analysis, Explain plan, TK PROF Statistics, join methods, join orders.
• Expertise in Supply Chain applications like Order to Cash Cycle (OM, PO, INV) and BOM and WIP modules.
• Expertise in CRM applications like Service Agreements, Install Base and TCA Architecture
• Good Experience Procure to pay cycle (Purchase Order, Oracle Payables)
• Good Experience in Financial Modules like GL, AP and AR
• Good Experience on estimation and delivery time lines of the scope
• Strong Team playing abilities and Quick Learner.

TECHNICAL SKILLS

• Oracle E-Business Suite (EBS) 11i/ R12.
• Oracle-Apps Technical
• O2C (OM
• INV and AR)
• CRM (SA
• IB
• TCA
• INV)
• P2P(PO
• AP & GL)
• BOM
• WIP
• Object and Code level Optimization-Tuning
• Coding Standards
• Supporting Environment
• Team Building
• PVCS
• KINTANA
• TOAD
• Quality Centre.
• SQL
• PL/SQL.
• OracleDeveloper 2000 (Reports 6i/10g
• Forms 6i/10g)
• Custom pll
• Form Personalization
• OracleWorkflowBuilder
• TOAD
• SQL*Loader
• PL/SQL Developer
• SQL*Plus
• OracleXML/BI Publisher.

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Applications Tech Lead

Responsibilities:

• Cisco Capital Pre-Owned Integration
• EU Try and Buy Euro Compliance
• Re-price of Service Duration Change
• External Fulfillment restriction
• Accuprice Integration
• ASF under Bundle
• Ultimate Consignee - US federal compliance requirement (SOWB form changes)
• SRC Tool
• Move Rules

Environment: PL/SQL, Oracle 11g, r12, TOAD, KINTANA, QUALITY CENTER, UNIX.

Confidential, CA

Oracle Applications Tech Lead

Responsibilities:

• NGC Integration for item configuration
• CCW Integration for Order import into ERP
• SOM - Supply Order Creation
• Status Replications between OM and SJ
• Work Flow hold and process
• OM - SA Changes

Environment: PL/SQL, Oracle 11g, r12, TOAD, UNIX.

Confidential, CA

Oracle Applications Analyst

Responsibilities:

• Domain Index-Context Index
• Auto QOT Renewal
• The following applications are modified as part of Architecture POC.
• CSCC QOT Management
• The following applications are Monitoring as part of Q2O Performance.
• CSCC QOT Management
• CCW - Order Management
• Export Compliance Hold Report
• CSM Contract Hold Report

Environment: PL/SQL, Oracle 11g, r12, TOAD, UNIX.

Confidential, CA

Oracle Applications Tech Lead

Responsibilities:

• Terminate Coverage for Minor
• Link Minor to Major
• Add Coverage to Minor
• Delink the Minor
• Move the Product from one Instance to Other Instance.

Environment: PL/SQL, Oracle 11g, r12, TOAD, KINTANA, QUALITY CENTER, UNIX.

Confidential, CA

Oracle Applications Consultant

Responsibilities:

• Asset Management - IB

Environment: PL/SQL, Oracle 11g, r12, TOAD, KINTANA, QUALITY CENTER, UNIX.

Confidential

Oracle Applications Consultant

Responsibilities:

• Online Contract Management
• Asset Management

Environment: PL/SQL, Oracle 11g, r12, TOAD, KINTANA, QUALITY CENTER, UNIX.

Confidential

Oracle Applications Consultant

Responsibilities:

• Online Contract Management
• Asset Management
• PA process Interface
• Mass Mat

Environment: PL/SQL, Oracle 11g, r12, TOAD, KINTANA, QUALITY CENTER, UNIX.

Confidential

Team Member

Responsibilities:

• Online Contract Management
• SCDC
• RMA
• Q&O
• X-Track
• SOM & POM

Environment: PL/SQL, Oracle 11g, r12, TOAD, KINTANA, QUALITY CENTER, UNIX.

Confidential

Team Member

Responsibilities:

• Migration of Online Contract Management
• Migration of Asset Management Tool
• RMA enhancements
• Migration of Audit Log Process

Environment: PL/SQL, Oracle 11g, r12, TOAD, KINTANA, QUALITY CENTER, UNIX.

Confidential

Team Member

Responsibilities:

• Played an active role in developing the Technical Design documents for interfaces.
• Played an active role in developing code for interfaces and extension.
• Worked on Order Import and CSM hold and release functionality issues
• Developing unit Test Cases for the developed product and loading the test cases them into Mercury Quality Center
• Resolving the defects raised in Test cycles within the given SLA.
• Preparing KINTANA Packages for the developed objects.

Environment: PL/SQL, Oracle 11g, r12, TOAD, KINTANA, QUALITY CENTER, UNIX.

Confidential

Team Member

Responsibilities:

• Played an active role in developing analysis on object level, index level, session level, code level tuning.
• Perform enhancements required to implement necessary Optimizations.
• Responsible for the development standards as per the project.

Environment: PL/SQL, Oracle 11g, r12, TOAD, UNIX.

Confidential

Oracle Applications Consultant

Responsibilities:

• GL Extract
• GL JE Batches
• Extension - AP Pay-batch Set Run
• Extension - AR Gen-print INT INV
• AR Open Item Outbound
• AR Paid Items Outbound
• AR Customer Master Elements Outbound
• AP Account Payables Elements Outbound
• Reports 6i
• PO-Conversion
• Vendor Conversion
• Responsible developing and customizing reports
• Responsible for following the development standards as per the project.
• Having morning negotiations with onsite people.
• Analysis of the specifications provided by the clients.
• Responsible handling the bugs in the project and resolving the issues.
• Defining concurrent executables and concurrent programs.

Environment: PL/SQL, Oracle 11g, r12, TOAD, SQL*Plus, PVCS, UNIX.