PROFESSIONAL SUMMARY:

• Having 9+ Years of ERP functional experience which includes expertise in Oracle Inventory (INV), Order Management (OM), Bills of material (BOM), Work in Process (WIP),Procurement, iprocurement and Support as Functional Consultant.
• Having enriched experience as ERP analyst, setups, testing, gap analysis, delivery and deployment in Supply chain, Manufacturing business processes.
• Strong Expertise in Advance Pricing, Shipping (WSH), Purchasing (PO),Sourcing, iSupplier Portal, iProcurement, AP, AR, GL.
• Good understanding about SDLC and requirements gathering.
• Ability to work with Cross - functional teams including Users, Business Analysts and Technical Consultants. Good Inter-personal, Reporting, and Communication skills.
• Expertise in preparation of business requirements and functional specifications for conversion of master data & transactional elements such as items, categories, transactions, on hand, bills, routings, customers, Sales orders, purchase orders, & discrete jobs.
• Developed functional specifications for application Extensions, Interfaces and Custom reports.
• Extensively worked on business requirements gathering, Solution design, business mapping, configuration, set-ups, testing (Unit & Integrated) etc.
• Worked on Order to Cash (O2C) and Procure to Pay (P2P) processes.
• Demonstrated ability to facilitate system review, data analysis, Conducting CRP & UAT and situation assessment.
• Through understanding of As-Is Process, designing To-Be Process, gathering business requirement, performing gap analysis, building RICE (Report, Interface, Conversion, Extension), Configurations throughout all phases i.e. CRP’s, Testing.
• Writing or reviewing the test cases to test the requrimens.
• Experience in Procure to pay Modules i.e iprocurement, Purchasing, Accounts Payables, Accounts Receivables.
• Experience with the Lockboxes in Receivables module.
• Experience in Teaching.

TECHNICAL SKILLS:

ERP: Software Oracle Applications 11i, Oracle 11.5.8 to 12.1.3, 12

Supply Chain: Order Management (Order Entry, Pricing, shipping), MRP

Core Mfg: Inventory, BOM, WIP, Costing

Procurement: Purchasing, iprocurement

Finance: AR,AP,GL

Databases: Oracle, SQL Server

Languages: PL/SQL, Visual Studio

Operating Systems: Sun Solaris 2.5,Windows (XP/2000/NT/98/95),MS/DOS

Industry Knowledge Areas: Supply chain planning, Inventory Management, Engineering / BOM / Cost, Order Management, Manufacturing, Procurement

PROFESSIONAL EXPERIENCE:

Confidential

Business System Analyst, Schaumburg, IL

Responsibilities:

• Gathering the Requirements and involved in the design sessions
• Working on a ongoing implementation.
• Work on implementing Oracle R12 system from different 11i and legacy systems.
• Involved in usecase meeting and creating the usecases.
• Have drawn the Visio diagrams for the As is and To be system.
• Providing Functional inputs / clarification to the Technical Teams
• Period review and reporting of Case Analysis, Case Statistics
• Providing inputs on functional process improvements as required.
• Identifying different types of possible errors when interfacing with Legacy
• Modification in Picking Release rule to overcome some of the issues with Legacy
• Set up of Inventory Organizations, Sub inventories, Item Sub inventory relationships, Shipping networks, Transaction Sources.
• Set up of Order Management with Order Cycles, Order Types, RMA types with various classes, Order Holds
• Setup of Price Lists for different Order Cycles, Order types, RMA types with various classes.
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, and Approval Management.
• Performed Thorough Analysis of the company’s Supply Chain and Manufacturing.
• Assisted Lead in requirements gathering process from the Business SMEs and prepared as-is, To-Be documents.
• Assisted lead in the process of interfacing various legacy systems with Supply Chain and Manufacturing modules.
• Developed the System Requirements Documents and configured system by mapping the BR with Oracle EBS Standard functionality.
• Assisted SCM and Manufacturing consultants in module related setups.
• Involved in various setups in SCM such as Replenishment setups, Cycle Counting, ABC analysis, Item setups etc.
• Involved in manufacturing setups such as Defining Bills and Routings and Scheduling rules for Flow Manufacturing.
• Involved in Interfacing Inventory and Manufacturing modules with Order Management and Purchasing Modules.
• Performed Gap analysis and defined Custom Components, Setup and Conversions.
• Currently involved in System Integration Testing.

Confidential, Duluth, GA

Lead SCM/Manufacturing Functional Consultant

Responsibilities:

• Functional Lead to support Inventory, Purchasing, Advanced Purchasing, Order Management, BOM, & WIP, Install base, pricing, Planning, GL,AR,AP, O2C, P2P cycles
• Handling tickets and application support to the end-users. When an issue is received, analyzed and resolved
• Worked with Oracle Support team in case of any bugs.
• Worked with technical team for implementing or any change request
• Run diagnostics requests, SQL’s or any other required to identify or resolve the issue, then run those required (data fix SQL’s when Required) and update SR’s and co-ordinate with oracle support team till closure
• In case, if the issue requires the support of Database Technical Consultants/DBA, then Describe and transfer the issue to Technical Consulting team with the inputs. Monitor and help Technical team to complete the task
• Prepared MD050/MD060 documents for any customizations
• Prepared Test Cases, Test Data & testing.
• Interacted with client/end users & updating the issue status.
• Trained the end users and preparing end user training material.
• Involved actively in quarter end and month end related issues
• Prepared the frequently occurring issues and solutions documentation.
• Worked to fix the frequently occurring issues by doing the root cause analysis and fixing the issue.
• Performed Data flow & Gap analysis with UML using MS Excel, MS Visio, Rational Rose
• Translated business requirements into functional specifications for communication to technology team
• Developed source to target data mapping for the source elements and created transformation rules as per the business need
• 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, kanban in shop floor, workorderless completions, repairs, outside processing cycles.
• Have prepared documentation as Oracle’s AIM Methodology, 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.
• 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, Boston, MA

Oracle SCM/Manufacturing Functional Consultant

Responsibilities:

• Onsite Lead to coordinate with Business analyst of the Client and the offshore team
• Working on various issues related to the SCM modules ( Inventory, OM, Purchasing and CDQ)
• Worked on Upgrades Oracle 11.5.8 to 12.1.3 and some of the support technical issues.
• Supporting the project by solving the issues raised by talking to the end users on call and coordinating with Onsite and Business analysts.
• 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 system
• Analyzed the business requirements for INV, Order management, BOM, and WIP.
• Closing the tickets related to inventory, Planning, CDQ, purchasing or Order management
• Providing Functional Assistance to the team in modules on SCM related modules
• Triaging the tickets to the respective queue.
• Interacting with technical team with the Business requirements and Business understanding.
• Interacting with the Business analyst of the client to understand the business and with the suggestions for the Improvement.
• Monitoring the similar kind of issues and building a permanent solution for the same
• Identifying the root causes for the issues and implementing the proposed solution.
• Get the required patches moved to production after complete testing on test instances.
• Closely worked with Business analysts and team members for analysis and changes.
• Responsible for Understanding existing Processes and suggesting good business practice. Production support for Manufacturing and Inventory modules.
• Responsible for Month end period closure. Periodic monitoring of pending transactions to close the inventory accounting periods.
• Resolved Transaction open interface and pending transaction issues. Working on issues related to pick release, pick confirm, deliveries, reservations. Resolving the issues on ticket basis.
• Assisted in the setting up the preference for workbench and personalized folders in workbench for viewing MRP output. Helped Planning super users in Troubleshooting and solving the issues related to MRP, WIP and Inventory. Interacting with super user for developing user required reports.
• Creating the setup for plans, planning parameters, MPS and MDS input for a new organization and new release. Worked with planning super users to train them on the MPS/MRP flow in Oracle Applications and Helping Planning super users interpret the exceptions and suggestions from MRP runs Understanding the present (AS-IS) process and Defining and Documenting To-Be Processes for the company based on good business practice. Production support for Manufacturing and Inventory modules.
• Assisted in the setup for Forecasting demand, profile options and MRP planner workbench setups. Helped Planning super users interpret the output from workbench and training them on MRP module.
• Creation of BOM, resources for Sub-assemblies and Finished Goods and also Created Routings, Standard operations for routings. Worked on INV replenishment methods Min-Max and Kanban replenishments
• Status calls with onsite with the status reports of the project.
• Taken the Lead role and allocated the tickets to the team members.
• Mentored and conducted training in the SCM modules and in soft skills for the new joiners.
• Participated in SCM COE meetings
• Conducted the knowledge sharing sessions on the support issues.
• Proactively monitored the month end preventing related issues and cleared the records accordingly.
• Documented the repetitive issues with the data fixes and worked on root cause analysis and worked with Oracle and got the permanent resolutions.
• Documented the solution documents for the new issues resolved and P1 related issues.
• Participated in CMMI documentations and meeting.
• Conducted CRP sessions for the ATO / PTO models & configured the systems for ATO and PTO models.

Confidential

SCM Functional Consultant, Hopkinton, MA

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 system
• 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.
• Resolving the day-to-day issues in PO, INV, OM and OPM modules.
• Providing functional support to the team
• 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, Ferguson, Missouri

Oracle Supply Chain Functional (SCM) Consultant

Responsibilities:

• Providing Functional inputs / clarification to the Technical Teams
• Period review and reporting of Case Analysis, Case Statistics
• Providing inputs on functional process improvements as required.
• Identifying different types of possible errors when interfacing with Legacy
• Modification in Picking Release rule to overcome some of the issues with Legacy
• Set up of Inventory Organizations, Sub inventories, Item Sub inventory relationships, Shipping networks, Transaction Sources.
• Set up of Order Management with Order Cycles, Order Types, RMA types with various classes, Order Holds
• Setup of Price Lists for different Order Cycles, Order types, RMA types with various classes.
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, and Approval Management.
• Performed Thorough Analysis of the company’s Supply Chain and Manufacturing.
• Assisted Lead in requirements gathering process from the Business SMEs and prepared as-is, To-Be documents.
• Assisted lead in the process of interfacing various legacy systems with Supply Chain and Manufacturing modules.
• Developed the System Requirements Documents and configured system by mapping the BR with Oracle EBS Standard functionality.
• Assisted SCM and Manufacturing consultants in module related setups.
• Involved in various setups in SCM such as Replenishment setups, Cycle Counting, ABC analysis, Item setups etc.
• Involved in manufacturing setups such as Defining Bills and Routings and Scheduling rules for Flow Manufacturing.
• Involved in Interfacing Inventory and Manufacturing modules with Order Management and Purchasing Modules.
• Performed Gap analysis and defined Custom Components, Setup and Conversions.
• Conducted user training and created user manual for End-Users and Business Representatives.

Confidential, Houston, TX

Oracle SCM / Manufacturing Consultant

Responsibilities:

• Involved in Design, Develop and Implementation of Manufacturing (WIP, BOM, INV) and Fulfilment (OM)
• Analyzed and configured major Setups in Order Management, Inventory modules
• Prepared Test Case Document as per process defined for Functional, Integration Testing and Business Scenario Testing
• Prepared As/Is, To-Be, MD050 and BR100 documents
• Designed MD50s for interfaces with various Legacy Systems.
• Participated in activities for Developing the Project Plan, GO-Live Plan and Master Setup Plan
• Develop the System Requirements Documents and configure system by mapping the BR with Oracle EBS Standard functionality
• Performed Gap analysis and defined Custom Components, Extensions, Setup and Conversions
• Completed configuration and setup of with custom components to meet the needs. (System Setup)
• Integrated system testing, performed user acceptance testing (UAT)
• Trained end users. Designed training materials (UM) to bring users up to speed with the standard System Functionality and Custom Components
• Supported all go-live activities and post-production troubleshooting. It includes data migration, System configuration issues

Confidential, Irving, TX

Oracle Finance and Supply Chain QA Analyst

Responsibilities:

• Tested Order Management (OM) functionality such as Enter/Book, all Sales Order Types such as Standard, Mixed and RMA
• Involved in testing all type of Order Holds and Releases such as Quantity, Amount and Credit.
• Involved in testing various standard & custom solutions within Oracle Supply Chain Planning & Logistics department. Creating systematic solutions mainly within Order Management (OM), Purchasing (PO), Inventory (INV), & Accounts Receivables (AR) modules.
• Involved in performance testing to revolve response time for all concurrent program and reports
• Involved in performance testing of EBS/ERP application using OATS.
• Involved in performance testing solution for a web application using OATS.
• Involved in testing custom sales order such as Advance Exchange and Repair and Return orders.
• Involved in testing end to end transaction in P2P and O2C cycle.
• Verified bottleneck issues and eliminate performance bottleneck issues using OATS.
• Verified all sales order Line and Header Level information, Verify On hand/Reserve quantity, Pick Release, Perform Ship Conform, Perform Auto Receipts Process and Receiving Receipts.
• Tested outbound interface of on-hand quantity from Oracle EBS to legacy system Prowess.
• Tested interface between Cyber Source and Oracle EBS for customer credit card payment processing.
• Tested Auto Lockboxes
• Involved in testing inbound interface of credit check for customers from 3’rd party tools into Oracle EBS.
• Involved in Functional, SIT, Regression, Performance, Automation and UAT testing.
• Tested Inter-Org transfer related issue and problems in INV, face due to invalid locator.
• Prepared Test Strategy, Test Plan and Test summary documents. Involved in BR100 setup testing.
• Coordinated with offshore on daily work.

Confidential

SCM Functional Consultant

Responsibilities:

• Providing functional expertise on Purchasing (PO), Inventory (INV) Oracle Applications 11.5.8 for an offshore client as well as a local client.
• Post Implementation Support
• Creation of Sub-Inventories as per Excise Rule
• Outside Processing Pos with PO move resource Type operation in WIP when operation is move to Queue to Move, and then generated Import Requisition,
• Auto Generation of Pos based on Outside Process Requisition And raised PO for Sub Contractor so it will be available for Out-Source Operation Completion
• Various receiving transactions.
• Sub-Inventories Transfer As per INDIA Localization Required for Sub Contractor
• OSP Challans, 57F4 Dispatch and Receipt Against Sub Contractor PO
• INDIA Localization Setup For Excise, Custom Duty, Third Party Taxes
• Knowledge of documenting requirements, definition through AIM Documentation