Zhiyuan Song
Projects Recent work Research Notes 中文
← Columbia LABS overview
Overview MEDICINE Sleep Chart TeaChart AI4Women Guidebook

Columbia lab · Apr 2026 · Guidebook & platform engineering

Guidebook and platform access delivery

This track shipped mainly in April 2026. I owned the Guidebook module end to end—from requirements to something we could ship—controlled access to internal documentation and resources for collaborators, including authentication, role-based access, invite-based onboarding, and admin review. In parallel I fixed Sleep Chart portal issues around GWAS downloads.

The group had manuscripts in peer review (including workflows tied to a Nature Medicine submission), so the platform needed to be usable on a deadline. I validated full user journeys, opened PRs, and coordinated Netlify env vars and admin/Firebase usage with the PI over private channels—no passwords, phone numbers, or one-time codes appear on this page.

The June 2025 first Sleep Chart portal build (GWAS UI, nav policy, merge fixes) lives on its own page: Sleep Chart portal (June 2025). This page emphasizes April 2026-era maintenance (e.g., GWAS download path) alongside Guidebook.

Guidebook (live): https://labs-laboratory.com/guidebook/

Engineering scope

  • Authenticated flows for a research portal: who can see what, and how access is granted or revoked.
  • Invite-based registration with admin approve/reject and account lifecycle; rejected users can re-verify via a new invite.
  • Firebase Authentication; Netlify deployment with environment-based configuration.
  • Helped stand up an org mailbox for backend use and complete provider verification (details private).
  • Documented env vars for deployment; synced with the main site via git pull before PRs to avoid conflicts.

Validation

End-to-end checks before handoff, including registration, pending review, approval, rejection, and re-invitation paths, plus admin flows such as disabling access.

Sleep Chart portal

Fixed GWAS download behavior so downstream analysis could run reliably through the portal.

Deployment and collaboration

Changes landed via PR; Netlify env var lists shared privately with the PI. This page lists no credentials.

Resume-ready summary

Led the design, implementation, and handoff of an authenticated Guidebook module for a biomedical research platform, supporting controlled access during active peer review (including Nature Medicine-related workflows). Architected invite-based onboarding, admin review/rejection flows, and user lifecycle management with Firebase Authentication; deployed via Netlify with environment-based configuration. Ran end-to-end workflow validation (registration, approval, rejection, re-invitation). Fixed Sleep Chart portal GWAS download issues and coordinated merges with upstream site changes.