Aviral Anand

Data Analyst

Bokaro Steel City, Jharkhand 1+ yrs exp 84 · Excellent

About

Results-driven Data Analyst with 1.5+ years of experience in business operations analytics within a consulting environment. Specialized in SQL query optimization, Power BI dashboard development (DAX, data modeling), Advanced Excel automation, and Python-based data processing. Proven track record of transforming 100K+ raw records into actionable insights, improving reporting efficiency by 40% and operational performance by 12%.

Skills & Expertise (27)

SQL Intermediate

7.5/10

1.5

Years Exp

Data Cleaning Intermediate

7.0/10

1.5

Years Exp

Python Intermediate

7.0/10

1.5

Years Exp

Power BI Intermediate

7.0/10

1.5

Years Exp

KPI Dashboards Intermediate

7.0/10

1.5

Years Exp

Complex Joins Intermediate

6.5/10

1.5

Years Exp

Power Query Intermediate

6.5/10

1.5

Years Exp

Advanced Excel Intermediate

6.5/10

1.5

Years Exp

DAX Intermediate

6.5/10

1.5

Years Exp

Query Optimization Intermediate

6.5/10

1.5

Years Exp

NumPy Intermediate

6.0/10

1.5

Years Exp

Stakeholder Requirement Gathering Intermediate

6.0/10

1.5

Years Exp

Performance Analytics Intermediate

6.0/10

1.5

Years Exp

KPI Intermediate

6.0/10

1.5

Years Exp

Executive Reporting Intermediate

6.0/10

1.5

Years Exp

MIS Intermediate

6.0/10

1.5

Years Exp

Data Transformation Intermediate

6.0/10

1.5

Years Exp

ETL Intermediate

6.0/10

1.5

Years Exp

EDA Intermediate

6.0/10

1.5

Years Exp

CTEs Intermediate

6.0/10

1.5

Years Exp

Star Schema Intermediate

6.0/10

1.5

Years Exp

Pandas Intermediate

6.0/10

1.5

Years Exp

Aggregations Intermediate

6.0/10

1.5

Years Exp

Automation Intermediate

6.0/10

1.5

Years Exp

XLOOKUP Intermediate

6.0/10

1.5

Years Exp

Pivot Tables Intermediate

6.0/10

1.5

Years Exp

Data Modeling Intermediate

6.0/10

1.5

Years Exp

Work Experience

Data Analyst

Ascendion

Sep 2024 - Present

Optimized 30+ complex SQL queries processing 100K+ records for performance reporting. Developed Power BI dashboards with DAX and star-schema models to track revenue and SLA KPIs. Automated recurring MIS reports reducing manual effort by 40%. Built Python data cleaning workflows improving reporting accuracy by 20%. Performed trend and root-cause analysis improving operational efficiency by 12%. Collaborated with stakeholders to deliver data-driven business insights.

Education

B.E. Computer Science - Sathyabama University

2019 - 2023 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10

📄 Resume 10/10

💼 Job Title 10/10

✍️ Bio 10/10

🛠️ Skills 20/20

🎓 Education 10/10

⏱️ Experience 9/15

💰 Rate 0/5

🏆 Certs 0/5

✅ Verified 5/5

Total Score 84/100

Profile Overview

Member sinceJun 2026

Skills (27)

Click a skill to find developers with the same skill

SQL Data Cleaning Python Power BI KPI Dashboards Complex Joins Power Query Advanced Excel DAX Query Optimization +17 more

Similar Profiles

Raushan Kumar

Data Analyst | Data Scientist

Divyanshu

Data Analyst

Saijyothi A

Data Analyst

Omkar Phadatare

Computer Science Graduate

View All Developers →