SUMMARY:

• Possess over 7+ 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 Manufacturing.
• 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).
• 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.
• 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) and Shipping,Advanced Pricing, Purchasing (PO),Costing, Account Receivables (AR), Bills of Material(BOM), Work in Process(WIP)

Office Tools: MS PowerPoint, MS Word, MS Excel, Microsoft Visio, 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

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 Subinventories, Locators 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.
• 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.
• 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.
• 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 etc
• 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, Madison, WI

Lead Oracle SCM Functional Consultant

Environment: Oracle Application Release R12

Responsibilities:

• Mapped the existing system with the Oracle Applications, defined various Order cycles for different business purposes and involved in setups, implementation and train users of the Oracle Inventory, Order Management, Purchasing and i- Supplier Modules.
• Defined and maintained ABC classification of items and Cycle counting procedures.
• Played a crucial role in streamlining the business process in the area of OPM.
• Involve in production Support and Resolve day-to-day issues in PO, INV, OM, Shipping and i-Supplier modules.
• Involved in upgradation and implemented the oracle apps for other branches.
• Analyzing and working on various functional issues
• Research on various new functionality and features in R12
• Worked closely with technical team to explain the Business related functionality.
• Regression testing for existing functionality over new fixes.
• Conducted knowledge sharing sessions on the setups required for Order management
• Assisted in creating Physical inventory operational instructions defining business process requirements and Oracle techniques necessary to conduct the physical inventory process in multiple warehousing and manufacturing facilities
• Involved in defining Bill of Material and Routings for manufactured products and subassemblies for ordering configuration
• Worked on completion order cycle setups from, order entry in order management to ship confirm in shipping execution modules and invoicing.
• Worked on O2C and PTP cycles related issues and implementing few modulus related to Order Management.
• Successfully implemented Standard Purchase Order, Blanket PO and PO releases. Implemented internal sales order using internal requisitions / standard PO and Sales Order processing.
• Defined Inventory organizations, parameters, sub inventories and picking rules in Inventory
• Maintained purchasing locations, buyers, and approval groups
• Conducted comprehensive user training on Oracle Purchasing, shipping Execution, development of training materials and practice exercises.
• Handled back flush related issues in both discrete manufacturing and flow manufacturing.

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.