top of page

Jack Song - Business Anylist

Business Analyst with experience in Trading Model Development, Investment Banking, and Real Estate Consulting.

 

Specializes in quantitative analysis and professional communication.

Data Analysis and Visualization Tools:  Excel, Tableau

Programming languages: Python, R, SQL

Projects

Sep - Dec 2025

Los Angeles, CA

Quantitative Researcher

Jane Street

  • Developed an ensemble trading signal model combining AutoEncoder-MLP and XGBoost on 2.4M+ transaction records, achieving 12.6% improvement in Utility Score (consistency-adjusted return) through model diversification

  • Identified 30 black swan trading dates exhibiting 129x normal volatility through daily return distribution analysis and implemented date-level filtering to improve model stability

Sep 2024 - Apr 2025

Orlando, FL

Commodity Hedging Analyst

Disney

  • Developed a 12-month horizon natural gas price prediction model with an average error rate of 10.26% and achieved savings of $2.5M compared to future-based procurement approach

  • Identified 6 key drivers associated with long term price trends and expanded project scope by developing time series and linear models to predict 1- to 12-month horizons, and supporting risk management and hedging strategies

  • Conduct trend analyses by processing 1M+ records of daily energy spot and future prices from EIA and CME across natural gas, crude oil, and coal, spanning 10 years

  • Facilitated Agile-style collaboration through whiteboard sessions and sponsor meetings, aligning data strategies with business needs while documenting cloud-based workflow roadmap and weekly timeline to enhance transparency and engagement

Experience 

Jun 2025

New York, NY

Finance Training Program

Eastdil Secured

  • Developed a dynamic DCF model with IRR sensitivity tables using Excel functions (What-If Analysis, INDEX-MATCH, VLOOKUP) to evaluate 10-year investment returns across multiple exit scenarios

  • Built a 360-month loan amortization schedule for a $90M acquisition, modeling monthly principal/interest allocation, balloon payments, and debt paydown under a 60% LTV structure

Dec 2021 - Sep 2023

Shenzhen, China

Consultant

BlackHills

Provided end-to-end real estate consulting services to corporations for property usage, acquisition, and investment in collaboration with multiple departments within the company

  • Created reports with analysis supported by company-owned data and insights towards market for companies including landlords and clients, securing an 83% retention rate and over 20 new client connections built

  • Customized financial/non-financial comparisons and strategies for site selection, attracting a diverse clientele across retail, finance and TMT industries, securing a profit of $500K and projecting future business development worth $1.2M

  • Navigated office setup for an insurance firm in a REIT project, achieving 50% cost savings through extensive research

Aug - Nov 2021

Shenzhen, China

Investment Banking Intern

China Merchants Securities

Conducted IPO due diligence for a lithium battery equipment manufacturing company with $33M in annual revenue and built a long-term client relationship with an electric automotive battery and car manufacturer

  • Investigated unusual transaction for 110+ personal bank statements among 10+ senior management and arranged meetings for discussion as needed to reduce the risk of inquiries from regulators

  • Prepared the prospectus by screening over 50+ companies to identify those with comparable business and gathered policy documents related to issuance

  • Analyzed 1,000+ SMEs in the Maker in China project and visualized findings in Excel to support client targeting

Education 

Aug 2024 - Dec 2025

Florida, FL

University of Florida, Warrington College of Business

Master's degree, Business Analytics

Awards:

Baldwin, Little, Sun & Wu Sunshine Scholarship

Sole recipient (Class of 2025) 

Relevant Courses:

Financial Accounting, Data Analysis, AI & Machine Learning

Jul 2025

Lyon, France

Emlyon Business School

Summer Exchange, Strategic Branding Management

Sep 2017 - Jun 2021

Guangzhou, China

South China University of Technology

Bachelor's degree, Engineering

Relevant Courses:

Engineering Economics, Project Management

Certificate

New_Bloomberg_Logo.svg.png

Bloomberg Market Concepts

Certificate of Completion, November 2nd 2025

Citi.svg.png
forage-schema-logo.png

Investment Banking Job Simulation

Certificate of Completion, July 3rd 2025

Wharton-Logo.png

Lending, Crowdfunding, and Modern Investing

Certificate of Completion, March 26th 2024

Wharton-Logo.png

Application of AI, InsurTech, and Real Estate Technology

Certificate of Completion, March 4th 2024

© 2025 by Shangyue Song. 

  • Email icon
  • LinkedIn
bottom of page