Dilraj Randhawa

Jargon helps newcomer tradespeople overcome language barriers while pursuing Canadian Red Seal certification. Many language-learning apps lack trade-specific vocabulary, and technical manuals can be overwhelming, filled with complex terms and little context. Developed in collaboration with BCIT's ConnectHER hub, this 15-week project combines visual learning with interactive exercises, featuring flashcards, optical character recognition (OCR), Gemini 3 Flash AI-driven Q&A, and progress tracking to keep users engaged. By balancing educational precision with an approachable interface, Jargon supports learners rather than intimidating them. Its interactive, goal-oriented design empowers tradespeople to overcome language obstacles, advance toward professional certification, and gain confidence in the workplace.

CINE HUB is an innovative movie database project designed to provide users with a comprehensive and immersive movie experience. CINE HUB offers a vast collection of information about movies, TV shows, actors, and more. Created by: Priya, Simran, Dilraj, and Mudarres. This product uses the TMDb API but is not endorsed or certified by TMDb.

The Strata Reserve Planning (SRP) Depreciation Portal is a comprehensive platform built for a British Columbia property management company specializing in strata reserve fund planning and depreciation reporting. The goal was to replace fragmented, manual processes with a centralized digital workflow covering inspections, appointments, surveys, and client documentation. The platform serves four distinct user roles — Admin, Client, Inspector, and Assistant — each with tailored dashboards, permissions, and workflows. Given the sensitivity of the financial and property data involved, the system was designed from the ground up as a secure internal business tool rather than a public-facing application. —— The Challenge —— Domain-Specific Filtering Logic — Rather than hard-coding business rules that would quickly become outdated, a flexible question CRUD system was built with configurable settings, empowering the company to tailor survey questions and document filtering based on their own domain expertise. Legacy System Integration — The company had an established Dropbox workflow for storing client documents. Rather than forcing a migration, the Dropbox API was integrated directly into the platform, enabling seamless upload, preview, download, and archival. Documents were organized by strata ID, and upon survey completion, automatically moved to a designated "completed" folder alongside the file ID — preserving compliance records while keeping active workflows clean. Multi-Role Complexity — Four user roles with overlapping but distinct permissions needed to coexist within a single platform, each requiring its own views, route protections, and data access patterns. Security & Compliance — Strict security measures were required to handle sensitive client data, including Canadian data residency compliance, role-based access control, and restricted account creation tied to verified business onboarding. —— Process —— Research & Discovery: The project began with detailed user personas representing each primary user type, capturing demographics, daily workflows, and the specific value the platform would deliver. These informed the creation of user flow diagrams for all four roles, mapping every interaction from login through to task completion. Project Planning: An Agile methodology was adopted using Jira to manage sprints, track progress, and maintain the product backlog. Weekly sponsor meetings provided consistent alignment, followed by team syncs to assign tasks and conduct sprint reviews. A structured pull request process with mandatory code reviews ensured quality across the shared codebase. Naming Conventions & Project Structure: Clear naming conventions and a three-repository architecture were established early — covering everything from Git branch naming to database column formatting. No inline styles were permitted, and reusable helper functions were enforced to keep the codebase clean and maintainable. —— Development —— The platform was built as a three-tier architecture across three repositories: Frontend — React, TypeScript, Vite: Role-based routing with separate admin and client route trees, a shared component library, custom data-fetching hooks, and modular SCSS styling. Backend — Hono, TypeScript, Prisma: A RESTful API with type-safe database access, role-based middleware, and a shared service layer for business logic. Supabase Edge Functions — Deno-based serverless functions handling all document operations — upload, download, preview, archive, and sync — via Dropbox API integration. Strategic Build Order: The Admin and Client platforms were built first, as these roles encompassed the full feature set of the application. This allowed for thorough testing and iteration on the most complex interfaces before the Inspector and Assistant platforms were developed. Iterative UI Improvements: Weekly client meetings drove continuous refinement. Key improvements included a configurable question management system, a Dropbox sync tool to reconcile database records with manually modified files, collapsible navigation for tablet and mobile views, and location grouping for appointments. —— Testing & Documentation —— Before expanding to the Inspector and Assistant roles, in-person testing was conducted with the sponsor on the completed Admin and Client platforms. This hands-on session validated core workflows, surfaced usability issues, and confirmed the foundation was stable enough to build upon. Supporting documentation was delivered in both video and PDF formats. —— Security & Compliance —— Canadian Data Residency — All data is hosted on Canadian servers in compliance with regulations governing client financial and property documentation. Route Security — Supabase authentication enforces role-based access control across all API endpoints. No Public Registration — Account creation is restricted to verified clients onboarded through existing business processes, with no public-facing registration. —— Outcome —— The completed SRP Depreciation Portal delivers a unified, role-based platform that modernizes the company's core operations. The result is a scalable, secure system with tailored workflows for each user role, flexible configuration without code changes, seamless Dropbox integration, and full compliance with Canadian data residency requirements — built to support the business today and scale with it going forward.