J

H

Work

About

Resume

J

H

Work

About

Resume

J

H

Data Analyst
Data Analyst

Jonathan He

Jonathan He

insightful

stakeholder-focused

storytelling

Data Analyst

Jonathan He

insightful

stakeholder-focused

storytelling

insightful

stakeholder-focused

storytelling

Canvas Database

Canvas Database

Canvas Database

Creating a Database Based on UT Austin's Canvas System

Database Designer

Created a database schema, a MySQL database with 50 rows of simulated data, and over 12 advanced SQL queries to mirror UT Austin's Canvas system.

Global Safety Dashboard

Global Safety Dashboard

Global Safety Dashboard

Interactive Data Dashboard

Data Visualizer & Storyteller

Built an interactive Tableau dashboard from a Kaggle dataset spanning 236 global regions and 19 socioeconomic factors to visualize global safety.

USCIS Citizenship Resource Center

United States Citizenship and Immigration Services

Data Analyst & Information Architect

Analyzed 52,000+ rows of metadata and 15,000+ user reports to identify problems and present data-driven findings to improve USCIS's website's information architecture and content findability.

USCIS Citizenship Resource Center

USCIS Citizenship Resource Center

United States Citizenship and Immigration Services

Data Analyst & Information Architect

Analyzed 52,000+ rows of metadata and 15,000+ user reports to identify problems and present data-driven findings to improve USCIS's website's information architecture and content findability.

BevoAdvisor

BevoAdvisor

BevoAdvisor

Course Recommender Chatbot

Relational Database Manager

Designed and tested a Voiceflow-powered course recommender chatbot for UT Austin students. Managed backend student data using Supabase.

WORK

ABOUT

RESUME