Senior Information Systems Analyst & Software Designer
Alexandria Fertilizers Co.
Total years of experience :18 years, 8 Months
Oracle EBS:
•Manage the upgrade of Oracle E-Business Suite from version 11.5.10.2 to version 12.1.3.
(Project Duration: 9 Months, Estimated Budget: 120, 000 EGP, Role: Project Manager).
•Organize users and key users training for all functional modules.
•Implementation of Oracle Human Capital Management, Self Service, Time and Labor and Learning Management.
(Project Duration: 12 Months, Estimated Budget: 60, 000 USD, Role: Team Leader).
•Provide Internal Training Sessions and Prepare Training Material (Documents, Videos, Presentations, etc.).
•Optimize current reports and create new reports to help middle management make the most out of the information in the system.
Infrastructure, Backup, and Monitoring:
•Planning and Performing Hardware Upgrade for SAN Storage and Blade Servers.
(Project Durations: 1 Month, 40, 000 USD, Roles: Team Leader).
•Monitor and update IT Inventory, enhance and supervise the ticketing system.
•Optimize, Schedule and Monitor Backups.
Information Security:
•Replacement of Internet Firewall with Next Generation Firewall (Infrastructure Upgrade Phase1).
(Project Duration: 3 Months, Estimated Budget: 6, 000 USD, Role: Project Manager).
•Monitor current systems/networks regularly and develop better security practices, review internal network traffic for anomalies and take corrective/preventive steps.
•Review current IT policies, and implement new ones.
•Provide security awareness sessions and newsletters for the end user.
Management Tasks:
•Preparing request for proposals and tenders.
•Evaluating new and emerging technologies.
•Planning future upgrades and expansion (On-going two years project).
•Enhancing IT Controls and Internal operation, and maintaining quality standards.
•Preparing reports, forms, SOPs.
•Estimating budgets.
•Demand, Deployment and Roll-out management.
•Training employees, attending meetings, doing presentations.
•Monitoring and maintenance for the Server Room infrastructure (Air-conditioning, Power connection/UPS, HVAC, etc.)
•Administration and upgrades of Servers/Storage Infrastructure (IBM x-Servers, Blade Servers, SAN Storage, etc.)
•Administrate Alexfert Network Infrastructure (Cables/Fiber Connections, Edge Switches, Core Switch, Routers, Firewalls, etc.)
•Monitor VMware ESX infrastructure (ESXi, Vsphere, Vcenter, and VMware workstation).
•Monitor and Optimize Software infrastructure (Active Directory, DNS, DHCP, WSUS, File Share, MS SQL Server, Cisco ACS, Sophos Enterprise AV, PRTG, Red hat Linux Servers, etc.)
•Basic administration of Oracle EBS server (Red Hat Linux, Oracle Database, Oracle Application Server, Backup, Cloning, etc.).
•Supervising IT Helpdesk staff, monitoring tickets, printing, E-Mail, Desktop infrastructures, and CCTV.
•Oracle E-Business suite 11.5 administration and user support (General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Purchasing, Inventory, Payroll, Process Manufacturing).
(Project: Implementation of Oracle EBS, Duration: 2 Years, Budget: 500, 000 USD, Role: Developer).
•Introduction of new reports using XML Publisher/Oracle Developer.
•Working close to the end user to guarantee the alignment between the ERP System and the business.
•Provide user training as well as training material.
•Maintenance of AlexFert HR/Payroll custom built application (Integrated forms and reports).
•Using VMware Workstation and VMware ESX
(Project: Migration to VMware, Duration: 2 Months, Role: Assistant Project Manager).
•Management and execution of the new Finger Print Time Attendance Project in AlexFert including preparing and implementing a project plan, interfacing to Oracle ERP, and the alignment with Human Resources department.
(Project Duration: 3 Months, Duration: 3 Months, Budget: 20, 000 EGP, Role: Project Manager).
•Managing the implementation of LaserFiche Document Management System in AlexFert, as well as LaserFiche administration, user training, etc.
(Duration: 12 Months, Budget: 25, 000 USD, Role: Project Manager).
•Assistance with Server Hardware upgrade to IBM SAN Storage / IBM Blade Servers to implement virtualization with VMware.
(Project Duration: 3 Months, Budget: 45, 000 USD, Role: Assistant Project Manager).
•Requirements collection for Alexfert website and Coordination with the implementation outsourced team using a Content Management System.
(Project Duration: 3 Months, Budget: 12, 000 EGP, Role: Project Manager).
•Planning for implementation for Alexfert backup / DR Site.
(Project Duration: 1 Month, Budget: 3, 000 EGP, Role: Project Manager).
•Implementation, Deployment and Maintenance of Alexfert Local Intranet using Joomla CMS.
•Facilitate the alignment between business and IM/IT in the country.
•Support the local demand (portfolio) management.
•Ensure the decommissioning of local applications.
•Provide reliable input for the IM/IT budget planning.
•Demand Management.
•Incident & Problem Management.
•Deployment and Roll-out management.
•Service Level Management.
• Basic Installation and Administration of Sybase Adaptive Server Anywhere, Adaptive Server Enterprise, and MS SQL Server 2000/2005/2008.
• Analysis, Design, Development and Maintenance of various systems (Basic Micro banking Modules for small, medium and large Microfinance Institutions/Banks: financial, loan tracking, savings systems…etc) using Power Builder, Java, or ASP.Net to develop the user interface.
• Installation, basic administration, and performance analysis and evaluation of Sybase Adaptive Server Enterprise on Linux platform (Fedora Core 3) as compared to Microsoft Windows Platform (Xp/Server2003).
(Project Duration: 5 Months, Budget: 12, 000 EGP, Role: Research and Development).
• Database replication (SQL Remote) on Sybase Adaptive Server Anywhere and Sybase Adaptive Server Enterprise.
• Development of Arabic, English and French Interfaces, as well as supplying necessary documentation, help and user Manuals.
(Project Duration: 3 Months, Budget: 6, 000 EGP, Role: Translator and Technical Writer).
• Development of web-based systems using J2EE based technologies (Apache Tomcat, Struts, Servlet, JSP, Project Duration: 9 Months, Budget: 4, 000 EGP, Role: Java Developer).
• Conduct user training for systems users as well as providing technical support.
• Extensive software testing, simulation, and bug verification.
• Assistance during first phase of the setup of two subsidiary microfinance institutions:
o The study of the various relations between the new institutions and their parent banks.
o Conducting a field mission to perform an assessment of the MIS requirements to sustain a decentralized credit scheme through the identified branches.
o Covered computing equipment and telecommunication facilities.
o Study of the adaptation and modifications to the existing loan tracking software to meet the new lending strategies resulting from the conducted market study.
• Study and implementation of the migration plan from Sybase Adaptive Server Enterprise 11.5 to Oracle 10g (Database Structure, Triggers, and Procedures migration).
• Development of web application using Microsoft Visual Studio 2008 (ASP.NET and .NET Datawindow) (Project Duration: 4 months, Budget: 7, 000 EGP, Role: Research and Development).
Electrical and Electronic Communication Engineering
Thanaweya Amma, Maths Section.