MIS Executive - Logistics CPG
The role requires strong Advanced Excel/Google Sheets skills, data accuracy, reporting
discipline, and an understanding of logistics operations such as dispatch, delivery, POD,
TAT, OTIF, RTO.
Key Responsibilities
- Logistics MIS & Reporting
Prepare daily, weekly and monthly logistics MIS reports.
Maintain shipment-level databases covering dispatch, delivery, POD, RTO and
pending shipments.
Generate city-wise, customer-wise, transporter-wise and warehouse-wise
performance reports.
Track shipment status and identify delayed/pending deliveries.
Prepare management dashboards and operational scorecards.
- Logistics Performance Tracking
Monitor Key KPIs Such As
- OTIF – On Time In Full
- Delivery TAT
- Pending/Undelivered shipments
- RTO update
- POD compliance
- Transporter SLA performance
Highlight exceptions and coordinate with operations teams for closure.
- Freight & Cost Analysis
Prepare transporter billing and freight reconciliation.
Validate freight invoices against agreed rates, shipment weight, distance and service
type.
Identify billing discrepancies, excess freight, weight discrepancies and cost
leakages.
Prepare cost-per-kg, cost-per-box, cost-per-order and freight-to-sales analysis.
- Data Management
Maintain Accurate Master Data For
- Pincode
- Customer
- Transporter
- Rate cards
- TAT
- Vehicle
- Route
Ensure timely data updates and data integrity.
Consolidate data received from multiple logistics partners.
- Transporter Coordination
Collect daily/weekly performance data from logistics partners.
Follow up for pending PODs, delivery status, RTO cases and exception shipments.
Prepare transporter performance scorecards.
Support monthly transporter review meetings.
- Automation & Process Improvement
Automate repetitive MIS activities using Excel formulas, Pivot Tables, Power
Query, Google Sheets and basic VBA/Apps Script.
Develop dashboards to reduce manual reporting.
Identify opportunities to improve data accuracy and reporting TAT.
Required Skills
Technical Skills
Advanced MS Excel
Pivot Tables & Charts
VLOOKUP/XLOOKUP
INDEX-MATCH
SUMIFS/COUNTIFS
IF/IFS & logical formulas
Conditional Formatting
Power Query – preferred
Google Sheets – preferred
Basic VBA / Apps Script – added advantage
Power BI – added advantage
Logistics Knowledge
B2B logistics operations
3PL management
POD management
RTO management
TAT & SLA monitoring
Freight billing and reconciliation
Vehicle utilization
Shipment tracking
Key Competencies
Strong analytical and problem-solving skills
High attention to detail
Good numerical ability
Strong follow-up and coordination skills
Ability to work with large datasets
Ability to identify trends and exceptions
Good communication skills
Ability to work under tight reporting timelines
Preferred Candidate Profile
Candidate should have experience in a logistics, courier, e-commerce, FMCG, retail or
supply-chain environment, preferably handling high-volume shipment data and multiple
logistics partners.