Back to Developers
Musthak Ali

Musthak Ali

Data Analyst

Chennai, India 0+ yrs exp 87 · Excellent

About

Results-driven Data Analyst with proven experience transforming complex, multi-source operational data into actionable business insights using Power BI, Advanced Excel and SQL. Skilled in designing automated dashboards, ETL style data pipelines and centralized master datasets that consolidate multi-source data into a single source of truth, Adept at replacing manual, error-prone reporting processes with scalable, automated solutions that improve data accuracy, turnaround time, and decision-making speed. Strong track record of collaborating with senior leadership to translate raw data into clear, actionable insights that drive operational performance.

Skills & Expertise (31)

Advanced Excel Advanced
8.5/10
1
Years Exp
Power BI Intermediate
8.2/10
1
Years Exp
Dashboard Development Intermediate
8.0/10
1
Years Exp
Data Visualization Intermediate
8.0/10
1
Years Exp
SQL Intermediate
7.5/10
1
Years Exp
Data Cleaning & Validation Intermediate
7.5/10
1
Years Exp
Python Intermediate
7.0/10
1
Years Exp
VBA automation Intermediate
7.0/10
1
Years Exp
Trend Analysis Intermediate
7.0/10
1
Years Exp
Root Cause Analysis Intermediate
7.0/10
1
Years Exp
Business Performance Analysis Intermediate
7.0/10
1
Years Exp
Data Integration Intermediate
7.0/10
1
Years Exp
Matplotlib process automation Seaborn Master Data Management ETL Concepts Stakeholder Management Cross-Functional Collaboration Problem Solving Process Improvement NumPy Pandas Budgeting & Forecasting Operational Analytics Data Modeling Advanced Formulas Pivot Tables Power Query Executive Reporting KPI Reporting

Work Experience

Data Analyst

Gleneagles Hospital

Dec 2025 - Present

Managed end-to-end MIS reporting across multiple business functions, consolidating data from several source systems into unified, standardized reporting structures. Built and maintained automated Power BI and Excel dashboards delivering daily, weekly, monthly, and YTD business insights to senior leadership — significantly reducing manual reporting effort and turnaround time. Designed and maintained centralized master datasets integrating operational, transactional, and revenue data across multiple departments to support a single source of truth for reporting. Created dynamic monthly, trailing, YTD, and Previous-YTD reporting templates with self-updating summary calculations, eliminating repetitive manual rework. Developed VBA macros and automation scripts to parse unstructured/free-text data into structured, query-ready datasets, enabling deeper downstream BI analysis. Performed detailed trend, root-cause, and consumption/utilization analysis across business categories to flag high cost or high-impact patterns for management review. Conducted time-slot and demand-pattern analysis to support capacity, staffing, and resource planning decisions. Supported system implementation by validating and migrating master data (vendor, customer, and transactional records) validation checks, ensuring data integrity across systems. Performed data validation, reconciliation, and anomaly detection on financial transaction records prior to migration, using rule-based and pattern-matching techniques. Led data-driven analysis of high-disposal medical consumables using Advanced Excel, Power Query, and Power BI, transforming complex data into actionable insights for executive leadership. Enabled targeted process improvements that reduced high-value consumable disposal by over 50% within one month, driving significant cost savings and improved inventory efficiency. Built a rolling 5-month operational forecast and full-year budget model using six months of historical revenue and expense trend data, consolidating department-wise P&L analysis into a single, large-scale organizational budget spanning a nine-figure value.

Intern

Touch Solar Technologies

Jun 2024 - Jul 2024

Conducted Pareto analysis and trend forecasting to identify key revenue contributors. Identified seasonal demand patterns to guide sales and production teams. Performed price sensitivity and discount strategy analysis to optimize revenue. Presented insights to internal stakeholders to support business planning.

Education

Master of Business Administration in Data Analytics - Pondicherry University

2023 - 2025 · Afghanistan

Bachelor of Commerce (B.COM) - General - St. Joseph’s College of Arts and Science

2020 - 2023 · Afghanistan

Certifications

Certification Program in Banking & Finance - Operations & Sales

· 2026

Career Essentials in Data Analytics

Microsoft and Linkedin · 2025

Introduction to Data Analytics

· 2025

Business Analytics with Excel

· 2025

SQL, Advanced Excel, Python, Power Bi

Besant Technologies · 2024

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 7/15
💰 Rate 0/5
🏆 Certs 5/5
✅ Verified 5/5
Total Score 87/100

Profile Overview

Member sinceOct 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation