Shivam Dhoot
New Delhi
Summary
Detail-oriented Data Analyst with 2.6 years of experience in SQL development, data transformation, and business intelligence. Proficient in building end-to-end ETL pipelines, designing interactive Power BI dashboards, and analyzing large datasets to derive actionable insights. Adept at performance optimization and automating reports to enhance business decision-making.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst
Accenture
10.2022 - Current
- Developed and optimized SQL queries to extract, transform, and analyses large datasets, improving query performance by 30%
- Designed and deployed interactive Power BI dashboards to monitor operational and financial KPIs, enhancing stakeholder visibility
- Built and maintained ETL pipelines using Teradata tools (Fast Load, TPT), reducing integration time by 60%
- Automated data validation processes using SQL, improving accuracy and reducing manual effort
- Ensured data consistency and integrity across multiple databases through rigorous transformation and validation procedures
- Developed and maintained Teradata BTEQ scripts and load processes, ensuring scalable and high-performance data workflows.
- Deployed Teradata scripts and automated ETL updates using CI/CD pipelines for streamlined release cycles.
- Collaborated with cross-functional stakeholders to gather business requirements and translate them into actionable data solutions.
Education
BCA -
Jamia Hamdard University
01-2020
MCA -
Amity University
01-2022
Skills
- Data Analysis & Programming: SQL, Python (pandas, NumPy, matplotlib), Excel (Pivot Tables, Power Query)
- ETL & Databases: Teradata (BTEQ, Fast Load, Multiload, TPT), SQLA, Data Modelling
- Visualization & Reporting: Power BI (DAX, Dashboarding), Excel, KPI Reporting
- Tools & Platforms: JIRA, Bitbucket, Confluence, ServiceNow, Unix, CI/CD Teradata
Certification
- TERADATA VANTAGE ASSOCIATE - TERADATA
- SQL SKILL FORGE - ACCENTURE
- POWER BI FOR BUSINESS INTELLIGENCE - UDEMY
Timeline
Data Analyst
Accenture
10.2022 - Current
BCA -
Jamia Hamdard University
MCA -
Amity University
Similar Profiles
Harshit PandeyHarshit Pandey
DevOps Engineer/Cloud Migration Engineer at AccentureDevOps Engineer/Cloud Migration Engineer at Accenture
JAGRATI REWADIKARJAGRATI REWADIKAR
Service Delivery Ops Analyst at AccentureService Delivery Ops Analyst at Accenture
Jasika SukhejaJasika Sukheja
Software Developer at AccentureSoftware Developer at Accenture
Umair KhanUmair Khan
Content Reviewer at AccentureContent Reviewer at Accenture
Ankit TanejaAnkit Taneja
Founder at Uphaar - Roohani EnterprisesFounder at Uphaar - Roohani Enterprises