Oracle System analyst
Saudi chemical company
Total des années d'expérience :16 years, 5 Mois
• implementation project of CCCI Company.
• Supporting oracle applications: and addressing issues for the 2 instances (SCC, SITCO).
• Gathering the functional / process requirements from the business users & acting as a link between the business users and the technical team.
• Creating & maintaining application documentation and configuration using Oracle AIM methodology & provide training for users as needed.
• Define user responsibilities, set up custom menus and request sets based on user roles and client specified documents.
• Writing SQL quires, PL/SQL functions and procedures and creating oracle objects as per business needs.
• Supporting production environments and users on their daily interaction with the system.
• Team work with key users, functional manager, project managers & developers.
• Provide assistance to developers through TOAD as required & testing customizations.
• Log, view, access, monitor, follow-up and close Service Requests (SRs) online - Oracle Support.
• Completed full life cycle of implementation project for INARA trading company across two business groups in different geographical locations (UAE, KSA).
• Supporting oracle applications and addressing issues for the 2 instances (SLC, Nardeen).
• Go-live activities and post-implementation support by supporting production environments and users on a daily basis by responding to emergency requests.
• Gathering user requirements, functional design, provide assistance to developers and testing customizations.
• Define Value Sets, Descriptive FlexFields, and Custom Profile Options.
• Inventory setup, configuration and implementation involving all the mandatory and optional steps according to the business needs.
• Implementation of some inventory tools like Physical inventory, Max-Min Planning.
• Setup purchasing module with different approval hierarchies for requisitions and purchase orders and applying customizations for accounting according to cost centers.
• Implementing pre-receiving landed cost module.
• Implementing different types of sales orders with couple of discount schemes according to location, customer and sales type.
• Implementing shipping execution configuration.
• Customized sub-ledger accounting entries according to accounting categories.
• Define user responsibilities, set up custom menus and request sets based on user roles and client specified documents
• Writing SQL quires, PL/SQL functions and procedures and creating oracle objects as per business needs.
• Data uploading and manipulation through Open interfaces, API’s and Data loader,
• Data migration from legacy system to new application.
• Developing custom reports using oracle developer and TOAD.
• Log, view, access, monitor, follow-up and close Service Requests (SRs) online - Oracle Support.
• Creating Oracle reports using Report Builder.
• Writing SQL quires, PL/SQL functions & procedures.
• Creating oracle objects like tables, procedures and functions
• Installing and configuring computer hardware, operating systems and applications.
• Resolving hardware & software issues.
• Completed the mandatory national service as a computer science instructor, eight hours per week, 30 students’ class.
B.sc in Computer Science from University of Khartoum – Sudan (2007)