Ahmed Emad Email & Phone Number

Egypt

Riyadh, Saudi Arabia

The team has successfully collaborated with the DevOps group to construct a robust infrastructure for our new data platform. This includes establishing a development cluster in Redshift, which is a critical component of our transition from PostgreSQL to Redshift as our primary data warehousing solution. This move is aimed at leveraging Redshift's scalability and performance benefits for large-scale data processing.Migration from ERD to Dimensional Modeling:In an effort to enhance data analytics capabilities, we have shifted from an Entity-Relationship Diagram (ERD) model to a dimensional modeling approach. This change facilitates easier and more efficient data analysis and helps in implementing the Medallion Architecture, which structures data into bronze, silver, and gold layers for improved clarity and usability.We have developed detailed data models for six critical business domains: Core, Pay, Ship, Zam, Mazeed, and POS. Each domain model includes both logical and physical components:- Logical Models: These models are documented with detailed sheets for each table's transformations and diagrams that illustrate the overall data flow, ensuring transparency and ease of understanding for future modifications and troubleshooting.- Physical Models: Implementation of over 300+ dbt models across the domains, enhancing the automation and maintenance of our data transformation processes.

Egypt

As a Teaching Assistant at ITI, I taught and guided students in various data science subjects, including:Data Modeling: Instructed students in designing efficient and scalable data models to meet business requirements.Statistics: Conducted lectures and practical sessions on statistical concepts and their application in data analysis.MongoDB and NoSQL Databases: Delivered instruction on MongoDB and NoSQL databases, including data modeling and querying.Data Warehousing: Taught students about data warehousing concepts, including dimensional modeling and ETL processes.Reporting: Instructed students on report design, data visualization, and storytelling techniques.Tableau and Power BI: Provided comprehensive training on Tableau and Power BI for data visualization and interactive exploration.

New York, United States

Segmentation Project and Data Pipeline Automation at WeightWatchersDuring my tenure at WeightWatchers, I had the exciting opportunity to lead a segmentation project aimed at enhancing customer engagement and personalization. Working closely with cross-functional teams, I spearheaded the creation of distinct customer segments, enabling the company to deliver customized offers and tailored services to each segment. This initiative resulted in improved customer satisfaction and contributed to increased revenue growth.In addition to the segmentation project, I played a vital role in developing and implementing data pipelines for near real-time (NRT) data processing. Leveraging my expertise in cloud technologies, I utilized a stack consisting of Google Cloud Platform (GCP) and Amazon Web Services (AWS) to automate the extraction, transformation, and loading (ETL) processes. This seamless data movement from various source systems to our centralized data warehouse significantly reduced manual efforts, improved data accuracy, and facilitated timely decision-making across the organization.

Texas, United States

During my tenure at Capstone Logistics, I held a multifaceted role encompassing data management, pipeline development, and the implementation of disaster recovery simulation solutions. Here are the key highlights of my contributions:Data Management and Pipeline Development:Utilized Azure Stack to create and maintain a comprehensive data catalog, streamlining data accessibility and facilitating efficient data discovery.Implemented robust cloning and backup mechanisms to ensure data availability and integrity, leveraging the power of Azure Stack technologies.Designed and built efficient data pipelines using Azure Stack, enabling seamless data movement to our lakehouse infrastructure.Conducted thorough data validation work, ensuring the accuracy and quality of migrated data, while utilizing Azure Stack's data validation capabilities.Collaborated closely with cross-functional teams to optimize data workflows, improve data management processes, and maximize the potential of Azure Stack.

During my time as a Teaching Assistant at Alexandria University, my responsibilities included assisting in teaching classes, correcting exams, and providing support to university staff in matters related to student management and summer courses. As an assistant, I actively engaged with students, addressing their questions and concerns, and provided guidance in their academic pursuits. Additionally, I collaborated with faculty members to ensure smooth administrative processes and efficient student management.

Cairo, Egypt

At Paymob, I successfully completed the following projects:Adjust Marketing KPIs: Built an ETL pipeline to extract and transform data from Adjust KPIs, loading it into Redshift. Created a dashboard to monitor campaign ROI and identify effective marketing channels. Mobile Events Analysis: Developed an ETL pipeline using Apache Airflow, processing mobile app events data from Amplitude APIs. Results were exported to Redshift, and a dashboard was designed on Apache Superset. The pipeline provided insights for marketing and product teams. Technologies used: Amplitude, Redshift, Superset, Python.Additional Dashboard Development: Created multiple dashboards tracking KPIs such as ROI, CAC, revenues, expenses, and customer segmentation. These dashboards provided insights into customer acquisition and loss trends. Collaborated with marketing and product teams for visualization and data analysis.These projects demonstrated my expertise in ETL pipeline development, data analysis, and creating insightful dashboards.

Cairo, Egypt

During my two-year tenure at Vodafone, I actively participated in various impactful projects:Always-On Marketing: Developed fast systems using a lambda architecture to deliver real-time customer offers.Behavioral Segmentation: Predicted customer behavior and interests to categorize them into different segments for targeted strategies.Challengers: Utilized Python and regression analysis to predict customer usage and recommend better rate plans.Data Warehouse Decoupling: Migrated ETL processes from legacy systems to Spark and the data lake, reducing production data integration jobs by over 70%.Location Analysis: Predicted customer locations based on network data, enabling personalized location-based offers.Logs Analysis: Managed logs, built performance dashboards, and implemented elastic watchers for timely issue detection.These projects allowed me to contribute to cutting-edge initiatives in real-time marketing, behavioral analysis, data migration, location-based services, and log management.

Cairo, Egypt

Data Management (Intake 40)

The program is designed to equip students with the necessary skills and knowledge to manage and analyze large volumes of structured.

Bachelor'S Degree, Management Information Systems, 86.7 (Ranked Second)

The MIS program focuses on the application of technology to help achieve organizational goals and solve business problems. The program.