Human Capital Reporting System Migration

Mar 2024 - Oct 2024

Role: Backend Developer

Project Link Access to this project is restricted because it runs in an internal environment.
Human Capital Reporting System Migration thumbnail
Tech Stack

Overview

Led the migration of a large-scale Human Capital reporting system from legacy Oracle Forms and Oracle Database into a modern cloud-based architecture using Python, PostgreSQL, and Google Cloud Platform.

In Collaboration With: Data Engineering Team and Internal Reporting Framework Team

Responsibilities

  • Migrated Oracle Forms-based reports into Python-based reporting services
  • Converted complex Oracle SQL queries into PostgreSQL-compatible queries
  • Developed reporting logic using both Python and internal .cfg-based framework
  • Handled data aggregation from multiple HR domains into unified reports
  • Maintained consistency between legacy system and new system outputs
  • Worked across 100+ report forms with varying business rules

Outcome

Successfully supported the migration away from legacy Oracle Forms into a scalable cloud-based reporting system. The new system improves maintainability, reduces dependency on outdated technology, and enables faster and more reliable HR data reporting.

Detailed Breakdown

The section above is optimized for fast recruiter review. If you want the full implementation context, open the details below.

The existing system was built using Oracle Forms, which became difficult to maintain, scale, and integrate with modern systems. As the company moved towards cloud infrastructure, a full migration was required.

The solution was to rebuild the reporting system using Python and PostgreSQL on GCP, while preserving the original business logic and report outputs used by the Human Capital division.

Primary Flow

01

Users select report parameters through dynamic forms.

02

System processes data using SQL queries and transformation logic.

03

Aggregated HR data is returned as structured reports for analysis.

This project required working across two different systems: legacy Oracle-based architecture and modern cloud-based services. Each report had unique logic, requiring deep understanding of both data structures and business rules.

Implementation Flow

01

The reporting request is routed into Python-based services that determine which Oracle or PostgreSQL sources need to be queried.

02

Business rules and data transformations are applied so records from multiple HR domains can be normalized into one reporting shape.

03

The processed result is returned through the internal framework layer for display, export, and further operational analysis.

Implementation Details

  • Worked with both Oracle SQL and PostgreSQL
  • Developed reports using Python-based services
  • Implemented reports using internal .cfg framework
  • Handled complex joins, aggregations, and data transformations
  • Processed data from multiple HR domains (employee, attendance, performance)
  • Adapted business logic across 100+ forms

Some implementation details are intentionally generalized due to internal system confidentiality.

Explore More Projects

A few more top picks that show adjacent product, platform, and operations work across the portfolio.

View All Projects
Brill One-Page Landing Page Development preview Brill One-Page Landing Page Development Brill Hepa Filter | New product development Strapped Plate Generator Enhancements preview Strapped Plate Generator Enhancements Strapped Plate | Product enhancement QRIS Refund Reconciliation System preview QRIS Refund Reconciliation System Alfamart | New product development Stock Opname Application preview Stock Opname Application BRIX Performance | New product development