Projects
Welcome to my portfolio! This is where I showcase the amazing projects I have worked on. Feel free to click around and explore the innovative solutions I came up with.
F1 Performance Dashboard
Microsoft Excel
Engineered an interactive Excel dashboard analyzing 75+ years of Formula 1 data (1950–2025) to evaluate driver racecraft and team dominance. Developed custom metrics, including Reliability-Adjusted Points Per Race (RAPPR), and built a dynamic Head-to-Head comparison tool, demonstrating advanced data modeling, complex logical formulas, and KPI generation.
Customer Segmentation Engine
SQL
Designed and deployed a comprehensive PostgreSQL database architecture and an automated RFM (Recency, Frequency, Monetary) segmentation model to analyze a major e-commerce dataset. By translating complex SQL joins and window functions into plain-English strategic intelligence, the project uncovered multi-million-dollar insights across operations, marketing, finance, and pricing, fundamentally shifting the business strategy from operational fixes to competitive positioning.
Apple Strategic Intelligence Engine
Python
Engineered a Python analytics engine evaluating 100,000+ Apple SKUs to drive executive strategy. Applied advanced statistical models (OLS regression, Welch’s T-tests, Pearson correlations) to quantify supply chain penalties, isolate price ceilings, and measure SKU complexity ROI. The project translated raw data into actionable pricing and operational insights, mitigating "Premium Remorse" across the product ecosystem
