Resume
Zetian Tao · Los Angeles, California, United States
Loyola Marymount University
Bachelor of Business Administration
Finance + Information Systems and Business Analytics
Activities: Secretary, Students and Scholars Association; International Business Society; Lion Investing Society; Finance Society
Shanghai American School
High school
Experience
-
Demand Forecasting & Production Planning Intern, Jiaxing Xinchengda Fashion Co., Ltd.
Jun 2023 – Present · Jiaxing, China
- 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.
- Cut demand-forecast error by 3.6% WAPE vs. the incumbent exponential-smoothing baseline across 194 SKUs, sharpening inputs for production volume, by training a LightGBM model on order history.
- Equipped the VP of Operations to evaluate expansion into Vietnam, Bangladesh, and 3 other markets by benchmarking 20+ garment manufacturers on labor cost, tariff exposure, and lead time in a side-by-side risk and tradeoff comparison.
-
Compliance Intern, Guardian Regulatory Consulting Limited
May 2026 – Aug 2026 · Hong Kong
- 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.
- Designed automation for the monthly FRR liquid-capital return, projected to cut 30 minutes of manual work per filing, by prototyping a Python tool on synthetic data that applies SFC haircuts and tests the HK$3m minimum and 120% early-warning threshold.
-
Dealing Intern, Tiger Brokers
Jul 2025 – Aug 2025 · Hong Kong
- Translated equity research on NVIDIA, BYD, and Chalco into 3 client-facing infographics for a retail audience with no finance background.
- Pitched an independent long thesis on Chalco to the asset management team, backed by a DCF and comps model built in Excel, and stress-tested the two risks most likely to break it.
-
Investment Banking Intern, Guotai Junan Securities
Jul 2024 – Aug 2024 · Shanghai, China
- 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.
-
Intern, Apex By Bybit
Jun 2024 – Jul 2024
- 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.
- Screened five small-cap digital assets on NVT and MVRV ratios, tokenomics, and wallet growth, then tested sentiment and momentum against what was already priced in and issued a Buy or Hold call on each.
Finance skills
- Financial modeling (DCF)
- Comparable company analysis
- Equity research
- Financial due diligence
- Valuation & financial statement analysis
Technical skills
- Excel
- Bloomberg
- Python
- pandas
- Matplotlib
- SQL (MySQL, PostgreSQL, SQLite)
- NumPy
- Jupyter
- REST APIs
- Data ingestion / ETL
- Data validation & governance
- Relational database design
- GitHub & Codespaces
- Railway
- Azure VMs
- Cloudflare DNS
Languages skills
- Mandarin Chinese (professional)
- English (native)
Analytics skills
- Demand forecasting (LightGBM, exponential smoothing)
- Regression
- Event studies
Certifications
-
Intermediate Python
-
Introduction to Data Visualization with Matplotlib
-
Bloomberg Spreadsheet Analysis (BQL)
Bloomberg
-
Bloomberg ESG
Bloomberg
-
Joining Data with pandas
-
Bloomberg Market Concepts
Bloomberg
-
Bloomberg Finance Fundamentals
Bloomberg
-
Microsoft Office Specialist: Excel Associate
Microsoft