Back to Projects
Featured
Digital Archive
Bilingual System
Historical Preservation
Pride Information Management System (PIMS)
Canadian Pride Historical Society (CPHS)
Jan 2025 - Mar 2025
Overview
Transformation of a legacy Pride Information Management System into a modernized digital archive for preserving Canada's LGBTQ+ history.
Role
Data Architect
Project Details
Designed and delivered a scalable, bilingual platform that enhances the system's functionality, addressing the evolving needs of CPHS.
Implemented standardized metadata (Dublin Core), consistent naming conventions, Role-Based Access Control (RBAC), audit logging, and compliance with the Canadian Copyright Act.
Applied Fixity and BagIt for file integrity, adopted a hybrid storage model (cloud + local), used open file formats, and set up encrypted, versioned backups.
Technologies
MySQL
V0
AWS S3
Supabase
Vercel
Tools
MySQL
V0
AWS S3
Supabase
Vercel
Skills Applied
Database Design
Data Governance
Bilingual Support