* More than 17 years’ experience in management, development and extending of Oracle E-Business Suite spread across version upgrade, data conversion, data upload, customization... in a three ERP business cycle implementations & support.
o Managing/Supervising on ERP projects:
Implementation of Oracle Cost Management module.
Implementation of Oracle MRP module in three production lines at Egypt factory.
Rebuilding HCM modules (HR-Core, Payroll) and custom time management solution.
Building a customer complaints solution on Oracle Quality module.
Making an OUM documentation (DO-070, MC-050) on FIN, SCM, MFG, and HCM modules.
Upgrading Oracle E-Business Suite from 12.1.3 to 12.2.10.
Upgrading Oracle database from 11g to 19c.
Implementation of Oracle Data Guard 19c.
Extending Oracle E-Business Suite with Oracle APEX.
Migrating custom concurrent program to Oracle APEX, which integrated with Oracle EBS.
Unifying custom concurrent program layout.
Building a custom reports to collect custom objects data definition in Oracle EBS (Personalizations, Alerts, Custom Reports).
Building a financial business area in Oracle Discoverer as a business intelligence solution to be used by finance department.
o Managing/Supervising on building custom Oracle APEX solutions:
Job Order Drawings: which presents uploaded finished product designs into BOM module of Oracle EBS to be viewed in production halls.
Logistic shipments: which helps in recording all shipment details to be followed, like its POs, suppliers’ data, landed costs, arrival notes... etc.
iTransformers: is an internal web portal like iGoogle, iVodafone… etc. that enables users to access all company information systems, mailbox, administrative alerts… and so on.
Media Channel: Internal TV channel, which present latest company news, administrative decisions, advertising videos and important events on large screens in production halls, by a Java FX backend engine with APEX administrative user interface.
o Designing and developing (MRP, Inventory, HRMS) summary and management reports.
o Analyzing and leading developers’ team for developing a customized Time Attendance and Payroll systems on Oracle Applications.
o Tracking the materials by barcode scanning in manufacturing steps from raw material to delivering the finished product.
o Developing a custom item interface program for loading items information into Inventory Item Interface tables, by validating items according to their predefined item categories & category sets.
o Creating custom concurrent requests and request sets for Finance, Supply chain, MFG & HRMS Applications.
o Configuring Webutil utility, which there is not a document from Oracle explains how to install it on Oracle EBS R12.
o Building custom requests contain PL/SQL Packages, Procedures and Functions using Interface Tables & APIs for (FIN, SCM, MFG, HCM) tracks.