
John Edwar Tadros
Business Analytics Specialist at Orascom Construction
Giza, EgyptWork 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 schoolJan 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
Languages
Arabic
FluentEnglish
FluentFrench
Intermediate