Hi, I'm Ahmed Lotfy Rashed.

With over 15 years of experience in manufacturing and operations, I am a data analytics professional who understands the questions that need to be asked to uncover business insights.

NATURAL teacher and public speaker, able to present and explain complex technical issues to all audiences.

DATA toolbox -- Azure Data Factory, Databricks, SQL Server, MySQL, Python, MicroStrategy, Tableau, and Power BI.

Download CV

About memy stats

Personal Details

Detail-oriented Data Professional with over 15 years of experience in business intelligence gathering, trending, benchmarking, and building robust applications.

Team-player who loves breaking down problems, building solutions, delivering actionable and data-driven insights, and working in a fast-paced, dynamic environment.

Download CV

EDA

Exploratory Data Analysis

ETL

Extract- Transform- Load

ML

Predictive Analytics

Viz

Interactive Dashboards

Technical Skills

Presenting

5

Collaborating

5

Root Cause Analysis

4

Statistical Methods

4

SQL

4

Tableau / PowerBI

4

Python

3

R studio

3

Data Analytics Experience

06/2024 - present

Senior BI Developer - SHERWIN WILLIAMS

Designed, debugged, and automated patches and configurations for Tableau and MicroStrategy Developer suites.

• Developed and updated enterprise MicroStrategy dashboards for quality, reliability, and efficiency.

• Assisted QA and Data Engineering teams in testing and validating Netezza to Snowflake migration project.

02/2024 - 04/2024

Data Analytics Engineer - GLOBALSTAR

Leveraged SQL queries to analyze production test data to identify inefficiencies and automate deployments.

• Optimized MySQL production queries, reducing run-times from ~ 50 minutes to ~ 5 minutes.

• Revamped manufacturing Power BI dashboards to automatically clean incoming data and KPI metrics.

11/2022 - 08/2023

Data Analytics Consultant - HENNY PENNY

Designed, developed, and maintained robust test systems, ensuring reliability and efficiency. Translated technical concepts for non-technical stakeholders, ensuring project goals were understood across different departments.

• Extracted and analyzed three-years-worth of operational data to uncover trends and inefficiencies using python, pyodbc, pandas, and SQL, presenting opportunities for improvement to stakeholders.

• Created python utility to extract and transform data from TestStand SQL database schema into flat CSV files. Reduced script to a single file, building a stand-alone executable for end-users to download.

09/2022 - 01/2023

BI Developer Consultant - GRANVILLE - PHILLIPS

Led the implementation of a new data analysis system into existing stations, resulting in a 20% increase in data accuracy.

• Performed exploratory SQL analysis to identify patterns in ion-gauge PCB telemetry data, translating the factory test data into easy-to-understand reports using Tableau.

• Collaborated with Mfg. engineers to identify trends and track processes, boosting yield from 65% to 99%.

09/2011 - 06/2022

Process Analytics Engineer - MKS INSTRUMENTS

Created visually impactful Tableau dashboards and executive data visualizations to track production yields and failure modes, saving test engineers over 10 hours weekly in diagnostics and manual reporting

• Extracted manufacturing data using Python, SQL, and Excel for monthly quality reports, preventing over $50,000 in lost annual revenue by catching product quality defects BEFORE they leave the factory floor.

• Connected Tableau dashboards to centralized data-pipeline for real-time production data tracking, improving average time-to-bug-fixes by 20% and highlighting time-sinks in factory workflows.

My PortfolioData Projects

TestStand KPI Dashboard

As a follow-up to our TestStand ETL, we develop an interactive dashboard using Power BI to uncover process trends and statistical control metrics.

Customer Retention Report

Dashboard report with legacy customer and sales data to calculate customer retention and overall sales metrics.

End-to-End Azure Pipeline

Azure ETL Pipeline for retrieving and processing NI TestStand test results.

TestStand DB Converter

Created python utility to extract and transform data from TestStand SQL database schema into flat CSV files.

COVID-19 Retrospective EDA

Explored and visualized COVID’s most affected countries, highest death rates, and fastest vaccination rates.

TikTok Claims Prediction Model

Built a classification model that predicts whether a video is a claim or opinion.

Housing Prediction Model

Built and optimized a predictive regression model of housing prices with historical CA housing data.

Contact MeContact

Contact me here

Email is the best way to get in touch with me. Also feel free to connect with me on LinkedIn. Looking forward to hearing from you!

Mobile Number:

+1 781-309-7560

Languages:

English, Arabic