Hi, I'm Zetian.

I study Finance + Information Systems and Business Analytics at Loyola Marymount University and live in Los Angeles.

This site is online

Self-hosted on an Azure Ubuntu VM, served over HTTPS by nginx, with a cached fallback if the database is down.

Loyola Marymount University

Bachelor of Business Administration · Finance + Information Systems and Business Analytics · Class of 2027

About me

I'm interested in both sides of a business: what the numbers say, and the systems that produce them. That's why I study Finance alongside Information Systems at LMU.

My internships run from IPO due diligence at Guotai Junan Securities and equity research at Tiger Brokers to demand forecasting at Jiaxing Xinchengda Fashion and data governance at Guardian Regulatory Consulting.

I went to high school in Shanghai before moving to Los Angeles for college, and I built and run this website myself on Railway with PostgreSQL.

Right now

Off the clock

Experience

Full details

Jun 2023 – Present

Jiaxing Xinchengda Fashion Co., Ltd.

Demand Forecasting & Production Planning Intern · Internship

Built a single source of truth for demand planning covering 10 years of order history by consolidating, cleaning, deduplicating, and standardizing records into an analysis-ready dataset.

May 2026 – Aug 2026

Guardian Regulatory Consulting Limited

Compliance Intern · Internship

Enforced data governance on client due-diligence records, surfacing 50 non-compliant files (missing fields, expired IDs, overdue reviews) across 5 accounts in 3 client reviews, with a rule-based Python (pandas) validation script mapped to SFC CDD requirements.

Jul 2025 – Aug 2025

Tiger Brokers

Dealing Intern · Internship

Translated equity research on NVIDIA, BYD, and Chalco into 3 client-facing infographics for a retail audience with no finance background.

Jul 2024 – Aug 2024

Guotai Junan Securities

Investment Banking Intern · Internship

Cleared an automotive power-electronics IPO candidate's financials for senior review by reconciling 4 balance-sheet and income-statement line items to SSE disclosure rules, flagging inconsistencies, and tracking open diligence items for the deal team.

Jun 2024 – Jul 2024

Apex By Bybit

Internship

Built the product pitch deck for a concentrated-liquidity AMM decentralized exchange on Mantle Network, making the market case from DeFi TVL and trading-volume data and diagramming L2 rollup architecture, fee mechanics, and governance flow.

Finance skills

Technical skills

Languages skills

Analytics skills

Career Platform (in progress)

This website, and a project in progress. A FastAPI and Jinja resume and portfolio site, built in GitHub Codespaces, run on an Azure Ubuntu VM with SQLite, and now on Railway with PostgreSQL. Pages read from the database on every request, with a cached profile if the database is down. It will grow into a career platform through the semester.

Visitor · HTTPS nginx → FastAPI SQLite Snapshot Azure Ubuntu VM

SEC EDGAR Data Pipeline & Earnings Analytics

A 7-script Python pipeline that pulls XBRL financials, 8-K earnings dates, and daily prices for 18 software companies plus the S&P 500 (SPY) from the SEC EDGAR API and Yahoo Finance into an indexed SQLite schema.

Get in touch

Zetian1212@gmail.com