Job Insight Pro: Job Portal powered by Generative AI

Idea

I am Mit Suthar, set to graduate in May 2023. Currently, I am actively searching for employment opportunities on various job portals. As part of this process, I tailor my resume to align with the specific skills required for each job and utilize GPT to generate customized cover letters.

The extensive time spent researching job-specific skills and crafting cover letters prompted me to develop a solution. Thus, I conceived Job Insight Pro - an application designed to streamline the job search process. Job Insight Pro not only fetches relevant job listings but also provides valuable insights. These insights include a breakdown of missing and matching skills, as well as the percentage of alignment between the job profile and the user's resume.

Application Video

How to use it

The process is straightforward and user-friendly. Upon visiting the Landing Page, users can easily initiate their job search by clicking on the "Job Search" button in the navigation bar, which seamlessly redirects them to the Main Dashboard.

Once on the Dashboard, users are prompted to upload their resume by simply clicking on the upload button. Following the resume upload, users can then input the desired job title and location before initiating the search by clicking on the designated button. It's important to note that, although it may take a moment, the system efficiently processes the information.

Tick, tick - as the system works in the background, users can patiently wait for the results to populate. Soon, a comprehensive list of relevant job opportunities will be displayed, aligning with the specified job title and location criteria. This streamlined process ensures that users can effortlessly navigate through their job search journey, making the experience efficient and user-centric.

The application offers a second crucial feature: the ability to generate a cover letter. When the user clicks on the "Generate Cover Letter" button, the application swiftly produces a well-crafted cover letter. The generated content is then conveniently copied to the clipboard, allowing the user to seamlessly paste it into their document and create a polished cover letter.

This functionality not only streamlines the process of composing a cover letter but also ensures that the user receives a professionally written document. By simplifying the generation and integration of cover letters, our application empowers users to present themselves effectively in their job applications. This feature enhances the overall user experience by providing a seamless and efficient solution for one of the crucial aspects of the job application process.

MindsDB utilization

I must say without MindsDB, I cannot convert my imagination into reality. The unique concept of combining the AI model with the existing database helped in my project.

Job Insight using Generative AI

I leveraged the capabilities of GPT-4 by amalgamating it with comprehensive job details obtained from various job sites. Following the aggregation of job listings, I seamlessly integrated them with an AI model to extract valuable insights for each specific job opportunity. This strategic combination not only streamlined the process of gathering job information but also enhanced the depth of analysis, providing a more comprehensive understanding of the roles available.

SELECT input.title,input.company,input.location,input.apply_link,input.job_description, output.answer
FROM supabase_datasource.mainTB AS input
JOIN jobmodel AS output where input.resume_link=<user_id>
LIMIT 50;

AI models

I have developed several AI models designed to automate the creation of cover letters and facilitate semantic searches between job descriptions and resumes. In the following sections, I will elaborate on some of the specific models I employed in this process.

CREATE MODEL JobModel
PREDICT answer
USING
    engine = 'openai_engine',
    prompt_template = 'Using the resume and job description below, give me the matched skills, missing skiils based on resume and job description and percentage that how much resume match with job description. 
Take the output and put in below format

Format:
{
"Matched_Skills":[],
"Missing_Skills":[],
"Percentage_Matched":
}

    Resume:
    "{{resume_text}}"

    Job Description:
    "{{job_description}}"';

Presented here is an AI model designed to generate cover letter text. This sophisticated system has been crafted to seamlessly produce compelling and articulate cover letters tailored to individual needs.

CREATE MODEL mindsdb.cover_letter_model
PREDICT response
USING
    max_tokens = 1000,
    engine = 'openai_engine',
    prompt_template = 'I want you to work as a Cover Letter Guidance Expert. Based on provided Resume and job description generate me the cover letter within 500 words.

    Resume
    "{{resume_text}}"

    Job Description
    "{{job_description}}"

    ';

Project Details

Tech Stack

• Next JS

• Shadcn UI

• Tailwind CSS

• Supabase

• Mindsdb

Github Repo: https://github.com/mit-27/jobinsightPro

Future Plans

• Optimizing the job search API

• Resume enhance feature which improves the resume for specific Job

• Improving UI for user-friendly navigation

Feel free to hit me up with some new features.

Conclusion

I extend my gratitude to Hashnode and MindsDB for organizing this fantastic hackathon. A special thank you to MindsDB for providing the platform that allowed me to create a solution benefiting millions of job seekers. Participating in this event was an enriching experience, and I appreciate the support in bringing my ideas to life. Thanks again for fostering innovation and collaboration. Looking forward to future opportunities! #MindsDB and #MindsDBHackathon