Khaled Mahfouz
Quality Engineer en Electrolux
Worldquant University, Applied Data Science Lab
Egipto
Experiencia
Electrolux
Quality Engineer
September 2022 - Presente
Enhanced the reporting methodology of the quality KPI, producing actionable reports that result in quicker & immediate response actions to operations in the factory, using python automation technology. Implemented Fit-Feel-Finish tests and built FFF data-collection infrastructure on the plant floor using VBA to monitor respective KPI. Enhanced the samples’ data collection methodology for the technological area in order to correctly output statistical process control charts. Lead (3) problem-solving cases with cross-function teams, using 8 disciplines methodology. Built a Power BI dashboard to analyze the top defects challenging quality KPI.
Electrolux
Quality Engineer
September 2022 - Presente
- Enhanced the reporting methodology of the quality KPI, producing actionable reports that result in quicker & immediate response actions to operations in the factory, using python automation technology.
- Implemented Fit-Feel-Finish tests and built FFF data-collection infrastructure on the plant floor using VBA to monitor respective KPI.
- Enhanced the samples’ data collection methodology for the technological area in order to correctly output statistical process control charts.
- Lead (3) problem-solving cases with cross-function teams, using 8 disciplines methodology.
- Built a Power BI dashboard to analyze the top defects challenging quality KPI.
AL Ahram Roastery
Part-time Manager
January 2022 - Presente
• Maintained products quality by developing the operations in shop-floor. • Registered and defined both barcoded and weighted items in the retail’s database and scales, provided ad-hoc analysis by querying the data to look up daily, weekly, morning, and evening shift sales to spot patterns in order to make an informed business decision. •Maximized a multi-background staff performance by supervising and motivating them through weekly feedback sessions and introducing “freebie breakfast day”.
AL Ahram Roastery
Branch Manager
January 2022 - June 2022
Maintained products quality by developing and standsardizing the operations in shop-floor. Registered and defined both barcoded and weighted items in the retail’s SQL server database and scales, queried the data to look up daily, weekly, morning, and evening shift sales to spot patterns in order to make an informed business decision, and performed data integrity checks. Maximized a multi-background staff performance by supervising and motivating them through weekly feedback sessions and introducing “freebie breakfast day”.
Rejuvbloom
Public Relations
October 2021 - November 2021
Saved 3 man-hours on a daily basis of routine tasks of e-mail marketing for PR employees by designing and implementing a custom workflow “CSRR”, an automated scripted action-based system and workflow tailored for e-mail marketing activities using python libraries like NumPy, Pandas, SSL, and SMTPLIB. Reached out to influencers from all over the world & established collaborations with them.
REJUVBLOOM
Public Relations Brand Manager
October 2021 - November 2021
• Saved 3 man-hours on a daily basis of routine tasks of e-mail marketing for PR employees by designing and implementing a custom workflow “CSRR”, an automated scripted action-based system and workflow tailored for e-mail marketing activities using python libraries like NumPy, Pandas, SSL, and SMTPLIB. • Reached out to influencers from all over the world & established collaborations with them.
Airforce - Egyptian Armed Forces
1st Lieutenant Military Officer
November 2018 - April 2021
Collectively saved 24+ man-hours per week for certificate creation process for retired officers by automating the workflow using Microsoft word & excel VBA macros, reducing manual intervention for the certificate creation process resulting in minimum human error. Reduced mistake rate of reports due to human error from 7.1% down to 1.4% by designing a forum on MS word using Visual basic for applications.
Airforce - Egyptian Armed Forces
1st Lieutenant Military Officer
November 2018 - April 2021
• Collectively saved 24+ man-hours per week for certificate creation for retired officers by using Microsoft word & excel VBA macros, processing the data before filling it in their destined fields, making the certificate creation process mistake-proof with minimum human error. • Reduced mistake rate of reports by designing a forum on MS word using Visual basic for applications.
Educación
Ingeniería Aeroespacial
Cairo University
Graduado en 2018
aerospace engineering and aeronautical science
Cairo University
Certificaciones y Distintivos
No se agregó certificaciones o distintivos
Proyectos
Check-Send-Read-Remind "CSRR"
•https://793eb4d9-c71a-475f-ad31-b9a5a1b8fc57.filesusr.com/ugd/ffcd90_da10da4b8afd4f61b54b4e5e9abaa330.pdfPR Brand Manager and Developer
A scripted action-based semi-automated workflow tailored for e-mail marketing, CSRR stands for the four actions that it does, Check Data, Send emails, Read Inbox & Remind unanswered. Recepients’ email addresses are stored in an Excel file and assigned a message (thread) ID, they get validated to protect the sender's reputation, It sends personalized emails to all recipients, then reads the inbox marking those who replied in the Excel file, and reminds those who didn’t reply automatically, developed using python libraries like Numpy, Pandas, SSL and SMTPLIB.
Data Expo 2009: Airline on-time data Flight Data Analysis
•https://khaled-mahfouz.github.io/Flight_Analysis/#/data analyst
From 1987 to 2008, we analyze the evolution of flight departure and arrival delays through 12 giga-byte flight records for all commercial flights within the USA, scatter charts depicting the creep of flights towards early arrivals and departures through the years. Conducted using python and jupyter notebooks. Link for documentation: https://www.kaggle.com/code/ksevenk/data-expo-2009-airline-on-time-data/notebook
E-Commerce website Conversion rates: A/B Test
•https://khaled-mahfouz.github.io/E-Commerce-conversions-A-B-Test/#/data analyst
This project is a research on conversion rates of an E-commerce website, where we perform an A/B test on a website click-through rate through a control and experiment groups, to decide which page design brings more conversion or are both of them are the same. Conducted using python and jupyter notebooks. Link for documentation: https://793eb4d9-c71a-475f-ad31-b9a5a1b8fc57.filesusr.com/ugd/ffcd90_4b73c7f761b342368b7b3637a3c81f34.pdf
Medical Appointments: No-Show Analysis
•https://khaled-mahfouz.github.io/Project--Medical-appointments-brazil/#/data analyst
In this project, we perform a deep dive EDA to discover multiple facts about the Brazilian medical sector, from appointments rescheduling phenomenon, to concentrations of an age-specific group for scheduling appointments at a specific time of day that might raise concerns for medical urgency or a disease that affects a certain age bracket. Performed using python and jupyter notebooks Link for the documentation: https://793eb4d9-c71a-475f-ad31-b9a5a1b8fc57.filesusr.com/ugd/ffcd90_893bb63b63a44d8ba338b9a255ae6d56.pdf
Idiomas
Inglés
Habilidades
Data Analysis and Display
Data Visualization
matplotlib
Excel
Programming in VBA
Python
NumPy
Jupyter
SQL
SQL Database
SQL Query
PostgreSQL SQL
Microsoft SQL Server
Regression Analysis
Classification Models
Random Forest
Decision Trees
Dashboard
Developing Dashboards
Forecasting Models
ARMA
Clustering
Power BI
¿Listo para una experiencia personalizada? Utilizamos cookies y tecnologías similares para adaptar nuestro sitio especialmente para ti. Al hacer clic en 'Aceptar', nos das luz verde para utilizar cookies y tecnologías similares. 🍪