This is a notifier developed for Unilever BD, alerting on Out-of-Stock (OOS) and Addition-to-Stock (ATS) situations.
Tech Stack (Amazon Web Services - AWS): DynamoDB Lambda CloudWatch Python Boto3 smtplib

Output Notifications

Why DynamoDB?

• Key-Value Storage Design helped perform simple, de-duplicated insertions (+ updates) of SKUs.
• Flexible Schema helped handle offers, discounts - since not all SKUs have them live always.
• TTL (Time-to-Live) helped (periodically) delete outdated SKU's data, plus optimize resource utilization.
• CloudWatch Log Stream Monitoring triggered the Lambda Function, to notify (email) OOS/ATS-events.
• Enabling Global Secondary Index (GSI) helped query faster on timestamp (not primary key), to identify OOS.