Promotion Portal
A promotion reward automation management system
Overview
This internal automation project moved thousands of promotion reward records from manual spreadsheet workflows into a database-backed approval and payout process.
Problem
- Monthly recipient selection and payout review are handled in spreadsheets, creating a high risk of mistakes.
- Promotion history is hard to track, making audits and budget evidence expensive to prepare.
- After payout decisions are made, reward delivery and system updates are disconnected, causing duplicate manual work.
Solution
- Validate uploaded source data and store it in a standard RDBMS schema.
- Handle recipient lookup, reward calculation, and multi-stage internal approval in one system flow.
- Use APIs to batch-issue coupons or rewards and send result emails after final approval.
Key Features
Excel Data Validation Parser
A parser that accepts existing Excel templates and filters invalid accounts, amount errors, and malformed rows in real time.
Approval Workflow Engine
A multi-stage workflow that follows internal approval rules from request drafting to final department approval.
Batch Payment & Notification API
A processing system that automatically issues rewards to hundreds or thousands of users and sends bulk notifications.
Live Budget Dashboard
A monitoring view that compares monthly budget allocations with cumulative promotion spending and burn rate.
System Interfaces
Promotion batch queue
Process
Analyzed manual Excel settlement steps and designed an MSSQL database structure.
Implemented Excel parsing and detailed error validation for multiple formats.
Built a backend for secure settlement permissions and electronic approval workflows.
Designed payout API integration and error handling for asynchronous batch jobs.
Ran load tests with simulated scenarios to check operational efficiency.
Result
- Reduced promotion settlement and recipient review from an average of three days to under one hour.
- Reached 0% payout errors and demonstrated budget leakage prevention through layered validation.
- Made yearly and promotion-type history traceable beyond the limits of manual record keeping.
- Became a core internal tool used regularly by marketing and operations teams.
Project Specs
- Database Architecture
- Full-stack Development