My Computer Science Projects

Student Enrollment Application

Description: A web-based enrollment system that automates student data processing for 24 districts served by Ulster BOCES. The application features a drag-and-drop interface that processes Excel files containing student information, stores data in MS SQL Server, and automatically generates enrollment reports per course and district—eliminating manual data entry and streamlining the enrollment workflow.

Technologies: Java, Spring Framework, JavaFX, MS SQL Server, HTML, CSS, JavaScript, JDBC, Apache POI

Key Features & Implementation:

  • Built with Spring MVC to handle server-side logic, RESTful endpoints, and database operations across multiple districts.
  • Architected MS SQL Server database with JDBC integration, implementing optimized SQL queries for CRUD operations on approximately 2,000 student records.
  • Designed interactive web interface using JavaFX WebView and WebEngine, with bidirectional Java-JavaScript communication via JSObject for dynamic UI updates.
  • Leveraged Apache POI libraries (Workbook, XSSFWorkbook) to parse, validate, and generate Excel files programmatically.

Roomsy (Roommate Finder)

Project URL: Roomsy (Roommate Finder)

Description: A cross-platform mobile application (Android/iOS) that connects users with compatible roommates based on lifestyle preferences, interests, and location. The app uses a comprehensive profile system where users specify their preferences, habits, and desired living arrangements. Now released on both the App Store and Google Play Store.

Technologies: Flutter, Dart, Firebase, Google Cloud Vision API, MVVM Architecture

Key Features & Implementation:

  • Integrated Firebase Cloud Functions with Google Cloud Vision API for automated content moderation of user-uploaded profile images before storage.
  • Architected Firebase authentication flow with email verification, Apple Sign-In, and Google Sign-In for seamless and secure user access.
  • Implemented Cloud Firestore for secure user data management with role-based access control and data encryption.
  • Implemented cloud functions for account lifecycle management, including cascading deletion of user data and assets upon account removal.
  • Developed multi-tier caching strategy (in-memory, Firestore, and Firebase Storage) to minimize API costs and improve response times.
  • Following MVVM architecture principles for clean separation of concerns and maintainable codebase.