Hao Li

Analytics Engineer & Full Stack Developer

I build data-driven solutions that turn raw data into actionable business insights and delightful digital experiences.

About

I'm an analytics engineer and full-stack developer with a passion for transforming complex data into clear, actionable insights. My background spans e-commerce growth analytics, data platform architecture, and modern web development — allowing me to bridge the gap between data teams and business stakeholders.

In my recent work, I've built end-to-end analytics platforms using Microsoft Fabric, designed data models following medallion architecture patterns, and created interactive dashboards that drive real business decisions. I enjoy the full spectrum — from writing SQL transformations and building data pipelines to crafting polished user interfaces.

Beyond my core work, I'm deeply interested in AI agent orchestration — exploring how to coordinate AI agents to improve project quality and operational efficiency. I believe every technology investment ultimately comes down to two outcomes: driving more revenue or reducing costs. This lens shapes how I evaluate and adopt new tools, ensuring they deliver real business value rather than just technical novelty.

Projects

E-Commerce Growth Analytics Platform

End-to-end analytics pipeline on Microsoft Fabric for a multi-channel DTC brand (Shopify, Amazon, TikTok Shop — 10K+ orders). Features Medallion architecture (Bronze → Silver → Gold) with PySpark ETL, star schema data modeling, automated pipeline orchestration, and a 3-page Power BI executive dashboard.

  • Microsoft Fabric
  • PySpark
  • SQL
  • Power BI
  • Delta Lake
  • Python
GitHub

SaaS Feature Adoption Analytics

Product analytics pipeline analyzing an AI feature launch for a B2B SaaS platform (~2,000 users, ~200K events). Built adoption funnel, cohort retention (30/60/90d), and DAU/MAU engagement analysis using dbt on BigQuery, orchestrated with Airflow in Docker, and visualized in Looker Studio.

  • BigQuery
  • dbt
  • SQL
  • Apache Airflow
  • Docker
  • Looker Studio
  • Python
GitHub

CollabZen — Partner Management SaaS

A partner management SaaS tool designed for SMBs, supporting influencer and affiliate partner tracking, project management, deliverable performance monitoring, and automated email reminders. Deployed and running in production.

  • Next.js
  • TypeScript
  • Supabase
  • Stripe
  • Tailwind CSS

haoli.ai — AI Resume Agent

A RAG-powered AI agent embedded in this portfolio that lets recruiters query my professional background via natural language. Uses Claude's native tool use API for autonomous tool selection, OpenAI embeddings with Supabase pgvector for semantic search, and a custom agentic loop — no LangChain.

  • Next.js
  • TypeScript
  • Claude API
  • OpenAI Embeddings
  • Supabase pgvector
  • Vercel
GitHub

Real Return Analyzer

A financial education web app that uses historical data from 7 major economies (1970-2024) to help users understand how inflation erodes purchasing power and the real returns of different investments. Supports English, Chinese, and French.

  • Next.js
  • React
  • TypeScript
  • Chart.js
  • Zustand

Ask My AI

Curious about my background? Ask my AI agent — it searches my professional documents using RAG and answers with verified facts.

Try one of these:

Powered by RAG + Claude AI · Searches my professional documents to give accurate answers

Contact

I'm currently open to new opportunities in analytics engineering, data analysis, and full-stack development. Whether you have a question, a potential role, or just want to say hi — my inbox is always open.

Say Hello