Oracle SQL and PL/SQL Expert, Oracle Developer Team Leader, Database Architect, ETL Consultant
Al-Masdar Saudi Systems Corporation (Previously Oracle Co.)
Total years of experience :26 years, 5 Months
1-Lead, Drive R&D of Oracle GRP technology initiatives like new tool evaluation, defining new standards, best practice leveraging.
2-Lead the analysis, design, development, documentation, implementation and maintenance of large/complex IT solutions for business processes.
3-Conduct Code Reviews, Capture Metrics to improve the drive better code quality for GRP Projects by working closely with Project Teams.
4-Provide technical expertise and recommendations in assessing new IT software projects and initiatives to support and enhance the existing systems.
5-Support the execution System Integration Tests (SITs), the User Acceptance Test (UATs), Unit Test (UTs) and conduct training plan, user guide etc.
6-Leverage existing solutions and global design to drive standardization, simplification to reduce implementation timelines and costs.
7-Drive technical reviews to minimize or eliminate risk of customization.
8-Investigate and resolve application functionality related issues and provide first Level support and troubleshooting.
9-Lead Integration, Migration and ETL (Extract, Transform, Load) Process.
1-Design and develop extensions in Oracle ERP to meet business requirements in accordance with technical development standards and best practices.
2-Design and develop Oracle applications modules extensions using SQL, PL/SQL, Forms, Reports, Oracle XML Publisher.
3-Develop complex technical objects in accordance with the technical development standards and best practices.
4-Design, develop, deploy, test and maintain technical objects that exist in oracle applications production environment, e.g. reports, interfaces, and custom applications extensions.
5-Support the execution of the Conference Room Pilots (CRPs)/System Integration Tests (SITs) and the User Acceptance Test (UATs).
6-Develop and maintain test scenarios for project team and end users.
7-Assist with testing and deployment of Release Update Pack and other module upgrades to keep application release level current.
8-Collaborate with business analysts, business users and other developers in conceptualization and development of new technical objects within the Oracle applications environment.
9-Gather business requirements and recommend industry best practices and work with functional knowledge holders.
10-Partner with business analysts and application super users to successfully complete projects.
11-Evaluate requirements from functional specifications and create efficient technical designs.
12-Make presentations to management, clients, and peer groups as requested.
13-Analyze and assess existing procedures to allow the application to respond to business changes.
14-Provide customer support for business critical application problems and issues.
15-Provide support to System Administrators relating to custom responsibilities, security profiles and menus.
16-Conduct research into new technologies, including tools, components, and frameworks.
17-Perform Technical consulting activities related to an Oracle E-Business Suite R11 implementation project on financials applications such as General Ledger, Accounts Payables, Purchasing, Fixed Assets, Accounts Receivable and HRMS
modules.
1- Setting up meetings; running meetings; writing and distributing meeting minutes.
2- Review, analyze, and create detailed documentation of business systems and user needs, including workflow, program functions, and steps required to develop or modify computer programs.
3- Review use cases and other technical documents with IT project staff to ensure business requirements are adequately reflected in technical planning documents.
4- Assisting in preparing the organization for CMMI.
5- Design and normalization of a logical data model that reflects the business processes of the organization.
6- Transforming the logical data model into a physical data model using Oracle Designer will then document and present the design to the applicable technical community within Omega Soft Company.
7- Implementing Oracle ERP Systems with oracle developer suite 10g.
8- Training end users for financial applications like GL, AP, AR, FA, PO, HR, Stock Control.
9- Making unit and integrated test to show the bugs and maintain it.
10-Assisting in installing database and application server.
11-Lead, manage Oracle technical team.
1-Assisting in system analysis and design.
2-Creating forms, reports, triggers, procedures and functions by oracle tools.
3-Creating Oracle Applications starting from system analysis and design phases, passing by implementation phase, reaching to testing and maintenance phases.
Using Oracle financial systems starting from execute primary functions stage, auditing and controlling functions passing by daily processing stage reaching to creating final reports.
1-NCC Software Engineering Methods. 2-NCC Software Engineering Management. 3-Object-oriented Softwar
1-Systems analysis and design. 2-Operation research. 3-Computer programming. 4-Applied statistics. 5
Mathematics, Business Administration, English Language, Law, Accounting, Auditing and Economic