Proven Business Impact Through Better Operations

Stock data was spread across multiple systems, including warehouse data, forecasts, and owings reports. Teams relied on manual checks and internal messaging to answer key questions on stock levels, expiry dates, and coverage. This lack of visibility led to constant back-and-forth, slower decision-making, and increased risk of expiring stock and unfulfilled orders, with teams spending more time chasing information than managing it.

A Stock Intelligence Tool was built to unify data from spreadsheets and APIs into one central interface. An AI-powered assistant enables users to ask questions and receive instant answers on stock, expiry, and forecasted coverage. Automated notifications alert stakeholders to changes in stock, forecasts, or owings, creating a real-time, proactive system that replaces manual processes with a scalable solution.

A large volume of operational data was being submitted with incomplete, inconsistent, or incorrect information. Many entries contained spelling errors, outdated details, or records that did not align with the correct source data. These inaccuracies regularly blocked downstream workflows, creating delays and forcing the team to review, clean, and validate datasets each month manually. As volumes increased, this became a significant operational bottleneck, consuming substantial admin time and introducing risk around data accuracy, consistency, and reliability.

A purpose-built processing tool was developed to clean, standardise, and match incomplete data at scale. Using intelligent matching logic, including similarity scoring techniques such as the Levenshtein distance algorithm, the system compares incoming entries against a trusted master dataset and assigns confidence scores to identify the most accurate matches. This allows the tool to automatically resolve inconsistencies, validate records, and standardise data in minutes. The solution integrates seamlessly into the existing workflow, transforming a manual, time-intensive process into a fast, reliable, and scalable system.

Critical operational information, such as discount codes and campaign details, was not flowing efficiently between Commercial, Customer Support, and Operations teams. This lack of visibility resulted in repeated internal queries, delays in responding to patients, and confusion around which campaigns were active. As a result, teams spent unnecessary time chasing information instead of focusing on delivering value.

To address this, an automated communication system was implemented using a combination of real-time notifications and an AI-powered assistant. A Teams bot was introduced to proactively notify relevant teams when updates occurred, while the assistant enabled users to quickly query accurate information from a centralised data source. This removed the need for manual back-and-forth and ensured consistency across all teams.