Drawing conclusions that hold up.
Intel: Sustainability Impact Analysis
Used SQL to analyze 601,740 repurposed devices from Intel's 2024 sustainability program. Found that older devices save 2.5x more energy per unit than newer ones, and that the same kWh saved prevents far more CO2 in Asia than in Europe due to grid differences. Built a recommendation from those two findings using joins, CASE WHEN bucketing, and CTEs.
sqldata-analysissustainability
Grammy Awards: Website Performance Analysis
Used Python to analyze Grammy and Recording Academy web traffic before and after a 2022 domain split. Measured bounce rate, pages per session, and session duration to determine whether separating the two sites improved engagement. Found that the split created two distinct audience profiles with meaningfully different behavior, and built a recommendation from the data.
pythonpandasweb-analytics
Lockheed Martin: 10-K Mini Analysis
Analyzed Lockheed Martin's balance sheet across 2021 and 2022, tracking movements in cash, accounts receivable, contract assets, and long-term debt. Calculated liquidity, leverage, and efficiency ratios and wrote up what the shifts suggest about the company's financial position and strategic priorities.
financial-analysisratiosdefense
Japan's Lost Decades: Economics
Researched Japan's 1990s asset bubble collapse and the decade of stagnation that followed. The paper covers how the bubble formed, why monetary policy failed, and what the government's use of capital injections and stimulus packages actually accomplished. Draws on Federal Reserve economic data and IMF working papers.
macroeconomicspolicyresearch
Drug Cartels, Border Security & Migration
Interdisciplinary research paper examining how Mexican cartels have shaped border security and migration patterns. I wrote the political science section, focusing on sovereignty, corruption, and why policies like the Merida Initiative fell short. Co-authored with two classmates who covered the historical and anthropological perspectives.
international-studiespolicy