Aditya Sharma
Gurugram
Summary
Results-driven Senior Consultant at Capgemini, with expertise in Power BI and data migration for approximately 8 years. Successfully reduced costs by $10,000 through innovative business solutions. Proven ability to optimize performance and lead teams, enhancing reporting processes across multiple industries. Adept at transforming complex data into actionable insights while mentoring junior consultants.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Consultant
Capgemini
02.2024 - Current
- Developed and deployed complex reports for media, power, telecommunication, and finance industries
- Designed solution architecture for quarterly reports
- Trained junior consultants on performance optimization with different domain expertise
- Managed and delegated regular customer escalations
- Proposed and implemented business solutions like integration of ServiceNow and Dataflow which significantly reduced the cost (~$10,000)
Consultant
Capgemini
03.2022 - 02.2024
- Owned end to end reporting: defining the scope of the project, gathering business requirements, doing analysis and documents
- Proposed and implemented new solutions and enhancements to existing BI processes of various domains(Finance, Dairy and Healthcare)
- Enhanced reporting by upgrading to custom multi filter visuals from default filters
Associate Consultant
Capgemini
10.2019 - 02.2022
- Handled multi level data migrations:
- Teradata to Snowflake
- Salesforce to Snowflake
- Teradata to Greenplum
- Owned historical data loading using dags in Apache Airflow and Amazon appflow
- Created DDL and DML for snowflake databases
Senior Analyst
Capgemini
10.2018 - 09.2019
- Resolved warehouse performance and access problems by troubleshooting.
- Optimized existing ETL processes by analyzing performance bottlenecks and implementing best practices in Informatica PowerCenter.
Analyst
Capgemini
08.2017 - 09.2018
- Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
- Developed stored procedures, functions and triggers to support application requirements.
- Tested databases and performed bug fixes.
- Provided technical assistance in the form of SQL coding advice to other team members.
Education
B.Tech - IT
I K Gujral Punjab Technical University
Jalandhar06.2017
Skills
- Power BI
- Data Modeling
- DAX
- ETL
- SQL
- Data Visualization
- Data Warehousing
- Performance Optimization
- Snowflake
- Apache Airflow
- Amazon Appflow
- Amazon S3
- Github
- Data migration
- Performance optimization
Certification
- Power BI Data Analyst Associate, PL 300
- Internal Certifications, SSIS, SSRS, Informatica, SQL, Snowflake
Latest Projects
- Canada Life
- Plante Moran
- T-Mobile
- Duracell
- NBC Universal
- Aldi
- Banner Health
- Baker Hughes
Timeline
Senior Consultant
Capgemini
02.2024 - Current
Consultant
Capgemini
03.2022 - 02.2024
Associate Consultant
Capgemini
10.2019 - 02.2022
Senior Analyst
Capgemini
10.2018 - 09.2019
Analyst
Capgemini
08.2017 - 09.2018
B.Tech - IT
I K Gujral Punjab Technical University
Similar Profiles
Abdoul-rahim DombaAbdoul-rahim Domba
Ingénieur d'études et de recherche at CapgeminiIngénieur d'études et de recherche at Capgemini
Bélinda BONACINABélinda BONACINA
Document Management, quality and configuration at CAPGEMINIDocument Management, quality and configuration at CAPGEMINI
Namrata DwivediNamrata Dwivedi
Front End Developer at CapgeminiFront End Developer at Capgemini