Back to Project

Job Application Tracker & Dashboard

A powerful, automated solution for tracking and managing your job applications. This system automatically extracts job application information from your email inbox, stores it in a secure AWS RDS database, and presents it through an intuitive web dashboard.

Key Benefits

  • Automation: No manual data entry needed - automatically extracts job details from your emails
  • Organization: Keep track of all your applications in one place
  • Insights: Monitor your application status and response rates
  • Scalability: Cloud-based solution that grows with your needs
  • Security: Your data is securely stored in AWS RDS
View on GitHub

Dashboard Preview

Dashboard Preview

Features

Automated Email Processing

  • Extracts job application info from LinkedIn and JobsDB emails
  • Handles batch/digest emails from JobsDB
  • Skips duplicates based on company, job title, and date

Database Storage

  • Stores all applications in AWS RDS MySQL database
  • Auto-increments the number field for each new entry
  • Secure and scalable cloud database solution

Web Dashboard

  • View all applications in a responsive Bootstrap table
  • Search and filter by company, job title, platform, and status
  • See application details at a glance

AWS Integration

  • Secure connection to AWS RDS MySQL instance
  • Automated data pipeline for reliable storage
  • Cloud-based solution for better scalability

Data Pipeline Structure

┌─────────────────┐     ┌─────────────────┐     ┌─────────────────┐
│                 │     │                 │     │                 │
│  Email Inbox    │────▶│  Email Parser   │────▶│  Data Processor │
│                 │     │                 │     │                 │
└─────────────────┘     └─────────────────┘     └────────┬────────┘
                                                         │
                                                         ▼
┌─────────────────┐     ┌─────────────────┐     ┌─────────────────┐
│                 │     │                 │     │                 │
│  Web Dashboard  │◀────│  Flask Server   │◀────│  AWS RDS MySQL  │
│                 │     │                 │     │                 │
└─────────────────┘     └─────────────────┘     └─────────────────┘

Pipeline Components

Email Inbox

  • Source of job application emails
  • Connects via Gmail API
  • Filters for LinkedIn and JobsDB emails

Email Parser

  • Extracts job details from emails
  • Handles different email formats
  • Identifies duplicates

Data Processor

  • Cleans and normalizes data
  • Formats data for database storage
  • Handles batch processing

AWS RDS MySQL

  • Stores processed job applications
  • Maintains data integrity
  • Enables efficient querying

Flask Server

  • Serves the web dashboard
  • Handles API requests
  • Manages data retrieval

Web Dashboard

  • Displays job applications
  • Provides search and filter functionality
  • Real-time data updates