Skip to main content
Payal Gondane

Payal Gondane

MIS Executive

Talent
PuneMember since July 1, 2026
Advanced ExcelPivot TablesVLOOKUPXLOOKUPHLOOKUPINDEX-MATCHChartsDashboardsMIS reportingERP applicationsPower BI
·

Hire this person

Send a job offer directly to this candidate

Advanced ExcelPivot TablesVLOOKUPXLOOKUPHLOOKUP

About

As a MIS Executive, I assist with data and reporting tasks for online, analytics, and software projects. Accountable for managing project data, keeping track of reports, and helping teams with daily performance updates. able to create dashboards and data summaries using Excel and Power BI to assist management in making decisions

Experience

MIS Executive at UAS IT consultancy services Pvt ltd (2024-10 – 2026-05)

  • Led the end-to-end MIS reporting process, including dashboard development, data consolidation, and performance tracking using Advanced Excel.
  • Automated multiple recurring reports using Excel Macros, reducing manual work and report generation time by 30%.
  • Prepared and maintained MIS reports and dashboards using Advanced Excel for business reporting and performance tracking.
  • Worked extensively with Excel formulas such as VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, IF, and logical functions to retrieve, validate, consolidate large datasets.
  • Used Pivot Tables and Pivot Charts to analyze large volumes of data, generate summaries, track KPIs, and support management decision-making.
  • Worked on ERP applications for data extraction, updating records, report generation, and maintaining operational data accuracy.

Education

Master in Computer Management – Prerna Collage Nagpur (2020)

Skills

MIS Executive

Reviews

Related