SUMMARY

• Oracle Certification: - Oracle R12 Supply chain Management implementation Specialist: Oracle Order Management
• Around 10+ years of extensive experience as Oracle Application Techno-Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i). dis 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 wif major focus in Order Management (OM), Inventory (INV), Oracle Incentive Compensation (OIC),General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Project Accounting (PA), 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 Functional and Technical Experience inOracleApplications wif primary focus onOracleFusion.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces wifin 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 teh 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 wif client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Discoverer and modified teh 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 wif users, fixed teh 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 wif good communication skills.
• Experience in all phases of teh 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 wif 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, Minneapolis, MN

Oracle Techno functional Consultant

Responsibilities:

• Understand teh Business Requirement and design
• Worked on Oracle Incentive compensation Module for teh Employee whom teh Bonus has to paid based on Goal set for dat Particular Period or year
• Worked on Integration from Oracle Application to teh STARDB application for Bonus calculation foe Sales Rep.
• Worked on PL/SQL packages and Procedures to extract teh Data from Oracle Database to STARDB database.
• Worked on Data Reconciliation after extraction of teh data.

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

Confidential, Minneapolis, MN

Oracle Techno functional Consultant

Responsibilities:

• Deliver solutions to clients in response to varying business requirements.
• Worked as Onsite coordinator for teh 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.
• Worked on Code development and Functional Testing for teh BPH process in Oracle Configurator.
• Responsible for effective communication to teh customer and peers. Provide day to day direction to teh peers and provided project status to teh customer on a regular basis.
• Translate customer requirements into formal requirements and design technical specifications, establish specific solutions, and leading teh efforts including programming and testing dat culminate in client acceptance of teh results.
• Utilize in-depth knowledge of functional and Technical experience in Oracle ERP and other leading-edge products and technology in conjunction wif industry and business skills to deliver solutions to customer.

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

Confidential, McKinney, TX

Oracle Techno functional Consultant

Responsibilities:

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

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

Confidential

Oracle Techno functional Consultant

Responsibilities:

• dis Project is of Enhancement and support Project for Different Division of Confidential
• Global Enhancement Project include New Development of Reports, XML publisher Report and Interfaces me.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.
• Actively involved in performance tuning task force team, fine tuning all teh effected processes (Reports, Concurrent Programs, and Nightly Jobs etc.) which would of High me/O Cluster waits, Poor Explain Plan, High CPU Cost. Reviewed (by generating trace files, explain plans etc.) and modified (or redesigned) teh existing programs to drastically increase teh performance.
• Developing procedures packages, for inbound and outbound interface.
• Worked On Inbound Interface for Invoice creation through Custom process
• Worked on OM, AR, PA, INV, AP, PO, GL, BOM, WIP, 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 teh functionality as per teh business Requirement.
• Used kintana package to migrate teh code from once instance to higher instance.
• Worked on TCA architecture for loading teh customer and supplier data in Oracle from legacy system.
• Used fnd load to download and upload teh code to higher instance in oracle.
• Worked on OAF form Personalization.
• Honoured and Nominated as Employee of teh Month for a 2 times for exceptional performance, commendable work quality and customer service attitude.

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

Confidential

Oracle Techno functional Consultant

Responsibilities:

• Initiative Owner, Functional and Technical Owner of implementation of Fuzzy Search in teh SolPro application which is one of key feature of teh product.
• Development of Reports and enhancement for OM,PO,AP,AR,INV and BOM
• Modified teh inbound Sub inventory Transfer interface program to do teh 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 teh product wif various ways and note teh 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.

Confidential

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 teh Common CNI’s me.e. Global components up gradation to R12 compatible.
• Has 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 teh program to create teh customer and its sites in TCA by using teh custom program as per teh business requirement.
• Has worked on upgradation of teh Reports, XML publisher reports and enhancement of reports as per teh business requirement to meet teh component for R12 compatible.
• Converted teh 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 teh custom process to AR invoices which were process through teh Order Management module.
• Worked on RICEW components.
• Worked on Order management Shipping Document sets and converted teh existing reports to XML Publisher.
• Worked on Materialized view as per teh Business requirement.
• Worked on form personalization for Order management.
• Developed XML publisher Bursting report to mail teh output to teh 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 teh effected processes.

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

Confidential

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 teh mail to teh users using UTL file package.
• Worked on GRC upgrades Project, which was to remove teh Logical Apps rules personalisation, was moved to GRC personalization.
• Worked on Inbound and out bound interface of Order management wif 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.

Confidential

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 teh mail to teh 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.

Confidential

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 teh business using PL/SQL.
• Customization of Standard Reports as per teh business need for OIC modules
• Each record you select for import, and if teh record contains valid data, then teh program for OIC custom interface for Sales calculation in OIC modules.
• Perform Incentive Compensation Administrator's tasks.
• Has done setup for teh collection and calculation for payments.
• Define compensation plans and roles and assigned to specific Resource in teh hierarchies

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

Confidential

Oracle Technical Consultant

Responsibilities:

• dis project was for R12 Upgradation project
• Designing and Registration of Reports.
• Development of XML Publisher report.
• Developed stored procedures, functions and packages in augmenting teh business using PL/SQL.
• Upgrading teh 11i RICE components to R12 Compatible components and migrate teh same to R12 instance.
• Worked on TCA for loading teh customer data in oracle rom legacy system by using API
• Worked on OAF personalization.
• Worked on Check Printing Report as per teh Business requirement for teh 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

Confidential

Oracle Technical Consultant

Responsibilities:

• Worked as an Oracle Apps Technical Consultant.
• Developed stored procedures, functions and packages in augmenting teh business using PL/SQL.
• Customization of Standard Reports as per teh business need.
• Creation of value sets, profile options and request sets and scheduling teh request set
• Developed packages for teh Payables Open Interface program dat validates, each record you select for import, and if teh record contains valid data, then teh program create a Payables invoice wif distributions and scheduled payments based on teh invoice header and line information in teh record.
• Developed a package dat validates invoice information and load teh 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 teh product wif various ways and note teh 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.

Confidential

Oracle Technical Consultant

Responsibilities:

• Developed, Designing and Registration of Reports.
• Setting concurrent programs.
• Customization of Standard Reports as per teh business need.
• Developed a package for GL Interface dat validates and imports journals to General Ledger.
• Developed an Interface wif 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 teh product wif various ways and note teh errors According to standards given charts of testing on Test Instance.
• Creation of value sets, profile options and request sets and scheduling teh request set

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