Mahmoud Ghanem
CA
Summary
Detail-focused Data Analyst with 2+ years of experience for a diverse clientele including Accenture, Google, and LaunchGood. Hands-on experience in conducting research and statistical analysis on big datasets using SQL, Python, R, Excel/Google Sheets, BI Tools (Looker/Tableau); building automated pipelines using tools like dbt; and cleaning, aggregating, and organizing data from disparate sources. Graduate training in UC Berkeley’s Master of Information and Data Science (MIDS). Passionate about delivering sustainable, ethical, data-driven, and evidence-based solutions.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Data Analyst
LaunchGood Inc
12.2022 - Current
- Identified patterns and trends in large data sets and provided actionable insights 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 databases/tables and external sources like AWS, 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 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
- Maintained data warehouses and data marts to support business operations
- Generated ad-hoc reports to evaluate specific business requirements
- Updated and developed scripts and queries to extract and analyze data from multiple sources
Data Analyst
Accenture, Google
06.2022 - 12.2022
- Conducted research on big datasets collaborating with cross-functional teams using SQL, Excel/Google Sheets, and internal Google Dashboards to ensure data integrity and accuracy, resulting in better-informed decisions
- 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
Accenture
01.2020 - 12.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
Accenture @ Google
03.2019 - 12.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
Accenture, Google
10.2018 - 02.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
United Group
04.2014 - 04.2017
Education
Master of Science - Information and Data Science
University of California, Berkeley
Berkeley, CA12.2024
Bachelor of Science - Accounting and Business Administration
Al Azhar University
Egypt12.2010
Skills
- Data:
- ETL, Data Wrangling, Data Modeling, Data Visualization
- Statistical Analysis, Sentiment Analysis, A/B Testing
- Machine Learning, Deep Learning, NLP, Feature Engineering, Linear Regression, Random Forests
- Tools:
- SQL
- Python
- NumPy
- Pandas
- R
- dbt
- Git
- Looker, Tableau, Power BI, Heap
- Interpersonal:
- Attention to Detail
- Problem-Solving
- Communication
- Active Listening
- Adaptability
- Multitasking
- Other:
- Testing
- Project management
Certification
- 04/22 Data Analytics Professional Certificate (Google)
- 06/19 Business Analytics Nanodegree (Udacity)
- 07/15 Project Management Diploma (Regional IT Institute (RITI))
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Data Analyst
LaunchGood Inc
12.2022 - Current
Data Analyst
Accenture, Google
06.2022 - 12.2022
Software Test Engineer
Accenture
01.2020 - 12.2022
Technical Support
Accenture @ Google
03.2019 - 12.2019
Content Review Analyst
Accenture, Google
10.2018 - 02.2019
IT Project Coordinator
United Group
04.2014 - 04.2017
Master of Science - Information and Data Science
University of California, Berkeley
Bachelor of Science - Accounting and Business Administration
Al Azhar University
Similar Profiles
Maymouna DhifMaymouna Dhif
People Operations Fellow at LaunchGoodPeople Operations Fellow at LaunchGood
Sabrina AhamatSabrina Ahamat
Trust & Safety Lead at LaunchGoodTrust & Safety Lead at LaunchGood
Gretchen UgaldeGretchen Ugalde
MFA Candidate | Teaching Assistant at University Of California, IrvineMFA Candidate | Teaching Assistant at University Of California, Irvine
Denise Del Carmen DuranDenise Del Carmen Duran
Administrative Assistant / Dispatcher at SIA CarriersAdministrative Assistant / Dispatcher at SIA Carriers
Abbey MorganAbbey Morgan
Food Runner at High/LowFood Runner at High/Low