00 / Resume
Andrew Hicks
Sr. Analyst, Airport Resource Automation · Envoy Air
01 / Summary
Senior Analyst in Airport Resource Automation at Envoy Air. A business analyst, developer and team leader with three years in airline operations: owning the roadmap for Inform GroundStar RealTime across the ground handling network, leading the department's move from Tableau to Power BI and Microsoft Fabric, and building automation on the Power Platform and Copilot Studio. BS in Business Analytics and Information Systems, MBA in Artificial Intelligence in progress, and an FAA private pilot.
02 / Experience
Sr. Analyst, Airport Resource Automation
Nov 2025 – Present
Envoy Air · Dallas–Fort Worth
- Own the strategic roadmap and continued expansion of Inform GroundStar RealTime across Envoy's ground handling network, driving workforce management and resource allocation improvements.
- Spearhead AI and automation initiatives with Copilot Studio, building intelligent safety tools and launching new process automation on the Microsoft Power Platform.
- Lead the department-wide transition from Tableau to Power BI and Microsoft Fabric, establishing standardized reporting frameworks and modern data pipelines.
- Manage an analyst, balancing task delegation with hands-on mentorship in SQL, the Power Platform and analytics development.
Analyst, Airport Resource Automation
Sep 2023 – Nov 2025
Envoy Air · Dallas–Fort Worth
- Spearheaded deployment of Inform GroundStar RealTime across six major U.S. airports (LAX, DFW, ORD, MIA, JFK, LGA), acting as product owner and subject matter expert between the vendor and operations teams.
- Designed and deployed real-time operational dashboards in Power BI and SQL, enabling data-driven decisions for hub leadership and replacing legacy Tableau reporting.
- Architected end-to-end automation with Power Automate, Power Apps and SharePoint, including safety briefing systems, employee evaluation workflows and attendance tracking.
Intern, Airport Customer Services Policy and Planning
Jun 2023 – Aug 2023
Envoy Air · Dallas–Fort Worth
- Built a performance evaluation program for station leadership and frontline employees, adopted company-wide and reaching 1,000+ staff.
- Presented data-driven findings and strategic recommendations to senior leadership, directly influencing operational policy.
03 / Education
MBA, Artificial Intelligence
University of North Texas
May 2026 – present
BS, Business Analytics and Information Systems
University of South Florida
Dec 2024
04 / Certificates
Google Data Analytics Certificate
Coursera
Aug 2022
Private Pilot Certificate
Federal Aviation Administration
Aug 2021
05 / Skills
Microsoft Power Platform
Analysis & leadership
Data
Frontend
Backend & infra
06 / Projects
- GroundStop.app
Is there a ground stop right now? Live FAA status, delays and alerts.
https://groundstop.app
- next-themes-colors
One component. Twelve colors. Zero flash.
https://next-themes-colors.vercel.app