
About
M.S. in Data Science at University of Southern California & Tsinghua University 25' | 2yrs exp. in Blockchain Data Analysis
Work Experience
-
Built data pipelines in Dune SQL and Python to locate MEV bundles within private order flow via RPC endpoint from raw Ethereum transaction sets based on builder transfer patterns and transaction index.
-
Investigated uncaptured MEV and conduct precise calculations to quantify the MEV value extracted from 1M+ order flow per month. Delivered data reports to clients directly with visualized analytical output, generating $8K+ in revenue.
-
Performed statistical analysis of 15.5M+ transactions in Python to extract insights on yield performance, trading patterns, and top players in the market; delivered visual results in annual and seasonal data report.
-
Validated labeling and profit calculation accuracy by cross-checking 2.6M transaction records and tracing origin signals for 40K+ arbitrage trades; optimized overall system performance by 16.3%.
-
Crawled and performed topic modeling on 900+ user threads on forums to track topic trends and discover influential speakers; delivered proposals with a list of high-value clients to optimize company business development.
-
Published in-depth blogs dissecting MEV strategies like flash-loan backed arbitrage, sandwich attack MEVs.
-
Built and maintain Dune dashboards across different protocols, ranging from Optimism incentive token tracker to Uniswap delegation tracker for a16z crypto that monitors the voting activities, preferences and bias across delegators.
-
Conduct data-driven research on governance for Optimism delegate team of Blockchain club at USC. Fetched off-chain and on-chain proposal content for internal voting evaluation via API and on-chain databases.
-
Forged collaborations with multiple industrial partners to encourage team members conduct research and share insights on AMAs, leading to 14+ published research articles covering ZK, Infra, L1/L2, NFT, GameFi, DAO governance.
-
Conducted individual research on on-chain data analytic tool stacks and MEV trading strategies and conducted live on Binance, attracting a record 4.2K live views and 5+ repost by crypto news outlets.
-
Designed and developed over 30+ charts and infographics for data storytelling using Adobe Illustrator. Edited and updated over 20 news pieces and independently reported 5 data stories.
Collaborated on interactive data story projects that received the National Prize in China Data Journalism Competition and was awarded as the Annual Data Story in China in 2022.
-
Collected data from extensive sources to develop SVG charts, maps and infographics with Python and Adobe Illustrator.
-
Collaborated with editors, pitched and reported 10+ data stories covering environment, policy, public health issues.
-
Standardized and automated daily COVID and vaccines newsletter with charts using Excel VBA functions and d3.js based on JHU COVID database, reducing the time by half and greatly improving the accuracy of references.
-
Contributed to an interactive reporting project covering illegal wildlife trafficking in data cleaning and collaborative coding on over 4K+ legal documentations. Converted text addresses into coordinates and developed interactive maps with AMAP API.
-
Assisted correspondents to track news sources and conduct interviews for exclusive news reporting.
-
Created multimedia contents to promote the company’s value via social media channels. Developed seven branding stories based on observation and in-depth interviews with core employees.
-
Implemented SEO strategies on branding content, increasing engagement by ~150% and garnering historical 120K+ views.
-
Initiated a data-driven project individually to visualize employees’ working life. Designed the survey and collected 300 self-reported employee records and developed an infographic report.
Projects
-
Enable user to search MEV bot and trading token pairs to track the bot's payment amount and methods to builders, as well as the transaction visibility in the order flow.
-
Provide clear builder payment leaderboard showing the possible collaboration of MEV searchers and builders.
-
Dive into the builder market share on Ethereum and value flow through the whole supply chain, including builder rewards sourced from upstream order flow market (private V.S. public orders) and to downstream subsidy payout to validators.
-
Track metrics to evaluate the performance and market dominance of a specific builder, including order flow market share, builder rewards and sources breakdown, as well as major miner tip payee analysis.
- Track key metrics related to the Pyth oracle usage on non-EVM chain Aptos, including the price updates, the breakdown of sponsored vs. non-sponsored updates, fees and costs, and the most active users and contracts interacting with Pyth Network.
-
The dashboard focused the recent EIP-4844 upgrade, tries to provide a deeper exploration of the potential impact of gas subsidies on Uniswap's ecosystem.
-
The analysis mainly examines the relations among multiple key metrics, including gas fee and user engagement & liquidity provision on L2 chains particularly considering.
-
Built a distributed database system based on PostgreSQL and Spark to manage LAPD domestic violence call records.
-
The system allows users to filter, scan, add, delete or update data with user-friendly interactive components to specify search criteria.
-
The system further enables advanced users to customize and execute SQL queries in the distributed databases.
-
Parsed smart contract event logs and function calls with Dune SQL and built dashboard for Optimism Collective to track 1M OP token allocation on chain incentives allocated to Yearn Finance.
-
Evaluated the incentive effectiveness and identify best and underperformed vaults from TVL, user activities and liquidity.
- Built the data dashboard with d3.js, Apache Echarts and GeoJSON to track the prevalence and patterns of mental health illness among students and related healthcare services in the United States at the county level.
-
Collected research data to identify and visualize the major cultural factors that significantly impacted Chinese international students’ mental health well-being and support-seeking intentions.
-
Created the prototype of the interactive data story in Figma and developed the interactive website based on Bootstrap framework, d3.js, Apache Echarts.
Speaking
- Guest speaker; share the latest research findings of the private order flow market and the value flow throughout the supply chain.
Writing
- A tech blog to introduce the MEV sandwich attack strategies based on AAVE loan
- Calculated the total MEV generated and captured from the private transactions via the MEV Blocker RPC.
-
The analysis focused on the evaluation of the effectiveness of incentive program by Optimism Collection, which allocated 1 million OP tokens to Yearn Finance. Yearn promised to distribute 100% of grant $OP tokens to yVault depositors to incentivize the move to Optimism. 25,000 OP tokens will be distributed weekly over the course of 40 weeks, starting on May 18th, 2023.
-
Yearn successfully fulfills the second KPI outlined in the proposal by growing Optimism to Yearn’s second highest TVL by chain, within the span of just one month, highlighting a substantial positive impact of the OP incentive program on Yearn’s user engagement and presence on Optimism network.
-
The incentive program successfully drew in new liquidity providers and encouraged active participation from existing users, with its TVL on Optimism surged from under $300K to over $14M, contributing to 2.3% of total TVL on Optimism in November. Optimism now became the second largest chain considering Yearn’s TVL by chain.
-
After the launch of the incentive program we observed that there is a clear increase in both deposit activities, as the deposit transactions grew from nearly 50 to over 3K per week. yvUSDT and yvUSDC now have the largest user deposits of 1.5M yvUSDT and 1.2M yvUSDC respectively.
-
As of November 19, 2023, Yearn distributed a total of 534,758 yvOP tokens as rewards, with 86% claimed by users already.
-
Although Yearn has allocated a substantial portion of yvOP rewards to one of the vaults named “yvVelo-alETH-WETH-f,” user claim rate for these yvOP rewards is relatively low at 36%.
Education
-
GPA: 3.9/4.0
-
Dual Degree with Tsinghua University
- GPA: 3.9/4.0
- Dual Degree with University of Southern California
-
Minor in Finance (3.7/4.0)
-
Outstanding Graduate
-
GPA: 3.8