About the Client
The Client is a leading trucking BI service provider, with a massive database of trucking information collected over 25 years. This includes details on types of trucks, their drivers, accidents or other history, truck brands, equipment manufacturers, and other related aspects.
The Client has a long-standing contract with US government for subscribing this data from US Federal and State Government files.
Client operated multiple applications for its business intelligence solutions, powered by a large database with all the information customers would require. Some of the older applications were outdated from a UI and architecture standpoint, and posed challenges such as poor customer feedback on usability and performance.
The client approached Silicus to help enhance the application.
Need help with an AWS Cloud Deployment project?Contact Silicus Sales
Client had its database on Microsoft SQL 2012 hosted on Azure. At the client’s behest, Silicus migrated the database from Azure to Amazon Redshift, for faster performance as evaluated by the client’s technical team. Silicus also moved a part of database to even more refined version of Redshift called Aurora.
New features added:
Prospect level User defined fields
Enhanced search options were incorporated. Eg: a word could be searched under three different categories, namely, equipment, company, activity (violations, investigations, etc.), and drivers
Implemented a “custom filter” functionality that allows users to dig deeper into the database. Users can search by keying in the prospect name from their end.
Created custom API’s that enabled CRM integration
Designed a flexible framework that supported report design and customization, enabling a robust dashboard with direct and quick access to truck data.
Leveraged Kendo UI library and Bootstrap to impart a modern and user-friendly look and feel to application.
Visual Studio 2013
3rd Party Tools
Amazon Redshift and Aurora
Better and Faster Performance
Database migration to Redshift and Aurora significantly improved application performance
Improved End User Experience
With customized search options, such as, Prospect level search, and CRM integration possibilities, client achieved a substantial level of customer-satisfaction