Anna Krużel

Delivering different reports on business performance, operations, and key metrics for internal stakeholders, using advanced Excel tools (Power Query, pivot tables) and SQL queries

Examples:

Weekly Sirax ADCM posting files for LX accounting

LHG Monthly Sirax audit invoice reports

SQL Daily refund workload

Oracle SQL Developer (Sirax SE16 database tables)

Managing and steering audit workloads by retrieving

automatic refund transactions irrelevant for audit

Providing data for involuntary transactions analysis (based on

Sirax and PNR segment history)

Percentage share of manual and automatic disputed Airline

Debit Memos (ADMs)

Teradata Studio Express and Corona

Supporting Fraud prevention process by extracting departure dates, PNR records and other ticket fraud relevant information (SQL provided by HAM team)

Basic knowledge of Corona database structure (table example: PNR_TIX_MANUAL_IATA_EXT)

Power Query

Providing key audit numbers for consecutive months for LHG Aggregation audit invoice report for time-based analysis

Power Automate

Granting access for IATA BSP-link for new users by automatic user data collection (MsForm), storing and maintaining information (Sharepoint list) and automatic Outlook notifications for users

Automatic saving of email attachments Sharepoint

OneRes

Advanced knowledge, conducting training for new Sales Audit team members

Tableau (basic)

Exploring and tracking data across markets and periods via filters and dashboards in the ADM Reporting report

VBA in Excel (basic) – recording and simple adjusting of existing macros (generating of txt files from Excel file for group ADM uploads in Sirax)

Sirax uploads (basic)

Adjusting existing upload files for new customers and different business needs

LH IATA BSP-link

Granting an access and maintenance of Sharepoint users database

• Quality control and oversight of sales audit processes performed by the external provider TCS
• Verification of existing audit documentation (e.g. transactions affected by irregularities)
• Monitoring ADM disputes initiated by travel agents
• Managing audit workload and task allocation (exlusions, holds monitoring)
• Handling ad hoc queries from TCS related to audit procedures, using the TrackSpace tool
• Participation in the migration of TC1 zone audit processes from LGBS Mexico to LGBS KRK
• Support in Excel topics within team: Creation of admin related files in Excel (time sheet with dynamic calendar, holiday files)
• Dealing with local Field Offices (solving problematic cases, exchanging information)

• LHG ticket audit covering fare, commission and tax areas (in accordance with information filed in GDS Amadeus, ATPCO Fare Manager, contracts and IATA regulations)
• Audit of airline voluntary exchange transactions, schedule changes, cancellations and refunded tickets
• Handling of Agent Debit Memos disputed by IATA agents
• Creation of workload and excluding cases not relevant for audit
• Participation in LPM project - checking correctness of fares and rules filed in reservation systems
• Creating and updating CRS database (GGAIRLH pages) including existing fares on specific markets