Soaring High: My Transformative Journey as a Business Analyst Intern at Lufthansa Technik

My tenure as a Business Analyst Intern at Lufthansa Technik has been an extraordinary journey, deeply enriching my professional and personal growth. With a long-standing passion for the Aviation, Airlines, and Aerospace industry, this internship allowed me to immerse myself in the dynamic world of Maintenance, Repair, and Overhaul (MRO) operations.

As a member of the esteemed Closed Loop team, I was entrusted with the critical responsibility of generating Key Performance Indicators (KPIs) that drive our operational excellence. Under the expert mentorship of Matheus Neves , an accomplished Data Analyst, I mastered the art of data manipulation and analysis. Utilizing Python for web scraping and data extraction, I created comprehensive Excel macros for in-depth analysis, and employed PowerBI for data visualization to develop insightful KPIs. Additionally, I produced pivotal reports such as the SCM Report, ZS Report, and Quarantine Report, each tracking vital metrics that inform our strategic decisions.

One of the crowning achievements of my internship was the 'Aircraft Retirement Forecast' project. By leveraging advanced machine learning techniques with Python, I delivered predictive insights that significantly impacted our strategic planning. This project not only honed my technical skills but also underscored the transformative power of data-driven decision-making.

Furthermore, my involvement in the United Airlines RFP project was a testament to the practical application of my analytical capabilities. Assisting the Key Account Manager, I conducted a thorough analysis of fleet capabilities, providing crucial insights that guided key strategic decisions. This experience offered a rare glimpse into high-stakes decision-making processes and fortified my analytical acumen.

Throughout my journey, I was privileged to work alongside an exceptionally talented and supportive team. A heartfelt thanks to my managers, Alejandro Acevedo , Daniela Walters and Alma Garcia-Martinez whose unwavering support and recognition of my potential were instrumental to my success. Their encouragement and guidance were invaluable, fostering an environment conducive to learning and growth.

Overall, my internship at Lufthansa Technik has been an unforgettable chapter in my career. It equipped me with a robust skill set, including advanced proficiency in Excel, Python, PowerBI, and Tableau. More importantly, it provided a platform to apply these skills in real-world scenarios, enhancing my analytical and problem-solving abilities. This experience has not only solidified my passion for the aviation industry but also prepared me for future challenges and opportunities.

#UTDMSITM