Highlights:

Skills:

Risk Consulting Intern 08/2023 - 10/2023
KPMG China, Shanghai, China
Industry: Consulting
1. Learned investment product mechanics, built transaction and ledger reconciliations using innovative keys, performed deep dives into exceptions using SQL and advanced Excel functions (SUMIFS, VLOOKUP, SUBTOTAL) – resulting in over 90% of discrepancies reconciling quickly 2. Built a risk factor measurement system utilizing SQL to extract data and calculate valuation, profit/loss, and risk measurements, increasing the efficiency and effectiveness of the risk management process and enhancing data integrity and accuracy via automated controls built with IT
--

Hitotsubashi University 04/2020 - 03/2024
Tokyo, , Japan
Degree: Bachelor's Degree
Major:Finance
Bachelor of Science in Commerce & Management Overall GPA: 4.19/4.30 (U.S. 3.98/4.00), Rankings: 1/296 Awards: Hitotsubashi University Award for Student Excellence in 2021, 2022 & 2023 Relevant Coursework: Macro Finance, Mathematical Finance, Quantitative Analysis, Asset Management, Asset Valuation, Portfolio Management, Equity Investments, Alternative Investments, Derivatives, Risk Management, Cost Accounting

Yi Yao