HARSHAL ARBAT
AMRAVATI,
Summary
- SAP Certified Consultant with 6+ years of experience in SAP BW/4HANA, SAP Native HANA, SAP BW on HANA, and SAP Datasphere.
- Skilled in ABAP and AMDP for custom data extractions, transformations, and performance tuning.
- Expertise in End-to-End Greenfield and Brownfield implementations, migrations, and support projects.
- Proficient in Agile methodologies for iterative, efficient project delivery.
- Proven team player with a track record of cross-functional collaboration to enhance Business Intelligence and drive data-driven decision-making for global clients.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Consultant
Deloitte India
Pune, India
04.2024 - Current
- Designed and implemented a Sustainability Reporting solution for ESG (Environmental, Social, and Governance) and EU Taxonomy Reporting (EUT) using SAP Datasphere
- Engineered backend data flow to the Composite Provider level in BW/4HANA and exposed as remote tables in SAP Datasphere for optimized data integration
- Developed Graphical views in SAP Datasphere to model and transform data for ESG and EUT reporting, ensuring data readiness for analysis
- Enabled data consumption in SAP Analytics Cloud (SAC) for reporting and actionable insights
- Collaborated with business stakeholders to define requirements and deliver a scalable solution for sustainability metrics
- Designed and implemented Core Data Services (CDS) Views for data modeling and extraction in SAP S/4HANA
- Leveraged CDS Annotations for analytical queries and optimized performance with SQL-based transformations
- Integrated CDS Views with SAP BW/4HANA and SAP Datasphere for real-time data consumption
- Provided technical support and troubleshooting for SAP BW/4HANA systems, ensuring high availability and optimal performance
Consultant
Deloitte India
Pune, India
04.2023 - 03.2024
- Played a pivotal role in the Shell conversion project, migrating the client's SAP BW 7.4 system to SAP BW/4HANA
- Conducted system analysis and devised the migration strategy
- Optimized data models and ETL processes, reducing data load times by 40%
- Executed data migration using SAP BW/4HANA Conversion Cockpit and performed post-migration validation
- Provided training and support to end-users, ensuring a smooth transition
- Developed innovative solution to convert legacy APDs (Analysis Process Designer) into HANA Calculation Views, enhancing performance and enabling real-time analytics
- Designed and optimized data models with ADSOs, Composite Providers, and HANA Calculation Views, while enhancing ABAP routines, transformations, and AMDP scripts to improve ETL performance
Application Development Analyst
Accenture
Pune, India
10.2021 - 03.2023
- Integrated BW on HANA objects with Native HANA and used them to implement complex business requirements
- Extracted data from SAP R/3 (FI/CO, SD, MM) into SAP BW using LO, LIS, and Generic extraction techniques, while creating and modifying Data Sources including delta mechanisms and initialization of delta loads
- Hands-on experience with SAP HANA SDI, XS Job creation, and HANA Flow graph management
- Worked on Bex Queries, Webi Reports, Rank function, Pruning techniques, Input Parameters, and variables, Performed currency conversions in HANA Views
- Developed and optimized Stored Procedures and Table Functions using SQL Script and CE Functions to handle complex business logic and process large datasets efficiently
Associate Consultant
Capgemini
Bengaluru, India
09.2018 - 09.2021
- Contributed to enhancements and reviews of various BI backend objects including CPs, ADSO, InfoCubes, Data Sources, Transformations, ABAP routines, DTPs, Process Chains
- Designed and managed Process Chains for data loads (Master and Transactional Data) using InfoPackages, DTPs, and flat files, ensuring timely completion and resolving failures
Education
Bachelor of Engineering - Electrical Engineering
G.H Raisoni College of Engineering
Nagpur, MH01.2018
Higher Secondary Education - Science
Smt. UDJC Jr College
01.2014
Secondary Education -
Fatima Convent Highschool
01.2012
Skills
- SAP BW/4 HANA
- SAP BW on HANA
- SAP DATASPHERE
- SAP NATIVE HANA
- SAP EMBEDDED ANALYTICS
- SAP HANA SDI
Certification
- SAP Certified Application Associate - HANA2.0(SPS05)
- SAP Certified Application Associate - SAP BW/4HANA 2.x
Timeline
Consultant
Deloitte India
04.2024 - Current
Consultant
Deloitte India
04.2023 - 03.2024
Application Development Analyst
Accenture
10.2021 - 03.2023
Associate Consultant
Capgemini
09.2018 - 09.2021
Higher Secondary Education - Science
Smt. UDJC Jr College
Secondary Education -
Fatima Convent Highschool
Bachelor of Engineering - Electrical Engineering
G.H Raisoni College of Engineering