challenge
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
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
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.
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.
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.
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.
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.
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.