Rabari Gokul

MIS Analyst

Mehsana, Gujarat 4+ yrs exp 92 · Outstanding

About

3× award-winning MIS professional at Vodafone Idea with a proven record of building automated reporting systems, zero-error payout audit frameworks, and real-time KPI dashboards for a 500+ agent national sales network. Delivered 35% faster stakeholder reporting, 18% regional sales uplift, and 100% audit compliance across 24 consecutive months. Core strengths in VBA automation, Advanced Excel, and MIS reporting; actively developing SQL and Power BI skills to deepen analytical capability.

Skills & Expertise (13)

Advanced Excel Advanced

8.0/10

Years Exp

VBA Macros Advanced

8.0/10

Years Exp

Pivot Tables Advanced

8.0/10

Years Exp

MIS Automation Advanced

8.0/10

Years Exp

Dashboard Development Advanced

8.0/10

Years Exp

Power Query Intermediate

7.5/10

Years Exp

KPI Tracking Intermediate

7.5/10

Years Exp

Stakeholder Reporting Intermediate

7.5/10

Years Exp

Root Cause Analysis Intermediate

7.0/10

Years Exp

Trend Analysis Intermediate

7.0/10

Years Exp

Data Reconciliation Intermediate

7.0/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Work Experience

MIS Executive

Vodafone Idea Pvt. Limited

Mar 2023 - Present

Reduced stakeholder reporting turnaround by 35% by designing VBA macro-driven Daily/Weekly/Monthly MIS dashboards in Excel, eliminating manual data consolidation across a 500+ field-agent sales network. Maintained 100% payout audit compliance for 24 consecutive months — zero errors via a multi-layer data validation framework cross-checking CRM records against Finance disbursement entries before every payout cycle. Improved regional target achievement by 18% by delivering hourly real-time MIS updates and trend analysis dashboards during BIG Day campaigns; recognised with Best Performance Award, January 2026. Cut reporting lag by 2 days for 4 regional sales managers by replacing manual spreadsheet decks with automated Excel dashboards consolidating live target vs. achievement data and root cause flags. Reduced payout query resolution time by 40% by standardising Finance-MIS coordination through pivot-table reconciliation models, eliminating back-and-forth over discrepancies.

Warehouse Officer

Sotac Pharmaceutical Company

May 2021 - Apr 2022

Reduced stock discrepancy rate by 20% by introducing a structured inward/outward Excel tracking log, verified through monthly physical reconciliation audits. Decreased dispatch documentation errors by 30% by standardising warehouse templates and training 3 staff members, tracked via weekly QC checks.