Lead BI Analyst and Developer• Azure Data Factory designer • Suported Power BI reporting environment • Developed new Azure Data Factory pipelines• Integration of QuickBooks into CRM and Azure Data Lake • Performed the role of DBA on the Azure SQL Database• Led the conversion of CRM replication process from DES to Synapse

Supported United’s domestic and international agency and corporation incentive systems; developed reporting tools to help business partners provide front and back end marketing incentives to drive future ticketing sales.• Designed and developed Power BI reports used in agency and corporate incentive programs. • Implemented Microsoft Power BI Office 365 subscription.• Converted Microsoft Power BI Embedded workspace to Azure workspace collection.• Served as key resource in implementation of Microsoft Azure Data Warehouse; experienced and proficient with database administration activities such as object creation, deletion, alter, updating, reorgs, unloads, reloads, image copies, backups, and recoveries.• Coordinated joint venture efforts between Star Alliance airlines to implement a shared data warehouse used to build a joint venture revenue program.• Coordinated implementation of a Power BI on-prem environment for use by United’s sales analytics team.• Refreshed data and performed backup and restore tasks for Azure Data Warehouse.• Implemented an automated process to load data files retrieved from United’s Teradata EDW to the Azure SQL Data Warehouse.• Managed data sourcing all information needed to implement a Sales Dashboard built on Azure SQL Server Integration Services (SSIS).

Created language codes for programs, tested functionality and reviewed errors to troubleshoot issues.• Supported mainframe programming utilized to develop reporting tools against DB2 database. • Functioned as lead programmer in the development of a Visual Basic online reporting tool designed to provide revenue forecasts and evaluated and reported progress against goals and milestones.• Ensured individual priorities and goals were aligned with team, manager, and agency plans and needs, and increases or redirects efforts in the face of challenging obstacles, changing priorities, or increasing demands.• Prepared, formulated, justified, reported on, and managed budgets.• Collected, organized, and analyzed data and other statistical information, including identifying and resolving data discrepancies and issues.• Developed ticketing sales reports to determine payments to domestic ticket agencies using BrioQuery reporting.

Developed and supported Cobol programs that updated tables on the Mainframe DB2 database; wrote the job control language (JCL) to process flat files for use in loading DB2 database tables.• Demonstrated ability to support and perform complex jobs and actions to prevent outages and service interruptions.• Formulated and defined system scope and objectives through research and fact-finding to develop or modify moderately complex information systems to solve business problems.