Chapter 1. Setting the Stage
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.
This work was delivered in collaboration with Data Engineering Team and Internal Reporting Framework Team.
Chapter 2. Carrying the Work
Responsibilities in this project included 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, and Worked across 100+ report forms with varying business rules.
Chapter 3. What Changed
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.
Chapter 4. The Problem and the Response
Problem
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.
Solution
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.
Chapter 5. How It Was Built
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: The reporting request is routed into Python-based services that determine which Oracle or PostgreSQL sources need to be queried. Business rules and data transformations are applied so records from multiple HR domains can be normalized into one reporting shape. The processed result is returned through the internal framework layer for display, export, and further operational analysis.
Implementation details included 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), and Adapted business logic across 100+ forms.
Some implementation details are intentionally generalized due to internal system confidentiality.
Chapter 6. Application Flow
Primary Flow: Users select report parameters through dynamic forms. System processes data using SQL queries and transformation logic. Aggregated HR data is returned as structured reports for analysis.
