Road Safety Improvement

Real-time telematics and analytical monitoring

Client: Transportation Company, USA

12 months

to MVP

Real-time

violation, route and weather alerts

incident rate and business risk

TypeScriptNode.jsPythonPostgreSQLRabbitMQAWSAmazon EC2AWS compute clusterAWS container servicesAmazon SQSAWS registryData centerAzure Kubernetes ServiceAzure Key VaultAzure DevOps servicesAzure Data Lake Storage Gen2Microsoft platformPower BICEPH S3-compatible storageTerraformPlaywrightSeleniumJasmineKarma
TypeScriptNode.jsPythonPostgreSQLRabbitMQAWSAmazon EC2AWS compute clusterAWS container servicesAmazon SQSAWS registryData centerAzure Kubernetes ServiceAzure Key VaultAzure DevOps servicesAzure Data Lake Storage Gen2Microsoft platformPower BICEPH S3-compatible storageTerraformPlaywrightSeleniumJasmineKarma

Challenge

Road incidents from poor conditions, route changes and policy violations put drivers, growth and reputation at risk. The data that could have explained them sat in silos — no real-time view, no history to optimize against.

Solution

An analytical platform over telematics and external data that detects violations, route issues and weather risk as they happen, and keeps the history for planning and optimization. Real-time alerts, dashboards and an approval flow for violations.

Implementation

  • 01Kappa architecture ingesting GPS, corporate rules and weather data
  • 02Lambda architecture with stream processing and Delta Lake for the real-time and historical layers
  • 03Web app for operators to work through violation alerts
  • 04APIs for device integration and real-time notifications
  • 05BI models and a data science toolkit for further analysis

Business impact

MVP delivered in 12 months

Lower incident rate and business risk

Improved driver safety and data-driven planning

Consolidated telemetry and supplemental data for future analytics

Technology stack

Data & Processing
  • Azure Databricks
  • Delta Lake
  • Azure Data Factory
  • Event Hub
Storage & Serving
  • SQL Azure
  • Synapse Serverless SQL
  • Redis
Cloud & DevOps
  • Azure Functions
  • App Services
  • Azure Monitor
  • Key Vault
  • Azure DevOps
  • Terraform
Analytics & BI
  • Power BI
  • Analysis Services

Have a complex system to build or modernize?

Tell us what must change. We will bring the relevant domain and engineering leads into the conversation.

Explore all case studies