Lead Management System API

Role:Backend Developer

Year:2026

Overview

Built with FastAPI and SQLAlchemy, this backend service exposes endpoints for managing sales pipelines. It includes password hashing with bcrypt, access tokens, and pagination to optimize server response times.

Problem Statement

Sales teams struggle to organize inbound leads, leading to slow response times, duplicate entries, and high security risks with shared credentials.

Proposed Solution

Developed a centralized, role-based RESTful API that standardizes lead storage, tracks pipeline stages, and restricts endpoint access through JWT authentication.

System Architecture

FastAPI routes handle incoming JSON payloads, SQLModel classes define database models, and SQLAlchemy ORM manages transactional sessions linked to MySQL.

API Client Request

FastAPI routing

SQLAlchemy ORM

MySQL Relational DB

Key Features

JWT Role-Based Authorization
Password hashing with bcrypt
Dynamic lead filter query parameters
Paginated response schemas to reduce payload weight
Database connection pooling to optimize connections

Challenges Faced

Configuring database connection pooling in MySQL during bulk updates to prevent thread execution lockups under concurrent requests.

What I Learned

Learned how to design optimized database indexes, partition router modules, and write secure, stateless authentication middleware.

Gallery & Mock Previews

Mock System Frame

Active Database log

Technology Stack

Python

FastAPI

SQLAlchemy

MySQL

JWT

Development StatusCompleted

Source Code

Related Projects

IoT & Automation

Smart Home Automation (MQTT + ESP32)

In Progress

An IoT controller connecting local sensors and relays to an MQTT broker, offering low-latency web triggers.

Python

C++

ESP32

MQTT

+1 more

View Case Study

Backend Development

E-Commerce Backend API

Completed

A backend service modeling inventory, cart orders, and transactions using relational database schemas.

Python

FastAPI

SQLAlchemy

MySQL

+1 more

View Case Study