Tomps Project Management | Project Case Study

#Tomps Project Management Apps

##Architectural Overview

Tomps Project Management is a solution by Telkom Indonesia designed for structured project tracking, task coordination, and budget management. As a Backend Engineer, I focused on the stability and reliability of the platform's microservices backend, ensuring that project data and thousands of operational records remain perfectly synchronized.

// Project Info

##Key Features

Project Information Hub

Centralized management of project details, candidates, and master stakeholder data.

Geospatial Tracking

Integrated mapping features for visual project distribution and location tracking.

Serial Number & Asset Monitoring

Structured modules to track equipment serial numbers and field resources.

Detailed Progress Oversight

Dashboards to monitor overall project progress, task completion, and active status.

##Engineering Highlights

###Multi-Service Architecture

The platform's backend is split into specific service roles: - Core Services: Managed core systems implemented in Laravel (PHP) for baseline data handling. - Node.js Extensions: Built and maintained specialized services using Node.js, Express.js, and Sequelize ORM for leaner, faster feature updates.

###Database Stability

To manage the project hierarchies reliably: - Structured Relational Data: PostgreSQL serves as the primary database, utilizing standard indexing for steady data retrieval. - Stored Procedures: Moved complex aggregate calculations (like progress rollups) into PostgreSQL Stored Procedures to simplify the application layer and improve API response times.

// Geospatial Tracking

##My Role and Responsibilities

Testing & QA: Wrote clear unit tests using Mocha, Chai, and Sinon for backend services to catch bugs early in the release cycle.
Database Refinement: Tweaked PostgreSQL Stored Procedures to handle data aggregations safely without overloading the server.
Documentation: Maintained straightforward technical notes and API guides for the QA and frontend teams.
Maintenance: Monitored system logs and SonarQube reports to clean up technical debt and keep the codebase tidy.

// Stakeholder Management

##Technical Stack

- Languages: PHP (Laravel), Node.js (Express.js), TypeScript - Frameworks: Vue.js (Web), React Native (Mobile) - Database: PostgreSQL, Redis - Testing & Tools: Mocha, Chai, Sinon, SonarQube, Jira, Notion