SUMMARY

• Supply Chain professional with 6+ years of Techno Functional IT experience on Oracle EBS (R12.R11i) in Supply Chain Management (SCM), Manufacturing (MFG) and Distribution modules.
• Expertise in analyzing business requirements as a part of implementation, up gradation projects and provides extensive functional support for Post - Production Support projects in SCM and MFG Modules of Oracle Applications R12 and 11i.
• Extensive knowledge in Oracle EBS modules including Inventory (INV), Order Management (OM), Purchasing (PO), Work In Process (WIP)& Shipping (WSH).
• Good experience in Application Set up Activities and Production Support of INV, BOM (Bill of material),OM, PO.
• 2 Complete cycle implementation experience in R12.
• Strong technical and functional knowledge in business flow like P2P (Procure to pay) and O2C (Order to Cash).
• Experience in using SQL, PL/SQL, data loader and Toad.
• Good experience on Data conversion and Data extracts for various projects from different legacy systems.
• Hands on experience in creating and maintaining Oracle AIM (Application Implementation Methodology) documents such as RD-020, BR-30, BR-100, TE-040, MD-050, CV-040 and BP-080 (Expertise in Analysis, design and documentation of client’s business requirements).
• Expertise in CEMLI (Configurations/Customization, Extension, Modification & Integration.
• Technical expertise in RICE (Repots, Interface, Conversion & Extension)
• Hands on functional experience: Requirements gathering, GAP analysis, Module setup, Configuration, training end users.
• Good Command over Functional aspects including implementation, Customization, Conversion, Interface, up gradation/Migration works in Oracle Applications (R12 and Prior versions).
• Technical activities: Interfacing with users, estimating work, producing documentation, and proving end user support.
• Experienced in work environments requiring direct client interaction during requirement gathering, gap analysis, and product implementation & customization phases
• Extensive experience in customizing and developing Reports in Oracle applications using Oracle Report Builder, Discoverer reports, XML publisher
• Well versed in migration of data into corresponding interface tables using a combination of PL/SQL Procedures, SQL* Loader or UTL FILE.
• Good knowledge of XML publisher template.
• Experience in configuration of R12 modules.
• Good knowledge of API.
• Expertise in loading data from .xls files to base tables.
• Basic Knowledge of OAF personalization.
• Proficiency in implementation process mapping, functional requirement analysis, train end users.
• Good working experience in communication between technical and non-technical clients.
• Proficient in problem solving and understand risk and collaboration.
• Excellent communication skill (written and oral), good interpersonal skills, leadership skills and team skills.
• Sound knowledge of API and interface tables as well as base tables.
• Willingly to learn other modules as per requirements.

TECHNICAL SKILLS

ERP Packages: Oracle Applications Release R12x, 11i

Modules: INV, OM, PO, BOM, WIP, AP, O2C, P2P cycles

Database Tools: SQL* Loader, Data loader pro, TOAD, XML/BI, SQL* Plus

Languages: SQL, PL/SQL, C, C++

Data base: Oracle 11g/ 10g, MS SQL Server

Domain: Supply chain management, Manufacturing and distributions

PROFESSIONAL EXPERIENCE

Confidential, Rockville-MD

Oracle Apps Techno functional Consultant

Responsibilities:

• Mainly responsible for gathering requirements for business.
• Setup documents in PO,INV, AP,AR.
• Created MD-50 and MD-70. Also set up BR-100.
• Upgrade from 11. .1.3.
• Find functional and technical gaps and AS IS finding.
• Worked on PANAYA to identify missing information to change the query as per R12.
• Customized the Accounts Payable (AP) Vendor Entry Form as per business requirements.
• Customized Service Request form as per business requirements.
• Worked on Inbound Interface (Bank of America/Amex) which receive file from third party server and populate data into Cash Management base table.
• Tested and retrofitted objects like alerts, triggers, functions, procedures etc.
• Developed oracle report for Inventory detail report
• Worked on customizations in Purchase Order Form.
• TEMPHas created XML Publisher Data definition and template definitions.
• Worked on Oracle reports and retrofitted the same.
• Worked on concur, Accelim, workday Interfaces.

Environment: Oracle R12.0.6 / R12.1.3 INV,, Purchasing & AP,AR, Purchase Order Report using XML Publisher, TOAD, Report builder, Form builder

Confidential, Austin, TX

Oracle Apps SCM Techno functional Consultant

Responsibilities:

• Understanding and Gathering the requirement from business super users and document the same in Business requirement & analyzing the Gaps. Responsible for Customizations.
• Documentation and set up for INV, BOM and PO module.
• Designed and documented the technical specifications of an Interface (MD70) using the available functional specification (MD 50).
• Worked with the project team in setup and configuration of INV, BOM, and PO.
• Developed a program to Migrate the data from legacy systems into the temporary tables in Order Management (OM). Successfully designed the custom API to validate the data in staging tables before transferring into the interface tables.
• Identified the process and mapped the business requirements with process flow charts and setup documents.
• Created Inventory Orgs, Item Master, Item Categories and Catalogs, Sub inventories and stock locators
• Created setup documentation for Inventory, Bill of materials, worked with shop floor super users to identify and define Departments, Resources, Operations and Routings for BOM items.
• Created documentation for Purchasing module which includes request for quotation (RFQ) and requisition.
• Created Forms and reports for various modules as well as form customization.
• Set Price list, Qualifier and Modifiers and Formulas for Advanced Pricing (AP).
• Defined Flex fields for various modules.
• Did setups for Order Management(OM) for Document Catégories, Document Séquences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping rules and Successfully created Orders, Attached pricelists, Pick released, Ship confirmed and transferred Order Information into Account Receivables (AR).
• Customized sales order window in Order management.
• Implementation of synchronized supply chain operations to have small investments in inventory. Synchronized Supply chain operations with every trading partner to operate under a new set of rules, to maximize profits.
• Worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL*Loader and PL/SQL.
• Performed a GAP analysis for the existing system to recommend improvements and customizations.
• Prepared site specific test script. Perform complete cycle testing during the implementation life cycle.
• Developed PL/SQL Packages, Procedures and Functions.
• Good exposure on Procure to pay (P2P) and Order to cash (O2C) cycles.
• Customized Standard reports in OM, WSH and AR using XML publisher & Report Builder 10g.
• Defaulting rule set up in order management.
• Developed custom conversion and interface programs to Import Item Category from legacy system to Oracle INV module.
• Developed a custom Interface to handle the Inbound Purchase Order (850) through EDI, to validate the additional Header and line information.
• Developed the BOM conversion code to convert the data from Focus to oracle system and registered as a Concurrent Program.
• Personalized page to enable submit button on the train flow of iProcurement
• Complete cycle implementation in R12

Environment: Oracle R12.0.6 / R12.1.3 ASCP, INV, WIP, BOM, Costing, iProcurement, iSupplier Portal, Purchasing & AP, Designed and developed Customer Invoice, Purchase Order Report using XML Publisher

Confidential, Miami, FL

Oracle Apps SCM Techno functional Consultant

Responsibilities:

• Understanding current business and requirements for inventory warehouses.
• Used RICE (Reports, Interfaces, Conversion & Extension) for SCM module
• Designed and developed new Form using TEMPLATE.fmb for Purchase Returns irrespective of Purchase Order Number.
• Did forms personalization to make view only forms.
• Customized the Sales Order Invoice Detail Report in Order Management.
• Customized the Accounts Payable (AP) Vendor Entry Form as per business requirements.
• Registering Custom Applications, Concurrent Programs, Tables
• Designed and developed Customer Invoice, Purchase Order Report using XML Publisher
• Defining Concurrent Programs and Executable.
• Adding Descriptive Flex Fields.
• Responsible for configuring Inventory and purchasing modules for various warehouses.
• Worked on Procure to pay (P2P) and Order to Cash (O2C) full cycle.
• Developed oracle purchasing process.
• Involved in Setting up requisition for each warehouse.
• Responsible for Set up request for quotation (RFQ).
• Responsible for Purchase order (standard purchase order& direct delivery).
• Responsible for Oracle purchasing end to end process.
• Involved in Setting up templates and calendar for each warehouses.
• Defined item attributes and item categories, Unit of measures (UOM).
• Create master items organizations.
• Worked on Drop shipment in Order Management.
• Worked on Advance pricing module. (Define modifiers, pricing organizer, formula, price list, etc)
• Worked on purchasing backend tables.
• Worked with R12 up gradation and implementations
• Resolved several issues by coordinating with Oracle Support Team through Service Requests of all levels of severity including data fixes on production system during go live.
• Personalized page to enable submit button on the train flow of iSupplier
• One complete cycle experience in R12.
• Designed and developed Customer Invoice, Purchase Order Report using XML Publisher

Environment: Oracle Applications: 12.1.1, PO, INV, TOAD, PL/SQL Developer. AP, OM, INV, PO XML publisher, report builder, form builder.

Confidential, FREMONT, CA

Functional Consultant

Responsibilities:

• Analyzed use requirements, functionalities and mappings within BOM, Inventory and OM Modules.
• Provided manufacturing functional expertise during development of manufacturing execution system.
• Involved in setting up the Order Management, Shipping Execution modules after finalizing on the requirements
• Provided Super User and End User supports.
• Identify the features enhancements in R12 in the flow for Order to Cash and Procure to Pay.
• Provided support and coordinated with the financial team for O2C and P2P Process.
• Created set up documentation for Inventory, Bill of Materials and Order Management.
• Involvement in framing out data conversion strategy.
• Interaction with client for requirement.
• Set price of items in Advance Pricing (AP)
• Worked on a program for Conversion of Purchase Orders and Purchase Requisitions into Oracle PO.
• Worked on a program for Conversion of Invoices into Oracle AP.
• Worked on a program for Conversion of GL Balances from legacy into
• Set up Advanced Pricing (Qualifier, Qualifier attributes, Unit of measure)
• Set up Return Material Authorization (RMA) & pricing agreement in Order Management.
• Created Complex PL/SQL Stored procedures, functions, Triggers.
• Continuous interaction with users and understanding user requirements. Modification and creation of forms and reports with new business requirements.
• Created Min max planning.
• Defined item category and category sets.
• Involved in Setting up stores catalogs, mapping catalogs to purchasing categories and defined expense account rules.
• Set up templates and calendar for each warehouses.
• Defined item attributes and item categories, Unit of measures (UOM).
• Used SQL*Loader for import into interface tables, and PL/SQL blocks for complete validation of data and inserting into base tables
• Customized Standard reports in OM, WSH and AR using XML publisher & report builder including pick slip report, sales order acknowledgement report.
• Worked on Application Object Library and created concurrent Programs for OM and PO modules.
• Created reports using XML Publisher as per client requirements with use of Report Builder tool
• Extracted data from legacy system to Oracle data base table with halp of API’s and standard interface tables.

Environment: Oracle R12, Modules: Oracle Inventory (INV), Oracle Order Management (OM), Oracle Purchasing (PO), Oracle Advanced Pricing (AP), Oracle Shipping, TOAD, PL/SQL Developer, XML publisher, report builder, form builder.

Confidential, MN

Oracle Functional Analyst

Responsibilities:

• Performed business analysis, process design, requirements analysis, and solutions design using Oracle AIM methodology.
• Was responsible for doing inventory setups such as defining locations, organizations, sub inventories, units of measure and items.
• Determined and defined the workday calendar.
• Defined and created the shipping networks.
• Determined the process for Min-Max planning.
• Writing and reviewing documents (MD 050, MD 070, cv010, cv060).
• Responsible for configuration of the Bill of material module.
• Worked on form personalization in Order Management and Inventory modules.
• Was responsible for system administrator functions including setting up users, defining responsibilities, determining request groups, and setting menus.
• Involve with user acceptance testing (UAT) and end user training
• Used SQL* Loader control file to import the customer information provided in the form of flat files into staging tables.
• Developed the templates for several reports using XML publisher.
• Developed a custom layout XML format according to the user

Environment: Oracle Applications: 12.1.1 (PO, INV, BOM, OM), Oracle reports, TOAD, PL/SQL Developer, XML publisher, report builder, form builder.

Confidential

Oracle Functional Analyst

Responsibilities:

• Studied the existing business process and conducted meetings on client business overview.
• Prepared business requirements documents for purchasing and Order Management.
• Defining and setting up of complete Procure to Pay (P2P) cycle sets up from entering the requisition in purchasing to entering the receipts and creating of the invoice in account payables module to support business requirements
• Created requisition templates and approved suppliers list
• Setup stores catalogs, mapping catalogs to purchasing categories and defined expense account rules.
• Assisted in doing setups for shipping parameters like picking rules, pick slip grouping rules for Order management
• Designed and developed Exception Reports in Custom Interfaces using XML Publisher.
• Write Test scripts and validate applications.

Environment: Oracle Applications: 11.5.10.2, PO, OM, Oracle reports, TOAD, PL/SQL Developer. Report Builder, Form Builder, XML Publisher.

Confidential

Oracle Techno functional Analyst

Responsibilities:

• Responsible for developing and customizing Reports and concurrent programs as per the client requirements in Oracle Apps 11i PO module.
• Registration of concurrent programs, defining value sets and parameters for customer reports.
• Development and modification of user friendly Oracle Forms and Reports for inventory procedures, stock ledger processing and management reporting etc. using Forms 6i and Reports 6i and PL/SQL etc.
• Created Complex PL/SQL Stored procedures, functions, Triggers.
• Designed Data flow diagrams, E-R diagrams, Data structure, Tables, triggers, indexes, constraints etc. using SQL, PL/SQL, TOAD, SQL*plus etc.
• Unit integration and testing, User training and troubleshooting.
• Import and Export of data between instances and schemas and data loading using SQL*loader.
• Continuous interaction with users and understanding user requirements. Modification and creation of forms and reports with new business requirements.
• Developed report in XML publisher for

Environment: Oracle Applications: 11i (11.5.10.2), PO, INV, Oracle reports, TOAD, SQL, PL/SQL Developer, SQL* Loader.