Decision frameworks and analytical tools written from the trenches of real portfolio operations. Real code solving strategic problems in financial reporting, portfolio analytics, and operational efficiency.
A 10,000-unit operator replaced a weekly manual export workflow with a Next.js dashboard connected directly to their PMS API. Six automated cron jobs ingest availability, leasing activity, and financial data into a structured database on a defined schedule. Every team reads from the same source.
Read moreManual benchmarking forces single-dimension comparisons and takes hours per month. Automated GL mapping, cohort definition, and quartile calculation enable simultaneous comparison across market, size, and vintage peers in 30 seconds.
Read moreSynthesizing rent roll and availability data to track rent performance across four lease lifecycle stages, bifurcated by floor plan and renovation status. Reveals pricing effectiveness and revenue optimization opportunities invisible in source reports.
Read moreStandard economic occupancy reporting shows one number per month with no directional signal. Multi-period variance analysis decomposes losses into vacancy, concessions, and delinquency while tracking momentum across T1, T3, and T12 periods.
Read moreNew residents submitting work orders within days of moving in signal units weren't actually ready. We built a system measuring three metrics: work order incidence rate, early intensity, and total intensity to quantify make-ready quality across the portfolio.
Read moreBuilding monthly distribution schedules across 30+ properties requires aggregating data from balance sheets, GL mappings, and unposted invoices. Automation reduces 3-4 hours of manual work to 2 minutes while ensuring unposted payables are reserved against distributable cash.
Read moreWeekly leasing performance reporting requires aggregating 9 PMS exports, parsing competitor survey PDFs, and generating property-level snapshots with time series charts. Python extracts survey data, VBA refreshes dashboards, reducing 4-5 hours of Monday work to 10 minutes.
Read moreProperties averaging $20,000+ delinquency before filing eviction are waiting well past jurisdictional thresholds. Tracking status transitions reveals enforcement timing variance and distinguishes avoidable delays from unavoidable life events.
Read moreRenewal management runs manually across spreadsheets with no systematic way to identify which residents require retention intervention. Combining payment history, maintenance requests, violations, reviews, and tenure into likelihood scoring.
Read moreConstruction lender draws require verifying invoices against historical submissions and extracting individual PDFs from 1000-page bulk exports. Two scripts automate verification through vendor name normalization and regex-based invoice detection, reducing draw preparation from 5 hours to 30 minutes.
Read more