Employee Management System

Role:Backend Developer

Year:2025

Overview

Exposes API paths to create, update, and search employees by designation. Utilizes structured joins in SQLAlchemy to optimize database retrievals.

Problem Statement

Human resource teams struggle to sync employee records across departments, resulting in outdated rosters and manual updates.

Proposed Solution

Developed an API backend that centralizes employee profiles, departments, and roles, using foreign key constraints to maintain sync.

System Architecture

SQLModel maps database models. SQLAlchemy handles transactions, executing query joins to retrieve departments and roles in a single database roundtrip.

API Client Request

FastAPI routing

SQLAlchemy ORM

MySQL Relational DB

Key Features

Employee, Department, and Role CRUD endpoints
Foreign key constraint validation
SQLAlchemy join query optimizations
Clean REST response models

Challenges Faced

Managing SQL session life cycles in FastAPI endpoints to prevent database connection leaks.

What I Learned

Learned the details of database relational constraints, session lifecycles, and relational database normalization.

Gallery & Mock Previews

Mock System Frame

Active Database log

Technology Stack

Python

FastAPI

SQLAlchemy

MySQL

Development StatusCompleted

Source Code

Related Projects

Backend Development

Lead Management System API

Completed

A secure RESTful API for tracking sales leads. Implements JWT token-based authentication and role-based permissions.

Python

FastAPI

SQLAlchemy

MySQL

+1 more

View Case Study

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