GA

Gamal Eldin Ahmed Aboud

Data Analyst | Data Engineer

New Cairo, Cairo, Egypt

Work Experience

  • Senior Data AnalystFull Time

    Square Engineering Firm

    Aug 2020 - Present -4 yrs, 11 months

    Egypt , Cairo

    • 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 moubark

      Jan 2003 

    Skills

    • Microsoft Excel
    • Microsoft Powerpoint
    • Leadership
    • Problem Solving
    • Project Management
    • Data Management
    • Performance Management
    • Automation
    • ETL
    • Integration
    View More

    Languages

    • Arabic

      Fluent
    • English

      Advanced

    Training & Certifications

    • Data Engineer

      DataCamp·2023
    • Modern Data Warehouse Analytics in Microsoft Azure

      Coursera·2023
    • Data Analyst with Python

      DataCamp·2023
    • Certificate of Completion for Tableau

      365 Data Science·2020
    • Data Analysis Track

      1 MILLION ARAB CODERS INITIATIVE·2020
    • ICDL

      Valeo Academy·2011
    • Course English

      Valeo Academy·2011
    • Course of human resource development

      Valeo Academy·2011
    • A certificate of appreciation and experience from armed forces

      Armed forces·2010
    • Industrial Safety

      Arabian Construction Company·2009
    Share this Profile