Yinan Zhao logoYinan Zhao Externship via Extern

Data-focused analyst shaping messy CSVs into usable dashboards

I build analytics databases and dashboards from messy data, using SQL and Claude to turn CSVs into business-ready insights.

View my workMessage Me

Work samples

Projects center on SQL database architecture and dashboarding, converting raw CSVs into analytics-ready data and visual reports for quarterly decisions.

  • Yinan Value Investing & Financial Modeling Externship
    Yinan Value Investing & Financial Modeling Externship
    Yinan Zhao logo

    Yinan Zhao · ✅ Verified by Extern · ⏱️ In progress

    Yinan Value Investing & Financial Modeling Externship

    Gain insider experience in value investing by analyzing leading stocks alongside seasoned investor Yinan Zhao. Learn how professionals leverage financial modeling in Excel, interpret alternative data, evaluate market trends, and craft persuasive investment recommendations. Build real-world skills essential for careers in finance, equity research, and investment banking.

    Investment AnalysisFinancial Statement AnalysisFinancial ModelingData AnalysisExcel

About me

I build analytics databases and dashboards from messy data, using SQL and Claude to turn CSVs into business-ready insights.

I am Asekho Toto. I started my career and am exploring a change in direction. I completed a SQL and database architecture externship with Breaking Games, where I turned six CSV files into an analytics database and built a Q4 dashboard using SQL and Claude.

Externships

Yinan Value Investing & Financial Modeling Externship

In progress

Experience

Receptionist

Fancourt, George · August 2025 – Present

Night Auditor | In Training

Fancourt, George · February 2026 – Present

Steward: Back of House

Fancourt, George · April 2025 – August 2025

Administration Assistant

Nelson Mandela University, George · February 2023 – December 2024

Education

Business Management Training College (BMT)

Diploma in Business Management (NQF Level 6) · Class of 2026

Nelson Mandela University, George

Higher Certificate in Business Studies (NQF Level 5) · Class of 2021

Business Management Training College (BMT)

Human Resource Management Fundamentals · Class of 2026

Business Management Training College (BMT)

Finance for Non-Financial Managers · Class of 2026

Skills

SQLDatabase architectureData cleaning from CSVsDashboard designWorking with Claude (AI assist)
Back to work
Yinan Zhao ↗

✅ Verified by Extern · ⏱️ In progress

Yinan Value Investing & Financial Modeling Externship

Gain insider experience in value investing by analyzing leading stocks alongside seasoned investor Yinan Zhao. Learn how professionals leverage financial modeling in Excel, interpret alternative data, evaluate market trends, and craft persuasive investment recommendations. Build real-world skills essential for careers in finance, equity research, and investment banking.

Investment AnalysisFinancial Statement AnalysisFinancial ModelingData AnalysisExcel

Overview

The externship involved hands-on financial analysis and modeling of public equities alongside guidance from Yinan Zhao. The work included building Excel models, examining alternative data sources, and producing investment write-ups for selected stocks.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I completed analyst-style work across research, modeling, and write-ups, applying Excel models and alternative data to evaluate candidate investments.

Project breakdown

View all work