challenge
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
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
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.
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.
Dairy Business Startup Exceeds Investor and User Expectations with Cross-Platform App
In the dairy supply chain, there are many steps and stakeholders involved: the farmer who owns livestock, the producers who develop dairy products, the retailers who commercialize the products, the consumers who buy them and so on. Even though these roles are all part of the same process, they don’t always communicate or collaborate in an optimal, transparent way. Vyla envisioned a collaborative dashboard software to better connect the production process and players to increase collaboration and improve results, but couldn’t bring that idea to life without an experienced software development partner. Learn how we helped.
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.
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.