Senior Oracle Developer (Oracle Forms & Oracle Analytics Publisher)

We are seeking a highly skilled and experienced Oracle Forms & Reports Consultant with 4 to 6 years of experience to lead a critical system upgrade and reengineering this role you will be responsible for migrating legacy Oracle Forms & Reports 6i environments up to the latest Oracle 14c infrastructure as well as modernizing the reporting layer using Oracle Analytics Publisher (OAP) on Exadata (ExaCC).

This is a high-visibility hands-on technical role requiring strong expertise in Oracle infrastructure database connectivity and report reengineering.

• Location: Manila Philippines (Client Location)

• Work Mode: 100% Work from Office / Onsite

• Contract Duration: 8 to 12 Months

• Experience Level: 4 to 6 Years

1. 1. Environment Setup & Upgrades

• Phase 1 Upgrade: Install Oracle Forms & Reports 12c in a test environment on Exadata (ExaCC) from the legacy 6i baseline; reconcile and validate the installation.

• Phase 2 Upgrade: Perform the subsequent upgrade and reconciliation of Oracle Forms & Reports from 12c to 14c (latest available version) within the test environment ensuring all components are thoroughly validated.

• Modernization Setup: Install the latest version of Oracle Analytics Publisher (OAP) in the test environment and configure its integration with Oracle 19c on ExaCC.

• Validation: Verify full connectivity licensing adherence and DB connectivity for the OFR 14c OAP stack and document the baseline architecture.

1. 2. Report Re-engineering & Development

• Migration to OAP: Re-engineer and develop legacy Oracle Reports 6i formats into Oracle Analytics Publisher formats.

• Template & Model Creation: Build robust data models design RTF/XSL templates and configure layouts within OAP.

• Validation: Conduct strict testing to validate that all newly engineered OAP report outputs exactly match the legacy originals.

1. 3. Testing Debugging & Documentation

• Execute a full recompilation of all upgraded Forms and re-engineered Reports.

• Conduct rigorous unit testing for each component documenting all test results comprehensively.

• Investigate debug and resolve all compilation errors and functional defects discovered during testing.

• Re-test resolved issues and drive the process to obtain official technical sign-off.

• Oracle Forms & Reports: Strong expertise in versions 6i and 12c (experience with 14c is a major plus).

• Reporting Tools: Proven hands-on experience re-engineering reports into Oracle Analytics Publisher (OAP) or BI Publisher including RTF/XSL template design and data modeling.

• Database & Infrastructure: Deep understanding of Oracle 19c and hands-on experience working within an Exadata (ExaCC) environment.

• Migration Experience: Proven track record of handling end-to-end upgrade and migration paths for Oracle legacy applications.

• Analytical Troubleshooting: Strong debugging skills to quickly isolate and fix complex compilation and functional defects.

• Documentation: Meticulous approach to documenting baseline configurations testing results and validation reports.

• Communication: Clear verbal and written communication skills to collaborate effectively with onsite teams and stakeholders.

• Opportunity to work on a cutting-edge Oracle modernization and cloud infrastructure project.

• Dynamic onsite work environment in Manila.

• Competitive contract remuneration package based on experience.

OSI Digital was founded in 1993 in California and now has offices in the US Canada India Philippines Dubai and Australia. Our client base ranges from start-ups to Fortune 500 corporations including Barnes & Noble College Hyundai Toyota Gilead Allergan Yamaha Planview Globe and Sketchers. OSI Digital has developed strong partner alliances with the worlds leading technology providers such as Salesforce Boomi Tableau Oracle Microsoft and Amazon Web Services.