Sumanta Hati

Phone: 484-***-****

ac4pi8@r.postjobfree.com

Experience Summary

IBM certified Senior SAP ABAP Technical Consultant over 10.5 years of IT experience including Sales Order Distribution (OTC), Pricing, Billing, Invoicing, Purchase to Pay Module and FI-CO module.

Have strong techno and functional knowledge in Sales Order Processing and Finance COPA module.

Extensive technical knowledge and have good hands on experience in Sales Order Enhancement like Material Substitution, Duplicate Sales Order Check, Back Order Processing and Purchase Order format check and Credit Check etc.

Worked on SD Invoice Pricing on rebates and custom VOFM routines.

Have basic knowledge on S4 HANA modelling. Completed training on SAP HANA and Data Migration.

Strong ABAP development experience in RICEF including Dialog Programming, ALV, BAPI’s, RFCs, BADI’s, Smart forms, SAP Script, ABAP Objects, ALE and IDOC, User Exits, Enhancement, BDCs.

Extensive work experience in RICEFW (Reports, Interfaces, Conversions, Extensions, Forms, and Workflow).

Having strong exposure in SAP Modules – Sales Order Processing (SD), EWM, FICA, VISTEX (Chargebacks, Customer Rebates, Purchase Rebates and Contracts), Production and Revenue Accounting (PRA), MM, HR, Retail, PTP and Master Data Management. Through understanding of relationship between various SAP modules (VISTEX, FICA, RMCA, SD, and MM) and of overall business process such as order-to-cash and purchase-to-pay and make to order.

Have strong technical knowledge in COPA Profibility Number Generation functionality.

Expertise in Data Migrations/Conversions using BDC Programming on Call transaction and Session method.

Expertise in working with ALE/EDI to transfer IDoc (EDI810, EDI850, EDI855 etc.) for cross applications to integrate systems.

Vistex Techno Functional Consultant over 7 years of experience which includes Vistex Customer Rebate, Vistex Purchase rebate, Chargeback and Contract Module and Vistex Deal Management Solutions.

Have 3 Years of OER and Advance Tracking Trace (ATTP) experience in Pharma Distributor Company “Amerisource Bergen Corporation”.

Extensive experience in FI/CA modules – Profitability Analysis (CO-PA), GL, AR, AP, Fixed Assets. Integration of FI with MM and SD with Procure to Pay and Order to cash Cycles Good working experience in ABAP/4 Reporting (with Sap script in Smart form, Classical, Interactive, ALV list/grid).

Have a good experience in Tax calculation and enhancement of tax calculation for different company code.

Enhanced Idoc segments by adding new fields for IDoc types, ORDERS, DEBMAS and MATMAS.

Designed and developed screens using Dialog programming with Screen Painter and Menu Painter

Developed and modified Forms using Smart Forms, SAP scripts.

Expertise in Technical and Cross-Functional experience in various modules and applications of SAP R/3

Experienced well in Performance Tuning, Optimization of reports in system integration, applying OSS notes, SQL Trace (ST05), Runtime analysis (ST12 and SE30) and System dump Analysis (ST22).

Involved in technical documentation and requirement gathering process and quality review.

Managed transport activity from development system to the production system.

Experienced in batch scheduling and managing batch processing.

Adept in Debugging, Performance Tuning, Unit Testing, Integration Testing and User Acceptance Testing

Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure, manage multiple project and cross train sub-ordinates in other functional areas

Professional Experience

Client: 3M, Maplewood, MN Sept‘17 – Till Date

Role: SAP ABAP Technical Consultant

Modules: SD, MM, Vistex,

Enhancements:

Experienced in Sales Order Processing enhancement and user exits in Sales order area mainly MV45AFZZ.

Worked on Invoice Pricing and Sales Order Best Price Logic.

Modified User Exit on VL02N transaction to pop up warning message if loading point field is blank under certain conditions

Worked on Customer Service (CS) and Convergent Invoicing (CI) module in AmerisourceBergen Project.

Used SD_SALESDOCUMENT_CREATE and SD_SALESDOCUMENT_CHANGE to create and change the sales orders.

Modified another User Exit on VL02N to update "Z" table based on business requirement.

Created custom sub screens for customer master XD01/XD02/XD03 using BADI

Experience in Product Substitution, Back Order Processing,Duplicate Order Check, APO and GATP Check functionalities as a technical and functional.

Reports:

Created dynamic ALV report with dynamic editable columns and dynamic colors to the columns based on condition

Created ALV reports with drag and drop functionality

Used Object Oriented Programming to display more than one field in ALV report

Wrote ALV reports with edit and save functionality

Worked on displaying ALV using a docking container

Interfaces:

Used Tables EDSAPPL and IDOCSYN to get the list of IDoc segments in which a particular data element is used

Familiar with FM IDOC_READ_COMPLETELY to read IDoc segment with qualifier

Used segment E1EDS01 for unplanned delivery costs on Inbound Invoice IDoc

Used BAPI_VENDOR_GETDETAIL to extract CUSTOMERADDRESS, CUSTOMERGENERALDETAIL & CUSTOMERCOMPANYDETAIL

Used BAPI_PRICES_CONDITIONS to Upload Conditions in SD

Used BAPI_PO_CREATE1 to upload Purchase Order with a combination of Purchase Order Service and Purchase Order Limit

Conversions:

Experienced in uploading Purchase Order data using multiple flat files

Created BOM by using LSMW Direct Input method

Used Direct Input method and Recording method to upload vendor master data

Used LSMW for mapping fields from the legacy system and created routines for data upload

Forms:

Worked on Label Printing and Dunning using Smart Forms

Experienced in Smart Forms

Familiar with displaying logo, background image and fetching data from multiple tables

Experienced in converting Smart Forms output to PDF format

Client: AmerisourceBergen Corporation, Valley Forge, PA April‘11 – Sept, 2017

Role: Sr. SAP ABAP Technical Consultant

Modules: SD, Vistex, MM, PP, Invoice, FI

Enhancements:

Experienced in Sales Order Processing enhancement and user exits in Sales order area mainly MV45AFZZ.

Worked on Invoice Pricing and Sales Order Best Price Logic.

Modified User Exit on VL02N transaction to pop up warning message if loading point field is blank under certain conditions

Worked on Customer Service (CS) and Convergent Invoicing (CI) module in AmerisourceBergen Project.

Used SD_SALESDOCUMENT_CREATE and SD_SALESDOCUMENT_CHANGE to create and change the sales orders.

Modified another User Exit on VL02N to update "Z" table based on business requirement.

Created custom sub screens for customer master XD01/XD02/XD03 using BADI

Experience in Product Substitution, Back Order Processing,Duplicate Order Check, APO and GATP Check functionalities as a technical and functional.

Reports:

Created dynamic ALV report with dynamic editable columns and dynamic colors to the columns based on condition

Created ALV reports with drag and drop functionality

Used Object Oriented Programming to display more than one field in ALV report

Wrote ALV reports with edit and save functionality

Worked on displaying ALV using a docking container

Interfaces:

Used Tables EDSAPPL and IDOCSYN to get the list of IDoc segments in which a particular data element is used

Familiar with FM IDOC_READ_COMPLETELY to read IDoc segment with qualifier

Used segment E1EDS01 for unplanned delivery costs on Inbound Invoice IDoc

Used BAPI_VENDOR_GETDETAIL to extract CUSTOMERADDRESS, CUSTOMERGENERALDETAIL & CUSTOMERCOMPANYDETAIL

Used BAPI_PRICES_CONDITIONS to Upload Conditions in SD

Used BAPI_PO_CREATE1 to upload Purchase Order with a combination of Purchase Order Service and Purchase Order Limit

Conversions:

Experienced in uploading Purchase Order data using multiple flat files

Created BOM by using LSMW Direct Input method

Used Direct Input method and Recording method to upload vendor master data

Used LSMW for mapping fields from the legacy system and created routines for data upload

Forms:

Worked on Label Printing and Dunning using Smart Forms

Experienced in Smart Forms

Familiar with displaying logo, background image and fetching data from multiple tables

Experienced in converting Smart Forms output to PDF format

Vistex:

Work on Sales, Purchase and Customer rebate and Chargeback.

Experience in both Vistex 6.0C and 6.0E.

Investigate and resolved Technical issues related to VISTEX and SAP ECC systems.

Created parallel processing program for standard VISTEX IP document creation in mass processing program to improve the performance.

Worked on Formula Builder logic for dynamic calculation for Net Sales Value for Admin Fees Rebate.

Involved in complete end to end technical design and development of new composite model deployment codes like MSA Fee and new Bucket functionality implementation.

Has knowledge of configuration of new deployment code in Purchase Rebate area.

Developed Pricing formulas and Routines, LIS update and validation for VISTEX applications.

Worked on purchasing rebates composite screens and user exits.

Worked on Supplier Rebates Accrual and Settlement Formula Extension.

Developed a custom utility program to validate and update the records in the Custom table for Price Appreciation calculations.

Experience in both Composite and Transaction model

Responsible for technical design, translates functional requirements into technical design, architecting of solution and coordinating with Vistex offshore development team.

Developed new enhancement for ADM repricing based on the agreement specific changes like material, rates thus reducing the runtime and system load.

Advance Tracking and Trace:

Worked on Purchase Order (PO Extract and PO Receipt Extract) Inbound Interface from other non-SAP Manufacturer system to ATTP Distributor system using standard ATTP BTT event.

Experienced in Outbound Shipping Interface from Distributor to Customer using Business Transaction Type (BTT) through PI.

Using eMDM tool to prepare the master data (Business partner, Location and Trade Item) for ATTP/OER system.

Added custom error messages to AIF system to monitor the message details using AIF transaction /AIF/ERR.

Worked on Inbound Interface for Lot ASN (Advance Shipment Notification) processing from Manufacturer to ATTP/OER system using EPCIS format.

Worked on Error Handling and Lot Level ASN Reconciliation Report for OER/ATTP and Internal Inquiry Report for Inbound/Outbound Tracing.

Used outbound delivery interface to send TI/TS information to ATTP/OER system.

Expertise in GS1 naming convention standard and format for ATTP.

Worked on BOLB configuration for ATTP data for further processing.

Used following standard ATTP BaDI for track and trace serialization.

/STTP/DM_CAPTURE_EVT

/STTP/BADI_DM_CAPTURE_EVT_APR

/STTP/BADI_CHANGE_EPCIS_INPUT

/STTP/BADI_DM_CAPTURE_EVT_CTY

/STTP/BADI_DM_TRN_ATT

Advanced Track and Trace for data cockpit transaction /STTP/COCKPIT is used to trace the record.

Created test data and execute end to end testing for various BTT Object events like Commissioning, Packing, and Shipping from Manufacture side and Eligible of Receiving, Receiving and Unpacking.

WebDynpro:

Created SAP ABAP WebDynpro Application with ALV editable to Change

Provided support for WebDynpro/FPM for ABC Passport Application.

Finance:

Has knowledge of CO-PA posting and related enhancement.

Worked on billing and FI related Interface.

Worked on tax calculation enhancement for new company code Switzerland.

Data Migration:

Worked in data migration in Amerisource Bergen Corp Project.

Worked for Data migration from OER system to ATTP System.

Create a conversion for data migration for existing record.

Environment: ECC 6.0

Client: Merck Da Vinci, Swiss/Italy Oct’10 – April‘11

Role: SAP ABAP Consultant

Modules: SAP IS-U, SRM, MM, SD

As part of the frequent change of prices in utility industry, updated new prices various times and updated billing logic as and when company needs.

Configured new charges as for different kind of services as by the client requirements.

Configured slab pricing with quantity based periodically controlled.

Developed the EDI810 Utility Invoice by following the PSE&G EDI Billing Guidelines.

Raised standard issues with SAP team via service market place.

Maintaining archiving period for billing documents.

Resolving the daily billing cycle issues, by interacting with the end users.

Working on print workbench for updating required changes on Bill-form.

Worked on Production and Revenue Accounting (PRA) for Merck Da Vinci Project.

Reports:

Used Word Wrap Functionality in ALV reports

Added PF-Status, Header and Footer in ALV using class CL_SALV

Created, modified and deleted entries dynamically from any custom table by using Object Oriented ALV

Created reports in MM module that outputs Material valuated stock, grouped by Material type and Plant. The output showed Material number, Storage location, Unit of Measure, and Description in addition to group totals

Developed Sales Operation Report to list customers and associated sales Partners as on date

Interfaces:

Used BAPI_PO_CHANGE to create service line items in Purchase Order as per requirement

Used BAPI_INCOMINGINVOICE_CANCEL and BAPI_BILLINGDOC_CANCEL1 to cancel the invoices

Used BAPI_MATERIAL_SAVEDATA to create and change Material Master Data

Used BAPI_ACC_DOCUMENT_POST to post a Document

Used BAPI_FTR_CONDITION_CREATE as a replacement for transaction VK11 while creating conditions

Used BAPI_SALESORDER_CREATE to create sales orders in SD

Conversions:

Copied LSMW object from one client to another

Uploaded material master data/records using Recording Method, and Direct Input Method

Used Batch Input Method to update customer master records

Developed technical specifications and created a BDC program to load Sales Deals using call transaction and loaded the Sales Deals using the program

Similarly, created a BDC program to load customer info records using session method and used the program to load customer info records

Enhancements:

Developed User Exits for cost center master data maintenance as per the clients requirement

Restricted users to view or change Sales order data in Enhancement Framework using Implicit enhancement option

Created a User Exit to populate the custom fields in Purchasing Document Header and Purchasing Document Line tables using enhancement MM06E005

Forms:

Used Smart Forms to print graphics, addresses and also designed Tables

Familiar with Sap Scrip design.

Environment: ECC 6.0

Client: British American Tobacco, Germany March’09-Oct’10

Role: SAP ABAP Developer

Modules: IS-U, FICA, DM, EWM, CS

Responsibilities:

Core competence in customizing and implementation of SAP ISU-CCS Billing and Invoicing Module

Designed, configured, and tested business processes for billing Master Data, Device Management, Billing, and invoicing modules.

Modified layout and added some fields for Zpermitplus application using Dialogue Programming

Modified Smartforms related to Disconnection Order and Service Order

Configured Partner Profiles for Logical Systems for Inbound IDocs

Involved in Functional requirement gathering from the client for development

Created a report to post payments from a Remittance File(generated by Netvantage ItemAge software) using BAPI_CTRACPAYMINC_CREATE, BAPI_CTRACPAYMINC_APPEND, BAPI_CTRACPAYMINC_RELEASE, BAPI_CTRACPAYMINC_CLOSE and BAPI_CTRACPAYMINC_SCHEDULE

Developed outbound interface to generate Check Refunds file, with customer account details and refund amounts used FM_ISU_ADDRESS_PROVIDE

Created a report to create Meter Read Order for already existing service types using FM_ISU_S_METERREAD_CREATE

Developed report to replicate the functionality of IW31 and IW32 Transactions for creation and change of Meter Read Order for new service types using FM_ISU_DET_DEVICE_FROM_INST and BAPI_ALM_ORDER_MAINTAIN

Environment: ECC 6.0

Client: PepsiCo International, Germany and Brazil July’08-March’09

Role: SAP ABAP Consultant

Modules: FI, CO

Responsibilities:

Development of various interfaces and interactive as well as classical reports, ABAP List Viewer for Pepsico.

Developed tracking report using drag and drop functionality in ALV container approach.

Check layout printing with signature and without signature based on user specifications

Involved in documenting all the stages of ASAP Methodology like Business blueprint, Realization, Final Preparation and Go Live

Applied OSS Notes

Reports:

Created an ALV report for Balance sheet display

Created Interactive report to display budget details based on GL - account number and vendor details

Displayed report in the format of monthly, bi-monthly, six monthly and yearly details

Created ALV report to display G/L account line items by Project Definition, WBS Element and Project type to compare CAPEX amount and AFDUC amount

Conversions:

Developed a BDC program to upload the data of G/L account document into SAP R/3 system using transaction FB50

Wrote a BDC program for posting vendor invoice documents using transaction FB60

Developed BDCs to upload trails balance (GLs, Customers, Vendors, Line items) with reusable features

Transfer of Legacy system payroll accounting documents data to SAP through FB01 transaction

Enhancements:

Added a custom ‘zfield’ in the Special Purpose Ledger to capture a Business Unit Field for reporting

Used the user exit in program SAPMV45A to include MV45AFZZ and included a custom program in order to create a dummy batch number that would appear in order entering process of certain transactions

Environment: ECC 4.7

Client: Philips Morris International Account, Switzerland Sep’07-July’08

Role: SAP ABAP Consultant

Modules: SD, MM, Solman Updation

Enhancements:

Implemented BADI for Outbound Delivery (VL31N) and Inbound Delivery (VL02N) to default the field Date of Manufacture when entering a goods receipt for PO using VL31N & goods receipt against return delivery using VL02N

Responsible for adding logic to populate the Profit Center in XREF2 field(XREF2 is used in all AR reports to identify a selling location) as the dynamic read of SD Account Assignment in EXIT_SAPLV60B_004(Include ZXVVFU04)

Smart Forms:

Worked on Smart forms to add EAN128 Barcode on the Mill Packing List form (ZV_PACKING_LIST) that contains the Delivery number assigned to the Shipment under the Contact Number

Worked on Smart forms Customer Ship Label to change the logic to improve the performance as the Customer Ship Label is printing slowly

Worked on Smart forms Customer Ship Label to change the logic as the duplicate and blank Handling Unit numbers are printing in the form

Modified existed OTC Smart forms to print the Total Number of packages in the Billing Document as per the Material Invoiced line item and to prevent the repeated materials in every row of data

Environment: ECC 4.7

Education

PhD in Information Technology, 2016, Indian Institute of Engineering Science and Technology, Shibpur, India

Master of Engineering in Electronics and Telecommunication – 2007, Bengal Engineering and Science University, India.

Bachelors of Engineering in Electronics and Communication - 2005, Burdwan University, India.

Contact this candidate