Work Portfolio

On August 5th, the highly-anticipated EIP1559 update went live on Ethereum. This update introduced a "base fee burn," where a portion of transaction fees would be burned, rather than 100% of transaction fees going to the miners. There was a lot of conversation and predictions surrounding what the impact of burning ETH would have on the network and asset price, as well as if enough would be burned to make ETH a deflationary asset. This dashboard dives into the main metrics surrounding EIP1559, including burn/emission rate, share of transactions using the new EIP1559 model, and how often the network is deflationary for ETH.

This became the most starred EIP1559 Dashboard on Dune Analytics.

This was my first dashboard as a part of Llama, specializing in treasury management for DAOs. Llama received a treasury management grant from Aave, which included treasury analytics in addition to establishing investment policies, treasury strategy, and financial reporting. This dashboard provides the Aave community with a real-time, open-source, and transparent view into protocol finances, which is only possible in crypto.

This dashboard covers Aave's Reserve Factors (Treasuries) by chain and its Ecosystem Reserve, with views for traditional Quarterly Statements. Community members can explore balances, revenue, expenses, and token allocation over time.

On July 13, Uniswap announced an "Alpha Launch" of their v3 exchange on Optimism's Layer 2 roll-up. Optimism was one of the most highly anticipated Ethereum scaling solutions, promising lower fees and faster speeds while connecting back to Ethereum's security layer. With my history of making dashboard for Uniswap v3, I had to be the first to get an analysis out. How many people are using the Optimism version? How much cheaper is it actually? Does it appear to be growing?

There was a Twitter debate between protocols about how aggregator vaults like Yearn compete versus users for yield. Discussion turned to a question about if these aggregator vaults should be seen as "whales" or as collections of smaller users? I was curious as well, and built this dashboard to try to gain insight into how many users are actually participating in Yearn vaults and how large their holdings are. Another semi-viral Twitter thread followed (see above).

Also built on Flipside Crypto here.

This was the second dashboard I created for Gamma Strategies. This aimed to 1) Speed up time to reaction by shortening the analysis window from trailing 7 days to trailing 2 days, and 2) Discover the most profitable distinct liquidity positions by pair, fee tier, tick range, time active, etc. Note that these distinct position fees are approximated, since we're using historical data versus in the moment activity, and transactions had to be aggregated in time blocks for query performance.

This Dashboard was a finalist winner in a Uniswap Grants dashboard competition. I took my experience in customer research and competitive analysis in the ecommerce space, and applied it to the decentralized crypto exchange market. This dashboard explores overall market share, share by pair, and it was my first attempt at aggregating pairs into trader use cases (i.e. bundling ETH/USDC, ETH/USDT, ETH/DAI into a ETH/USD grouping).

The one where I took a dog token too seriously. I quote tweeted a Yearn team member's WOOFY launch announcement saying "Actually maybe this is my next dashboard to make. I’m curious how many $WOOFY holders are/were $YFI holders, and how many are in it for the memes." A few likes and follows later, I decided to build this out.

This was the first analysis I created for Gamma Strategies, an organization researching active liquidity management. This dashboard helped monitor Uniswap v3 activity and discover trading pairs that might be worth investing in. This dashboard quickly became the the most "favorited" Uniswap v3 dashboard on Dune Analytics, and within a few weeks became the top Uniswap dashboard overall.

This is where it all started. Read my blog post for context on how I learned crypto data, Uniswap data, and Dune Analytics by building this dashboard, and how it was my first signal of traction in this field.