Skip to content

Repository files navigation

Muhammad Auwal Abdulaziz

On-chain & Data Analyst | Mathematics Graduate

View Portfolio Hub →


📂 The Intelligence Hub

This repository hosts my professional portfolio, designed as a high-integrity interface for exploring Web3 protocol intelligence and data forensics. I bridge the gap between abstract on-chain data shards and actionable intelligence through mathematical rigor and forensic interrogation.

🔍 Strategic Case Files (Showcase)

Below are selected "Case Files" extracted from my work, demonstrating specialized capabilities for clients:

FILE: NX-25 // Nexora 📊

NextJS data engineering application to clean, profile, and query spreadsheets. Runs in-browser without database servers or data leaving the sandbox.

On-chain data analyst skill for AI coding agents. Automatically generates Dune SQL queries, decodes Anchor program transactions, and builds growth reports.

A Web3 security vulnerability database and audit checklist, built by analyzing audit logs and repositories from Immunefi's team.

Rigorous data cleaning pipeline on 1,200 transactional records in Excel. Standardized date formats, formatted pricing to currency, handled 309 missing coupon codes, and built structured, filterable named Excel tables.

Dynamic, formula-driven financial dashboard. Used AVERAGE, SUMIF, and COUNTIFS to aggregate sales metrics, yearly trends, acquisition performance, and coupon code return rates.

Constructed database schemas and wrote query scripts to profile sales metrics. Aggregated monthly seasonality, mapped the logistics funnel, ran YoY H1 trends, and audited coupon return rates.

FILE: WF-25 // Wavefront 📡

Onchain market intelligence for Solana, featuring narrative clustering, risk scoring, and AI-powered token analysis in one terminal. Powered by Birdeye data and Gemini AI.

FILE: SB-25 // Sunboard 🌅

Advanced Sunrise Intelligence Terminal for Solana. Momentum scoring, holder distribution, and real-time liquidity tracking for high-conviction assets.

FILE: VX-25 // Vertex ⚡

Institutional-grade invoicing tool for the Solana freelance economy. Generate smart agreements and get paid in USDC/SOL instantly.

Intensive masterclass transitioning from manual data cleaning to building scalable data systems and on-chain intelligence.

FILE: LS-25 // LedgerSnap

High-fidelity financial archival system. Transforming chaotic spending into a streamlined digital ledger with deep analytical insights.

Interactive PivotTable sales dashboard analyzing demographic and regional datasets to identify performance trends.

Call log analytics model with pivot reporting to trace customer service performance gaps.

Dynamic retail sales dashboard with slicers and PivotTables analyzing transactions by location and time.

Demographic and country-level transaction filtering dashboard using Excel slicers.

Power BI data model for inventory tracking, using DAX measures and Power Query ETL pipelines.

FILE: SD-01 // Solana Fraud Detection

Forensic investigation of fraudulent activities on the Solana network. Identifies malicious patterns and protective protocols for on-chain integrity.


🛠️ Technical Architecture & Stack

This portfolio is built using a modern, high-performance stack to demonstrate my ability to deliver premium digital tools for data presentation.

  • Interface: React + Vite (Low-light, high-density aesthetic)
  • Motion Engineering: Framer Motion
  • On-chain Languages: SQL, JavaScript
  • Intelligence Tools: Tableau, Excel, Python

📡 Secure Directive (Contact)

For high-priority inquiries or consulting projects:


Identity verified. Extraction protocol complete.

About

Portfolio and project archive for a data and on-chain analyst. React and Vite, deployed to GitHub Pages.

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages