Akash Kumar

Data Analyst

1+ yrs exp 88 · Excellent

About

Data Analyst with 1 year of experience in Power BI, SQL, Excel, and data visualization. Skilled in data cleaning, transformation, and data modeling using Power Query and SQL. Experienced in building interactive dashboards, KPI reports, and MIS reports to support business decisions. Hands-on experience in Power BI Service including report publishing, scheduled refresh, and data validation. Strong ability to analyze data, identify trends, and provide actionable insights.

Skills & Expertise (25)

Power BI Intermediate

7.8/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Data Transformation Intermediate

6.0/10

Years Exp

DAX Beginner

5.5/10

Years Exp

Python Beginner

5.0/10

Years Exp

LOOKUP functions NumPy Pandas Aggregate Functions Window Functions CTE Joins Subqueries Queries Data Types Excel Functions Pivot Chart Pivot Table MS Excel Data Reporting ETL Power BI Services Dashboard Development Data Modelling Power Query

Work Experience

Data Analyst

Dhampur Bio Organics pvt. Limited

Jun 2025 - Present

Experience in data analysis, reporting, dashboard development, and business intelligence using Microsoft Power BI, SQL, and Microsoft Excel. Developed and maintained interactive dashboards and reports to monitor KPIs, including cane planting, audit activities, sales trends, and team performance. Built financial models and forecasting reports to predict future performance, support budgeting, and improve planning accuracy. Performed in-depth data analysis on financial statements, KPIs, and historical data to identify trends, variances, and growth opportunities. Provided strategic recommendations through data-driven insights to improve profitability, optimize operations, and reduce costs. Prepared comprehensive MIS reports, management dashboards, and presentations for senior leadership decision making. Optimized SQL queries for data extraction, transformation, and performance tuning on large datasets. Implemented drill-through functionality within dashboards, enabling granular analysis and reducing ad-hoc data requests by 25% monthly. Ensured 100% data validation and consistency before report deployment, minimizing reporting errors.

Data Analytics Intern

IBM

Jun 2024 - Aug 2024

Analyzed complex datasets using Power BI, MySQL, and MS Excel to extract actionable insights; findings contributed to resolving the three largest operational bottlenecks within a two-month project timeline. Developed data dashboards and reports using Power BI and Excel, improving stakeholder decision-making efficiency by 15%. Conducted statistical analysis and delivered actionable insights, contributing to a 20% improvement in project outcomes.