Built Hypebuzz’s internal admin dashboard, enabling the company to oversee platform-wide ticket sales, payments, customer issues, and live event activity. The system includes real-time analytics, event controls, customer support tools, complimentary ticket issuance, and QR scan monitoring. I implemented race-condition prevention, payment confirmation workflows, and SQL automations to maintain accurate reporting and secure operations.
Challenge
The platform needed to reliably handle real-time payments, prevent invalid ticket issuance, and provide secure QR-based entry validation. A key technical challenge was handling payment race conditions — ensuring tickets were only issued after confirmed payment.
Approach
I engineered a full-stack solution with:
- M-PESA payment integration and confirmation handling
- Backend logic to prevent premature ticket issuance
- Automated email delivery with unique QR-coded tickets
- QR code scanner for real-time gate validation
- Dashboards for tracking purchases and payments
- SQL functions and triggers for payment updates and dashboard calculations
I implemented database-level safeguards and backend verification to ensure data consistency and prevent race conditions.
Result
Delivered a secure and reliable Dashboard system that:
- Allows management of customers, i.e wrong email and phone number entries during purchase.
- Prevents fraudulent or invalid entries.
- Provides real-time sales and payment visibility
- Improves operational efficiency for the company
Key features
- Dashboard tracking sales and ticket purchases in real time.
- Event Creation and Update page.
- Marketing page where admin sends promotional messages to his customer base.
- Ticket Management to handle issues arising from ticket purchase, like wrong email address. Also used to send complimentary and invite tickets.
- Check in dashboard to view ticket scans at the entrance in real time.
- Purchases page to track purchases in depth, including analytics.
Technical highlights
- Solved payment race conditions using backend verification and database consistency controls
- Implemented SQL functions and triggers for automated payment updates and dashboard metrics
- Built a real-time QR code validation system for physical event access
- Designed a secure ticket issuance workflow tied strictly to confirmed payments