Selected experience
Systems behind the reporting and workflows.
Case studies in data engineering, reporting, API automation, and backend/cloud work. Each describes the problem, my contribution, and the supported outcome.
Marketing Data Platforms
Marketing Data & Campaign Analytics Platform
Advertising APIs, BigQuery reporting layers, recovery workflows, and campaign analysis behind a marketing analytics product.
Product team · Contribution described in case study
Read the case study →
Backend & Connected Devices
AWS Connected-Device Backend & Telemetry
Backend and telemetry engineering within an existing connected-device product: APIs, aggregation, recovery, and cloud performance work.
Product team · Contribution described in case study
Read the case study →
Google Sheets Automation
Google Sheets and Apps Script Reporting Automation
Automating recurring Sheets updates and document/report outputs while keeping configuration and validation understandable for the team.
Solo · Contribution described in case study
Read the case study →
Marketing Data Platforms
Dataform + BigQuery Marketing Analytics Warehouse
GA4, Google Ads, and CRM inputs organized into BigQuery reporting models with Dataform transformations and reconciliation checks.
Solo · Contribution described in case study
Read the case study →
Commerce & Backend Reporting
Commerce, Subscriptions & Acquisition Reporting Backend
Payment and subscription workflows, acquisition metadata, and reporting APIs within the same connected-device product.
Product team · Contribution described in case study
Read the case study →
Marketing Data Engineering
DV360 & Ads Data Hub Data Pipeline
Production event-driven data platform for DV360 metadata, DV360 report normalization, Ads Data Hub match-rate workflows, BigQuery processing, and reliable AWS SQS delivery.
Solo · Contribution described in case study
Read the case study →
Marketing & Advertising
Marketing Ads Dashboard
Google Ads, Meta Ads, and Sheet inputs connected to a reporting model and an authenticated marketing dashboard.
Solo · Contribution described in case study
Read the case study →
Ecommerce & Marketplace Analytics
Amazon Vendor/Seller Analytics Dashboard
Custom marketplace analytics dashboard built around recurring vendor/seller reports, email ingestion, MySQL storage, and a Next.js reporting UI.
Solo
Read the case study →
Marketing Reporting Automation
Multi-Platform Ads Reporting Automation
Google Ads, Meta Ads, LinkedIn Ads, and Bing/Microsoft Ads reporting automation into Google Sheets with platform-specific handling and validation.
Solo
Read the case study →
Affiliate & Partner Marketing
Affiliate Network Data Pipelines
Python pipelines for normalizing Awin, Rakuten, and TradeTracker-style affiliate data into reporting-ready transaction tables.
Solo
Read the case study →
Data Pipelines & Migrations
Database Migration and Email Automation
Python and SQL workflows for reporting database migration, schema preservation, backup helpers, and email-related automation.
Solo
Read the case study →
Public Data Enrichment
SAM.gov Opportunities Enrichment Pipeline
Python pipeline for collecting public opportunity records and enriching them with PSC/NAICS-style classification context for reporting.
Solo
Read the case study →