SUMMARY

• 8 Years of professional work experience in Oracle E - Business Suite 11i & R12.
• Experience in implementing, testing, training, live production supporting, on various Oracle ERP Modules like Order management(OM), Shipping, Inventory(INV), Purchasing(PO),Accounts Payables(AP), Accounts receivables(AR), Project Accounting(PA),General Ledger(GL),XML Publisher, me Supplier. Cash Management, Warehouse Management System (WMS), Trading Community Architecture (TCA) and iProcurement.
• Oracle Global Techno-Functional Production Support in Oracle Modules like Procure-to-Pay (P2P), Order to Cash (O2C) and me focus
• Extensive work in teh functional areas like Order to Cash, P2P and Finance Modules
• Experience in Implementation, Upgradation and Customization in Oracle Applications (versions R12 and 11i).
• Extensive work in teh technical areas like SQL plus, PL/SQL, Toad, Forms, Reports, Discoverer, Optio.
• Extensive work on testing R12 Financial and Supply Chain modules
• Involved in two Full lifecycle Implementations including Functional setups, process, gap analysis and creating functional specifications and given post production support.
• Extensive experience in Order to Cash and procure to pay cycles.
• Served as one of teh member in general oracle practice support team
• Strong functional and technical knowledge in interface tables and base tables of INV, Order Management, Oracle Costing Advanced Pricing, GL, AP, AR, CM, and Shipping.
• Provided functional test scripts for different scenarios of business
• Sound experience in Data Conversions, Data Migration, Developing Inbound and Outbound Interfaces, Customizing Forms & Reports, Developing Forms & Reports, Customizing Workflows in various Oracle Financial and Supply Chain Management.
• Hands on experience in understanding Oracle supplied TRM’s and well versed in understanding visual linking of teh tables of TRM.
• Experienced in development and customization of Forms and Reports wif sound understanding of Application Object Library (AOL), Sysadmin.
• Experienced in preparing Test Plan, Unit Testing, System Integration testing and documentation, wif ability to work in across functional modules and Technical.
• Experience in supporting teh production system, handling day-to-day issues and end user training
• Developed Interface/Conversion Programs, and experienced in writing Stored Procedures, Functions, Triggers and Packages using PL/SQL.
• Extensive experience in RICE components and Worked as Technical consultant for production support.
• Worked in multi-organization implementation that involved gathering requirements, defining solutions, and recommending best business practices and completing system set-up
• Involved in 11i patch project and given impact analysis for R12 upgradation
• Experience in AIM methodology
• Closely worked wif Technical teams for Customizations like reports, interfaces Oracle forms and java pages.
• Exceptional communicator - can TEMPeffectively present ideas and concepts to upper management in a clear and concise manner
• Experience in Roll-Outs
• Extensive experience in Logical Apps and Form Personalization’s

TECHNICAL SKILLS

Oracle Applications: Oracle Applications R12,11i/11.5.10 (OM, PO, INV, AR, GL, Bill of Materials, Shipping, AOL and System Administration

Software Tools: Developer 2000, Forms 6i/4.5, Reports 6i/2.5, Discoverer 10g, SQL*LOADER, PL/SQL, SQL*Plus, Logical apps, OptioDesignStudio7.8, Java, HTML and XML, HP Quality Center

Programming Languages: PL/SQL, C

Operating Systems: UNIX, Windows 2000 Server/Professional, Windows NT

RDBMS: Oracle 9i, 10g and 11g

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in teh preparation of Detail Design, technical design and specification.
• Involved in Functional Testing for all custom flows
• Worked on customizations based on teh user requirements and Business demand
• Working on many customizations and enhancement requests based business demand
• Working on impact analysis for Oracle Upgrade from 12.0.3 to 12.1.3.
• Managed/Supported a team to fill teh GAP in teh Financial Flow and Procure to pay flow.
• Co-ordinate and lead teh entire phase of teh project which included initial operations analysis, business process re-evaluation, testing, training conversions, customizations and documentation and implementation of modules
• Worked on Data Masking, Data Trimming and Purging activities.
• Worked on Customization of XML reports
• Developed interfaces between Oracle and legacy systems.
• Experience in developing web-services using Oracle SOA (BPEL, XML, WSDL) to integrate Oracle EBS to other non- database systems.
• Preparation & Execution of Test Scripts for all Financial Modules

Environment: Oracle Applications R12 INV, PO, AP, AR, GL, iProcurement, Cash Management, OCO, OIC, Oracle 11g,PL/SQL, TOAD, SQL*PLUS, SQL*LOADER,HP Quality Center Forms 6i, Reports 6i, Discoverer10g.

Confidential, Chicago, IL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Analyzing teh Business Requirements and System Specifications to understand teh application
• Incident and Problem / Service Management of all teh applications supported
• Involved in functional setups as per customer requirements
• Involved in teh preparation of Detail Design, technical design and specification.
• Developed an Interface program to load teh item, invoices and customer data from flat files into oracle Tables which Validates teh data using PL/SQL program and populated teh Payables
• Monitor Database Backups and resolve any issues
• User Account / Access Management
• Executing Data fixes for application teams
• Weekly and scheduled Basic Cloning / Refreshes
• Performance monitoring of critical database and infrastructure components
• Lock/Latch/Memory issues resolution
• Customized PL/SQL Procedures as per client
• Involved in Creation and review of test Scenario and test Case based on requirement and design document
• Involved in Functional Testing
• Tracking teh Test Plan/Test Specification vs. Requirements
• Involved in design documents and code migration activities.
• Worked on form personalization’s to fulfill teh customer requirements and Business demand
• Co-ordinate and lead teh entire phase of teh project which included initial operations analysis, business process re-evaluation, testing, training conversions, customizations and documentation and implementation of modules
• Worked on Customization of XML reports
• Worked on Oracle Alerts to send Email, based on some changes in teh custom table

Environment: Oracle ApplicationsR12 INV, PO, OM, AP, AR Oracle 9i, PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Forms 6i, Reports 6i, Discoverer10g.

Confidential, Libertyville, IL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Preparing teh Business requirement documents wif teh business rule associated wif customers screening.
• Identified teh Gap in AS-IS Business process and listed out RICE Components and associated configurations to meet teh requirements.
• Demonstrated Livingston application and screening process to teh Client for each of their business scenarios.
• Executed all teh configurations to set up SIT and UAT in AR and SLA modules.
• Preparing of Functional specs for various customized components developed.
• Preparing test cases & test plan for all teh integrations.
• Experience in developing web-services using Oracle SOA (BPEL, XML, WSDL) to integrate Oracle EBS to other non- database systems.
• Worked wif all intermediate systems for Integration testing
• Involved in Unit testing and creating Test cases.
• Created AOL objects for all development work.
• Responsible for Creating/ registering AOL objects like Lookups, Concurrent programs, etc.
• Developed teh Business Events to achieve teh business requirements
• Functional testing of teh application and customizations

Environment: Oracle Applications R12 TCA Oracle 9i,PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Discoverer10g.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in functional setups as per customer requirements
• Involved in teh preparation of Detail Design, technical design and specification.
• Developed an Interface program to load teh item, invoices and customer data from flat files into oracle Tables which Validates teh data using PL/SQL program and populated teh Payables interface table through a Concurrent program, which in turn submits a standard tables Interface program.
• Created CSV, text files by using teh macros for Exclusion and Inclusion purposes.
• Developed PL/SQL packages for validations of data and used API to populate teh data in base tables
• Worked on AOL objects for creating custom tables, menus, responsibilities, concurrent programs, request sets etc
• User Training and production support.
• Worked on customizations of Pack slip and Pick Slip reports to fulfill teh customer requirements
• Worked on Optio DesignStudio7.8 Prepared layout design for optio printing for Notice to shipment and picking and packing list.
• Developed interface programs, which will import all items, item categories and item attachments that are created using teh Item Open Interface.
• Involved in developing of new interfaces, customization of existing interfaces and developed new reports and customizing existing Reports and Forms to 6i to meet teh business/client requirements.
• Worked on BMC tool for Production support to resolve teh BMC tickets.

Environment: Oracle ApplicationsR12 INV, PO, OM, AP, AR, PA, GL, Oracle 9i,PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Forms 6i, Reports 6i, Discoverer10g.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in teh preparation of Detail Design, technical design and specification.
• Responsible to debug teh workflow errors like duplicate rows in modules schema and not closing teh workflow, and also creating huge number workflow rows for PO, OM, AR, BOM, WIP workflows.
• Worked on customizations based on teh user requirements and Business demand
• Used Form Personalization’s on FOB Customizations
• Worked on Asia and Europe roll-outs.
• Involved in developing of new interfaces, customization of existing interfaces and developed new reports and customizing existing Reports and Forms to 6i to meet teh business/client requirements.
• Analysis of business needs and requirements, identifying teh gaps and issues for Order managements, inventory, AR and Purchasing modules
• Worked on BMC tool for Production support to resolve teh BMC tickets.
• Working on many customizations and enhancement requests based business demand
• Working on impact analysis for patch project
• Managed/Supported a team to fill teh GAP in teh Order to cash and Procure to pay flow.
• Co-ordinate and lead teh entire phase of teh project which included initial operations analysis, business process re-evaluation, testing, training conversions, customizations and documentation and implementation of modules
• Developed interfaces between Oracle and legacy systems
• Involved in EDI process on production issues

Environment: Oracle Applications 11i INV, PO, WIP, BOM, OM, AP, AR, PA, GL, Cash Management Oracle 9i, PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Forms 6i, Reports 6i, Discoverer10g.