SUMMARY

• Over 12 years of experience in Oracle Applications OTC and P2P, worked as a functional lead for the Implementation and Conversion and set up of Oracle Distribution/ Manufacturing / Supply chain / financial applications. Experience includes managing projects using Oracle’s AIM methodologies.
• Experienced in Requirement Analysis, Data Mapping, Gap Analysis, Design, Development, Implementation, Upgrade, RICE Developments, Data Conversion/Migration, Testing and Production Support in Oracle EBS 11.5.10, R12 versions and related products, tools and integrations with third party tools and external Applications.
• TEMPHas broad experience in all phases of design, development and implementation of Order Management, Inventory, WMS, Purchasing, me - Procurement, me-supplier, MRP, ASCP, MSCA, Advanced Pricing, WIP, BOM, Receivables, EDI, and GL.
• Experienced in all phase of Project Implementation on both Functional and Technical activities. Completed multiple full lifecycle implementations in OM, INV, PO, WMS, MSCA, AR, AP, GL, WIP, BOM, EDI modules.
• Also have broad experience with Oracle Apps technical architecture and Oracle tools and experienced in Pl/Sql,, Workflow, Forms and Reports, Discoverer, NOETIX,OA Framework and XML Publisher Reports .
• Serve as a liaison between the business and IT to provide Oracle Functional and technical business solutions dat meets needs of client managers and other stake holders.
• Strong Documentation skills and analyzing the business processes and on developing detailed user requirements and functional specification documents and strong process management, analytical skills, and experience in quality assurance testing
• Ability to lead and motivate high potential project teams to ensure timeliness and quality of deliverables.
• Currently working as a Business IT Analyst for Confidential &T. Extensively Involved in Analysis, Design, Testing, and Maintenance, Data Migration, Data mapping and Quality Related Activities with SOX requirement for full life cycle of the ERP project.
• Self-motivated and results oriented collaborative thinking, experienced in managing multiple competing priorities and tasks effectively across multiple functional and technical tracks.
• Strong Functional noledge on Oracle EBS 11.5.10 and R 12 implementation projects in Order Management, Inventory Management, Purchasing Suite, Work in Process, Bill of Materials, MSCA, WMS, ASCP and Oracle Financials Receivables, Payables and General Ledger and Project Accounting.
• Participation in the overall process improvement of the functional areas. Analyze complex user information flows and needs. Creation of functional specs and Application configuration, User acceptance testing, training and problem resolution etc.
• Participation in medium to large complexity projects, with responsibility to drive projects from concept through final implementation.
• Development of detail work plans, schedules, budgets, resource plans and status reports user training documents, process documents and story boards.
• Leading functional design and configuration design activities in collaboration with development teams and Manage expectations throughout all levels of project management lifecycle
• Thorough understanding of the process flows of Oracle Supply Chain Management OTC, P2P and integration with Oracle Financials and Journal Interfaces.
• Developed various MD50 interface designs for the complex High Volume Order Process interfaces like Sales Orders Interface, Shipping Transactions Interface, Open Purchase Orders Interface, Receiving Transactions, Customers and Customer Invoices Interface and Calculate Pricing Interfaces ‘Shop Order Engineering Items and BOM Interfaces ’, ’BOM Routing Interface’, Item Categories Interface, Item Attributes, Inventory Locators and Onhand Conversions, etc.
• Strong noledge of configuring EDI setups using Oracle E-Commerce Gateway, setup includes Trading Partners, mapping data between EDI translation platform and Oracle EBS system.
• Conversant on integration of 3rd Party reporting, printing, scheduling requests through Appworx and Loftware.

TECHNICAL SKILLS

Packages: Oracle Applications R12, 11.5.10.2, 11i, 11.5.9, 10.7, 11.0.3Modules Oracle Manufacturing Order Management (OM), Inventory (INV), Purchasing (PO), me Procurement, me supplier PortalAdvanced Pricing (QP), Work in Process (WIP), Bill of Materials (BOM), Costing (CST), ASCP, MSCA, WMS

Oracle Financials: Oracle Payables (AP), Receivables (AR)General Ledger (GL), Project Accounting and Billing (PA)

Programming Languages: PL/SQL, Shell scripting, SQL, XML

Development Tools: Oracle Forms 6i, 4.5, Oracle Reports 6i, 2.5, Oracle BIOracle Workflow 2.4, XML Publisher, Oracle Discoverer

Database: Oracle8i/9i, 10g

Operating System: Windows XP, UNIX, WINDOWS NT

Tools: LOFTWARE, NOETIX, Kintana, ClearCase, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle R12 BSA P2P

Responsibilities:

• Responsibility included Carrying out detailed study & analysis of new features & enhancements in R12 for Purchasing, me-Procurement and me-Supplier Portal and integration with other Supply Chain Modules
• Understanding the impact of new features & enhancements on the implemented business processes
• Setting up the entire purchasing suite main setups like document types, purchasing, Receiving, Financial Options, Defining Buyers and setting up Approval Hierarchies.
• Conducted training to buyers on Buyers work Centre and worked on the inbound price list setups using Oracle Advanced Pricing Module.
• Worked on ASN Receipts using DESADV to insert the data into Receiving Interface tables and to process the receipts through open Receiving Interface and to send the rejection details to Suppliers.
• Worked on setting up the trading partners using supplier scheduling and worked on setting up the outbound EDI ORDERS, ORDCHG.
• Requirements gathering, facilitation of technical docs (MD-50, MD-70s, MD-100). Responsible for translating high-level business requirements into detailed IT specifications

Confidential - Atlanta, GA

Business Analyst - P2P

Responsibilities:

• Involved in the Implementation of Purchasing, me-Procurement which includes Requirements gathering phase to Post implementation support.
• Worked with the key business users in understanding the business processes and prepared the AS-IS and To-Be Process documents
• Responsible for the Implementation of Advance Procurement Suite which includes Purchasing, me-Procurement, me-Supplier portal and Procurement Contracts
• Implemented Solution for procuring services in integration with Oracle
• Defining locations, buyers, approval groups, approval group assignments, defining purchasing options, receiving options, Requisitions templates,look up codes, quality inspection codes, ASL and its attributes and sourcing rules.
• Involved in the Unit and Integration testing of all the business processes and update the defect logs and update the necessary documents.
• Worked on the preparation of user training documents, test cases and worked with key business super users on UAT and worked with change management team on go-live activities.
• In Purchasing involved in the setting up Payment Terms, PO Lookups, Purchasing Options, Buyers, Financial Options, Transaction Reasons, Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees.
• Actively participated in the GO-Live activity which involves Open Purchase Order conversions and Open receipts Conversion and vendor conversions and resolution of the Issues dat have come across during Post implementation.
• Worked as a P2P lead which involves tracking all the defects, Issues, RICE Items in the Issue tracker and Co-Ordinate with stake holders, project sponsors and other functional teams and all other project team members.

Confidential, Charleston, SC

SCM Functional Consultant

Responsibilities:

• Worked as a Business Analyst for Enhancing Purchasing and Inventory modules for upgrade to R12, extensively involved in functional setups in Inventory, Purchasing, me -Procurement, Sourcing, Landed Cost Management, workflows, setup form personalization in purchase Order window etc
• Designed and implemented different business processes for creating various types of Internal and purchasing requisitions like Catalog, Non-Catalog using me-Procurement.
• Leading Functional team of Inventory and BOM, providing alternate solutions, Set-up of modules with user data using Data loader, Collected Requirement and
• In Inventory designed and implemented KFF’s, Organizations, Locations, Sub-inventories, Item Templates, Items, Item Status, Item Attribute Control, Item DFF, Item templates, Serial Control, Sub inventory, Locators, Planners, Min-max planning, Cycle Counting, Item Attachments, Shipping Network, UOM Conversion, BOM Parameters, PTO Bills of materials and Manufacturing Calendar.
• Implemented Procurement Contracts which involves conducting workshops for gathering Requirements, As-Is process and To-Be Process documents, Fit Gap Analysis, Configuring Profile Options, Integrating with Purchasing, Contract Types, Roles, Risks, Templates, Clauses, folders etc.
• Implemented setups in Purchasing, me-Procurement module to establish Electronic Ordering and Receiving transfers Confidential remote sites. Involved in the setup of financial options, purchasing options and Shipping parameters.
• Translated business requirements into system definitions and solutions and functional and technical specifications. Updated setup document (BR100).Developed Functional design documents (MD050).
• Designed and developed test plans, test scripts and test strategies for the upgrade.
• Training the client’s super users and users on the application and conducting pilot testing, integrated testing, design validation. Developed Test Scripts (TE040) and User Guides (DO070) for the complete process. Responsible for leading the UAT sessions, SIT testing & Regression testing, executing the conference room pilot.
• Worked on the Transaction Management like Material Transaction which supports both non-stocked items and stocked items and involved in the setup of RF Device Compliance and LPN Based Returns
• Responsible for setup Trading Partners and maintenance of EDI "OUT: Planning Schedule (830/DELFOR)" for Planning Schedule with Release Capacity.
• Responsible for developing and maintaining trading partner definitions, and handling communications with trading partners for EDI transaction set-up and ongoing maintenance.
• Developed integrated test scenarios, identify test data, execute test scenarios as part of system integration testing, troubleshoot and resolve issues identified and document test results.

Confidential, Burbank, CA

Functional Consultant - SCM

Responsibilities:

• Involved in designing, developing interfaces, customizing user requests and implementation change requests. During these processes interacted with end users and implemented their requirements into the Application Systems.
• Designed MD50 for complex reports for business users such as Supplier Delivery Performance, Purchase Price Variance reports Etc in Purchasing.
• Designed MD50 documents for Blanket Purchase Orders interface, Vendors interface, PO Receiving interface, Locations interface and in inventory Items and BOM Interfaces ’, ’BOM Routing Interface’, Item Categories Interface, Item Attributes, Inventory Locators and Onhand Conversions etc.
• Worked on configuring the Discoverer Reports with NOETIX Views and custom views and end User trainings.
• Creation of test script documents; lead the conference room pilot (CRP) phase of the project.
• Wrote a training guide for users, and used this guide to conduct training sessions.
• Designed various rtf Templates with BI / XML Publisher to print the report values with Barcodes for scanning purposes.

Confidential

Functional CONSULTANT

Responsibilities:

• Worked as Functional Lead for the Inventory Management business cycle process implementation
• Involved in business requirement gathering, identifying gaps, design solution to resolve gaps in the standard Oracle Apps, Configuration, testing, training and all documentations
• Designed MD50 and implemented the solution design for ‘Daily Sales Orders Interface and maintenance’ Interface program.
• Worked on solution design for customized Internal Sales orders cycle, Item sourcing and internal customer Returns customizations.
• Developed solution designs various customizations like 'Stock Enquiry Screen’, 'Custom ASN Form' in Oracle11i using Forms6i and modified Oracle Standard forms 'Inter Organization Transfer Form’ (INVTTMTX.fmb), 'Miscellaneous Transaction Form (INVTTMTX.fmb) using CUSTOM.pll.
• Worked on design and implementation of various custom reports like ‘MIN-Max Planning Report’, ‘Print Sales Order Report’, ‘LPN Label reports’, ‘Stock Receipt reports’,’ Commercial Invoice Report’, ‘Custom Sales Order Printing Report’, ’Customer Returns Report’ etc. to the 3rd Party printing tools OPTIO, LOFTWARE.
• Complete ownership on the Implementation of Custom Internal Returns Process between the Inter/Intra Organizations across the Operating units.
• Implemented the Custom Calculate Price Interface from FO legacy system and Price List Conversion and Maintenance.
• Involved in Post-production troubleshooting and analysis of business process issues within: OM, WMS, Shipping, INV and Customer Master and Involved in the sorting technical problems with team related to Order Management, Purchasing and Inventory.
• Designed various functional design documents MD50s and technical design documents MD70s and process maps related to various custom components for the implementation of EBS.
• Developed MD50 for On Hand vs Available Report, Planned order Reports for Inventory projection.

Confidential, Schaumburg, IL

Functional Consultant - OTC

Responsibilities:

• Worked on the requirement gathering, estimations and preparing the Emergency/ Micro Project documents for new enhancement requests from client.
• Designed MD50 and MD70 for Customers & Open Invoice conversions. Created specifications for custom reporting requirements, worked with technical team for development & testing of the custom reports (OM, AR, INV)
• Designed solution design for various custom forms like 'Stock Enquiry Screen’, 'Custom ASN Form' in Oracle11i using Forms6i and modified Oracle Standard forms 'Inter Organization Transfer Form’ (INVTTMTX.fmb), 'Miscellaneous Transaction Form (INVTTMTX.fmb) using CUSTOM.pll.
• Designed solution design for developing and printing various custom reports like ‘MIN-Max Planning Report’, ‘Print Sales Order Report’, ‘LPN Label reports’, ‘Stock Receipt reports’, ‘Commercial Invoice Report’, ‘Custom Sales Order Printing Report’, ’Customer Returns Report’ etc. to the 3rd Party printing tools OPTIO, LOFTWARE.

Environment: Oracle E Business Suite11.5.8, Oracle9i, Forms6i, Reports6i, KINTANA, TOAD

Confidential

Functional Consultant

Responsibilities:

• Development, configuration, and testing of interfaces from various legacy systems to Oracle Applications (including the Order Management (OM/ONT), Shipping Execution (WSH), and Inventory (INV)).
• Techno-functional troubleshooting of the Shipping Execution (WSH), Order Management (OM/ONT), and Inventory (INV) modules within Oracle Applications. Working on issues related to pick release, pick confirm, deliveries, reservations (hard, soft, ATP), backorders (B/O), interfacing to 3rd party warehouse /packaging systems (ALS and FedEx), and ship confirmations (WSH, ONT, INV). Methodological identification of issues starting from order initiation to ship confirmation and closing of order line.
• Changes in configuration to Shipping, OM, and INV setups as needed to address issues, improve performance, and ensure proper flow of data to 3rd party systems. Analysis of customizations and enhancements: evaluate design, quality, stability and maintainability of custom code developed to fill gaps between standard Oracle Applications functionality and business requirements.
• Delivering technically accurate, high quality documentation within specified deadlines
• Supported all functional setup issues related to ‘Sales Orders‘Interface from legacy system into Order management.
• Perform unit testing of Oracle application for assigned process areas, identify issues and troubleshoot issues to resolution.

Confidential

Functional Consultant

Responsibilities:

• Studying client processes, developing AS-IS and TO-BE maps, assisting in implementation.
• Responsible to Capture Functional & Technical requirements in interaction with the Client.
• Mapping the business requirements in relation to Oracle Application functionality.
• TO-BE design to meet the client needs.
• Complete ownership of customer issues in Order management, Inventory and Purchasing and providing end-to-end solutions

Environment: Oracle Applications E Business Suite11.5.7, Oracle9i, Forms6i, Reports6i, KINTANA, TOAD

Confidential

Technical Lead

Responsibilities:

• Responsible to Capture Technical requirements in interaction with the Client.
• Worked in Custom.pll to customize the Forms to meet the Client Requirements.
• Worked in the customization of Reports and registration of Forms and Reports, adding Value sets and DFF’s.
• Implemented in the data setups like Organization setups and Items
• Giving online training with test data to end users in Purchase and Inventory modules.

Environment: Oracle Applications E Business Suite11.5.7 (OM, PO, INV), Oracle9i, Forms6i, Reports6i, KINTANA, TOAD