Traffic Challan Analytics & Compliance

Traffic Challan Analytics & Compliance Reporting Dashboard Overview

Worked as a Business Analyst on the design and implementation of a compliance reporting dashboard that provided state-wise visibility into challan activity, pending liabilities, disposed cases, and financial exposure.

The objective was to help operations and management teams monitor compliance performance, identify high-risk regions, and make data-driven decisions.

My Role

As the Business Analyst, I gathered reporting requirements from stakeholders, defined business metrics, collaborated with data teams on SQL-based reporting, and validated dashboard outputs to ensure reporting accuracy.

Key Responsibilities

✅ Business Requirement Gathering

✅ KPI Definition & Metric Design

✅ Reporting Requirement Documentation

✅ Dashboard Planning & Validation

✅ SQL Query Review & Data Verification

✅ Stakeholder Management

✅ UAT & Report Testing

Key Metrics Tracked

State-wise Challan Count

Pending Challans

Disposed Challans

Total Challan Amount

Pending Liability Amount

Disposed Amount Analysis

Regional Performance Insights

Deliverables

Business Requirement Documents (BRD)

Dashboard Specifications

KPI Definitions

SQL-Based Reporting Requirements

UAT Test Cases

Data Validation Documentation

Tools Used

SQL • Redash • Jira • Agile • Business Analysis • Data Reporting • UAT