The role requires solid 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.

📌 MIS Executive (Mumbai)
🏢 Purplle.com
📍 Mumbai