Oracle Techno Functional Consultant

 

Description:

Major Duties and Responsibilities:

§ Support Finance team for any issues in AR, AP, GL, CE and FA

§ Respond Finance team for any queries and concerns promptly

§ Resolve technical and operational problems in a timely fashion

§ Creation of Finance Hierarchies and Approval Groups including Approval Limits in Oracle

§ Creation of Bank Accounts in Oracle System

§ Updating and Amending the Finance Approval hierarchies and Approval Limits in Oracle

§ Training and Knowledge transfer of Oracle Financial to the Application Users

§ Identify functional gaps and provide corrective actions

§ Ensure that requested deliverables meet customer specifications

§ Provide suggestions to personalize Oracle applications for optimal performance

§ Manual Clear or rewind of Financial transactions stuck due to User faults

§ Check Create Account Errors and inform the Application Users

§ Open Financial Periods of All Ghazzawi Group

§ Assigning and Revoking of the Responsibilities to Users

§ Coordination with Oracle Support to fix data corrupt transaction with Data fix

§ Creation of new Ledgers, Legal Entities, BSV, Operation Units, Natural Accounts

§ Enabling and Disabling of Account Code Combination

§ Assigning Security profiles and Security roles

§ Development of new ledger sets for managerial reporting

§ Creation and updating of Suppliers and Customers

§ Develop or Customize Oracle Reports, Xml Publisher Reports, and Pl/SQL Reports.

§ Designed/developed tables, views, various SQL queries, store procedures, functions and complex PL/SQL packages.

§ Design and code packages, functions, and procedures used in report and form custom module development.

§ Use validations to load validate data into the database after logging the appropriate error, warning, and informational messages.

§ Create custom and staging tables in Custom schema integrating them with EBS

Qualifications and Experience

Qualifications

Experience

· Bachelor’s degree in Computer Science, MIS or equivalent with a minimum of 6 years of related experience.

· Considerable knowledge of the principles and practices of application development and support.

· Knowledge of programming, object-oriented analysis and design and/or data and process flow analysis.

· Adequate knowledge of work flow management software such as Business Objects or ARIS is preferable.

· Proficiency in both English and Arabic Language