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.

Awesome use case! Automating resume-job matching saves so much time.

Thrilled to share that I have officially completed the training program at Manara! ​Throughout this journey, I’ve deeply enhanced my technical skills in data and machine learning, working through rigorous projects and sharpening my expertise in building scalable, real-world solutions. ​A huge thank you to the entire Manara team and mentors for the incredible guidance and support. This is a solid milestone, and I’m super excited for the next chapter—gearing up for the AWS Certified Machine Learning Engineer exam and diving deeper into MLOps! ​#Manara #MachineLearning #DataEngineering #MLOps #AWS #ContinuousLearning

Huge congratulations, Hazem! Such a great milestone😊