Back to Developers
MM

Milan Mahaliya

Rajkot, Gujarat, India 60 · Good

About

Final-year B.Com student with self-directed learning in SQL, Excel, and Power BI, building end-to-end analytics projects across e-commerce, telecom, and mobile app domains. Comfortable going from raw, messy data to a business recommendation. Looking to bring that same structured thinking to client-facing analytical work.

Skills & Expertise (26)

Power BI Advanced
8.7/10
4
Years Exp
SQL Advanced
8.4/10
4
Years Exp
DAX measures Advanced
8.0/10
3
Years Exp
Data Validation KPI Design Root-cause analysis Trend Identification EDA Drill-through Calculated Columns Slicers KPI Cards Conditional Formatting Dashboards XLOOKUP VLOOKUP Pivot Tables Excel Window Functions Subqueries CTEs Aggregations GROUP BY Joins SSMS Microsoft SQL Server

Work Experience

Analyst

Telecom Customer Churn Analysis

Present - Present

Analyzed 7,043 customer records; calculated 28.4% overall churn and segmented by contract type, tenure, internet service, and payment method. Identified month-to-month contracts (51.6% churn) and new customers 0–6 months (77% churn) as the two highest-risk segments. Built a four-page Power BI dashboard (Overview → What Is Happening → Why → What To Do) with drill-through and custom tooltip pages. Recommended contract conversion campaigns and a 90-day onboarding program targeting the segments responsible for the largest share of lost revenue.

Analyst

E-Commerce Returns & Revenue Risk Analysis

Present - Present

Analyzed 346 orders with a 48% return rate, quantifying Rs. 3.75L in at-risk revenue from returns and COD defaults. Cleaned the dataset (64 corrections logged) and built pivot-based dashboards tracking return rates by category, channel, and payment method. Traced top return drivers to size issues (37%) and quality defects (18%); identified Instagram as a high-return acquisition channel feeding into product and channel recommendations.

Analyst

Mobile App User Behaviour Analysis

Present - Present

Processed 10,000+ user records; wrote SQL queries (joins, GROUP BY, aggregations) to analyze engagement patterns across platform, visit frequency, and download behavior. Segmented 5,699 active users into high- and low-engagement cohorts; identified Google Play as the dominant platform and flagged an Android-first retention opportunity. Built a Power BI dashboard tracking active users, session frequency, and download trends.

Data Analytics Job Simulation

Deloitte Australia (Forage)

Present - Present

Completed consulting-oriented tasks covering data preparation, dashboard-based analysis, and business recommendation delivery.

Education

Bachelor of Commerce (B.Com) - Saurashtra University

- 2026 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 0/10
📄 Resume 10/10
💼 Job Title 0/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 60/100

Profile Overview

Member sinceMay 2026

Availability Details

Relocation

Open to Relocation