Role & responsibilities

- DATE Sheet: Maintain daily data sheets, update records, track pending activities, and ensure data is entered correctly and on time.
- PMS Sheet (Performance Management System): Maintain employee or department performance data, track targets versus achievements, and prepare performance reports.
- FMS Sheet (Follow-up Management System): Track pending tasks, follow-ups, deadlines, responsible persons, and task completion status.
- IMS Sheet (Inventory Management System): Maintain stock records, material inward/outward entries, stock balances, spare parts inventory, and stock reconciliation.
- Prepare daily, weekly, and monthly MIS reports for management.
- Maintain Excel sheets using formulas, PivotTables, VLOOKUP/XLOOKUP, conditional formatting, and dashboards.
- Coordinate with sales, purchase, stores, production, service, and accounts departments to collect and verify data.
- Monitor pending activities and send reminders to the concerned departments.
- Ensure all sheets are updated regularly and reports are shared within deadlines.
- Identify data discrepancies and maintain proper records for management review.

Preferred candidate profile

- Education: Graduate in any stream; B.Com, BBA, BCA, or equivalent qualification preferred.
- Experience:



13 years of experience in MIS reporting, preferably in the automotive, automobile dealership, manufacturing, or auto components industry.
- Technical Skills: Solid knowledge of MS Excel, including VLOOKUP/XLOOKUP, PivotTables, IF, SUMIFS, COUNTIFS, data validation, and conditional formatting.
- MIS Reporting: Hands-on experience in preparing and maintaining daily, weekly, and monthly MIS reports.
- Sheet Management: Experience maintaining and updating DATE, PMS, FMS, and IMS sheets, including data entry, tracking, follow-ups, and reporting.
- Data Management: Ability to collect, verify, analyze, and consolidate data from multiple departments.
- Coordination Skills: Ability to coordinate with sales, purchase, inventory, production, service, and accounts teams.
- Analytical Skills: Good attention to detail, data accuracy, problem-solving, and reporting skills.
- Communication Skills: Good verbal and written communication skills with the ability to follow up with different departments.
- Personal Attributes: Organized, detail-oriented, proactive, responsible, and capable of meeting reporting deadlines.

Perks and benefits

📌 MIS Executive (Bahadurgarh)
🏢 Pawan Chhabra
📍 Bahadurgarh