Kelsier Ventures Wallet Analysis (On-Chain Forensics Project, Apr 2025)
Investigative research using Solscan and wallet clustering techniques on Solana
• Identified pump-and-dump schemes involving $LIBRA and $M3M3
tokens.
• Clustered insider wallets based on transaction patterns and behavioral
similarity.
• Tracked token distributions, wash trading loops, and exploit flows
across multiple wallets.
• Documented key TXHashes and mapped wallet movements to build an
evidence trail.
• Contributed to blacklist support efforts targeting fraudulent actors on
the Solana network.
COVID-19 Data Exploration (SQL Project, Jun 2024)
Analyzed global pandemic trends using SQL and on-chain health data
• Explored infection and vaccination trends across multiple countries.
• Applied advanced SQL techniques including CTEs, window functions,
and data type conversions.
• Created views to visualize key metrics such as death rates and infection
spikes.
• Identified correlations between vaccination rates and case numbers,
supporting public health insights.
Nashville Housing Data (SQL Data Cleaning Project, Jul 2024)
Data quality enhancement and transformation on real estate records
• Cleaned and standardized over 56,000 housing records using advanced
SQL techniques.
• Handled null values, removed duplicate entries, and applied formatting
transformations.
• Utilized BULK INSERT for efficient data loading and processing.
• Normalized address fields to ensure consistent and structured data for
analysis.
Call List Analysis (Excel Project, Dec 2023)
Customer interaction analysis and dashboard automation using Excel
• Analyzed over 5,000 customer call logs to uncover patterns and service
gaps.
• Identified $250k+ in missed opportunities through performance
insights.