The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
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.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
Three years ago, we built a service provider booking app (plumbers, carpenters, electricians) from scratch, fully custom code. Took close to 4 months to get live.
Today, with AI tools like Claude and ChatGPT in the workflow, I think a comparable MVP could realistically ship in 4-6 weeks. The boilerplate and repetitive work compress fast, matching logic and payment edge cases still need real engineering judgment.
If you had to rebuild something similar today, what timeline would you expect?
Four to six weeks feels realistic for a focused MVP now. The acceleration is real, but matching rules and payment edge cases are still where the product needs careful engineering.
📊 HR Employee Attrition Dashboard | Power BI
Just completed another Power BI project focused on HR Employee Attrition Analysis.
I worked with employee data to understand attrition patterns across different areas such as:
• Department
• Age Group
• Job Role
• Gender
• Business Travel
• Overtime
• Job Satisfaction
• Years at Company
The dashboard includes KPIs, interactive slicers, charts, and a summary table to make HR data easier to understand and analyze.
🛠️ Tools Used:
Power BI | Power Query | DAX | Data Cleaning | Data Visualization
This project helped me improve my skills in HR analytics, data cleaning, dashboard development, and business insights.
More projects coming soon. 🚀
#PowerBI #DataAnalytics #DataAnalyst #HRAnalytics #EmployeeAttrition #PowerQuery #DAX #DataVisualization #BusinessIntelligence #Dashboard
We haven't disappeared tho we've been building.
so here is what we have been working on, you know job hunting already asks a lot from people.
You find a role that feels like a good fit, spend time applying, and then wonder whether your resume even made it past the first filter.
That's the problem we're working on.
We're building a Chrome extension designed to help job seekers understand how their resume aligns with a job they're applying for and help them tailor it for the role.
Not just:
“Here are the keywords you're missing.”
But helping you understand the gap between your experience and what the role is looking for, then showing you how your resume can be better positioned.
The goal is simple,
Spend less time guessing. Apply with more clarity.
We've just wrapped up the first part of the onboarding, and here's a small snapshot of what we're building.
More from the process soon.
Clean work🔥