Case Study

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.

Related Case Studies
See All Case Studies
People in a warehouse unloading and moving around cargo.
Case Study
Jul 24, 2025

Sparq Transforms Strategic IT Operations for 3PL

When a leading 3PL needed to free up their internal engineering teams for growth initiatives, we stepped in with seamless, scalable support. By managing over 30 essential applications across their ecosystem, Sparq helped reduce operational strain, improve performance, and save the client $250,000 annually.

Read More
A woman doing yoga on a yoga mat by herself in a studio.
Case Study
Jul 21, 2025

Aligning Data and Teams to Meet a Critical Retail Deadline

Facing a critical reporting deadline, this global athletic apparel brand’s FP&A team needed an enhanced structure to guide decisions during peak season. Learn how we brought clarity, connection, and speed so they could deliver insights when they mattered most.

Read More
An image of a man running on a sports field with a city skyline in the background.
Case Study
Jun 16, 2025

Scaling Global Retail Brand Operations with Digital Asset Management System

A global athletic apparel brand was losing time and momentum managing creative assets across a number of disconnected tools. Teams couldn’t reliably find, share, or reuse content, which slowed delivery and made it hard to maintain consistency at scale. They needed a secure, unified system that could keep up with a global brand and actually help their teams move faster.

Read More
Exterior of a home.
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.

Read More
See All Case Studies
noun-arrow-2025160 copy 2
noun-arrow-2025160 copy 2
See All Case Studies