Freelancers using RedashFreelancers using Redash
Projects
People
Cover image for 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
0
11
Cover image for Led the business analysis and
Led the business analysis and requirement definition for a logistics operations enhancement project focused on compliance, reporting, and operational efficiency. Key Contributions ✅ Defined requirements for E-Challan and Court Challan management workflows ✅ Improved reporting capabilities by introducing enhanced Redash dashboards with vehicle-level and challan-level visibility ✅ Collaborated with stakeholders to design driver allocation validation rules, preventing assignment of drivers with expired or soon-to-expire licenses ✅ Gathered and documented requirements for reimbursement tracking enhancements, including dummy amount and comment fields for reporting purposes ✅ Worked closely with product, engineering, and operations teams during UAT to refine business rules and improve user experience Deliverables Business Requirement Documentation (BRD) User Stories & Acceptance Criteria Process Flow Analysis UAT Support & Validation Stakeholder Coordination Reporting & Dashboard Requirements Tools Jira • SQL • Redash • Agile • UAT • Business Analysis Outcome The enhancements improved compliance visibility, reduced operational risks related to driver allocation, and provided more accurate reporting for operations teams.
0
21