Back to Developers
Madhan Kumar

Madhan Kumar

Data Analyst

Namakkal, Tamil Nadu 80 ยท Excellent

About

Detail-oriented Data Analyst with hands-on experience in SQL, Python, Excel, Power BI, Tableau, and MySQL for data analysis, business intelligence, and visualization. Skilled in data cleaning, preprocessing, exploratory data analysis (EDA), KPI reporting, dashboard development, statistical analysis, and business reporting. Experienced in transforming raw datasets into actionable insights through SQL queries, Python automation, and interactive Power BI dashboards.

Skills & Expertise (38)

Power BI Advanced
8.5/10
5
Years Exp
SQL Advanced
8.4/10
5
Years Exp
Excel Advanced
8.0/10
5
Years Exp
Data Cleaning Advanced
8.0/10
5
Years Exp
Python Intermediate
7.5/10
3
Years Exp
Exploratory data analysis Intermediate
7.5/10
4
Years Exp
DAX Intermediate
7.0/10
3
Years Exp
Statistical Analysis Intermediate
6.5/10
3
Years Exp
Tableau Intermediate
6.5/10
3
Years Exp
Git Intermediate
5.5/10
2
Years Exp
Jupyter Notebook Data Transformation VS Code Data Validation Dashboard Creation Conditional Formatting SUMIFS Index-match XLOOKUP VLOOKUP Pivot Charts Pivot Tables Seaborn Matplotlib NumPy Pandas Subqueries HAVING GROUP BY Aggregate Functions Window Functions CTEs Joins Business Reporting Dashboard Development KPI Reporting Preprocessing MySql

Work Experience

Data Analyst

Zomato

Present - Present

Cleaned and analyzed Zomato restaurant data using SQL to uncover trends in ratings, cuisines, pricing, and customer preferences. Developed optimized SQL queries using Joins, CTEs, Window Functions, Aggregate Functions, GROUP BY, HAVING, and Subqueries for business insights. Built an interactive Power BI dashboard with KPI cards, DAX measures, slicers, and drill-through reports to analyze restaurant performance, online delivery, and city-wise trends.

Data Analyst

Adventure Works

Present - Present

Cleaned and transformed Adventure Works finance and sales data using SQL for accurate reporting and analysis. Performed financial analysis on revenue, profit margin, budget variance, customer sales, and regional performance using advanced SQL queries. Developed a 5-page interactive Power BI dashboard with 20+ DAX measures, drill-through navigation, decomposition tree, maps, and ribbon charts to identify sales opportunities and top-performing products.

Education

Bachelor of Engineering (Computer Science and Engineering) - Paavai College of Engineering

2022 - 2026 ยท 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 5/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 80/100

Profile Overview

Member sinceOct 2026