Gemini Candidate Search Chatbot

I need a web-based chatbot that lets recruiters type plain-English requests—e.g. “Give me profiles of candidates with 2 years of experience and Python skills”—and instantly returns:

• a ranked list of matching candidates
• the exact SQL query that produced those results

The model behind the scenes must be Google’s Gemini, fine-tuned on our existing Oracle database. When the user asks for a profile, the chatbot should extract intent, translate it to SQL, fetch data, and answer with concise summaries that always include work experience, educational background, and skill-set certifications. Filtering by Python proficiency is essential; other skills can be added later without code rewrites.

Key expectations
• Use streamlit io for app development
• consider oracle database of atleast 1000 candidates profiles with columns like name, contact, years of experience, skills etc.
• Provide well-commented source code, model-training scripts, and setup docs that let my team retrain the model when schema changes.
• Accuracy benchmark: >90% match between chatbot result set and manually executed SQL for the same query.

Please outline your proposed tech stack, Gemini integration approach, and any prior work building NL-to-SQL systems when you respond.

Expecting well documented code, and detail documents with model diagram, PPT/doc format .