Role-Based Inventory Management System

Fullstack Developer
Project Overview
This system is a Java-based system for my client - FRAPS, a solar panel installation business. This system have individual accounts for different employee roles, such as administrators, sales personnel, inventory personnel, and IT support. Each account have specific permissions and functionalities. By implementing this system, It aims to simplify business functions, enhance efficiency, and reduce errors, ensuring clients' can maintain a high standard of operations while contributing to the renewable energy movement. Ultimately, this system enables the client to better serve their local community in Bulacan, and all over the country with improved services and organized management.
My Contributions
In the Inventory Management System project, I was responsible for the entire development process. I structured and normalized the database to ensure efficiency and data integrity. Additionally, I designed and developed the application using NetBeans IDE, connecting it to the database through XAMPP and MySQL. For the programming language, I utilized Java to build the system, handling all core functionalities and ensuring smooth operation.

Essentially, I developed the entire system from the ground up, combining my skills in database design, application structuring, and programming to deliver a fully functional Inventory Management System.
Developing this database management system for FRAPS Solar Works was a rewarding journey that highlighted the importance of aligning technology with real-world business needs. Through this project, I gained valuable insights into database design, normalization techniques, and the integration of modules for data handling. As well as improved my coding skills especially in Java programming language.

The process of understanding FRAPS Solar Works’ operational challenges—such as manual data management inefficiencies and lack of analytics—helped me appreciate the critical role of technology in solving real-world problems. By using tools like NetBeans and XAMPP, I was able to design a scalable and efficient system that organizes data, and reduces errors.

Moreover, working on features like service management, inventory tracking, and sales reporting emphasized the importance of modularity and clarity in software design. This project not only improved my technical skills but also strengthened my problem-solving abilities and taught me the significance of thorough documentation and testing. Overall, it was a fulfilling experience that demonstrated how well-executed technology can drive operational excellence and support growth
Role-Based Inventory Management System
Fullstack Developer
August 2024 - December 2024