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
Case Study
Jul 24, 2024

Accelerating Growth for Leading Manufacturing Company

Tanis Brush, a leading manufacturer of industrial and abrasive brushes, faced a critical challenge in its quoting processes. Relying on manual methods, the company encountered inefficiencies that threatened to impede its growth targets. Learn how we streamlined these processes for continued growth for our client.

Read More
Case Study
Jul 21, 2024

Trading Business Grows its Operations Through a Custom Cloud-Based System

TYR is a commodity trading company dedicated to buying, selling and transporting products such as organic food, wood and grains, with operations across North America and Europe. In order to manage the company’s different transactions and keep information centralized, they were using a system that couldn’t keep up with the business’ growth. Plus, it was hard to understand and install. Our client needed a partner to build a custom cloud-based solution for better scalability and improved UX. 

Read More
Case Study
Jul 19, 2024

Reinvigorated Stock Management System Improves Service Quality for Pharmacy Chain

As the biggest pharmacy chain in Uruguay, our client operates an app where users can buy their goods online and get them delivered. The existing platform was unorganized and caused a lot of canceled and delayed orders, which was translating into a decrease in customer loyalty and damage to their brand image. Learn how we partnered to develop a new platform for better stock management and improved customer satisfaction.

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