Alexander Prospal
Computer Science • Economics
Projects

All Projects

A comprehensive list of all the projects I have developed through coursework and independent work. Now directing that experience toward AI and machine learning, building on a foundation in database design, security principles, and maintainable system architecture.

Focus areas
What I’m building toward
AI / ML Data Pipelines Relational Systems Security Fundamentals

Prefer projects where correctness is prioritized through solid data models, careful handling of sensitive information, and designs that remain testable and extensible.

Core Projects
Complete Systems

These are the projects I’ve taken end-to-end (architecture → implementation → real deliverable).

CSDS 344 • Computer Security
Secure Password Manager Application

A Java password manager with encrypted, file-based persistence and a JavaFX GUI built around an MVC design.

Java JavaFX MVC Encryption Input Validation

  • Designed and implemented a secure password management system in Java to store, retrieve, and manage user credentials through a structured MVC architecture
  • Developed a data model to encapsulate password objects with controlled access, validation logic, and persistent storage handling
  • Implemented file-based data persistence to securely load and save encrypted credential data across sessions
  • Built a JavaFX-based graphical user interface with multiple controllers to handle user authentication, password listing, and CRUD operations
  • Enforced input validation and separation of concerns between application logic, data model, and UI controllers to ensure maintainability and security
CSDS 341 • Intro to Database Systems
Theater Inventory Database System

A fully normalized PostgreSQL database with advanced SQL analytics and a Python CLI application layer in addition to a Flask UI.

PostgreSQL SQL Python Flask 3NF Design Constraints

  • Designed and implemented a fully normalized relational database in PostgreSQL to manage costumes, props, performers, and show assignments for a theater organization
  • Defined primary keys, foreign keys, composite keys, and referential integrity constraints to enforce data consistency and eliminate redundancy (3NF schema design)
  • Wrote advanced SQL queries including multi-table joins, grouping and aggregation, nested subqueries, and constraint-based filters to answer operational and reporting questions
  • Developed a Python application layer with a command-line interface to connect to the database, execute parameterized queries, and safely process user input
  • Implemented realistic business logic such as inventory tracking, availability checks, and summary statistics through structured query design and controlled transaction handling
Personal • Ongoing
Personal Portfolio Website (prospal.dev)

A responsive site to present projects and qualifications with a consistent layout and small UX touches.

HTML CSS JavaScript Responsive UI Accessibility

  • Designed and developed a responsive personal website to showcase academic projects, technical skills, and professional experience
  • Implemented a modular front-end structure using HTML, CSS, and JavaScript with a unified component-based layout
  • Focused on clean UI/UX design, accessibility, and cross-browser compatibility across Safari, Chrome, and Firefox
  • Deployed and maintained the site using Git-based version control and GitHub Pages hosting
  • Continuously iterate on design, performance optimization, and content structure to reflect current technical work
Next
Where this is going

Actively moving toward AI and machine learning projects that take the full pipeline seriously, including data acquisition and cleaning, model development and evaluation, and reliable deployment. My background in security and database systems supports that direction with strong engineering fundamentals.