SUMMARY

• 8 years of experience which include 3 years as a Functional Analyst in Process Manufacturing (OPM), and around 5 years as an Oracle SCM Functional Analyst with extensive expertise in both R12 & 11i versions of Oracle applications.
• Worked on various modules with focus in Process Manufacturing (OPM) and Distribution domain with extensive experience in Oracle Inventory (INV), Order Management (OM) including Shipping, Advanced Pricing, Purchasing (PO) including iProcurement (iProc), Bill of Material (BOM), Work in Process (WIP), Material Requirements Planning (MRP) and Master Product Scheduling (MPS).
• Proven expertise in business process mapping, analysis, design and configuration, customization and workarounds, functional issue resolution, System Integration and Acceptance Test as a part of Implementation and Upgradation.
• Expertise in requirement analysis, system mapping, conduct CRPs and UAT, Integration testing, system configuration, data conversions, regression testing, Go - live support and production support.
• Proficient in create and maintain documentation under AIM methodology like RD 20, BP 80, BR 30, MD 50, CV 40, BR 100, and TE 40 and created User Manuals.
• Exploration Phase Scheduling- Application requirement and evaluation study, Selection of product vendor and sourcing, Product demonstration to Project Steering Committee and key business users, Selection of implementation methodology.
• Engagement Phase Scheduling- As-Is process mapping, To-be process mapping, gap and fit gap analysis, Goal setting, Mile stone fixing, Strategies scheduling, Fixing responsibilities matrix, Data sourcing and refining, Data migration and validation, Conference Room Pilot (CRP).Enable Phase Scheduling- Defining roles and responsibilities, on the job training for key and end users, Parallel process running, Result deviation, UAT, Going live and Post implementation issues.
• Excellent problem solving, communication, analytical and interpersonal skills.
• Follow-ups with Oracle Support on Technical Assistance Requests (TAR)/Service Requests (SR) and conduct Oracle Web Conference (OWC) to resolve high prioritized issues within the time lines.
• Create and maintain user manuals and provide multiple user training sessions for large group of users.
• Conduct System and Integration Testing (SIT) and coordinate with UAT.
• Good experience in implementation process mapping, functional requirement analysis, Gap analysis, post implementation production support, development of training material, presentations, testing and documentation.
• Worked in multicultural and multiethnic environment with coordination across different time zones including On-Site/Offshore model.

TECHNICAL SKILLS

Modules: INV, OM, PO, iProc, BOM, WIP, MRP/MPS, Advance Pricing, Costing, P2P, O2C cycles, AP, GL.

Versions: R12 (12.0.3, 12.0.4, 12.0.5, 12.0.6, 12.1.1, 12.1.2, 12.1.3) & 11i (11.5.8, 11.5.9, 11.5.10, 11.5.10.2)

Other Tools: Data Loader, PL/SQL, SQL Loader, TOAD, XML and Discoverer

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle SCM/OPM Functional Analyst

Responsibilities:

• Reimplementation of 11. upgrade for Supply Chain Management/ Oracle Process Manufacturing (OPM), Quality, Order Management, Inventory, financial and HRMS modules.
• Understanding client's current Business Process design, gathering new business requirements, application configuration, and usage of the OracleEBS.
• Review R12 new features and identify new functionality to replace customizations from 11i.
• Perform initial R12 upgrade functional design of mandatory R12 changes.
• MRP: Configure the module, Check setups with Inventory, Purchasing, Order Management, Create MPS and MRP Plans, create Forecasts, release manufacturing jobs and requisitions from Work Bench,
• Inventory: Worked on Item Conversion program for converting Items and Item Revisions from 11i to R12 Instance in Inventory (INV) Module.
• Quality: Involved in setups of test class, test codes, specifications, validity rules, creation of lots for Quality and Inventory module.
• As a functional consultant setup the OPM System for the Following Business flow Cycles:
• Concept to Release
• Schedule to Produce
• Quality Issue to Resolution
• Sampling to Acceptance
• Product Costing to Inventory Valuation
• Duties included solution design, documentation, and training of subject matter experts.
• Assist in development of use cases, GAP analysis and extension design through CRP1 for Inventory, Product Development and Production Execution Modules.
• Responsible for all strategies related to production and costing. Participated in the strategy to integrate Oracle Process Manufacturing with the Financial applications.
• Assist client in the deployment of OPM Product Development, Production Execution, and Inventory.
• Setup of Order Management with Order Transaction Types, RMA types with various kinds of Order Holds utilizing credit check Confidential different stages of order.
• Setup of Price Lists for different Order Transaction types, RMA types.
• Documented BR100’s for OPM modules. Conducted business workshops on OPM process functionality.
• Worked on AMEX CAR integration that includes importing the expenses form American Express server and generating Payable Invoices in Account Payable module.
• Worked on development and testing of IPAD Consignment report app using IREP and SOA technology.
• Work with IBM off shore team on the development, migration of Rice build objects and migration of objects and defects.
• Worked on development of TTRR Data Entry form and TTRR Conversion and data extracts from 11i to implement in R12.
• Create and follow up with Oracle Service requests and apply patches as needed or do the functional changes to fix the defects.
• Done setups for employee’s information for HRMS module in R12 instance.

Confidential, CA

Oracle OPM Functional Analyst

Responsibilities:

• Project was basically reimplementation of Oracle Financial and Process Manufacturing module of Apps R12 OPM. Distribution and Supply Chain Management were the main modules along with Financial Modules.
• Provided and prepared the following deliverables as part of the project:
• Future Design Document (BP.080) for OPM Product Development, OPM Formulator, OPM Costing and Distribution Modules.
• Application Setup Document (BR.100) for OPM Suite and Distribution Modules.
• End User Training and Supporting on Daily Transactional Activities. Preparing training Documents for all the OPM Modules.
• Set up of Inventory Organizations, Sub inventories, Item Sub inventory relationships, Shipping networks and Transaction Sources.
• Automation of Item Set up including set up of Item, Setup of Item Templates and Item Categories.
• Setup of Order Management with Order Transaction Types, RMA types with various kinds of Order Holds utilizing credit check Confidential different stages of order.
• Order entry & order booking - Use defaulting rules and processing constraints to help through order entry.
• Implementation of Holds using Oracle workflow to ensure greater control over Order Modification.
• Invoicing of the orders as per the business rules.
• Analyzed the various pricing business scenarios to understand the pricing and discounting requirement of the client.
• Implemented various pricing and discounting measures based on product hierarchy and pricing attributes.
• Defined and mapped flexible attributes & domains to control the prices & discounts applicable to different items, customers and orders.
• Defined various price lists, pricing contexts, attributes & attribute values to meet the business requirements of the customer.
• Setup of Price Lists for different Order Transaction types, RMA types.
• Setup Modifiers to pass on charges to the customers like Freight charges to capture Confidential the point of shipping.
• Set up Agreements with customers to use pre-negotiated prices, freight charges & payment terms
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, and Approval management
• Set Up of sourcing rules & Approved Supplier Lists
• Prepare and review test scripts based on the business requirements
• Planned, Executed and Monitored the CRP phases in Development instances
• Imparting functional training to users and super users
• Involved in change management to follow up the necessary changes that have been made as per the business flow in day-to-day activities.

Confidential, Charleston, SC

SCM Functional Consultant

Responsibilities:

• Worked as a Business Analyst for EBS 11.5.10 implementation, Implemented Holds, Processing Constraints and Defaulting Rules to support new processes, Implemented Item Relationships and Customer Item Cross References to enable substitution and cross-reference during Order entry, Setup Profile options, System parameters, Quick Codes, Document Sequences, Transaction Types, Defaulting Rules, Order Import Source, Validation Templates, resolving stuck Sales Orders, Returns and Invoices, correcting serial numbers, resolving delivery exceptions, design and implemented new Credit and rebill process including, enhancing and creating new workflows, setup form personalization for Order, line delivery and ship set Weight.
• In shipping execution, involved in the Setup Roles, Shipping and Pick Release Parameters, Delivery Parameters, Freight Carriers and Ship Methods, Document Sequences and Categories Etc
• In WMS worked on the Configuration of Shipping Labels, and printing the shipping Content Labels and Concatenate the Sub inventory and Locators in the WMS and produced new barcodes in order to save time while scanning and reduce Picking errors.
• In WMS worked on Cartonization of Container Items, Defining Load Container Relationship and Multi Level Cartonization and worked on the setting up automatically suggest packing configurations for groups of items.
• 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
• Worked on feasibility and effort analysis, training and explaining R12 new functionality to Users and managers in Oracle Distribution Modules. Developed solution design for Planning Bill Of Material firmed order history interface and developed solution design for PBOM Forecast load interface from Legacy mainframe application.
• Developed solution design for Pegging Report, Demand vs Replenishment, Forecast Comparison Report, Projected Inventory Level Report and 12 month forecast for specific Product types.
• 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 - Atlanta, GA

Business Analyst

Responsibilities:

• Worked as business analyst in Order Management, Shipping Execution and Warehouse Management System (Oracle WMS) implementation, which includes the Warehouse and Inventory Management sections, and the simultaneous implementation of the Label printings with Bar Codes.
• Responsible for Requirement Analysis /Feasibility Study Regression Testing Update/Create (BR100, MD50, TE050), for functional application processes and Participation in Business Lean workouts Solution Prototyping-Analysis/Control of application function.
• Major activities includes process maps and gap analysis, developing solution designs, end user training and creation of test case documents
• Designed MD50s for Sales orders interface from Legacy systems, Backorders interface, stock Replenishments interface and pricing interface from legacy systems.
• Configuration of Shipping Labels and printing the shipping Content Labels.