From the Founder's Practice · Retail pharmacy

From weeks to overnight: modernizing quality for a national pharmacy platform

Weeks → overnightFull regression cycle

Retail pharmacy · Store-to-cloud data platform (GCP, IBM Cloud) · Robot Framework (Python), DevTest

01 The situation

A national retail pharmacy network in Canada, with hundreds of stores, relied on a middleware platform to move pharmacy data from every store into a central database, feeding multiple downstream applications across a multi-cloud environment on Google Cloud (GCP) and IBM Cloud. The data volumes were large, the integrations were many, and a defect anywhere in the chain could reach stores and the systems that depend on them. Testing was largely manual and ran on on-premises infrastructure. A full regression cycle took a few weeks, which slowed every release and made thorough testing hard to sustain.

02 What we did

  • Built automation for the platform using a Python-based Robot Framework approach, covering data flows from store to central database to downstream applications.
  • Automated API testing with DevTest, to validate integrations between the middleware and the applications that depend on it.
  • Moved testing to the cloud (GCP and IBM Cloud), alongside the platform's own migration.
  • Set up a dependable release rhythm: an automated sanity suite after every deployment; the full regression suite overnight after fixes and new features; results reviewed and acted on each morning.
  • Robot Framework
  • DevTest
  • GCP
  • IBM Cloud

03 How it worked

Store systems
Middleware
Central database
Downstream applications (GCP, IBM Cloud)
Robot Framework (Python): data and flow validation
DevTest: API tests

04 Implementation

  1. Every deployment: automated sanity suite
  2. Overnight: full regression after fixes and new features
  3. Morning: results reviewed, defects routed to teams

05 Results & business impact

Results

Weeks → overnightFull regression cycle
Every deploymentValidated by automated sanity checks
DailyClear morning view of release quality
60Global team led through the change

Business impact

  • Releases no longer waited weeks for testing
  • Predictable daily view of release quality
  • Testing scaled with the move to the cloud

06 What this means for you

If your regression takes weeks, your data flows cross many systems, or your quality signal can't be trusted, this is the kind of change IQE Labs helps you plan and deliver.

Anonymized from the founder’s prior enterprise work, before IQE Labs was founded. Client names and identifying details are withheld.