PROFESSIONAL SUMMARY:

• Oracle Certification: - Oracle R12 Supply Chain Management Implementation Specialist: Oracle Order Management
• 11+ years of extensive experience as Oracle Application Techno-Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), Oracle Incentive Compensation (OIC), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), BOM.
• Experience in Order to Cash (O2C), Procure to Pay (P2P) life cycles and Supply Chain business flows.
• Involved in development of RICE components using SQL, PL/SQL Developer 2000, XML Publisher as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Applications. 
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• 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.
• Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL), Implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
• Worked on TCA implementation Project for loading the customer and supplier in Oracle from legacy system.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Performed User and Administration responsibilities in Discoverer
• Experienced in Forms Personalization
• Experienced in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher.
• Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Discoverer and modified the formats using XML publisher for customizations as per client specification.
• Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
• Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.
• Interacted with users, fixed the bugs, developed test plans and provides daily production support.
• Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS.
• Excel in team collaboration, quick adaptation and problem solving with good communication skills.
• Experience in all phases of the system development life cycle.
• Worked on Month end Closure activities for order management and Inventory.
• Experienced in advance PL/SQL, IN-BOUND, OUT-BOUD Interface and Conversions.
• Worked on migration of objects like concurrent programs, value sets through fndload.
• Worked on Integration Projects by Using SOA with Oracle Application

TECHNICAL SKILLS:

ERP: Oracle Applications ERP (Rel 12, Rel 11i)

Tools & Technologies: TOAD, SQL Developer, SQL* Plus, JDeveloper for Oracle Applications Framework, Oracle Reports Builder (6i/9i/10g), JDeveloper for OAF, XML Publisher tool

Functional Modules: Order Management, Purchasing, Inventory, Accounts Payables, Account Receivables, General Ledger, Bills of Materials, WIP and OIC

Languages: SQL, PL/SQL, JAVA/J2EE, UNIX, C, C++

Operating Systems: Windows NT/2000 Server, UNIX

Databases: Oracle 9i,10g

Technical Skills: Interfaces/Conversions, XML Reports, OA Framework, Extensions, Logical Apps, AOL

Domain: Oil & Gas, Energy, Infrastructure, Software Products and Tele-Communication

Other Software Tools: Kintana, PVCS, CVS, HP Service Desk (HPSM), SharePoint, SBM

PROFESSIONAL EXPERIENCE:

Confidential,San Jose, CA

Oracle Apps Techno Functional Consultant

• Working as an Oracle Apps Techno-Functional consultant.
• Working on Revpro tool for Revenue Recognition calculation as per US GAAP and ASC606.
• Worked outbound interface to extract the data for oracle Sales order and AR invoices.

Oracle Techno Functional Consultant

Responsibilities:

• Understand the Business Requirement and design
• Worked on Oracle Incentive Compensation Module for the Employee whom the Bonus has to paid based on Goal set for that Particular Period or year
• Worked on RICE components for SCM modules such as OM, IN, AR, AP.
• Worked on report Development in Oracle.
• Worked on Outbound interface to extract the data from Order management.
• Worked on Integration from Oracle Application to the STARDB application for Bonus calculation for Sales Rep.
• Worked on Compensation Plan design.
• Worked on Configuration of imported data files.
• Worked on PL/SQL packages and Procedures to extract the Data from Oracle Database to STARDB database.
• Worked on Data Reconciliation after extraction of the data.

Environment: Oracle Applications ERP (Rel. 12), Oracle 10g

Oracle Techno Functional Consultant

Role/Responsibilities:

• Deliver solutions to clients in response to varying business requirements.
• Worked as Onsite coordinator for the customer.
• Worked on Requirement gathering for different Business Processes for Configure to Order cycle and Order to cash Cycle of Oracle
• Implemented Supply chain modules.
• Deliver various RICE components specifically Conversion/Interfaces, XML Reports
• Design and Deliver Interfaces between multiple systems using Inbound and Outbound interface for Order Management.
• Worked on Code development and Functional Testing for the BPH process in Oracle Configurator.
• Responsible for effective communication to the customer and peers. Provide day to day direction to the peers and provided project status to the customer on a regular basis.
• Translate customer requirements into formal requirements and design technical specifications, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in Oracle ERP and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Environment- Oracle Application 11i & R12, Oracle Supply Chain, Accounts Receivables (AR), Accounts Payables (AP), Order Management (OM), Inventory.

Oracle Techno Functional Consultant

Role/Responsibilities:

• Work with Functional Team in translating business requirements into Technical Requirements Document and to Detailed Design Documents.
• Requirement gathering for the Discovery project.
• Created BRUD document for this Discovery
• Developed Strategy for the discovery for the OCD and Documented the same for the Development
• Developed the AS IS and To Be flows for the Regulators Divisions
• Developed the Flow Diagrams for the Standard and Customization process which are followed by the Business.

Environment- Oracle Applications ERP (Rel 11), Oracle 9i, Supply chain, Inventory (INV), Order Management (OM), Purchasing, Bills of Materials (BOM), I-Store, Configurators.

Oracle Techno Functional Consultant

Responsibilities:

• This Project is of Enhancement and support Project for Different Division of Emerson
• Global Enhancement Project includes New Development of Reports, XML publisher Report and Interfaces i.e. All RICE components and Also Enhancement based on Bossiness Requirement.
• Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL. 
• Developing procedures packages, for inbound and outbound interface.
• Worked Configuration of imported data files OIC .
• Worked on Inbound Interface for Invoice creation through Custom process
• Worked on OM, AR, PA, INV, AP, PO, GL, OIC, Modules.
• Developed and customized XML publisher reports for different Oracle Modules
• Converted RDF reports to XML publisher report for different Oracle Modules.
• Worked on Form Personalization for OM module for Sales order Form.
• Worded on Order import interface to enhance the functionality as per the business Requirement.
• Worked on setup for Collect, Calculation and Payment process in OIC.
• Used kintana package to migrate the code from once instance to higher instance.
• Worked on TCA architecture for loading the customer and supplier data in Oracle from legacy system.
• Used fnd load to download and upload the code to higher instance in oracle.
• Worked on OAF form Personalization.
• Honoured and Nominated as Employee of the Month for 2 times for exceptional performance, commendable work quality and customer service attitude. 

Environment: Oracle Applications (11i, R12), Oracle10g, OIC, INV, PO, OM, PA, PO, AP, AR, GL and Reports 6i

Oracle Techno Functional Consultant

Responsibilities:

• Initiative Owner, Functional and Technical Owner of implementation of Fuzzy Search in the SolPro application which is one of key feature of the product.
• Development of Reports and enhancement for OM, PO, AP, AR, INV and BOM
• Modified the inbound Sub Inventory Transfer interface program to do the soft reservation in Oracle.
• Developed Custom Packing slip report and Created new Shipping Document Sets in order management.
• Worked on RICE components on PO, OM, GL, AR, BOM, WIP, INV
• Developing procedures packages, for inbound and outbound interface for Purchasing.
• Worked on Inbound Interface for Receiving transaction processor for Receipts in PO through Custom process.
• Developed and customized XML publisher reports.
• Converted RDF reports to XML publisher report for Shipping Document sets.
• Interfaces: Receiving Transaction Processor, Order Import inbound interface.
• Includes Testing of the product with various ways and note the errors According to standards given charts of testing on Test Instance.
• Received Appreciation mail from client for exceptional performance
• Use of Daily Business Intelligence tool in Oracle and design of reports.
• Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing, service pack upgrades and adhoc report requirements.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets

Environment: Oracle Applications ERP (Rel 11), Oracle 9i, Purchasing, Vendor Management System.

Oracle Techno Functional Consultant

Responsibilities:

• Development of RICE deliverables. Interfaces/Conversions and XML Reports.
• Technical Specifications Build for all objects handled.
• Worked on R12 upgradation project for the Common CNI’s i.e. Global components up gradation to R12 compatible.
• Have worked on TCA implementation, Worked on Integration part for Customer creation by using different API’s in to Oracle R12.
• Created Supplier using standard oracle API’s
• Created the program to create the customer and its sites in TCA by using the custom program as per the business requirement.
• Have worked on upgradation of the Reports, XML publisher reports and enhancement of reports as per the business requirement to meet the component for R12 compatible.
• Converted the Rdf reports to XML Worked on RICE components on PO, OM, GL, AR, BOM, WIP, INV
• Worked on Document set for Order Management modules.
• Developed the custom process to AR invoices which were process through the Order Management module.
• Worked on RICEW components.
• Worked on Order Management Shipping Document sets and converted the existing reports to XML Publisher.
• Worked on Materialized view as per the Business requirement.
• Worked on form personalization for Order management.
• Developed XML publisher Bursting report to mail the output to the Supplier, and also for couple of other Bursting reports.
• Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL. 
• Actively involved in performance tuning task force team, fine tuning all the affected processes.

Environment: Oracle Applications ERP (Rel 11), Oracle 9i, Purchasing, Inventory, Order Management, Accounts Receivables, Bills of Materials

Oracle Technical Consultant

Responsibilities:

• Development of RICE deliverables. Interfaces/Conversions.
• Development of Reports and enhancement for different oracle Modules such as GL, AP, AR, FA, PO, OM, BOM, WIP
• Development of XML reports for Bursting email program for Supplier and other custom reports.
• Worked on RICE components on GL, AP, AR, FA, PO, OM, BOM, WIP
• Developing procedures packages, for inbound and outbound interface.
• Worked on OUTBOUND Interface of Sales orders Extraction and sends the mail to the users using UTL file package.
• Worked on GRC upgrades Project, which was to remove the Logical Apps rules personalisation, was moved to GRC personalization.
• Worked on Inbound and out bound interface of Order management with SOA integration.
• Worked on Logical Apps Rules.
• Designing and coding for Procedures, Packages, Functions in PL/SQL, Data load,

  SQLLoader.

• Worked on GL, AP, PO, INV, BOM, WIP, OM Modules.

Environment- Oracle Applications ERP (Rel. 11, R12), Oracle 9i Oracle Supply Chain Management Modules and Oracle Financials.

Oracle Technical Consultant

Responsibilities:

• Development of RICE deliverables. Interfaces/Conversions.
• Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL. 
• Development of XML reports.
• Worked on RICE components on GL, AP, PO, OM, BOM, WIP
• Developing procedures packages, for inbound and outbound interface.
• Worked on OUTBOUND Interface of Delivery Details and sends the mail to the users.
• Worked on Inbound and out bound interface of Order management
• Worked on Inbound and out bound interface of Order management.

Environment- Oracle Applications ERP (Rel. 11, R12), Oracle 9i Oracle Supply Chain Management Modules and Oracle Financials.

Oracle Technical Consultant

Responsibilities:

• Development of RICE deliverables. Interfaces/Conversions.
• Worked on Reports development and enhancement
• Worked on Compensation Workbench
• Perform setups for Collection, Calculation, and Payment.
• Configure/carry out Incentive Compensation Administrator's tasks.
• Creation and classification of rules and hierarchies/ Creation of sales credit allocation rules and hierarchies.
• Assigning roles to resources/Reps
• Assigning compensation plans, Pay Run
• Create resources/ sales roles and assign them to resources/ compensation groups and teams and Create hierarchies
• Xml Publisher Reports Developments.
• Designing and coding for Procedures, Packages, Functions in PL/SQL, Data load, SQL Loader.
• Developed stored procedures, functions and packages in augmenting the business using PL/SQL.
• Customization of Standard Reports as per the business need for OIC modules
• Each record you select for import, and if the record contains valid data, then the program for OIC custom interface for Sales calculation in OIC modules.
• Perform Incentive Compensation Administrator's tasks.
• Have done setup for the collection and calculation for payments.
• Define compensation plans and roles and assigned to specific Resource in the hierarchies

Environment- Oracle Applications ERP (Rel.11, R12), Oracle 9i Oracle Supply Chain Management Modules and Oracle Financials, Oracle Incentive Compensation

Oracle Technical Consultant

Responsibilities:

• This project was for R12 Upgradation project
• Designing and Registration of Reports.
• Development of XML Publisher report.
• Developed stored procedures, functions and packages in augmenting the business using PL/SQL.
• Upgrading the 11i RICE components to R12 Compatible components and migrate the same to R12 instance.
• Worked on TCA for loading the customer data in oracle rom legacy system by using API
• Worked on OAF personalization.
• Worked on Check Printing Report as per the Business requirement for the Pre-printed Stationary.
• Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL. 

Environment- Oracle Applications ERP (Rel.11, R12), Oracle 9i Oracle Supply Chain Management Modules and Oracle Financials

Oracle Technical Consultant

Responsibilities:

• Worked as an Oracle Apps Technical Consultant.
• Developed stored procedures, functions and packages in augmenting the business using PL/SQL.
• Customization of Standard Reports as per the business need.
• Creation of value sets, profile options and request sets and scheduling the request set
• Developed packages for the Payables Open Interface program that validates, each record you select for import, and if the record contains valid data, then the program creates a Payables invoice with distributions and scheduled payments based on the invoice header and line information in the record.
• Developed a package that validates invoice information and load the invoices into AP interface tables.
• Modification of AP Invoices Interfaces developed by Oracle to import data from different source systems every month.
• Modification of AP Invoices Interfaces developed by Oracle to import data from different source systems every month.
• Creation of Technical Design Client standard template based on required functionality given in MD-50 document.
• Includes Testing of the product with various ways and note the errors According to standards given charts of testing on Test Instance.
• Worked on XML Publisher Reports.

Environment- Oracle Applications ERP (Rel.11, R12), Oracle 9i Oracle Supply Chain Management Modules and Oracle Financials.

Oracle Technical Consultant

Responsibilities:

• Developed, Designing and Registration of Reports.
• Setting concurrent programs.
• Customization of Standard Reports as per the business need.
• Developed a package for GL Interface that validates and imports journals to General Ledger.
• Developed an Interface with validations to transfer Daily Currency Conversion Rates from Legacy System to General Ledger.
• Registered PL/SQL packages, and reports as concurrent programs.
• Creation of Technical Design Client standard template based on required functionality given in MD-50 document.
• Includes Testing of the product with various ways and note the errors According to standards given charts of testing on Test Instance.
• Creation of value sets, profile options and request sets and scheduling the request set

Environment: Oracle Applications ERP (Rel.11, R12), Oracle 9i Oracle Supply Chain Management Modules and Oracle Financials.