Aryan Yadav

Data Analyst

Delhi, India 1+ yrs exp 73 · Very Good

About

No bio added yet

Skills & Expertise (22)

Power BI Intermediate

7.0/10

0.5

Years Exp

SQL Intermediate

6.5/10

0.5

Years Exp

Advanced Excel Intermediate

6.5/10

0.5

Years Exp

Data Visualization Intermediate

6.5/10

0.5

Years Exp

CALCULATE Intermediate

6.0/10

0.5

Years Exp

SUM Intermediate

6.0/10

0.5

Years Exp

DAX Intermediate

6.0/10

0.5

Years Exp

Pivot Tables Intermediate

6.0/10

0.5

Years Exp

VLOOKUP Intermediate

6.0/10

0.5

Years Exp

filter Intermediate

6.0/10

0.5

Years Exp

Pandas Intermediate

5.5/10

0.5

Years Exp

Python Intermediate

5.5/10

0.5

Years Exp

VS Code Intermediate

5.0/10

0.5

Years Exp

MIS Reporting Intermediate

5.0/10

0.5

Years Exp

Jupyter Notebook Intermediate

5.0/10

0.5

Years Exp

SQL Developer Intermediate

5.0/10

0.5

Years Exp

DBeaver Intermediate

5.0/10

0.5

Years Exp

Conditional Formatting Intermediate

5.0/10

0.5

Years Exp

NumPy Intermediate

5.0/10

0.5

Years Exp

Git Beginner

4.5/10

0.5

Years Exp

Risk Analysis Beginner

4.0/10

0.5

Years Exp

SAS Beginner

3.5/10

0.5

Years Exp

Work Experience

Data Analyst

KoneXions Pvt. Ltd. (Airtel Africa)

Jun 2025 - Present

Extracted and queried business data from SQL databases using DBeaver and SQL Developer to support daily reporting and operational analysis requirements. Cleaned, transformed, and validated raw SQL data in Excel using VLOOKUP, Pivot Tables, and conditional formatting to ensure accuracy before dashboard ingestion. Built and maintained end-to-end Power BI dashboards — covering KPIs, bar charts, slicers, and summary tables — to visualize operational metrics for stakeholders. Developed DAX measures and calculated columns (SUM, CALCULATE, FILTER) to enable dynamic filtering and accurate metric aggregation across reports. Established Power BI data connections to SQL databases and Excel sources, configuring refresh schedules to keep dashboards updated with live data. Delivered recurring MIS reports and ad-hoc analyses to management by translating cleaned data into actionable visual insights via Power BI.

Data Analyst Intern

QSpiders

Feb 2025 - May 2025

Completed 5 end-to-end data analysis projects encompassing data cleaning, exploratory analysis, and dashboard creation — ranked among the top performers in the batch. Optimized slow-running SQL queries through query restructuring and indexing strategies, achieving up to 40% improvement in query execution speed. Collaborated in a team of 4 using Git for version control and code management, following industry-standard development workflows. Improved data processing efficiency by 80% and data quality by 30% through automated validation pipelines and structured ETL workflows.