SSGC Field Activity Reporting System
An internal web application developed during my Software Engineering internship at SSGC. It streamlined access to operational field-activity data and reduced dependence on manually written SQL queries for recurring information requests.
- Organization:
- Sui Southern Gas Company
- Period:
- August 2025 – September 2025
- Java
- Spring Boot
- Spring Security
- Hibernate
- JPA
- Oracle Database
- REST APIs
- Chart.js
Supervisors and management relied on manual SQL queries for recurring field-activity information. The process was slow, error-prone and difficult to scale.
A secure Spring Boot application exposing approximately 20–25 REST APIs with server-side pagination, hierarchical filtering from region to unit to sub-unit, and interactive Chart.js dashboards over SSGC’s production Oracle database.
Handling large operational datasets without loading them entirely into memory while keeping filtering usable for non-technical management.
Server-side pagination and hierarchical filtering keep data access responsive, while Chart.js dashboards provide clear operational visibility.
Authentication gate
Spring Security authenticates every request before it reaches the API surface, protecting internal operational data.
- 01Server-side pagination to handle large operational datasets efficiently.
- 02Hierarchical filtering across regions, units and sub-units.
- 03Interactive Chart.js dashboards for management visibility.
- 04Integration with SSGC’s production Oracle database.
- 05Delivered for internal deployment and real operational use.
Delivered for internal deployment and used by supervisors and management for field-activity tracking and reporting.
Role — Software Engineering Intern — sole backend developer on the application.
Next projectAbroad School Management System →