Vaibhav Khot

Detail-oriented Data Analyst / MIS Analyst with over 5+ years of progressive experience in data analysis, MIS reporting, dashboard development, and business intelligence across fintech, operations, HR, sales, supply chain, and service-based organizations. Proven expertise in SQL, Tableau, Power BI, Advanced Excel, and data modeling, with strong capability to handle large datasets, design analytical constructs, define KPIs, and convert complex data into actionable insights for leadership and cross-functional teams.

Assistant Manager (MIS / Data Analytics) - Angel One - Pune, India

(2023-01)

• Managing MIS and analytics deliverables across multiple departments and business modules.
• Design and maintaining real-time dashboards to track operational and business KPIs for zonal and regional leadership.
• Working closely with business teams to define analytical requirements, KPIs, and performance metrics.
• Analyzing large datasets to identify trends, anomalies, and improvement opportunities.
• Preparing and presenting insights to senior stakeholders in a clear and structured manner.
• Salesforce id creation and mapping stakeholders
• Handling Mass communication for entire stakeholders.
• Handling multiple projects as per the requirements of business.
• Translate complex data into clear insights for zonal, regional, and senior leadership
• Support across multiple business teams and modules.

HR & Admin MIS Analyst (Contract) - Logicon Management Pvt. Ltd.

(2022-01 - 2023-12)

• Developed and optimized Power BI dashboards using advanced DAX calculations and structured data models.
• Prepared MIS reports for HR and operations including SLA, utilization, cost, aging, productivity, and serviceability metrics.
• Automated regular reports using Advanced Excel and Power Query to reduce manual intervention.
• Supported management with data for hiring, payroll processing, and administrative decision-making.

SCM Coordinator (MIS) - Samsung

(2021-01 - 2022-12)

• Created and distributed PAN-India sales, inventory, and warehouse stock MIS reports.
• Managed inventory planning, forecasting, stock aging, OBSOL, PSI, and shortage identification.
• Prepared sell-in, sell-out, and sell-through reports for sales and regional teams.
• Converted business requirements into MIS dashboards and analytical reports.
• Handling data from SAP MM mapping and team coordinate with team.

MIS Executive - Swiggy (Bundl Technologies Pvt. Ltd.)

(2019-01 - 2020-12)

• Provided MIS and analytical support to sales, operations, onboarding, and payroll teams.
• Designed and maintained dashboards using SQL, Power BI, and Excel.
• Prepared daily, weekly, and monthly reports on SLA, utilization, serviceability, and costs.
• Supported management presentations with operational analysis and insights.

Associate Team Member - SLK Global BPO Services Pvt. Ltd.

(2011-01 - 2012-12)

• Maintained SLA and TAT trackers for team assignments and shared performance metrics with management.
• Created Excel templates, trackers, and dashboards for operational reporting.

Computer Operator Intern - Bajaj Auto Ltd.

(2007-01 - 2008-12)

• Supported HR data management, onboarding, and administrative activities.
• Maintained records, reports, and internal documentation using MS Excel.

MBA & MA - Shivaji University, Kolhapur