AI Chatbot For Collage Document Query Resolution: Genie Assistant

College administrative systems face critical challenges managing information scattered across multiple documents and websites. This research presents Genie Assistant, an open -source, lightweight AI-powered chatbot leveraging Retrieval-Augmented Generation (RAG) for college document query resolution the system enables users to upload custom documents and query them in natural language using Streamli , Sentence transformers (all-miniLM-L6-v2), ChromaDB, and Flan-T5. Testing with 50 student users demonstrates 92% query accuracy, 3.2-second average response time ,89% user satisfaction, and 98.7% successful query completion. the system operates ensuring complete institutional data privacy. Implementation using open-source technologies eliminates licensing costs, reducing average query resolution time by 98.8% (from 28 minutes to 3.2 seconds). The five-layer architecture comprises user Interface, Processing, Storage, Retrieval, and Generation layers. Genie Assistant demonstrates that sophisticated AI capabilities need not require expensive commercial infrastructure while maintaining transparent, source-attributed responses.