Full-Stack • Enterprise • 2024

Dormitory CRM

An automated, all-in-one dormitory management system built for American University of Central Asia.

Dormitory CRM System

The Problem

Managing student housing at AUCA was a nightmare. Room assignments were tracked in spreadsheets, contracts were filed in cabinets, and communication happened through endless email threads. Every semester, the housing office spent weeks manually processing applications, assigning rooms, and resolving conflicts.


Students complained about slow responses, lost paperwork, and unclear room availability. Staff were overwhelmed with administrative tasks. The system was broken, inefficient, and didn't scale.

The Solution

Dormitory CRM digitizes and automates the entire housing management workflow. From application submission to room assignment to check-out, everything happens in one system. No more spreadsheets. No more lost contracts. Just clean, automated processes.

Student Management

Comprehensive student profiles with room assignments, contact information, and occupancy tracking.

Room Allocation

Automated room assignment system with conflict detection and availability management.

Document Management

Digital storage for contracts, applications, and important documents with secure access.

Analytics Dashboard

Real-time insights into occupancy rates, payment status, and dormitory operations.

Technology Stack

Backend
Flask
Frontend
HTML/CSS
Database
PostgreSQL
Architecture
RESTful APIs
UI Framework
Bootstrap
ORM
SQLAlchemy

Real-World Impact

Reduced manual paperwork by 80% through digitalization

Improved room allocation efficiency by 60%

Serving 500+ students across AUCA dormitories

Automated billing and payment tracking system

Streamlined check-in/check-out processes

The Journey

I built Dormitory CRM after seeing firsthand how inefficient the housing process was at AUCA. As a student, I experienced the frustration of unclear room assignments and slow communication. As a developer, I knew there was a better way.


The system was built with Flask for rapid development and PostgreSQL for reliable data management. I worked closely with the housing office to understand their workflows and designed the system to match their needs — not the other way around.


Today, Dormitory CRM serves over 500 students and has transformed how housing is managed at AUCA. It's proof that good software can solve real problems and make people's lives easier.

More Projects