Key Responsibilities

- Prepare and maintain daily, weekly, and monthly MIS reports, trackers, and dashboards.
- Manage and consolidate data from multiple departments and Google Sheets/Excel files.
- Use advanced Google Sheets formulas such as VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, ARRAYFORMULA, FILTER, QUERY, and IMPORTRANGE.
- Create agile dashboards, reports, dropdowns, validations, and automated trackers.
- Identify data errors, duplicates, inconsistencies, and troubleshoot formula-related issues.
- Automate repetitive reporting tasks using Google Apps Script where required.
- Support migration of Excel-based reports and processes to Google Sheets.
- Coordinate with departments to collect data and ensure timely and accurate reporting.
- Identify inefficient processes and suggest improvements and automation.
- Train/support team members in Google Sheets and reporting practices.
- Stay updated with new Google Sheets features and tools.

📌 MIS Executive (Ludhiana)
🏢 R.K. Transport
📍 Ludhiana