Financial Economics · Johns Hopkins University

Finance.
Colorfully.

I'm Yan — a financial economist who builds data pipelines, credit models, and dashboards that actually get used. From fixed income research desks to consulting engagements, I turn complex data into clear decisions.

4.0
GPA at JHU
2
Degrees (Finance & Law)
4
Internships
4+
Projects
DC
Based in
3
PRs Merged (HARK)
01

Selected Work

📊
Data Visualization · State Street
Power BI KPI Dashboards
Designed and maintained management-ready KPI dashboards integrating multi-source operational datasets. Built for senior leadership to support resource allocation and cross-regional transparency.
Power BI Tableau Multi-Source Data KPI Design
🔁
Data Engineering · State Street
Data Pipeline & Automation
Built end-to-end data capture and aggregation pipelines in Python and SQL, consolidating 600+ operational checklists into a centralized database. Reduced processing time and improved data quality by ~30%.
Python SQL ETL Automation
🏦
Fixed Income Research · Huatai Securities
Infrastructure Bond Analysis
Constructed SQL pipelines converting 100+ regulatory announcements into structured event indicators. Assessed policy shock impacts on bond yields using event-study comparisons with robustness checks.
SQL Event Study Fixed Income Credit Analysis
🧮
Quantitative Finance · Project
Credit Application Scorecard
Developed a credit underwriting scorecard using logistic regression with WOE/IV variable selection. Parsimonious 6-variable model across three dimensions — achieved KS = 0.33 on validation.
Python Logistic Regression WOE/IV Scorecard
📉
Econometrics · Research
Derivatives & Firm Value
Built a 14-year panel of 3,847 China A-share firms (61,883 observations). Estimated fixed-effects regressions linking derivatives use to firm value; found stronger valuation effects among SOEs.
Stata Panel Data PSM Fixed Effects
💻
Open Source · Econ-ARK / HARK
Computational Economics
Reproduced a convergence bug in heterogeneous-agent consumption-saving models. Submitted three merged pull requests to the Econ-ARK / HARK toolkit using Python dynamic programming.
Python Dynamic Programming Git Open Source
02

My Setup

Languages
Python · R · SQL · Stata
Finance Tools
Bloomberg · Wind · Excel · EViews · PowerPoint
Visualization
Power BI · Tableau · ggplot2 · matplotlib
Methods
Panel Econometrics · Time Series · Credit Risk · CGE
Education
M.S. Financial Economics · JHU | B.A. Finance & B.Laws · SDU
Currently
Open-source contributor · Econ-ARK / HARK
03

About Me

I'm Yan (Color) He, a graduate student in Financial Economics at Johns Hopkins University with a 4.0 GPA. I hold a dual degree in Finance and Law from Shandong University and spent a semester at UC Santa Barbara studying statistics and mathematical finance.

My experience spans data engineering at State Street, consulting at Huron, fixed income research at Huatai Securities, and ESG research at the Institute of Green Investment. I've built everything from operational data pipelines to credit scorecard models to investment memos.

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

Beyond the spreadsheets — I'm drawn to photography, writing, and calligraphy. I think the patience and precision in brushwork translates well to how I approach data and modeling.

  • Financial Modeling & Valuation
  • Python / Data Analysis
  • SQL & Data Pipelines
  • Power BI / Dashboards
  • Econometrics (Panel / TS)
  • Fixed Income & Credit
04

Experience

Jan 2025 — Jul 2025
Analytics & Operations Intern
State Street · Global Delivery · Hangzhou
Built data pipelines consolidating 600+ checklists, designed Power BI dashboards for senior leadership, and delivered process risk assessments across business functions.
Oct 2025 — Feb 2026
Consulting Analyst Intern
Huron Consulting Group · Washington, DC
Supported consulting engagements through structured research, financial analysis, and client-ready deliverables including reports, frameworks, and slide decks.
Jun 2024 — Aug 2024
Fixed Income Research Intern
Huatai Securities · Infrastructure Bond Dept. · Shanghai
Built pricing models, constructed SQL data pipelines for regulatory data, and produced investment memos translating macro-fiscal dynamics into actionable insights.
Apr 2024 — Sep 2024
Exchange Student
UC Santa Barbara · Statistics & Mathematical Finance
GPA: 3.8/4.0. Coursework in statistics and mathematical finance.
Nov 2022 — Jan 2023
Research Assistant
Institute of Green Investment (IGI), CUFE · Beijing
Monitored ESG regulatory frameworks and authored a 5,500-word industry report on China's energy storage sector that reached 10,000+ readers and won Gold Prize nationally.
05

Education

Johns Hopkins University
M.S. Financial Economics
Aug 2025 — Present · GPA 4.0/4.0 · Washington DC
Shandong University
B.A. Finance (Banking & Securities) · B.Laws — Dual Degree
Sep 2021 — Jun 2025 · GPA 3.8/4.0 · Shandong
UC Santa Barbara
Exchange — Statistics & Mathematical Finance
Apr 2024 — Sep 2024 · GPA 3.8/4.0 · California

Let's connect.

Open to investment banking, research, and quant roles.