Sunil Tripathy

  • SAP SD / SCM Solution Architect
  • Denton, TX
  • Member Since May 11, 2023

Candidates About

 

Sunil Tripathy

SKILLS: Sales and Distribution, Logistic Execution, Shipping and Transportation, pricing Strategy, billing & Invoice, service management, professional service, revenue recognition, IS–Oil and Gas Downstream, Bulk Shipment and transportation, Exchange, Hydrocarbon Product Management, SILO management, APO (Advance Planning and optimizer) like GATP, Demand planning, Supply network planning, and Core interface.

Executive Summary.................................................................................................................................................. 2

PROJECT DETAILS:.................................................................................................................................................. 3

Project I: ESAB Welding & Cutting Products............................................................................................................. 3

Project II: Client: Doosan, Fargo, ND             Duration: Sept 2014 to Dec 2015............................................................ 4

Project III:  Client: NTT DATA, Boston, MA             Duration: Aug 2012 to Aug 2014.................................................... 5

Project IV: Client Invensys (Schneider Electric)......................................................................................................... 6

Project V: Client: Apple Inc., Cupertino, CA               Duration: April 2010 to March 2011.............................................. 7

Project VI: Client: Lexmark, Lexington, KY                        Duration: May 2009 to April 2010......................................... 7

Project VII Client: Bacardi Ltd., Switzerland, Europe             Duration Oct 2008 to March 2009..................................... 8

Project VIII: Client: Infineum UK Ltd, Milton Hill, UK             Duration Sept 2006 to Oct 2008......................................... 8

As Project Manager (since Nov. 2006 to Oct 2008)....................................................................................................... 9

Project IX Client: Nalco Chemicals, NA           Duration Nov 2005 to July 2006............................................................. 9

Project X: Client: Albemarle Corporation             Duration from Nov 2005 to August 2006............................................ 10

Project XI: Client: US Robotics, USA            from Nov 2005 to August 2006.............................................................. 10

Project XII: Client: Tyco Electronics USA             Duration Feb 2005 to Nov 2005....................................................... 10

Project XIII: Client: SHELL Petrochemicals, Netherlands              Duration Oct 2004 to January 2005.......................... 11

Project XIV: Client: Indian Oil Corporation Ltd. (IOCL), India Duration April 2004 to Oct 2004....................................... 11

Project XV: Client: IOCL- LPG- UNITS, Chennai Duration Jan 2003 to February 2004.................................................. 12

Project XVI: Client:       Rohm and Haas, Philadelphia - US Duration 2002 To 2003...................................................... 13

SAP pre sales EXP:................................................................................................................................................. 13

PROFESSIONAL NON-SAP EXPERIENCE................................................................................................................ 13

SAP TRAINING (AS TRAINER):................................................................................................................................ 14

SAP TRAINING (AS TRAINEE):................................................................................................................................ 14

Education /Achievements:....................................................................................................................................... 14

 

 

Executive Summary

 Mr. Sunil is a SAP Supply Chain Management Consultant, having 16 years of total experience, 14+Yrs.of SAP Experience. He has expertise in Sales and Distribution, Logistic Execution, Shipping and Transportation, pricing Strategy, billing & Invoice, service management , professional service, revenue recognition, IS–Oil and Gas Downstream, Bulk Shipment and transportation, Exchange, Hydrocarbon Product Management, SILO management, APO (Advance Planning and optimizer) like GATP, Demand planning, Supply network planning, and Core interface.

He is a MBA Graduate and a trainer with experience in Project Management. He facilitated business growth across the project lifecycle, bringing diverse IT projects to successful completion. He possesses good client relationship management skills and has worked with premier clientele like Doosan, Invensys (now Schneider Electric), Apple, Lexmark, Bacardi, Shell, Infineum, Indian Oil Corporation, Tyco Electronics and Nalco Chemicals, etc.

 

·                     Good understanding of business processes in Logistics and SCM.

·                     Good team player, strong team orientation & leadership qualities, hardworking and enthusiastic.

·                     Very good logical skills suitable for process design, development & implementation.

·                     Excellent communication and presentation skills and Customer Oriented attitude.

·                     Certified Solution Consultant for SAP Sales and Distribution, Order to Cash and has around 12 years of business and varied industry experience like Mobile, Electronics, electrical, Petrochemical, Oil and Gas, Chemical, High-tech, Sprit and Beverages, Heavy equipment, etc.

·                     Over 13 years of experience in Technology consulting (IT-SAP), Business consulting, Process consulting.

·                     Full Life-cycle Implementations, Upgrade, Rollout and Production Support. Has extensive SAP experience in SAP Sales and Distribution (SD) covering SAP components ranging from 4.6C to ECC 6.0.  Involved in Upgrades and Post Implementation production support.

·                     Extensive SAP experience encompasses Solution Architect, Project Implementation, Systems Analysis and Design with Data Gathering, Business Process Blueprinting, System Configuration, testing (unit testing, integration testing and User Accepting testing), User Training, Master Data Build-up and Maintenance and Production / Post Production Support.  Extensive experience in SD Integration with SAP LE, MM, WM and FI/CO.

·                     Ability to work independently and in groups. He has assisted in instituting improvements for better management workflow.  He is a goal driven problem solver, creative, analytic, well organized.  He has progressively developed his inter-personal and communication skills.  He demonstrates record of high performance including attention to schedules, deadlines and quality work.  Good understanding of general business processes.

·                     International exposure having worked in USA, France, Geneva, Malaysia apart from India.

 

·         SAP EXPERTISE:

 

 

S

A

P E

X

P

 

 

SKILLS

RESPONSIBILITY

PROJECT TYPE

PROJECT NAME

SAP  SD

SD Lead

SAP Rollout 

ESAB Canada Implementation

SAP SD

Sales and Distribution

Amber road SAP Integration implementation

Amber Road

SAP SD

SDPS 

Professional Service full life cycle Implementation

NTTDATA Synergy

SAP SD

SD Lead

EMEA , US SAP ECC 6.0 Full life cycle Implementation

Invensys, Foxboro, MA 

SAP SD

SD Lead

 ITUNE Implementation

Apple Inc., Cupertino

SAP SD –OTC, OTC Dist. 

OTC OM and OTC Dist. Lead

ECC 6.0 full life cycle Implementation/Support

Lexmark International

APO- DP/SNP/PPDS/CIF

FTS Lead

ECC 6.0 full life cycle Implementation

Bacardi

SD-GATP/CIF

 SD /APO Lead

GATP Implementation/Support

Infineum

Project Management

Project Manager

Support

Infineum

SD

SD Lead

Support

Nalco/ Albemarle/ US Robotics

SD

 Consultant

Implementation/support

Tyco/IOCL/CPCL. Etc.

PROJECT DETAILS:

 

Project I: ESAB Welding & Cutting Products.

DENTON, TX                                                                                        Duration: Jan 2015 to August 2016

Project name: SAP ECC 6 ESAB Canada Rollout

Role: Solution Architect

 

Responsibilities:

 

·                     Roll out of ESAB US SAP environment to ESAB Canada.

·                     Project Planning and sign off from the stake holders.

·                     Preparation of testing environment, test planning, signoff of user acceptance.

·                     Reporting to management on progress of project and testing.

·                     Cutover planning, execution and reporting.

·                     Workshop to gather Canada Specific Regional Requirements.

·                     Business Blue Print design and sign off.

·                     Realization of SAP configuration and development of RICEF objects.

·                     Separate pricing strategy and design for Canada.

·      Retail price, distributor price, performance price, selective customer price, and wholesale price, special Price by product line for Select customers/Distributers, special price by end user, short term sales deal, and customer hierarchy.

·      Design of Channel price like industrial, OEM, automation, instrumentation etc.

·      Design of marketing programs driven prices, trade fair, sales deals.

·      Design of different discounts, Surcharges and freight cost.

·                     Tax determination in Pricing and integration with Vertex.

·      Define a Physical RFC connection and test the connection.

·      Testing the external System tax data.

·      Define tax procedure and activate external tax calculation.

·      Defining the tax jurisdiction code structure.

·      Customizing customer master and material master tax classification.

·      Customizing master data tax indicator.

·      Maintaining master data in SD and MM.

·      Set up Pricing procedure and condition technique.

·      Migration of Customer, Material, vendor master as all taxable in SAP.

·      Loading of all exemption certificates in Vertex.

·      Set up tax code and maintain Dummy jurisdiction code for non-tax items.

.

·                     Intercompany sales process and return, intercompany pricing procedure to capture standard cost plus mark up.

·                     Design of foreign trade and custom for export process, export documentation.

·                     Design of Kit selling using sales BOM through different processes and return.

·                     Design of consignment process for the sale of demo products to salesman.

·                     Customer Service management

·         Selling and return of serialized product.

·         Creating equipment master, configuration of plant maintenance  

        • In-warranty repair & FOC Delivery.
        • In-warranty Spare Parts Delivery
        • In Warranty spare parts delivery to Canada customer form Canada and US Plants.
        • Out of Warranty repair.
        • Intercompany out of warranty repair.
        • In warranty repair and free of change delivery

·                     Integration with third party systems like WMS Microlistic and Vertex.

·                     Design of communication strategy for order acknowledgement, delivery, invoices using print, fax and e-mail as medium.

·                     Prepare testing environment, leading the team for execution of test scripts, tracking, reporting used Bug track as tool to track the defects and resolution.

·                     Design of test script Unit testing, integration testing and regression testing 

·                     Develop simulation test plan & scenarios

·                     End user training & documentation

·                     Transition to production environment.

·                     Data migration:

·      We have migrated the Master data and transactional data migration from legacy BPCS and JDE system to SAP.

·      The Objects are like Sales order, material master, customer master, sales order text, Credit master and BOM materials.

·      Developed upload programs and LSMW.

 

Project II: Client: Doosan, Fargo, ND                            Duration: Sept 2014 to Dec 2015

Project name: SAP Amber Road Integration

Role: Solution Architect  

Responsibilities:

·                     Integration of current SAP system with Amber road compliance Management system to simplify, automate and streamline global trade operation.

·                     Preparation of test environment, responsible team.

·                     Designing end to end test script and assigning task to respective team.

·                     Reporting to management phase wise progress of testing and status of issue resolution.

·                     Cutover planning, assignment of task, execution and progress reporting to stake holders.

·                     Analyse & define business processes.

·                     Functional requirements document - gather functional requirements.

·                     Analyse & define technical process.

·                     Detail design document (including integration details & technical requirements)

·                     Configure system to meet design requirements.

·                     Material master, customer master data inventory analysis.

·                     Develop and test inbound /outbound programs.

·                     Mapping of Customer master and material master fields in Amber road Product master and customer master fields.

·                     Data Migration of customer master and Material master to Amber road.

·                     Mass loading and delta loading of master data.

·                     Data validation and reporting.

·                     Unit testing ,Integration testing.

·                     Testing Lead: The team of cross functionality modules like Webmethod, oracle, Amberorad in terms of tracking the defect and reporting to stake holders. Used Remedy as tool for tracking defects.

·                     Prepare testing environment

·                     Develop simulation test plan & scenarios

·                     End user training & documentation

·                     Transition to production environment.

·                     Integration with Oracle, web method, ESB.

 

Project III:  Client: NTT DATA, Boston, MA                               Duration: Aug 2012 to Aug 2014

Project name: NTTDATA Project Synergy

Role:  Solution Architect

Responsibilities:

·                     Implementation of ECC 6.0 SD in Professional Service environment.

·                     Process re-engineering across all entity, Global process requirement gathering, workshop, designing, building solution, testing, Data Migration, integration testing.

·                     Data Migration strategy for Transactional and master data.

·                     Integration with sales force, Gimmal Documentum solution for Contract and Project.

·                     Integration with Taxware as external system for tax calculation.

·                     Lead the Integration testing and user acceptance testing across all modules like PS, SD, HCM, Salesforce, FI, GImmal.

·                     Preparation of test environment, execution of test scripts, reporting of status and issue resolution.

·                     Procurement process for sub-contractor and payment to vendor and Intercompany billing process for the offshore resourcing.

·                     Contract management, Resource Related Billing, integration with Project System, HCM and FI/CO.

·                     Rev Rec specific to Service industry like result analysis, milestone billing, straight line method, event based billing and rev rec. Knowledge of FASB new Rev Rec. guidelines. 

·                     Prototype solution development, end-to-end presentation to business.

·                     Building RICEFW objects, solution as per business process requirement.

·                     Creation of BPP and subsequent workshop for sign off.

·                     Design implementation of communication method like email and print output to end customer and internal use.

·                     BI/BW reports, like utilization, commission calculation, time entry, cost and profit margin report.

§  End-user training and training documentation, SOP preparation and sign off from business owner.

·                     Data Conversion and Data loading, responsible for Material master, customer master, condition records, Contracts.

·      Data conversion Plan.

·      Data Inventory assessment, source system identification and defining ownership of data.

·      Data cleaning in source system and finalizing cut off date.

·      Mapping and conversion rules.

·      Extraction program and load program rules.

·      Adjusting rules and modifying program after testing.

·      Initial load and mass load testing.

·      Fixing mass load issues.

·      Full load to test environment.

§  Mock load to pre-production environment.

·      Data validation and sign off from Business object owners.

·      Cutover plan and accommodation of delta change data.

·      Full load into production System.

§  Validation report in Production system.

 

Project IV: Client Invensys (Schneider Electric)

Foxboro, MA                                                                                        Duration: March  2011 to  July 2012.

Role: Solution Architect

Responsibilities:

·                     Implementation of ECC 6.0 Sales and distribution.

·                     Migration of Legacy system data to SAP, material master , customer master , condition records , sales order , sales order and material master with variant configuration. Material variant materials.

·                     Global process requirement gathering, workshop, designing, building solution, testing, Data Migration, integration testing.

·                     Design and implementation of drop shipment, intercompany process, make to order, make to stock, variant configuration, material variant processes, business rules , exception rules , use of logical operators, variant pricing, reporting.

·                     Drop ship, Project and Warranty order fulfilment.

·                     Repair and return service management related pricing, project orders pricing.

·            Customer service, service processing

·            Onsite service non billable and billable.

·            Service repair in-house non-billable.

·            Order processing for loaned unit.

·            New material W/service billable.

·            New material w/services, Billable at a Fixed Price.

·            The small project orders - end to end process using a service order instead of the SAP PS module will go through the process of sales order setup, service order setup, labor planning, resale planning, hardware (internal factory material) planning, receiving the material, time charging and month-end financials.

·            Third party labour: A third party purchase order can be used for labor or materials.  Both would allow cost to be consumed onto a service order.

 

·                     OTC process Integration with MM, PP, FICO.

·                     Taxware implementation for USA.

·                     SAP pricing strategy for global and regional requirements, sales order costing, and variant pricing.

·                     EDI-IDOC configuration, monitoring, error handling.

·                     Data migration from legacy system to SAP, the objects like customer master, material master, opens sales order, pricing, customer material info records.

·                     Batch job and variant creation, sequence, monitoring.

·                     Design implementation of communication method like email and print output for end customer and internal use.

·                     Cutover strategy, plan and execution

·                     End-user training and training documentation.

 

Project V: Client: Apple Inc., Cupertino, CA                                         Duration: April 2010 to March 2011

Role: ITUNE Gift Card Lead                                               

Responsibilities:

·                     Implementation of ITunes Gift card processes in Apple retail store, third party retail store, and reseller across Geography. Apple DC.

·                     Setting up new materials for of ITUNE music, video, album sales in various channels.

·