Ahmed Lotfy Rashed

Ahmed Lotfy Rashed

Project Engineer

Followers of Ahmed Lotfy Rashed2000 followers
location of Ahmed Lotfy RashedColumbus, Ohio, United States

Connect with Ahmed Lotfy Rashed to Send Message

Connect

Connect with Ahmed Lotfy Rashed to Send Message

Connect
  • Timeline

  • About me

    Microsoft Certified Data Engineer | BI Developer with experience using Tableau, Python, SQL, Power BI, & Azure Data Factory to extract, curate, and analyze large datasets in manufacturing and operations industries.

  • Education

    • Bryn Mawr College

      2000 - 2003
      Master of Arts - MA
    • University of Maryland Baltimore County

      1995 - 1999
      Bachelor of Science - BS
  • Experience

    • Symmetricom is now Microsemi

      Sept 2005 - May 2008
      Project Engineer

      Responsible for designing, building, testing, and troubleshooting complex electronic circuits that were used to control and measure the frequency and stability of novel atomic clocks. Wrote documentation to describe the design and operation of the circuits and firmware. Transitioned to manufacturing support. • Developed LabVIEW test software for production Automatic Test Equipment. • Monitored and modified production performance using execution plans and key-process indicator (KPI) tuning. • Key contributor to high-visibility Six Sigma Green Belt project, improving Rubidium Atomic Clock production yield from 88% to 95%. Show less

    • MKS Instruments

      Jun 2008 - Jun 2022

      Managed test station software projects using Agile JIRA workflows and version control, ensuring quality and reliability of software through comprehensive regression testing and streamlined reporting processes.• Picked up SQL and Python on-the-job to drive enhanced data visualizations for TechOps & Business Unit teams, preventing ~ $50,000 in lost annual revenue by catching defects before they leave the factory floor.• Created visually impactful dashboards and executive data visualizations in Tableau to track production yields and failure modes, saving test engineers over 10 hours weekly in diagnostics and manual reporting.• Led development and rollout of internal real-time Statistical Process Control (Xbar & R Charts, Gage R&R, Cpk, and KPI) system for the production floor. Show less Incorporated extensive upgrading and overhauling legacy product lines. Rewrote LabVIEW test software architecture into robust, data-driven, user-friendly applications, improving quality, reliability, and efficiency.• 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.• Developed LabVIEW web service drivers to connect various product lines to custom database (Visual Factory), allowing engineers and line operators to catch process issues in hours rather than days.• Sustaining production by resolving issues on the floor. Regularly perform Kaizen blitz and FMEA analysis to find root causes of test failures, implementing short- and long-term solutions using Cpk and KPI metrics.• Skills Used: Business Intelligence (BI), Agile Methodologies, Data Mining, Data Cleaning, Data Visualization, Statistical Data Analysis, Extract, Transform, Load (ETL), Tableau, Software Development Analytics, Ad Hoc Analysis, Business Analysis, Test Automation, Statistics, Agile Project Management Show less

      • Principal Test Engineer

        Mar 2021 - Jun 2022
      • Senior Test Engineer

        Sept 2011 - Feb 2021
      • Test Engineer

        Jun 2008 - Aug 2011
    • Granville - Phillips

      Sept 2022 - Jan 2023
      BI Developer Consultant

      Picked up NI TestStand on-the-job, becoming the resident expert in two months. 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.• Created & deployed Statistical-Process-Control dashboards, improving first-pass-yields from 75% to 95%.• Collaborated with Mfg. engineers to identify trends and track processes, boosting yield from 65% to 99%.• Re-engineered TestStand Sequential and Batch processes, reducing process time by 35%. Show less

    • Henny Penny

      Dec 2022 - Aug 2023
      Data Analytics Consultant

      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. Show less

    • Badger Meter

      May 2023 - Nov 2023
      Independent Consultant

      • Picked up C# and MS Visual Studio on-the-job to reverse-engineer communication drivers from C# into an extensible DQMH LabVIEW framework.

    • Globalstar

      Feb 2024 - now
      Test Analytics Engineer
  • Licenses & Certifications