CLARA.AI: An On-Premise LLM-Powered Academic Administration and Analytics Platform

Indian engineering institutions face significant administrative bottlenecks, ranging from repetitive circular drafting to manual, error-prone data entry for university mark sheets. CLARA.AI (Comprehensive LLM-powered Academic Resource Administrator) is a full-stack, AI-driven platform designed to automate and augment these critical workflows. Operating entirely on-premise to ensure data privacy, the system integrates a local Large Language Model (Llama 3.1 and 3.2 via Ollama) with a Django-based Model-View-Template architecture. Key innovations include an AI Circular Generator that overlays dynamically drafted text onto institutional letterheads, and an Intelligent Academic Analytics engine that utilizes coordinate-based table extraction and LLM metadata enrichment to parse complex PDF mark sheets. Furthermore, CLARA.AI features a hybrid Natural Language Query (NLPQ) pipeline and a robust four-tier Role-Based Access Control (RBAC) system. By seamlessly unifying data management and generative AI without relying on external cloud APIs, CLARA.AI represents a paradigm shift in secure, intelligent educational administration.