All Projects Health Informatics · Database Design · API

Contraception4All

M.S. applied project building a clinical decision-support tool for contraceptive counseling, designed for inclusivity across TGNC populations. Features a 38-table database schema, 4-endpoint Express.js API with OpenAPI documentation, and a matching engine that ranks resources from questionnaire responses using severity hierarchies. Repository is private pending UW advisor clearance.

Private M.S. Applied Project
🔒 Repository is private pending UW advisor clearance. Full source code, schema, and API documentation available on request for verified recruiters.
Problem

Existing contraceptive counseling tools are designed almost exclusively for cisgender women, leaving transgender and gender-nonconforming (TGNC) patients without reliable, inclusive guidance.

Approach

Designed a 38-table PostgreSQL/Supabase database schema and a REST API that matches patient questionnaire responses to a ranked set of contraceptive resources using clinical severity hierarchies, with privacy protections aligned to HIPAA principles.

Tools
PostgreSQL Supabase Node.js Express.js Next.js TypeScript OpenAPI 3.0
Result

Built a 4-endpoint, fully documented API and a resource-matching engine covering 126 resources across 708 method-factor combinations, validated by 85/85 passing SQL tests.

Why It Matters

Demonstrates health-equity-focused product design, clinical database architecture, and privacy-by-design API development — directly relevant to health informatics and clinical data platform roles.

Project Highlights

  • 38-table PostgreSQL/Supabase schema across 7 migrations with referential integrity and RLS
  • Resource catalog maps 126 resources to 708 method-factor combinations for personalized matching
  • 4-endpoint Express.js API with OpenAPI 3.0.3 spec; privacy architecture aligned with HIPAA principles
  • Pseudonymized identity mapping, consent tracking, and access logging throughout
  • Clinical knowledge base: 15 methods, 28 questionnaire factors, 238 factor-resource mappings
  • 5 audience categories including TGNC-specific resources across 3 geographic coverage levels
  • 45 SQL validation scripts with 85/85 passing tests verifying schema correctness

Tech Stack

PostgreSQL Supabase Node.js Express.js Next.js TypeScript OpenAPI 3.0

Domain Tags

Health Informatics HIPAA Database Design API

Interested in reviewing this project?

Code and documentation available on request for recruiters and collaborators.

Request Access

Infographics

Inclusive 3-tier system architecture

Inclusive 3-tier system architecture

Personalized matching engine logic

Personalized matching engine logic

38-table PostgreSQL schema (simplified ERD)

38-table PostgreSQL schema (simplified ERD)

Resource Coverage Analysis

C4A resource coverage dashboard: methods, factors, and audience

Resource coverage dashboard: 126 resources mapped across 708 method-factor combinations