Finding the right job often requires manually comparing a resume against dozens of job descriptions.

This project automates that process by:

Analyzing a resume against multiple real job postings Generating AI-powered match scores Identifying missing skills Providing resume improvement suggestions Storing results in a SQL database Visualizing insights in Power BI Offering a live Streamlit web application 🛠️ Tech Stack Python Pandas SQLite SQL Google Gemini AI API Streamlit Power BI VS Code 📊 Key Features AI Resume Analysis Resume-to-job match scoring (0–100%) Missing skill identification AI-generated recruiter feedback Resume improvement recommendations Database & SQL Stores analyzed jobs in SQLite Performs analytical queries Identifies skill gaps Finds best-fit companies and locations Power BI Dashboard Average Match Score Strong Fit Jobs Top Match Score Company Match Analysis Skill Gap Analysis Streamlit Application Paste any job description and instantly receive:

Match Score Missing Skills AI Feedback Resume Improvement Tips

📈 Dashboard Insights The dashboard provides:

Overall resume strength across jobs Best matching companies Skill gap analysis Job fit distribution Career improvement opportunities 🎯 Business Value This project demonstrates:

Data Cleaning Data Analysis SQL Querying AI Integration Dashboard Development Data Visualization End-to-End Analytics Workflow 🔮 Future Improvements Analyze 100+ job postings Automated LinkedIn job ingestion Multiple resume comparison Industry-specific recommendations Advanced skill trend tracking 👨‍💻 Author Gourav Jangid

Aspiring Data Analyst passionate about transforming data into actionable insights using Analytics, SQL, Python, Power BI, and AI.