Data Science & Economics · UC Berkeley
I’m
Tristan.
I am a designer, researcher, student, teacher.
Selected work
BD3D: 3D Egyptian Coffin Research Viewer
Read six ancient coffins in 3D: 314 scholarly annotations linked to 607 surface regions, raking light, word-to-location links, and a compressed asset pipeline that cut downloads by 74%.
Next.js · TypeScript · React Three Fiber · three.js · glTF · Playwright
K–12 Sustainability Evidence Retrieval
Hybrid lexical + neural search over 10,000+ district pages and policies. Recall@5 +35%, manual source discovery −76%.
Python · BM25 · Sentence Transformers · CrossEncoder
California Home Value Estimator
Predicts California home sale prices from property and location data, with an explanation for every estimate.
7.7% median error on 11,900 held-out sales
Python · XGBoost · scikit-learn · GeoPandas · Streamlit
Predicting 3D Reconstruction Quality
Early structure-from-motion signals predict final scan quality: 13.7% lower geometric RMSE than a reprojection-error baseline.
Python · Agisoft Metashape · Ridge regression
Spotify Analytics Platform
Spotify OAuth ingest of 1,000+ tracks and 50+ artists, listening analytics, and content-based recommendations via audio-feature cosine similarity.
TypeScript · Node.js · FastAPI · PostgreSQL · Pandas · Tableau
Experience
Sep 2026 – Present
Archaeological Research Facility, UC BerkeleyBerkeley, CA
Read the case study →Undergraduate Research Assistant
- Built the BD3D research viewer (Next.js, TypeScript, React Three Fiber), linking 314 scholarly annotations to 607 surface regions across 6 photogrammetric Egyptian coffin models, with two-way selection, raking-light inspection, and collection-wide search.
- Designed a compressed 3D asset pipeline (meshopt glTF, tiered textures, checksummed provenance) that cut exhibit downloads by 74% (82 MB to 21 MB across six coffins) and geometry parsing from 82–132 ms to 2–3 ms.
- Built a structured annotation data pipeline with schema validation, replacing manual XML lookup; 127 automated tests run in CI.
- Lead the incoming URAP students and the design team.
Sep 2026 – Present
Ten StrandsBerkeley, CA
Read the case study →Data Research Intern
- Built an NLP retrieval system combining BM25, dense transformer embeddings, and a sentence-transformers CrossEncoder reranker over 10,000+ California K–12 district webpages and policy documents.
- Benchmarked lexical and neural retrieval on human-validated evidence (Recall@K, MRR): Recall@5 up 35%, manual source-discovery time down 76%.
May 2026 – Aug 2026
IDX ExchangeRemote
Read the case study →Data Science Intern
- Built a model that estimates California single-family sale prices from 309K cleaned CRMLS sales (Jan 2024 – Apr 2026), adding location, property-age, and school-district features via a spatial join across 680 districts.
- Evaluated chronologically with leakage rules: the final XGBoost model reached 7.7% median error on 11,890 held-out April 2026 sales, versus 16.5% for a linear baseline.
Aug 2025 – May 2026
Lucarelli Photogrammetry Lab, UC BerkeleyBerkeley, CA
Read the case study →Undergraduate Research Apprentice
- Built an automated Python photogrammetry pipeline (Agisoft Metashape API) processing 1,000+ images into 3D reconstructions, cutting manual processing time by 40% (~30 → ~18 min each).
- Developed Ridge regression models on SfM and image-overlap graph features to predict reconstruction quality: 13.7% lower geometric RMSE than a reprojection-error baseline, with leakage-aware cross-validation.
Aug 2025 – PresentJan 2026 – May 2026
Berkeley ANova
Computer Science Mentor
- Teach Python weekly to 100+ high school students.
Marketing Officer
Jan 2025 – May 2025
Goldman Sachs
Possibilities Summit
Aug 2024 – Feb 2025
Rose Water CapitalUnited States
Business Consulting Intern
Feb 2023 – May 2024
Shaolin Temple Cultural Center
Martial Arts Coach
Education & skills
University of California, Berkeley
B.A. Data Science & Economics
Expected May 2029 · GPA 3.88
CourseworkMicroeconomics, Probability and Statistics for Business, Foundations of Data Science, Computational Structures in Data Science, Linear Algebra
Languages
- Python
- SQL
- JavaScript
- TypeScript
- HTML/CSS
Frameworks & tools
- React
- Next.js
- FastAPI
- PostgreSQL
- Supabase
- MongoDB
- Git
- Vercel
- OAuth 2.0
- REST APIs
Data science & ML
- scikit-learn
- PyTorch
- Sentence Transformers
- OpenCV
- Pandas
- NumPy
- SciPy
- Matplotlib
- Tableau
About
I study Data Science and Economics at UC Berkeley (class of 2029). I like problems where a model or a tool is only half the job and the other half is making it useful to the people who rely on it: researchers, teachers, students.
Every week I teach Python to 100+ high schoolers as a Computer Science Mentor at Berkeley ANova. Explaining an idea to a room of fifteen-year-olds is the fastest way I know to find out whether I really understand it.