ANSHU VERMA
ORACLE EBS SCM CONSULTANT
Phone: 585-***-****
Email: **********.***@*****.***
EXPERIENCE SUMMARY
•Around 12+ years of diverse experience as a Functional Consultant in Oracle EBS Supply Chain Management and Logistics(Inbound/Outbound) Modules. Around 2 years of Functional experience in Oracle Transportation Management and Logistics.
•Rich experience in Oracle E-Business Suite R12 modules of Order Management (OM), Shipping (WSH), Warehouse Management System, MSCA(Mobile Supply Chain Applications), Advanced Pricing, Bills of Material (BOM), Work in Process (WIP), Purchasing (PO), I-Procurement, Inventory (INV), i-Receivables, Accounts Payables (AP), Oracle Transportation Management (OTM), AOL, System Admin, and integrated custom applications.
•Experienced working in the various phases of the software development life cycle (SDLC) using methodologies like Waterfall, Agile and Scrum.
•Implementation, Change Control and Production support of Oracle EBS R12.
•Business Requirements gathering, Gap analysis, solution design, configurations & setups, Test Plan Preparation, Unit Testing, System Integration testing.
•Brainstorming sessions, Root Cause Analysis, Risk Analysis, Functional Walkthroughs, meetings with all stakeholders in the project.
•Oracle AIM methodologies including preparation of MD50, TE20 and BR100 documents.
•Experience in working with My Oracle Support via Service Requests.
•Experience working with Developers and Business Users based in different geographies.
•Experienced in conducting and supporting Systems Integrated Testing, User Acceptance Testing, QA Processes including Test Plan preparation, Test Scripts execution and working with multiple testing environments.
•Generate reports by executing SQL queries against databases such as Oracle.
•Excellent judgment skills in identifying areas of high-risk, critical business areas, early in an application and prioritizing my tasks to focus my efforts when time is limited.
•Highly motivated team player with good communication and interpersonal skills.
•Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
SKILLS
Oracle Applications
Oracle Applications R12 and 11i; Order Management (OM), Inventory (INV), Purchasing (PO), Oracle Shipping Execution (WSH), Accounts Receivable (AR), Advanced Pricing, Bills of Material (BOM), Work In Process (WIP), Warehouse Management System (WMS), Oracle Transportation Management (OTM) and Application Object Library (AOL).
Productivity Packages
MS Word/Excel/PowerPoint/Outlook
RDBMS
Oracle 19c
Operating Systems
MS-Windows & DOS, Mac OS
EDUCATION
Masters in Biomedical Instrumentation, Year 2012
BIT Mesra, Ranchi, Jharkhand, India.
Bachelor of Science, Year 2009
JWC, Jamshedpur, Jharkhand, India
CERTIFICATIONS/AWARDS
•OCI Foundation Associate
•OCI AI Foundation Associate
PROFESSIONAL EXPERIENCE
Oracle EBS Functional Analyst May 2022 - Till Date
Client: Trane Technologies, Davidson, NC
Project Title: Commercial and Residential HVAC Enhancements
Responsibilities:
•Implementation, Change Control and Hypercare production support of Oracle EBS Projects and ADCRs for Residentials HVAC region.
•Business Requirements gathering, Gap analysis, solution design, configurations & setups, Test Plan Preparation, Unit Testing, System Integration testing, and production support.
•MD50,BR100 documentation for the projects and ADCRs.
•Worked on JIRA board which is a project management tool where we used various methodologies like Agile, Scrum and Kanban. They provide visual representation of Project workflow facilitating task tracking, team tracking and team collaboration.
•Worked on enhancement on the Oracle Modules of INV, OM, PO, Shipping, Planning, OTM, MFG, WMS, SYS ADMIN, AOL.
•Worked on the Oracle Supply Chain Integration with Oracle and 3rd Party Logistics, both Inbound and Outbound.
Environment: Oracle EBS (Order Management, Purchasing, Inventory, Manufacturing, Shipping, WMS), Oracle Transportation Management (OTM), Fusion Middleware.
Oracle EBS Functional Analyst March 2021 - April 2022
Client: Trane Technologies, Davidson, NC
Project Title: Application Managed Services-Oracle Logistics Functional Analyst
Responsibilities:
•Understanding the existing business processes and Standard Work.
•Supervised and directed the knowledge transition activities.
•Resolving Incidents assigned to Logistics team.
•Discussing with business users and end users regarding the issues and ensuring timely resolution of Incidents.
•On Call and Daily Monitoring activities.
•Regression Testing and Sanity Testing of Integrations using Standard Work.
•Integration testing as part of BCP and DR activities.
•Updating MD50 (Functional Specifications) and preparing promotion sheets for code movement to Production.
•Debug and progress stuck Orders in Oracle EBS R12 using Order Management, Inventory and Shipping and Fusion Middleware.
•Supporting Dematic Voice Activated Picking in some warehouses.
Environment: Oracle EBS (Order Management, Purchasing, Inventory), Oracle Transportation Management (OTM), Fusion Middleware, Dematic.
Oracle SCM Functional Analyst Jan 2020 - Feb 2021
Client: IU Health, Indianapolis, IN
Project Title: Oracle Release 12.2.8 SCM Implementation
Responsibilities:
•Understanding the existing business processes.
•Worked on the Implementation of Oracle Release 12.2.8 SCM Modules.
•Implementation of Order Management, Advance Pricing, Purchasing, Oracle Transportation Management (OTM) modules.
•Discussing with business users and preparing business process documents like BP80 for future Process documents.
•Preparing of all the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents. Worked on the configuration Order Management, Advance Pricing, Purchasing, Inventory, Oracle Transportation Management (OTM) modules.
•Involved in configuration of Oracle Transportation Management (OTM) - Business Process Monitor, Automation Agent, Saved Query, Saved Condition, Complex Expression, Action Check, User Access.
•In Advance Pricing, Defined Pricelists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing. Modifiers include discounts, freight discounts and point price breaks.
•Providing support to users after implementation is done and fixing all issues related to set ups. Conducting CRP 1, CRP2 UATI and UAT2 and helping the user for going through all the test cases.
•Interacting with upper management to identify the business process and needs and with end users to identify their requirements.
Environment: Oracle Applications Release 12.2.8 Implementation and Rollout for US, Canada, iProcurement, iSupplier, Advance Pricing, Purchasing, Inventory.
Oracle SCM Functional Consultant June 2017 – Dec 2019
Client: Cox Automotive, Atlanta, GA
Project Title: Implementation of Oracle EBS Release 12.2.7
Responsibilities:
•As a Business Analyst Supported SCM processes in Release 12.2.7.
•Conversions & Enhancements for Order Management, Advanced Pricing, i-Procurement,
i-Supplier, Purchasing, Inventory, Accounts Receivables (AR), Accounts, Payables (AP), General Ledger (GL)
•Worked in configuring the Approval Hierarchies in PO module.
•Worked on the setup of i-Procurement module including the setting up of Catalogs, Categories and Uploading Items into i-Procurement, Punch-out's both transparent and direct.
•Worked on the setup of Purchasing Options, Financial Options and Document Types in PO Module.
•Worked on the configuration of the Intercompany transactions using the Internal Requisition Internal Sales Order (IRISO) process.
•Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
•Configurations in AR, GL, i-Procurement, i-SuppIier, PO, FA, Cash Management, AP modules and created BRI 00 documentation for the setups.
•Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
•Conducted Regression testing to examine the effects of a new Org on the previous Org.
•Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
•Provided training to the users in Oracle EBS modules of PO, INV, OM, AR, AP, GL.
Environment: Oracle Apps 12.2.7 (Order Management, Advance Pricing, i-Procurement, iSupplier, Purchasing, Inventory.
Oracle SCM Functional Consultant May 2012 – Jan 2016
Client: Flipkart, Bangalore, India
Project Title: Implementation of Oracle EBS Global Rollout
Responsibilities:
•As a Functional Consultant implemented the Order to Cash Business flows including Order Management, Advance Pricing, Inventory, AR and GL
•Performed Requirement and Gap analysis.
•Configurations and Setups for OM, AR, INV, GL and AP modules
•Worked on the setup of Revenue Recognition in AR module.
•Setup of Accounting and Invoicing rules in AR module.
•Defined the Auto Lock Box process in AR module.
•Defined the Auto invoice process in AR module.
•Worked on the Functional Mappings for data conversion from 11i to Release 12 for Distribution and SCM modules.
•Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
•Pre upgrade testing and Post upgrade production live support.
•Support Production issues on a day-to-day basis including month end closure issues.
Environment: Oracle Applications 11i and 12.1.3 (Order Management, Purchasing, Inventory, Accounts Payables, Accounts Receivables, General Ledger).
PERSONAL DETAILS
Date of Birth: March 2, 1986
Nationality: India
Marital Status: Married
Location: Victor, NY