SGAI - Integrated Academic Management System

A robust full-stack ERP solution for higher education institutions, managing the entire academic lifecycle from enrollment to certification using the Spring Boot ecosystem.

2025 · Shipped

SGAI is a comprehensive Enterprise Resource Planning (ERP) system designed for Engineering Schools (ENSAT model). It digitizes administrative, pedagogical, and student life processes within a secure, N-Tier architecture. The system manages complex academic structures, including Preparatory Cycles (AP) and Engineering Cycles (GINF, GSR, etc.), enforcing strict data integrity rules. It features a sophisticated grading engine capable of calculating weighted averages (Coefficients per Subject and Module) and generating official PDF transcripts dynamically. Beyond simple CRUD operations, SGAI includes advanced modules for attendance tracking, conflict-free scheduling, and a mass-import hub for administrative efficiency. Security is handled via Spring Security 6 with granular Role-Based Access Control (RBAC) for Administrators, Professors, and Students.

The Problem

Educational institutions often struggle with fragmented systems where student enrollment, grading, and attendance are tracked in disconnected Excel sheets or legacy software. This leads to data inconsistency, lack of security, and manual errors in calculating GPAs and generating official documents.

The Solution

I engineered a centralized web platform using a clean Layered Architecture (Controller-Service-Repository). The solution implements a strict database schema using JPA Inheritance strategies to handle User Roles. It automates critical workflows such as transcript generation (via iText/OpenPDF) and mass user enrollment (via OpenCSV), ensuring data consistency and saving administrative time.

Class Diagram
Class Diagram
Package Diagram
Package Diagram
Sequence Diagram 1
Sequence Diagram 1
Sequence Diagram 2
Sequence Diagram 2
Use Case Diagram
Use Case Diagram
Admin Dashboard
Admin Dashboard
Import Hub
Import Hub
PDF Transcript
PDF Transcript
Schedule
Schedule
Teacher Grading
Teacher Grading
Year
2025
Role
Sole Developer responsible for the full lifecycle: Requirement Analysis, Database Modeling (UML), Backend Development (Spring Core), Security Implementation (Spring Security Filter Chain), and Frontend Design (Thymeleaf/Bootstrap).
Tech Stack

Java 17 · Spring Boot 3 · Spring Security · Spring Data JPA · Thymeleaf · Bootstrap 5 · H2 Database · OpenPDF · OpenCSV · Maven

Links
Source code
← All projects