Tugba Demirci Kasarci

I led the migration of a departure control system (DCS) to a data warehouse, transforming an open system without a relational database. Utilizing SQL, I analyzed systems, collaborated with developers and analysts, and gathered business requirements. Building on this, I devised rules and designed the data warehouse (DWH). Leveraging a domain with a daily data volume exceeding two million records, I generated reports on MicroStrategy encompassing over 500 metrics and attributes. This allowed numerous departments to access crucial data for strategic decisions, such as passenger check-in trends, aircraft occupancy rates, baggage volumes, and passenger profiles.

The documentation system I established throughout the project laid the foundation for data governance. The user guides I created resulted in an 80% reduction in the need for business unit support for report usage.

The organization faced the complex task of transitioning from an outdated data warehouse to a new, modern system, necessitating the recreation of existing report codes without disrupting strategic decision-making processes.

I meticulously compared old system tables with new ones, creating detailed data mapping documents. I identified discrepancies and accounted for them when preparing report scripts, ensuring alignment with business needs.
I scrutinized existing report scripts, aligning each with the precise business requirements in the new data warehouse. I proactively addressed source data errors, significantly improving data quality and reporting accuracy.
I achieved 100% accuracy in migrated data, confirmed through extensive testing. This precision ensured the continuity of analytics and reporting functions, which are vital for ongoing business operations.

The project went beyond simple migration by re-confirming report needs with owners, leading to updated and more relevant reports. The successful on-time delivery of the project minimized business disruption.

I revamped the company's monthly sales analysis presentation, previously in PowerPoint, into an interactive dashboard with Tableau. Collaborating with my team, I elucidated the business rules for each graph and crafted scripts accordingly. The dashboard, comprising around 50 graphs, enhanced flexibility by introducing filters for weekly, quarterly, and annual data, with provisions for accessing data from previous years.

Recognizing the critical need for data accuracy, I proactively addressed inconsistencies during the dashboard's development. Liaising with data source owners, I identified and resolved issues, ensuring users had reliable and precise data for strategic decision-making.

Developed a script to recalculate excess baggage fees for an airline company, utilizing pre-flight weight data instead of manually entered baggage weights. I identified significant revenue loss due to excess baggage mishandling through the project, prompting corrective measures. I implemented a data transfer system to streamline the collection of pre-flight weight data, improving accuracy and efficiency.

Daily reports on staff and missing baggage entries were generated, fostering awareness and reducing fee losses. I contributed to minimizing revenue loss by optimizing excess baggage fee calculations and collaborated with personnel across multiple stations to ensure the effective implementation of corrective measures and ongoing monitoring.