Case studies
23 projects, each traced from the data it started with to what shipped. Client names are withheld; the work is real.
AI, LLMs and agents
LLM extraction and translation pipelines, MCP agents over your own functions, synthetic training data and pricing models.
- Documents and PDFsPortuguese PDFs to structured JSON with meaning intactPortuguese book translation to English · PublishingTesseract OCR · Claude 3.5 Sonnet
- External APIsMCP agents querying live stock, country and tourism APIsMCP Agents using UDF · Internal R&DMCP · Anthropic · Finnhub +3
- Pricing and promotion historyPrices set on elasticity and cannibalisation, not cost-plusRetail — Price & Forecast Optimizer · RetailGoogle BigQuery
- Operational databasesSynthetic training data for healthcare, ad-tech and Salesforce typesSynthetic Data Generator · AI & MLRuby on Rails · Spring Framework · Google Storage +3
Data pipelines and platforms
Batch and streaming pipelines on Google Cloud, AWS and Azure that ingest, clean and enrich data, then land it where analysts can use it.
- Product event streamsStreaming cohort retention on Dataflow and BigQuerySocial User Cohorts Data Pipeline · MediaGoogle PubSub · Google BigQuery · Google Dataflow +3
- E-commerce and cart dataCart logs to Snowflake through Spark, orchestrated by AirflowRetail Data Pipeline · RetailSnowflake · AWS EMR Spark · AWS S3 +1
- Operational databasesConfigurable pipelines across Kafka, Beam and SparkEnterprise Data Platform · EnterpriseReactJS · Ruby on Rails · Apache Kafka +7
Analytics and dashboards
One view across systems that never agreed: SSP revenue, deal data, departmental forecasts, promotion performance.
- CRM and ERP recordsOne forecasting view across six departmentsManufacturing Unit Consolidated Dashboard · ManufacturingSalesforce Einstein Analytics Studio
- Ad exchanges and SSPs + CRM and ERP recordsPrivate-marketplace deals matched to Salesforce in one viewDeal Dashboard — Data Aggregation · Ad techAd-Juster · Salesforce · Excel +3
- Ad exchanges and SSPsCampaign, viewability and audience data in one BigQuery modelMarketing Insights Platform · MarketingGoogle Storage · Google BigQuery · Google Composer +5
- Pricing and promotion historyA multi-year plan up the price and promotion maturity curveRetail — Price & Promotions · RetailGoogle BigQuery
- Pricing and promotion historyFinds the long tail of margin-diluting promotionsRetail — Promotion Analytics · RetailGoogle BigQuery
- Ad exchanges and SSPsRevenue from a dozen SSPs in one next-day viewRevenue Dashboard — Data Aggregation · Ad techTapClicks · Rubicon · Pubmatic +11
Commerce and apps
Web and mobile products built end to end, from in-store beacon apps to Shopify stores and platform migrations.
- Location and in-store signals42% of shoppers who saw a targeted message bought the productBeacon — Supermarket · RetailEstimote Beacon SDK
- E-commerce and cart data65% reduction in average page load timeShopify — Leather Shoe Store · FootwearVenture · Dawn · Klarna +6
- E-commerce and cart dataShopify to Dukaan with no data lossShopify Migration to Dukaan · FootwearDukaan Shopify Importer · Dukaan
Campaigns and ad tech
Programmatic, geo-fenced and mobile campaigns, with the tracking scripts to prove what worked.
- Location and in-store signalsCTR raised from 0.57% to 1.85%Campaign — Retail Chain · RetailGoogle DFP · Geo-aware · HTML 5
- Ad exchanges and SSPsRetargeting at a 15:1 or better CPACampaign — Clothing Brand · ApparelAppNexus · The Trade Desk · JavaScript +1
- Location and in-store signals3.21% of reached shoppers saved the event to their calendarCampaign — Department Store Chain · RetailGoogle DFP · Geo-aware · HTML 5
- Location and in-store signalsAn in-ad store locator that turned views into store visitsCampaign — Fast Food Chain · Quick-service restaurantsInMobi · HTML 5 · XML
- Ad exchanges and SSPsA 17:1 CPA held through the campaignCampaign — Fitness Cycle · FitnessGoogle Adwords · AppNexus · InMobi +3
- Location and in-store signalsOver 1% CTR across 200+ geo-fencesCampaign — Outdoor Power Equipment Company · Outdoor equipmentGoogle DFP · Geo-aware · HTML 5
- Location and in-store signalsA $2.25 CTA held for the entire campaignCampaign — Telecom Major · TelecomAppNexus · The Trade Desk · JavaScript +1