Feb 2023 – Present · 3 yrs 4 mos

• Prepare MIS reports using MS Excel for operational-level decision-making. Create Excel dashboards and present reports to the concerned departments. Collect, clean, store, and reproduce data in required formats for management. Develop and maintain monthly reports for Stack and Incentives. Monitor and maintain quality metrics on a daily, weekly, and monthly basis. Proficient in XLOOKUP, VLOOKUP, HLOOKUP, advanced filtering, conditional-formatting, and data validation. Utilize Pivot Tables and lookup formulas for effective report generation. Perform formula evaluation, error checking, and trace cell relationships (dependents/precedents). Secure spreadsheets through sheet, cell, and workbook protection. Extract and maintain daily reports in Excel. Provide support and maintenance to existing Management information systems (MIS). Provide support and maintenance for existing MIS systems. Generate and distribute accurate and timely reports to management. Document MIS processes to ensure smooth operations. Analyze data and prepare periodic reports. Support organizational goals through strategic data-driven planning. Participate in cross-functional meetings to address and resolve recurring issues. Google Sheets Skills: Data validation and conditional formatting. Creating and managing Pivot Tables. Using ARRAYFORMULA, IMPORTRANGE, QUERY, COUNTUNIQUEIFS, and FILTER functions. Collaborative editing and commenting. Building dynamic dashboards.