Technical Team Leader
APPSPRO
Total years of experience :22 years, 9 Months
My Projects at AppsPro
• Al-Rajhi Bank
•Developing customized reports, Alerts, User Hooks, Personalization, workflow and OAF
•Integrate payments with third party application.
• Al-Rajhi Steel
• Developing customized reports, Alerts, workflow, User Hooks, Personalization, OAF.
• Digico
• Developing integration between oracle retail (POS) and oracle EBS
• RSAF (Saudi Air Force)
• Developing Extension and integration
• Migrating data from old system to oracle EBS
• Raada
• Developing customization, extension, personalization and alerts
• Emaar
• Developing Customization and enhancements for cost center restructuring
• Workflow Customization.
• Bravo
• Developing integration between billing system and GL, AR.
• Integrate between inventory and Fixed Assets
• migrating all the INV, AP, FA master data using Oracle standard API and interfaces
• Customizing PO Approval, PLA workflow
•Tadawel
• Assist in upgrading application from 11.5.10.2 to R12.1.3
•CMA
• Upgrade application to the latest family pack (Technology, Financial and DBI, SCM, HCM)
• Develop complex payment Extension and LG
•MCIT
• Develop integration, customization and extensions
DBA Activity
• Upgrade oracle application from 11.5.10.0 to R12.1.3 on Linux environment
• Upgrade oracle application db from 9.2.0.6 to 11gR2 for application 11.5.10.2
• Clone, backup, patching, autoconfig and install oracle application
• Upgrade AD utility, TXK, ATG and Jinitiator to latest patchset running on UNIX / Linux.
• Upgrade Oracle DB, technology stack, discoverer to latest release running on UNIX / Linux.
• Perform periodic maintenance plans, critical patch updates, point release upgrades, performance diagnostics, technology assessments and troubleshooting.
• Manage Oracle EBS 11i including DB 9i & 10g, patch analysis, patching, cloning, , concurrent manager and system administration.
Responsible for Oracle Cluster customer, applying patches and all CEMLI work.
DBA Activities:
Orascom Telecom:
•Migrating the AP, AR, GL data to a new production database after upgrading from 11.5.5 to 11.5.10.2
•Installing Oracle E-business suite 11.5.10.2 (windows 2003, XP, Suse, RedHat Enterprise Linux 3).
•Loading all the invoices and payments from test server to the production database using oracle API and Interfaces.
•Upgrading Dicoverer from 4.1.37 to 4.1.48.08
Development Activities:
Iraqna Telecom
•Develop all the custom reports needed for iraqnna telecom.
•Modifying the CST Average Costing Workflow to make all the transactions accounted against many accounts.
Orascom Telecom
•Develop all the custom reports needed for Orascom Telecom.
•Check printing solution.
•Implementing all the Discoverer business area and reports for GL, AP, Asset
Syriatel
•Upgrading 86 Custom reports from 11.5.5 to 11.5.10.2 then migrating those reports from windows NT to Solaries 9.
•Integrate between inventory and Assets through interface.
DBA Activities
• Installing oracle database 10g rel 2.0, Forms & reports Services 10g on
Red Hat Enterprise Linux v3.0. (Dell Server with Raid 5)
• Restricting access to data and services with least privileges,
implementing a new profile with new security features.
(password security, session managements).
• Audit the Data by means of value based auditing.
• Planning and schedule a backup strategy using RMAN scripts and DBMS_SCHEDULE package.
• Monitoring the performance of the database, finding out any invalid objects, unused indexes and any kind of locking held in the database.
check all the alerts created due to a differences between the base line statistics and the current statistics.check the sql advisor recommendation. And any other advisors.
Development Activities.
• Responsible for designing and developing UIS (Ultra Integrated System)
to automate all the process in ultra-print company using oracle forms 10g
And reports 10g.
The package include the following systems:
• Financial system
• Coasting system
• Asset system
• Inventory system
• Maintenance system
• RH (Request Handler)
• HR (Human Resource)
• PY (Payroll)
• iORG (Organizer )
Deployment Activities.
• Responsible for Deploying all the forms and reports developed by oracle forms and reports builder on Red Hat Enterprise Linux V3.0
• Importing all the Arabic fonts used in the forms and reports.
• Configuring the formsweb.cfg, registry.dat, default.env and httpd.conf
files used in the deployment phase.
• Create all the reports servers needed for running the reports and managing them.
• Deploy all the icons and images used in the forms (CodeBase or DocumentBase)
Senior Technical Consultant
DBA Activities:
• Loading the hr master data to the hrms application using oracle hr API.
• Installing Oracle E-business suite 11.5.10.2 (windows 2003, XP, Suse, RedHat Enterprise Linux 3).
• Planning and Supervising Backup strategies for apps Database (closed backup)
• Performing all System Administrator and Apps DBA duties (Handling Users & Responsibilities, Managing Concurrent Managers, Transactional managers, Worker, Tuning & Performance Monitoring, Cloning, Applying Consolidated Patches, security, etc…)
Development Activities:
• Design and develop a warehouse management system that integrate with inventory module through :
A) Obtaining all the stock locators, item, uom and any other attribute from the inventory module .
B) Posting the transaction from the warehouse module to the inventory module by using the inventory API .
• Applying all the standaralization for apps forms, registering the schema, creating all the needed table handler for database and items handler in each form, registering forms and functions. Dealing with most of the interface tables.
• Integrating the HRMS module with external payroll system build by Jdeveloper 9i
• Obtaining all the employees and hr structure from the HRMS module and passes all these values to the payroll system Through custom Views.
• Developing all the functions needed for the implementation of the hrms payroll module.
• Registering all the user defined functions used by the payroll module and writing all the payroll formulas.
• Through HRMS personalization I have Customized, changed the look-and-feel, layout or visibility of page content to suit a business need or a user preference.
• Developing a Letter of Credit module that integrated with the 11i Financial System.
• Developing a Letter of Grantee module that Integrated with the 11i Financial System
DBA Activities:
Using Advanced Replication
Responsible for Designing, Implementing, Tuning a replicated database for Flight information system. The database consists of two master site and a materialized view site. All these sites have been created by enterprise manager 9i. the transaction was pushed from the queue to the other sites on commit not by job.
Development Activities:
Responsible for Designing and Developing an integrated system for Orascom company to automate all the proccess in each branch .
Monitoring all the activities, tasks and requests through a central database.
The System modules are categorized as follow:
1- Administration and HR module.
2- Sales and Marketing module.
3- Request Handler.(managing the workflow of all the requests).
4- Evaluation and Exam system.
DBA Activities
• Oracle Database Administrator Track Instructor.
Development Activities
• Oracle Developer Track Instructor.