SUMMARY:

• Possess around 6+ years of experience in software industry with comprehensive knowledge through all phases of software development lifecycles from requirement analysis to maintenance of a project Expert in the phase of Implementation, Support and Maintenance of Oracle E - Business Suite modules.
• Successfully implemented full life cycle projects, hands on process and design implementation experience in Order-to-Cash (OTC), Procure-to-Pay (P2P) Process and discrete and flow Manufacturing. d
• Experience in Business Analysis, Enhancements, Data Migration and Implementation of Oracle Manufacturing Modules Inventory, BOM and WIP.
• Excellent knowledge of Multi-Org and Multi-Currency structure.
• Strong communication, analytical, diagnostic and troubleshooting skills and experience with working in dynamic, cross-functional teams
• Conversant in implementing Oracle Supply Chain and Manufacturing modules (PO, OM, Adv. Pricing, INV, BOM, WIP,WMS).
• Proficient in functional knowledge of Order to Cash, Procure to Pay and Financial business processes withOrder to Cash(OTC), Procure-to-Pay(P2P)
• Developed Functional Requirements definitions and Test cycles using AIM and OUM methodologies.
• Understanding of Planning Module ASCP.
• Setup and implementation of Flow Manufacturing for a product line and employ JIT( Just-In-Time concept) such as Manufacturing to demand.
• Setup Flow Routings utilizing the Graphical Designer in Flow Manufacturing. Configured Flow Sequencing and Execution to sequence and process the Flow Schedules through the Manufacturing Line to complete to Inventory.
• Excellent analytical skills in Fit/Gap analysis, Solution design, configuration, requirements gathering, running CRPs, driving testing and troubleshooting issues and preparing User Guides using AIM Mythologies.
• Experience implementing Oracle e-Business in financial and Manufacturing Modules. Good background in the business requirement gathering and documentation.
• Good experience in developing Tech specs, coding RICE components, performing UNIT test, String testing, regression testing, documenting test results, and troubleshooting programming errors.
• Strong interpersonal skills, communication and presentation skills, ability to interact with people at all levels.

TECHNICAL SKILLS:

ERP Skills: Oracle 11i, R12 Oracle Inventory (INV), Order Management (OM), O2C and Shipping,Advanced Pricing, Purchasing (PO), P2P,Costing, Account Receivables (AR),Oracle Accounts payables, iProcurement, iSupplier, iexpense, Invoicing, WMS(Warehouse Management System), Bills of Material(BOM), Work in Process(WIP), Oracle Engineering, Oracle Quality(QA), Oracle Framework, ASCP(Advanced Supply chain Planning),Oracle Flow Manufacturing(OMF), Material Requirement Planning(MRP)

Office Tools: MS Power Point, MS Word, MS Excel, Microsoft Visio, MS Project, DataLoader, Microsoft BI Publisher etc.

Programming Tools: SQL*PLUS, SQL* Loader, TOAD9.0

Other Tools: Oracle Reports Developer 10g. TOAD and SQL Developer

Platforms: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Waynesboro, VA

Oracle SCM/Manufacturing Functional Consultant

Environment: Oracle R12.1.3

Responsibilities:

• Involved in the process of requirement gathering from Business Users and analyze the level of Fit and Gap between the Business Requirement and Standard oracle Functionality.
• Involved in the preparation of BR100, BR120, SRD documents, including requirement gathering and coordination with the technical team to develop Customized reports and perform enhancements.
• Worked with planning team to set up inventory planning for the items at Inventory organization level with planning methods such as Reorder Point planning, Min/Max Planning for calculation of levels of safety stocks and reorders levels.
• Involved in setting up Sub inventories, Locators, WMS and Min-Max setups and carried out sample transactions to show functionality to the business users and provided training on the same.
• Setup shipping network for Internal Requisition and Internal Sales Order across operating units.
• Created Approved Supplier List, Sourcing Rule and Assignment set for auto creation of Standard Purchase orders & Blanket Release with Advanced Supply Chain Planning (ASCP) workbench functionality.
• Setup the item cost and new external and intercompany price lists for multi-currency conversion across North America.
• Worked with team to configure flow manufacturing, setup pull material using Kanban planning to reduce inventories, optimize machine time and simplify shop floor activities.
• Involved in setting up WIP Transaction types to complete the discrete jobs.
• Part of team to develop customized forms for What-if functionality for buy components availability for final assemblies.
• Developed Test scripts for the conference room pilots and “proof of concept” scenarios for Inventory, Advanced Product Catalog, Project Manufacturing, Flow Manufacturing, Advanced Supply Chain Planning, and Work in Process and Bills of Material applications.
• Customized reports in AR such as: Open-Debit Memo Report, Aging Report Customer Payment Details Report.
• Tested the functionalities as per the requirements, before the system went live.
• Responsible for validation of data and coordinating data conversion activities with conversion team.
• Provided extensive user support during UAT and Post Production phases.
• Developed test scenarios and end user manuals for super user and end user testing.
• Developed, modified and Executed Test Scripts for INV, BOM, WIP, OM, PO, iProcurement, AP and AR
• Setup new reports to compare demand and Production cost on weekly and monthly basis.
• Experienced in creating and raising Oracle Service Request and work with Oracle to solve Critical issues related to Standard Oracle Bugs and Data Corruption.
• Involved in developing and testing of Customized Reports using Oracle SQL and PLSQL.

Confidential, MO

Oracle Supply Chain Consultant

Environment: Oracle Application R12

Responsibilities:

• Functional Lead for Implementation of Oracle Modules Inventory, Purchasing, Order Management, Bills of Material and Work in Process.
• Capturing Business Requirements and Preparation of As-Is Documentation
• Setup of Inventory Organizations, Sub inventories, Item Sub inventory relationships, Shipping networks, Transaction Sources and warehouse management system etc
• Implemented Oracle flow manufacturing to production of family of products at steady rate.
• Predict line capacities according to product demand rates and reduce operation time to meet demand
• Solutions provided in Shop floor management using work in process discrete job management, Work order scheduling, Work order Printing, Discrete job routing sheet customization, move transactions, completion transactions, raw material management process in shop floor.
• Translated business requirements into functional specifications for communication to technology team.
• Worked with Cross Functional Team for End to End Testing and Smooth execution of Order to Cash and Procure to Pay Cycles.
• Developed source to target data mapping for the source elements and created transformation rules as per the business requirement.
• Assisted the QA team in reviewing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were catered to by the application
• Performed Data flow & Gap analysis with UML using MS Excel, MS Visio, Rational Rose
• Designed solutions in shortage management, Work Order less completions, repairs, outside processing cycles.
• Have prepared documentation as Oracle’s AIM Methodology, Oracle EBS taken business Sign-Offs on various test results and have provided approvals for further progression of upgrade activities
• Perform Gap analysis between business requirements and Standard functionalities of Oracle ERP application.
• Tracking the right flow of transactional data by using SQL queries in data base system
• Worked with the end-users and management to resolve issues and bridge business process gaps.
• Designed WIP Interfaces for Discrete Manufacturing invoking Oracle SOA based web services
• Discussed with various business units to gather required information and setting up of locations and Employers Approval groups, Purchase orders approval hierarchy, and Receiving options.
• Training the users on order entry, pick release, ship confirm, Invoicing processes. Trouble shooting shipping issues and reservation issues.
• Have Conducted onsite solution reviews, UAT, and sign-offs for new RICE Components development, solution delivery, and production cutover.

Confidential

Oracle SCM and O2C Functional Consultant

Environment: Oracle 11.5.10i

Responsibilities

• Provided Production Support to the End-Users on Oracle Supply Chain Application modules: Oracle Inventory, Order Management (OM) and Oracle Purchasing.
• Supported the clients for the functional and technical issues in Order to cash Process Flow including coordination with Finance team to provide resolution and do Root Cause Analysis of the Issues.
• Involved in Creation of MD50 and coordination with Technical team to prepare customer specific Customized Reports.
• Involved in Setting the profile options, system parameters, transaction types and defaulting rules for Purchasing to facilitate the ordering process and setting the pricing rules.
• Involved
• Prepared training documentation for future users for reference and conducted training for the users and super users in company on Oracle concepts and carrying out sample transaction
• Worked with Oracle Support, Created Oracle SR’s and Fixed Pending Issues and oracle Bugs after getting latest patches from Oracle.