HomeProjects

/ github

GitHub activity

Public contribution history for the last twelve months.

/ charts

Charts showcase

Interactive chart experiments used across analytics storytelling.

Ring chart

Relative strength across core skill groups.

12,847Skill coverage
  • SQL85%
  • dbt62%
  • Python42%
  • Looker32%
  • Tableau21%
  • Airflow15%

Sunburst

Hierarchy from stack layers down to tools.

WarehouseSnowflakeBigQueryRedshiftTransformdbtSQLPythonBILookerTableauPreset
Click a segment to zoom in · hover to inspect

Composed chart

Mixed series for trend + volume storytelling.

Sankey

Flow from raw events through the analytics stack.

Choropleth map

Geographic distribution for regional context.

Loading map…

/ projects

Selected work

Hands-on pipeline and automation projects across CRM, warehouse, and BI stacks.

Tally → Zapier → HubSpot → Airbyte → BigQuery → Preset

Case Study

Leads Analysis Pipeline + Dashboard

Sep 2022 – Oct 2022

Built a zero-cost, real-time registration pipeline for a VC incubator using Tally, Zapier, HubSpot, Docker-hosted Airbyte, BigQuery, and Preset — tracking founder signups without premium connector fees.

AirbyteBigQueryHubSpotPresetZapier
Case Study

Messy Data Normalization

Jan 2023

Cleaned extremely unstructured client data where geolocation, email, and phone were wrapped in single cells — normalized attributes into independent columns using Alteryx and the Geocode.io API.

AlteryxGeocode.ioData Quality
Case Study

Lead Scraping Automation

Jan 2023

Screenscraped a web resource with UiPath StudioX and structured exported CSVs in KNIME before uploading leads to HubSpot — a cost-effective alternative to paid acquisition tools.

UiPathKNIMEHubSpot

/ workflows

Automation workflows

Pipeline diagrams that auto-walk each node — click or drag anytime to take over.

n8n → BigQuery → Sheets → Tableau

An n8n workflow that lands data in BigQuery, syncs to Google Sheets, then publishes to Tableau Public.

DB → Python → warehouse → HubSpot

MySQL/Postgres data through Python, GitHub Actions and Airflow into BigQuery, then Airflow syncs to HubSpot.

HubSpot → Fivetran → BigQuery → Python → HubSpot

CRM extract via Fivetran into BigQuery, Python enrichment, then write-back to HubSpot.

BigQuery → Python + OpenAI → OpenMetadata

Warehouse data prepared in Python, enriched with an OpenAI model, then cataloged in OpenMetadata.