Retail & Wholesale
Shoppers Drug Mart
Retail & Wholesale
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.
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.
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.
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.