~/projects/panday

Panday

Career roadmap platform for BC trades apprentices

# Role: Technical Lead & Full-Stack Developer # Team: 4 developers, 4 designers # Duration: 4 months # Year: 2025
Next.js 15 React 19 Go PostgreSQL pgvector Redis Streams D3.js React Flow Vitest
Panday main screenshot
~/rationale

British Columbia faces a critical shortage of skilled tradespeople, yet aspiring apprentices struggle to navigate the complex certification pathways. Existing resources are fragmented across government websites, making it difficult to understand prerequisites, timelines, and career progression options.

The platform needed to transform dense regulatory information into an intuitive, interactive experience. Technical requirements included visualizing interconnected career paths with hundreds of nodes, implementing AI-powered guidance that references official documentation, and ensuring the system could scale to support thousands of concurrent users.

Panday presents BC trades pathways as interactive visual roadmaps built with D3.js and React Flow. A RAG-powered AI assistant answers questions using official program documentation, while voice transcription enables hands-free navigation. The architecture leverages Redis Streams for real-time features and pgvector for semantic search across embedded documents.

~/highlights

Interactive Career Roadmaps

100+ nodes · O(n) collision detection
01

Built a visual navigation system supporting 100+ interconnected career nodes with collision detection optimized from O(n²) to O(n) using grid-based spatial partitioning. The D3-force physics simulation runs 300 iterations to generate deterministic layouts.

Interactive Career Roadmaps

RAG-Powered AI Assistant

80% API cost reduction · sub-second queries
02

Implemented semantic search across official BC program documentation using pgvector with 1536-dimensional embeddings and HNSW indexing. The system caches query results with a 5-minute TTL, reducing embedding API calls by 80%.

RAG-Powered AI Assistant

Team Leadership & CI/CD

515+ tests · 54,000 lines · 8-person team
03

Led a cross-functional team of 4 developers and 4 designers. Established GitHub Actions CI/CD pipelines with branch protection rules, enabling junior developers to contribute to the 54,000-line codebase with 515+ Vitest tests and zero production regressions.

Team Leadership & CI/CD
~/screenshots
Panday screenshot 2