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

