Sree Veeranjaneya ERP System
ERP system for inventory, billing, and operations
Project Overview
Sree Veeranjaneya is a custom ERP system built for a spare parts manufacturing company. The platform handles the full operational cycle — from stock tracking and vendor management to billing, invoice generation, and sales analysis. Built with React and Spring Boot, it replaced a fully manual operation with a structured digital system used daily by the business.
Problem Statement
The company was tracking spare parts inventory, customer records, and vendor data entirely on paper and in spreadsheets. Billing was manual, invoices were generated by hand, and there was no way to view sales performance over time. Every process was slow and error-prone.
Architecture Overview
React frontend with Spring Boot backend and MySQL database.
System Architecture
React + TypeScript, Tailwind-based UI
Spring Boot APIs for business logic
MySQL for structured data storage
Key Features
Inventory Tracking
Inward and outward stock movement tracking with real-time stock level visibility across product categories.
Bulk Product Upload
Excel-based bulk product import for large catalogues — eliminates manual data entry for product listings.
Billing & Invoicing
Invoice generation with customer and vendor data pre-filled, payment tracking, and billing history.
Customer & Vendor Management
Centralised records for customers and vendors with transaction history and contact management.
Sales Analysis Dashboard
Management dashboard showing total sales, stock movement trends, and revenue insights across time periods.
Engineering Challenges
Large Dataset UI Performance
Product and transaction tables with thousands of records required pagination and optimized rendering to stay responsive.
Excel Bulk Import
Building a reliable Excel upload system that validates data, handles errors gracefully, and maps columns correctly to the product schema.
Multi-Level Authentication
Implementing role-based access for multiple user types — each with different module permissions — required a clean JWT-based permission structure.
Impact
Digitized end-to-end inventory operations for a manufacturing business previously running on manual records
Bulk product upload via Excel handles large catalogue imports without manual data entry
Role-based multi-user system with separate access levels for different staff
Sales analysis dashboard gives management real-time visibility into revenue and stock