Bachelor in Financial Engineering. Currently a Cornell SC Johnson College of Business MS student majored in Applied Economics & Management, with internship experience in Investment Banking/PE/Industry & Investment Analysis.

Now I'm actively seeking Business Analyst | Strategic & Planning opportunities.
Feel free to reach out via email. I'd love to connect!

PUBLICATIONS

How do consumers' attitudes differ across their basic characteristics toward live-streaming commerce of green agricultural products: A preliminary exploration based on correspondence analysis, logistic regression and decision tree
Ying Wang, Jiahui Lan, Jialing Pan, Lin Fang
Journal of Retailing and Consumer Services | SSCI Top1 | 2024
Webpage

PROJECTS

Data Visualization of US Socioeconomics & Public Health Trends in R

- Created NYT-style county-level overdose maps (multi-panel layout)
- Built animated visualizations (GIF) from longitudinal datasets

Financial Modeling & Analytics Dashboards in Excel

- Financial Performance & Investment Analysis Dashboard
- Sales & Customer Analytics (CRM) Dashboard
- Financial Modeling & Optimization (Break-even & Product Mix)

Evaluation of the “Shared Community · Happy Life” Project in Wenzhou

- Designed and implemented a analytical framework combining Random Forest, SEM, and Sentiment Analysis.
- Processed and analyzed survey data to evaluate community service effectiveness.

Consumer Behavior Analytics in Live-Streaming E-Commerce

Applied MCA (relationship mapping), Logistic Regression (behavior prediction) and Decision Tree (consumer segmentation).

SKILLS

Programming

  • Python, R, Machine Learning, SQL
  • Excel (Advanced: modeling, dashboards, vlookup)

    • Econometrics

  • SPSS, Stata, Eviews
  • Applied Econometrics

    • Finance & Accounting

  • Commodity & Option
  • M&A and Advanced Financial Statement Analysis
  • ACCA 8/13, To be earned

    • Design & Video

  • Photoshop
  • iMovie

    • HONORS & REWARDS

    National Scholarship Recipient

    Top 0.1% in College of Business

    First Prize, Zhejiang 12th Undergrad. Statistical Survey Plan Design Competition

    Vice Team Leader

    Third Prize, Zhejiang Province Financial Innovation Competition

    Team Leader
    - Directed a team to analyze the root causes of Silicon Valley Bank's failure, focusing on asset-liability mismatch and interest rate risk.
    - Built analytical frameworks incorporating: 1) Interest rate sensitivity analysis 2) Asset-liability structure evaluation 3) Financial risk modeling (e.g., VaR, duration concepts)

    LEADERSHIP & INVOLVEMENT

    Minister, Academic Atmosphere & Science Department, Student Union

    - Organized the “Challenge Cup” Entrepreneurship Competition and coordinated 8+ academic and innovation events
    - Awarded Outstanding Student Leader and contributed to recognition as a Star Department

    Volunteer

    - "Internet+" Volunteer, Zhejiang Province | School Award Recipient
    - Conducted enterprise visits, delivered rural financial anti-fraud education, and supported elderly care programs.
    - Recognized as an Advanced Individual; 84+ service hours and 40,000+ words of reports.

    LIFE

    Active

    Badminton

    I've been playing badminton since junior high. It's my favourite way to stay active and recharge, and I still play almost every week.

    Rock Climbing

    A balance of trust, focus and pushing my limits.

    Through My Lens

    One-Legged Bird

    A small moment of balance and persistence

    City & Water

    Where urban life fades into calm water