Muhammad Rafey

Oracle APEX Developer and Oracle Technical Consultant with 8+ years of experience designing, developing, and optimizing enterprise applications using Oracle APEX, PL/SQL, Oracle Forms & Reports, Oracle Integration Cloud (OIC), REST/SOAP APIs, and Oracle Database technologies. Proven track record delivering scalable ERP, logistics, insurance, and financial solutions across UAE and Pakistan. Oracle-certified professional with expertise in cloud integrations, performance tuning, application security, and digital transformation initiatives.

Oracle APEX Developer - Ajman Ports and Customs (via Alpha Data L.L.C) - Ajman, UAE

(2025-10)

• PL/SQL & Database Development: Designed and optimized 50+ PL/SQL packages, procedures, functions, and database objects, improving transaction processing performance by up to 40% and supporting mission-critical port operations.
• Application Development & Customization: Developed and enhanced enterprise Oracle APEX applications and Oracle Forms/Reports used across multiple departments, reducing manual processing efforts by approximately 60%.
• Database Optimization & Security: Optimized complex SQL queries and implemented indexing strategies that reduced report execution times from several minutes to under 30 seconds.
• Support, Documentation & Collaboration: Provided system support, technical documentation, and training while collaborating with IT and business teams for continuous improvement.

Oracle APEX Developer - Tristar Group L.L.C - Dubai, UAE

(2024-03 - 2025-09)

• PL/SQL & Database Development: Developed and maintained 10+ Oracle APEX business applications supporting logistics and fleet management operations for hundreds of daily transactions.
• Database Optimization & Security: Collaborate on database design, optimize SQL queries, implement indexing/partitioning, and enforce security best practices for authentication and authorization.
• Oracle Integration Cloud (OIC): Implemented enterprise integrations through Oracle Integration Cloud (OIC), reducing data synchronization delays by over 80% and improving operational visibility.
• Support, Documentation & Mentorship: Led production support and optimization initiatives, maintaining system availability above 99.5% while mentoring junior developers and producing comprehensive technical documentation.

Software Engineer - Oracle - Nadia Neon Advertising L.L.C - Abu Dhabi, UAE

(2024-01 - 2024-03)

• PL/SQL & Database Development: Designed and optimized PL/SQL components supporting large-scale operational data processing, improving database performance and reducing batch processing times by 35%.
• Oracle APEX, Forms & Reports: Develop and customize Oracle APEX applications, Oracle Forms & Reports (11g and 12c) to enhance business workflows and reporting.
• Database Management & Performance Tuning: Manage Oracle RDMS databases, enforce data validation, optimize SQL queries, and implement indexing and partitioning strategies for enhanced performance.
• Reporting & System Integration: Delivered 25+ operational and management reports using Oracle Reports and Jasper Reports, providing stakeholders with real-time business insights. Integrated multiple third-party REST and SOAP APIs, enabling seamless data exchange and eliminating duplicate manual data-entry processes.

Senior Oracle App Developer - EFU General Insurance Ltd - Pakistan

(2021-10 - 2023-10)

• Application & Reporting Development: Led the development and enhancement of enterprise insurance applications serving multiple business units, supporting thousands of policy and claims transactions monthly.
• Database Management & Optimization: Oversee Oracle RDMS databases, implement data validation, optimize SQL queries, and enhance performance with indexing and partitioning strategies.
• Integration & Security: Successfully integrated banking and vendor APIs, enabling automated transaction processing and reducing reconciliation efforts by over 50%.
• Software Enhancement & Documentation: Improved application stability through proactive troubleshooting and optimization, reducing production issues and support tickets significantly.

Software Engineer - Oracle - Marten Digitals Pvt. Ltd - Pakistan

(2020-06 - 2021-10)

• Oracle APEX & Forms Development: Delivered multiple Oracle APEX and Oracle Forms projects from requirements gathering through deployment, achieving on-time delivery and high user satisfaction.
• PL/SQL & Database Management: Design and optimize PL/SQL packages, procedures, triggers, and dynamic SQL for Oracle Database (12c to 21c), ensuring data integrity, validation, and high-performance transactions.
• Reporting & Data Analysis: Develop and integrate Oracle Reports and Jasper Reports, delivering accurate, visually compelling reports for business intelligence and decision-making.
• Web Services & System Integration: Developed secure REST and SOAP integrations with payment gateways and third-party systems, improving automation and reducing processing errors.

Software Engineer - Xclusive Solutions Pvt. Ltd - Pakistan

(2020-03 - 2021-10)

• Multi-Language Development: Developed and maintained multi-technology solutions using Oracle APEX, Python, and PHP, delivering scalable business applications across diverse client requirements.
• System Integration & Web Services: Develop SOAP/RESTful APIs, integrate payment gateways, and implement secure authentication mechanisms.
• Infrastructure & Performance: Managed database and application infrastructure supporting business-critical systems while maintaining high availability and performance.
• Software Optimization & Documentation: Debug, optimize, and document technical specifications, user manuals, and release notes.

Bachelor of Science - Computer Science - IQRA University (2016-09 - 2021-05) Karachi, Pakistan