Hi 👋

🇨🇭 Zurich | 🛠️ Finance and Blockchain Data Engineer & Analyst

Turning raw on-chain chaos into insights. Building reliable blockchain data pipelines.

Currently deep in Across Protocol live data streaming, multi-chain event extraction (Ethereum, Arbitrum, Base, Polygon, Linea, etc.), and medallion architecture ETL.

🚀 Current Focus

• Real-time & historical analytics for Across Protocol bridge (live streaming + decoded events)
• Multi-chain event log extraction & decoding (Etherscan, Moralis, custom RPC)
• Medallion architecture pipelines (bronze → silver → gold) in Python + dbt + DuckDB/Polars
• AI-assisted SQL generation for blockchain queries
• Enriching transactions with LLM context (RAG-style)

Featured Projects

• paxos_analytics
  Full analytics pipeline & dashboard for PyUSD Paxos stablecoin

• across-analytics
  Comprehensive analytics pipeline & dashboards for Across Bridge protocol

• across_live_stream
  Live data streaming solution for Across events across multiple EVM chains

• auto_sql
  AI-generated SQL queries for Ethereum & EVM blockchain data exploration

• blockchain_transactions_context
  Web app: extract last tx for token + enrich context with LLM

• ilv_holders_bigquery
  BigQuery-based analysis of token holders & positions

Tech Stack & Tools

• Languages: Python • SQL
• Data: Polars • DuckDB • PostgreSQL • BigQuery • dbt-core
• Blockchain: Web3.py • Etherscan API • Moralis • RPC providers
• Others: Pandas → Polars migration • LLM prompt engineering for SQL • GitHub Actions

Feel free to explore the repos — feedback & forks always welcome! 🚀