endorsedOngoing

Modernization of Proprietary Task Management System

Services Covered:

Web Application Development • Database Development and Management

Industry

Logistics & Transportation

50 months

Budget

50K - 199K

Start Date

1 May 2015

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

Confidential

United States of America

Project Summary

AllianceTek renovated a proprietary, Access-based database into a web-based SQL platform, rewriting the front- and backend and adding quoting, scheduling, and work order modules. The converted platform, built with a Backbone.js web framework, is now an essential enterprise tool used across quoting, scheduling, and operations. The renovation improved client relations and made management of files and scheduling far easier for the waste transportation company.

Key Challenges

Manage records for drivers collecting waste from more than 150 locations with unique customer requirements
Replace cumbersome Word document storage and a rudimentary Access database
Build a more robust, scalable system to accommodate company growth

Project Deliverables

Quoting module (frontend)
Scheduling module (backend)
Work order processing tool with printable forms
Full code rewrite and migration to SQL
Web-based application built on Backbone.js

Project Solution

AllianceTek renovated the client's Access-based database into a web-based system. They added a frontend quoting module, created a backend scheduling module, and developed a work-order tool that produces printable forms. The vendor migrated the application to SQL and rebuilt the platform using a Backbone.js web framework, iteratively refining the product until the client was satisfied. Communication was handled via a U.S.-based project manager while an offshore development team performed nightly implementation work.

Project Outcome

Transformed a basic Access database into a core enterprise tool used across quoting, scheduling, and operations.
First two phases were completed ahead of schedule.
Improved client relations and streamlined file and scheduling management.
Enabled daily development turnaround by combining a U.S.-based project manager with an offshore development team.

Platforms

Tech Stack

Backbone.js
SQL

Client Endorsement

Overall Review Rating

4.75

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Managing client relations became much easier after AllianceTek revamped the database system. From scheduling to file management, the renovated platform has improved all aspects of the business.”
Anonymous
Project Manager
Date: 07/23/2019