Sap Bw 4 Hana

Vijay Kuntla LinkedIn Profile : LinkedIn

SAP BW* HANA Consultant

+1-303-***-**** ******.********@*****.***

Professional Summary

• Certification: SAP Certified Application Specialist - SAP BW/4HANA 2.0 Delta.

• SAP BW/4 HANA – ABAP: Having 12 years of experience in SAP BW with strong exposure in S/4 HANA ABAP programming, Implementing Transformations using AMDP OO-ABAP Object oriented Programming, debugging, Data dictionary, Enhancements, BADI’s and Customer Exits, Function Modules, HANA CDS Views, HANA Modelling.

• S4 HANA ABAP Development Tools – Eclipse: Experience in Eclipse in creating SAP ABAP CDS views, HANA studio, HANA SQL Scripting, Analysis for Office – AO, Native HANA, Data Provisioning.

• Native HANA: Design and implement SAP HANA information models using Attribute views, Analytic views, Calculation views, stored procedures, CE functions and SQL script, carry out currency and UOM conversions.

Technical Skills

• ERP Packages - SAP BW/4 HANA, S/4 HANA.

• ABAP Development Tools - Eclipse.

• BW Modelling Tools - Modeling Tools for SAP BW/4HANA.

• Programming Languages - SAP ABAP, SQL.

• Reporting Tools - SAP - BEX Query Designer, AO – Analysis for Office.

• SAP Functional Modules - Logistics – SD and MM.

• BI tool - Power BI.

Education

• Master Of Technology from University of Hyderabad August 2008 SAP BW4 HANA - ABAP Expertise

• Strong exposure in S4 HANA ABAP object Oriented programming for SAP BW.

• Implementing transformation routines using AMDP.

• Debugging Routines in Infopackage Routine, Start Routine, End Routine, Expert Routine.

• Extracting data using SLT from SQL Server and other 3rd Party into HANA Data base.

• Creating S4 HANA and BW4 HANA CDS Views – Core Data Services.

• Creating SAP Open ODS view, ODP Objects, Transient provider, Virtual Provider in SAP BW.

• Implementing Routines in Infopackage Routine, Start Routine, End Routine, Expert Routine.

• Creating classes, implementing interface methods, Function Modules, Tables, Views etc., and debugging source code.

• Creating Restricted Key Figures, CKF, RKF, Conditions, Exceptions, and Variables.

• Enhancing DataSource by appending structure and populating the Extract Structure with Data using BADI's.

• Performance Issues, Info cube management using Compression, roll up, Partitioning and performance tuning, using Aggregates.

• Worked extensively on Bex Query designer in building queries using Filters, Variables, Structures, Restricted Key figures, Calculated Key figures, Calculations, Exceptions and created aggregates for frequently used queries.

• Replaced CMOD code with BADI’s for Datasource enhancements and Bex Customer exit variables. Native Hana - SQL Scripting Expertise:

• Extensively worked on stored procedures with parameters.

• Created User defined exceptions and handled errors.

• Used Dynamic Filter on table functions.

• Extensively created and used Table functions and Scalar functions.

• Used scalar functions in table functions.

• Created Table variables and table types.

• Design and implement SAP HANA information models using Attribute views, Analytic views, Calculation views, stored procedures, CE functions and SQL script, carry out currency and UOM conversions.

• Data Provisioning - SLT replication server to load real-time data from SQL server to HANA. Organization : Object Experts LLC April 2024 – Till Date Client : USAA

Role : SAP BW4 HANA Consultant

Responsibilities:

• Worked on Native HANA – Attribute views, Analytic Views, and Calculation Views.

• Worked on Joins- Inner, Left, Right, text.

• Created filters on Table functions.

• Extracted data from SQL server to HANA using SLT data provisioning.

• Created Calculation views using tables.

• Used Calculation views in composite providers and built reports.

• Implementing Transformation routines using AMDP.

• Extensively worked on S/4 HANA CDS Views and used CDS Views as Datasource in SAP BW4 HANA.

• Fixing all Abap related issues which cannot be migrated to HANA.

• Implementing and debugging Routines in Infopackage Routine and Transformation Start Routine, End Routine, Expert Routine.

• Creating Calculation views for on HANA Studio to consume in BOBJ, and other third-party tools.

• Leveraged existing BW extractors and enhancing them to perform better on HANA.

• Design and implement SAP HANA information models using Attribute views, Analytic views, Calculation views, stored procedures, CE functions and SQL script, carry out currency and UOM conversions.

Organization : Epiq Global November 2020 – April 2024 Project : Master data Enhancement Project

Role : SAP BW4 HANA Consultant

Responsibilities:

• Implementing Transformation routines using AMDP.

• Creating Core Data Services – CDS Views and in Eclipse and using CDS views as Datasource in SAP BW like generic datasource.

• Implementing Routines in Infopackage Routine, Start Routine, End Routine, Expert Routine.

• Creating Table Functions and calling Class methods.

• Replicated data using SLT.

• Extensively worked on HANA CDS views and used them as Datasources.

• Enhancing the Datasources and Creating Generic DataSources.

• Migrated info Cube, DSOs into HANA and modified as per requirements and created models using HANA studio.

• Creating composite providers, Open ODS Views, ADSO’s – Advanced DSO’s.

• Compressing Cubes, Monitoring Process Chains, and fixing errors.

• Debugging Field Routines, Start Routines, End Routines, Expert Routines

• Creating programs for mass data upload, validating data across ECC, BW and in Reports.

• Debugging and finding root cause analysis, Performance tuning.

• Creating information objects / Data models (packages, attribute views, analytic views, Calculation views Graphical and SQL script based, Decision tables, Stored Procedures).

• Created procedures and used them in table functions and calculation views. Organization : ITC Infotech. March 2018 – October 2020 Client : Sigma Aldrich Merck

Role : SAP BW HANA Consultant

Responsibilities:

• Installing Business content to replicate the data from Source system to target system BI.

• Implementing Transformation routines using AMDP.

• Enhancing the Datasources and creating Generic DataSources.

• Debugging and code fix in Infopackage Routine, Start Routine, End Routine, Expert Routine.

• Designing process chains - RSPC for master data loads and transaction data loads.

• Developing the CDS views and consuming in Analysis for Office.

• Replacing Exits and Implementing BADI for Customer exit Variables for Datasource Enhancement and BEx variables.

• Design and implement SAP HANA information models using Attribute views, Analytic views, Calculation views, stored procedures, Table Functions, CE functions and SQL script, carry out currency and UOM conversions.

• Used SLT replication server to load real-time data from SQL Server to HANA. Organization : CenturyLink Technologies India Private Ltd. June 2016 – Feb 2018 Client : eBay

Role : SAP BW HANA Consultant

Responsibilities:

• Creating SAP BW objects like Composite provider, InfoCube, ADSO.

• SAP HANA and BW Modeling in SAP HANA studio.

• Implementing Routines in Infopackage Routine, Transformation’s Start Routine, End Routine, Expert Routine.

• Created HANA objects using SQL Editor and GUI option.

• Design and implement SAP HANA information models using Attribute views, Analytic views, Calculation views, stored procedures, Table functions, CE functions and SQL script, carry out currency and UOM conversions.

• Extracting data using SLT from SQL Server to HANA.

• Designing process chains, monitoring, and scheduling the process chains.

• Data Reconciliation’s to verify the data in SAP R/3 and SAP BW after the data loads.

• Debugging Routines at various levels like InfoPackage Routine, Start Routine, and End Routine.

• Creating custom queries & defined Calculated Key Figures, Restricted Key Figures. Organization : Capgemini March 2014 – March 2016

Client : Altria

Role : SAP BW Consultant

Responsibilities:

• Creating DSOs, InfoCube and MultiProviders, data reconciliation with ECC system.

• Creating HANA Tables and Attribute, Analytical and Calculation views.

• Collecting objects in transport requests and transport requests from Development to quality and Production.

• Creating test cases and performance checks.

• Enhancing DataSources by implementing Exits and BADI's.

• Implementing Routines in Infopackage Routine, Start Routine, End Routine, Expert Routine.

• Creating Tables, views, and Function Modules as part of Generic extraction.

• Creating HANA stored procedures, and Table Functions.

• Creating custom queries and defining Calculated Key Figures, Restricted Key Figures. Organization : ProcessWeaver Software Solutions Pvt. Ltd. April 2013 – December 2013 Client : AP Genco

Role : Senior Software Engineer.

Responsibilities:

• Developing process chains for master data loads and transaction data loads and scheduling the Process chains for periodic loads.

• Implementing Routines in Infopackage Routine, Transformation’s Start Routine, End Routine, Expert Routine.

• Extracting data from various Source systems.

• Escalating high-prioritized tickets regarding extractions, Performance Issues, and load failures.

• Scheduling and Monitoring of InfoPackages. Keeping note of all the tickets until they are closed.

• Data Reconciliation’s to verify the data in SAP R/3 and SAP BW after the data loads. Organization : Logica. June 2011 – July 2012

Client : AMB

Role : IT Consultant

Responsibilities:

• ABAP Data Dictionary: Creation and maintenance of tables, structures, views, and other dictionary objects. Module Pool Programming: Extensively worked on Module Pool Programming.

• Implementing and debugging Routines in Infopackage Routine, Transformation’s Start Routine, End Routine, Expert Routine.

• Reports: Creation of Classical, Interactive and ALV Reports, debugging and performance tuning

• Modularization techniques: Include, Subroutines, Function modules, Macro’s.

• Performance check using SQL trace and Run Time Analysis.

• Enhancements: Enhancing standard business applications using User Exits and Badi’s.

Contact this candidate