Akshay Kumar

Data Analyst

Gurugram, Haryana 0+ yrs exp 82 · Excellent

About

Data Analyst with 1 year of experience in MIS Reporting, Data Analysis, SQL, Excel, and Power BI. Experienced in creating dashboards, automating reports, and analyzing business data. Skilled in transforming raw data into actionable insights that improve operational efficiency and business performance.

Skills & Expertise (23)

Pivot Tables Advanced

8.0/10

Years Exp

Excel Advanced

8.0/10

Years Exp

Interactive Dashboards Intermediate

7.5/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

Dashboards Intermediate

7.5/10

Years Exp

IF formulas Intermediate

7.5/10

Years Exp

VLOOKUP Intermediate

7.5/10

Years Exp

XLOOKUP Intermediate

7.5/10

Years Exp

Data Analysis Intermediate

7.5/10

Years Exp

Aggregations Intermediate

7.5/10

Years Exp

HAVING Intermediate

7.5/10

Years Exp

GROUP BY Intermediate

7.5/10

Years Exp

CTEs Intermediate

7.5/10

Years Exp

Subqueries Intermediate

7.5/10

Years Exp

Joins Intermediate

7.5/10

Years Exp

Pandas Intermediate

7.0/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Power Query Intermediate

7.0/10

Years Exp

KPIs Intermediate

7.0/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

Data Modeling Intermediate

6.5/10

Years Exp

Work Experience

Data Analyst

24X7 Veda Care Pvt Ltd

Feb 2026 - Present

Collected, cleaned, and validated business data from multiple sources to ensure high data accuracy. Developed 50+ SQL queries for sales and MIS reporting, reducing report generation time by 30%. Wrote SQL queries to extract and analyze data for business reporting. Identified trends and patterns in sales and operational data to support decision-making. Automated repetitive reporting tasks using Excel, reducing manual effort. Assisted in basic accounting data handling and record maintenance. Collaborated with cross-functional teams to understand business requirements and deliver actionable insights.

Data Analytics Intern

SkillCircle

Jul 2025 - Jan 2026

Analyzed 100K+ records using SQL (JOINs, Subqueries, CTEs, Aggregations) to extract actionable business insights. Designed 3 interactive Power BI dashboards to track sales, performance metrics, and 10+ KPIs for stakeholders. Cleaned, transformed, and validated datasets using Python (Pandas), improving data accuracy and consistency by 30%. Generated 12+ weekly MIS and performance reports using Excel (Pivot Tables, XLOOKUP, IF formulas), saving 8+ hours/week. Collaborated with 5+ team members to automate reporting workflows, reducing manual effort by 25%. Supported data-driven decision-making by identifying trends across 50K+ records, improving reporting accuracy.