Pawan Kumar Dubey
Bengaluru
Summary
Dynamic SAP BW/4HANA Associate Consultant with TCS expertise in designing data models and building SAC dashboards. Proven ability to optimize performance and automate data loads, enhancing data quality. Strong analytical skills combined with excellent client-facing abilities, driving impactful solutions in BI environments. Proficient in BW Modelling Tools and Analysis For Office.
Overview
15
15
years of professional experience
1
1
Certification
Work History
SAP BW4/HANA Associate Consultant
TCS
03.2022 - Current
- Designed and implemented data models using ADSOs, Composite Providers, and Open ODS Views in BW/4HANA.
- Built SAC dashboards and visualizations using live and import data models connecting BW and S/4HANA.
- Automated data loads using process chains and monitored data quality across layers.
- Working as an Individual contributor for Development/Support for SAP BW/4HANA and Integrated planning.
- Worked on Analysis For Office and Bex Report.
- Written VBA to format Analysis for Office Workbooks.
- Worked on Input ready BW queries, Planning Functions, Data Slices, Characteristic relationships, and Planning sequences.
- Worked on Calculation views and Table Functions.
- Debugging Planning functions, Table functions, ABAP codes, and HANA scripts in transformations.
- Extensive worked on AMDP based transformations and debugging.
Senior Consultant
Deloitte USI
07.2019 - 03.2022
- Working as a Solution Specialist for the offshore BI Team.
- Driving a project/change including Requirement Gathering, Effort Estimate, Change, UAT and production support.
- Worked on BEx Query Designer, BEx Analyzer, Analysis for Office and Web Application Designer.
- Writing BI-ABAP code to optimize routines, and data extractors.
- Worked on Analysis For Office (AFO).
- Worked on Performance optimization to reduce query runtime and data loading process.
- Extensively worked on Standard and Generic extractors to pull data from ECC.
- Process chain design to execute parallel loads to meet SLA for data available for reporting.
- Extensively worked on Transformation routine to optimize the long-running loads.
- Developed CDS views to be consumed in Embedded Analytics.
- Worked on Embedded Analytics on cloud and on-premise.
Technical Lead
SAP Labs
11.2016 - 07.2019
- Worked on /JBPB/ Standard content creation and installation.
- Created planning function based on AMDP class.
- Debugged standard/custom planning functions extensively.
- I have created input-ready queries to accept data from users & save it in DSO & cubes.
- Implementation of BADI, customer exits, SAP Exits, and user Exits.
- Extensively worked on Aggregation Level, Data slice, Planning Function, Planning Sequence, Characteristics relations and other Planning objects.
- Created Function Module, ABAP Report.
- Implementing Transformation routines using the ABAP OO technique.
IT Analyst
Tata Technologies
10.2014 - 11.2016
- Implemented Performance Tuning Techniques like creating Indices, Rollup and compressing the data in Data Targets.
- Excellent Client facing skills and articulating requirements into deliverables to support offshore team.
- Activated Info Objects, DSOs, Info cubes and Multi-provider from Standard Business Content.
- Customizing BEx/WEBI/WAD changes according to user requirements.
- Creating Authorization objects and roles for restricting query access.
- Writing queries on SQL Server 2008 based on ad-hoc requests.
- Customizing Universe to create new reports.
- DSM is a Dutch-based multinational life sciences and materials sciences company. DSM's global end markets include food and dietary supplements, personal care, feed, medical devices, automotive, paint, electrical and electronics, life protection, alternative energy and bio-based materials.
Software Engineer
SABMiller
10.2010 - 09.2014
- Load Monitoring/Month End Support/Sales Module support owner.
- Resolution of high-priority incidents within SLA.
- Worked extensively in LO cockpit extraction.
- Business content based on requirements.
- Critical Experience in cutover activities before Go Live.
- 24X7 support of high-priority issues occurring in the daily data loads, and non-availability of consistent data in the report.
- Reconciliation of the Report with ECC Data.
- Experience in tuning system enhancement in terms of Performance, Query Access & Loading.
- South African multinational brewing and beverage company.
Education
Bachelor of Technology - Computer Science
KNIT Sultanpur
Sultanpur 06-2010
Skills
- BW/4HANA
- SAC
- S/4HANA
- HANA Studio
- BEx Queries
- BW Modelling Tools
- Composite Providers
- ADSOs
- InfoObjects
- Open ODS Views
- SAP Analytics Cloud
- Analysis For Office
Certification
- SAP BW4HANA
- SAP Certified Associate - Data Analyst - SAP Analytics Cloud
- SAP Business Data Cloud
- IBM Certified Database Associate -- DB2 9 Fundamentals
Projects
SAP BW4/HANA Associate Consultant, 03/01/22 to Present, TCS, Designed and implemented data models using ADSOs, Composite Providers, and Open ODS Views in BW/4HANA., Built SAC dashboards and visualizations using live and import data models connecting BW and S/4HANA., Automated data loads using process chains and monitored data quality across layers., Working as an Individual contributor for Development/Support for SAP BW/4HANA and Integrated planning., Worked on Analysis For Office and Bex Report., Written VBA to format Analysis for Office Workbooks., Worked on Input ready BW queries, Planning Functions, Data Slices, Characteristic relationships, and Planning sequences., Worked on Calculation views and Table Functions., Debugging Planning functions, Table functions, ABAP codes, and HANA scripts in transformations., Extensive worked on AMDP based transformations and debugging. SAP BW/HANA Consultant, 07/01/19 to 03/31/22, Deloitte USI, Working as a Solution Specialist for the offshore BI Team., Driving a project/change including Requirement Gathering, Effort Estimate, Change, UAT and production support., Worked on BEx Query Designer, BEx Analyzer, Analysis for Office and Web Application Designer., Writing BI-ABAP code to optimize routines, and data extractors., Worked on Analysis For Office (AFO)., Worked on Performance optimization to reduce query runtime and data loading process., Extensively worked on Standard and Generic extractors to pull data from ECC., Process chain design to execute parallel loads to meet SLA for data available for reporting., Extensively worked on Transformation routine to optimize the long-running loads., Developed CDS views to be consumed in Embedded Analytics., Worked on Embedded Analytics on cloud and on-premise. SAP BW/IP/HANA/ABAP Developer, 11/01/16 to 07/31/19, SAP Labs (Contract), Worked on /JBPB/ Standard content creation and installation., Created planning function based on AMDP class., Debugged standard/custom planning functions extensively., Created input-ready queries to accept data from users & save it in DSO & cubes., Implementation of BADI, customer exits, SAP Exits, and user Exits., Extensively worked on Aggregation Level, Data slice, Planning Function, Planning Sequence, Characteristics relations and other Planning objects., Created Function Module, ABAP Report., Implementing Transformation routines using the ABAP OO technique. SAP BI/BO Developer, 10/01/14 to 11/30/16, DSM/TCS, Implemented Performance Tuning Techniques like creating Indices, Rollup and compressing the data in Data Targets., Excellent Client facing skills and articulating requirements into deliverables to support offshore team., Activated Info Objects, DSOs, Info cubes and Multi-provider from Standard Business Content., Customizing BEx/WEBI/WAD changes according to user requirements., Creating Authorization objects and roles for restricting query access., Writing queries on SQL Server 2008 based on ad-hoc requests., Customizing Universe to create new reports. SAP BI/BO Developer, 10/01/10 to 09/30/14, SABMiller, Load Monitoring/Month End Support/Sales Module support owner., Resolution of high-priority incidents within SLA., Worked extensively in LO cockpit extraction., Business content based on requirements., Critical Experience in cutover activities before Go Live., 24X7 support of high-priority issues occurring in the daily data loads, and non-availability of consistent data in the report., Reconciliation of the Report with ECC Data., Experience in tuning system enhancement in terms of Performance, Query Access & Loading.
It Experience
- SAP BW4/HANA Associate Consultant, TCS, 03/01/22, Present
- SAP BW/HANA Senior Consultant, Deloitte USI, 07/01/19, 03/31/22
- SAP BW/IP/HANA Lead Consultant, SAP Labs (Client), 11/01/16, 07/31/19
- SAP BW/BO Technical Consultant, Tata Technologies, 10/01/14, 11/30/16
- SAP BW/ABAP Consultant, Accenture, 09/01/10, 09/30/14
Timeline
SAP BW4/HANA Associate Consultant
TCS
03.2022 - Current
Senior Consultant
Deloitte USI
07.2019 - 03.2022
Technical Lead
SAP Labs
11.2016 - 07.2019
IT Analyst
Tata Technologies
10.2014 - 11.2016
Software Engineer
SABMiller
10.2010 - 09.2014
Bachelor of Technology - Computer Science
KNIT Sultanpur