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
Jan 30, 2025

New Trading Desk Enables Continued Growth for Top 10 US Bank

Following the merger of two major financial institutions, our client—a top 10 US bank—needed to expand their suite of offerings to attract new Fortune 500 clients and increase their competitive advantage. Learn how our expertise in complex capital market solutions helped us establish a state-of-the-art trading desk to fuel future growth.

Read More
Case Study
Jan 29, 2025

Centralized Reconciliation System Transforms Payments Company’s Treasury Operations

A rapidly growing unicorn payments company, faced challenges managing payments across a complex and expanding ecosystem. Learn how we created a centralized solution to streamline data management, ensure compliance, and maintain trust with stakeholders. 

Read More
Case Study
Jan 24, 2025

Future-Proofing a Payments System for Scalable Growth

Our client, a rapidly-expanding payments company, needed to lay the groundwork for their next-generation payments platform. Their existing payments system was outdated and lacked the scalability and flexibility required for future growth. Learn how we built a façade around their legacy system to modernize their payment management processes without disrupting ongoing operations.  

Read More
Case Study
Jan 23, 2025

Reimagining the User Experience for a Top 10 US Bank

A top 10 US bank recognized the need to improve the user experience within their Corporate & Investment Bank’s operations. They lacked a clear definition of their diverse user base and struggled to design intuitive interfaces and experiences that met the specific needs of different user groups. Learn how we created a single source of truth that would drive user adoption.

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