• Helped Oku.trade: research smart contracts, identify onchain users of competitors, build custom dbt data models and dashboard to collect and monitor the users for a user acquisition campaign.
• Developed and optimized DBT data models for Uniswap, Odos, Jumper (Li.Fi), and Bungee (Socket), enhancing processing efficiency and integration as open source contributor at Dune.com.
• Uniswap Analytics Grants — 1st Prize Winner (Jun-Aug 2023): Won 1st prize with 2 comprehensive on-chain research analyses:
  • Uniswap Memecoin Mania Analysis: Analyzed PEPE-led meme coin trading surge (Apr-Jun 2023) covering $31B aggregate volume across 4,000+ minor pools. Found meme pools peaked at 21% of daily trading volume and 75% of new traders at height of mania. Identified 180K+ new DeFi users onboarded to Ethereum via meme trading. Analyzed whale behavior (0.2% of traders accounted for 52% of volume), trader profitability patterns (experience beats activeness), and cross-pool liquidity migration effects. Discovered meme traders showed 1.5x higher retention vs average traders in first 3 weeks.
  • Uniswap User Origin Analysis: Deep-dive into trader acquisition routes analyzing 11.3M traders, $1.6T volume, 276M+ trades across 450K+ contracts. Segmented users by trading route: Uniswap Frontend (55% of onboarding, 29% of volume), Aggregators (35% onboarding, 15% volume), MEV (1% onboarding, 42% volume), and Unknown contracts (9% onboarding, 14% volume). Analyzed multi-route trader behavior, cohort retention patterns, and weekly growth rates by route. Built live Dune dashboard for real-time user origination tracking.

Led a team of 3 analysts, using BigQuery, Looker, Google Sheets, Airflow, Superset, and Amplitude to monitor user growth.

• Identified optimal threshold and content with A/B test to maximize notifications open rate, minimize spam (email, app/in-app push).
• Analyzed journey of first-purchase users to find visits threshold for optimal activation.
• Analyzed patterns of engaged users to develop strategies for retention and increased lifetime value.
• Built and managed data model versions with Bitbucket.

Monitored ecommerce category financials, achieving target growth rates by identifying and resolving issues with category leaders.

• Built Ecommerce Sales Funnel report to visualize metrics, improving visits, conversion rates, and revenue for Merchandising team.
• Enhanced retail cash cycle through ETL of inventory data from ERP to BigQuery, contract reviews, and payable forecasting.
• Recommended negotiations for better supplier deals, increasing intake margins, reducing prices, and boosting revenue and gross margins.
• Created logistics cost dashboard to analyze and reduce fulfillment and transportation expenses.
• Reduced work process from 2 hours to 30 minutes by automating reports using SQL and Python.

Assisted Finance Director with financial planning, analysis, business partnering, and project management.

• Analyzed monthly Profit and Loss variances to identify trends, risks, and insights for revenue and costs.
• Co-developed a purchasing strategy with the Purchasing Manager, resulting in $580k savings.
• Built financial models to optimize payment plans for key suppliers.
• Led a three-member team in establishing a new fixed asset management system, rebuilding a database of 1,200 assets and reducing monthly tasks from two days to one.
• Researched market values to compute insured amounts, mitigating potential losses of $2.8 million.
• Accelerated reporting processes using VBA/Macros for repetitive tasks.

Managed supply chain finance from production to sales and marketing in the North hub.

• Controlled Capex expenses and evaluated operational improvement projects.
• Analyzed asset movements and managed slow-moving/obsolete stocks.
• Supervised contractors for a $50 million business expansion project.
• Coordinated with Marketing to oversee promotion programs.