SUMMARY

• Overall 11+ years of experience in Information Technology and Manufacturing domain.
• Having 8+ years of extensive experience in IT industry as Oracle applications VCP/SCM/MFG functional consultant and 3 Years of Manufacturing Domain experience.
• Proficient in ASCP, GOP, Rapid Planning, Inventory, Purchasing, Order Management, BOM,WIP and Knowledge in APCC, Inventory Optimization (IO), General Ledger, Advanced Pricing, Costing and i Supplier.
• Effectively involved in Requirement gathering, analyzing business requirements, System Mapping, Conference Room Pilot and Postproduction support.
• 4 Full life cycle implementation of Oracle E - Business Suite (MFG & SCM modules) & VCP Modules including design, setup, development, implementation and support of manufacturing systems, with excellent knowledge on VCP/MFG/SCM modules.
• Extensive Experience in Oracle Business flows Procure to Pay (P2P) and Order to Cash (O2C).
• Effectively involved in Oracle EBS R12& VCP Implementation, Enhancement and Production Support Projects.
• Involved in preparation of various Functional Design Documents like MD050 for customizations by using AIM Methodology.
• Experience in the preparation of Functional Design documents for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces.
• Having very good knowledge in Preparing of different Documents by using Oracle Applications Implementation Methodology (AIM).
• Involved in Unit, Integration (SIT), and User Acceptance Testing (UAT) through the development of test scripts
• Good communication and Inter-Personal Skills and able to work as an active member maintaining good interaction with client and team members.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS

ERP Releases: Oracle Applications R12.0.1, R12.1.1, R12.1.3 & R 12.2.4

ERP Modules: ASCP,GOP, Rapid Planning, APCC, Inventory Optimization (IO),Inventory, Purchasing, Order Management, Bills of Materials, Work in Process, General Ledger, Advanced Pricing, Costing and i Supplier.

Database: Oracle 9i,10g, 11g

ERP Methodology: AIM

Languages: SQL, PL/SQL

Oracle Tools: SQL Developer, Toad, Data Loader

PROFESSIONAL EXPERIENCE

Confidential - Sidney, OH

Responsibilities:

• Working as an Oracle Planning Functional consultant and part of COE/Architect Team.
• Preparing Functional design documents for Planning gaps by leveraging ASCP & APCC Custom Hooks.
• Reviewing RFCs for Planning configuration sheets to provide feedback and approvals.
• Involving in RICE Approval meetings for ASCP related customizations.
• Performing impact analysis for Planning solutions, provided by various Emerson Project teams.
• Providing Production support for ASCP, GOP, APCC Modules.
• Involving in post cloning/Upgrade activities of EBS and APS Instances to re-establish the connections.
• Providing Support in resolving different performance issues with collections and plan run.
• Testing and validating MSC Profile options as per new Business requirement and implementing the Profiles.
• Impact analysis for changes on existing MSC Profile options to make sure other sites are not affected.
• Working with Oracle support Team for Planning bug fixes and Coordinating with DBA Team for implementing the patches.
• Exploring new Functionalities of ASCP, APCC& GOP Modules to meet client requirements.
• Providing guidelines to Planning Business users to avoid issues in Production.
• Preparing ASCP, APCC Strategic documents and providing guidelines to New Project Teams on Emerson standards.
• Prepare and maintain UC4 Schedules for Gather schema statistics, Collections and Plan run requests.
• Implemented a solution to fix ATP Downtime issue due to the planning data collection process.
• Provided a solution to add a custom Row in Horizontal plan view of ASCP by using ASCP Custom Hook.
• Implemented Legacy collections to collect sales History and Supply data from Mainframe to Oracle Demantra.
• Provided a Custom solution to honor Sales order -WO linkage in ASCP Pegging logic by using Data Collection & Release Hook.
• Provided a solution to populate Custom Item attributes in APCC Fact tables by using APCC Custom Hook.
• Provided a solution to populate Production Line details in ASCP Workbench for all FG Supply orders by using ASCP Post Plan Processing Hook.
• Provided Support in Implementing GOP/ATP Solutions for different Business sites.
• Implemented Region/Zone based sourcing rules to populate Warehouse in sales order based on Customer Location and region/Zone In transit -Times for different Plants.
• Explored New Material plan and Resource plan view functionalities of APCC.
• Implemented MPS solution for planning of Finished goods and Critical components.
• Explored ASCP Worksheet Functionality, which is used to export plan data into Xl document for planner convenience.
• Implemented a solution to run Plans in parallel for different Lower Instances.
• Developed Product Family solution to implement Production Line Capacity for the Plant.
• Implemented Auto release of Planned orders for low value Stock Items.
• Implemented ‘Item simulation set’ to consider Post processing lead time of Finished goods for Planning.
• Worked on Oracle ASCP to setup Unconstrained plan options, setup for multi node instance, configured the planning flex fields, worked on the ODS Load process, defined the plans and plan options, worked on the ASCP Collection process.
• Functional Testing of the enhanced Solution on test instances and then promoted to production through RFC.
• Providing comprehensive training Materials and practice exercises
• Preparing the test plans for all the business scenarios and guided the users in UAT.

Confidential - Moosic, PA

Responsibilities:

• Working as an Oracle Applications Functional consultant.
• Walkthrough the existing setups, custom objects of the Application and gain the required findings for better understanding.
• Involving in high-level discussions in addressing client specific business scenarios.
• Developed Daily Program to Reset Planning Attribute to 'Not Planned' to reduce the Planning Load.
• Automation of Planning releases for low value Stock Items.
• Worked on Oracle ASCP to setup Unconstrained plan options, setup for multi node instance, configured the planning flex fields, worked on the ODS Load process, defined the plans and plan options, worked on the ASCP Collection process.
• Worked on the WIP setups like WIP Parameters, WIP Accounting Classes, WIP Profile Options etc.
• Worked on BOM Setups - defining the resources, resource usages, resource cost rollups, setting up routing, defining departments and assigning resources to departments, setting up BOM Parameters, etc.
• Worked on the Item Master Setups in Inventory module, defining of item templates, categories, catalogs, defining item attributes, enabling items in various organizations, controlling item attribute changes by implementing controls, etc.
• Implementing Blanket Purchase agreements, Blanket Releases, Sourcing rules and Approved Supplier lists. once the planner releases planned order from Planning board, it should create blanket releases automatically.
• Developed Discoverer Reports for Requisitions and Work orders interface errors to improve traceability of the Planner.
• Implemented Statistical Forecasting for all Stock Items and covered under planning to Reduce Stock outs of Stock Items.
• Analyzing the parameters involved in cycle counting, physical inventory and setup of ABC classes for teams to aid in implementation of counting methodology
• Developed Item Catalogs, Pegging Reports to reduce too much Time Spent On Master Data Management By Planners.
• Testing of the enhanced Solution on test instances and then promoted to production through RRC.
• Providing comprehensive training Materials and practice exercises
• Preparing the test plans for all the business scenarios and guided the users in UAT.

Confidential - Lebanon, OH

Oracle VCP Production Support

Responsibilities:

• Worked as an Oracle Applications Functional Consultant.
• Provided Oracle Functional support for ASCP, GOP modules.
• Responsible for following up the issues logged by end users, resolving the issues, documenting the resolutions.
• Worked with Business Users on a daily basis, providing functional support assistance to ensure the successful flow of the Business processes.
• User Interaction and getting the information to understand the issue.
• Interacting with Technical consultants discussing on Developments and providing Functional Requirements.
• Prepared the different Functional Design Documents and describing to Technical Consultants.
• Debug the issues related to Planning data collections & plan run and provided the fix.
• Provided fix for different sales order scheduling issues due to ATP/GOP setups.
• Training the end users and preparing end user training material.
• Testing on developed functionalities in non-production instances and sending notification to Track Owners and Super Users for the approvals to migrate the development to Production.
• Creation of Oracle Support Requests (SR), providing action plan updates, applying data fixes, patches as applicable.

Confidential

Oracle EBS Implementation

Responsibilities:

• Worked as Oracle Applications Functional consultant.
• Gathering requirement and business processes for Implementing Oracle Applications.
• Mapped business process with the Oracle Application e-business suite.
• Prepared BP 40 & 80 (As Is & To Be Process Documents)
• Involved in setups for SCM modules as per company’s specific requirement.
• Preparing BR 100 Documents.
• Updated Requirement Specification Document based on Change Request.
• Configured the test instance and tested the required functionalities to meet the functional requirement.
• Prepared the test plans for all the business scenarios and guided the users in UAT.
• Involved in CRP Testing.
• Raising SR to Oracle for Critical Issue Solution.
• Prepared the training documents.

Confidential

Oracle EBS Production Support

Responsibilities:

• Worked as an Oracle Functional consultant for SCM Module.
• Troubleshooting and resolution of functionality issues in INV and OM including min-max planning and restock, cycle counting and physical counts.
• Provided Oracle Functional support for ASCP module.
• Working with Business Users on a daily basis, providing functional support assistance to ensure the successful flow of the Business processes.
• Responsible for closing the issues after interacting with the respective users, assisting the users.
• Reviewed and corrected setups as necessary per module.
• User Interaction and getting the information to understand the issue.
• If the issue requires the support of development, then transfer the issue to development team with the inputs. Monitor and help development team to complete the task.
• Raising SR with Oracle for getting assistance in resolving the issues.
• Interacting with Technical consultants discussing on Developments and providing Functional Requirements.
• Preparing Test Cases, Test Data & testing.
• Training the end users and preparing end user training material.

Confidential

Oracle EBS Implementation

Responsibilities:

• Worked as an Oracle Applications Functional consultant.
• Interacting with super users of the proposed systems and discussing and understanding business requirements.
• Responsible for defining and setting up complete order cycle setups from order entry in order management to ship confirm in shipping execution module to support business requirements.
• Wrote business requirements documentation for purchasing setup and Order Management.
• Performed setups for inventory and purchasing.
• Analyzing the parameters involved in cycle counting, physical inventory and setup of ABC classes for teams to aid in implementation of counting methodology
• Setting up Drop Shipment process, shipping parameters - Picking Rules, Pick slip grouping rules, Release Sequence rules.
• Supporting day to day operational issues, testing application functionality for new patches.
• Providing comprehensive training Materials and practice exercises.
• Analyzed the defects, bugs and raised oracle SR for data fixes and resolutions.
• Prepared the test plans for all the business scenarios and guided the users in UAT.
• Conducted CRP’s (Conference Room Pilots) to ensure that the e-commerce business processes were defined for all major business processes and could be performed successfully using Oracle Applications.

Confidential

Oracle EBS Production Support

Responsibilities:

• Worked as an offshore Functional support for the distribution modules like Inventory, order management and Purchasing.
• Working with Business Users on a daily basis, providing functional support to ensure the successful flow of Business processes.
• Responsible for following up the issues logged, resolving the issues, documenting the resolutions.
• Raising SR with Oracle for getting assistance in resolving the issues.
• Interacting with Technical consultants discussing on Developments and providing Functional Requirements.
• Attending weekly status meeting with the team and updating status of the Issues.
• Testing on developed functionalities in non-production instances and sending notification to Track Owners and Super Users for the approvals to migrate the development to Production.
• Creating solution documents once fixed the issue in Development Instance and sending to Super Users for their approvals.

Confidential

Senior Design Engineer

Responsibilities:

• Extensively involved in Taking Orders from the Customers.
• Developing the various Subassembly layouts and Machine layouts as per the customer requirements.
• Solving Manufacturing problems, Assembly problems and Customer service problems within minimum possible time and maintaining good relationship with customers.
• Satisfying customer requirements on top priority basis both in terms of quantity and quality.
• Achieve agreed & planned targets.
• Involved in attending the customer to clarify their Enquires by providing the customers with Catalogs of the products required by the customer.
• Involved in taking care of the delivery of the product ordered by the customer.
• Involved in providing suggestions regarding the delivering of product and regarding the services.
• Ensure the required inventory at all stages of the supply chain.