A Modern and Secure Application for the Mechanical Contractors Association of Georgia

challenge

An Aging Application

MCAG was using a 20+ year-old, custom application developed using aging and inadequate technology (VB6 and MS Access) to manage their business. The organization needed an updated core business platform in order to scale with growth, keep up with modern infrastructure standards, and operate at a low cost with a low level of maintenance.

solution

A Modern Technology Stack

The Sparq team completely rebuilt the application utilizing a modern technology stack (.NET, Angular) and moved it to the AWS cloud. AWS technologies utilized include RDS (MySQL), S3, CloudWatch, EC2, Route53, CodeCommit, CodeBuild, and CodeDeploy.

results

A Cost-Effective, Scalable Solution

By utilizing a suite of light-weight yet powerful AWS services, the final product provided MCAG with a cost effective, scalable solution that could be maintained at a very low cost. The product is now far less susceptible to third party changes such as OS upgrades and legacy infrastructure.

About
Mechanical Contractors of Georgia (MCAG)

Around 1890, plumbing and heating contractors in Atlanta came together to form one of the city’s very first trade associations. Now known as the Mechanical Contractors Association of Georgia, MCAG is the state’s leading union-employing organization, representing the most talented mechanical contractors.

Case Study

Apr 8, 2025

Enhanced Insights and Data-Driven Decision Making for Center Street Lending

Center Street Lending provides smarter loans for residential real estate investors in 42 states. Their internal teams relied on visualizations to make data-driven decisions within their loan programs, but their data sources were fragmented and not automated. Learn how we helped establish a single source of truth for streamlined communication between stakeholders and teams, while improving the accuracy and accessibility of key organizational metrics and KPIs.

Case Study

Apr 1, 2025

AI-Powered Predictions Drive Efficiency for Transportation & Logistics Company

For a global transportation & logistics client, predicting pickup volumes for their highest-tier and most urgent next day air delivery service was a challenge due to fluctuations in customer demand. Without precise predictions, planners would either over-allocate or under-allocate resources, negatively impacting our client’s efficiency and their customers’ satisfaction. They partnered with us to find a more reliable way to assist their route planners in optimizing daily dispatch schedules.

Case Study

Mar 27, 2025

Scalable Data Overhaul for Supply Chain Sustainability Company

The existing tech stack for a leader in sustainable supply chain and manufacturing intelligence lacked usability and accessibility, making it harder to provide comprehensive product insights for customers. Learn how we created an AI-ready data solution that could scale efficiently while minimizing manual processes.

Case Study

Mar 26, 2025

Using AI to Solve a Stadium’s Biggest Entry Headache

A major American stadium had been struggling with serious bag check bottlenecks after the introduction of new security policies. Our client needed to find a new way to screen bags that was efficient, consistent, and preserved the positive experience fans expect. Learn how we used AI to solve this challenge.

See All Case Studies

A Modern and Secure Application for the Mechanical Contractors Association of Georgia

An Aging Application

Sparq IT Blog Cookies Policy