ERPilot AI

Project Overview

ERPilot AI is a full-stack AI-powered Enterprise Resource Planning (ERP) platform developed as an independent post-graduation project. The system centralizes employee management, inventory tracking, supplier management, sales operations, reporting, and AI-assisted business insights within a secure multi-tenant SaaS architecture. Built using Python and Flask, the platform demonstrates enterprise software engineering principles including role-based access control, tenant-level data isolation, automated reporting, inventory monitoring, and conversational AI integration powered by Google's Gemini models.

Problem Statement

Small and medium-sized businesses often manage employees, inventory, suppliers, and sales data across disconnected spreadsheets and isolated software tools. This fragmentation leads to poor visibility, duplicated work, reporting delays, and inefficient operational decision-making. Additionally, extracting business insights typically requires technical expertise, making data analysis inaccessible to many operational teams.

Solution Approach

ERPilot AI addresses these challenges through a centralized ERP platform that combines operational management with AI-assisted decision support. The system introduces secure multi-tenant architecture, enabling multiple organizations to operate independently within a shared platform while maintaining strict data isolation. Business modules are integrated into a unified workflow, allowing users to manage employees, inventory, suppliers, sales transactions, reports, and notifications from a single dashboard. Gemini AI integration enables natural-language interaction with business data, helping users obtain operational insights without requiring SQL knowledge or advanced reporting skills.

Architecture Overview

ERPilot AI follows a modular Flask blueprint architecture designed for scalability and maintainability.

• Multi-Tenant SaaS Design with tenant-level database isolation.
• Flask Blueprint-based modular architecture.
• SQLite database engine with PostgreSQL-ready structure.
• Gemini AI conversational assistant integrated through dedicated AI service modules.
• Role-Based Access Control (RBAC) system for Admin, Manager, and Employee permissions.
• Automated reporting engine supporting CSV, Excel, and PDF exports.
• Notification system for operational alerts and inventory monitoring.
• Secure authentication using password hashing and session management.

Tech Stack

Key Features

• Multi-Tenant SaaS Architecture
• Employee Management System
• Inventory Management & Stock Monitoring
• Supplier Directory Management
• Sales Order Processing
• AI-Powered Business Assistant
• CSV, Excel & PDF Report Generation
• Notification & Alert System
• Dashboard Analytics & KPI Tracking
• Role-Based Access Control (Admin / Manager / Employee)
• Tenant-Level Data Isolation
• Secure Authentication & Session Management
• Audit Logging & Activity Tracking

Lessons Learned