Ahmed Maher Ghoneim

Experience

• 

  GlobeSoft

  Sept 2007 - Dec 2007

  Software Engineer

  Customized a document management system for Bibliotheca Alexandrina using Java, and Documentum.

• 

  Orange

  Apr 2009 - Jun 2016

  • Transitioned the advanced analytics function from informal efforts into a fully established team.• Designed and implemented analytical models, including lifestyle segmentation, and churn prediction with 87% precision for top 15% scorers.• Developed and validated an SNA-based Multi-SIM detection model on Teradata achieving 84% accuracy at 76% customer base penetration in Orange Egypt (2014).• Orchestrated the seamless migration of the Data Charging system integration from Volubill to Ericsson achieving 0% discrepancy. • Employed tools and technologies like Teradata, IBM DataStage, SQL, SPSS Miner, Apache Hadoop, and Bash in the above projects. Show less • Constructed the Teradata-oriented Telco Data Warehouse from the ground up, delivering a robust foundation for business intelligence and future advanced analytics, through developing ETL jobs, modeling raw data, designing DWH architecture, and supporting the BI team.• Migrated the prepaid charging data source to Ericsson in the DWH, gaining deep architectural expertise on the charging system.• Created the recharge-based RFM analytical model, driving improvements in customer segmentation and targeted marketing. Formulated the SNA foundation layer, establishing the groundwork for future advanced business applications.• Employed a tech stack that included Teradata, SQL, Bash, and DataStage throughout the aforementioned activities. Show less

  • Manager, EDW & BI

    Jan 2013 - Jun 2016

  • DWH Architect / ETL Developer

    Apr 2009 - Dec 2012
• 

  Vodafone

  Jul 2016 - Jan 2017

  Manager, Predictive Modeling & Big Data

  Created the Predictive Modeling & Big Data team from scratch, and delivered a propensity model to optimize offer/customer matching utilizing SQL, R, Oracle's Exadata, and DataStage increasing opt-in rate by 38% upon release.

• 

  Home24 SE

  Feb 2017 - Sept 2019

  • Managed the emergence of the MarTech team from the Data Platform team, overseeing both teams under the data umbrella, leading to a streamlined product focus, and accelerating business deliverables.• Performed an aggressive AWS budget optimization, cutting costs by 40%, and initiating a process of regular AWS billing health checkups.• Paired with a talented data scientist to build a new revenue attribution model based on Markov Chain in Scala resulting in optimized data-driven budget allocation to marketing channels. Show less • Crafted ETL flows to fulfill marketing business needs, supporting the Marketing Data Warehouse (MDWH) using Data Virtuality, BigQuery, and Amazon Redshift, while analyzing the requirements for building a new Data Platform to replace silos.• Migrated and fine-tuned the legacy attribution model from R in MDWH to Sparklyr within the Data Platform.• Implemented data importers and transformation jobs using Scala, Apache Spark, and Amazon EMR on AWS, integrating with Tableau, Amazon Redshift, and Amazon S3 to launch the new Data Platform at home24.• Maximized Data Platform’s EMR parallelization, improving SLA for the marketing daily dashboard by 4 hours while saving AWS costs. Show less

  • Engineering Manager, Data

    Aug 2018 - Sept 2019

  • Senior Data Engineer

    Feb 2017 - Jul 2018
• 

  Amazon Web Services (AWS)

  Oct 2019 - Sept 2020

  Global Big Data Architect

  Built data processing and ML pipelines for BMW, enabling the customer to maximize the beneficial utilization of AWS while minimizing costs; achieving a consistent CSAT score of 10 over three engagements.

• 

  Home24 SE

  Oct 2020 - now

  Senior Engineering Manager, Data

  • Lead MarTech, a stream-aligned cross-functional team, focused on delivering data products to automate and optimize marketing and CRM processes.• Spearheaded and architected the migration of marketing data pipelines and models to consume Google Analytics 4 (GA4) events, ensuring a seamless transition and compliance with deadlines using Apache Spark, Scala, and Amazon EMR.• Engineered solutions to address known bugs in GA4 exports to BigQuery, resolving issues with UTM parameter veracity and preserving data accuracy for marketing attribution and other products.• Made raw GA4 event data available in Amazon Redshift, reducing BigQuery costs by almost 90%, and fostering a culture of analytics autonomy and data democratization at home24.• Initiated the Image Classification project to enhance reverse ELT feeds, promoting adoption by other teams, for example, to reduce marketplace product onboarding time. Show less