Hospital System Migration to Oracle APEX

Project Overview: We are seeking skilled professionals to migrate our existing Hospital Information System (HIS) application developed in Oracle Forms and Oracle Reports to a modern, web-based architecture using Oracle APEX and BI Publisher. The current application serves as a critical system for managing hospital operations, including patient management, billing, inventory, HR, and more. The project involves converting all functionality, workflows, and reports while ensuring high performance, usability, and scalability. The target system should maintain data integrity, provide responsive design for access across devices, and include enhanced security measures. ________________________________________ Project Scope: 1. Application Conversion: o Convert all Oracle Forms modules to Oracle APEX. o Recreate all workflows, validations, and triggers in APEX. o Maintain or improve existing functionality while leveraging APEX features for better user experience. 2. Reports Migration: o Convert all existing Oracle Reports to BI Publisher. o Maintain the same report structure, data accuracy, and layout. o Enable flexible reporting options (e.g., scheduling, exporting to multiple formats). 3. Database Integration: o The current system uses Oracle Database. All data structures (tables, views, procedures, and triggers) must remain intact and optimized for the new system. o Optimize SQL queries for enhanced performance. 4. User Interface Design: o Create a modern and responsive UI using Oracle APEX. o Ensure a user-friendly interface for doctors, nurses, administrators, and other staff. 5. Security: o Implement role-based access controls. o Secure sensitive patient and operational data using modern encryption and authentication methods. 6. Testing and Validation: o Conduct unit, system, and performance testing. o Perform user acceptance testing (UAT) with stakeholders to ensure functionality and usability. Skills Required: • Expertise in Oracle Forms and Oracle APEX. • Experience with BI Publisher and converting Oracle Reports. • Proficiency in Oracle SQL and PL/SQL. • Strong understanding of responsive web design and modern UI/UX principles. • Knowledge of healthcare systems and data compliance standards (e.g., HIPAA, GDPR) is a plus. ________________________________________ Deliverables: 1. Fully functional and tested HIS application in Oracle APEX. 2. Converted and validated reports in BI Publisher.