Youssef Galal Email & Phone Number

Irving, Texas, United States

Engineered and implemented robust Spark ETL processes, enhancing data integration across diverse systems, reducing time required by more than 80%. Conducted meticulous quality control procedures to unify data, creating a precise snapshot of retail performance, resulting in a reliable foundation for informed energy procurement decisions and other reporting/dashboard needsDesigning and implementing stratification processes for price testing to refine and optimize pricing strategies, contributing to 50% higher profitability versus planLeveraged data-driven methods to identify and quantify dual-fuel sales opportunities as well as portfolio retention performance, contributing to the development of new marketing strategies Developed a classifier model on a highly imbalanced dataset (positive class <5%) to pinpoint customers likely to switch within the company portfolio as well as contributing variables, achieving an exceptional 80% AUC on the precision-recall curveActively studying ISO markets and the energy industry with a quantitative focus for application in both physical and financial trading strategies

Dallas, Texas, United States

Utilized PySpark and Databricks to explore 1.3B rows of data, detect anomalies, and applied feature engineering, various statistical methods, and machine learning techniques to improve sales volume forecastHelped implement different model iterations to validate customers with similar purchasing behavior, identify potential sales opportunities, improve stock allocation, and better utilization of frontline workersCompleted ad-hoc analysis by aggregating, windowing, joining, and filtering data, leading to the identification of correlations in sales and the development of effective sales strategies

Edinburg, Texas, United States

• Compiled and cleaned economic data from 20+ economic research and government databases in Excel• Calculated 10+ different economic growth indicators and extracted insights for the office to implement• Streamlined the County’s data sourcing process, saving the county 100+ hours of research

Master Of Science - Ms, Business Analytics, 3.7/4.0

Bachelor Of Arts - Ba, Economics, Summa Cum Laude