
Pankaj Gupta
- SAP SCM SD RAR FUNCTIONAL CONSULTANT
- Wilmington, DE
- Member Since Apr 30, 2023
Pankaj Gupta
SAP SCM SD RAR FUNCTIONAL CONSULTANT
Profile:
Total 10 Years of experience in SAP SCM SD Module. My expertise in SAP SD module includes Configuration, Designing, Testing, Implementation and Support. Core areas of expertise in Sales and Distribution Module include Configuring (OTC) Order to Cash process (which includes Sales Order Management, Customer Master set up, EDI experience using Standards, Third Party Logistics Integration through EDI, Logistics execution and Billing), Revenue Recognition, Special business scenarios and SD basic functions. Responsible for integration of SD with MM, PP, and FI module.
SAP Experience summary
· Experience in all phases of the Project Lifecycle from user requirements, analysis, design, development and implementation of SAP SD, LE functionalities.
· Experience in SAP Data conversion using Extraction, Transformation and Loading Techniques
· Experience on Revenue Recognition and Revenue Accounting Reporting 1.2
· Experience on Special business processes Pre-Bill, Interfaces – PAC, PCR, PAMS
· Experience on Current and Future GAAP for calculation of SSP in License and Maintenance Process
· Worked on RAR monitor for SD01, SD02 and SD03 and Revenue Recognition Process
· Experience in IDOC and SAP POS Inbound processing configurations
· Experience in Subsequent Listings and assortments
· Experience in Business Engagement, Data Profiling and cleansing, Clear Data Quality entry and Data Governance
· Worked on Data Extraction Tools for SAP and Legacy system with rules applied, Source mapping and Target Mapping and Loading the data using LSMW, BAPI, IDOC etc.
· SAP Supply Chain expertise from the standpoint of understanding the capabilities and limitations of SAP supply chain solutions, understanding how SAP can be used to meet the needs of the business and how SAP can solve business problems
· Design and configuration experience in one or more of the following modules SD, MM, IM, and APO
· Experience with reverse logistics and 3rd party logistics
· The ability to interact with fellow team members and business owners and translate business requirements into SAP solutions
· The ability to provide SAP best practices and overall solutions advice to fellow team members
· Prior analyst / business process owner experience a plus
· Experience in Configuration includes Standard Orders, Consignment Orders and 3rd party order processing, 3rd party Logistics Interface, intercompany Orders, STOs.
· Shipping and Transportation: Expertise in configuration of Delivery Processing, Delivery Types, Packing List, Picking List, Goods Issue, Transportation processing, Routing and Route Determination, STOs, etc.
· Support the global deployment of SAP Hybris within the corporation
· Responsible for the production monitoring, Incident/Problem Management and peak season readiness activities for the Hybris modules
· Develop, test and implement SAP Hybris solution enhancements
· Business Partner Replication, Product Replication, Export License, License Rules, US ECCN and EU ECCN
· Experience in Reporting EDI status to SAP including SAP Status codes, creating custom messages, Mapping the Status IDOCs, Inbound/Outbound
· Configuration Expertise in Special business scenarios like Revenue Recognition, Variant Configuration, Variant Pricing, SAP Data Migration, MTO and MTS Configuration, Availability check/Transfer of Requirements, Inter-Company Sales, Stock transport orders using SD delivery, Inventory Management in MM, Third Party logistics and Individual purchase orders.
· Expert in Shipping Point Determination, Route Determination, Transport and Delivery Scheduling, Backward Delivery Scheduling, Partial and Complete Delivery, Subsequent Outbound Delivery Split and Grouping of Deliveries.
· Variant Configuration: hands on experience on Super BOMs, Super routings, Configuration profile, Object dependencies, Constraints, and Pricing.
· Configured Consignment Sales, Shipping, Shipment cost settlement, Billing, Returns order processing, Complaint processing and all SD Basic functions like Pricing, Free Goods, Material determination, Credit management, Output determination, Material listing, Exclusions, Partner Determination, Incompletion log and Text Determination
· Responsible for identifying the User-Exits and prepare the functional specification with the business requirement.
· Responsible for creating variants and setting up of Background jobs.
· Configured Classes, Characteristics, and profile in Variant configuration.
· Worked on EDI 850 (Sales Order), EDI 940 (Delivery Notification), EDI 856 (Advanced Shipment Notification), EDI 945 (Delivery Confirmation), EDI 810 (Invoice)
· Experience on Warehouse Management, Production Planning and Quality Management
Technical Skills
Operating Systems : Windows2003/2000/NT/98/XP/Vista
ERP Applications : SAP R/3, SAP CRM4.0, SAP BW3.0b
Cross Applications : RFC, ALE, EDI, and IDOCS
RDBMS : ORACLE 8i
Employment Summary
Client: Accenture / DuPont April’2017 to August’2017
Project Scope : SD/MM and GST Implementation
Project Category: SAP Version ECC 6.0
Location: Wilmington, Delaware
Specific Role: SAP SD GST Tax Implementation, SAP SD RAR
· Setting up Taxation for GST Implementation
· Preparation of Functional Design Document for Output Layout and GST Reports
· Configuration of New Pricing Procedures for GST specific tax calculation
· Configuration of Tax condition types – Central, State and Integrated Tax.
· Application of OSS Notes on specific business scenarios as part of GST Implementation
· Worked on the Five Step Framework Identifying the contract, Identifying the POBs, determining the Transaction price, allocation of transaction price to POBs, Recognize the revenue based on POBs satisfied
· Worked on the workstreams of Supply Chain Order to cash, Making, Demand Planning and Purchasing
· Worked on Master Data Relevant for Supply chain including Customer, Vendor, Business Partner
· Worked on the reporting using SAP S/4 HANA
· Worked on the SAP Order Management including structure of sales order, Plant / Shipping point determination and Item Category determination
· Worked on Item category determination table T184 and User Exits
· Worked on ATP Rules, Availability check, Delivery scheduling, Rescheduling and RLT
· Worked Route Determination formula, Schedule lines and Replenishment Lead time calculation
· Worked on Pricing routine, Function Modules and User Exits to function the process
· Worked on Output Determination for Invoices, Delivery and Sales Order
· Review, analyze, and solution change requests to determine complexity and provide resource/cost estimates
· Provide information to IT and Business leadership regarding best practices, industry trends and business opportunities, as well as, feedback on the overall performance of processes and tools
· Understand key business controls and impacts of changes caused by functionality, technology changes and changing business needs
· Work with business counterparts to meet audit, SOX and other compliance requirements
· Identify and initiate process improvements (continuous improvement)
· Help Conduct Unit tests, Integration tests, Regression tests, Performance Tests and Disaster Recovery Tests
· Train and transfer knowledge to other team members, users and stakeholders as required
Client: Pega Systems January’2017 to March’2017
Project Scope : SD/MM and RAR 1.2 Production Support
Project Category: SAP Version ECC 6.0
Location: Cambridge, Massachusetts
Specific Role: SAP SD Pricing, Contract to Cash Management, Exposure to RAR 1.2
· Primary objective for Resolution of Production Support Issues
· Worked on Periodic and Milestone Billing for Pega Business scenarios
· Worked on License and Maintenance process for Pega on Contracts to Cash
· Worked on CPI, SSP (Standalone Selling Price) related issues in SD pricing area
· Worked on Revenue Recognition and Revenue Accounting Reporting 1.2
· Work on providing Business as Usual support of SAP Hybris within the corporation which involves break fixes and change requests
· Set up Customizations for Revenue Recognition Item Categories
· Configuration specialist for SAP Revenue Accounting and Reporting and Application Installation Process
· System Requirements, Installing SAP RAR, setting up Item classes RAI, setting up SAP Business client, Integrating with SAP Business warehouse
· Step by step configuration for Inbound processing, Revenue Accounting Contracts, Revenue Accounting postings, Integration with SD and Non SD Applications, BRF+ Integration, Decision tables and Account Determination in BRF+
· Processing of Revenue Accounting Contracts and Generation of RAIs from SD and Non SD applications
· Stages of RAI Processing and Processing RAIs through Adapter Reuse Layer
· Customizing and enhancing RAI items, Revenue accounting contracts Navigation, Revenue schedule and POBs
· Worked on price allocations, contract combinations, contract fulfillment, Invoices in Revenue accounting contracts
· Worked on revenue recognition processes and postings to FI, Foreign currency exchange processing with version 1.3 and simplification for High volume invoice processing
· Worked on Attributes of POBs allocation data, fulfillment data, general data and account assignment
· Collaborate with representatives of other SAP functions to ensure end to end process integration and consistency develop, prototype, test and implement solution improvements to increase stability, usability and functionality to enable end users to meet business objectives
· Worked on Special business processes Pre-Bill, Interfaces – PAC, PCR, PAMS
· Worked on Current and Future GAAP for calculation of SSP in License and Maintenance Process
· Worked on RAR monitor for SD01, SD02 and SD03 and Revenue Recognition Process
· Worked on Customization for Revenue Recognition Item Categories
· Worked on Customization for Copy Control settings
· Worked on Customization for Condition Tables, Pricing Condition Types and Access sequences
· Worked on Customization for Billing Types and Output Determination procedure
Client: Saint Gobain, Certain Teed Sep’2016 to November’2016
Project Scope : SD, MM/WM, PP, and FICO
Project Category: SAP Version ECC 6.0
Location: Malvern, Pennsylvania
Specific Role: SAP Pricing, SAP RAR, SAP EDI implementation
Responsibilities
· Data Migration for customer master from Legacy system to SAP System
· Worked on Customizing Sales Document Types, Item Categories and Schedule Line Categories
· Step by step configuration for Inbound processing, Revenue Accounting Contracts, Revenue Accounting postings, Integration with SD and Non SD Applications, BRF+ Integration, Decision tables and Account Determination
· Experience in SAP Data conversion using Extraction, Transformation and Loading Techniques
· Experience in Business Engagement, Data Profiling and cleansing, Clear Data Quality entry and Data Governance
· Worked on Data Extraction Tools for SAP and Legacy system with rules applied, Source mapping and Target Mapping and Loading the data using LSMW, BAPI, IDOC etc.
· Worked on Warehouse Management, Production Planning and Quality Management
· Business blue print documentation for Outbound Delivery Processing and 3PL interface documents related to Wholesale, Retail drop ship, Professional sale/ Large residences, SIS (Consignment).
· Master Data: Configurations including customer master, material master, product hierarchies, customer hierarchies, combining sales area elements, condition records for both pricing and outputs.
· Worked on Periodic billing and Milestone Billing for Gypsum and Ceilings business
· Prepared Functional specifications and Developed program for customer master partnering
· Prepared Functional Specifications and Developed program for Customer Hierarchy
· Worked on Resource Related Billing and Result analysis
· Performed end to end Functional Unit Testing for Customer Master data conversion program functionality
· Participated in Business hubs for SAP EDI implementation
· Requirement Gathering for EDI field mapping with SAP
Employment Summary
Client: Pitney Bowes; Company – Accenture Mar’2014 to Jan ’2015 Project Scope : SD, MM/WM, PP, PS and FICO
Project Category: SAP Version ECC 6.0
Location: Hartford, Connecticut
Specific Role: SAP Pricing and Revenue Recognition Configurator, Customer Master Data Governance
Responsibilities:
· Worked on Revenue Recognition and setting and customizing item categories for deferred revenues.
· Worked on Periodic Billing and Milestone billing
· Worked on Resource Related Billing using DIP profile
· Worked on Customization for Revenue Recognition Item Categories
· Worked on Customization for Copy Control settings
· Worked on Customization for Condition Tables, Pricing Condition Types and Access sequences
· Worked on Customization for Billing Types and Output Determination procedure
· Worked on SAP Invoice creation using Smart Form and Integrating with ECC
· Created Partner Profiles and Configured Outbound and Inbound Parameters with Message type, Partner Type, Partner Role, Basic Type
· Worked on Revenue Based Method with Profit Realisation, Cost Based POC Method
· Actively participated in scoping sessions with Business process owners to understand the requirements.
· Worked on customer master data set up in SAP from Legacy system using LSMW and BDC
· Used ETL tool for transformation and Loading process of customer master data from legacy system
· Handled the Challenges in Field mapping of customer master (Centrally and Complete) in SAP
· Worked on specific fields like Name, Search Term, Country, Jurisdiction code for Tax Interface system
Client: Microsoft; Company - Accenture Feb ’2013 to Feb ’2014
Role: Sr. SAP SD Consultant and Team Lead
Location: Redmond, WA
· IDOC Based solution for invoicing
· MS Project Development for its Business Process
· Onboarding Currency change for Latvia Country
· Onboarding Sales Org. for Commerce Platform Brazil
· Worked on Project Management, Agile Methodology, Tool VSTF
Responsibilities:
· Worked on customizing Sales Document types, Delivery Types and SD Billing Types
· Worked on Customization for Revenue Recognition Item Categories
· Worked on Customization for Copy Control settings
· Worked on Customization for Condition Tables, Pricing Condition Types and Access sequences
· Worked on Azure Process in SAP SD and mapping with Feedstore and MS SALES process
· Worked on End to End Business Process Azure in EA, analyzing BRD, Prepared Functional Specifications, Review with client, Test case Preparation, TSD preparation with ABAP
· Worked on Azure SAP and IDOC mapping structure
<span style="font-size:11pt;font-family:Symbol