ario57

Developed and maintained 440+ SQL queries to analyze Solana ecosystem activity, protocol performance, DEX routing, wallet behavior, and market structure across large blockchain datasets. Built repeatable data workflows that transformed raw on-chain transactions into structured metrics used for dashboards, weekly newsletters, data-driven articles, and ecosystem reporting. Authored 71 data-driven SolanaFloor articles based on SQL analysis, transaction-level datasets, wallet segmentation, protocol classification, and validation of on-chain metrics. Designed analytics systems for aggregator routing, Prop AMM volume, staking behavior, x402 micropayments, derivatives activity, stablecoins, and cross-chain token trading. Improved reliability of blockchain analytics by validating query outputs, checking abnormal activity patterns, reconciling protocol-level metrics, and refining methodology for cleaner reporting.

Built 60+ SQL-based blockchain analytics dashboards across DeFi, stablecoins, DEXs, liquid staking, and trading behavior. Wrote and optimized queries to extract, clean, structure, and analyze high-volume on-chain datasets for reusable metrics and visual reporting. Published data-driven analyses that generated 1.1M+ total impressions across X, demonstrating strong data communication and insight delivery.

Delivered blockchain analytics projects using Dune and Flipside, focused on protocol performance, wallet activity, DeFi usage, and ecosystem-level trends. Built custom SQL dashboards and reusable analytical queries to support on-chain research, reporting workflows, and decision-making.