—–

CASE STUDY

Telematics Solutions Application Management & Support Service

Domain: Financial
Client Location: UK

—–

Background

Telematics Solutions is dedicated to helping the customers to deliver an outstanding insurance Telematics solution. Telematics Insurance represents a fundamental change in the way car insurance is sold, underwritten and administered. As data from an accident is understood, reconstruction tools will revolutionize fault allocation, with early intervention transforming FNOL (First Notification of Loss) activity and situation control; delivering cost reductions throughout the process. Telematics solution gathers the real-time data of the insurer performance and vehicle conditions. The vehicle Telematics technology helps to keep track of key information about vehicles, which help to improve insurer’s efficiency and safety.

The main service around ITS project consists of development and maintenance support of ITS application. The primary scope of this project is mainly deals with the data collection, storage, data analysis and data modeling of telematics data and to produce BI Reports. The Telematics data is used for

Data Analysis: Delivering meaningful high frequency telematics data for analysis (Ex: First Notification of Loss – FNOL alerts and to study crash impact, to check for safe driving, claims processing and to produce reports).
Data model: An excellent data model is being built to implement intervention model requirement by analyzing the speed data of the vehicle and for performance considerations. This BI Intervention Data Model helps in analyzing the speed of vehicle in each speed limit in which driver drives in a particular area. The management can alert the driver for over speeding events, and subsequently cancel the policies.
BI Report: Converting the data into bespoke Management information (producing daily MI reports of data for managerial actions).

—–

Schedule

Sep’15 to Dec’18

—–

SWORD’s Contribution

  • Stabilized the existing business critical applications
  • Introduction of alarm systems across all worker role services for monitoring purposes
  • Implementation of Quality Management system and processes
  • Adherence to the basic tenets of Project Management (PM-Initiation, planning, execution, monitoring and control, closing)

—–

Enabling Technologies:

  • .NET (C#, Visual Studio)
  • SQL Server 2014
  • Azure Cloud Platform
  • SSIS (SQL Server  Integration Services)
  • SQL Scripts, SQL  Management Studio
  • Business Intelligence (For developing intervention model and MI Reports)

—–

Deliverables:

  • Impact analysis
  • Functional Specification
  • Technical documentation
  • Unit tested code
  • Test plans and Test Reports
  • User release notes