Back to Projects
Oracle APEX DeveloperJul 2024 – May 2025Sana'a, YemenView Project

Fuel Tracking System

Rebuilt a legacy Fuel Tracking System from Oracle Forms 6i to Oracle APEX 24.2, delivering a modern bilingual interface and dashboards for 50+ concurrent users at a public telecommunications corporation.

Key Metrics

50+
Concurrent Users
40%
Processing Time Reduction
25%
Error Reduction

The Problem

An outdated Oracle Forms 6i fuel tracking system was slow, difficult to maintain, and couldn't scale to meet the demands of a growing telecommunications corporation with 50+ concurrent users.

The Solution

Migrated the entire system to Oracle APEX 24.2 with a modern bilingual UI, refactored PL/SQL packages, and optimized SQL queries — reducing data processing time by 40% and manual entry errors by 25%.

Key Highlights

  • Rebuilt legacy Oracle Forms 6i system to modern APEX 24.2
  • Delivered bilingual interface and dashboards
  • Refactored PL/SQL packages and revised SQL queries
  • Reduced data processing time by 40%
  • Decreased manual entry errors by 25% in UAT

Tech Stack

Oracle APEX 24.2PL/SQLSQLOracle Forms 6iData Migration