Back to Developers
Kalai Arasan

Kalai Arasan

Data Analyst

Salem, Tamil Nadu
80
Profile Score

About

Detail-oriented Business Data Analyst with a strong foundation in data analysis, visualization, and business intelligence. Proficient in Excel, MySQL, Power BI, Python, and Tableau, with hands-on experience building interactive dashboards and analyzing complex business datasets. Completed end-to-end analytics projects spanning E-Commerce, Healthcare, and HR domains — translating raw data into actionable insights that drive strategic decisions. Passionate about leveraging data to improve business performance and enable data-driven growth.

Skills & Expertise (39)

Power BI Expert
9.1/10
7
Years Exp
Data Analysis Expert
8.8/10
7
Years Exp
Data Visualization Expert
8.5/10
7
Years Exp
Python Advanced
7.9/10
5
Years Exp
MySql Advanced
7.5/10
5
Years Exp
Statistical Analysis Interactive Dashboard Development Pandas NumPy Seaborn Matplotlib EDA Power Query Tableau Interactive Dashboards Calculated Fields Filters Visual Storytelling BI & Reporting Communication Data Storytelling Presentation Skills Charts Data Cleaning KPI Tracking Microsoft Excel Pivot Tables Advanced Formulas VLOOKUP Ifs TEXT DAX Conditional Formatting Joins Aggregations Subqueries Window Functions Reporting Data Modeling

Work Experience

Data Analyst

E-Commerce

Present - Present

Analyzed multi-region e-commerce sales data to identify revenue gaps, underperforming product categories, and seasonal demand trends that impacted overall profitability. Built an end-to-end Power BI dashboard by integrating cleaned Excel data with MySQL-backed product and order tables; applied DAX measures to compute dynamic KPIs including revenue, profit margin, and return rate. Identified top 3 underperforming regions contributing to 35% of losses, enabling targeted corrective strategies; dashboard reduced ad-hoc reporting time by providing a self-service analytics layer.

Data Analyst

Healthcare

Present - Present

Hospital management needed visibility into patient admission trends, departmental load, and average length-of-stay to optimize resource allocation and reduce patient wait times. Designed an interactive Power BI dashboard consolidating patient admission records, departmental data, and discharge summaries; built time-intelligence DAX measures to track monthly and quarterly trends. Uncovered peak admission periods and overloaded departments, enabling data-backed staffing decisions; dashboard provided at-a-glance KPIs that reduced manual report generation from days to minutes.

Data Analyst

HR

Present - Present

HR leadership lacked a consolidated view of employee attrition, tenure distribution, and department-level headcount, making it difficult to proactively retain talent and plan workforce needs. Developed an HR analytics dashboard in Power BI using employee records from MySQL; applied segmentation by department, tenure band, age group, and gender to surface attrition drivers and diversity metrics. Pinpointed that employees with 1–2 years of tenure in the Sales department had a 40% higher attrition rate, prompting targeted retention initiatives; dashboard became a monthly HR review tool for leadership.

Data Analyst

Retail Business

Present - Present

A retail business needed to understand distinct customer buying behaviours to personalize marketing campaigns, improve customer retention, and optimize inventory for high-value segments. Applied K-Means clustering on retail transaction data using Scikit-learn after feature engineering RFM (Recency, Frequency, Monetary) metrics with Pandas; visualized cluster profiles using Seaborn and Matplotlib. Segmented customers into 4 actionable groups (Champions, Loyal, At-Risk, Lost Customers); insights enabled targeted re-engagement campaigns and helped prioritize inventory planning for the top 20% of customers driving 60% of revenue.

Education

Bachelor of Commerce (B.Com) - Periyar University

- 2025 · 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 sinceApr 2026