GA
Gamal Eldin Ahmed Aboud
Data Analyst | Data Engineer
New Cairo, Cairo, EgyptWork Experience
Senior Data AnalystFull Time
- Job Details:• Member of the team responsible for implementing modules of SAP S/4HANA, including Finance, Controlling, Materials Management and Project Systems. • Member of the team responsible for implementing modules Autodesk Construction Cloud ACC as a Data Analyst. • Established Master Data Management for each Function and coding. • Implement and design the database for the Operating system (Labour System, Scaffolding, and others system. • Create The data Warehouse and data mart • Experience in ETL tools Like Informatica PowerCenter and SSIS. • Design the Data Architecture and Create Data warehouse and Data mart and Establish the Integration between Others • Create the Operational Dashboard, Performance Dashboard, and Strategic Dashboard. • Issue Recommendations to improve the business process and define the Business Analysis gaps. • Proficient in utilizing a range of BI tools, including Power BI, SQL, Python, and Excel, and data visualization techniques • Established a centralized business intelligence function to consolidate data from multiple sources and provide enterprise-wide insights • Collaborated with stakeholders to identify critical data requirements and design custom dashboards and reports • Implemented advanced data analytics techniques, such as modelling and root cause analysis, to uncover hidden trends and optimize operational efficiency • Established Document Management Framework and how to
Data Analyst & Purchasing SupervisorFull Time
Rowad Modern Engineering
May 2018 - Aug 2020 -2 yrs, 3 months
Egypt , Cairo
- Job Details:• Use Microsoft Power BI and Excel to create dashboards based on business needs. • Develop an Excel-based system to manage daily tasks. • Prepare required reports using data extracted from the Oracle ERP system. • Create operational dashboards to track daily work performance. • Generate hourly and daily reports for various operations. • Design and track KPIs for performance reports. • Organize the data warehouse by creating folders to store all Excel files and documents. • Cleanse and track data errors, ensuring they are corrected. • Collaborate with management to prioritize business needs. • Create payment reports, including checks and related financial data. • Develop and track Planning vs. Actual reports and Others Reports and Dashboards
Senior Purchasing CoordinatorFull Time
Rowad Modern Engineering
May 2017 - May 2018 -1 yr
Egypt , Cairo
- Job Details: Seeking new suppliers concrete Materials with Best Price (Hollow Block, Solid bricks, Concrete Tiles, Curbs, Interlock, Clay, and other items to approve from the project consultant. Cement Follow up Prices and supply that to projects Steel Follow up Prices and supply that to projects Supply Building Accessories. Supply Diesel for all Projects over 500 thousands liter by month. Generators Rent for projects. Follow up site requests, comparison sheet, purchase order, store received and received invoices. Prepares purchase orders by verifying specifications and price list obtaining recommendations from suppliers for substitute items. Negotiation and Interact with suppliers for purchase orders and price lists. Review deliveries against the orders. Track the status of any orders. Ensure that any invoices are sent to accounts for payment. Issue all reports for status site request, purchase order and invoices and Debt and follow-up Cheque for Every suppliers. Follow up manufacturers Products for approval from the projects consultants about ( cement, steel, concrete cement, accessories building and other items) Review and follow up Purchase officers about purchasing materials for all projects day by day and Reduce delay purchase orders.
Assistant Administration and Legal ManagerFull Time
Rowad Modern Engineering
Oct 2014 - May 2017 -2 yrs, 7 months
Egypt , Cairo
- Job Details:I worked team leader and assistant with my director consultant: Refaat Ghabour with the best six persons in administration department for service over 25 projects with Project managers, Accountants, administrators and accommodation Team leader 1) Administration Department 1. Accommodation Team Leader Searching for apartments and rental it for our staff. Negotiating and writing contracts for apartments. Buy Furniture required for more than 25 projects. Providing Accommodation places for staff Providing Accommodation places in the apartments and the camping in the site for staff more than 3000 worker by day Issuing monthly rentals for apartments. Traffic and inspection of apartments to ensure the preservation for Furniture in apartments for more than 300 apartments Continuous to delivery apartments finished to his owner and recovery the insurance. Check and review invoices for (electric, water, Gas , Maintenance ) for projects accountants 2. Security Supervision of Administrative Security for all Projects. Preparing requests to payment amount guard for all projects every month Supervision security for projects and movement of traffic them. 3.The facilities Handling procedures the Government interests. Dealing with government agencies for to provide projects facilities (water - electricity - telephone) Follow-up to the issuance of the necessary licenses 4. Equipment Rent and Diesel 5. Stationery processing 7. Canteen 8. Petty cash for administration and legal department For rental apartment for accommodation for stuff whose work in all projects Purchase accommodation requested and other things. 2) legal Department Administrative Investigations. Dealing with the social insurance office. Lawsuits Police reports for Accidents and thefts.
Education
Bachelor of Law in Faculty of law
Cairo University (CU)Jan 2016 - Jan 2021 - 5 yr
Bachelor of commerce in Business Management
Cairo University (CU)Jan 2004 - Jan 2008 - 4 yr
High School - Thanaweya Amma
aly moubarkJan 2003
Skills
- Microsoft Excel
- Microsoft Powerpoint
- Leadership
- Problem Solving
- Project Management
- Data Management
- Performance Management
- Automation
- ETL
- Integration
View More
Languages
Arabic
FluentEnglish
Advanced
Training & Certifications
Data Engineer
DataCamp·2023Modern Data Warehouse Analytics in Microsoft Azure
Coursera·2023Data Analyst with Python
DataCamp·2023Certificate of Completion for Tableau
365 Data Science·2020Data Analysis Track
1 MILLION ARAB CODERS INITIATIVE·2020ICDL
Valeo Academy·2011Course English
Valeo Academy·2011Course of human resource development
Valeo Academy·2011A certificate of appreciation and experience from armed forces
Armed forces·2010Industrial Safety
Arabian Construction Company·2009