Mahmoud Ghanem
Portfolio

Data Analyst with 2+ years of experience using SQL, Python, R, Excel/Google Sheets, BI Tools (Looker/Tableau), dbt & BigQuery.

Master of Science in Information and Data Science

University: University of California, Berkeley | Expected Grad: Dec 2024

Coursework: Generative AI, Natural Language Processing(NLP) with Deep Learning, Applied Machine Learning, Statistics for Data Science, Data Engineering, A/B Testing and Experiments, and Causal Inference, Research Design and Applications for Data and Analysis.

Bachelor of Science in Accounting and Business Administration

University: Al Azhar University, Egypt | June 2010

Data: SQL, Python, Tensor Flow, PyTorch, NumPy, Pandas, R, Exploratory Data Analysis, dbt, BigQuery, Looker, Tableau, Power BI, Heap.

Other: Financial Analysis, Testing, systems operations, project management, and information services.

Data Analyst

Company: LaunchGood Inc. | Duration: Dec 2022 - Present

  • Conduct research on big datasets using SQL, Python, Excel/Google Sheets, BI Tools
  • Design, develop, and maintain robust dashboards and reports using Looker, Heap, Google BigQuery, and Sheets, enabling teams to gain valuable insights and make data-driven decisions.
  • Spearhead the migration of financial data from multiple internal and external databases/tables, resulting in the creation of comprehensive monthly financial reports for the finance team to identify profit leaks and optimize company performance.
  • Utilize SQL, dbt, and lookML tools to extract, transform, and load data from our MySQL database into data pipelines, facilitating the creation of actionable dashboards and reports.
  • Conduct in-depth data analysis, including campaign performance, conversion rates, user engagement, and financial reconciliations, delivering actionable insights to various VPs.

Data Analyst

Company: Accenture @ Google | Duration: Jun 2022 - Dec 2022

  • Conducted research on big datasets using SQL, Excel/Google Sheets, and internal Google Dashboards
  • Worked with project managers to understand and interpret complex business requirements into SQL queries and define metrics, automate processes, and improve workflows through analysis, coding, and database management
  • Conducted initial due diligence on technology and business operations, developed project documentation, integration plans, timelines, resource requirements, personnel structures, and go-live implementation and training schedules.

Software Test Engineer (UAT)

Company: Accenture @ Google | Duration: Jan 2020 - Dec 2022

  • Managed and tested Movies & TV Tools testing; including preparing XML test packages (MMC, MEC, Media files) for Partner Portal tool
  • Prepared mass avail files & packages to test avail backend data and ingestion pipelines performance
  • Used SQL to retrieve and summarize production data key points and tie back to user experience

Technical Support

Company: Accenture @ Google | Duration: Mar 2019 - Dec 2019

  • Curated, analyzed, and integrated user/system requirements into design specifications
  • Provided primary support for installation of application releases into production
  • Conducted project and issue management (status reporting, issue reporting, ETC/budget reporting)

Content Review Analyst

Company: Accenture @ Google | Duration: Oct 2018 - Feb 2019

  • Investigated and resolved issues regarding content that is reported for account support and/or safety; flag for action, and resolve within agreed-upon turnaround times and standards of quality
  • Understood and remain up-to-date with client policies and guidelines; resolved inquires according to defined policies and procedures

IT Project Coordinator

Company: United Group | Location: Cairo, Egypt | Duration: Apr 2014 - Apr 2017