Client: Digital Fleet is a GPS asset tracking and fleet telematics company offering real-time fleet tracking solutions with customizable workflows and integration with operational systems particularly made for the construction materials and ready-mix concrete industries.

Challenge: Since Digital Fleet works in Telematics domain, they have to deal with large amounts of data. Effective management of the rapid increase in data volume was being considered as a challenge to the client. The reporting module required more flexibility and efficiency. To make this upgrade possible, it was important to keep the data storage for reporting module separate from the production module. SSI pooled resources with Digital Fleet to build a product for the better management of the increasing data volume using SQL server. It was advised to use MongoDB in sync with SQL Server in real time because the reporting majorly consisted of near real-time tracking of construction vehicles on maps. 

Solution: SSI implemented its own developed analytics framework that enables well-organized reporting, rich data visualization, and customizable dashboard layouts. It has three main features:

  • Query Builder: A rich UI to design complex drag and drop structures and creates text queries on run time.
  • Report Builder: Creates multi-section reports based on the queries designed in Query Builder.
  • Dashboard Builder: A widget based data visualization tool to build a customized dashboard layout of user’s choice.

A message broker service was introduced to transfer the data persisted in MongoDB to MS SQL Server for real time data synchronization between MongoDB and MS SQL Server.  A wrapper module on top of RabbitMQ was also created to manage the speed of data transfer and to maintain the telematics data in a sequential order.

Result: The application helped improve the user experience for their end clients and improved operational efficiency for Digital Fleet as a more scalable platform.

Technology:

Similar Studies

  • Thomson Reuters /Quantitative Analytics

    A financial data predictive analytics software for quantitative researchers, portfolio managers and technical analysts for a global financial firm

    • Financial
    • .NET
    • Advanced Analytics
    • SAAS
    • Desktop
  • SnapFlow

    A robust Workflow Management system that transformed a purely paper based ordering system into a fully automated SaaS solution for a tech startup

    • Startup
    • .NET
    • Web
    • SAAS
  • Thomson Reuters

    An advanced data ingestion platform to handle massive multi-stream data feed to a powerful data warehouse of a global financial information and software company

    • Financial
    • Advanced Analytics
    • .NET
    • Desktop
    • SAAS
  • Lime Brokerage

    A high performance multi-asset class trading software designed for efficient implementation, testing, and deployment of algorithmic trading strategies for a leading financial services company

    • Financial
    • Advanced Analytics
    • .NET
    • Desktop
    • SAAS