Oracle Apps Technical Consultant
Saudi Business Machines
Total des années d'expérience :18 years, 7 Mois
Work as Oracle Technical Consultant in Oracle EBS 12.2 Finance (AP, AR, GL) Modules.
Roles & Responsibilities:
Creating new Reports by XML, BI publisher to business as requested.
Creating new Forms and Supporting and Troubleshooting of existing developed applications Forms and Reports.
Creating SQL and PL/SQL Queries, Packages, Procedures, Functions.
Creating New Alerts for sending notifications to user in ERP system.
Have good technical skills and capability to interact with Business, Have good Knowledge EBS implementation & Support experience.
Have good experience on collecting requirements, interacting with teams and if needed on making project plans.
Work as Senior Oracle Developer.
Developing, Deployment and Supporting ERP System.
Roles & Responsibilities:
• Work as Oracle Developer Designing, Developing, Solving
and Fix troubleshooting in (HR, Finance, inventory) System for SAUDI RED CRESCENT AUTHORITY (SRCA).
• Participate in Design and Analyzing system,
• Validate the technical architecture of the applications, the way they are build and connected the one with the others
• Coordinate with various departments to work together according to business process requirement
• Installing and configure oracle weblogic server.
• Researched and troubleshooting of application issues from weblogic configuration to code issues.
Work as Team Lead Tech.
Analyzing, Developing and Supporting ERP Systems.
Roles & Responsibilities:
• Work as Oracle Developer Designing and Developing New System for (HR, Finance, Inventory).
• Participate in Design and Analyzing system.
• Validate the technical architecture of the applications, the way they are build and connected the one with the other
• Coordinate with various departments to work together according to business process requirement.
• Have good experience of Business and Functional Analysis of Saudi Electricity Company.
• Install Database 12C and configuration.
• Check and Ensures backup and recovery strategy.
• designing and managing large reporting databases & building data warehouse.
• Make database performance tuning and SQL tuning skills with hands on experience in designing and developing PL/SQL and shell scripting.
Work as Oracle Developer, CC&B Consultant, Senior Application Analyst and system Business Analyst.
Participate with HQ for Transfer Data from Legacy System.
Also, I been assigned as member of Team to rollout from legacy system to the new program (CC&B) customers care and billing system implementation in MAKKAH and TAIF.
Roles & Responsibilities:
• Participate in data analysis and designing with team cycle of CC&B (customers, accounts, billing, meters and violations),
• Good experience of Full-life cycle Customer Care and Billing implementation (CC&B) Experience
• Good experience in key functional areas of CC&B (customer management, accounts, meter management, meter read, billing, payment, credit and collection, Case Management).
• Good experience Techno functional of Oracle Customer Care and Billing CC&B.
• Good knowledge of Java (OUAFSDK)and configuration.
• Good knowledge of architecture, data model and Oracle Utilities Application Framework (OUAF). Good knowledge of OUAF (Oracle Utilities Application Framework).
• Good knowledge in Config tool such as BO, MO, UI Map, Business script, Service Script, BPA script, Zones and Portals.
• Good knowledge of CC&B batches and algorithms and plug in.
• Extensive experience of CC&B modules like Billing, Billing Segments, Rates, Customer information, Field orders, Field Activity, Metering, Payments, Credit and Collections.
• Have good experience of Business and Functional Analysis of Water utilities.
Work as Team Lead Tech.
Analyzing, Developing and Supporting ERP systems.
Roles & Responsibilities:
• Work as Oracle Developer for upgrade systems, Support and solving issues in systems (Billing, HR, Finance, Fines),
• Validate the technical architecture of the applications, the way they are build and connected the one with the other.
• Preparing Governance documents for analyzing data.
• Coordinate with various departments to work together according to business process requirement,
• Upgrade systems from Oracle Developer 6i to 10G, Database 9i to Database 11G,
• Participate with HQ Team for Analyzing and Designing to transfer
data (Customers, Accounts, Billing, Meters and Violations),
• Designing Tables and Forms for transfer data from Legacy
system to Customer Care and Billing (CC&B).
• Participate with HQ Team in Business and System Analysis and Development and Solving Issues for Data.
• Good Experience in Technical support, techno functional and implementation of Core CC&B.
• Good experience in Resolving user queries and Incidents in the Application and Support the Minor release roll outs.
• Good Experience in Techno Functional of CC&B.
• Update and install configuration Database from 9i to 11g.
• Creating and maintaining user accounts, passwords, profiles, roles and access rights.
• Good Experience of database performance tuning and SQL tuning skills with hands on experience in designing and developing PL/SQL and shell scripting
• Good Experience as a database architect/developer
• Good Experience and knowledge with Oracle 9i-10g-11 including Oracle RAC 10 & 11, Oracle Cluster ware, ASM, Data guard, Streams, Partitioning, Data Warehouse, OEM Grid Control, RMAN, SQL, PL/SQL, query optimization, backup & recovery
• Check and Ensures backup and recovery strategy for all environments.
Work in General Authority of Survey Analyzing, Designing and Developing ERP Systems in General Authority of Survey and
Developing system and work as Oracle Developer, DBA and Financial Consultant Company Design Program for Government Resource Planning System (GRP).
Roles & Responsibilities:
• Work as Oracle Developer to create and design forms in Development environment,
• Participate in Data Analysis and Designing Diagrams.
• Business Analyst for Preparing Governance documents,
• Setting up Database and Application Server WebLogic Server.
• Make Installation and configuration Database 10g.
• Creating and maintaining user accounts, passwords, profiles, roles and access rights.
• Check and Ensures backup and recovery strategy.
• Good Experience of designing and managing large reporting databases & building data warehouse
• Good Experience of database performance tuning and SQL tuning skills with hands on experience in designing and developing PL/SQL and shell scripting.
Worked as part of IT Team Analyzing, Designing and Developing Programs Health Management, Building Management, Investment and Land Management as Oracle Developer and Oracle Database Administration.
Roles & Responsibilities:
• Participate in Data Analysis and Designing Diagrams.
• Create and design forms for Building Management.
• Participate in Health Certificate program,
• Participate in program has been created where the customer submits license application to open the Shop
• Participate in Technical Agency program for building demolition and renewal License.
• Participate in program in Land Management.
• Install Database10g and configuration and fix issues.
• Check and Ensures backup and recovery strategy.
• Setting up Application Server Configuration.
Work in BESHAY Steel (Egyptian American for Rolling Steel)
Work in iron Smelting Factory there three Stages to get iron Billet
Work with Foreigner Team in Analyzing work and roles in The Factory Designing & Developing Programs with Oracle Developer,
Managing SCADA system & Linked with Database.
College of Computer Science 2004