Sanjoy Gorain adlkov@r.postjobfree.com

Sr. SAP Consultant +91-810*******

Bengaluru, India.

PROFESSIONAL SYNOPSIS

11+ years of SAP experience with expertise in Native HANA / ABAP on HANA/S/4 HANA/ ABAP/ SAP HANA Cloud.

Working or CDS views for OLIN account in HCL, Bangalore.

Working on POC to automate QoS Parameters in SAP HANA Cloud.

Worked on HANA Views project for Shell Market India Ltd, Bangalore.

Worked on Celonis Project for developing Calculation Views, Procedures, UDF’s and Tables. Also involved in deploying them across landscape for Shell Market India Ltd, Bangalore.

Worked on BW and HANA upgrade as a part of SPS2019 project for Shell Market India Ltd, Bangalore.

Worked on S/4 HANA Migration Project for Euronics, UK.

Worked on HANA DB Migration Project using Panaya Tool for Magna, US.

Worked on BW/HANA Implementation Project for American Airlines.

Worked on S4 HANA Custom Code Migration Worklist Tool

Worked for HANA DB Migration for Goodyear, Belgium.

Worked on ODATA Service to expose CDS views to FIORI.

Worked on SAP Best Practices for analytics with SAP S/4HANA

Worked and given Training on ABAP CDS views in Eclipse Environment

Worked on SAP SLT replication server to replicate tables for ECC to SAP HANA

Understand the Business requirement and Design Technical specification accordingly & Unit Test plan preparations

Worked extensively on MM, SD, CS, PS, PP and FI SAP modules for development of Reports, Dialog Programming, and Smart Forms, Business Add-Ins (BADI), user exits, BAPI, ABAP objects & BDC.

Expertise in understanding the R/3 system and experience in ABAP/4 programming techniques using quality driven methodologies. Has worked extensively on ABAP code tuning using tools like SQL trace, Performance analysis.

Adept in swiftly ramping up projects and ensuring on-time deliverables.

SAP ABAP/BW/HANA Upgrade Experience.

Education:

B.E in Information Science and Engineering fom V.T.U. Belgaum.

Trainings Attended:

Course Name

Conducted By

SAP ABAP on HANA (HA400)

SAP India

FIORI

HP India

Employment History

Working as Lead Consultant in HCL Technologies from Feb’2020 to till date.

Worked as HANA Application Developer in IBM, Bangalore from Jul’2018 to Dec2019.

Worked as SAP Consultant in ATOS, Bangalore from Apr ‘2017 to Jul’2018.

Worked as Technology Consultant in HPE, Bangalore from Mar‘2011to Apr’2017.

Worked as Associate ABAP Consultant in Dexler Information Solutions, Bangalore from Mar ’2010 to Feb’2011.

Project Details:

Client : Olin, US

Role : HANA Application Developer

Projects : Olin, US

Team Size : 15

Duration : 19th Feb 2020 to till date.

Responsibilities: Developed ABAP CDS Views and CV’s used in AO reports.

Worked on incidents and service catalog tickets raised on Service now

for AO reports issues

Worked and done effort estimations for CR’s

Worked on short dumps.

Designed VDM’s and technical specs for new developments.

Optimized HANA Views and CDS Views

Client : Shell, Bangalore

Role : HANA Application Developer

Projects : SPS2019, Celonis and HANA Views

Team Size : 15

Duration : 9th July 2018 to 6th Dec 2019.

Responsibilities:

Developed Procedures and UDF’s for AP,P2P, AR and OTC data.

Used the tables and UDF’s to create Calculation Views.

Deployment of these structures across landscape.

Designed VDM and technical spec for these developments.

Fixing issues on SAP HANA Views occurred due to Upgrade.

Optimized HANA Views

Client : Euronics, UK

Role : S/4 HANA Consultant

Team Size : 11

Duration : 22nd Dec 2017 to 2nd Jul 2018.

Responsibilities:

Worked on Custom Code Migration Worklist Tool

Design development approach to fix the compatible issues faced due to S/4 Conversion

Developed HANA Backend Objects or Replacement objects (CDS Views) for the dropped tables.

Developed of AMDP’s in HANA using ADT for better performances.

Analyzed the ABAP logic for fixing functional related issues.

Use the ABAP Test Cockpit to perform a code inspection to ensure performance optimizations.

Client : MAGNA, US

Role : ABAP HANA Consultant

Team Size : 12

Duration : 8th May 2017 to 10th Dec 2017.

Responsibilities:

EHP upgrade from ECC EHP 5 to EHP 7 and HANA DB Migration.

Identified the affected objects i.e Programs,Classes,Function Groups,etc using Panaya Tool

Use the ABAP Test Cockpit to perform a code inspection.

Adaptations related to ensure no functional regression and performance optimizations

Client : American Airlines

Role : HANA Modeler

Team Size : 15

Duration : 19th Sept 2016 to 20th April 2017.

Responsibilities:

Design development approach to deliver the scenario views.

Developed HANA Backend Objects for Asset Management Detail, Account Payable Corp Tax, TM Bars Base and Scenario Views

Development of HANA Calculation views for BW master data objects

Unit testing of HANA Calculation views for Global master data objects

Analyzed extractor logic ABAP code for BW reports.

Analyzing HANA Live Views for modelling logic.

Analyzing VDM (Virtual Data Model).

Using Hana Live Views

Client : GoodYear, Singapore

Role : ABAP HANA Consultant

Environment : R3

Team Size : 10

Duration : 15th April 2016 to 9th Sept 2016.

Responsibilities:

Identify the affected objects i.e. Programs, Classes, Function Groups,etc using ATC(ABAP Test Cockpit)

ABAP Remediation’s for HANA DB migration

Custom code optimized to ensure functional correctness.

Usage of Database Hints removed.

Functional related adaptations.

SPDD and SPAU activities.

Client : GSKBIO, Belgium

Role : ABAP HANA Consultant

Environment : R3

Team Size : 10

Duration : 10th Oct 2011 to 31st March 2016.

Responsibilities:

Identify conflict programs using SCI,ATC, SQLM, SWLT standard tcodes

Performance modifications for ABAP programs on S/4 HANA

Created flexible attribute, analytic and calculation views, designing SQL queries based on real-time and historic data.

Created CDS Views using CDS editor and consumed in ABAP Programs

Used Fuzzy Search and ALV on HANA.

Developed Analytic Privileges and Stored procedure in HANA Studio.

New development to send an e-mail to warn employees and employees’ manager of a new absence to a medical visit.

Responsible for code review.

Responsible for BI, Workflow, Batch Jobs and Batch Input Session Monitoring

Client : Godrej.

Role : ABAP Technical Consultant

Environment : R3

Duration : 23rd Aug 2011 to 9th Oct 2011.

Responsibilities:

Responsible for the extended syntax checks, Code inspector checks and fixes.

Responsible for the Functional Unit Testing and Technical Unit Testing.

Responsible for code review.

Responsible for the preparation of Technical Specification for developments.

Uploading the QUALITY INSPECTION VARIANCE Excel File into SAP System.

Displaying the CUSTOMER COMPLAINTS DATA in ALV GRID.

Uploading the DIE LIFE TRACK data into the custom table in SAP System.

Providing F4 help for Custom screen field Die Serial Number in CO01 and CO02 transaction codes.

Client : SAIL.

Role : ABAP Technical Consultant

Environment : R3

Duration : 28th Mar 2011 to 29th Jul 2010.

Responsibilities:

Responsible for the extended syntax checks, Code inspector checks and fixes.

Responsible for the Functional Unit Testing and Technical Unit Testing.

Responsible for code review.

Created 3 Purchase Requisition Fields namely Tender Mode, Cost Center and Installed Quantity in the shopping cart.

Populated the custom field values of Tender Mode, Cost Centre and Installed quantity of Purchase Requisition into the created custom fields of Shopping Cart.

Populated the Special terms and conditions of an item in to the supplier note.

Created an extra row Item Description in the Shopping Cart.

Mapped SRM Purchase order condition types to ECC PO condition types.

Client : Dexler Information Solutions, Bangalore.

Role : ABAP Associate Consultant

Environment : R3

Duration : Mar’10 to Feb’11.

Responsibilities:

Worked as an ABAP Associate Consultant providing support and maintenance to the client for the developed product.

Solved various tickets raised by users during the usage of the developed application.

Created Custom tables.

Used the ABAP runtime analysis tool (SE30) to analyze & improve runtime performance.

A report created to display Customer details. The report displays Customer Number, Customer Name and City in which Customer resides.

Worked on Web Dynpro ABAP ALV using component usage.

Developed Web Dynpro applications to call BAPIs

Create a custom implementation for the BADI.

Adding a filter Object in a BADI

Create a custom BADI Multiple use implementation.

Personal profile

Name : Sanjoy Kumar Gorain

Gender : Male.

Marital Status : Married.

Language Proficiency : English, Hindi and Bengali.

I hereby declare that all the statements made above are true to the best of my knowledge and belief.

Place: - Bangalore Sanjoy Kumar Gorain

Contact this candidate