Allarakha Khan

Senior MIS & Reporting

Mumbai, Maharashtra 11+ yrs exp 78 · Very Good

About

MIS and Reporting professional with 10+ years of experience supporting sales, inventory, supply chain and field operations. Leads recurring reporting for Head Office and regional teams. Skilled in Power BI, Power Query, DAX, Python, Excel VBA, ETL, data modelling, SAP ERP and basic SQL. Experienced in dashboard development, KPI tracking, data validation, reconciliation and reporting automation.

Skills & Expertise (13)

Power BI Advanced

8.5/10

Years Exp

Power Query Advanced

8.0/10

Years Exp

Advanced Excel Advanced

8.0/10

Years Exp

DAX Advanced

7.5/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Excel VBA Intermediate

7.0/10

Years Exp

ETL Intermediate

7.0/10

Years Exp

Data Modelling Intermediate

7.0/10

Years Exp

Power Pivot Intermediate

7.0/10

Years Exp

Data Visualization Intermediate

7.0/10

Years Exp

Sap Erp Intermediate

6.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Product Lifecycle Intermediate

6.0/10

Years Exp

Work Experience

Senior Business Intelligence Executive

Joinmay Mumbai Electronics Pvt. Ltd. (JMEPL)

Jul 2022 - Present

Manage an average of 10 recurring MIS reports across 8 zones for Head Office and market teams, covering sales, inventory, supply chain and field operations. Deliver daily, weekly and monthly reporting across Primary, Secondary, Activation, Dispatch, Stock and WOD, with product, zone, distributor, sales-team and outlet-level views. Build Power BI dashboards and Power Query/ETL workflows that consolidate multi-source sales, inventory, product lifecycle and KPI data into refreshable reporting datasets. Develop Python and Excel VBA automations, using AI assistance during development, to reduce manual data pasting and updates and speed recurring report preparation. Prepare monthly closure and management reviews covering Product Life Cycle (PLC), market share, product and series trends, Target vs Achievement and KPI scorecards. Develop new product launch, pre-activation and pre-booking reports covering penetration, demo allocation, conversion and ageing; built an IMEI-level tracker to measure activation-to-sale turnaround. Reconcile Stock, Primary, Secondary and Activation data; report field visits and outlet coverage to support follow-up.

Senior Executive (MIS)

Randstad India Ltd. (deputed to CRISIL Ratings Ltd.)

Feb 2022 - Jun 2022

Managed data auditing and ETL for credit-rating MIS portfolios, following established data-quality requirements. Created market-share intelligence matrices benchmarking CRISIL against external rating agencies for senior management. Improved portfolio allocation tracking with automated Excel audit templates, reducing manual review effort.

MIS Officer & Team Lead

Teleperformance DIBS

Aug 2015 - Feb 2022

Led a 5-member MIS reporting team supporting corporate accounts including Asian Paints, UltraTech and Canara HSBC Insurance. Developed Excel and SAP dashboards for agent productivity, shrinkage, utilization and operational KPIs. Managed SAP ERP data extraction, transformation and bulk uploads, processing thousands of records per cycle. Prepared executive Monthly Business Review (MBR) decks and appraisal scorecards across organizational levels.