Back to site

00 / Resume

Andrew Hicks

Sr. Analyst, Airport Resource Automation · Envoy Air

Dallas–Fort Worth, TXlinkedin.com/in/andrewkhicksgithub.com/andrewhicks123

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

  1. 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.
  2. 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.
  3. 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

Power BIPower AppsPower AutomateMicrosoft FabricCopilot StudioSharePoint

Analysis & leadership

Product ownershipStrategic roadmapsVendor & stakeholder managementOperations analyticsMentoring

Data

SQLPostgreSQLTableauExcelInform GroundStar RealTime

Frontend

Next.jsReactTypeScriptTailwind CSSshadcn/ui

Backend & infra

Node.jsPrismaDrizzle ORMMongoDBAWSVercel

06 / Projects

  • GroundStop.app

    Is there a ground stop right now? Live FAA status, delays and alerts.

  • next-themes-colors

    One component. Twelve colors. Zero flash.