Financial Economics · Johns Hopkins University

Finance.
Colorfully.

I'm Yan — a financial economist who believes data should be beautiful, models should be rigorous, and work should speak for itself. I build dashboards, financial models, and research that actually get used.

View My Work ↓ Get In Touch
4.0
GPA
2+
Internships
3+
Projects
DC
Based in
01

Selected Work

📊
Data Visualization
Power BI Dashboard
Interactive business intelligence dashboard built to surface operational insights. Designed for clarity — every chart earns its place.
Power BI DAX Data Modeling
View Project →
📈
Financial Modeling
Financial Model
A comprehensive financial model built from first principles. Forecasting, valuation, and scenario analysis — all in one rigorous framework.
Excel DCF Scenario Analysis
View Project →
🏦
Fixed Income Research
Fixed Income Research
Research produced during internship at a Chinese brokerage firm. Analysis of bond markets, yield dynamics, and macro implications.
Bloomberg R Fixed Income
View Project →
🧮
Quantitative Finance
Credit Scorecard Model
Logistic regression-based credit scorecard using Weight of Evidence and Information Value methodology. Academic project, production-grade rigor.
Python Logistic Regression WOE/IV
View Project →
🔁
Data Engineering
Data Pipeline (State Street)
Operational data pipeline work during internship at State Street. Automating data flows and improving reliability at scale.
SQL Python Operations
View Project →
📉
Econometrics
Panel Data Analysis
Fixed effects and panel data econometrics. Rigorous methodology applied to real economic questions — the kind of work that holds up to scrutiny.
R Fixed Effects Econometrics
View Project →
02

My Setup

Languages
Python · R · SQL
Finance Tools
Bloomberg Terminal · Excel
Visualization
Power BI · ggplot2 · matplotlib
Research
Fixed Income · Credit · Macro
Education
M.S. Financial Economics · Johns Hopkins
Currently Reading
Volatility surfaces · VIX dynamics
03

About Me

I'm Yan (Color) He, a graduate student in Financial Economics at Johns Hopkins University with a 4.0 GPA and a genuine obsession with making finance less grey.

My background spans fixed income research, data pipeline engineering, and quantitative modeling — from the trading desks of Chinese brokerage firms to the operational infrastructure of global asset managers.

I believe the best financial work is rigorous and communicable. A model no one understands is just noise. I build things that get used.

When I'm not in spreadsheets, I'm listening to Jay Chou, making perler bead art, and probably thinking about my next options trade.

  • Financial Modeling
  • Python / Data Analysis
  • Power BI
  • R / Econometrics
  • Bloomberg Terminal
  • Fixed Income Research

Let's connect.

Open to investment banking, research, and quant roles.

Email Me LinkedIn GitHub