Oracle Technical Consultant
A Leading Company in the field of finance
مجموع سنوات الخبرة :23 years, 11 أشهر
- Oracle DBA roles
- MIS(Management Information System)
-Operations tasks (direct debit cycle- working on SADAD interface with banking - working on SIMAH project - working on mapping payments tool)
• Supervision and full responsibility for the Smart classrooms.
• Supervision and full responsibility for the site of the Institute.
• Developed small business owners assessment test.
• Developed (ILFEN) International License for Entrepreneurship exam.
• Enhanced small business finance for (ILFEN) International License for Entrepreneurship.
• Developing a business plan software for the small business owners.
• Developed a software to manage Entrepreneurship Association..
• Participation in organizing the SWAT analysis workshop for Prince Salman Entrepreneurship Institute
• Participation in organizing the Intel workshop "Global Technology Entrepreneurship II - Teaching Entrepreneurship " during the period 31-05-2011 to 01-06-2011.
• Participation in organizing the First KSU Forum on Entrepreneurship and Knowledge-based Economy during the period from 16-01-2011 to 18-01-2011.
• Participation in organizing the Intel workshop "Global Technology Entrepreneurship" during the period 05-06-2010 to 09-06-2010.
• Participation in organizing the Badir workshop "Starting a Biotechnology Business"
during the period 28-04-2010.
• Participation in organizing the First International Conference on Entrepreneurship during the period from 25-10-2009 to 26-10-2009.
• Participation in organizing the ALLY workshop during the period 10-06-2009.
• Participation in the (HRDF) Human Resources Development Fund field study of "small and micro businesses and their role in the economy".
• Member of the Diploma Mentoring for the academic year 1430H /1431H.
• Consultant for the following company for shares managemrnt system (Saudi Telecom Company STC - National Commercial Bank NCB - Saudi Paper - Rana Investment - Etihad Etisalat Mobily - Inmaia)
Project Description: Shares Management System (SMS)
Provide a full automation for all the activities of shares department in any company.
there is two version of SMS one is Client-Server and the other is wep enabled based
The major areas of Business function supported
- Accepting, maintaining, controlling and managing Shareholder Data after subscription
- Dividend issuance and Declaration
- Managing Dividend Payment
- Managing Dividend Checks
- Managing Company Remittance to the paying out banks
- Managing I/O docs to Shares Department
- Data Uploading from in circulation ،V Al tadawul
- Managing the General Assembly Module Activities
- Managing the subscription refund data and subscription data upload
- Managing Company Capital increase
- Managing standard share value change
- Managing Data Upload from SSRC.
Contribution : design database - develop sql and pl/sql - develop forms/reports ،V make export and import - load data using SQL-Loader
Ensure that the data and information in the organization are secure.
Ensure that the database is implemented correctly and interface correctly with the various other systems and applications.
Ensuring about the database performance.
Make pre-sale job like :
Product installations and demonstrations
Participate in technical conference calls
Define customers،¦ business problems and requirements
Provide technical pre sales phone support to prospects
Technologies and methodologies used: Oracle 9i rel2 ،V Developer6i - DS9i SQL - PL/SQL ،V Microsoft Visual FoxPro
The Clients
1- Saudi Telecom Company STC
2- Etihad Etisalat Mobily
3- MTC (ZAIN)
4- National Commercial Bank NCB
5- Ahlia
6- Medgulf
7- Saudi Paper
8- Rana Investment
9- Inmaia
10- Red sea housing services
11- Saudi Printing and Packaging
12- Aslak
Developing, implementing and updating any change requested in the following system:
Personnel and payroll system, Bill of Materials (BOM) system, Materials system, Master Fabrications (MFS) system
Inventory system, Purchasing system, Sales system, Shipping system, WIP (Work In Processes).
Drawback system:A system concerned with export &import transactions dealing with shipping and finance departments including different financial processes.
Security system:A trial to integrate between systems in our company to make them running as a hierarchical tree Programmatically which enables the user to connect with one account for all systems. This feature has been added as a ready tool to implement in future releases like that in Oracle Financial Application11i.
Instrument System:A system to measure the different instrument parameters using different units and under different environment.
Sending an automatic mail from database:In the Personnel system we have all data about each employee and we want to send information to each employee like greeting in its birth day or sending its salary or its absents or its vacations to check it and so on.
Contribution:analysis, design database-develop sql and pl/sql-develop forms/reports.
Technologies and methodologies used:Oracle8-developer 2000-SMTP Simple Mail Transfer Protocol-Oracle designer2000-Oracle Forms6I-Oracle reports6I-Oracle Discoverer 4-SQL Navigator3-VB6.
Vessel traffic System
Project Description: collect all data about the vessels and Monitor all vessels movements
Contribution : develop all the system.
Technologies and methodologies used: MSAccess97 - MSAccess2000
Personnel System
Project Description: Collect all personal date and insurance data of the employees and the company data
Contribution : develop the data base of the system - develop sql and pl/sql -develop forms/reports.
Technologies and methodologies used: MSAccess97 - Visual Basic 6.
Maintenance System
Project Description: collect all data about the problems that occurred in the center its reasons and its solutions
Contribution : develop the data base of the system - develop sql and pl/sql -develop forms/reports.
Technologies and methodologies used: MSAccess97/2000
Inventory System (Several types of inventory)
Project Description: Collect all date about the items and all issues, receives and adjusts in these items
Contribution : analysis and design the data base of the system - develop sql and pl/sql -develop forms/reports.
Technologies and methodologies used: Oracle8, Oracle developer 2000, oracle designer 2000.
Personnel System
Project Description: Collect all date about the solider.
Contribution : develop the data base of the system - develop sql and pl/sql -develop forms/reports.
Technologies and methodologies used: MSAccess97/2000, VB5
B.Sc. in computer science and automatic control engineering Faculty of engineering Alexandria university