Skip to content
<-- All Projects

Coca-Cola SmartLabel

Serverless Data Pipeline · Event-Driven Architecture · Cloud-Native Frontend

Designed and built a full-stack archival platform combining a serverless AWS data pipeline with a React-based browser interface to capture, store, and explore SmartLabel product history.

Role:
Developer/Architect
Employer:
IfThen
Client:
Coca-Cola
Team:
1 Developer + Account Lead
Industry:
Non-Alcoholic Beverages
Timeline:
4 months (2022)

Impact

  • Automated end-to-end archival of SmartLabel product data and visual evidence
  • Eliminated manual workflows through a scalable, event-driven processing pipeline
  • Enabled searchable, user-facing access to historical product records
  • Delivered a complete cloud-native platform spanning data ingestion, processing, and consumption

My Role

  • Sole architect and developer responsible for full platform design and implementation
  • Designed and implemented serverless backend using AWS Lambda, SQS, S3, and DynamoDB
  • Built React-based frontend application for browsing and retrieving archived data
  • Developed API layer to connect archival pipeline with user-facing interface
  • Defined infrastructure using AWS SAM and CloudFormation
  • Owned all architectural decisions across backend processing, data modeling, and frontend integration

Technical Architecture

Backend

Managers upload both on-demand requests and recurring manifests via CSV files. CSV information is used to capture relevant data and generate screen captures.

Frontend

Users browse archived screenshots and metadata via a CloudFront-enabled React.js app.

System Overview

  • Event-driven pipeline ingests CSV product data from S3 and transforms it into structured workloads
  • Queue-based processing distributes screenshot generation tasks across Lambda executions
  • Headless browser automation captures SmartLabel pages and stores images in S3
  • DynamoDB persists revision history and brand metadata for query-based retrieval
  • API Gateway exposes archive data through HTTP endpoints
  • React single-page application provides a guided interface for searching and browsing archived records
  • Frontend deployed as static assets to S3, fully decoupled from backend compute

Archiver (Backend System)

  • Serverless ingestion and archival pipeline built on AWS managed services
  • Parser Lambda converts CSV files into structured records and partitions workloads
  • SQS queue decouples ingestion from processing, enabling asynchronous execution
  • Archiver Lambda uses Puppeteer with headless Chromium to capture product page screenshots
  • S3 stores both source files and generated screenshot artifacts
  • DynamoDB models revision history and brand relationships based on query patterns
  • API Gateway provides access to archived data for downstream consumers

Browser (Frontend System)

  • React single-page application for searching and exploring archived SmartLabel data
  • Guided filter workflow supports date range, brand, sub-brand, and GTIN queries
  • Dynamic retrieval of brand and taxonomy data from backend APIs
  • Paginated visual results with screenshot previews and metadata display
  • Modal-based inspection enables detailed review without disrupting search flow
  • Client-side JSON export supports lightweight data extraction
  • Statically deployed to S3 for low-cost, scalable frontend delivery

Architectural Decisions

  • Adopted event-driven architecture to decouple ingestion, processing, and consumption layers
  • Introduced SQS-based workload partitioning to handle Lambda execution constraints
  • Separated backend pipeline from frontend application via API-driven integration
  • Modeled DynamoDB schema around access patterns to support efficient filtering and retrieval
  • Used serverless browser automation to capture visual archive evidence at scale
  • Deployed frontend as static assets to align with API-first cloud architecture

Stack

Frontend

ReactMaterial UIAxios

Backend

Node.jsAWS LambdaAPI GatewayPuppeteer

Cloud

Amazon S3Amazon SQSDynamoDB

Infrastructure

AWS SAMCloudFormationIAM

Context

The platform was designed to address the need for reliable archival and retrieval of SmartLabel product data over time.

Key challenges included:

  • Processing large datasets within serverless execution limits
  • Capturing visual snapshots of product pages at scale
  • Designing a system that supports both archival storage and user-driven retrieval
  • Integrating multiple AWS services into a cohesive, maintainable architecture
  • Providing a usable interface for exploring archived data

Outcome

  • Delivered a complete cloud-native platform spanning ingestion, processing, storage, and user interaction
  • Transformed a complex archival workflow into a scalable, asynchronous system
  • Enabled both programmatic and user-facing access to historical SmartLabel data
  • Demonstrated end-to-end ownership across backend architecture, frontend development, and cloud infrastructure