Telegram CRM system (FastAPI, aiogram, PostgreSQL, Alembic, Redis)
BotLead — CRM system for small business
BotLead is a full-fledged CRM platform for automating the processing of applications from social messengers and managing sales. The system is aimed at small and medium-sized businesses and allows centralized management of clients, applications, and communications through a Telegram bot with a convenient web interface.
Key Features
Collection of applications through a Telegram bot with automatic lead creation
Management of leads in the sales pipeline with status changes
Assignment of responsible managers to applications
Built-in communication with clients directly in Telegram
Web dashboard for viewing and analyzing sales performance
Reminder and notification system for managers
Role-based access model (administrator, manager)
Event log and user action logging
Architecture and Technology Stack
Component Technology Version
Backend API FastAPI 0.109
Telegram Bot aiogram 3.3
Database PostgreSQL 16
ORM SQLAlchemy 2.0
Migrations Alembic 1.13
Cache/Message Queue Redis 7
Frontend React + TypeScript 18
UI Styling Tailwind CSS 3.4
Authentication JWT (PyJWT) 2.8
Validation Pydantic 2.6
Containers Docker + Docker Compose 3.9
Implemented Functionality
Backend
Development of REST API with complete documentation via Swagger and OpenAPI
Asynchronous request processing
Authorization and authentication via JWT
Clear role-based access model
Caching and background task processing using Redis
Data validation via Pydantic
Full support for database migrations with Alembic
Writing custom middleware and dependency injections
Telegram Bot
Asynchronous bot on aiogram 3.x
User application registration
Communication between managers and clients
Reminder and status update system
Distribution of applications among managers
Processing callback requests and FSM logic for dialogues
Frontend
SPA interface on React with TypeScript
Interactive pipeline dashboard
Display of sales statistics
Management of applications and managers
Authorization module and route protection
Responsive layout with Tailwind CSS
Infrastructure
Docker containerization of all services
Docker Compose for local project launch
Configuration of PostgreSQL and Redis containers
Environment configuration for development and production
Preparation of services for deployment on VPS
Personal Contribution
Designing the architecture of the entire system
Developing the Telegram bot from scratch
Creating the backend on FastAPI
Complete setup of the database and ORM
Implementation of authorization and security mechanisms
Integration of frontend with API
Containerization of the project and preparation for deployment
Repository
Project code available on GitHub:
https://github.com/Yegor10/crm-new
If needed, I can:
shorten the description to fit a resume or GitHub README;
translate the text into English;
prepare a presentation description for clients or freelance platforms;
format a technical case study with diagrams and schemes.
BotLead is a full-fledged CRM platform for automating the processing of applications from social messengers and managing sales. The system is aimed at small and medium-sized businesses and allows centralized management of clients, applications, and communications through a Telegram bot with a convenient web interface.
Key Features
Collection of applications through a Telegram bot with automatic lead creation
Management of leads in the sales pipeline with status changes
Assignment of responsible managers to applications
Built-in communication with clients directly in Telegram
Web dashboard for viewing and analyzing sales performance
Reminder and notification system for managers
Role-based access model (administrator, manager)
Event log and user action logging
Architecture and Technology Stack
Component Technology Version
Backend API FastAPI 0.109
Telegram Bot aiogram 3.3
Database PostgreSQL 16
ORM SQLAlchemy 2.0
Migrations Alembic 1.13
Cache/Message Queue Redis 7
Frontend React + TypeScript 18
UI Styling Tailwind CSS 3.4
Authentication JWT (PyJWT) 2.8
Validation Pydantic 2.6
Containers Docker + Docker Compose 3.9
Implemented Functionality
Backend
Development of REST API with complete documentation via Swagger and OpenAPI
Asynchronous request processing
Authorization and authentication via JWT
Clear role-based access model
Caching and background task processing using Redis
Data validation via Pydantic
Full support for database migrations with Alembic
Writing custom middleware and dependency injections
Telegram Bot
Asynchronous bot on aiogram 3.x
User application registration
Communication between managers and clients
Reminder and status update system
Distribution of applications among managers
Processing callback requests and FSM logic for dialogues
Frontend
SPA interface on React with TypeScript
Interactive pipeline dashboard
Display of sales statistics
Management of applications and managers
Authorization module and route protection
Responsive layout with Tailwind CSS
Infrastructure
Docker containerization of all services
Docker Compose for local project launch
Configuration of PostgreSQL and Redis containers
Environment configuration for development and production
Preparation of services for deployment on VPS
Personal Contribution
Designing the architecture of the entire system
Developing the Telegram bot from scratch
Creating the backend on FastAPI
Complete setup of the database and ORM
Implementation of authorization and security mechanisms
Integration of frontend with API
Containerization of the project and preparation for deployment
Repository
Project code available on GitHub:
https://github.com/Yegor10/crm-new
If needed, I can:
shorten the description to fit a resume or GitHub README;
translate the text into English;
prepare a presentation description for clients or freelance platforms;
format a technical case study with diagrams and schemes.
Kyiv 
Available for hire