Charles Waters Email and Phone Number

Primary duties:* Design, test and maintain data source objects used to support Consumer Sales, and other business units, analytical reporting and planning needs* Work with software engineers to implement new objects, improvements and fixes related to Consumer Sales portfolio of reporting and dimension database objects* Work with business units, technical users and external vendors to resolve ad-hoc issues related to Consumer Sales database objects (e.g. data/logic understanding, understanding processing logic, SQL setup/improvement,etc.)* Complete on-call support rotation for daily production processes that update Consumer Sales Fact and Dimensional database objects used for performance analysis and planning * Tools: MS SQL Server (SSMS), Jira, Azure, Agile, Teradata, Slack, MS Teams

Provided consulting services to a client developing data products utilizing MIDT Booking data, OAG Schedules, and US Department of Transportation data. Services included methodology development and data source testing and review.

Corporate-wide subject matter expert, data steward and product owner for several external airline industry-wide data sources: Customer Ticket Purchases - MIDT, Government Data (DB1B, T100,etc.) and Flights Schedules (OAG)- Used for competitive analysis and analytical model development- Used by multiple business planning groups (i.e. Schedule Planning, Sales, Revenue Management, etc.)- Provided on-going training and support to 200+ person user baseManaged 2+ year replacement project for MIDT and OAG data sources- Saved $700K of annual operating expenses- Added 20+ additional features to make data sources easier to use Lead/represented Network Planning on cross-functional projects related to updating/creating analytical tools and developing data solutionsResearched and evaluated new tools and data sources to create better forecasting system inputs and conduct more accurate competitive analysesCompleted ad hoc analytical projects as requiredTools: SQL, SAS, Unix, Teradata, Agile, Project Management, Excel/VBADepartment: Flight Schedule Planning

Developed automated processes, mainframe & PC, to provide accurate and timely performance statistics (e.g. revenue, booking share, profitability, etc.) for AA’s airline marketing partners and represented department on cross-departmental systems development projects.Key Contributions/HighlightsJoined group as senior analyst and was promoted to a principalHelped reduce the cost of AA’s 2001 British Airways Alliance project by developing custom applications in-house to fulfill government requested market share and revenue documentation requests.Saved department mainframe charges and streamlined partner reporting process by developing PC-based database, used by 20+ project managers, to measure the financial and operational performance of AA’s interline, codeshare and frequent flyer partners.Tools: SQL, SAS, Excel/VBA, MS Access, Business AnalysisDepartment: Marketing Alliance Planning

Created automated processes, mainframe & PC-based, to report marketing, sales and profitability performance measures to various levels of Passenger Sales’ management (sales rep to VP level).Key Contributions/HighlightsJoined group as an analyst as was promoted twice (Sr. Analyst 11/97, Team Lead 1/99)As Team Lead, planned, organized and directed the activities of 5 analysts responsible for developing production and ad hoc performance reportsProvided technical training to team members as well as other members of the Sales Headquarters organizationTools: SAS, Excel/VBA, MS Access, Business AnalysisDepartment: Global Sales

Identified opportunities for cost savings and operational efficiency improvements for IT audit clients. Additionally, created and maintained software used by both internal auditors as well as the external auditors, Ernst & Young, to independently verify that a specific AA system was performing appropriately.Tools: IBM mainframe, ACLDepartment: Internal Audits

Developed and maintained compliance software, used by the group's auditors, for a number of internal banking applications. Additionally, maintained the performance tracking system used by Senior Management for planning and reporting purposes.