profile-img

John Edwar Tadros

Business Analytics Specialist at Orascom Construction

Giza, Egypt

Work Experience

  • Business Analytics SpecialistFull Time

    Orascom Construction

    May 2019 - Present -6 yrs, 1 month

    Egypt , Cairo

    • Job Details:- I took the privilege to be the first selected from a pool of resources to initiate OC Business Excellence vision, transforming Orascom’s database into Insights. • Designed Power Bi and Tableau comprehensive and ad-hoc dashboard for OC’s Top Management, Cost Control, Projects Control, Finance, IT and HR Directors. • Worked with a team of analysts making a data-driven impact on various business needs: o HR; Setting wages distribution strategy for 65K labor. o Finance; Clustering Company Expenditures and introducing Possible cashflow leveraging techniques. o Cost Control; Developing an understanding of labors Productivity behavior. o Planning; exploring the potential for company Resources circular economy. o Operations; Identifying bottlenecks through process mining and introduce new tools of automation. • Perform SQL queries, Python and R statistical analysis to support various department’s forecasting models. • Apply regular validation to check the integrity of data and detect outliers.
  • Analytics ConsultantFreelance / Project

    Azdan Business Analytics

    Mar 2019 - Aug 2019 -5 months

    United Arab Emirates

    • Job Details:-a My Team Handled many successful Large scale Projects giving support to the client through all stages from the planning step till going live covering a wide Horizontal exposure. My role includes: • Provide comprehensive analysis and Ad- Hoc analysis using different Business intelligence tools for United Arab Emirates University (Power BI) and NSCC international ltd (Oracle Analytics Cloud) • Use statistical models and operational research techniques to optimize client operations. • formulate conclusions and recommendations to be presented for Client senior leadership.
  • Cost Control EngineerFull Time

    Orascom Construction

    Jan 2018 - May 2019 -1 yr, 4 months

    Egypt , Cairo

    • Job Details:-A Proudly took department full responsibility for data analytics strategy starting from a 12 BN EGP project till implemented through the whole corporation. My role involved the main Cost Control tasks along with the initiative to renovate the Business Intelligence processes within the department as follows: • Provide Insights for PMs, and Cost Manager about improving Project Profitability and Cost reduction. • Proposed a detailed analysis and strategy to tackle the Company Indirect Cost Issue. • Automation of cost Control reporting system using Power BI tools • Optimized data flow channels through modeling of business processes using BPMN 2.0.
  • Education

    • Civil Engineering in Civil Engineering

      Cairo University (CU)

      Jan 2012 - Jan 2017 - 5 yr

    • High School - Thanaweya Amma

      diamond language school

      Jan 2012 

    Achievements

    VINCI Innovation Awards 2015:2020 Global Climate Challenge Sep. 2015 Twinkle Box Business Case – Paris, France • A prepayment and equipment solution to ease everyone's access to electricity. Awarded 2nd Prize Winner under the category of “Connected City and Urban Services”. Computer Skills

    Skills

    • Power BI
    • Excel power Tools
    • Tableau
    • Microsoft SQL Server
    • AutoCAD
    • Knime
    • Python
    • Civil Engineering
    • Management

    Languages

    • Arabic

      Fluent
    • English

      Fluent
    • French

      Intermediate
    Share this Profile