Increased Customer Loyalty and Better Reliability for Global Tool Manufacturer’s SaaS Product

challenge

Performance Issues for Multi-tenant SaaS Product

Our client, a global tool manufacturing company, had launched a revolutionary jobsite management application that connects sites, people and equipment and helps users manage their tools and streamline equipment workflows. By making it easier for customers to manage their inventory of tools that were purchased, the app inherently increases customer loyalty and long-term revenue. This multi-tenant application has a robust search feature that accepts filters and partial keywords to find devices across many disparate data sources. One of the primary domain databases was under a constant load, creating performance issues across all users of the applications. This caused large searches from some tenants of the application to impact the performance of smaller tenants. Search results for an empty list could take as long as 45 seconds during mid-peak usage. Their immediate resolutions were costly and not making much impact, causing headaches and frustration for their smaller tenants. They needed a partner to come in and quickly help them achieve high availability and reliability so that the app could perform at its best, therefore helping its users provide a high level of customer service to their own customers.

solution

Multidisciplinary Approach Using Multiple AWS Services

Our team took a multidisciplinary approach to solving the issues around performance and lack of scalability of our client’s application. We removed CRUD APIs from the .NET monolith that was running the majority of the application and refactored those endpoints to Amazon REST API Gateway routes that executed scalable AWS Lambda functions. We then re-architected the search engine of the application to utilize AWS OpenSearch (formerly ElasticSearch). We deployed a well-architected OpenSearch cluster with appropriate encryption, networking, ingress access, API Gateway integration and monitoring. We also created DevOps pipelines to execute API testing, load tests and validation of new indexes. We used fine-tuned indexes to provide the fastest possible searches and indexing to occur within one second of new data being added. We then created data pipelines to synchronize data from IoT devices, DynamoDB, On-Prem SQL databases and RDS SQL databases to the OpenSearch cluster. This was accomplished via DMS migrations and real-time synchronization, AWS EventBridge, Kinesis, Kinesis Firehose, DynamoDB Streams, ECS Tasks and AWS Lambda. We created the operations (from Jenkins Pipelines and AWS CloudWatch), AWS Architecture design and implementation and backend API solutions. Separate front end and mobile teams consumed the new Search API.

results

Better Scalability, Reduced Costs and Improved UX

With a change to the search architecture, our client was able to scale with their customer base, reduce costs, maintain high availability and reliability and provide a better customer experience. This also helped to increase customer loyalty and retention. The new solution had data searchable within one second of a device reporting or data being added, with the average case being under 100 milliseconds. The new endpoint returned results from the largest data sets within 400 milliseconds (down from 45 seconds), reducing search responses by 99.2%. We also reduced monthly costs by hundreds of dollars. By introducing a cluster service with multiple nodes we increased availability threefold over the previous implementation. All of this was accomplished within four months.

Case Study

Oct 23, 2023

Driving New Revenue Streams for a Pharmacy Benefits Management Company

Our client, a pharmacy benefits management company, wanted to create a set of products that would create new revenue streams and help them gain market share. Since this was their first time launching Cloud-based commercial software products, our client needed a partner with a strong product mindset. Learn how we created two modern applications to help our client become a true market leader in this space.

Case Study

Oct 9, 2023

App Modernization Helps Natural Gas Transportation Company Stay Compliant and Increase Revenue

With a big regulatory change on the horizon, our client, a natural gas transportation company, needed to update their current system or face a potential shutdown for non-compliance. Learn how we helped them move to the Cloud and instill a DevOps culture within their organization.

Case Study

Sep 26, 2023

Streamlining Delivery: Modernizing In-Vehicle Information System (IVIS) for Global Logistics Provider

A large global logistics and package delivery company was one of the first implementers of a modern IVIS for their thousands of feeder drivers across the U.S. Originally developed several years ago, the system needed re-platforming and modernization to support future business initiatives. Learn how our team modernized the application and improved the user experience, enabling drivers to spend less time in the application and more time on efficiently getting packages to customers.

Case Study

Aug 31, 2023

Modernized Cloud-Based Solution Helps Drive Revenue and Increase Profitability for Global Transportation Company

As a global leader in transportation, manufacturing and freight services, our client’s railcar management and leasing services division had grown 800% over the last five years and had outpaced their current technology suite’s capabilities. They had multiple monolithic applications built in different technologies and wanted to build a connected enterprise suite. Learn how our team helped this client modernize so they could realize revenue more quickly while also reducing their investment in operating expenditures.

See All Case Studies

Increased Customer Loyalty and Better Reliability for Global Tool Manufacturer’s SaaS Product

Performance Issues for Multi-tenant SaaS Product

Sparq IT Blog Cookies Policy