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

Solid 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 - Logistics CPG (Mumbai)
🏢 Purplle.com
📍 Mumbai