Data Analyst
| Predictive Analytics & Process Improvement |
| Python • SQL • Data Visualization • Machine Learning |
| Turning data into decisions that reduce risk, improve performance and profitability |
View the Project on GitHub Extracted-Dee/Manufacturing-Defect-Reduction-Analysis-Project.github.io
A data-driven process improvement project focused on reducing welding defects while increasing production capacity in an electronics manufacturing facility.
A manufacturing plant producing electronic circuit boards experienced a rise in welding-related defects during the Manual Finish (Thru-Hole) process, while also facing increased product demand.
These defects led to:
The analysis included defect data from:
Each record included:
This allowed for both facility-wide and model-level defect analysis.
To ensure consistency and accuracy:
The most frequent defects across the facility were:
| Rank | Defect Type | Impact |
|---|---|---|
| 1️⃣ | Solder Bridge | Highest contributor to failures |
| 2️⃣ | Excessive Solder | Affected solder joint quality |
| 3️⃣ | Missing Components | Caused assembly/test failures |
.png)
👉 These three defect types became the primary focus for improvement efforts.
| Product Model | Most Common Defects |
|---|---|
| 595407-XXX-00 | Solder Bridges, Missing Components, Lifted Components |
| 595481-00X-00 | Solder Bridges, Lifted Components, Wrong Components |
| 595310-001-00 | Excessive Solder, Solder Bridges, Damaged Components |

.png)

🔎 Key Insight:
Solder Bridge defects appeared across nearly all models, indicating a systemic process issue rather than a product-specific problem.
A Fishbone (Ishikawa) framework was used to categorize likely root causes.

If implemented, these improvements would:
✔ Target the highest-frequency defects
✔ Support a 20% defect reduction goal
✔ Enable increased production without quality loss
✔ Improve compliance with IPC-A-610E standards
✔ Reduce rework costs and improve operational efficiency
This project demonstrates how structured data analysis combined with quality engineering principles can drive measurable improvements in manufacturing performance.
It highlights the ability to: