The role requires robust 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 oppo

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