Skip to content
SPSudhesh Prabhu
← All projects

Tiger Analytics for Lands' End · Data Engineer · 2022

Dynamic Promo Application

Sell-through scoring pipelines that set SKU-level promotional discounts for Lands' End's e-commerce platform.

  • PySpark
  • AWS EMR
  • AWS Glue
  • Redis

Problem

Promotions needed to respond to actual demand: discount the products that weren’t selling through, without discounting the ones that were.

Approach

  • Developed PySpark pipelines on AWS EMR to calculate sell-through scores from inventory, demand and sales data in S3.
  • Applied business-defined rules to determine promotional discounts for SKU-level pricing.
  • Automated processing with AWS Glue triggers, storing results in Amazon RDS and caching them in Redis for real-time access from the storefront.
  • Worked with the client’s product manager to refine requirements and ship enhancements as business needs evolved.

Results

Targeted promotions that improved inventory turnover, aligned pricing with customer demand and boosted engagement.