← Back to Projects
Centralized Multi-Campus School Management System

Centralized Multi-Campus School Management System

Developed a comprehensive school management system handling admissions, student records, and operations across multiple campuses, serving close 1,000 students each year over 7 years. The system streamlines everything from digital applications to financial tracking through an integrated database architecture.

- Engineered a complete school management solution that revolutionized the admission and operational processes:
- Created a digital admission system with custom forms for parent data collection, feeding directly into a centralized database

Implemented campus-specific data retrieval systems allowing each location to access relevant student information
- Automated the generation of admission agreements upon staff approval, pre-filling with applicant information
- Integrated the database with multiple school operations including class creation, tuition management, and financial tracking
- Developed analytical dashboards for admission statistics and year-over-year comparisons
- Successfully served as the primary database for multiple campuses for over 7 years, managing approximately 1,000 students
- Built a single source of truth for all student-related data, enabling efficient multi-campus operations and data-driven decision making

JotForm GoogleSheets BigQuery LookerStudio