DILIP KUMAR BHAGAVATULA
Hyderabad
Summary
Dynamic SAP Consultant with extensive experience at Tata Consultancy Services, specializing in SAP HANA and BW modeling. Proven track record in data transformation and analysis, enhancing system performance and efficiency. Adept at SQL programming and ABAP development, with strong problem-solving skills to drive impactful business solutions.
Overview
14
14
years of professional experience
Work History
SAP Consultant
Tata Consultancy Services
Hyderabad
06.2020 - Current
- Responsible for deliverables of SAP HANA/ SLT/ BW/ BODS.
- Support and maintenance for HANA developments with complex Stored Procedures which contain modelling and processing logic to fetch data from multiple tables and loads data into Celonis application.
- SLT system which provides real time and batch load data from ECC, CRM and BW models into HANA system.
- Worked on Data Services part in Cloudera Project where data is extracted from ECC and CRM systems and loaded into Microsoft Azure through data pipelines.
- BW models support and maintenance to fetch data from EBS, Nalco and other systems with slicing, dicing and modelling logic to provide data to reports.
- Implementation of best procedures and tweaking the systems to improve performance of the existing models.
- Troubleshoot and monitoring of loads, cutover activities for new datasources and enhancement of existing datasources.
- Identified and proposed few performance, load and query improvement techniques in BW area.
- Client Name: Ecolab Inc
- Languages: SAP ABAP, SQL
- Special Software: SAP HANA/ BW/ BODS
Analytics Lead
Tata Consultancy Services
Hyderabad
05.2019 - 05.2020
- Responsible for deliverables of SAP HANA/ BW/ BODS.
- Demonstrated ability in transforming business decisions into functional requirements and thereby converting those into technical documents to formulate an appropriate multi-dimensional design/planning model after assessing against the usage of SAP delivered Business Content.
- Developed OTC SAP HANA information models such as Procedures and HANA Calculation Views using graphical modelling.
- Support and maintenance of OTC, Sales, Finance and other complex models.
- Loading Data into the SAP HANA Database using SLT, BODS and DXC.
- Worked on HANA XS applications, exposing and consuming data with ODATA services.
- Created Composite Providers and Advance DSO’s.
- Support and maintenance of complete BW and HANA system.
- Worked on Cutover activities at the time of LO Cockpit datasource enhancement.
- Client Name: Corteva
- Languages: SAP ABAP, SQL
- Special Software: SAP HANA/ BW/ BODS
Team Lead
Tata Consultancy Services
Hyderabad
04.2017 - 04.2019
- HANA/ BW Development and Maintenance.
- Supported complex business models in the OD BW environment. Worked on enhancements, monitoring, Incidents, Tasks and performance enhancement techniques.
- Worked on migration of DANISCO HANA models from one environment to other.
- Supported HANA modelling objects defined in the DIH system.
- Data modelling in HANA Studio using Calculation views and Stored Procedures.
- Used inner, outer joins and union Process, Projection, Aggregation, Join and followed the best practices to implement the Calculation Views.
- Loaded data into SAP HANA using various data provisioning techniques like SLT and BODS.
- Worked on analysing issues in HANA Security like Analytical Privileges.
- Trouble shooting existing Complex HANA Models on Data and Performance Issues.
- Worked on supporting, analysing and fixing the issues in OD BODS environment.
- Client Name: Dupont
- Languages: SAP ABAP, SQL
- Special Software: SAP HANA/ BW
SAP HANA/ BODS Consultant
NTT DATA
Hyderabad
11.2016 - 03.2017
- Development and Maintenance.
- Performed data modelling and developed calculation views as final model in HANA Studio.
- Bringing Data from ECC, Oracle and Flat files, also implemented ABAP Data Flows in BODS.
- Experience in debugging execution errors using Data Services logs and by analysing the target.
- Automation, scheduling and monitoring of existing Bods jobs on production.
- Resolution for issues faced in production environment.
- Client Name: Honeywell
- Languages: SAP SQL
- Special Software: SAP HANA/ BODS
SAP HANA/ BODS Consultant
NTT DATA
Hyderabad
11.2016 - 03.2017
- Requirement Gathering, Design and Implementation.
- Created Data Flows for dimension and fact tables and loaded the data into targets in Data Warehouse.
- Validated and executed batch jobs. Tested data flows against sample data and real data.
- Data Services Designer to fetch data from multiple sources including Flat Files, Excel workbooks, XML, SAP ECC and third-party applications through Datastore setup and custom transfer program.
- Developed number of Complex data integrator Mappings and Reusable Transformations to facilitate Daily, Weekly & Monthly Loading of Data.
- Gathered requirements from the Business and applied the look-up functions to meet their requirements.
- Used Global, Local Variables and Parameters between Work flow and Data flow as per business requirements.
- Implemented job template and delta handling for SAP replication jobs, dimensions and fact tables.
- Worked on Custom ABAP mechanism to handle delta for ECC tables.
- Used Formats and Transforms including Flat File formats, Query, Table Comparison, History Preserving, Reverse Pivot, Date generation, Key Generation and Map Operation.
- Configured the mappings to handle SCD Type 2 to preserve the existing records using History Preserve Transformation.
- Tuned Data Integrator Mappings and Transformations for the better performance of jobs.
- Migrated developments from DEV TO TEST TO PROD, & scheduled the jobs.
- Client Name: Alghanim Industries
- Languages: SAP SQL
- Special Software: SAP HANA/ BODS
SAP BW/ ABAP Consultant
NTT DATA
Hyderabad
11.2014 - 10.2015
- Blueprint, Requirement Gathering, Design and Implementation.
- Involved in all phases of the project cycle from Blueprinting, Design Architecture, Configuration, Development, Documentation, Integration Testing and Go Live.
- Having precise expertise in understanding the ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of existing system.
- Handled design and implementation of Bookings as part of Bookings, Backlogs and Billings (BBB) solution.
- Worked on activating the Business content and installing various standard objects to implement a new system.
- Developed Booking data flow by installing standard datasources and developing custom logic.
- Worked on Retraction logic, written ABAP routines, customer exits to deliver efficient data model.
- Created Virtual Providers in BW side to consume in HANA models.
- Made use of SAP Early watch report and implemented best practices and performance tuning techniques to increase the overall health and effectiveness of the system.
- Client Name: Joy Global
SAP BW/ ABAP Consultant
Altimetrik India Pvt. Ltd
01.2013 - 10.2014
- Requirement Gathering, Design and Implementation.
- Demonstrated ability in transforming business decisions into functional requirements and thereby converting those into technical documents to formulate an appropriate multi-dimensional design/planning model after assessing against the usage of SAP delivered Business Content.
- Involved in design and implementation of the project.
- Created design for monthly and daily profit margin reports.
- Calculation of price elements and other cost specific elements.
- Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical documents, designing and developing reports, unit testing(UAT) to Go live production support.
- Single handedly designed and implemented Customer profitability report based on integration between Billing, Delivery, FI, MM, CMN, CO.
- Calculation of KPI’s CRSB, CMN, EBITDA for ACC.
- Implemented Profitability report to find Actual revenue from Billing and costs incurred for sale from GL and various other datasources with drilldown to the least at Customer Invoice level.
- Created process chain for the complete flow and provided post Go-Live support for the project.
- Client Name: HSSA (Holcim Services South Asia)
SAP BW Consultant
Altimetrik India Pvt. Ltd
02.2012 - 06.2012
- Development and Maintenance.
- Configuring layers of SAP BI, responsible for reliable data acquisition and information processing.
- Involved in installing Business content objects and creation of Info Objects, Info cubes, data store objects, infoset, Multiprovider, data sources.
- DTP and transformations based on specs where logics like routines, filters, delta and extraction settings are defined.
- Extensive tuning of the interfaces and reports in the production and development environment thereby leading to faster execution of reports.
- Filling statistical set-up run during down time, initializing LO and enabling delta. Prior to this checking SMQ1 status.
- Designed and activated process chain with varied process types.
- Involved in generation of MM Reports using functions like selections, variables, structures, exception aggregation and constant selection.
- Support activities involve scheduling and daily monitoring process chains. Creating infopackages and triggering extractors and redesigning process chains for loading master and transaction data in background.
- Involved in Info Cube maintenance i.e., Compression, Roll-up of Aggregates.
- Designing BEx queries optimally with BEx functions like RKF/CKF, variables with multiple processing types exclusively customer exits and designing workbooks and assigning same to roles.
- Client Name: Mahindra Group
Education
Bachelor of Technology - Electrical and Electronic Engineering
Jawaharlal Nehru University
Kakinada, India01.2009
Skills
- SAP HANA
- BW modeling
- Data transformation
- SQL programming
- ABAP development
- Data analysis
Designation
Assistant Consultant
Passport Details
N9111363
Date Of Joining
04/19/17
Personal Information
- Number of Children: None
- Date of Birth: 04/18/87
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Timeline
SAP Consultant
Tata Consultancy Services
06.2020 - Current
Analytics Lead
Tata Consultancy Services
05.2019 - 05.2020
Team Lead
Tata Consultancy Services
04.2017 - 04.2019
SAP HANA/ BODS Consultant
NTT DATA
11.2016 - 03.2017
SAP HANA/ BODS Consultant
NTT DATA
11.2016 - 03.2017
SAP BW/ ABAP Consultant
NTT DATA
11.2014 - 10.2015
SAP BW/ ABAP Consultant
Altimetrik India Pvt. Ltd
01.2013 - 10.2014
SAP BW Consultant
Altimetrik India Pvt. Ltd
02.2012 - 06.2012
Bachelor of Technology - Electrical and Electronic Engineering
Jawaharlal Nehru University