Skip to content

Projects

A selection of financial models, automation systems, and analytical tools developed for real client engagements.

Client confidentiality preserved: all public examples use reconstructed or synthetic data while retaining the original methodology, architecture, and decision-making process.

01

Development Finance & Cash Control System

Real Estate Development - Hotel Expansion

Modeled a $20M+ villa development's ability to self-fund through construction, financing, and sale phases across a 3-year horizon.

A unit-level underwriting and cash management model integrating construction budgeting, cost allocation, financing, and profitability analysis.

Scale

  • 10 villas
  • $20M+ in sale proceeds
  • 3-year planning horizon

Technologies

ExcelFinancial ModelingScenario AnalysisCash Flow Planning

Review Project →

02

Financial Data Processing & Automation

PDF Transaction Extraction Pipeline

Automated extraction of 50,000+ transactions from 100+ monthly statements into structured, source-traceable data.

A Python pipeline that extracts, validates, and structures transaction data directly from PDF financial statements.

Scale

  • Multi-page financial statements
  • Source-level traceability
  • Structured transaction records

Technologies

PythonpandasPyPDFRegular Expressions

Review Project →

03

Embedded Finance & Payment Operations

Stripe Platform Fees Allocation Engine

Automated ~95% of a monthly payment-cost allocation process covering 13,000+ transactions, while preserving daily reconciliation controls.

An allocation engine that distributes Stripe fees and shared payment costs to individual transactions for accurate unit-level profitability.

Scale

  • 13,000+ transactions analyzed
  • 700+ fee lines assigned
  • 1.5 years live in production

Technologies

Power QueryExcelDynamic ArraysFinancial Reconciliation

Review Project →

04

Sales Operations & Revenue Analytics

Salesforce Revenue Reporting System

Replaced hours of manual CRM analysis with an automated Salesforce reporting pipeline covering historical pipeline tracking and executive dashboards.

Extracts, transforms, and compares weekly Salesforce snapshots to surface pipeline movement and validate forecasts.

Scale

  • 5,000+ opportunities
  • Weekly automated reporting
  • Historical pipeline comparison

Technologies

SalesforcePower QueryVBAExcel

Review Project →

05

Sales Forecasting & Decision Support

Yearly Sales Forecasting & Scenario Analysis

Converted historical CRM bookings into a probability-based 2026 forecast, flagging a $1.76M gap to target with 22 weeks remaining.

A rolling forecast model using 105 weekly booking windows and scenario analysis to test whether the annual objective remains achievable.

Scale

  • 105-week rolling history
  • Bi-weekly forecast updates
  • $10K–$400K opportunity values

Technologies

ExcelStructured TablesDynamic ArraysForecast Modeling

Review Project →

06

F&B Franchise / IP Licensing / Finance Model

F&B Franchise Expansion Equity Raise

Supported a $400K equity raise for a 7-country café franchise expansion, closing at a higher implied valuation than the original $1M ask.

A 36-month integrated financial model and investment memorandum underwriting each of 7 planned markets independently.

Scale

  • 10 planned store openings
  • 7 countries
  • $1.0M raise scoped, $400K closed

Technologies

ExcelFinancial ModelingScenario & Sensitivity AnalysisValuation

Review Project →