Blockchain Data Engineer - Milan, Italy
Email: [email protected] | Phone: +39 351 530 7130 Website: 0xEkss.com | X: 0xEkss | LinkedIn: in/ousmane-diagne
Blockchain Data Engineer with 10 years of experience building analytics pipelines and dashboards that turn on-chain data into strategic insights. I built Dune dashboards for tracking Uniswap, Polymarket (Polygon) and Solana volumes. Proven ability to design scalable ETL systems and translate complex Web3 data into growth metrics and actionable intelligence.
Base $JESSE - Creator Coin on BASE
- This Dune dashboard tracks on chain trading activity for the $JESSE token on Base, showing how much it trades, when people trade it, and how many unique wallets are involved over time.
- Dashboard link
Polymarket Uniswap Cup Analytcs
- Getting OrderFilled events from Polygon’s NegRiskCtfExchange contract.
- Normalized maker/taker asset flows, applying correct token decimals (USDC 1e6).
- Built clean metrics for trader volume, open interest, and market activity.
- Dashboard was reshared on X by ecosystem analysts, increasing visibility during Devconnect.
- Dashboard link
Unichain Overview
- Launched a public Dune dashboard tracking Uniswap v4 metrics on Unichain.
- Measured cross-chain volumes, gas usage, and liquidity flow trends.
- Impact: Provided ecosystem teams with health KPIs now referenced by Dune community reports.
- Dashboard link
Solana NFTs Risk Monitor (Helius x [REDACTED] Hackathon)
- Designed a fraud detection model to identify wash trading patterns on Solana NFT markets.
- Flagged 2,000+ suspicious wallets; recognized as a top analytics submission.
- Dashboard link
Base Overview Dashboard
- Built multi-project analytics for Base L2, including failed tx trends and project-level volume tracking.
- Impact: Identified 15% week-over-week growth in active users, shared with Base ecosystem leads.
- Dashboard link
Uniswap v4 Hooks Indexer (ongoing)
- Indexed pool creation, swaps, and hook adoption using Solidity event listeners and Dune SIM IDX.
- Built metrics to monitor adoption across chains and evaluate protocol growth.
- Impact: Enabled real-time visibility into 500+ pools and $100M+ swap activity.
- Github Repo
Freelancer Data Engineer - Remote (2023 - Present)
- Designed and implemented a real-time dashboard for EssilorLuxottica, analyzing on-time delivery performance using Custom ETL Pipeline, SQL & ABAP.
- Focused on KPIs, supply chain performance, and timely delivery metrics.
**IBM Italy - Data Engineer - Hybrid (**2016 - 2022)
- Delivered analytics solutions for 10+ enterprise clients (Central Bank of Italy, Italian Government, Edison).
- Re-architected €2M data warehouse for Edison Energy, improving query efficiency by 40%.
- 2x SAP Innovation Award winner for BW/4HANA optimization projects.
Data Tools: Dune, dbt, Databricks, Power BI, SAP Analytcs Cloud
Programming: SQL, Python, ABAP, Javascript
Modeling: Star Schema, OLAP/OLTP, DAG Orchestration
Cloud & Infra: API Integrations, Databricks, Supabase
Diploma, Information Technology & Computer Science (2010 - 2016)
English: Professional ; Italian: Mother tongue