Latest work: Wrote a post about Binance Staked SOL, including Mint, Burn, Transfer, and Trade events of BNSOL. Used neo4j to find and show graphs of Minters who also traded BNSOL. Post, Dune dashboard.

• Developed blockchain data analysis toolkit using Python, Web3.py, and Google BigQuery to decode Ethereum smart contract events from Ethena DeFi protocol, processing 2+ TB of blockchain data.
• Analyzed Mantle Staking contract in Solidity to build a Dune dashboard for the Mantle Reward Booster Season 3 Campaign. Dashboard.
• 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.
• Designed and built custom dashboards for DeFi clients, sourcing data from Dune, FlipsideCrypto, and Defillama to review growth campaigns and drive user acquisition/retention.

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.