Objective: Develop an automated ELT process to integrate and transform data from AIMS, an on-premises airline management software specializing in operational and financial management, to streamline critical reporting on key metrics such as flight schedules, on-time performance, cancellations, and delays. This process should also automate BI reporting to deliver real-time, actionable insights, supporting data-driven strategic decision-making across the airline’s operations.