Telegram bot for managing employee tasks — Python

Developed a Telegram bot for monitoring task completion by managers.

The administrator creates tasks, employees complete them — the bot reminds, tracks progress, and keeps the manager informed.

What has been done:
- FSM dialog for task creation (5 steps: title, description, responsible person, deadline, priority).
- Automatic reminders 24 hours and 3 hours before the deadline.
- Task statuses: not started / in progress / completed / overdue.
- Deadline extension with mandatory reason and change history preservation.
- Daily summary for the administrator at 9:00 AM.
- Task viewing with filters: all / by employee / overdue / for today.
- Role model: admin and employee.
- Architecture for scalability: transition from SQLite to PostgreSQL with one line in the config.

Technologies: Python, aiogram 3, SQLAlchemy 2, aiosqlite, APScheduler, python-dotenv.
Result: ready bot @staff_tasks_control_bot, deployable with one command on any server.

#python #task_management #telegram_bot #telegram_bot_api #bot_development #aiogram #automation