Candidates About

 

Sunil Kumar Ratala

SUMMARY

• 12 years of professional experience as SAP Consultant currently center focused on SAP TM and SAP EM projects execution.
• Last 5 Years of experience in SAP TM and SAP EM with 3 Implementations project experience, including production support and enhancements.
• Previously 7 years of experience in SAP ERP - SD, MM and LE/WM modules, including production support and enhancements. SAP Certified Application Associate in SAP SD, MM and LE/WM modules, have in-depth knowledge on business processes execution.
• Worked for global clients such as Smithfield Foods, Under Armour (UA), Apple, HD Supply (HDS), Intel, Baker Hughes(BH), Johnson Controls (JCI), and Rockwell Automation (RA).
• Sound ABAP debugging and configuration skills; Provided functional support for development of WRICEF - Workflows, Reports, ALV, Dialog programming, Interfaces with external systems using RFC/IDOCs, SAP Scripts/smart forms, functionality in XI/PI, Enterprise Portal (EP) integration with SAP ECC, User Exit and Screen Exit Developments, Data conversions, Batch Job management, BDC programs using batch input method and call transactions.
• End-to-End projects experience; Building commercial POCs in SAP TM and EM, involving requirements study, project preparation, gap analysis, blue printing, realization, design, configuration, customization, developing test scripts, unit testing, integration testing, cutover activities, conducted user training, prepared user training documentations, go-live and support.

·         Expertise in complete SCM-TM functionalities; (Transportation Order Management, Transportation Planning, Transportation Execution, Charge Calculation and Freight Settlement and carrier invoice processing, TM Master data setup, Transportation Network setup, BRF+ conditions, Incompatibilities,  Interactive planning with cockpit, Automatic planning, Pooled shipments, International shipments, Freight unit building rules setup (FUBR), Carrier selection, Freight order Tendering, FO integration with ERP shipments, Transportation event monitoring, Transportation charge Management (TCM), Transportation cost distribution).

·         Expertise in complete SCM-EM functionalities; (EH type and Event message configurations, Rule set logic, Processing and EH generation functions, Internal/External event codes and mapping, Web UI integration, Archive Strategy, Carrier 214/315 integrations for Ocean/Air/Road scenarios in LTL/FTL/LCL/FCL, EVMSTA02 IDOC integration, Notifications and Exception handling, BADI enhancements, EM to downstream integrations for Reporting, ECC to EM extraction, TM to EM extraction and SNC to EM extractions), Managed end-to-end Carrier onboarding with all major global carriers like UPS, FedEx, DHL, TNT, etc.

 

SAP TM KNOWLEDGE

          SAP TM Functional (9.X/8.X): TM Planning and Optimization / Order & Delivery Integration and Freight Unit           Building/Tendering and Carrier Selection, Transportation charge Management (TCM) and Freight settlement,           Change Controller strategies, Carrier Collaboration Portal / BRF+, Routing guide Setup / Third Party Integration           (SMC3/XPS/PC-Miler) / Freight forwarder and LSP processes and functionalities

          SAP TM Technical: Good understanding of TM Business objects, PI Proxies, SAP TM Classes and Methods, Post-   Processing framework (PPF).

SAP EM KNOWLEDGE

            ECC-EM data extraction, TM-EM data extraction, Event handler & Event message  Integration via RFC, Pre-            processing, Event Handler and Event message model, Rule set functionality , EM UI configuration and             customization, EDI-214 &315, Integration of EM with other applications, Carrier API setup, Carrier on boarding.

INDUSTRY EXPERIENCE

            Food Industry, Apparel & Footwear, Retail & Consumer Industry, Oil & gas, Chemical Engg, Automotive,             Manufacturing & Logistics

 

PROJECTS EXPERIENCE

Smithfield Foods, Kansas City, MO

SAP TM Consultant – One SAP project Implementation & Support

October 2017 to till date

Smithfield Foods is a leading consumer packaged meats company, also the world’s largest pork processor and hog producer, committed to providing good food in a responsible way. We accomplish that by maintaining robust animal care, community involvement, employee safety, environmental, and food safety and quality programs.

·         24*7 production support to resolve TM tickets as per agreed SLA.

·         Monitoring, trouble shooting and enhancements in TM planning, execution and settlement areas.

·         Planning for FTL, LTL, Cartage, drayage, customer pickup and parcel scenarios using TM optimizer in transportation cockpit

·         TM Planning for Rail, Ocean and Air scenarios.

·         Transportation execution via Fourkites third party system to capture all the truck events using REST API integration.

·         Distance, duration calculation and geo mapping integration via PC-MILER third party system using RFC call.

·         Charge Calculation, Freight settlement document(FSD) creation, cost distribution in TM based on number of pallets and Agency business documents setup in ECC for distribution of cost.

·         Execute and Monitor Freight execution via Collaboration portal in TM.

 

Under Armour, Baltimore, MD

SAP TM Consultant – Project 20/Twenty

June 2017 to October 2017

Under Armour, Inc. is engaged in the development, marketing and distribution of branded performance apparel, footwear and accessories for men, women and youth. The Company's segments include North America, consisting of the United States and Canada; Europe, the Middle East and Africa (EMEA); Asia-Pacific; Latin America, and Connected Fitness. Its products are sold across the world and worn by athletes at all levels, from youth to professional, on playing fields around the globe, as well as by consumers with active lifestyles. The Company sells its branded apparel, footwear and accessories in North America through its wholesale and direct to consumer channels.

 

·         Execute and Monitor of Ocean/Air Freight for Inbound logistics planning & Execution.

·         Execute and Monitor Truck (Parcel) outbound logistics planning & Execution.

·         Execute and Monitor Freight execution via Collaboration portal

·         Responsible for enhancements in the area of ECC integration with PI and TM integration with PI in order to capture new data elements in ECC and TM.

·         Calculate Parcel Transportation costs & Non-Parcel Transportation charges.

·         Design & Integration between TM and GTS for import and export process.

·         Design & Integration between TM and SNC for integrating with Vendors and third party logistics providers.

·         Trigger Alerts & Notifications to Under Armour business users for exception messages reported by carriers and when the expected event becomes overdue via Expected event monitoring.

·         Design & Integration b/w TM to EM extraction for creating Event handlers and posting event messages for tracking various TM process documents – Freight Unit, Container Unit, Freight Order and Booking Orders.

·         Design & Integration b/w GTS to EM extraction for updating Import and Export events reported by Customs execution.

·         Design & Integration b/w SNC to EM for updating Ready to Ship Confirmed (RTS) events and triggering alert to SNC via Rule set when Cargo Receipt event reported by carrier.

·         Design & Integration for Carrier 214 to send LTL/FTL/Parcel events for SAP EM via PI system and GSX/XPS systems. GSX is for Inbound scenario and XPS is for Outbound/E-commerce execution.

·         Design & Integration for Carrier 315 to send LCL/FCL events for SAP EM for Ocean/Air scenarios via PI system and GSX.

·         Updating Seal/Container Number from Freight Forwarders at Container unit EH level using EM Events

·         External Events integration from 3PL and Freight forwarders.

·         Web UI integration to provide access for external users (3PL, FF) to send events for Ocean/Air scenarios.

 

HD SUPPLY, Atlanta, GA

SAP TM/EM Consultant - Supply Chain Shipment Visibility

August 2016 to April 2017

HD Supply is one of the largest industrial distributors in North America. The company provides a broad range of products and value-add services to approximately 500,000 customers with leadership positions in maintenance, repair and operations, water infrastructure and residential and non-residential construction sectors. Leading businesses include HD Supply Facilities Maintenance, HD Supply Waterworks and HD Supply Construction & Industrial.

 

·         Prepared functional specs for GAPS identified in the area of Order integration, Transportation network, Change Controller Strategy, TCM and Settlement. 

·         Responsible for enhancements in the area of ECC integration with PI and TM integration with PI inorder to capture new data elements in ECC and TM.

·         Responsible for analyzing carrier contracts across different Service levels and designing architecture for Transportation Charge Management for all Hubbell business divisions.

·         Setup FTL, Expedited, Air, Intermodal contracts in TM.

·         Set up LTL and Parcel contracts in TM and XPS.

·         Extracting ECC data into EM using SAP standard visibility process templates config and customization for OTC and P2P processes.

·         Integration of Carrier 214/315 transactions with SAP EM for posting 214/315 events in EM via EVMSTA02 IDOCs.

·         Integration b/w Mercury gate (MG) and EM for posting LTL carrier 214/315 events via Liaison and SAP PI.

·         Integration b/w Liaison and EM for posting UPS small parcel carrier 214 events via SAP PI.

·         Track and trace solution of creating Event handlers in EM for Sales orders, Purchase orders, Inbound/Outbound Deliveries, Good receipt and Invoice documents.

·         EH Generate functions configuration in EM based on CTN matching logic to post event message in existing Event handler (EH).

·         Rule set configurations for different event handler types (EH) of CTN, SO, PO, IBD, OBD and Invoices to process the events for setting up the status, notifications and exception handling. 

·         Handling exceptions, errors and IDOC failures during the transactions being posted in EM to ensure the errors are available in system for reprocessing them later.

·         Configurations for status attribute profiles, Extension tables, Control/Info/System parameters setup, mapping profiles, Expected/Unexpected events setup, Overdue monitor check for expected events.

·         Archiving strategy to archive the event handlers, event handler sets and event messages.

·         Extensively involved in the cutover activities and integration testing of ECC to EM for testing different business processes like Inventory POs, Factory direct (FD) orders, STOs and sales processes. 

·         EM Web UI configuration of purchase order visibility processes to track the purchase orders via web UI and to navigate from PO documents to IBD or OBD (STO case) and to navigate to CTN EH to track carrier events.

·         CTN EH creation logic from ECC based on tracking number available either in handling unit document or shipment document based on business scenario for Inbound/outbound flow.

·         Identified custom developments required and prepared functional specification document. Responsible for functional testing for the identified developments.

·         Worked in different TM areas to design and configure end-to-end business solution.

·         Performed end-to-end testing for all the scenarios.

·         Responsible for preparing test scripts, user training guide, configuration guide and training documents etc.

 

APPLE, Cupertino, CA

SAP EM Consultant - Apple Insource Track and Trace Solution

March 2013 to July 2016

Insource track and trace capabilities within Apple for End to End ‘In Transit’ Supply Chain Visibility Best in class deployment of technology to streamline processes, reduce latency, and provide better Shipment visibility to end customers. Provide Track and Trace data for all levels of reporting in future including EDW/LDW, BI Tools and any customer facing applications leverage on the capabilities of the SAP Event Management (EM) platform and the integration with SAP Core (ECC) to gain complete Shipment visibility within the expected SLAs.

·         Worked on various stages of an implementation right from project preparation, which includes project plan and scope, gap analysis, WRICEF design documentation, configuration, customization, prepare cutover activities for go live and support for post go-live

·         Design and integration of different business processes to extract the data for OBD, IBD and PO processes from ECC to EM for creating the shipment event handler (AUSID) and the corresponding PO/OBD/IBD event handlers at line item level in SAP EM system.

·         Architected end-to-end track and trace solution for Apple Immediate Delivery (IDL) model to deliver the shipments within 3 hrs. of SLA in the same day.

·         Implemented the Enhancements in SAP EM for Apple Pick-up Points (PUP) and Alternate Delivery Location (ADL) projects to pick up the product by customer at the carrier pickup point location based on email/SMS notifications sent to customers by EM and Rover systems.

·         Designed custom RFC to efficiently handle peak business volumes of EDI 214 and 315-events between Carriers and SAP EM via Web methods system.

·         End-to-End EM web UI standard configuration for different transaction scenarios and web UI customization via EM UI BADI implementation.

·         Configuration of authorization and filter profile in order to control the EM data to display for different business partners, i.e. customers, 3PL, Vendors and Apple Internal business users.

·         Integration of EM data to send to GBI downstream system for enhancing the reporting capabilities for shipment tracking using ZTRG architecture.

·         Set up new Events, Status Attribute profiles, Control, Info, system and Event message parameters.

·         Rule set configurations for AUSID EH, PO EH, SO EH, IBD EH and OBD EH.

·         Preprocessing functions logic for creating Shipment (AUSID) EH based on tracking number exist either in outbound or inbound delivery document with matching logic.

·         Design of SAP EM roles setup for each business partner to control the EM access via front end for External users (Vendors, 3PLs, OEMs) and Internal users (Apple business users).

·         Business object event configuration in SWETYPV (TCODE) to extract the data from ECC to EM for various business object types and events configured in ECC.

·         Involved in EDI 214 configuration to setup various partner profiles and Parent and Child SCAC configuration for integration of carrier data with EM.

·         Participated a key role in the design and integration testing of procurement (MM) processes at Apple to integrate with EM for shipment tracking – Hub-ship process, 3PP drop ship, Print services, STO Processes.

·         Participated a key role in the design and integration testing of sales processes(SD) at Apple to integrate with EM for tracking– Order to Cash, buy sell process, MIT Process (Merge in Transit), RMA (customer returns), RTV (Return to Vendor), Parcel and Bulk processes.

·         Provided extensive support to different business partners like Carriers, 3PLs, OEMs, Custom brokers and Apple internal users during Pre UAT and UAT.

CELANESE CORPORATION, Dallas, TX

SAP MM/IM/WM Consultant - SAP Enhancements/Production Support

December 2011 to February 2013

Celanese Corporation is a global technology and specialty Materials Company and one of the world’s largest producers of acetyl products. Celanese operations are primarily located in North America, Europe and Asia.

·         Successfully handled the Transition of both Support & Project areas in MM/WM at client location.

·         Functional design on enhancements of Order cockpit functionality for tracking the Sales Orders, Purchase Orders, and STOs across the globe.

·         Handling day-to-day incident tickets in MM, IM & WM areas. Provided resolution to incident tickets as per SLAs.

·         Handled enhancement of projects in MM, IM & WM areas, along with production support,

·         Worked on various enhancements for configuring custom segments and support on EDI transactions for Purchase Order (850), Purchase Order Acknowledgement (855), Advanced Shipping Notification (856), Invoice (810) and integration with SAP.

·         Worked on procurement cycle – Purchase requisition, RFQ, Maintenance of quotations, vendor selection, purchase orders, goods receipt and invoice verification.

·         Customization of material master views for utilizing optimizing functions available for Purchasing, Inventory Management, Warehouse Management, and Materials Requirement Planning.

·         Purchase order purchase price determine by goods supplier, Purchase order split logic changes.

·         Involved in all testing life cycles Unit Testing, Functional Unit Testing and Integration Testing and prepared procurement related test scripts in QC.

·         Coordinating for UAT & Business sign-off, Cutover & Go Live, User Training and Support

JOHNSON CONTROLS, Milwaukee, WI

SAP MM/WM Analyst - Power Solutions SAP Implementation & Support

March 2011 to November 2011

Johnson Controls is the world’s largest supplier of lead acid batteries. Our world-class product design and manufacturing systems ensure that our customers receive the highest quality products available.

·         ASAP project methodology related activities - Scoping, Project Preparation, Business Blue Printing, Realization, Final Preparation, Go-Live including Warranty support

·         Enhancements and L2/L3 Level Production support.

·         Purchasing – creation of purchase requisitions, converting PR to POs using batch job, configurations of vendor master, material master, source determinations, source list.

·         Configurations to setup the business processes for Inventory POs, Stock transport order(STO) and third party sales.

·         Inventory Management – Goods issues against Production order, Goods issues for cost center, Goods receipt against Purchase order, GR to blocked stock, Create Reservations to reserve certain material stock for production order.

·         Configured the Release Strategy with classification, definition and assignment of Plants, Purchase Organizations and other Organizational Elements.

·         Invoice Verification – parking and posting of invoices, release of invoices.

·         BOM: creating multiple BOM, variant BOM, and super BOM.

·         MRP: planning with different planning procedures like MRP, MPS, carrying out planning run (Single-item multilevel and Single-item single level).

·         Defined Valuation and Automatic Account Assignment including Standard & Moving Average pricing.

·         Customized messages for PR, PO, RFQ, Contracts, and scheduling agreement

·         Performed knowledge transfer to technical team regarding business problems, assist them in technical solution build and Document Preparation.

·         Created different types of pricing procedures for various customers with sales areas and maintaining condition records.

·         Configured for Item Category Determination and schedule line category.

·         Configuration done for Storage Locations, Warehouses, Storage types in WM.

·         Worked on Availability checks and transfer of requirements and material determination procedures.

·         Involved in Periodic Releases, which transports new enhancements to production.

·         Automatic determination of GL accounts, mapping valuation classes to GL accounts.

·         Coordinated with ABAP developer developing required formats of Purchase Orders, Goods Receipt Slip, Goods Issue Slip, and Dispatch Notes etc.

·         Provided GO-LIVE support at the plant location

BAKER HUGHES, Houston TX

SAP SD Senior Consultant - POWER (Performance Oriented Workflows Enhancing Reliability) 

January 2009 to February 2011

Baker Hughes Inc. is a supplier of products and technology services and systems to the worldwide oil and natural gas industry. Baker Hughes operates in over 90 countries worldwide providing products and services to international oil companies, independent oil and gas companies and national oil companies.

Baker Oil Tools (BOT), one of the divisions of Baker Hughes, is looking at bringing business process standardization across product categories and regions. One of the first processes that have been chosen is the Quote-to-Cash process. BOT wants to implement POWER as a standard system that will provide BOT a solution to capture the Quote-to-Cash Process as a Standard process

·         Key role in the designing of business processes for quote, plan and invoice phases in POWER 1.0 and POWER 2.0

·         Order to Cash(OTC) integration for Service order items, rental items, Saleable items and Consignment items.

·         Configuration of sales return items and consignment return items.

·         Configured complex pricing procedures, Condition technique setting in pricing, Condition records setup, condition types, and credit/debit demos for different sales document types like Consignment issue, Sale items, service order and Rental items.

·         Design and configured the pricing workflow approval process for Quotation documents before creating sales orders with reference to quotations.

·         Involved right from business requirement gathering, gap analysis, technical design and development, implementation, testing, and follow up problem resolution.

·         Defined copy control rule for sales documents, delivery documents and billing documents.

·         Designed, Mapped, LSMW for Legacy Data conversions & Data Migration.

·         Configured Shipping Points, Shipping Condition and Loading Groups.

·         Prepared functional specifications in order to fulfil the customer requirements through ABAP developments

·         Configured Materials Master including Material Types, definition of views, required Number Ranges for Material types etc.

·         Prepared weekly and monthly status reporting and team coordination

·         End user training and documentation of user manual, training materials.

·         Provide Go Live and Post Go Live Support.

INTEL, USA

SAP SD & MDM Analyst - SAP Location Master Data Implementation

March 2008 to October 2008

Intel Corporation (better known as Intel) is an American multinational technology company headquartered in Santa Clara, California. Intel is one have the world's largest and highest valued semiconductor chip makers.

·         Gathered data requirements for Location master data implementation.

·         Location master data migrated from non-SAP Systems to SAP ECC, from ECC to MDM via XI

·         Involved in the workflow driven activities

·         Data migration of master data from legacy to ECC using Legacy System Migration Workbench (LSMW).

·         Integration of MDM with Business intelligence (BI)

·         Design for integration of master data between ECC and MDM

·         MDM server side configuration for inbound and outbound process flow between ECC to MDM

·         Played a key role in the extractor design and development to extract master data from ECC to MDM

·         Involved in ALE/IDOC configuration for converting the data between sender and receiver and for maintain rules.

·         Involved in migrating the master data from the third party (Non SAP) system to SAP ECC using LSMW.

·         Provided functional assistance to the technical team for feasibility study and requirement gathering like creating a custom Report (Custom object Repository) to fetch all the custom objects in the system.

·         Preparation of project related documents and templates like Test plans, code review checklists, status reports, test scripts etc.

·         Coordination with functional members and the client, offshore support during the go-live of project and worked on cutover activities.

·         Involved in the MDM business package integration with Enterprise portal.

·         Provided functional support in the customization of MDM business package deployment in Enterprise portal

·         Conduct implementation and testing reviews.

ROCKWELL AUTOMATION, Netherlands

SD Business Analyst - E-Commerce Internet Sales Application

October 2006 to January 2008

Rockwell Automation has realized to start the project on E-Commerce (ISA b2b) Implementation for their customers to ensure the orders of RA products thru Online. There are different Components in the Landscape CRM, ECC, XI, EP and PeopleSoft.

·         Worked extensively on developing migration strategy, cutover plan and performing cutover activities during the Go-Live week.

·         Customized organization structure/hierarchy – company codes, plants, storage locations, purchasing group etc.

·         Maintained the web shop, Creation of Product catalog, Creation of views and variants.

·         Created the customized roles and assigning authorizations to the user

·         Middleware support and Configuration to send the customer data from CRM into ECC.

·         Configuration of user management

·         Involved in the variant configuration for ECC to CRM integration.

·         XCM configuration and administration, setup of ISA application

·         Involved in preparing Low-Level Design Document.

·         Customization of ISA User admin application

·         Coordination with other functional members and the client, offshore support during the go-live of project and worked on cutover activities.

·         Preparation of Unit test plan, Integration test plans and User Manual documents

·         Defect Resolution as part of User Acceptance Testing and Post Go-Live Support.

·         Performing Unit testing and System Integration Testing for new SAP Solutions developed.

WKFS, Saint Clouds, MN

SD Func