SUMMARY

• Over 12+ 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.
• Hands-on involvement on all phases including Definition, Operations Analysis, gathering business requirements, GAP analysis, process mapping, solution design, configuration, Customization, Build, Transition, /Production cut over, user training, support and maintenance experience of Oracle applications.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Technically proficient in RICEW/CEMLI components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Implemented and supported various stages of Oracle Supply Chain Management, Procurement and Manufacturing, Order-to-Cash and Procure-to-Pay life cycles for the last Ten (10) Years.
• Experienced in Customizing Oracle Forms with Forms Personalization.
• Experienced in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).
• Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations.
• Fullest experience and expertise on Advanced Pricing.
• Well versed with AIM Methodology. Created of Standard Documents like BR100, MD050.
• Functional work experience on Oracle SCM Modules (OM, PO, Inventory, i procurement, Discrete Manufacturing (BOM, WIP), AP).
• Worked in Production support and involved in activities like monitoring, trouble shooting, documenting.
• Worked with oracle support, using metalink, to resolve issues using knowledge base, SR/TAR..
• Good experience in creating Unit Test documents.
• Ability to quickly learn business applications and demonstrated analytical and problem solving skills.
• Ability to facilitate system review, data analysis and involved in various SIT, UAT and Go-Live phases of different implementation and upgrade projects.
• Good business experience and background regarding the Supply Chain Management functions.

TECHNICAL SKILLS

Manufacturing: Discrete, Oracle Inventory (INV), Bill of Material (BOM), Work In Process (WIP), Costing (CST).

Procurement: Purchasing (PO/PUR), I Procurement, Supplier Management.

Sales and Distribution: Quoting, Order Management (OM), Shipping, Warehouse Management (WMS), Drop Shipment, Advanced Pricing (QP), ATP.

CRM: Service Contracts (OKC/OKS), Install base (IB).

Finance: TCA architecture, Account Receivables (AR), Account Payables (AP).

AOL: System Administration, Application Object Library (AOL)..

Methodologies & Documents: Oracle’s Applications Implementation Methodology (AIM), Oracle documents including BP040, BP060, BP070, BP080, RD050, BR010, BR030, BR100, BR110, MD040, MD050, MD060, MD070. Oracle SQL, PL/SQL 9i, 10G, Toad.

PROFESSIONAL EXPERIENCE

Confidential, California

Oracle Apps Technical Consultant

Responsibilities:

• I have involved in Project Revenue, Cost Conversions and Open & Paid Invoice conversion.
• Have good knowledge on PA business flow like labor processing, cost and revenue distribution steps.
• In financial side have good knowledge in sub ledger accounting how the postings are happing. SLA links between external modules to GL module.
• Developed custom applications using OAF JDeveloper in the implementation
• Involved in Customer page creation and Invoice page creation using OAF
• Worked Concur expense reporting integration with SOA
• Implementation of request enhancements/new development.
• Involved in XML Publisher reports creation and modifications
• XML Template design using rtf and xl formats and Data definition bursting file creation
• Worked on Oracle reports 10G and forms 10G, implemented many reports using developer 10g.
• Prepared Technical documentation for all customized reports.
• Developed oracle project costing page using ADF JDeveloper 11.1.1.5 in Oracle Project Accounting Modules
• Developed custom applications using OAF JDeveloper 11.1.1.5 in Oracle Project Accounting Modules
• Implementation of request enhancements/new development.
• Worked on the ADF applications with Oracle Applications Server and Web Logic Server.
• Developed several features using custom ADF components for Table/Shuttle/Dynamic/Session/ Global Scoping of applications
• Created procedures, packages, sql and pl/sql for business requirement.
• Created the technical design document that describes the technical implementation.
• Involved in AP check printing, payment build format (Creating invoices, vendors, bank account and batches to process the forms to the clients)

Environment: Oracle Applications R12, Oracle 10g, Reports 10g, Forms 10g, PL/SQL, SQL* Plus, XML Publisher, OAF, AP, AR, GL, PA, FA.

Confidential

Lead Consultant

Responsibilities:

• Data Extraction, Cleansing, Transformation, Formatting and Loading.
• Data Migration strategy, Preparation of Conversion specification documents, Templates, Data Validation & Load file preparation.
• Items conversion, Item On hand conversions support and reconciliation.
• BOM updates, Routing Updates migration to support RA Model changes.
• Sourcing Rule and Sourcing Rule assignments migration.
• Responsible for Analysis on Upgrade impact on Customized extensions and Existing Business Flows.
• Cutover plan preparation, identification of the cross functional tasks, setups, access, data migration, validation, publishing the cutover plan through share point, regular follow up on task completions and respective timelines.
• Analysis and modifications to the OE Order line and Header Workflows.
• Working with Cross functional teams on Common Objects migration, GOCC tickets.
• RFC creation process, FRS, TRS preparations, participation in Functional and Technical Reviews, PVCS upload and code migration.
• Hard Code removals, OE Holds hard coding removals, AR Transaction type hard code removals, PO Line type default hard code changes, Mapping with lookups.
• Pick slip report changes, supporting the shipping process, integration with WADV and TRAX systems for Confidential shipping process for RMT.
• Weekly Tech Track review calls on key accomplishments, Risks, decisions and next setups with business leads and IT Managers.
• Work with development team to build the functionality for the new requirements in INV, PO, OM modules and testing in DEV instances before migrating it to UAT and PROD instances.
• Supporting the business in development and test cycles, CRP1/CRP2, SIT and UAT.
• Supporting the CRP end to end demos, issue resolution.
• Regular RICEW/CEMLI list development status calls on progress, interaction with respective track leads for clarifications.
• FNDLOAD to migration AOL objects from one instance to other.
• Data migration for Navision, Mfg pro and Flip the Factory.
• Interaction with QA team for Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including Advanced Pricing, OM, INV, PO, BOM, WIP, AR, AP.
• Vastly experienced in troubleshooting the issues, providing the workaround and finding the Root Cause of the issues.
• Gathering the requirement details from the super user and enhancing the Oracle custom reports and forms.
• Analysis on current wave CEMLIs as part of R12 Retrofit to know the objects for retirement and future wave migrations.
• Project Delivery, Resourcing, establishment of Support Process & effective monitoring.

Environment: Oracle 9i/10g(SQL, PL/SQL), TOAD, Oracle Reports, Oracle Forms, BI Publisher, Work flows, Oracle E-Business Suite 11i and R12, Purchasing, Inventory, Order Management, General Ledger, BOM, WIP, Accounts Payables, Accounts Receivables, procurement, Application Developer, System Administrator, Oracle Alerts.

Confidential

Lead Consultant

Responsibilities:

• CEMLIs retro fitment and testing based on the business requirements.
• Code maintenance, version control, code migration and documentation.
• Functional and Technical review, business signoffs, Code staging.
• Item On hand Conversion and reconciliation.
• Sales order process integration with network tracker, issue resolution in Workflows.
• Issue prioritizations, issue resolution, tracking, regular issue follow up calls.
• Work with development team to build the functionality for the new requirements and testing in DEV / QA instances before migrating it to UAT and PROD instances.
• Supporting the business in various development and test cycles, SIT and UAT.
• Issues fixes, retro fitment of the custom min max planning process.
• Understanding and troubleshooting, resolving issues and helping development team to resolve technical issues.
• Data Migration, Business System Integration Testing, Data cleansing.
• Preparing business requirement, functional design documents and working with the development team to build the custom reports in various applications in Oracle, testing the report and migrating it to the other instances.
• Analysing the issues and finding out the root cause of the problem to get a permanent fix for the issues in various applications.
• Replacing the critical issues in Test instances to fix the problem in PROD instance
• Resolving the issues on Pending Transactions from various applications.
• Working on Flex fields- segments, value sets, values and look up codes.
• Understanding the current business process and troubleshooting the Production issues to find the Root Cause and replacing the issues in TEST instances and testing the resolution / work around to fix the issues in Production. Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules.
• Providing the Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including Advanced Pricing, OM, INV, PO.
• Extensively worked on Change Requests (CR's) and preparing the BRD's, FD's on OM.
• Extensively worked on troubleshooting the issues on Custom Concurrent Programs in Oracle, providing the workaround and finding the Root Cause of the issues.
• Extensively worked with the development team to build the Oracle custom forms in various applications and testing the functionality before migrating it to the other instances.
• Worked extensively on Item categories, Category sets, Category codes and prepared the setups for Item categories in Inventory, Purchasing, Order Management modules.
• Extensively worked with Oracle Metalink on a few SRs (TARs) to fix the issues in Oracle Supply chain management, Financials, Manufacturing areas
• Involved in setup and implementation of Service Contracts depending on functional setup changes/enhancement.
• Involved in conversion programs for Items using Oracle PL/SQL and Standard APIs.

Environment: Oracle E-Business Suite 11i and R12, Purchasing, Inventory, Order Management, Service contracts, Application Developer, System Administrator, Oracle 9i/10g, SQL, PL/SQL, XML Publisher,TOAD.

Confidential

Lead Consultant

Responsibilities:

• Responsible for the delivery of the Custom technical & functional solution by coordinating offshore onsite teams.
• SCM Distribution CEMLI objects Impact study and retro fitment.
• Responsible for functional Setups for the respective tracks, Preparing business requirement documents (BR100)s and other design documents as MD050.
• Troubleshooting the production issues on various applications (Purchasing, Inventory, Order Management, Work in Progress, Bill of Materials, Material Planning, etc), replicating the issues in TEST environment, and testing the fix prior to apply in Production instance.
• Extensively worked on preparing test scenarios, test scripts on different applications to help the users for better understanding the application.
• Created Oracle service requests and fixed the bugs in inventory and order management with the help of Oracle support. Tested the fix in TEST instance prior to apply in other instances.
• Prepared the functional design documents to explain the functionality of the custom concurrent programs in Oracle Costing application by analysing the PL/SQL programs
• Coordinated, supervised, and lead design efforts to Build the new system.
• Supplier Audit Report reconciled for the Duplicate supplier data.
• Purchasing and payment options for supplier sites setups.
• CRP / UAT Cutover time before upgrade Count has been Taken and after upgrade count will be compared with data accuracy.
• Extensively worked on troubleshooting, fixing the issues on Internal requisition, Approved Supplier list, Request for Quotes in Oracle Purchasing
• Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle
• Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing
• Creating the Training material documents on various applications in Oracle
• Creating Inter-org transfer setups for Inventory application in Oracle R12
• All Personalization affectivity compared with 11.5.10 and R12.
• All Business Flows Tested end to end Cycles.
• Enhanced Functionality in R12 User manuals created and user training provided.
• Supplier migration issues and new Supplier setup’s.
• Supplier and key purchasing and payment setup information for supplier sites.

Confidential, San Jose, CA

Team Lead

Responsibilities:

• Business Requirement Analysis.
• Preparation of the scripts for the various setups like COA, Location, Primary Ledger, Secondary Ledger, OU and Inventory organization creations.
• Defining the Organization structure for new Buy-Cell entity.
• Setup for GL track for different instances.
• Performing the module level Setups,P2P and O2C Setups.
• Creation of inventory orgs, sub inventories, shipping networks, org responsibility assignments.
• Functions, menus and value sets, concurrent programs, request groups creation and migration.
• Setups for Purchasing options, Receiving options, Approval groups, Approved suppliers
• Setups for Financial options, Payable options, Bank/Bank Branches/Bank accounts setups
• Suppliers, Payment terms
• Scripts development for Purchase orders migration, AP Invoices migration.
• Coordinating and understanding of the setups dependencies between different tracks.
• Development of RICE components and Testing
• Kintana package creation and code move to different instances.
• Preflow and support activities for different Test cycle instances.
• Supporting TCA, TCB cycles, Code review activities.
• Educating cross flow team in setups dependencies.

Environment: Oracle E-Business Suite 11i and R12, General Ledger, Accounts Payables, Accounts Receivables, Order Management, Oracle Inventory, Oracle Purchasing, Oracle 9i/10g, SQL, PL/SQL, TOAD, Forms 6i.

Confidential, Atlanta

Instance Lead

Responsibilities:

• Responsible to support complete Order to Cash and Procure to Pay flows.
• Quick work around and resolutions on Priority issues.
• As an offshore lead, responsible for the quicker resolution of the production issues.
• Close monitoring on the cases, periodic update to the client, working with oracle on out of box issues by raising the SRs, weekly calls to update the status on issue, daily call to update the status on critical issues.
• Supporting the bug fixes code migration and Smoke test activities.
• Supporting the Sales order/Line workflows and Purchase order approval process.
• Worked closer and steadier to bring the system to a stable usage and rid of post go live issues and improve its performance as a whole.
• Conforming to the Quality Procedures and Standards related to the project.

Environment: - Oracle Applications (11.5.9), Oracle Supply chain modules, Oracle9i, Sql, Pl/Sql, Toad, Oracle Reports, Oracle Forms, Workflow, XML Publisher.

Confidential

Onsite SCM Consultant

Responsibilities:

• Understanding the AS IS process, client business flows, requirements gathering, gap analysis, preparation of the Solution design documents.
• Attend Business Process and Knowledge Transition Sessions with IT & Business Owners and Mapping Customers requirements into Oracle.
• Performing module level setups, integration of other modules with Inventory, Purchasing, and OM.
• Involved in various Functional setups of Inventory, Order Management, Purchasing, and System administrator modules.
• Worked on creating the Sourcing rules to develop the continuity planning and to create auto Requisitions and Purchase order based on Sourcing Rule.
• Created all the functional documents BR110, BR150, MD200 and CF250 for the implementation of SCM modules.
• Worked closer and steadier to bring the system to a stable usage and rid of post go live issues and improve its performance as a whole.
• Involved in development of new custom objects, documented Test scripts, Scenarios and test results.
• Supporting the technical team to help understand the business requirements, performing the required setups to perform the unit testing.
• Configure R12 test & production instance and creating Setup documents - BR100.
• Involved in data migration of Items and worked on conversion functional design and explained technical team for script development.
• Worked on the functional design of customization of Requisition Account generator for iProcurement requisition and functional testing.
• Worked on the functional design of customization standard PO report output and functional testing.
• Developed P2P User training guides using Oracle User Productivity Kit (UPK).
• Involved in SIT,UAT phases of implementation.
• Post Go-live stabilization support.
• Post Go-live now involved in Production support and maintenance of modules (PO, iProcurement, iSupplier, Inventory, BOM,MRP and Trade Management module).
• Worked closely with Business Analyst on various major enhancement Projects for the process improvement of existing custom program for various modules of MRP, Inventory, BOM and PO.
• Involved in design and development of custom program to automate Item Organization assignment in Inventory module.

Environment: - Oracle E-Business Suite 11i, Oracle Inventory, Oracle Purchasing, General Ledger, Accounts Payables, Accounts Receivables, Order Management, Oracle 9i/10g, SQL, PL/SQL, TOAD, Forms 6i and Oracle Reports 6i.

Confidential

SCM Consultant

Responsibilities:

• Interacted with client during the Implementation process, Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Application.
• Involved in Implementation and support of complete end to end Procure to Pay Process.
• Performed module level setups in SCM modules.
• Analyzed and understanding the existing business process for various custom solutions that client has and provided the feasible solutions.
• Involved in data migration activities and module level setups and setup a new operating unit.
• Defining profile options, lookups, value sets and values, DFFs and KFFs.
• Worked on creating the Sourcing rules to develop the continuity planning and to create auto Requisitions and Purchase order based on Sourcing Rule.
• Involved in Implementation and support of complete end to end Order to cash Process.
• Worked closer and steadier to bring the system to a stable usage and rid of post go live issues and improve its performance as a whole.
• Involved in development of new custom objects and documented Test scripts, Scenarios and test results.
• Lead the maintenance of issue tracker.
• Involved in End user training.

Environment: - Oracle9i, Oracle Applications (11.5.9), Sql,Pl/Sql, Toad,Oracle Reports

Confidential

Responsibilities:

• System Document Analysis.
• Coordination with the users to utilize the existing functionality of Oracle 11i for the custom program in 10.7
• Up gradation of the 10.7 custom program code by validating the tables of 10.7 with etrm and using the valid tables in 11i against the obsolete tables.
• Testing the program functionality in 11i with the given test plan parameters by PPG (client), and to compare the results of 10.7 and 11.5.9.
• Preparation of TAC (Technical Analysis of Changes) document for all the changes that we made to the code.

Environment: - Oracle applications 10.7, Inventory, Purchasing and Order Management, Sql, Pl/Sql, Toad, Oracle Reports, Oracle Forms,, SQL *Loader.