Chanchal Chaudhary
SAP Analytics Consultant
Gurugram
Summary
A multi-skilled and result oriented professional with 6+ years of experience in Business Intelligence. Demonstrated expertise in areas of SAP technologies (SAP Datasphere/BW Bridge, SAP BWSAP BW, SAP HANA, SAP BO).
Overview
7
7
years of professional experience
4
4
years of post-secondary education
3
3
Languages
Work History
SAP Datasphere Consultant | SAP Analytics COE Team
Accenture Solutions Pvt Ltd
Gurugram
11.2023 - Current
- As a core member of the COE team, focusing on the seamless integration and implementation of Datasphere models.
- Establishing bridge between SAP BW & Datasphere.
- Ensuring that the processed data from Datasphere models is accurately channeled for consumption in Azure reporting tools.
- Built Datasphere objects, including dataflows, SQL views, local tables, and graphical views
Designer and Developer
Accenture Solutions Pvt Ltd
Bangalore
12.2019 - 10.2023
- Involved in solutioning and estimation on multiple reports in functional areas like Sales Distribution, Quality Management, Finance etc.
- Involved in End-to-End Analysis, Build, Testing & Migration individually for the Projects and post go live support
- Designing and Implementing HANA architectural solution based on the requirement specification
- Build SAP HANA Information models using multiple operations like Unions, Joins & Aggregations
- Creating Filters, Variable, Input parameter, Calculated Columns & Hierarchies
- Worked on BW modeling with Mixed scenarios (consuming BW objects in HANA views and consuming HANA views in Composite Providers and BW Queries)
- Involved in replication of ERP tables to HANA
- Performing Unit Testing, System Integration Testing and being part User Acceptance Testing
- Developed Standard & Ad-hoc reports in Business Objects Web Intelligence Rich Client using SAP data sources
- Creating OLAP connection on top of Bex query
- Created SQL queries/reports in Impala Hue in Hadoop Ecosystem
- Trained data analyst for development and managed a team of developers to delegate the tasks and to ensure progress
- Played a role of reviewer for solutions/ designs planned for requirements within the project.
Analyst
Capgemini
Bangalore
08.2016 - 11.2018
- Data modeling workbench
- Custom development
- Worked on Data warehouse workbench (RSA1) and customized info objects, info cubes, DSO’s, Data Sources, Transformations, Multi-providers
- Performed data extraction, transformation and loading from SAP and non-SAP source systems into the SAP BW
- Developed queries using Bex Query Designer that had conditional formatting, restricted key figures and calculated key figures
- Worked on Data source enhancement
- Created process chain
- Repartition correction gap at aggregated and detailed level DSOs
- Developed archive Monthly DSOs and performed data loads at aggregated level DSOs
- Classification of product hierarchy in the data reports
- Addition and removal of orders in Backlog reporting DSO
- Selective deletion in DSOs/Info cube
- Developed reports on Info Cubes/multi-providers using Bex Analyzer/Explorer
- Rectified Universes in Business Objects
- Created and scheduled reports on the Business Object universe using WEBI
- Monitoring of the data loads.
Education
Bachelor of Technology (B.Tech) - Computer Science Engineering
Amity University
Gurgaon, Haryana 08.2012 -
Skills
Technical Skills : SAP Datasphere, Native HANA, SAP BW, SAP BW on HANA, SAP BO, Web-Intelligence, SQL
Accomplishments
- Pinnacle Awards FY21
- Pinnacle Awards FY22
Timeline
SAP Datasphere Consultant | SAP Analytics COE Team
Accenture Solutions Pvt Ltd
11.2023 - Current
Designer and Developer
Accenture Solutions Pvt Ltd
12.2019 - 10.2023
Analyst
Capgemini
08.2016 - 11.2018
Bachelor of Technology (B.Tech) - Computer Science Engineering
Amity University
08.2012 -