Client Profile

Shoppers Drug Mart Corporation is Canada's largest retail pharmacy chain, and has its headquarters in North York, Toronto, Ontario. It has more than 1,253 stores operating under the names Shoppers Drug Mart (SDM) in nine provinces and two territories. In addition to its retail formats, the company owns and operates several specialty services. This includes 62 Shoppers Home Health Care stores, which sell and service assisted-living devices, home-care products, and mobility and medical equipment; Shoppers Drug Mart Specialty Health Network, a provider of specialty drug distribution, pharmacy and comprehensive patient support services, and MediSystem Technologies Inc., a provider of pharmaceutical products and clinical services to long-term care facilities and retirement communities.

Program Objective

SDM did not have an effective demand and capacity management system in place, creating a situation where business budgets ballooned. The main factors which led to this situation were Threat to revenues, rapidly rising power and cooling costs, low utilization rates and declining service levels. Their custom old system was based on excel sheet macros which were outdated and non-scalable.

TechCompiler Solution

TechCompiler’s answer to this situation was a Resource Demand and Capacity Management System which provided workflow processes to identify which resources are vital to the success of business, Ensuring that these resources are available as business needs them and Improving efficiency by ensuring that assets are not over-provisioned and then left lying idle. Our system was developed using JAVA/J2EE on Google Cloud.

Technology Used

  • Enterprise Applications
  • J2EE frameworks like Spring, Strut and JSFJ2EE Design Patterns
  • Java Persistence API frameworks like Hibernate and TopLink
  • JSP,JSPX, Servlets, Custom Tags, JDBC, XML/XSL, EJB, JMS, JTA and JUnit
  • Google Apps Engine
  • Cloud Mysql
  • JIRA bug tracking tool

How it works

This application is a custom Resource Demand & Capacity Management application. It allows a Business Owner to set demand & capacity of Resources, as long as it falls within the following constraints:

  • Manage Projects
  • Add Resources to Projects
  • Forecasting Resource demands
  • Resource Availability
  • Project Assignment Shared/Dedicated Resource
  • Reports

How it looks

1. Application Dashboard


2. Project Resource Forecast


3. Reports