Professional
Maintenance Planning Tools
Two Python GUI applications developed during my internship at MNG Airlines to streamline data processing and cross-referencing tasks common in maintenance planning.
Aug 2025
GitHub Repo
Problem & Context
Maintenance planning often required manually verifying modification statuses across multiple aircraft and cross-referencing conflicting Excel databases. The department needed automated tools to eliminate human errors and save time.
Accomplishments
- Developed 'Aircraft Mod Status Checker' to cross-reference aircraft modification implementation statuses (PRE/POST) against a master database.
- Developed 'Excel Match Finder' to compare separate Excel workbooks and locate matching cell values across all sheets without requiring Microsoft Excel installed.
- Packaged both Python applications as standalone Windows executables (.exe) for seamless deployment.
Gained Experience
- Understood the critical role of robust error-handling in professional software.
- Learned to communicate effectively with colleagues to translate their needs into technical requirements.
- Strengthened my expertise in GUI development using Tkinter and advanced data manipulation with pandas/openpyxl.