Skip to content
View joshuatochinwachi's full-sized avatar
🧑‍💻
🧑‍💻

Block or report joshuatochinwachi

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
joshuatochinwachi/README.md

Hi there, I'm Joshua 👋

Blockchain Expert | Data Wizard | Full-Stack Developer

I decode blockchain data and build full-stack analytics systems that turn on-chain activity into business insights—helping Web3 teams track performance, predict user behavior, and make data-driven decisions.

📄 My CV | 📊 Dune Portfolio – #1 Analyst on Cardano, Plasma & Ronin blockchains


What I Build

On-chain Analytics & Data Engineering

  • Automated ETL pipelines processing millions of blockchain transactions
  • Real-time dashboards for DeFi, gaming, NFTs, and L1/L2 ecosystems
  • ML models for user behavior, retention prediction, and anomaly detection

Full-Stack Applications

  • Production APIs and web apps (FastAPI + Next.js + Dune Analytics)
  • Interactive dashboards processing live blockchain data
  • End-to-end analytics platforms with intelligent caching (Singleflight Merger) and real-time updates
  • Cross-platform mobile applications with Defense-in-Depth IAP Sync (iOS/Android/Telegram), utilizing StoreKit 2 appAccountToken to eliminate payment race conditions.
  • Industrial Ingestion Clusters: Developed a multithreaded Stealth Archiver (Playwright) on Contabo VPS using human heuristics and High-Res Image Hijacking to deliver 4K visuals from low-res embeds.
  • Distributed CI/CD Architecture: Built a "Zero-Exposure" deployment pipeline using GitHub Actions that handles Secret Reconstitution (ephemeral decoding of production certificates) for automated native builds.

Tech Stack

📍 Core: SQL (PostgreSQL, MSSQL, Snowflake, Trino) · Python · Dune Analytics · Flipside · AI/ML · React
📍 Blockchain: Envio Indexer · Ethers.js · Web3.py · Solidity · Rust · RPC Nodes
📍 Backend: FastAPI · Node.js · Express.js · SQLAlchemy · REST/GraphQL · Dune API · CoinGecko API · Playwright · Socket.IO · AsyncIO · Telegram Bot API · App script
📍 Frontend: React.js · Next.js · TypeScript · React Native · Expo · Streamlit · HTML · CSS · JavaScript · Tailwind CSS
📍 Auth/Payments: Supabase · Stripe · Apple Pay · Google Pay
📍 Machine Learning: Scikit-Learn · PyTorch · TensorFlow · XGBoost · LightGBM · Pandas · NumPy
📍 Visualization: Dune's Dashboarding Tool · Power BI · Tableau · Plotly · Matplotlib · Seaborn · Recharts · Excel (VBA, Macros)
📍 Patterns & DevOps: Singleflight Cache Merger · iOS Plunger Logic · PDS Logic · Zero-Limit Build Engine (GHA + Local Builds) · Secret Reconstitution · GitHub Actions · Contabo VPS · Git · Docker · Apache Airflow · Vercel · Railway · AWS · Streamlit Cloud


Key Wins

Featured in Dune Digest 17 – Ronin Games analysis reached 1M+ subscribers
#1 Dune Analyst on Cardano, Plasma and Ronin blockchains and earned a public shout-out across all three
Real Impact – My dashboards drove NFT sellouts and 10x token price increases
Endorsed by Jihoz.ron – Co-Founder of Ronin & Axie Infinity; secured major grant
Rewarded with Dune Merch (a rare gift to top builders) and Specially Invited to Dune Con Argentina 2025


Let's Connect

LinkedIn Twitter Telegram Email

Pinned Loading

  1. HollowScan-Mobile-App HollowScan-Mobile-App Public

    a SaaS that sources sweet products at relatively cheap prices from popular stores in the UK, USA & Canada like: Amazon, eBay, Argos, Lewis, Smyths, Curry’s, Waitrose, Tesco, Costco, Sainsbury’s, Ha…

    JavaScript 10 1

  2. Solana-Game-Signals-and-Predictive-Modelling Solana-Game-Signals-and-Predictive-Modelling Public

    Next-generation analytics & ML-powered churn prediction for Solana gaming. Self-training models predict player churn 14 days in advance. Live dashboard + REST API analyzing 60M+ on-chain transactio…

    TypeScript 18 1

  3. Pokemon-Center-Monitor-MicroService Pokemon-Center-Monitor-MicroService Public

    Hacked Imperva's WAF with a ghost-mode Playwright microservice that auto-detects Pokémon Center's virtual queue when it goes live. 6-sensor fusion engine, 100-node residential proxy rotation, and r…

    Python 4 1

  4. Ronin-Ecosystem-Tracker Ronin-Ecosystem-Tracker Public

    Professional analytics web app/dashboard for Ronin blockchain gaming economy with real-time insights, network health monitoring, and comprehensive DeFi/NFT marketplace intelligence.

    Jupyter Notebook 11

  5. RonHub-Raffle RonHub-Raffle Public

    Cryptographically secure on-chain raffle platform for the Ronin Network — USDC-verified ticket entry, automated blockchain verification, and cryptographic winner selection. Built with Next.js, Node…

    JavaScript 9

  6. RETAIL_SALES_AND_LOGISTICS_OPTIMIZATION_ANALYSIS RETAIL_SALES_AND_LOGISTICS_OPTIMIZATION_ANALYSIS Public

    I analyzed retail data (2022–2023) using Python (ETL) and SQL. Identified top products, regional trends, and sales growth, providing actionable insights to optimize logistics, boost sales, and impr…

    Jupyter Notebook 13