- Where
- Karmen Halı, Gaziantep. Production planning internship, September – December 2026
- Scope
- 3 modules on a shared database; Weaving and Finishing departments
- Tools
- Python, Streamlit, Excel
Problem
Production data had been entered into monthly Excel forms since 2017. The same data was typed twice, once into the production file and once into the OEE files. Planning, efficiency tracking and lean records lived apart from each other.
Solution
I combined three separate tools into one application through a shared integration contract. The modules use the same database, so a change in OEE in the efficiency module can be followed alongside the lean techniques being applied.
Current state
As of November 2026 the three modules run as one application. It currently runs in the cloud (Google Colab); installation on a single central computer on the factory network is planned. I am not reporting a measured business result yet.