System Analyst/Senior Oracle Developer
Saudi Ports Authority
Total des années d'expérience :16 years, 5 Mois
Responsibilities
• Analyze any new requirements
• Maintain and enhance old systems.
• Data cleaning for migrate to new Government ERP.
Achievements
Create inventory and covenant management system for IT department
Responsibilities
Analyze new requirements, maintenance and develop workflow application named NAS (Network Auto Tracking System) by oracle forms 10g, this system serve about 1000 employees and about 100 vendors such as (Ericson, Huawei, Nokia, Alcatel and Samsung). And serve MRN (Mobile Radio Network) department to follow up projects stages till final submit.
Achievements
• Create integration with ERP Financial module to redirect invoices.
• Migrate oracle forms & reports 10g to oracle forms & reports 11g.
Responsibilities
• Acting project manager to initiate, requirements analysis, quality assurance, confirm receiving and close the project (new IOMS application).
• Analyze new requirements, maintenance and develop IOMS application (Input Output Management System) by oracle 10g, this system serve about 1500 employees and they are insert about 200 transactions per day.
• Analysis the new requirements received by applications department.
• Create new application to follow Input Output documents in the ministry with municipalities. Response to any new requirements received from minister office staff.
• Create many integrations with inside departments or outside municipalities. Participate to develop web applications by Oracle ADF 11g.
• Create database jobs, triggers, packages, functions, procedures to serve business process for applications and integrations.
Achievements
• Reach the requested target for minster office on IOMS module to make sure no delays with any received documents from higher level management of kingdom and get full summarize reports to enhance the workflow for receiving documents.
• Build application to follow sent documents to municipalities and send notice by SMS or Email when the reply is delayed.
Responsibilities
• Analysis and develop for Riyadh International Cars Auction system.
• Analysis and develop for Real Estate Management system.
• Acting Project Manager to close MS Dynamics Great Plains 10.0 ERP project.
• Support for MS Dynamics Great Plains 10.0 ERP.
• Data migration between MS Dynamics Great Plains 10.0 ERP with other Oracle systems by using Microsoft Integration Manager 10.
• Create database jobs, triggers and database procedures to serve business process for system & create any needed database objects.
• Support other oracle systems as 'Public Transportation Center, Market for Vegetables and Fruits Wholesale.
• Manage four Oracle Database 10g servers and ensure of stability and ensure of daily backup taken.
Achievements
• Integrate Microsoft great plains ERP with oracle modules to redirect invoices and receipts amount to ERP.
• Create new application is called IOMS (Input Output Management System) to record transfers of documents between department and received from out of company.
Responsibilities
• Work as implementer in Ministry of Municipal and Rural Affairs Project to implement (HR, Financial, IOMS) systems.
• Developing applications using Oracle forms 10g.
• Create database triggers and database procedure to serve business process for system & create needed database objects.
• Participated in software system analysis.
Achievements
Implement and running Input Output Management System application (IOMS) at (Ministry of Municipalities and Rural Affairs)
Responsibilities
• Maintained and enhanced architecture for old systems (HR, Purchase, General Relations).
• Define business processes, managing systems, train the end-users and Implements systems and Maintenance.
• Train graduate Saudi's employees to use oracle forms 10g.
Achievements
• Migrate applications from old version (Oracle 6i) to (oracle 10g).
• Create module to print employee’s card.
• Create module as calendar for secretaries of departments to arrange appointments for managers.
Responsibilities
• Managing and developing applications using Oracle 9i as Database with Developer/2000 (V. 4.5) forms.
Achievements
• Migrate applications from old version (Oracle 4.5) to (oracle 9i).
• Integrate between EDox "Electronic Archiving" with Oracle applications.
* From 2001 till 2005 * Grade is good