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 current Google Sheets features and tools.

📌 Mis Executive Ludhiana
🏢 R.K. Transport
📍 Ludhiana