Chandan Variya
Portfolio

"I have created a project based on Power BI, Tableau, Python, MySQL, and Microsoft Excel.
Please email suggestions to variyachandan223@gmail.com".

Professional
Experience

Central MIS Executive | MIS Lead | Data Analyst
4+ years of experience in MIS Reporting, Business Intelligence & Process Automation

270+ Reports / Year
90% Automation Rate
300+ Employees Managed
20+ Stakeholders
5 Departments

Tools & Technologies

Power BI Advanced Excel Power Query VBA Macros Power Automate MIS Reporting Dashboard Development Data Analysis Process Automation Tableau MySQL Python Microsoft 365 SharePoint HTML / CSS

Guhilot Enterprise Pvt. Ltd.

Central MIS Executive
MAY 2025 – PRESENT  |  Ahmedabad & Pune, India
  • Promoted from department MIS role to Central MIS — company-wide responsibility across 5 departments
  • Delivered 251+ reports (2025–26) across Client + Operations: 72% within 1 day | 85% within 2 days
  • Managed MIS operations for 300+ employees, supporting 20+ stakeholders (TLs, Managers, HOD)
  • Automated 90% of Excel trackers into live Power BI dashboards
  • Built role-based dashboards for TL, Manager, and HOD levels — from individual KPIs to company-wide view
  • Standardized reporting frameworks across all departments
  • Conducted Advanced Excel training for Team Leaders
  • Handled incentive calculations, weekend/comp-off tracking, and HR reporting support

Guhilot Enterprise Pvt. Ltd.

MIS Executive & Data Analyst
JUN 2024 – APR 2025  |  Ahmedabad, India
  • Managed RAS department reporting — daily, weekly, and monthly MIS
  • Built automation systems using Excel, Power BI & VBA Macros
  • Developed error tracking & performance monitoring systems
  • Improved reporting efficiency and significantly reduced manual effort
  • Reduced MIS turnaround time from ~1 week to 24 hours

Tata Motors – Shreeji Automart Pvt. Ltd.

Team Leader & Customer Advisor
AUG 2022 – SEP 2023
  • Maintained team data, records and performance tracking
  • Monitored individual and team performance against targets
  • Analysed market trends and customer feedback

Maruti Suzuki NEXA – Kiran Motors  |  Gruham Developers

Relationship Manager & Business Development Manager
APR 2021 – AUG 2022
  • Lead generation, cold calling and client relationship management
  • Digital marketing and online outreach