Institute of Mental Health logoInstitute of Mental Health Externship via Extern
Kimberly Kho portrait

Applied math student focused on finance and data

Sophomore at UC Berkeley who turns public data into clear analytics and visuals for finance and health insights.

Work samples

Projects include a TruBridge healthcare data analytics externship focused on public datasets, statistical analysis, and dashboard-ready visualizations.

  • TruBridge Healthcare Data Analytics Externship
    TruBridge Healthcare Data Analytics Externship
    TruBridge logo

    TruBridge · Sep 2026 · ✅ Verified by Extern

    TruBridge Healthcare Data Analytics Externship

    A TruBridge externship in healthcare data analytics focused on working with public datasets, statistical analysis, and dashboard-ready visualizations.

    Data AnalysisPower BIGoogle ColabExcel, Other
  • Healthcare Operations & Consulting Externship
    Healthcare Operations & Consulting Externship
    Institute of Mental Health logo

    Institute of Mental Health · ✅ Verified by Extern · ⏱️ In progress

    Healthcare Operations & Consulting Externship

    This externship explores how care coordination work in acute mental health settings can be designed, analyzed, and communicated as a customer-centric operational system. Externs study the case manager’s role at IMH to understand how workflows shape patient experience, surface hidden risks, and make invisible coordination work visible. Through structured analysis, process mapping, and dashboard prototyping, externs learn how operational clarity supports continuity of care, safety, and institutional decision-making.

    Stakeholder MappingSystems ThinkingProcess MappingChange Management

About me

Sophomore at UC Berkeley who turns public data into clear analytics and visuals for finance and health insights.

I am a junior at UC Berkeley studying Applied Mathematics with a career focus in finance. I have completed a TruBridge healthcare data analytics externship where I worked with public datasets, performed statistical analysis, and prepared dashboard-ready visualizations.

Externships

Healthcare Operations & Consulting Externship

In progress

Experience

Executive Officer

Yahweh Apparel · August 2024 – Present

Student Assistant

UC Berkeley College of Environmental Design · September 2026 – Present

Guest Services Representative & Event Staff

Foodieland · June 2024 – Present

Healthcare Data Analytics Extern

TruBridge Healthcare · June 2025 - September 2025

Student Researcher

University of California, Irvine · July 2023

Education

University of California, Berkeley

BA in Applied Math, Concentration: Actuarial Science, Global Public Health Minor

Skills

Applied mathematicsStatistical analysisData cleaning with public datasetsDashboard-ready visualizationHealthcare data analyticsFinancial data interest

✅ Verified by Extern

TruBridge Healthcare Data Analytics Externship

A TruBridge externship in healthcare data analytics focused on working with public datasets, statistical analysis, and dashboard-ready visualizations.

Data AnalysisPower BIGoogle ColabExcel, Other

Overview

The work analyzed public healthcare financing, disease mortality, and survey datasets to compare funding models and outcomes across geographies. The student identified and documented the WHO Global Health Expenditure database, cleaned and normalized multiple CSVs in Google Colab with pandas and NumPy, and produced EDA visuals and written interpretations. The deliverables included cleaned Colab

TruBridge Healthcare Data Analytics Externship

What I've accomplished

I delivered cleaned, normalized datasets and Colab notebooks, a data quality report, EDA charts with written interpretations, a linear regression showing a strong positive correlation (r=0.94, R²=0.96, p<0.001) in AskCHIS, and an interactive dashboard comparing heart disease by insurance type (2009–2014).

Project breakdown

View all work

✅ Verified by Extern · ⏱️ In progress

Healthcare Operations & Consulting Externship

This externship explores how care coordination work in acute mental health settings can be designed, analyzed, and communicated as a customer-centric operational system. Externs study the case manager’s role at IMH to understand how workflows shape patient experience, surface hidden risks, and make invisible coordination work visible. Through structured analysis, process mapping, and dashboard prototyping, externs learn how operational clarity supports continuity of care, safety, and institutional decision-making.

Stakeholder MappingSystems ThinkingProcess MappingChange Management

Overview

The externship analyzed care coordination work at the Institute of Mental Health, mapping workflows and producing analytic artifacts for operational clarity. The work combined process mapping, structured analysis, and dashboard prototyping to make coordination activities visible. Deliverables included workflow maps and analytical findings about coordination bottlenecks.

Healthcare Operations & Consulting Externship

What I've accomplished

I produced workflow maps and a scope-of-work spreadsheet that detailed a case manager's daily responsibilities and surfaced fragmented records, high caseloads, and administrative pain points.

Project breakdown

The module summarized a case manager's situation, tasks, workflows, and pain points. I mapped daily responsibilities (discharge coordination, risk surveillance, documentation, crisis response) and produced a spreadsheet scope-of-work showing fragmented records, high caseloads, and administrative…

Google Sheets
Access

I identified that patients received no follow-up after cardiac discharge, mapped contributing factors across people, processes, materials, machines, measurements, and environment, and traced deeper causes with a Fishbone and 5 Whys to show coordination and recordkeeping breakdowns.

Google Docs
Access
View all work