Case Study: Converting Excel-based Solutions to Cloud-based Software Applications
Optimum converted a complex Excel-based solution to a modern, customizable, and robust, Azure-based software application.
Business Challenge and Project Background
Prior to Optimum’s involvement, Client, a leading provider of operations software for Industrial markets, offered a suite of proprietary Excel-based tools, forms, and templates to their customers. This suite of Excel-based applications lacked the security, scalability, and automation capabilities required by the Client’s customers and offered limited functionality ad visibility, with only the standard charts and capabilities available within the
The Client sought to offer their customers a modern, customizable, and Cloud-based platform running on a more robust and secure infrastructure and providing a customizable and modern user experience.
The Client also needed as solution that provided the ability for growth and expansion, allowing the opportunity for additional capabilities based on their customers’ end-user feedback. The Client sought to leverage the solution to increase marketability in their product offerings.
Optimum began the engagement by conducting a series of in-depth requirements definition and process mapping workshops, to understand the current product, and defining and documenting the business and functional requirements of the new application as well as the high-level user stories for the new, Cloud-based product offering.
Optimum then began a thorough Design phase, defining and architecting the backend design and data model of the new application, including the database architecture and schema design, data modeling and mapping from Excel to Azure SQL tables, ETL design, and application security layers and technologies. We also designed and developed User Interface and User Experience (UX/UI) mockups and visualizations for the key screens and functionality of the new application.
Optimum utilized the right combination of Microsoft technologies and products to develop this solution. We implemented Azure DevOps including Azure Boards to manage and track developer assignments and workflows, Azure Test Plans for managing test cases and bugs and Azure Repos for managing code and the code repository. We created a security architecture that allows for user authentication and role-based authorization, something the Client had not previously been able to do within Excel. We also utilized MS SQL Server including ETL processes to drive daily and weekly data loads and implemented Angular and DevExtreme libraries for the front-end user interface.
Optimum continues to support this solution for various updates and customizations based on Client’s feedback.
The new, Cloud-based application meets the Client’s requirements and objectives, including security, scalability and maintainability, flexibility of the user interface and user interactions, automated workflows, robust Cloud hosting features, and advanced reporting and KPI visualizations, while allowing the Client flexibility in creating user defined filters for different reports and screens within the application. The utilization of the MS Azure technologies allows the Client the flexibility to rapidly modify, improve, and customize the product to meet the current and future needs of their customers and appropriately respond to end user feedback.
Optimum is a leading, certified Gold Microsoft Partner, partnering with clients from concept to execution to implement and deliver end-to-end customized software solutions or modernize your legacy applications to maximize your IT investments and reduce costs.
With years of knowledge and experience in Modern Application Development, our team of Microsoft certified experts redesign, modernize, and convert legacy applications to modern and integrated solutions to improve performance and user experience and reduce your maintenance and support costs.
Contact us for a free discovery session to identify and discuss the best solution option for your application modernization and software development needs. More information: Software Development and Application Modernization
Contact us: firstname.lastname@example.org | 713.505.0300