Case Study

Cloud-based Automation Improves Data Quality and Time Savings

challenge

Manual Processes Needed Upgrading

Our client is a managed service provider (MSP) who delivers complete hybrid IT solutions, from mainframe to Cloud, tailored to each client’s journey. They have a business unit and team that manages the data for their IBM and IBM ISV TADz reporting systems. Our client had been using a data tech team to fill out a half dozen spreadsheets to plan upgrades and build a roadmap for the technicians. None of this was automated and had to be completed each week. This led to their need for a unique partner with experience in both product design leadership and AWS architecture. Having a partner of this kind would enable our client to collaboratively build an application that would help get rid of these time-consuming manual processes.

solution

A Serverless Application Using Angular and AWS Tools

Utilizing our client’s reference application architecture within AWS, our joint team deployed a serverless application within a new AWS Account. We built an Angular application served via S3 and CloudFront using AWS Edge functions for authentication redirects to AWS Cognito and SPA router deep-linking. We deployed AWS Lambda functions, an OpenAPI 3 specification file with Amazon extensions and dozens of VTL mapping templates to integrate with DynamoDB to serve the API backend. We utilized a CQRS architecture model with a separate event-logging database in DynamoDB. From there, we utilized DynamoDB streams to build view models in a separate DynamoDB table to serve the read only endpoints of the application API. This provides the fastest possible writes using versioning to support optimistic concurrency and event sourcing for fast iteration on data models, as demanded by the client. It also provided real-time report generation. We utilized AWS CloudWatch for monitoring and integrating Bitbucket with AWS CodePipeline to build, deploy and test the application using AWS CodeBuild, AWS CodeDeploy, S3 and AWS CloudFormation. Finally, we used AWS CloudFormation to enable the team to quickly deploy feature environments for experimentation, A/B testing and development environments.

results

Improved Data Quality and Hundreds of Hours Saved

Our client’s cumbersome spreadsheets, which had a catalog of hundreds of clients and thousands of software versions, were consolidated into an application leveraging search and data validation, saving hundreds of hours per year as well as reducing staff burnout. We were able to provide them with “what if” scenarios that will allow our client to offer their clients data-driven consulting level advice that otherwise would have been a near impossible manual process. This improved data quality helped them to better serve their clients and improve their brand as a leading Mainframe MSP.

 

Related Case Studies
See All Case Studies
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
Woman picking up packages
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. 

Read More
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.

Read More
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. 

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