- Prepare daily, weekly, and monthly MIS reports for management.
- Maintain and update operational data using MS Excel and Google Sheets.
- Use formulas such as VLOOKUP, XLOOKUP, IF, SUMIFS, COUNTIFS, and other relevant functions.
- Prepare dashboards, performance reports, and data summaries.
- Track vehicle utilization, driver performance, collections, outstanding balances, and operational metrics.
- Verify data accuracy, identify discrepancies, and correct errors.
- Consolidate data from multiple sources and maintain proper records.
- Monitor daily targets and share performance updates with the operations team.
- Coordinate with internal departments to collect and validate data.
- Complete assigned reports within deadlines and maintain data confidentiality.
Required Skills
- Good knowledge of MS Excel and Google Sheets.
- Knowledge of Excel formulas, pivot tables, sorting, filtering, and data validation.
- Strong analytical and numerical skills.
- Good attention to detail and accuracy.
- Ability to handle large datasets and prepare reports independently.
- Valuable communication and coordination skills.