• Organized career resources and posted blogs to promote career education for business school students• Coordinated and managed CSE newsletter, ensuring timely delivery of information to business school students and alumni• Proficiently managed and maintained the Business School student resume database on Handshake, resulting in improved data quality and user satisfaction• Conducted comprehensive industry research to curate and organize career resources for Business School students• Actively engaged with alumni across various industries, fostering a robust network and leveraging their expertise to provide students with valuable networking resource

• Assisted professor with lecture material and graded students’ assignments and group projects• Addressed student questions during office hours regarding database design using SQL, data visualization with R coding

• Constructed market capitalization-weighted cryptocurrency portfolios using Python, and integrated them with traditional assets to evaluate effects of incorporating cryptocurrencies into portfolio construction strategies• Clarified discrepancies in performances of different cryptocurrency portfolios via utilizing Power BI to visualize and analyze cryptocurrency market trends, enhancing team decision-making efficiency by 40%• Reduced overall portfolio risk exposure by 30% through proactive monitoring of key performance metrics, including return, volatility, Sharpe ratio, CVaR, and skewness, substantially improving portfolio resilience• Forecasted portfolio outcomes via Monte Carlo Simulations and evaluated risk tolerance within budget management framework, ensuring adherence to financial objectives

• Assisted in interim audit for Country Garden, one of China’s top three real estate firms; leveraged SAP to prepare six-month working papers on financial expenses, accounts payable, and accounts receivable• Increased audit preparation efficiency by 50% by utilizing SQL and VLOOKUPs to extract data from original financial statements of 80 subsidiaries, streamlining working paper construction in Excel• Identified and resolved AP/AR discrepancies through detailed reconciliations and proactive communication with clients, guaranteeing accuracy and prudence of financial statements• Resolved compliance issues by organizing subsidiaries’ shareholding structure to clarify abnormal controlling relationships

• Conducted field research with team on 17 urban villages in Shenzhen to explore impact on urban development• Established econometric models to quantify influencing factors of population distribution and mobility and industrial development in urban village

• Monitored daily profit and loss and conducted reconciliations of fund transactions, ensuring accuracy and completeness of cash balances, investment positions, and other financial data for investment funds• Evaluated and verified Net Asset Value (NAV), Return on Equity (ROE), and Internal Rate of Return (IRR), and provided quarterly fund performance reports to management and clients, delivering insights on over 30 investment portfolios• Conducted thorough reviews of waterfall calculations to achieve accurate distribution of financial gains and dividends to both clients and internal teams, maintaining compliance with accounting standards and fund agreements