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.

Content in all repositories owned by your account will be closed.
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 👋

Data Analyst | AI/ML Engineer | Software Engineer | Blockchain / Web3 Expert

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


  • 🔭 Currently building YieldSage — an AI-powered DeFi yield optimization & paper trading agent on Solana blockchain
  • 🌱 Deepening expertise in on-chain governance analytics, AI agents, and cross-chain data pipelines
  • 💬 Ask me about Software Engineering (Full-stack development), Blockchain Analytics, DeFi, SQL, Python, Full-Stack Data Engineering, or breaking into Web3
  • ⚡ Fun fact: I went from an Anatomy degree to becoming a #1 Dune Analyst, building AI agents, softwares/systems, web apps and mobile apps live on the App Store & Play Store, and landing a research master's at UWE Bristol — all at the same time

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)
  • AI agents that auto-researches and carries out tasks while you sleep
  • Automated on-chain logger and ETL pipelines
  • 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


Analytics & Highlights


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 12 2

  2. Yield-Sage Yield-Sage Public

    An autonomous AI agent that researches while you sleep and recommends the best yield opportunities for you on Solana blockchain

    TypeScript 5 1

  3. 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 19 1

  4. Scrybe Scrybe Public

    Scrybe is a password-gated Input Data Message (IDM) logger for Ethereum Mainnet. Standalone, secure, and verifiably on-chain.

    TypeScript 4

  5. 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

  6. 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