endorsedCompleted

Fuel Management Data Analysis Web App

Services Covered:

Custom Software Development • Software Maintenance and Support

Industry

Energy & Natural Resources

24 months

Budget

10K - 49K

Start Date

1 June 2012

Team Size

Confidential

Engagement Model

Offshore

Project Capability Score (PCS)

72/100

Good

Project Capability Score (PCS) estimates how capable AllianceTek Inc. is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Sokolis Group

Warrington, United States of America

Project Summary

AllianceTek developed a cloud-based web app that consolidated clients' fuel purchasing data and compared transactions against pricing indexes using GPS-based sampling. The solution consolidated multiple Excel spreadsheets into a single system, automated previously manual processes and delivered sustained stability and productivity improvements over several years.

Key Challenges

Consolidate multiple Excel spreadsheets into a centralized system.
Analyze clients' fuel purchasing data and compare it to pricing indexes to identify savings.
Automate location- and time-sensitive price lookups using GPS data.

Project Deliverables

Cloud-based web application
Excel data import functionality
GPS-based price sampling feature
SQL Server database

Project Solution

AllianceTek built a cloud-based .NET web application backed by a SQL Server database. They used the client's Excel models as the specification, implemented Excel import capabilities, integrated third-party pricing indexes for nationwide price comparisons, and developed a GPS-based price sampling feature to automate location-sensitive price lookups. They rolled out the system after a period of fine-tuning and continue to provide ongoing support and maintenance.

Project Outcome

App remained stable and functional 4–5 years after launch.
Consolidated Excel spreadsheets into a single system.
Major productivity improvements, especially for GPS price comparison.
Automated a manual process that previously required 2–3 resources for a full day.

Platforms

Cloud
Web

Tech Stack

.NET
Microsoft SQL Server

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The app bolstered productivity by consolidating Excel data into a single system and automating time-consuming processes. Despite the complexity of the industry, AllianceTek kept the core objective in mind and delivered as expected. They had a straightforward approach and communicated consistently.”
Howard Abrams
Executive Vice President
Date: 12/19/2018