Team Leader
AMC
Total years of experience :28 years, 7 Months
Dar ElFouad Hospiotal
Create top management reports using SAP BI.
Data Warehouse Project for General Organization for Export and Import Control
Design and create ETL application to extract data from data sources and load it to consolidated database. Teradata used as consolidated Database and MSAS used analysis server.
Egyptian Maritime Data Bank (EMDB)
Responsibilities within the scope of this project:
Design and Develop Intelligent reporting system using Tableau to satisfy top management and customer requirements.
Dealing with and resolving problems and issues which arise.
Identifies and translates business constraints, in collaboration with the technical team.
Defines business processes
During this period I had share a team in finalizing the analysis, design and development the Egyptian prosecution Offices.
This application written using C# ( thin client) with Oracle DataBase.
Follow up IT team on Maintain and the support the AMCO existing applications. Analyze, design and develop Al-Haya new requested applications. Participates in preparing module request for proposal for AMCO requirements for ERP solution. Participates in preparation for migration and loading steps for AMCO data into ERP (Oracle Financial) application
Shared in development the following projects:
1. Data Warehouse Project for Ministry Of Foreign Trade
Data Warehouse uses the customs data to extract information for Ministry of Foreign Trade.
A TeraData used as Database to hold the data extracted from the customs databases.
MicroStrategy used as OLAP tool to develop the Ministry of Foreign Trade required reports.
An application developed as a stand alone application to distribute it to the exporters to enter their export declaration locally. Then they print the export declaration report which containing 2D barcode. 2 D Barcode reader used to read the barcode found on the export report and move the export declaration data to the warehouse temporary database.
An application developed to connect to and transfer the data from Egyptian customs databases to temporary database and from the temporary database to the warehouse database.
An application developed to follow up the customs declaration loaded per year, month and days in sheet and graphics display with the ability to open the required declaration
2. Egyptian Customs Applications
Share the development team in develop the following applications
Main and Branched Cashiers System
Payment Approve System
Financial Budget System
Letter of Guaranty System
Payroll And Personnel System
Stock Control System
Current Account System
3. Mina Contractors Company Project
Develop the following applications
Project Control System
Marketing and Sales System
Accounting System
Human Resource System
4. Retail System
During this period I had successfully completed Design and Implementation the following systems:
Costing System of Salaries
Costing System of Material and Tasks
Costing System of Workshop
Costing System of Vans
Costing System of filling and Covering
Costing System of Tobacco and Mixed Materials
Costing System of Final Products
As a Teaching Assistant in the department of computer science, I was teaching computer languages BASIC, FORTRAN, C, besides Statistics courses