Skip to content
View KonScanner's full-sized avatar
🌴
On vacation
🌴
On vacation
  • Stealth 👻
  • 16:39 (UTC +01:00)

Highlights

  • Pro

Block or report KonScanner

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
KonScanner/README.md

Konstantinos

Backend Software Engineer · Data Engineer · Data Scientist
Physics first, then machine learning, then blockchain data.
Greater London Area, United Kingdom

LinkedIn Notion

I build blockchain data pipelines, real time Postgres systems, and the products that sit on top of them. I take an early stage idea from a proof of concept to a released v1.0.0.


Path

From physics to blockchain data.

Career path: University 2016 to 2020, TX Connected 2020 to 2021, LeasePlan 2021 to 2022, Flipside Crypto 2022, Polygon Labs 2022 to 2023, ZettaBlock 2023 to 2025, Share.xyz 2025 to May 2026

Experience

Period Where Role and work
2025 to May 2026 Share.xyz Social crypto app. Backend, pipelines and product, end to end.
Mar 2023 to 2025 ZettaBlock Senior Data Engineer, Data Scientist and Analytics Engineer. Core EVM data infrastructure. Raised decoded table rates on core ingested tables and built the abstraction layers above them. Wrote pipelines into a Presto, Athena and SparkSQL compatible Delta Lake, and into PostgreSQL, on the AWS stack. Built the real time Ingestor and real time Balances on PostgreSQL with asyncio. Optimised a complexity based query routing heuristic that dispatched user queries between Presto, Athena and PostgreSQL, so the engine stayed invisible to the user. dbt for transforms, MySQL for user management.
Apr 2022 to Apr 2023 Polygon Labs Data Lead, Data Scientist and Analytics Engineer. Ran the pipelines and analytics infrastructure behind internal BI on Looker and dbt. Built and maintained APIs that served the business development and marketing teams, and external partners including Starbucks and Reddit. Standardised the metric methodology for Network, DeFi, NFT and Gaming data. Moved heavy Python jobs to PySpark on Dataproc. Refactored the Airflow DAGs and the SQL behind them. Wrote research reports and data models for product and growth decisions.
2022, part time Flipside Crypto Bounty hunter. SQL analytics and dashboards across Terra, Thorchain, Maker and Aave. Reached Elite tier.
Nov 2021 to Apr 2022 LeasePlan Data Scientist. Built credit risk scoring models for private individuals. Led feature discovery, analytics and model development. Added ML text extraction to compare PDF contracts.
Jun 2020 to Oct 2021 TX Connected, acquired by Toyota Junior Data Scientist, crashmatics group. Vehicle telematics crash data. Driver liability and accident severity models. Feature engineering from physics signals. MLflow, Docker and AWS for deployment.

Education. Data Science MSc, University of Surrey. Theoretical and Mathematical Physics BSc, University of Nottingham. Physics BSc, University of Leicester.


What I build

flowchart LR
    RPC["JSON-RPC nodes"] --> EXT["Extract<br/>Rust, batched"]
    EXT --> DEC["Decode<br/>ABI, logs, traces"]
    DEC --> CDC["CDC merge<br/>parquet to SQL"]
    CDC --> PG[("Postgres<br/>real time")]
    PG --> API["API<br/>FastAPI, GraphQL"]
    API --> APP["Product<br/>bots, dashboards, apps"]
Loading

Blockchain pipeline engineering. Extraction from JSON-RPC to parquet, then ABI decoding of logs, calls and traces, then load into SQL. Gap fill, reorg handling and backfill included.

Real time Postgres. Change data capture with COPY into a temporary table, then MERGE. Partitions, indexes and vacuum policy for tables that grow with every block. Real time balances at chain tip.

Query routing. Send each query to the engine that suits it. Postgres for point reads and low latency, Presto or Athena for large scans. The caller sees one interface.

End to end products. FastAPI and GraphQL services, Telegram bots, dashboards and the schema underneath them.


Selected work

Public repositories below. Most recent pipeline and product work sits in private repositories, so it is described in general terms without links.

Repository What it is
triodion Rust. Extracts EVM data to parquet, csv or json. Derived from paradigmxyz/cryo, with Multicall3 batching, coalesced log extraction and JSON-RPC request batching.
hyperliquid-trader-tracker Rust. Telegram bot that tracks Hyperliquid wallets. One edit in place card per perp position, with PnL, ROI, leverage and liquidation price. No keys needed.
flipsideClaimBot Python. Claimed Flipside bounties that dropped overnight. Now a public archive.
Terralytics Terra ecosystem analytics from the Flipside years.
Predicting_Accidents_proj R. UK road accident severity, 2005 to 2015. Cleaning, k means clustering and prediction. University of Surrey.
transitionMatrix State transition analysis, used for credit rating migration. Fork of open-risk/transitionMatrix.
Blockchain data and ingestion
Repository What it is
triodion EVM extraction to parquet, csv and json. Rust.
lazy-contract-mapping Scrapy tool that maps contract addresses to labels.
chainlist_scraper Scrapes chain metadata from public chain lists.

Private repositories hold change data capture from parquet into per chain Postgres schemas, a real time Bitcoin ingestor on PostgreSQL, EVM and Cosmos ingestors in Go, ABI parsing, a TimescaleDB evaluation, Dagster orchestration and zkEVM testnet work.

Analytics, the Flipside and Polygon years
Repository What it is
flipsideClaimBot Bounty claim bot. Archived.
Terralytics Terra ecosystem analytics.
maker-dao Maker DAO analysis.
Polygon-x-Sushi Sushi contribution to Polygon growth.
retention-dashboard Retention metrics dashboard.
Cashboard Dashboard for monitoring cryptocurrencies.
synthr-farming Synthr action farming scripts.
Onchain_Analysis On chain analysis toolkit. Fork of readysetcryptocodes/Onchain_Analysis.
Blockchain Data Analytics A Notion series I write. Case studies that run from exploratory analysis to decoding contract logic, including decoded tables from raw logs and a piece on smart contract mutability.

Private repositories hold Flipside reporting, Thorchain and staked Aave dashboards, ecosystem value modelling, growth and competitive metrics, and Terra SDK utilities.

Machine learning, reinforcement learning and physics
Repository What it is
Predicting_Accidents_proj R. UK road accident severity, 2005 to 2015. University of Surrey.
transitionMatrix State transition analysis for credit rating migration. Fork of open-risk/transitionMatrix.
pytorch-Deep-Learning Deep learning with PyTorch. Fork of the NYU course by Atcold.
TensorFlow_CertificationNotes TensorFlow certification notes.
Simple-Harmonic-Oscillator Physics simulation.
computer-vision-cloud9 Computer vision on AWS Cloud9.
mpl-style Custom matplotlib style.

Private repositories hold reinforcement learning method work, the NYU deep learning course track, an impact event reader for telematics signals, and a Kaggle entry.

Backend, tooling and side projects
Repository What it is
fappiTemp FastAPI template with Postgres.
Business_Solution Business database solution in PL/pgSQL.
macro-bot-telegram Macro statistics over Telegram.
dispmail Disposable email. Sign up for services without giving personal information away.
image_toolkit Image processing utilities.
Golang-fundamentals Go fundamentals.
ETH_mine_hodler Mining payout history measured against price.
CookBook Personal engineering cookbook.

Private repositories hold FastAPI web3 scaffolding, data APIs, Hyperliquid strategy and trading tools, crypto tax statement tools, secret encryption, basketball data work and a research aggregator.


Stack

Layer Tools
Languages Python, Rust, Go, SQL, TypeScript, R
Databases PostgreSQL, TimescaleDB, MySQL, DuckDB, Redshift
Query engines Presto, Athena, SparkSQL, Delta Lake, Iceberg, Parquet
Transform dbt, Spark, Pandas, NumPy
Orchestration Airflow, Dagster, asyncio
Services FastAPI, Flask, GraphQL
ML PyTorch, TensorFlow, scikit-learn, MLflow, Hugging Face
Chains EVM, Bitcoin, Cosmos, Terra, Hyperliquid. Alchemy and QuickNode.
Cloud AWS, GCP, Docker, Kubernetes
BI Looker

Now

I work with early stage teams and help them ship. Give me a proof of concept and I take the product to a released v1.0.0. I cover what the build needs, from the backend and the data underneath to the interface the user touches. I write the code myself.

Reach me on LinkedIn.

Away from the keyboard: guitar, bass and basketball.

Pinned Loading

  1. triodion triodion Public

    triodion - extract EVM blockchain data to parquet, csv, or json. A fork of paradigmxyz/cryo with Multicall3 batching, coalesced log extraction, JSON-RPC request batching & more

    Rust

  2. Layr-Labs/eigenpod-proofs-generation Layr-Labs/eigenpod-proofs-generation Public

    Go 24 40

  3. open-risk/transitionMatrix open-risk/transitionMatrix Public

    Statistical analysis and visualization of state transition phenomena

    Python 87 32

  4. hyperliquid-trader-tracker hyperliquid-trader-tracker Public

    Real-time Hyperliquid whale/wallet tracker as a Telegram bot, in Rust — one edit-in-place card per perp position (open/add/reduce/close) with PnL, ROI, leverage and liquidation info. No keys needed.

    Rust

  5. dispmail dispmail Public archive

    Disposable emails. Sign up for stuff without giving your personal information away.

    Python 1