Yaser Ali elKhider Ali
Oracle e-Business Suite **i / R12 Applications Administrator
8i / 9i / 10g Database Administrator
Oracle Hyperion 11.1.2.1 Administrator
IT Trainer
aczhs6@r.postjobfree.com
Cellular 002***********
Personal Details
Date Of Birth
10th July, 1979
Nationality
Sudanese
Languages
Arabic (Mother Tongue); English (S/W/R Fluently);
Japanese (S/W/R Beginner);
Summary
Over 9 years of experience in IT implementation, IT project management, Budgeting, and IT Training. Proficient in managing projects, installations, configurations, administration, backup and recovery, performance tuning in three environments: Oracle e-Business Suite 11i/R12, Oracle Hyperion 11.1.2.1 and Oracle OLTP environments. Experienced in Oracle 9i/10g Database Administration on various platforms, installing and configuring Discoverer 10g with Apps 11i, patching, cloning, and performance tuning various Apps components. Proficient in Oracle Metalink troubleshooting and analytical problem-solving. Moreover, strong in Oracle Tools including SQL*Loader, Oracle Enterprise Manger, RMAN…etc.
In addition, migration of data from earlier versions of Oracle, from other databases and other data formats and reengineering the data access through stored procedures, database backups and tuning using utilities like optimizer, auditing and Oracle performance monitor. Collaborative team player with robust abilities to coordinate and communicate with others.
Career Objective
An Interesting position in a progressive organization that offers opportunities for advancement.
Academic Qualifications
Technical Diploma in Japanese Language and Literature from the College of Business and Communication (Kawasaki, Japan)
2013 – 2014
BBI Honors (Bachelors of Business Administration in Information Systems)
University of Lincolnshire and Humberside, UK.
1997 – 2000
Awarded the High School Certificate in Science after successfully completing the 12 year UAE Ministry of Education High School Programme (Zayed Al-Awwal High School – AlAin)
1996 – 1997
Professional Qualifications
Oracle11i e-Business Suite Applications Administrator Certified Professional
Oracle10g DBA Certified Professional
Oralce10g DBA Certified Associate
Oracle9i DBA Certified Associate
Oracle 6/6i Developer Certified Professional
Oracle PL/SQL Developer Certified Associate
Oracle Approved Trainer
CIW (Certified Internet Webmaster) Master Designer.
CIW (Certified Internet Webmaster) Certified Instructor.
MCP (Certified Microsoft Professional) educated.
Expertise
Oracle e-Business Suite 11i / 12 installation, configuration, administration, and patching.
Oracle Hyperion 11.1.2.1 Installation, configuration, administration, and patching.
IBM Cognos 8 BI Administration v8.4
Managing oracle projects.
Oracle Database (9iRAC/10gRAC) Installation, configuration, Administration, monitoring, troubleshooting and optimizing database for ensuring high performance.
MS SQL server 2005/2008 Administration
Installing and configuring Discoverer 10g with Apps 11i.
Unix Solaris 5.10 (SPARC-64bit), Unix AIX, HP UNIX (TRU64), Redhat Linux 4, and Microsoft Server 2003.
SQL, PL/SQL programming; and Oracle Forms and Reports (6i/9i/10g), and unix shell scripting
Software design and development, networking and internet technologies.
Skills
Worked on latest releases of Oracle e-Business Suite, Oracle Hyperion, database, application server, and discoverer while implementing the best practice.
Configuring 10g Application server with 11i/12, using SSL in DMZ setup, and multi domain URLs.
Experience in defining/analyzing ERDs, Data models and physical database design
Relation management skills with customers, partners and internal groups.
Ability to understand, communicate, and coordinate with all internal disciplines including Project Management, technical staff, senior management, finance, legal, procurement and human resources, or externals disciplines including subcontractors and customers.
Technical ability to learn and understand products
Self-driven, results-oriented with a positive outlook, and a clear focus on high quality and business profit.
Oracle Metalink Troubleshooting and analytical problem-solving skills
Strong understanding of Oracle e-Business Suite structures, theories, principles, and practices.
Strong understanding of Oracle Hyperion application structures, theories, principles, and practices.
Strong understanding of database structures, theories, principles, and practices.
Scripting and automating repetitive administrative skills
Capable of working in teams under demanding circumstances
Ability to manage teams in-line with complex deadlines.
Excellent English and Arabic mastery, and very interested in learing new languages as well.
Ability to relocate.
Career Progress ( Experience )
November 2009 – May 2013 Senior Oracle e-Business Suite R12 Apps DBA and
Oracle Hyperion 11.1.2 Administrator
Abu Dhabi Gas Industries Ltd. (GASCO)
Apps DBA Job Duties:
Daily health checkup for all Oracle and SQL server databases, as well as the EBS and Hyperion applications.
Making sure that all scheduled backups has completed successfully.
Perform and manage Oracle EBS 11i/12 Post Production Support.
Regular database administration, backup, and disaster recovery procedures
UNIX support for the Solaris 10, Redhat Linux, and Oracle Linux.
Monitor, troubleshoot and optimize database ensuring high performance
Collaborate with software developers to achieve high performance from their database
Upgrade to new releases and ensure that highest versions are used.
Preparing shell scripts for the daily database and application backups.
Patching, Cloning, Performance Tuning various Apps components including database.
Setting up and managing a dedicated testing environment.
Hyperion Admin Job Duties:
Provide daily end user support.
Perform daily application health and performance checkup before users attending to use the system.
Insuring that the daily scheduled application and database backup was completed successfully without errors.
Perform application changes to entities, accounts, calculations/business rules, and migration of data.
Maintain access and security roles.
Perform application troubleshooting, as necessary for Hyperion Planning and HFM.
Install, build, and configure various Hyperion 11.1.2.x components in a distributed Windows environment including the Hyperion Foundation Services, Reporting and Analysis, Hyperion Planning, Essbase, Web Analysis and Financial Reporting.
Testing support for each of the products, including performance testing, integration testing between interfacing systems, and performance tuning.
Identifying, diagnosing and solving existing system issues.
Create and maintain consistent and thorough documentation of all processes and procedures for supported hyperion applications.
Maintain applications change/update and software upgrades.
Creating scripts for automating the daily backups for the application, essbase, and the RDBMS.
December 2006 – July 2009 Oracle e-Business Suite 11i / R12 Apps Admin and DBA
Dubai Holding – GroupIT, Dubai
Job Duties:
Working on live projects managing large databases
Classify key business processes and elements involved in project management, costing, billing, procurement, inventory management, and extentions.
Working closely with vendors’ teams as well as monitoring them for quality implementation of projects Suite modules, and reviewing the documents deliverable submitted by implementation vendor team during the handover process; and Scheduling in-house training courses for users and IT members on need basis.
Perform and manage Oracle EBS 11i/12 Post Production Support.
Installation of Oracle Real Application Clusters RAC
Monitor, troubleshoot and optimize database ensuring high performance
Creation of Oracle standby database and failover databases, and installing and configuring advanced replication.
Installation of the Multi-threaded server, Installation and configuration of printers
Implementing KEEP and RECYCLE pools, and building self-tuning database mechanisms.
Control user accesses and assign authority to all system users, and analyzing and deploying large databases.
UNIX support for AIX, HP/UX, Solaris 10, and Redhat Linux.
Regular database administration, backup, and disaster recovery procedures
Set-up and installation of backup and recovery software
Oracle disk architecture and disk load balancing, Oracle SQL Tuning, and Oracle design reviews.
Collaborate with software developers to achieve high performance from their database
Upgrade to new releases and ensure that highest versions are used.
Collaborate with vendors on implementing new solutions that requires database such as Maximo.
Installing and configuring Discoverer 10g with Apps 11i.
Implementing Disaster Recovery solution for apps using Maximum Availability Architecture.
Patching, Cloning, Performance Tuning various Apps components including database.
Monitoring Oracle Applications database including Forms, Web, Reports,
Setting up and managing a dedicated testing environment.
Configuring and Supporting Apps with multi Node RAC and multiple middle tier for High Availability.
Softwares used : Oracle e-Business Suite 11i/R12, Oracle RDBMS 9i/10g, Oracle Discoverer 10g, Data Masker, Toad 7.6, X-Manager, Putty, and MS SQL Server.
February 2003 – June 2006 Oracle Database Administrator and Faculty member
Al-Khawarizmi International College, Abu-Dhabi
Job Profile:
Installation, upgrading, database design and creation, configuration, administration, backup and recovery, performance tuning of ORACLE in both Data warehousing and OLTP environments. Migration of data from older versions and from other formats. Database auditing and working towards implementing highest security standards for running databases. Writing PL/SQL code for various batch processes, stored procedures and triggers to automate tuning and monitoring. Prepare and implement backup strategies. Associated with the development of in-house projects such as document management, client management, time resource management.
Software used : Oracle 8i/9i/10g
May 2001 – February 2003 Oracle Developer and Faculty member
AlKhawarizmi International College, Abu-Dhabi
Job Profile:
Module leader, Database design and Performance tuning, Front-end designand development, Oracle Reports, SQL, PL/ SQL coding, implementation and Training at site in Abu-Dhabi.
Software used: Oracle8i, Developer 6i Forms and Reports.
IT Proficiency
Applications : Oralce e-Business Suite 11i / 12, Oracle Hyperion 11.1.2.1, and Cognos BI 8.4.
Database : Oracle (9i/10g), SQL server 2005/2008
Application Server: Oracle 10g AS
Tools: EM, RMAN, SQL Loader etc.
Front End : Developer 6i Forms.
Reports : Developer 6i Reports.
OS : Windows 98/ME/XP/Server 2003, Unix Solaris 5.10 (SPARC-64bit), Unix AIX, HP UNIX, Shell Scripting.
Programming Languages : C, C++, SQL, PL/SQL, Visual Basic, Visual C++.
Web technologies : VBscript, JavaScript, ASP, XML, HTML,WebServers, and Apatche
Networking: TCP/IP, Microsoft Networking setup, and fundamentals of Cisco.
Fundamental Projects Associated
Upgrade of Maximo Oracle Database from 10.2.0.3 – 10.2.0.6
Abu Dhabi Gas Industries Ltd
Technical lead for the Oracle Hyperion 11.1.2.1 project implementation
Abu Dhabi Gas Industries Ltd
Upgrading Oracle e-Business Suite 11i to 12 RUP 4
Dubai Holding – Group IT
IBM Document Management System
Dubai Holding – Group IT
Upgrading Oracle e-Business Suite database to 10gR2 RAC
Dubai Holding – Group IT
Oracle e-Business Suite – Testing Envionment Sanitization
Dubai Holding – Group IT
IBM Portal REVAMP
Dubai Holding – Group IT
Primavera P6
Dubai Holding – Group IT
Maximo Enterprise Asset Management
Dubai Holding – Group IT
Hyperion Financial Management
Dubai Holding – Group IT
Bea SOA (Service-Oriented Architecture)
Dubai Holding – Group IT
Document Management System- In House Project
Al-Khawarizmi International College
Time Resource Management Software - In House Project
Al-Khawarizmi International College
Details to be firnished upon request.
References
Furnished promptly upon request.