Updating pharmacy inventory system: 30% increase in throughput capacity

Innowise successfully modernized the legacy inventory management system for a leading pharmacy chain, resulting in increased speed, improved stability, and enhanced user satisfaction.

Der Kunde

Branche

Pharmazie

Region

Kunde seit

2023

Our customer is an international chain of pharmacies renowned for its extensive range of health and beauty products. A standout feature of this chain is the professional pharmaceutical consultations. Additionally, the chain offers a loyalty program that grants participants discounts, bonuses, and special offers. An online store offers delivery or in-store pickup from the nearest pharmacy for customer convenience. The company is actively developing and implementing innovative technologies to enhance customer service and streamline internal processes.

Detaillierte Information über den Kunden kann aufgrund der Bestimmungen des NDA nicht veröffentlicht werden.

Herausforderung

Legacy system hinders pharmacy chain efficiency

The client needed to modernize their inventory management system, which was based on outdated technology and no longer met contemporary performance and functionality standards. The legacy code was difficult to maintain and upgrade, complicating the implementation of new features and improvements. The system operated slowly, with frequent failures and errors that negatively impacted pharmacists’ work and the overall business process.

The Innowise team was engaged to tackle the challenges of updating legacy code, ensuring a seamless transition from the old system to the new one, optimizing application performance at all levels, and enhancing usability.

Lösung

System modernization with microservice architecture

Innowise initiated a comprehensive modernization project, replacing outdated legacy code with a cutting-edge technology stack and implementing a microservices architecture to enhance scalability and development speed. This new architecture effectively resolved existing performance bottlenecks and significantly improved functionality.

Furthermore, we developed a redesigned, intuitive user interface based on extensive user experience research, aiming to improve usability and streamline the daily tasks of pharmacists.

Legacy code refactoring

Our team conducted a comprehensive audit of the existing system, meticulously analyzing the codebase, architecture, and technologies in use. The audit revealed that the system was built on an outdated version of the .NET Framework, employed an obsolete component library, and relied on an outdated Sybase database. These factors contributed to several critical issues, including poor performance, scalability challenges, security vulnerabilities, and limited integration with modern tools and services.

Based on the audit results, we decided to completely overhaul the system’s code. Our experts choose .NET 8 as the new tech framework because it offers superior performance, flexibility, and a full set of capabilities for developing cutting-edge applications.

Migration to microservice architecture

With a focus on innovation and efficiency, we transitioned to a microservice architecture by decomposing the system into independent modules, each dedicated to specific business capabilities. Our microservices were meticulously designed with principles of loose coupling, high cohesion, and alignment with business domains, incorporating best practices from SOLID and domain-driven design (DDD) principles. This strategic shift significantly streamlined our development, testing, and deployment processes, while also enhancing fault tolerance and scalability.

The implementation was carried out in phases to ensure seamless continuity of the client’s business operations. Employing the “strangler fig pattern”, we gradually replaced legacy functionality with new microservices. To maintain data and functional compatibility during the transition, we utilized adapters and data transformation mechanisms based on the anti-corruption layer pattern. This approach allowed us to carefully manage the complexity and potential overhead introduced by these additional layers, ensuring a smooth and efficient transition.

Enhanced performance and stability

We have optimized the application’s performance across all tiers. This process included fine-tuning database queries in both Sybase and SQL Server, leveraging Redis for data caching to accelerate access to frequently used information, and utilizing asynchronous programming alongside parallel data processing to boost application responsiveness. Additionally, we implemented comprehensive monitoring and logging mechanisms to swiftly identify and address potential issues, resulting in improved system stability.

Enhanced usability

Understanding that the efficiency of pharmacists’ work directly depends on the usability of the tools they use, we placed a special focus on developing the interface of the new application. Our process began with an in-depth exploration of workflows to pinpoint key pain points, needs, and preferences regarding the interface. We meticulously analyzed typical work scenarios, frequently used features and problem areas of the existing application.

Armed with this data, we engineered clickable interface prototypes featuring various design and navigation options. These prototypes allowed us to test different approaches and gather feedback from pharmacists before beginning the development.

We conducted multiple rounds of usability testing, refining the prototypes based on the results. This iterative cycle continued until we achieved the optimal interface.

The outcome is an intuitive interface with easy navigation, a modern design, and an adaptive layout, ensuring correct display across different devices.

Technologien

Datenbanken

Sybase, Redis, SQL

Überwachung

Datadog

Programiersprachen

.NET, C#, TypeScript

API-Tests

Postman

VCS

Bitbucket

DevOps

Docker, Jenkins

Prozess

At Innowise, client interaction is rooted in transparency and close cooperation. During the initial stage, our team conducted a comprehensive analysis of the existing system and created a tailored plan of action to address the identified challenges. Upon client approval, we commenced implementation using the Scrum methodology, breaking down the project into manageable two-week sprints with clearly defined goals and deliverables.

At the end of each sprint, the team presented the results to the client and gathered feedback, allowing for flexible responses to changes in requirements and adjustments to the development plan. The project manager provided the client with bi-weekly reports on completed work, achieved results, and plans for the upcoming sprint. We maintained continuous communication with the client through various channels, including email, Slack, and video conferencing.

Team

Projektmanager

Backend-Entwickler

Front-End-Entwickler

DevOps-Ingenieure

QA-Ingenieure

Ergebnisse

2x schnellere Produktplatzierung auf dem Marktplatz

Our team has successfully modernized the product and basket management system, significantly enhancing pharmacist efficiency and customer service. The new system boasts a 40% increase in speed, reducing response time from 5 seconds to 3 seconds, and a 25% improvement in stability, with unplanned downtime dropping from twice a week to just once a month.

With a microservice architecture, the system now handles up to 1,500 transactions per hour — 30% more than the previous system — providing a robust margin for future growth. By rewriting legacy code and optimizing processes, we have halved critical failures, as evidenced by a substantial reduction in support calls.

Projektzeitraum

März 2023 - Fortlaufend

30%

increase in system throughput capacity

40%

improvement in response speed

Unsere aktuellen Fallstudien

Kontaktieren Sie uns!

Einen Anruf buchen oder füllen Sie das Formular unten aus und wir melden uns bei Ihnen, sobald wir Ihre Anfrage bearbeitet haben.

Name

Unternehmen

E-Mail

Telefon

Nachricht Bitte fügen Sie Projektdetails, Dauer, Technologie-Stack, benötigte IT-Experten und andere Infos bei.

Bitte fügen Sie Projektdetails, Dauer, Technologie-Stack, benötigte IT-Experten
und andere Infos bei.

Hängen Sie nach Bedarf zusätzliche Dokumente an.

Datei hochladen

Sie können bis zu 1 Datei von insgesamt 2 MB anhängen. Gültige Dateien: pdf, jpg, jpeg, png

Bitte beachten Sie, dass Innowise mit dem Anklicken der Schaltfläche 'Senden' Ihre persönlichen Daten nach der Datenschutzrichtlinie verarbeiten wird, um Ihnen die gewünschten Informationen zukommen zu lassen.

Wie geht es weiter?

Sobald wir Ihre Anfrage erhalten und bearbeitet haben, werden wir uns mit Ihnen in Verbindung setzen, um Ihre Projektanforderungen zu besprechen und eine NDA (Vertraulichkeitserklärung) für die Vertraulichkeit der Informationen zu unterzeichnen.

Nach der Prüfung der Anforderungen erstellen unsere Analysten und Entwickler einen Projektvorschlag, der Arbeitsumfang, Teamgröße, Zeit- und Kostenschätzung enthält.

Wir vereinbaren einen Termin mit Ihnen, um das Angebot zu besprechen und eine Vereinbarung mit Ihnen zu treffen.

Wir unterzeichnen einen Vertrag und beginnen umgehend mit der Arbeit an Ihrem Projekt.