Skip to content

(01) Index

Madison, WI

I find the story in the spreadsheet.

Now

  • Taking Real Estate Finance this semester
  • Building multi-agent underwriting at TAM
  • Extracting genes from 500+ papers at the Mandel Lab
  • Choosing the next Badger Book Club read

I’m a senior at UW–Madison studying Data Science and Economics. I’ve always been drawn to work that makes a real difference, which is how I found my way to where real estate, finance and AI meet. I like simple tools that help people decide with more confidence.

(02) Work

Selected work.

  1. 01Sunrise Senior LivingJun – Sep 2026A multi-agent platform that ranks 241 senior living communities by capital need.Asset Management Intern
    (01) Sunrise Senior Living2026

    Asset Strategy

    • Portfolio Rankings
    • Admin

    Portfolio Rankings

    Where capital investment is most needed, and where it has the most room for impact.

    75–100

    Highest priority

    50–74

    Moderate

    25–49

    Lower

    0–24

    Recently invested

    Active communities

    241

    Portfolios

    20+

    Historical CapEx

    $943.6M

    Annual CapEx ranked

    $150–160M

    #CommunityCompositeAsset needFin. & growthMarket
    1Community APortfolio 0791948288
    2Community BPortfolio 0286799084
    3Community CPortfolio 1181887076
    4Community DPortfolio 0477718372
    5Community EPortfolio 0772766174

    Illustrative recreation · not real data

  2. 02TAMAug 2025 – nowMulti-agent underwriting workflows that turn raw property data into acquisition models.Early-stage startup
    (02) TAM2025
    Analyst WorkspaceCompany A ▾Quarterly ▾Adjusted ▾New analysisExport pack

    Executive Overview

    Last refresh 9/14/2026, 4:12 PM

    $128.4M

    8.8× Adj. EBITDA

    Revenue (LTM)

    $64.2M

    vs last run +3.8%

    Reported EBITDA (LTM)

    $13.9M

    vs last run +2.1%

    Adjusted EBITDA (LTM)

    $14.6M

    vs last run +3.4%

    Adjustments % of EBITDA

    5.0%Green

    vs last run +0.4ppt

    Avg. NWC (LTM)

    $0.8M

    vs last run +1.6%

    EBITDA → OCF conversion

    52%Amber

    vs last run +2ppt

    Revenue growth YoY / QoQ

    5.1% / 4.2%

    vs last run +0.9ppt

    Overall deal risk

    4.2 / 10Amber

    vs last run −0.3

    Revenue & Adjusted EBITDA trend

    Adjusted EBITDA bridge

    Illustrative · not real data

  3. 03KHC HousingJun – Aug 2025Acquisition and development models that helped secure $3.2M in construction financing.Summer Financial Analyst Intern
    (03) KHC Housing Company2025
    KHC Housing — Development ModelBase case

    Residential units

    72

    Location

    Mumbai

    Total project cost

    $5.4M

    Construction financing

    $3.2M

    Capital stack$5.4M total
    Construction financing · $3.2M
    Other sources · $2.2M

    Quarterly net cash flow

    ScenarioIRRNPVMargin
    Downside13.1%$0.4M14%
    Base18.6%$0.9M21%
    Upside23.4%$1.4M27%

    IRR sensitivity · sale price vs. build cost

    −5% costBase+5% cost+5% price22.9%21.0%19.2%Base20.4%18.6%16.8%−5% price17.8%16.1%14.3%
    AssumptionsCash flowDCFScenariosTerm sheet

    Model outputs illustrative

  4. 04Research Data AnalystSept 2025 – nowA RAG pipeline that extracts gene information from 500+ research papers, with sources.Mandel Lab · UW–Madison
    (04) Mandel Lab, UW–Madison2025

    Progress

    • ✓Search
    • ✓Pull & screen
    • ▸Review
    • ✓Saved
    Send feedback

    3. Review

    To review (8)Accepted (4)Rejected (8)All (20)
    ›  How the criteria work
    PMIDPDFWhyTitleYearReview
    4090…PDFVF✓ Gene✓ Orig✓ Eco✓ Colonization factors in a squid–vibrio symbiosisOkafor L et al.2025Undecided
    4124…PDFVF✓ Gene✓ Orig✓ Eco✓ Strain-level host responses to symbiont originLindqvist A et al.2025Undecided
    4146…PDFVF✓ Gene✓ Orig✓ Eco✓ Transposon screens across V. fischeri isolatesMoreau P et al.2025Undecided
    4077…VF✓ Gene✓ Orig✓ Eco✓ A dual-colour reporter for symbiont gene expressionHaddad R et al.2025Undecided
    4153…VF✗ Gene✗ Orig✓ Eco✓ Developmental responses of a host to ocean warmingTanaka S et al.2025Undecided

    Illustrative · papers not real

  5. 05California HousingAug 2025A time-series look at California housing and a policy brief on the supply gap.Independent project
    (05) Independent2025

    House prices since 1975

    % change, FHFA all-transactions house price index

    Redrawn from FHFA data · approximate

(03) Method

How I think.

  1. A percentage divided by something close to zero will say whatever it likes. Before I trust a ratio, I look at the raw dollars underneath it.

    Evidence: Flow-through rebuild, Sunrise →

  2. Most analysis gets easier once the data has the right grain. Turning one row per project into one row per community is what made the whole CapEx comparison possible.

    Evidence: CapEx investment case, Sunrise →

  3. A score nobody can argue with is a score nobody will use. Every ranking I build comes with the reasons behind it.

    Evidence: CapEx prioritization platform →

  4. When a model summarizes 500 papers, the useful part is knowing which paper said what. If I can’t trace a fact back, I don’t ship it.

    Evidence: RAG pipeline, Mandel Lab →

  5. A senior living community is somebody’s home. The spreadsheet is a way of taking care of it, not the point.

    Evidence: Summer at Sunrise →

(04) Log

The changelog.

11 entries shown

  1. 2026.08PublishedIn Praise of a Little Friction Essay on Substack
  2. 2026.06JoinedSunrise Senior Living, Asset ManagementBuilt a CapEx prioritization platform across 241 communities
  3. 2026.03UnderwroteThree multifamily acquisitions, Project DestinedReal estate private equity program; pitched to industry executives
  4. 2025.09JoinedMandel Lab, UW–Madison, as Data AnalystRAG pipeline over 500+ research papers
  5. 2025.09FoundedBadger Book ClubPresident; 20+ members and a five-person board in the first semester
  6. 2025.08StartedTAMMulti-agent underwriting for acquisition due diligence
  7. 2025.08JoinedBadgerYogis as Social ChairOutdoor flows, yoga-and-journaling nights, midterm stress relief
  8. 2025.08ShippedCalifornia housing analysisZillow + FHFA time series and a policy brief
  9. 2025.08LaunchedA Substack Essays on people, connection and culture
  10. 2025.06JoinedKHC Housing Company, MumbaiModels behind $3.2M in construction financing
  11. 2024.08StartedUW–MadisonB.S. Data Science and Economics, class of 2027

(05) Writing

Notes on people.

Essays on people, connection and the places we share, on Substack. About SourceSubstack analyticsMonthly views, as of the previous site. views a month. Read more ↗

(06) About

The short version.

I study Data Science and Economics at UW–Madison. The work I like best starts with a messy spreadsheet and a question someone keeps asking, and ends with a number people can actually use.

Most of that work has been in real estate: underwriting multifamily deals, modeling a 72-unit project in Mumbai, and this summer ranking capital needs across a senior living portfolio. Around that, I built the monthly financial review decks property owners saw, turning occupancy, NOI and labor trends into a few clear takeaways, and owned a series of analyses that fed real decisions: rebuilding a flow-through view that was telling the wrong story, sizing the downside when new competitors move in, matching communities to pricing strategies, and turning a 60-page management agreement into a tracker an asset manager could use.

Outside of class I run a book club, plan events for a yoga club, and write essays on Substack about people and the places we share.

Education

University of Wisconsin–MadisonB.S. Data Science and Economics · Aug 2024 – May 2027

Modeling

Financial modelingReal estate underwritingDCF & IRRForecastingBudgetingMarket analysisExcel (advanced)

Code

Python (pandas, NumPy, Matplotlib)SQLPostgreSQLGit

AI

LangChainAgentic AIRAGAmazon Bedrock

Reporting

Power BIPower QueryTableauPowerPoint

Coursework

Real Estate FinanceAI in Real EstateReal Estate Excel ModelingFinancial AccountingMachine LearningSQL DatabasesProbability & StatisticsLinear AlgebraAdvanced Micro & Macro Theory

Certificates

Wall Street Prep — Real Estate Financial ModelingCS50 — Databases with SQLPython — 20 Real-World Applications & AI AgentsMicrosoft Power PlatformMicrosoft Excel (with Honors)

Clubs

Badger Book Club — PresidentBadgerYogis — Social ChairReal Estate ClubRho Epsilon IotaCS NESTProduct Management ClubEconomics Student Association

Off the clock

Certified yoga teacherStrength trainingBadmintonCooking new recipesWriting on Substack