SUMMARY

• 14+ years of overall extensive IT experience in all aspects of Oracle Applications Analysis, Design, Development, Production Support, Testing, Migration, Conversion, Customization and Implementation and documentations.
• 8 years of work experience on Techno Functional knowledge on Oracle E - Business Suite Application in Supply Chain /CRM modules Order Management(OM), Pricing, Shipping, Purchasing(PO), Inventory(INV), BOM, WIP. Also, worked on Account Payables(AP) & GL custom solutions.
• Expertize in customization of Oracle Forms/Reports, Data Conversions, Real time Interfaces, Customizations, Extensions (RICE) on Oracle Applications R12 and 11i.
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles.
• 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.
• Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality.
• Experienced in Oracle Application upgrades from 11i to R12 releases.
• Experience working on complex applications using Oracle SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes, worked on Script development using UNIX and Shell Scripts.
• Knowledge of code migration tool Kintana (HP PPM), Clearcase, SVN and AIM Methodology.
• Onsite Site Post PROD Support, Enhancements & new solution development experience of Oracle Apps eBusiness Suite 11i & R12
• Participation in varied roles ranging from Team Lead, Techno Functional and Technical Consultant.
• Over 4 years of experience in managing and leading a team as a team leader and onsite-offshore coordinator.
• Expertise in preparing AIM(Application Implementation Methodology) Documents and User Manuals Functional Specification Document (MD050), Technical Design Document (MD070/CV060) and Conversion Mapping Document (CV040).
• Good experience in Oracle Applications Application Object library (AOL).
• Identified product gaps, coordinated with other Teams by creating Service Requests (SR) and obtained one-off fixes. Managed and monitored SRs for several P1 Issues. Provided on site solutions and resolved showstopper issues.
• Experience in Application System Administration activities like Managing Concurrent managers, Application User set up, Defining responsibilities, Value sets, Flex Fields, Registering menus and providing support to Apps end users.
• Good international experience of working in four different countries. USA, Malaysia, Singapore and India.
• Out-of-the-box thinking and creative problem solving.
• Excellent communication and interpersonal skills. Very good client relationship track. Good Leadership qualities with go-get abilities.
• Knowledge on TCA architecture.

TECHNICAL SKILLS

ERP: Oracle Application R12 and 11i (Order Management, Shipping Execution, Inventory, Purchasing, BOM, WIP, Oracle Workflow, iProcurement, AOL, SYSADMIN, XML Publisher Administrator, Integrated SOA Gateway, OIC and Account Payables

Programming Language: PL/SQL, SQL, Unix Shell Scripts

RDBMS: Oracle 9i, Oracle 10g, Oracle 11g and Oracle 12c

Development Tools: XML Publisher

Desktop Applications: PL/SQL Developer, SQL Developer, TOAD, SQL*Loader, Oracle Forms 6i and Reports 6i

Other Tools: Putty, SSH, WinSCP, PVCS, Clear Case, Kintana, SVN and Fiddler

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Oracle Sr. SCM Techno Functional Consultant

Responsibilities:

• Understand business requirement and prepare MD.070 document for enhancements to existing extensions
• Review the packages contents and ensure that change has properly done as per requested, tested and documented
• Explaining the action items to the offshore team
• Helping in closing related critical issues.
• Guiding team time to time whenever it is required and helping them out in case of any issue/bug
• Interacting directly to client by conf. call and Web-ex meeting.
• Taking the ownership of any object where it is required.
• Involved in all escalations call till issue resolutions, make sure to deliver the quality solutions on time, weekly status call with Customer/Stakeholders.
• Resolved multiple issues pertaining to Cancelled sales order and implemented the permanent solution for the same.
• Implemented a permanent solution to fix Preferred Access intermittent Automatic Reservation issue during Sales order booking.
• I was part of testing Preferred Access functionality for Oracle EBS Annual DR Exercise & also part of Q4 Patch testing.
• Also, Responsible for the Development/Enhancement of following Technical Components

Environment: Oracle Apps 12i (OM, INV, PO, and AP modules), PL/SQL procedures/Unix Shell Scripts, Oracle database 10g/11g/12c, TOAD, Oracle Reports, XML Publisher Reports, BMC Remedy UserTicketing tool, WinSCP and Putty

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Involved in requirements gathering, analysis, development, QA and post-production support.
• Worked on Development/Enhancement of following Technical Components
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.

Environment: Oracle Apps 12i (Modules -OM, INV, WSH, AP, PO and GL), PL/SQL procedures/Unix Shell Scripts, Oracle database 9i/10g, TOAD, Oracle Reports and BMC Ticketing tool and Putty

Confidential

Oracle OIC Technical Consultant

Responsibilities:

• MR Statement reports (Summary and Detail).
• Overlay/Rollup programs.
• GL Account Rate integration in OIC.
• Pay Plan Assignment Management Report.
• MR Accrual Report.
• Archiving Everest and SAP orders from Staging and Reference tables.
• Closed order logic added in Everest Order interface program.

Environment: Oracle Apps 12i (Modules -OM and OIC.), PL/SQL procedures, Oracle database 9i/10g, TOAD and OVSD Ticketing tool, Kintana, Clearcase, WinSCP and Putty.

Confidential

Oracle Techno-Functional Consultant & ON-SITE Co-Ordinator

Responsibilities:

• Reviewing CV60’s and Data Migration Codes and to make necessary changes required in technical documents and data migration codes.
• Was involved in coordinating with offshore Data migration Team for DM activities and helping them in resolving issues related to DM.
• Involved in optimize the performance and Enhancements of CEMLI objects.
• Involved in enhancement and testing of FedEX Interface.
• Involved in setup related change requests.
• Involved in Post Production Support of Technical issues of CEMLI objects till stabilization.
• Involved in all of the Test Cycles.

Environment: Oracle Apps 11i (Modules -INV, PO and OM), PL/SQL procedures, Oracle database 9i/10g, TOAD, SQL Developer, WinSCP, Putty, Kintana, Clearcase and OVSD ticketing tool.

Confidential

Oracle Technical Consultant

Responsibilities:

• This Task mainly involves the development of Extracts which would inturn be used for Data Conversions.
• Involved in the Upgradation Performed by the Avago from 11.5.5 to 11.5.10
• Involved in the development of following data conversions
• Item Pending Status and Item Cross References Conversions.

Environment: Oracle Apps 11i (Modules - Inventory, PO and OM.), PL/SQL procedures, Oracle database 9i/10g, PL/SQL Developer and SQL Loader.

Confidential

Oracle Technical Consultant

Responsibilities:

• Items Conversion.
• Conversion of item default locators.
• Customization Of PO Form TO Ensure No PO Is Created For Less Than US$1000.
• Custom Report For Purchase Orders With Matching Type By Supplier,By Period.
• Sales Orders And RMA Outbound Interface By Salesperson, By Customer.

Environment: Oracle Apps 11.5.7(Modules - INV, PO and OM), PL/SQL procedures, Oracle 9i, TOAD and SQL Loader.

Confidential

Oracle Technical Consultant

Responsibilities:

• Implement zoom in the sales order form to view the item definition information Passing Item As Parameter.
• Item ABC Codes Migration.
• Item Categories and category assignments conversion.

Environment: Oracle Apps 11i (INV, OM & PO), Reports 6i, TOAD, SQL Loader.