Web-Based ERP System

Overview

This ERP system was developed to streamline daily operations. Staff can monitor stock opname in real-time, submit procurement requests with approval workflows, and manage attendance and payroll in a centralized platform.

Features

A web-based ERP system built to manage internal operations for PT. Inaugurasi Pelangi Nusantara, covering stock opname, procurement, HR, and reporting modules. Focused on organizing warehouse stock records and optimizing the PostgreSQL database for faster report query generation.

• Stock Opname Module (real-time stock tracking & inventory logs).
• Procurement System with multi-level approval workflow.
• HR Module (Attendance, payroll, and performance appraisal).
• Reporting system for warehouse activity and financial summaries.

Challenges & Solutions

The main challenge was handling large amounts of stock opname and activity log data, which originally slowed down the query response. The solution was optimizing PostgreSQL indexing on date and warehouse ID columns, and simplifying the aggregation query.

Lessons Learned

Developing this system taught me the importance of writing clean database migrations and structuring tables correctly. I also learned how to read query execution plans to optimize database performance.