profile-img

Abanoub Eskander Ghally

Data analyst and ERP functional consultant at Invent solutions

Heliopolis, Cairo, Egypt

Work Experience

  • Senior Business Intelligence EngineerFull Time

    PwC

    Aug 2023 - Present -1 yr, 11 months

    Egypt , Cairo

    • Job Details:Built a model for stock market transaction validation and fraud detection, automating fraud pattern identification and compliance checks with insights visualized through Power BI. Conducted thorough data analysis and Python-based validation to ensure alignment with internal policies and global regulations. Developed Python scripts to enhance audit efficiency, reducing manual review time and automating 70% of the validation and assessment process. Implemented automated data validation and reconciliation using Python and Power BI with DAX, streamlining audit processes and delivering real-time insights. Deployed custom auditing models and DAX-driven visualizations to identify operational risks and address discrepancies effectively. Improved data flow using Databricks and Apache Airflow, ensuring reliable and timely data delivery.
  • Business Intelligence EngineerFull Time

    PwC

    Dec 2022 - Aug 2023 -8 months

    • Job Details:Implemented advanced data visualization techniques utilizing Power BI and performed in-depth data analysis to drive comprehensive daily reports analysis for UK risk team • Collaborated closely with the financial risk analytics team in the UK to architect, develop, and provide ongoing support for robust data warehousing and business intelligence solutions. • Designed intuitive visualizations, including charts, graphs, and KPIs, to provide clear and actionable insights into sales performance, revenue trends, and customer behavior at Honda Center. Digital Analytics
  • Digital analytics specialistPart Time

    Johnson and Johnson

    Mar 2021 - Present -4 yrs, 4 months

    Egypt , Cairo

    • Job Details:Develop streamlined and automated approaches for gathering and delivering data, thereby reducing manual business processes where possible • Responsible for all aspects of data analysis, from meeting with regional managers to define and gather requirements through the delivery of insightful and powerful dashboards • Determine and create an optimal graphical display for critical measures, producing graphics and dashboard formats to convey process performance accurately and professionally. • Development of models to predict future volume and capacity needs. • Production of dashboards, KPIs, scorecards, executive decks, and exception tracking reports on a routine basis • Structuring of data to support drill-down analyses on process performance. • Analyze reporting requirements, extract and interpret data, and ultimately provide recommendations to management. • Participate in project teams and provide guidance on relevant metrics to support production needs.
  • Data analyst and ERP functional consultantFull Time

    Invent solutions

    Jan 2019 - Present -6 yrs, 6 months

    Egypt , Cairo

    • Education

      • Bachelor's Degree in Information system technology

        El-Obour High Institute

        Jan 2015 - Jan 2019 - 4 yr

      Skills

      • Advanced excel
      • SQL
      • Python
      • Data cleansing
      • Math
      • Statistics
      • Pandas
      • NumPy
      • Data Mining
      • Data Wrangling

      Languages

      • Arabic

        Fluent
      • English

        Advanced
      Share this Profile