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

Dec 11, 2024

Revolutionizing Cancer Research with Powerful Data Visualization

A world renowned research hospital with one of the largest laboratory testing facilities in the country needed to redesign their genetic research dashboard to support oncologists and hematologists in identifying key factors correlating to certain cancer types. Learn how we helped them work towards their goal of reducing the number of tests and panels needed to identify a timely and effective treatment plan for each patient.

Case Study

Dec 10, 2024

Unified Data Warehouse Drives Transformational Growth for Upscale Retailer

An upscale regional pet retailer had fragmented data sources across a number of systems, which was causing misinformation to be reported throughout the company. They needed a partner to consolidate and transform their data for a single source of truth to generate actionable insights.

Case Study

Dec 6, 2024

Debt Syndication Platform Provides Powerful Analytics for Capital Markets Division

A major American bank struggled with tracking their debt syndication pipeline in the investment grade, high yield and municipal bond markets. Their existing approach caused operational auditing issues across a number of teams. Learn how we streamlined deal collaboration and provided enhanced analytics.

Case Study

Nov 26, 2024

Digital Transformation Catapults Global Retailer to $4 Billion Projected Revenue Boost

A leading international retailer with a multi-billion-dollar product roadmap faced significant challenges in their product development cycle. This led to a number of problems including the inability to ensure optimal ROI. Our client needed a partner to restructure their process and provide deeper insights into their product development cycle.

See All Case Studies

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

An Aging Application

Sparq IT Blog Cookies Policy