MIS Executive

1. Job Purpose

To monitor daily warehouse operations through MIS reports, ensure that all operational processes are followed correctly, maintain accurate data and coordinate between warehouse teams, management, customers and other departments.

The candidate will be responsible for identifying operational gaps, tracking pending tasks, highlighting errors and ensuring timely completion of daily activities.

2. Key Responsibilities

A. MIS & Reporting

1. Collect daily operational data from all warehouse locations and departments.
2. Prepare Daily, Weekly and Monthly MIS reports.
3. Maintain reports for inward, outward, stock, inventory, manpower, attendance and vehicle movement.
4. Prepare stock reconciliation reports and identify physical vs. system stock differences.
5. Track warehouse productivity, order processing, dispatch and pending activities.
6. Prepare management dashboards using Excel, Google Sheets and Looker Studio.
7. Ensure all reports are accurate and submitted within deadlines.

B. Process Monitoring & Control

1. Monitor whether warehouse teams are following defined SOPs and processes.
2. Track the complete process from vehicle entry and inward to storage, picking and final dispatch.
3. Verify whether inward and outward documentation is properly maintained.
4. Monitor GRN, put-away, picking lists, loading sheets, invoices and gate passes.
5. Identify process gaps, delays, errors and repeated operational issues.
6. Ensure FIFO / FEFO and batch-wise inventory practices are followed.
7. Maintain an exception report for stock mismatches, short/excess quantities, wrong picking and dispatch errors.
8. Follow up with warehouse supervisors for corrective actions.

C. Coordination & Follow-up

1. Coordinate with Warehouse Managers, Supervisors, DEOs and other operational staff.
2. Follow up on daily pending tasks and ensure timely closure.
3. Coordinate with the accounts and billing teams for pending documentation and data.
4. Track customer complaints and ensure that issues are assigned to the concerned person.
5. Maintain a daily action tracker with responsibility and deadlines.
6. Escalate unresolved issues to management.

D. Process Improvement

1. Identify unnecessary manual work and suggest process improvements.
2. Develop standard reporting formats and automated Excel / Google Sheets trackers.
3. Improve coordination between different warehouse locations.
4. Monitor employee and departmental performance through measurable reports.
5. Ensure proper implementation of management instructions and SOPs.

3. Skills Required

• Advanced MS Excel and Google Sheets.
• MIS reporting and dashboard preparation.
• Knowledge of ERP / WMS software.
• Good understanding of warehouse and inventory operations.
• Strong follow-up and coordination skills.
• Ability to identify mistakes and analyse data.
• Good communication and problem-solving skills.
• Ability to work independently and meet deadlines.

4. Daily Deliverables

1. Daily Inward & Outward Report.
2. Stock Movement and Inventory Report.
3. Pending GRN / Put-away / Picking Report.
4. Dispatch and Vehicle Movement Report.
5. Attendance and Manpower Report.
6. Stock Discrepancy and Exception Report.
7. Customer Complaint and Pending Issue Tracker.
8. Daily Operations Summary to Management.

.