01 · selected work
Proof of Work
Twelve projects. The problem, the approach, and the number that moved.
Highlight
M&A Investment Proposal: Netflix ⇢ Paramount
Determine strategic viability and fair value of a $30B+ media acquisition to expand content infrastructure.
- Aggregated 5 yrs of 10-K / 10-Q data to baseline revenue stability and debt obligations.
- Built a dynamic 5-year forecast model; normalized non-recurring items → 9.27% projected revenue growth.
- Ran DCF + sensitivity on WACC & Terminal Value, identifying 41% undervaluation ($18.58 implied vs $13.16 market).
Other Noteworthy Projects
- Derivatives
Quantitative Portfolio Management
Generate alpha against S&P 500 while managing systemic risk during a high-volatility election cycle.
DerivativesRiskFinanceOptionsSharpe RatioTechnical Analysis - SQL
Investment Portfolio Analytics & SQL Data Pipeline
Consolidate fragmented high-net-worth asset data into a single source of truth for real-time risk monitoring.
SQLDashboardsFinanceJoins & CTEsViewsRisk Metrics - SQL
U.S. Labor Market & H-1B Sponsorship Analysis
Quantify real purchasing power of STEM roles across U.S. cities to optimize job search ROI for international graduates.
SQLLabor EconomicsAzure MySQLWage Modeling - Python
Telecom Customer Churn Prediction
Diagnose root causes of customer attrition and build predictive logic to trigger retention interventions.
PythonMLPandasSeabornEDA - Stats
Statistical Analysis of MBTA Transit Efficiency
Evaluate service reliability gaps between transit lines to propose operational efficiency improvements.
StatsOpsHypothesis TestingRCorrelation - Optimization
Logistics Network Optimization
Redesign a global coffee producer's distribution network by siting a second warehouse to minimize annual transport and handling costs across 17,600 tonnes of demand.
OptimizationLinear ProgrammingOpsExcel SolverSensitivity AnalysisScenario Modeling - Power BI
Workforce BI
Bridge two disconnected workforce systems (WhenToWork scheduling + Kronos punch clock) at a luxury hotel to detect compliance risk before payroll close.
Power BIBIComplianceDAXStar SchemaAnomaly Detection - Power BI
Olist Sales Funnel Insights (Brazilian E-commerce)
Help a Brazilian e-commerce marketplace cut client acquisition cost while protecting merchant revenue as post-pandemic tailwinds reversed.
Power BIBIMarketingMySQLDAXSMART Goals - Optimization
RH Furniture
Cut delivery cost and CO₂ for a furniture retailer by solving the daily Vehicle Routing Problem and feeding optimized routes into a live Power BI dashboard.
OptimizationPythonPower BIOR-ToolsVRPBin Packing - NLP
Airbnb Listings
Decode why some Airbnb listings outperform others by mining 3,985 listings across 12 markets and isolating which content signals (not pricing) drive guest satisfaction.
NLPText MiningRTF-IDFSentiment AnalysisBigrams
play with the math
Watch a route optimizer solve.
Drop delivery stops and hit solve. The tangled path untangles into the shortest route in real time, nearest neighbor first, then 2-opt swaps, the same idea behind my RH Furniture routing project. The savings is measured against the naive order.
vehicle routing · nearest neighbor + 2-opt
readystops
11
naive route
2254
current route
2254
saved
0%
Have a number that won't speak?
Get In Touch