Hany Elromany

Working as Oracle advance customer support ACS Global Expertise Centers

Managing EBS system R12- Hits HRMS system - Real Estate System- maintenance system

Responsibility and achieves :
• Project Manager for implementing E-Business for Rooya Company
• Project Manager for HITS DNA HRMS including modules (Payroll -HR Foundation - Time attendance management - Absence/leave management- Misconduct - Self-service and workflow for compensation and personnel- Alerting)
• Project Manager for MAP visualization Using Java Script & Apex integration with other Modules.
• Project Manager coordinator for custom Appraisal System on APEX published online.
• Project Manager Maintenance system for Compounds
• Oracle Projects superuser (Create project template - Create task & expenditure - Calculate cost to project cost module).
• Helping Oracle Consulting Team in solving issues (Follow SRs, Closing Periods, fixing bugs, create accounting issues, finding corrupt data)
• Project Manager for Published E-business Online
• Following Hard storage growing up and compare growing monthly & yearly

Manage EBS production with two nodes (APPS r12 & WebLogic 11g - Database - San storage HP p2000 G3- IBM storage V7000v2) on HP Blade System c3000
Manage Three EBS (One development & two test Environments for ebiz r12)
Project Manager for HR Project (MS Hits DNA Cloud)

• Installing Oracle E-business suite R12 application for implementation.
• Worked with Primary Datacenter setup DBA.
• Using hot backup and recreating control file from its trace backup.
• Taking Logical Backup of the database through export/import utilities and cold OS level backup.
• Code Automated Backups using Shell Scripting in UNIX/Linux and RMAN Scripts.
• Disaster Recovery of database pertains various types of database Failures and that too in different database modes.
• Establishment and maintenance of Sound backup polices with RMAN and ‘User Managed Backups’.
• Optimizing SQL queries and code.
• Detecting and troubleshooting the database using V$VIEWS.
• Monitoring Alert File regularly.
• Administering User Security.
• Managing the Oracle instance.
• Proactive Maintenance.
• Installing oracle application on multi tires more than one node.
• Running patch with utility opatch, ad patch, and hot patch.
• Installing printer on application local printer on anther OS or network printer.
• Maintained application forms, report, Flexfield and concurrent managers.
• Cloning application node and database node.
• Cloning from multi node to one node.
• Trouble Shooting concurrent managers and requests.
• Worked with profile options.
• Assign responsibility to users and auditing.
• Managing oracle SR
• Relink the executable files in apps& database file instance file
• Maintain apps schema structure rebuilt forms, reports, PLL and jar files
• Database Upgrade from 10g to 11gR2
• Project data recovery (Data guard) “physical standby database”
• Upgrade of ebiz application from 12.0.4 to 12.1.3
• Upgrade OS OLE4 to OLE5
• Move Oracle system Database and Application to new structure “HP 2000 SAN storage”
• Implement Weblogic 11g & Discoverer 11g with ebiz r12
• Cross-platform transportable tablespaces & Database
• Install Oracle RAC 11g two nodes with ISCSI SAN storage in Test environment
• Oracle Database 12c administration