Years of Experince
Chanchal Chaudhary
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 BW, SAP HANA, SAP BO).
Overview
6
6
Work History
Designer and Developer
Accenture Solutions Pvt Ltd
Bangalore
12.2019 - Current
- Involved in solutioning and estimation on multiple reports in functional areas like Sales Distribution, Quality Management, Finance etc.
- Have designed end to end complex process related reports
- 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
01.2016
Skills
- Technical Skills : SAP BW, SAP BW on HANA, Native HANA, SAP BO, SQL
- Functional Skills : OTSC, PLTP, RTR, PRTP
- Tools : SAP GUI, SAP HANA Studio, Eclipse IDE, SAP BO
- Collaboration Skills
- Multi-Tasking Abilities
- Analytical Skills
- Work Prioritization
- Multitasking and Organizing
- Design Concepts Development
Timeline
Designer and Developer
Accenture Solutions Pvt Ltd
12.2019 - Current
Analyst
Capgemini
08.2016 - 11.2018
Bachelor of Technology (B.Tech) - Computer Science Engineering
Amity University