Appli-Tracker is a centralized dashboard designed to organize the job and co-op application process for university students, career coaches, hiring coordinators, and system administrators. Instead of juggling NUWorks, LinkedIn, Handshake, spreadsheets, and trackers, users get one platform where all applications, postings, analytics, performance metrics, and communication tools come together.

Demonstration Video: https://youtu.be/MW1a-I_FHPQ

Submission Doc: https://docs.google.com/document/d/1TmlUUN2x7ps-J0oeWKFS9AE_49s6qqudHZ14uU2oRSI/edit?usp=sharing

Github Repo: https://github.com/alantai26/Phase-3

This project was developed by:

• They can:
  • Add and manage job applications
  • Attach resumes and documents
  • Track platforms like LinkedIn, NUWorks, and Handshake.
  • View sorted application lists and status'

• They can:
  • See a dashboard of all student activity
  • Track interviews, offers, and outcomes
  • Filter students by application stage
  • Send messages & receive notifications

• They can:
  • Manage job postings across platforms
  • Track applicant counts and listing performance
  • Receive alerts on expired/expiring postings
  • Analyze platform effectiveness

• They can:
  • Monitor performance metrics and CPU usage
  • Review alerts and audit logs
  • Manage backups and restore points
  • Adjust retention policies and system configs

• Python
• Streamlit (Frontend UI)
• Flask (REST API)
• MySQL (Database)
• Docker & Docker Compose

The project runs entirely inside Docker.

git clone https://github.com/alantai26/Phase-3.git
cd Phase-3

SECRET_KEY=yourSecretKeyHere

DB_USER=root
DB_PASSWORD=yourDBPasswordHere
DB_HOST=db
DB_PORT=3306
DB_NAME=appliTracker

MYSQL_ROOT_PASSWORD=yourDBPasswordHere

docker compose up -d

• Streamlit UI:
  http://localhost:8501

• API root (optional):
  http://localhost:4000

Stop all running containers:

docker compose down

To reset database data as well:

docker compose down -v

The backend contains Blueprints for:

• /applications
• /resume
• /hiring
• /system-admin

Each supports:

• GET
• POST
• PUT
• DELETE

based on user stories.

• James - Student
• Marcus - Career Coach
• Sophia - Hiring Coordinator
• Jack - System Administrator