Knoldus Inc

knoldus-logo

Retail & Wholesale

Shoppers Drug Mart

Headquaters

India

Industry

Retail & Wholesale

Technology Used

Apigee, Kubernetes Engine, Pub/Sub, Dataflow, and BigQuery.

Shoppers Drug Mart is Canada’s leading pharmacy retailer, with more than 1,300 pharmacist-owned locations across the country. Founded in 1962, Shoppers Drug Mart is a subsidiary of Loblaw Companies Limited and has headquarters in Toronto, Ontario, Canada.

Challenges

Need to persist the information and for further analysis.

Solutions

Build a highly scalable and enterprise-ready solution utilizing several GCP services.

Results

he team is now able to access the customer and pharmacy data for further insights and analytics

Challenges

Shoppers Drug Mart utilizes a set of web-based forms that provide a variety of user experiences for pharmacists and customers while screening and registering for various services like vaccines, medication reviews, etc. This information was captured but was never persisted as schemas were dynamic, containing complex data bindings and the need was to persist the information for further analytic Needs.

Solution

We designed and built a highly scalable and enterprise-ready solution utilizing several GCP services. The forms are treated as events and are streamed through pub-sub. The dataflow pipelines de-identifies the PII data and persist the data in BigQuery by enhancing the schema to cater to all records. Metric collections + monitoring are achieved using Stackdriver, Prometheus & Grafana.

Results

All the form data is now ingested in BigQuery and SDM’s Data Science team is now able to access the customer and pharmacy data for further insights and analytics use cases -helping SDM improve patient outcomes, improved operational efficiency, etc. It supports the dynamic nature of forms and requires no enhancements or service disruptions for handling any new form or updates to any existing Forms.

Our solution saves this information to BQ, which can be utilized for any further processing like analytics, providing additional user experience based on previously captured data, having events/triggers where applicable, and any other use cases on available data. We see this only as the beginning of our journey with SDM.

Indrani Gorti

Explore latest Case Studies