Abhay Kumar
IT Consultant
Gurgaon,HR
Summary
Data and Analytic consultant with PwC India for more than 7 years of experience covering a wide range of different tools in my skill sets. I am currently leading Snowflake migration project Functionally and tableau reporting. I have also contributed in end-to-end implementation projects in SAP native HANA, HANA 2.0 as modeler and gathered a year of BO reporting experience mainly in Web intelligence and exposure of SAC reports and stories. I find myself a fast learner and problem solver with positive attitude and looking for opportunities where works are challenging so that he can gather some new experience along with sharing his knowledge and experience earned till date. I love to work in a team with give and take mindset. When it comes to work on any engagement or project. I feel dedicated and motivated to work for the firm in the path of the progress and at the same time I can also learn and progress in my professional and personal perspective.
Overview
8
8
years of professional experience
1
1
Certification
1
1
year of post-secondary education
Work History
Senior Consultant
PwC India
Kolkata
04.2021 - Current
- Integration of SAP and Non-SAP data sources with SAP Datasphere and SAC
- Data modeling in SAP datasphere
- Requirement gathering with users for the KPIs and dashboards
- Sending and receiving data from and to SAC & Datasphere
- Hierarchy definition and Time dimension views
- Standard CDS views identification for intended reports
- Helped the customer to expedite their decision process 20% fast
- Helped the customer to migrate their existing reports in AFO and Bex query to SAC and Datasphere
Consultant
PwC India
Kolkata
07.2017 - 03.2021
- Functional Lead for all modules (Primarily for SD and Planning models)
- Delivered more than 10 self service models in Tableau and 4 dashboards
- Lead a team of 7 people and also worked on the data flow design of few models
- Organized Workshops with end users to take requirement
- Build test cases, owned the SIT and driven UAT with users
- Trained the users on how to use the tableau reports and do few ad-hoc analysis if required by using selfservice models and dashboards
- Impact analysis on movement of models from classic to HANA 2.0
- Requirement gathering and self-initiator on POCs
- Developer of Synonyms, roles, Stored procedure, tables and Calculation views wherever required
- Gathered requirement from functional team and clients and created the technical specification as well the data flow diagram in the project
- Key developer of Native HANA Models (calculation views, wrote stored procedures, created Analytical Privileges and repo roles for security and table functions) in entire journey of project
- Report developer in Web Intelligence on top of final HANA views
- Performance Optimization of calculation views
- Created BW objects like ADSOs, DTP, Transformation and process chains to materialization and snapshotting of data as per requirement
- Worked end to end from Hana views development to report development and lead the team in crucial time to make the project delivered in time and ready to take such roles in future
- Key Risk Indicator (KRI) identification and definition as per client requirement which help to take necessary action
- Requirement gathering from functional team
- Created basic CDS views and calculation views in S4 HANA
- Created Bex Query in Query designer on top of CDS Views
- Solely Designed and delivered SAP WEB Intelligence Reports
- Worked on Dashboard development on SAP Lumira designer
Education
MBA - Business Strategy & Management
IIM Lucknow
04.2024 - Current
Post Graduate Program - Data Science and Business Analytics
Great Lakes Executive Learning
01.2021
B. Tech - Mechanical Engineering
National Institute of Technology, Durgapur
01.2017
Intermediate - Science
Gaya College
01.2013
Skills
- SAP Native HANA
- HANA Studio
- HANA 20
- Calculation Views
- Stored Procedures
- Analytical Privilege
- Table functions
- SAP BW4/HANA
- Process Chains
- ADSOs
- DTP
- Transformations
- Snowflake
- SAP Datasphere
- SAP Web Intelligence
- Power BI
- SAP Analytics Clouds
- RDBMS SQL
- MS Excel
- MS PowerPoint
- Visio
- SAP SD
- SAP FI-RAR
- S4HANA On-Premise
- S4HANA Cloud
- ECC
- IBP
- Ariba
- Navision
- Pronto
Certification
- SAP Certified Application Associate SAP Analytics Cloud, 09/01/21
- AWS Cloud Practitioner Certification, 06/01/21
- Microsoft Certified: Data Analyst Associate (PowerBI), 03/01/21
- SAP HANA Implementation, Modeling and reporting Course, 10/01/20
- SAP BI/SAP Business Objects Web Intelligence Online course, 01/01/20
- Above and Beyond Award, 2019 & 2022
- Above and Beyond Award, 2020 & 2022
Great Learning Profile
https://eportfolio.greatlearning.in/abhay-kumar3
Skills
SAP Native HANA (HANA Studio) & HANA 2.0(WebIDE only), SAP BW4/HANA, Snowflake, SAP Datasphere, SAP Web Intelligence, Power BI, SAP Analytics Clouds, RDBMS SQL, MS Excel, MS PowerPoint, Visio, functional knowledge of SAP SD and SAP FI-RAR modules, S4HANA On-Premise and Cloud (Public), ECC, IBP, Ariba, Navision, Pronto
Timeline
MBA - Business Strategy & Management
IIM Lucknow
04.2024 - Current
Senior Consultant
PwC India
04.2021 - Current
Consultant
PwC India
07.2017 - 03.2021
Post Graduate Program - Data Science and Business Analytics
Great Lakes Executive Learning
B. Tech - Mechanical Engineering
National Institute of Technology, Durgapur
Intermediate - Science
Gaya College
Similar Profiles
Vanya AroraVanya Arora
Associate at PwC IndiaAssociate at PwC India
Abhishek SinghAbhishek Singh
Associate Tax Manager at PWC IndiaAssociate Tax Manager at PWC India
Prashant TripathiPrashant Tripathi
Manager, Digital Supply Chain Transformation at PwC IndiaManager, Digital Supply Chain Transformation at PwC India
Isita PaulIsita Paul
Senior Associate at PwC IndiaSenior Associate at PwC India
ANJALI SINGHANJALI SINGH
Senior Talent Acquisition Specialist at Accor PlusSenior Talent Acquisition Specialist at Accor Plus