EXPERIENCE SUMMARY:

• Overall 12+ 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 4 Years of Manufacturing Domain experience.
• Proficient in Oracle Value Chain Planning modules (ASCP, GOP, APCC & Rapid Planning) and Oracle EBS modules (Inventory, Purchasing, Order Management, BOM, WIP) and Knowledge in Inventory Optimization (IO), General Ledger, Advanced Pricing, Costing & i Supplier.
• Effectively involved in Requirement gathering, analyzing business requirements, System Mapping, Conference Room Pilot and Postproduction support.
• 5 Full life cycle implementation of Oracle VCP Modules and Oracle E - Business Suite (MFG & SCM 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, VCP Upgrade 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 & VCP 12.1.3.7, VCP 12.2.4.1

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 & 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

Oracle VCP Functional consultant

Responsibilities:

• Responsible for configuring the system for different VCP Modules like ASCP, GOP, APCC & RP.
• Conducting and analyzing the User requirement study of the client business processes and documenting along with conducting Fit gap analysis for clients As-Is process and documentation.
• Mapping the business processes of clients to those offered by Oracle, and carrying out GAP analysis to arrive at workarounds and a complete TO-BE solution for all business scenarios
• Involving in high level discussions in addressing client specific business scenarios.
• Participating in regular project status reporting and steering committee meetings with client management.
• Supporting DBA Team for post cloning activities of both EBS and APS Instances.
• Providing Support in resolving different performance issues with collections and plan run.
• Prepared the different Functional Design Documents and describing to Technical Consultants.
• Implemented APCC Dashboards, data collection setups, APCC Profile option setups.
• Implemented a global solution to fix ATP Downtime issue due to the planning data collection process.
• Provided a solution to add custom rows in Horizontal plan view of ASCP.
• Provided a custom solution to honor Sales order- WO linkage in ASCP Pegging.
• Provided a solution to run ASCP Plans in parallel in different Lower Instances.
• Exploring New material plan and New resource plan of APCC.
• Walkthrough the existing setup of the application and gain the required findings for better understanding.
• Planning and execution of Unit, Integration (SIT), and User Acceptance Testing (UAT) through the development of test scripts
• Carrying out Confidential ( Confidential ) to obtain user sign-offs
• Providing post-production support after Go-Live
• Providing comprehensive training Materials and practice exercises.

Confidential, Moosic, PA

Oracle Applications VCP Functional consultant

Responsibilities:

• Responsible for configuring the system for ASCP, GOP and APCC Modules.
• Conducting and analyzing the User requirement study of the client business processes and documenting along with conducting Fit gap analysis for clients As-Is process and documentation.
• Involved in high level discussions in addressing client specific business scenarios.
• Drafting the solution design for client specific business processes.
• Worked on the ASCP Setups - setting up the Item planning attributes, planners, planning parameters, defining the plan options, collection parameters, setting up Instances, ATP Rules.
• Implemented APCC Dashboards, data collection setups, APCC Profile option setups.
• 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.
• Automation of Planning releases for low value Stock Items.
• Supporting DBA Team for post cloning activities of both EBS and APS Instances
• 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, Lebanon, OH

Oracle VCP Functional Consultant

Responsibilities:

• Responsible for configuring the system for ASCP and GOP of Oracle applications.
• Mapping the business processes of clients to those offered by Oracle, and carrying out GAP analysis to arrive at workarounds and a complete TO-BE solution for all business scenarios
• Configuration/set up and implementation of the Oracle Applications test Oracle instances and later on the production instance
• Worked on the ASCP Setups - setting up the Item planning attributes, planners, planning parameters, defining the plan options, collection parameters, setting up Instances, ATP Rules.
• Conducting and analyzing the User requirement study of the client business processes and documenting along with conducting Fit gap analysis for clients As-Is process and documentation
• Involved in high level discussions in addressing client specific business scenarios.
• Drafting the solution design for client specific business processes.
• Prepared the different Functional Design Documents and describing to Technical Consultants.
• Training the end users and preparing end user training material.
• Prepared the test plans for all the business scenarios and guided the users in UAT.
• Creation of Oracle Support Requests (SR), providing action plan updates, applying data fixes, patches as applicable.

Confidential

Oracle Applications Functional consultant

Responsibilities:

• 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 Confidential 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 Modules.
• Troubleshooting and resolution of functionality issues in INV and OM including min-max planning and restock, cycle counting and physical counts.
• 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 Applications Functional consultant

Responsibilities:

• 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 Confidential ’s 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.
• Responsible for closing the issues after interacting with the respective users, assisting the onsite and offshore users