Built AI Resume Analyzer & Text-to-SQL Chatbot using LangChain + Gemini | Python · Flask · RAG | Anthropic Certified

Atharv Mandhare  • Peerlist

Developed an AI-powered chatbot that converts plain English questions into optimized SQL queries using Gemini LLM and LangChain. Built an agentic workflow handling multi-step reasoning, SQL execution, and result interpretation — enabling non-technical users to query databases conversationally.

Text-to-SQL Chatbot

Developed an AI-powered Resume Analyzer using Python and Flask that evaluates a candidate’s resume against a job description by extracting text from PDF resumes and performing intelligent analysis using the Google Gemini (gemini-2.5-flash) API; the system applies prompt engineering to generate a structured output including a match score out of 100, identification of missing skills, actionable improvement suggestions, and an overall suitability summary, demonstrating practical implementation of large language models, document processing, and backend AI integration for recruitment and HR automation use cases.

AI Base Resume Analyzer

> It is the Clone of an Amazon website it is an Frontend design. > This project Utilizes HTML, CSS. > This Project is an Self devloped project.

Amazon Clone

> To Centralize and Optimize blood bank operations through an efficeint, userfriendly online platform. > This Project Utilizes HTML,CSS,PHP for frontend and backend develop, alongside MySQl for secure and scalable data management.