Mushtaque Ahmad

Mushtaque Ahmad

Data Analyst
UAE
English, Hindi
Full-time On-site

About Me

Data Analyst and MIS Reporting professional with 3+ years of experience turning raw business data into accurate insights and professional management reports across Fintech and Telecom. Hands-on with Power BI, Advanced Ex…

Experience

Data Analyst

Paytm · Noida
Sep 2024 - Sep 2026 · 1 year 11 months

<p>Prepared daily, weekly and monthly MIS reports and management summaries from business team data to track performance.</p><p> Built interactive Power BI and Looker Studio dashboards for multiple KPIs, cutting weekly reporting time from 8 hours to under 2 hours.</p><p> Automated routine reporting with Python and Google Apps Script, reducing manual effort by 40%.</p><p> Reconciled data and checked it for errors to keep reports accurate and reliable.</p><p> Consolidated data from multiple teams and worked with Finance, Operations and Product to share clear insights.</p>

MIS Executive

Bharti Airtel · Gurgaon
Aug 2023 - Sep 2024 · 1 year

<p>Analysed inventory and supply-chain performance using ERP systems and Advanced Excel.</p><p> Built MIS dashboards and ageing reports, reducing stock discrepancy escalations by 25%.</p><p> Automated recurring MIS reports with VBA and Excel macros, saving about 6 hours per week.</p>

Junior Data Analyst (Intern)

NWCC LLP · Gurgaon
Feb 2023 - Aug 2023 · 6 months

<p>Extracted and analysed transactional datasets using SQL and ERP systems.</p><p> Prepared monthly KPI reports and standardised reporting templates, reducing preparation time by 30%.</p><p> Maintained 98%+ data accuracy through systematic validation and cleansing.</p>

PROJECTS

Retail Sales Analytics Dashboard

Personal · https://github.com/M94-ctrl/Retail-Sales-Analytics-Dashboard
Duration : 24-Sep-2026 - 28-Oct-2026

<p>A 6-page interactive Power BI dashboard for a multi-store retail business: sales and profit performance, customer value (Pareto / top-20% analysis), product and region mix, and time-based trends (YoY, MoM, YTD, rolling 3-month).</p><p>Tools: Power BI · DAX · Power Query (M) · Data modelling · Python (validation script)</p><p></p><p></p>

Dubai Logistics MIS Dashboard

Personal · https://github.com/M94-ctrl/Dubai-Logistics-MIS-Dashboard
Duration : 13-Sep-2026 - 20-Oct-2026

<p>An end-to-end logistics analytics project: raw shipment data → SQL Server cleaning → star-schema model → 4-page interactive Power BI dashboard tracking delivery performance, SLA compliance, cost and courier efficiency across the UAE.</p><p>Tools: Excel · SQL Server (T-SQL) · Power BI (DAX) · Data modelling.</p><p></p><p></p>

Certifications

Data Analyst bootcamps

udemy · East Delhi , Delhi , India · 2026

Skills

ChatGPT Claude Microsoft Copilot Power BI DAX Power Query Looker Studio Data Visualisation Advanced Excel Pivot Tables XLOOKUP VLOOKUP Aggregate Functions Macros SQL Server Joins Window Functions Python Pandas Data Cleaning Report Automation ETL Google Apps Script ERP Systems MIS Reporting Financial Reporting KPI Tracking Trend Analysis EDA Reconciliation Data Validation Data Cleansing Process Improvement
Report this Profile?