All Work

Projects

10 real-world projects across backend systems, data solutions, and Web3 automation — grouped by domain.

Backend

Realtime Analytics Platform

A backend service for streaming and querying live analytics data over WebSocket, backed by Redis for fast reads and PostgreSQL for durable storage.

FastAPIWebSocketRedisPostgreSQLPython

AutoReport

An automated reporting tool that transforms raw data into interactive dashboards, cutting manual report-building down to a single command.

PythonPandasPlotlyStreamlitPostgreSQL

apiwatch

A CLI and API monitoring toolkit for tracking endpoint health and uptime, with results persisted to PostgreSQL for historical analysis.

PythonFastAPIPostgreSQLTyper

URL Shortener + Analytics API

Production-ready URL shortener with real-time click analytics. JWT auth, async GeoIP tracking, rate limiting, URL expiry, and 5 analytics endpoints.

FastAPIPostgreSQLSQLAlchemyAlembicJWTGeoIPSlowAPIPython
  • Async click tracking
  • GeoIP per click
  • Auto Swagger docs
  • Rate limiting

Data

E-Commerce BI Dashboard

A business intelligence dashboard for e-commerce data, surfacing sales trends and product performance through interactive Plotly Dash visualizations.

PythonPlotly DashPostgreSQLPandas

E-Commerce Price War Analysis

Scraped 156 fashion products across Lazada & Zalora Malaysia, built a full data pipeline, analyzed discount patterns, and deployed a live interactive dashboard.

PythonSeleniumBeautifulSoupPostgreSQLPandasPlotlyStreamlitSupabase
  • Zalora 74% products discounted vs Lazada 13.9%
  • Zalora avg discount 28.4% vs Lazada 16.4%
  • Detected price inflation strategy across both platforms
  • Most aggressive brand: NEXT (57.5% avg discount)

dataqual

A PyPI-published CLI for automated data quality checks on tabular datasets, flagging nulls, duplicates, and schema drift before they reach production.

PythonTyperPandasPyPI

fraud-detection-api

A REST API that scores transactions for fraud risk in real time using a scikit-learn model, with results and history persisted in PostgreSQL.

PythonFastAPIscikit-learnPostgreSQL

Web3 & Blockchain

All-in-One Web3 Analytics Telegram Bot

11 analytics modules, 80+ commands, running 24/7 on VPS — covering wallet tracking, token analytics, and cross-chain DeFi data directly inside Telegram.

PythonWeb3.pyTelegram Bot APIEtherscanCoinGeckoDeFi LlamaLI.FILinux VPS
  • 11 Modules
  • 80+ Commands
  • 24/7 Live Deployment
  • Cross-Chain Support

CryptoVault API

Secure REST API for managing crypto portfolio data with JWT auth, live price integration, and analytics endpoints.

PythonFastAPIPostgreSQLSQLAlchemyJWTCoinGecko API
  • REST API Architecture
  • JWT Authentication
  • PostgreSQL Integration
  • Live Deployment
Instrumental