×

iFour Logo
 

Data Transfer for Fleet systems

About Customer

Customer is a leading service provider of state-of-the-art, highly integrated, transportation software solutions and administrative services in Canada and US. Customer also offers transportation booking features to third-parties to fetch and store data appropriately.

Challenge

The customer is providing transportation software solution and administrative services using a software that was built years ago using legacy technology VB6. The legacy software is full of bugs and incapable to cope up with new generation technology. System does not manage data appropriately adding frustration to customer as he has to do this manually. The customer realized the need of re-engineering legacy software using new technology with robust and new features.

Data Transfer for Fleet systems - 01

Technology Used

Technology
Window Service

Type

Technology
ASP.NET (C#) Framework 4.0

Programming Language

Technology
Microsoft SQL Server 12

Database Management Server

Technology
window

Architecture

Technology
Open XML, Crystal Report

Client Technology

Technology
SVN

Version Control

Data Transfer for Fleet systems - 02
Data Transfer for Fleet systems - 03

Get In Touch With Us

We encourage you to contact us with any questions or comments you may have.

image
  • Automation of data extraction from third party third transportation service providers like CMT, MKC, ICABBI, MT Data, VTS and CTS

  • Calculation of fees and charges of fleet rides automatically

  • On demand Bill and Invoice generation

  • Provides appropriate driver statement and invoice through email

  • Automatic database backup and restoration

  • Effective memory usage by deleting existing backup after specific period of time

  • Error logs tracking made easy by Audit trail of all activities performed and log generation

  • "Auto Email Error log management" to email the logs of the events with errors

  • Online remote connection web services and off line data import process to import data from different third parties

  • Run on demand completion of events to complete events manually

  • User friendly "SQL Compiler" to compile SQL script

image Conclusion/Results

With the reliable and robust solution provided by iFour Technolab, customer was able to import the data from various transportation solution provider and calculate the fees and charges in no time without any hassles. Sustainability and consistency of a system made it possible to book number of rides at a time. Revamped system made database back up and restoration easy.

 

Related case studies

 

What do our clients say

iFour Testimony - Jan Marteen Kops
iFour Testimony - David Stewart
iFour Testimony - Matthew Bellgrove
iFour Testimony - Darren Fisher
iFour Testimony - Gavin Kretzschmar
iFour Testimony - Carlos Hernandez
iFour Testimony - Jeroen Van Megchelen
iFour Testimony - John Schenk
iFour Testimony - Tim Grant
iFour Testimony - Jan Entjes
iFour Testimony - Michael
 
Blog Our insights
16 Power BI Dashboard Design Mistakes to Avoid
16 Power BI Dashboard Design Mistakes to Avoid

Avoiding dashboard design mistakes is like hosting a dinner party. Just as you need to plan the menu and seating arrangement carefully, you need to design Power BI dashboards thoughtfully. For...

Types of Power BI Licenses & Their User Personas
Types of Power BI Licenses & Their User Personas

Choosing the right Power BI license, especially when each one has remarkable and unique features, can be daunting and confusing. But, if you understand your requirements and see which...

HR Analytics Dashboard – Key Metrics & Examples
HR Analytics Dashboard – Key Metrics & Examples

HR analytics, generally known as People Analytics, could be a solid answer to those sceptics who believe that the HR department's role is just about hiring and making offers! This...