Senior Oracle APEX Consultant
ABU DHABI POLICE
Total des années d'expérience :18 years, 3 Mois
• Making the analysis and full development of more than 10 Oracle APEX applications.
• Design & Build Applications from scratch to meet agreed requirements using APEX 5, 18, 19, 20 versions.
• Application Shared Component Design (UI, Process etc )
• Develop and enhance existing APEX Applications.
• Develop professional APIs (Packages, Procedures, and functions) to be used in APEX applications using PL/SQL.
• Using and enhancing third party plug-ins, and implementing complex dynamic actions.
• Pay strict attention to design details.
• Integration with other systems.
• Giving training for new junior developers on Oracle APEX.
ORACLE APPS TECHNICAL EXCPERIENCE
• Development and maintenance of customizations of Oracle Applications (SQL, PL/SQL, Forms, Reports, Oracle Workflow, XML Publisher) and deploying in Oracle environment.
• Develop and maintain all customized Oracle ERP applications according to customers business requirement for configuration.
• Demonstrated experience with Oracle Application Framework (OAF) and Approvals Management (AME).
• Monitor and resolve all application issues and escalates issues to management if required.
• Coordinate with the project manager and develop all project milestones and ensure compliance to same and monitor all projects and implement all applications according to standard processes.
• Participate in the development and maintenance of interfaces to and from the Oracle E-Business Applications.
• Deploying concurrent processes and custom development in Apps.
• Develop functional and technical design and documentation of Oracle Applications dependent data conversions, interfaces, custom reporting, and custom applications including.
• Data migration and Data Upload.
• Integration with other systems.
• Creating custom APIs to deliver dynamic solutions.
• Enriching the Workflow content with a HTML charts and modern style tables.
• Design and deliver technical solutions and specifications to engage with Project Managers, Functional Consultants and End Users to aid delivery of Functional
Core team member responsible for PM / ETM / PP / CRM & DMS Modules support including:
- SAP Solution Implementation: Design and implement SAP solutions by translating business requirements into configuration, Configure and maintain settings in SAP.
- Production Support: Provide routine systems operation support, Diagnose and fix system problems, Respond to end-user problems, maintain production and test environments.
- Change Request Management: Manage Requests for Minor Enhancements, Analyze requirements, develop specs, obtain approvals, make changes and test, and coordinate training.
- SAP Consultancy: Provide technical/functional process consulting, Work with business clients to analyze operations and propose changes / improvements, Design and implement technical solutions that meet business user requirements. Interface with other IT team members to successfully complete implementations.
- Training: Assist business clients with in-depth, advanced training, new user training.
- Technical Documentation: Develop detailed functional specifications for solution and perform functional unit testing, end user manual, Addendum to blueprint, MOM, emails …
- Testing: Create test scripts and participate in integration testing with appropriate end-user and technical groups.
Oracle Experience:
Forms: Developing Forms using Oracle Forms Developer.
Applications: Managing and implementing developed application.
DB Operation: Creating Triggers, Packages, Functions and procedures using PL/SQL.
Reports: Developing Reports using Oracle Reports Developer.
Making the analysis and full development of two modules using Oracle Developer Suite 10g:
Performance Management System: System for evaluating employees’ Performance each year and generate statistical reports for decision making.
Document Management System: Module that provides document control for the company, so they can keep track on the outgoing and incoming documents as well as generating the reference number for each document.
Install and maintain Oracle Database and act as DBA.
Data migration for other systems.
Backup and recovery policy for the live database.
Deploying Forms and reports with Application server.
Falcon Clinic System: having 3 main modules
Falcon Treatment Module.
Petty Cash Module.
Inventory Module for the clinic pharmacy.
Position: Oracle Software Consultant
Managing many Modules for Governmental project FEWA (Federal Electricity and water Authority):
• Financial Module
• Projects Module
• Billing Module
• HR Module
Applying change requests for the payroll module.
• Connections Module (Electricity & Water).
Designed and applied the connection module to organize the connection applications, generating work orders, Calculate the connection bill and to create consumer account then integrate with the billing module.
- Defining and analyzing ERD, Data models and physical database design.
- Installing and configure Oracle DB 10g and Application server.
- Data migration for other systems.
- Deploying Forms and reports with Application server.
- Managing Database remotely via VPN.
- Integration with other systems (Archiving system).
Managing many Modules for BEK Project (Beit El-Khair)
• Financial Module
• Compensation Module
- Developing Forms using Oracle Forms Developer.
- Managing and implementing developed application.
- Creating Triggers, Functions and procedures using PL/SQL.
- Developing Reports using Oracle Reports Developer.
- Making the analysis and full development of two modules using Oracle Developer Suite 10g:
Performance Management System: System for evaluating employees’ performance each year and generate statistical reports for decision making.
Document Management System: Module that provides document control for the company, so they can keep track on the outgoing and incoming documents as well as generating the reference number for each document.
Developing Reports using Oracle Reports Developer and Crystal Reports.
I was Oracle Developer responsible for developing forms and reports using oracle developer 9i and 10g, Creating Functions and procedures using SQL Plus, TOAD and SQL Developer.
Flight and tourism , host and hostess training institute, certificate achieved in the courses of modules ( safety, rescue, grooming and customer service).