Healthcare OperationsProject Proposal - VCH

Wheelchair Inventory Optimization System

Cerner Integration & Data-Driven Healthcare Management

3 Sites
Hospitals
200+
Patients
Proposed
Efficiency

Project Overview

Spearheaded a comprehensive project proposal for Vancouver Coastal Health to optimize wheelchair inventory management across multiple healthcare facilities. The proposed system integrates with existing Cerner EHR infrastructure to enable real-time tracking, automated maintenance scheduling, and data-driven analytics for improved patient care delivery.

Challenge

Manual wheelchair tracking across VGH, Richmond Hospital, and Lions Gate Hospital led to inefficiencies, maintenance delays, and reduced patient satisfaction.

Solution

Integrated data analytics platform with Cerner EHR integration for real-time inventory tracking and predictive maintenance scheduling.

Business Context

Healthcare Impact

Wheelchair availability directly impacts patient mobility, discharge timing, and overall healthcare experience across VCH facilities.

  • Reduced patient wait times
  • Improved discharge efficiency
  • Enhanced patient satisfaction

Operational Benefits

Streamlined inventory management reduces operational costs and improves resource allocation across multiple hospital sites.

  • Predictive maintenance scheduling
  • Real-time inventory tracking
  • Data-driven decision making

Technical Approach

Data Integration Strategy

Proposed integration with Cerner EHR system to leverage existing healthcare data infrastructure while maintaining compliance with healthcare privacy regulations.

Analytics Engine

SQL & Python for data processing and predictive modeling

Data Visualization

Tableau dashboards for real-time monitoring

Process Optimization

Excel-based modeling for workflow improvement

Expected Outcomes

Quantitative Benefits

Inventory Visibility95%+
Maintenance Efficiency30% Improvement
Patient Wait Time25% Reduction

Qualitative Impact

  • Enhanced Patient Experience

    Reduced wait times and improved mobility support

  • Staff Efficiency

    Automated tracking reduces manual inventory tasks

  • Data-Driven Decisions

    Evidence-based resource allocation and planning

Project Details

Timeline

Q2 2024 Proposal

Client

Vancouver Coastal Health

Scope

Multi-site implementation across VGH, Richmond Hospital, Lions Gate Hospital

Technologies

SQLPythonTableauCerner IntegrationExcelData AnalysisProcess Optimization

Key Features

  • Cerner EHR integration proposal
  • Inventory tracking optimization
  • Maintenance scheduling automation
  • Data-driven decision making
  • Multi-site coordination system