All Projects

A collection of data engineering, cloud infrastructure, and e-commerce solutions I've built.

← Back to Home

E-commerce Data Pipeline

Real-time data pipeline processing millions of events daily

BigQueryDataformGCP Cloud RunPub/SubTypeScript
Problem:

Legacy batch processing caused delays in business insights and decision-making for a growing e-commerce platform.

Approach:

Built a streaming data pipeline using GCP Pub/Sub, Dataflow, and BigQuery with automated data quality checks.

Result:

Reduced data latency from 24 hours to under 5 minutes. Enabled real-time dashboards that improved inventory decision-making and reduced stockouts by 23%.

Shopify Integration Platform

Unified integration layer for Shopify apps and services

ShopifyNestJSRedisPostgresDocker
Problem:

Multiple disconnected Shopify integrations led to data inconsistencies and slow order processing.

Approach:

Developed a centralized NestJS API with Redis caching, webhook management, and automated sync workflows.

Result:

Consolidated 5 separate integrations into one platform. Reduced order sync time by 67% and eliminated 95% of data discrepancies.

Cloud Infrastructure Optimization

Cost and performance optimization for cloud workloads

GCP Cloud RunDockerBigQueryNode.js
Problem:

Cloud costs were increasing 40% year-over-year without corresponding growth in usage.

Approach:

Implemented autoscaling policies, containerized services with Cloud Run, and optimized BigQuery queries with partitioning.

Result:

Reduced monthly cloud spend by $12K (35% reduction) while improving average response time by 150ms.

Marketing Automation Suite

Automated customer segmentation and email campaigns

KlaviyoBigQueryTypeScriptPostgres
Problem:

Manual campaign creation was time-consuming and lacked personalization at scale.

Approach:

Built automated segmentation using BigQuery ML and integrated with Klaviyo for targeted campaigns.

Result:

Automated 80% of campaign workflows. Increased email engagement by 2.4x and revenue from email by 156%.

Real-time Inventory Sync

Multi-channel inventory synchronization system

Pub/SubRedisShopifyNode.jsDocker
Problem:

Overselling across channels caused customer dissatisfaction and fulfillment issues.

Approach:

Created event-driven sync system using Pub/Sub to update inventory across all sales channels in real-time.

Result:

Reduced overselling incidents by 98%. Synchronized inventory across 3 channels within 2 seconds of any update.