About Experience Projects Skills Education Credentials Contact Email

Max Hemmerich

Research operations professional improving data quality, reporting, and workflow efficiency in regulated health research.

Download resume (PDF)

MAX_HEMMERICH.exe — Portfolio

[profile loaded]

Max Hemmerich

Max Hemmerich

Research operations professional with experience improving data quality, reporting, and workflow efficiency in regulated health research.

Total CAMH tenure

About 3 years (Sep 2023 – Present)

Study Lead tenure

About 2 years (Aug 2024 – Present)

Total research experience

About 4 years (May 2022 – Present)

Current work spans clinical study coordination, operational reporting, data-quality workflows, dashboarding, and practical automation in a regulated research environment.

Experience

Research Analyst & Study Lead

  • Built a Power Automate flow to scan a shared calendar and automatically surface research visits (3,000–4,000/year) with no staff assigned.
  • Automated EEG lab scheduling with a recurring Power Automate flow, replacing manual weekly availability-block creation for 4 technicians.
  • Built and independently shipped a multi-tab HTML recruitment dashboard for the VIBE study, enabling self-serve monitoring for leadership.
  • Maintained data quality across 3 concurrent study arms using REDCap and Excel in a regulated research environment.
  • Built Python- and Power Automate-supported ingestion and validation workflows for longitudinal datasets with 3,000–4,000 annual event records.
  • Conduct structured diagnostic interviews (KSADS, SCID) and contribute to consensus diagnoses with psychiatry teams.
  • Collect biosamples and perform retinal imaging to explore biomarkers related to brain health and mental illness.
  • Lead MRI and cognitive assessment visits and support EEG acquisition and quality assurance.

Research Assistant

  • Facilitated MRI and cognitive visits while supporting protocol adherence and participant comfort.
  • Conducted biosample collection and processed clinical data for psychiatric research studies.
  • Built Python and Power Automate workflows to support scheduling and operational processes across a longitudinal cohort.
  • Developed dashboards tracking recruitment, visit completion, and study milestones for team reporting.
  • Managed REDCap databases across concurrent studies under GCP-aligned practices.

Clinical Research Coordinator

  • Coordinated CAPU RISE, a non-therapeutic clinical trial on cannabinoid effects on stress response, including scheduling, fMRI coordination, and biosample collection.
  • Supported data integrity through reconciliation and adverse-event management.
  • Assisted with the design and submission of a Health Canada clinical trial application.
  • Led study start-up work including REB documentation and site-readiness tasks.

Projects

Fig. 1

VIBE Dashboard

HTML/CSS recruitment-metrics dashboard for study leadership, enabling self-serve monitoring.

Open folder No public link
Fig. 2

TAY Coverage Gap Flow

Power Automate flow that scans a shared Outlook calendar and surfaces research visits with no staff assigned.

Open folder No public link
Fig. 3

EEG Scheduling Flow

Power Automate workflow that replaced manual weekly availability-block creation for 4 technicians.

Open folder No public link
Fig. 4

Retinal OCT Privacy Utility

Utility to identify and remove patient-identifying fields from retinal OCT exports before research use.

Open folder No public link
Fig. 5

Chalk

SMS habit tracker: text habits daily and track them on a live dashboard. Node.js + Express backend handling Twilio SMS webhooks and cron scheduling, with a React + Vite dashboard reading Supabase.

Open folder chalk-seven.vercel.app
Fig. 6

Mirror

An unlaunched interactive prototype. The build went from an approved product specification to a working interactive prototype verified by an automated harness — Next.js App Router, TypeScript and Tailwind, with Vercel as the deploy target.

Open folder No public link
Fig. 7

Distill

AI reading interface that turns articles or pasted text into hierarchical, sectioned summaries. Next.js App Router and TypeScript, using the OpenAI API in a three-pane reading layout that preserves footnotes and references.

Open folder distill-mu.vercel.app
Fig. 8

BeatTheClose

NBA player-props analytics tool using Python for Kelly sizing, expected-value calculations, and CLV tracking.

Open folder No public link

Core Skills

Power Automate workflow automation
Research data quality and reporting
Advanced Excel (LET, XLOOKUP, FILTER)
Python scripting and data-validation automation
Dashboard development (HTML/CSS, Power BI)
Recruitment and cohort funnel reporting
SPSS statistical analysis
SharePoint, Microsoft 365, Teams, Outlook
SQL and PostgreSQL
Google Apps Script
Local LLM experimentation (Ollama, Modelfiles)
French (Functional)

Education

University of British Columbia

Simon Fraser University

Credentials

  • PL-300 Microsoft Power BI Data Analyst (in progress)
  • CITI Program Clinical Research Coordinator
  • Health Canada Division 5 Drugs for Clinical Trials Involving Human Subjects
  • MRI Safety Level 1 Personnel
  • Transportation of Dangerous Goods (TDG)
  • Suicide Prevention Training

Contact

Name: Max Hemmerich

Email: max.hemmerich@outlook.com

Location: Toronto, ON

Open to: Toronto, ON / Open to Ottawa

LinkedIn: linkedin.com/in/max-hemmerich/

Resume: Download resume (PDF)