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
Feb 21, 2024

AWS Solution Brings Scalability and Additional Growth for Digital Healthcare Platform

Medify Health, a health technology company providing hyper personalized health services, has a unique platform that pairs patients with health coaches who empower them to achieve better health outcomes. They had specific business goals that they wanted to meet, so they were looking to enhance their platform so it could scale proportionately with their growth.

Read More
Case Study
Feb 19, 2024

Helping to Improve the Insurance Policyholder Experience with AWS Cloud

CRS Temporary Housing, a top-tier Additional Living Expense (ALE) services provider for insurance carriers, had a vision to innovate their business operations by implementing next-generation technologies further to do-more-with-the-same costs. Learn how we used an AWS solution to help them achieve their vision.

Read More
Case Study
Jan 22, 2024

Customer Experience Transformation Positions FinTech Platform for High Growth

After being acquired by a private equity firm, our FinTech client had aggressive growth targets they needed to meet. Their current product was limited in its UI/UX design flexibility and their customers were asking for more advanced filters and views of AR data and reports. Without a modernized platform, our client would likely not be able to expand and meet their new growth goals. Learn how we helped them modernize, enhance their UI/UX and introduce more scalable technology.

Read More
Case Study
Jan 3, 2024

Fueling Growth: Transforming Freight Factoring with Modernized Platform

As specialists in freight factoring, our client wanted to gain more market share by leveraging advanced technology. Their current resources were unable to keep up with the highly competitive speed of business and our client was concerned that without technology upgrades, they’d start to lose customers. Learn how we helped them modernize so they could continue to grow.

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