Key Responsibilities

·
Operational & Trip Reconciliation:

Oversee daily, weekly, and monthly trip reconciliation reports. Ensure scheduled trips, actual trips run, and kilometers tracked match perfectly with GPS/telematics data.

·
Billing & Cost Management:

Generate accurate, timely monthly billing reports for corporate clients. Track and audit vendor/driver payouts, fuel consumption, and AdBlue costs to identify variance and prevent revenue leakage.

·
Dashboard Development & Automation:

Design, maintain, and automate agile tracking sheets and dashboards (using advanced Excel/Google Sheets functions, power queries, or BI tools) to monitor key performance indicators (KPIs).

·
Compliance & Fleet Tracking:

Monitor fleet maintenance schedules, tracking uptime, and integrating data points (such as vehicle data, fuel mileage, and compliance metrics) into centralized reporting formats.

·
Data Integrity & Security:

Establish strict data validation protocols to ensure zero-error reporting. Manage access permissions for internal data sharing.

·
Ad-hoc Analysis:





Provide management with ad-hoc cost-benefit analyses, trend reporting (e.g., peak/off-peak utilization, route optimization data), and financial projections to support business scaling.



Required Skills & Qualifications

·
Experience:

5 to 10 years of core experience in MIS, data analytics, or operations billing (experience in logistics, employee transportation, car rentals, or fleet management industries is highly preferred).

·
Advanced Excel/Spreadsheet Mastery:

Expert-level knowledge of advanced formulas (Weighted Averages, Cumulative Sums, XLOOKUP, INDEX/MATCH), Pivot Tables, Power Query, and Dashboard design.

·
Tech-Savvy:

Familiarity with GPS tracking software, transport management systems (TMS), and integrating external government/logistics data (like vehicle/driver data) into internal systems is a major plus.

·
Analytical Thinking:

Exceptional ability to spot patterns, anomalies, and disc

📌 Senior Executive – MIS (Chennai Metropolitan Area)
🏢 Amaze Travels
📍 Chennai Metropolitan Area