Shivam Tyagi

Data Analyst

Noida 2+ yrs exp 85 · Excellent

About

Results-driven Data Analyst skilled in Power BI, SQL, Microsoft Fabric, and Excel, with expertise in dashboard development, data modeling, ETL processes, and KPI reporting. Experienced in automating reports, optimizing workflows, and transforming complex data into actionable insights that improve business performance, reporting accuracy, and operational efficiency & Experienced in working within Agile/Scrum environments and collaborating with cross-functional teams to deliver data-driven solutions.

Skills & Expertise (29)

Excel Advanced

8.0/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Dashboard Development Advanced

8.0/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

Advanced SQL Intermediate

7.5/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Joins Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Data Transformation Intermediate

7.0/10

Years Exp

Data Validation Intermediate

7.0/10

Years Exp

Data Modeling Intermediate

7.0/10

Years Exp

Reporting Automation Intermediate

7.0/10

Years Exp

KPI Reporting Intermediate

7.0/10

Years Exp

Power BI Service Intermediate

7.0/10

Years Exp

Business Intelligence Intermediate

7.0/10

Years Exp

Power Query Intermediate

6.5/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.5/10

Years Exp

Statistical Analysis Intermediate

6.5/10

Years Exp

Trend Analysis Intermediate

6.5/10

Years Exp

Performance Analysis Intermediate

6.5/10

Years Exp

ETL Processes Intermediate

6.5/10

Years Exp

Subqueries Intermediate

6.5/10

Years Exp

Window Functions Intermediate

6.5/10

Years Exp

CTEs Intermediate

6.5/10

Years Exp

Matplotlib Intermediate

6.0/10

Years Exp

Requirement gathering Intermediate

6.0/10

Years Exp

M Language Intermediate

5.5/10

Years Exp

Microsoft Fabric Intermediate

5.5/10

Years Exp

Work Experience

Data Analyst

Clovia

Jul 2025 - Present

Developed interactive Power BI dashboards using DAX measures, advanced visualizations, and Power BI Gateway, reducing manual reporting effort by 50%. Analyzed lead performance data across geographies and product categories, implementing Row-Level Security (RLS) to ensure secure data access and contributing to 8–10% revenue growth. Created SQL-based analytics reports for performance tracking and user behavior analysis. Worked with large datasets to identify business trends, operational gaps, and growth opportunities. Supported management teams with KPI monitoring dashboards for faster business decision-making. Improved reporting accuracy and reduced turnaround time by streamlining data transformation processes.

Data Analyst

Kryptora Infotech

Jan 2024 - Jun 2025

Developed and automated Power BI dashboards, reducing manual reporting effort by 35% and improving report delivery efficiency. Performed lead funnel analysis and product performance tracking using SQL queries and business KPIs. Optimized SQL queries in Metabase to improve dashboard loading speed and faster data retrieval. Built automated reporting structures that helped teams monitor operational KPIs in real time. Assisted stakeholders with data-driven insights for improving business performance and process efficiency. Reduced repetitive reporting workload by automating daily and weekly reporting tasks.