Telegram loyalty and management systems for the restaurant "YOUR"
Development of a full-fledged loyalty system in Telegram for automating interaction with guests of the establishment. The main goal is to provide the restaurant team with a convenient tool for customer retention and daily operational work, replacing complex and expensive external CRM systems.
My role in the project
Designing the architecture and developing the MVP system from scratch "turnkey" (Backend, Telegram bots, Web admin panel, infrastructure setup).
Implemented functionality
For clients (Telegram bot): Registration, receiving a personal QR code (or deeplink), viewing visit statistics. Receiving welcome bonuses and cyclical rewards. A separate bot for feedback and order placement.
For staff (cashiers/admins): A convenient interface for scanning clients' QR codes, confirming visits (in manual or automatic modes), and processing orders.
Web admin panel: A full-fledged dashboard for managing business processes. Includes client and cashier management, loyalty threshold settings, creating newsletters (with template previews), configuring all bot messages, exporting data to CSV, and maintaining an action log.
Security and anti-fraud: A reliable protection system against manipulations has been developed (cooldown between visits, daily limits, duplicate control, and the ability to block).
Technology stack and infrastructure
Backend: Python, FastAPI, aiogram (for 2 bots).
Database: PostgreSQL (using SQLAlchemy async).
Web interface: Jinja2.
Infrastructure: Docker / Docker Compose, Nginx (configurations for production), support for webhook/polling modes. A manage.sh script has been written for convenient environment management.
Result
The client received a fully functional and documented product, deployed on a production server (with prepared instructions for staff). The system covers the full cycle: from attracting guests and gamifying visits to returning clients through automated newsletters.
#python #fastapi #aiogram #sqlalchemy #docker #CRM #PostgreSQL #Deploy #web-programming
My role in the project
Designing the architecture and developing the MVP system from scratch "turnkey" (Backend, Telegram bots, Web admin panel, infrastructure setup).
Implemented functionality
For clients (Telegram bot): Registration, receiving a personal QR code (or deeplink), viewing visit statistics. Receiving welcome bonuses and cyclical rewards. A separate bot for feedback and order placement.
For staff (cashiers/admins): A convenient interface for scanning clients' QR codes, confirming visits (in manual or automatic modes), and processing orders.
Web admin panel: A full-fledged dashboard for managing business processes. Includes client and cashier management, loyalty threshold settings, creating newsletters (with template previews), configuring all bot messages, exporting data to CSV, and maintaining an action log.
Security and anti-fraud: A reliable protection system against manipulations has been developed (cooldown between visits, daily limits, duplicate control, and the ability to block).
Technology stack and infrastructure
Backend: Python, FastAPI, aiogram (for 2 bots).
Database: PostgreSQL (using SQLAlchemy async).
Web interface: Jinja2.
Infrastructure: Docker / Docker Compose, Nginx (configurations for production), support for webhook/polling modes. A manage.sh script has been written for convenient environment management.
Result
The client received a fully functional and documented product, deployed on a production server (with prepared instructions for staff). The system covers the full cycle: from attracting guests and gamifying visits to returning clients through automated newsletters.
#python #fastapi #aiogram #sqlalchemy #docker #CRM #PostgreSQL #Deploy #web-programming
Kharkiv 
Available for hire