Kyle Tran
Los Angeles office towers at blue hour

Kyle Tran

Specialties

Underwriting · Valuation · Portfolio Analytics · Automation

Degree
USC B.S. RED, Aug 2026
Most recent
Rexford Industrial
Certified
ARGUS Enterprise
Location
Los Angeles, CA
ResumeEmail

Experience

Full detail

Technology Intern, AI & Automation

Built Python pipelines that screened 1,600+ workbooks and consolidated 269 underwriting workbooks and 193 capital approval records across a 409-property portfolio, saving analysts 3–5 hours of prep each week.

Contact

LinkedInGitHub
© 2026 Kyle Tran
EmailLinkedInGitHub
kyletristentran@outlook.com
Web Portfolio · Los Angeles
View ProjectsResume (PDF)
USC B.S. Real Estate Development, Aug 2026

Kyle Tran — Web Portfolio

USC B.S. Real Estate Development, August 2026 · Los Angeles

Case Studies Resume (PDF)

Selected Work

Underwriting and market work from USC coursework and internships, and the systems I built around it.

Concept masterplan render of the Cité Vivante district

Featured case · USC RED 469 · Spring 2026

Cité Vivante

Sanofi walked away from a 16.2-hectare R&D campus south of Paris. The sponsor’s filed plan keeps the labs and swaps offices for industrial flex; this is the independent counter-case: exit the impaired office, retain the irreplaceable wet-lab platform, and add the neighbourhood the campus never had.

  • 16.2 ha7 parcels · 2 communes
  • 32,000 m²wet lab retained
  • 350–500homes proposed
  • 11field meetings in Paris
Read the investment case
Southern California Industrial Portfolio Acquisition

Southern California Industrial Portfolio Acquisition

Underwriting | $61.8M, two assets, 10-year hold (2024)

Acquisition underwriting for two Southern California industrial assets: 10-year DCF, market comps, debt structure, and a 13.2% LP IRR at a 2.27x equity multiple. The cash-flow model behind the resume line.

DCFExcelMarket CompsDebt Structure
View Case Study
Schema of the pro forma version-control ledger: run registry, run records, field change log, deal snapshot

Pro Forma Standardization and Version Control

Systems | Budget-approval workbooks, prototype (2026)

A budget-approval pro forma arrives as a workbook and every sponsor lays it out differently. This prototype reads only the elected strategy, maps line items through alias tables, and writes each upload to a version-control ledger with a field-level diff. Built on fictitious data; the problem came from my Rexford Industrial internship.

Office ScriptsPythonDataversePower Automate
View Repository

Experience

Five Los Angeles real estate firms since 2023. Role-by-role detail is on the Experience page.

FirmRoleDatesWork
Rexford Industrial Realty (NYSE: REXR)Technology Intern, AI & AutomationJun–Aug 2026Python pipelines that screened 1,600+ workbooks and consolidated 269 underwriting workbooks and 193 capital approval records into one reporting database across a 409-property portfolio; 3–5 hours of manual prep saved per analyst each week.
MRK PartnersPortfolio Analyst InternOct 2024–May 2025Monthly portfolio reporting and budget variance across a 25-asset multifamily portfolio; T12 recoding and utility anomaly flags; quarterly bond-covenant reporting presented to the CFO.
CBRE Capital MarketsCapital Markets FellowSpring 2025Capital stack and debt-structure case work on $500M+ of transactions; 15 financing structures with 12–25% IRR waterfalls.
PMI PropertiesAnalyst, Multifamily Acquisitions & Asset ManagementJan–Oct 2024Due diligence on 3 acquisitions totaling $45M; cap rates checked against CoStar comps; cash flows in ARGUS Enterprise.
Lever Capital PartnersFall Analyst, Capital MarketsAug–Dec 2023$100M+ of debt transactions across 12 deals; 1,000+ entry lender database.

Skills and Tools

ARGUS and Excel for the modeling, Python and SQL for the reporting around it. Automation only where it can be validated and traced back to source.

ARGUS
Enterprise v23
Certified; lease-by-lease cash flow modeling
Excel
Financial Modeling
DCF and waterfall models, Power Query, VBA
Python
Data Engineering
ETL pipelines, SQL, Power BI reporting
Automation
Workflow Tooling
Claude, Copilot Studio, Power Automate; validation and audit trail

Core Technical Skills

Real Estate & Finance

  • ARGUS Enterprise (Certified)
  • DCF & Waterfall Modeling
  • CoStar & Yardi
  • Excel (Power Query & VBA)
  • T12 & Bond-Covenant Analysis

Data & Analytics

  • Python (Pandas, NumPy)
  • SQL
  • Power BI & Tableau
  • ETL Pipeline Design

Automation

  • LLM workflows with review and citation controls (Claude)
  • MCP (Model Context Protocol)
  • Microsoft Copilot Studio & Power Automate

Web & Systems

  • React & Next.js
  • HTML/CSS/JavaScript
  • PostgreSQL & Supabase
  • Git & GitHub

Education & Credentials

USC degree, ARGUS Enterprise certification, and California real estate license

University of Southern California

B.S. Real Estate Development
Sol Price School of Public Policy
August 2026

Credentials

ARGUS Enterprise v23, Certified
California DRE Sales License #02235838
A.CRE Financial Modeling

Contact

Email LinkedIn GitHub Resume