Moamen Yousry

Developer on JD Edwards ERP system (Reports, Forms, BSFN, Tables, Data structure, Tables Triggers, Data items (DD), UDCs and BI Charts). JD Edwards Administration and configuration (Datasource, OCM, Security Matrix, Users, Roles). Analysis input data and develop KPIs using charts on JD Edwards ERP System to visualize these data using (Bar, Pie and Line charts). JDE package build (Full- Update) Create OCM records Create JDE Datasource Developing APIs using Python to integrate JDE ERP with mobile apps

Establish the needs of users and monitoring user access and security Monitor performance and manage parameters in order to provide fast responses to front-end users Query Optimization, understanding query planner. Common Table Expressions Write Functions and Stored Procedures. Writing queries, dissecting queries making improvements to the speed database access. Control access permissions and privileges Develop, manage and test back-up and recovery plans Ensure that storage and archiving procedures

Develop a custom subsystem BSFN to be used in external Receiving and Sales Develop a custom report for Shipment Confirmation to do partial confirmation to Subsystem to do confirmation automatically. Develop a custom report for Items Reclassification application (P4116) to attached to Subsystem and do Reclassification automatically. Develop and design BI templates XML and attach it to batch applications. Develop KPIs and Finance reports for management

Maintain and developing on IBM DB2 and SQLSERVER 2016 database servers. Managing and maintain 6 branches database servers. Development new tools to improve business processes like (HR, Operations,). Applying data analysis tools to improve our business.

JDE E1 installation and configuration. Oracle Database Installation, Design Security, Tuning and Maintenance. SQLSERVER Database Installation, Design Security, Tuning and Maintenance. JDE ERP Developer Reports and Forms, BSFN, Tables, Processing Options, Data structure, Tables Triggers, Data items (DD), UDCs. Apply ESUs, ASUs and Language updates. Create and configure JDE security Matrix. Configure One View Reporting. Develop One View Reporting.

Upgrade JDE from E811 to E9.1 Creating and configuring JDE security matrix Creating and designing E1 Menu Creating and configuring Environments, Datasources & Pathcodes Creating and configuring Automatic Accounting Instructions (AAI’s) Develop JDE Reports,Forms,BSFN, BSV, DD, Workflow, DS, Processing Options and Table Conversion Create databases,instances,functions,procedures,triggers Manage, tune and maintain database Oracle RAC implementation and administration Troubleshoot database problems

Windows Server 2003 Administrator (Domain, DNS, IP Distributing, File Sharing, and Security). Windows Server 2008 Administrator. IBM Servers Disk RAID Management. Support and maintenance IBM servers’ xSeries, Acer PC’s, HP printers, Bi-Zebra Scales and DIGI scales. Microsoft Exchange Server 2003 Administrator. Kaspersky antivirus Administrator.

Algorism, Datastructure, Database design, Aotumata, Compiler, Probability, Standard Divitation, C, C++, Java, C#, Pascal.