Two months inside the second-busiest U.S. airport
Peak-hour passenger-flow time studies, an Excel-VBA collection tool over 50% faster, a sensor network audited to 98% data accuracy, checkpoint layouts redesigned in AutoCAD with queuing theory, and an evaluation of the world's first One Stop Security initiative.
- Excel VBA
- AutoCAD
- Time Studies
- Statistical Analysis
−50%
Data processing time
Passenger-flow sensor network at 98% data accuracy
2nd
Busiest U.S. airport
Field research with industrial engineers
CTX
Baggage machines optimized
Routing speed at ticket-counter bag drops
OSS
One Stop Security
First-of-its-kind initiative, evaluated
Collect
Excel-VBA data collection tool built for peak-hour passenger-flow studies.
Process
Manual processing replaced by automated pipelines at maintained accuracy.
Visualize
Seat-condition heat map merging Excel, VBA, and AutoCAD for maintenance triage.
Act
Checkpoint layouts redesigned in AutoCAD. Wait times down, queue capacity up.
Context
The second-busiest U.S. airport, two months before its next big test
DFW International Airport is the second-busiest airport in the United States, and its operational planning runs on current, accurate passenger-flow data. I worked with industrial engineers on operational projects to improve efficiency and passenger experience, in an environment where every number I produced had to be right.
The marquee initiative was One Stop Security (OSS), the world's first implementation of its kind, and checkpoint layout planning needed current, accurate passenger-flow data to design around.
Problem
Great analysis starts with terrible data collection
Passenger-flow data collection was manual and slow. Time spent processing records was eating the time available for analysis, and maintenance teams had no systematic view of seat conditions across the terminal. Before any layout could be redesigned, the data pipeline itself had to be fixed.
Constraints
Two months, a live terminal, and numbers that drive decisions
The project window was two months, August to September 2025, and the terminal does not pause for research. Time studies had to be conducted during actual peak operating hours, which meant working around real passengers, real staff, and real security procedures rather than a controlled lab condition.
The second constraint was consequence: these numbers were going to leadership, in an environment preparing for major demand growth. That set the standard for the work — every figure needed a traceable path from raw observation to processed record to recommendation, and the collection tool itself had to be reliable enough that the audit trail held up. The third was practical: the tool would be used on the terminal floor, not at a desk, so it had to be operable in field conditions with the software already available.
Role
Field research intern: tools, studies, and presentations
I built and deployed the measurement layer, ran the studies, and presented the findings directly to airport leadership. The work spanned six deliverables:
- A sensor-network audit comparing automated logs against manual time-study data, resolving system glitches to maintain 98% data accuracy for passenger-flow metrics.
- An Excel-VBA tracking system with color- and gender-coded buttons that eliminated manual tracking errors and cut data processing time by over 50%.
- A custom asset-tracking heat map mapping terminal seating in AutoCAD and linking the visuals to Excel scatter plots, with VBA forms automating data entry for maintenance repairs.
- Redesigned checkpoint layouts in AutoCAD, applying queuing theory and flow analysis to eliminate bottlenecks, optimize lane capacity, and reduce wait times.
- An evaluation of the One Stop Security (OSS) initiative, the world's first of its kind, through peak-hour time studies across screening, baggage handling, and ground operations.
- CTX baggage-routing optimization at airline ticket counters, accelerating bag handling while preventing passenger tampering after luggage weighing.
Outcome
Presented to airport leadership
I presented key findings and recommendations directly to airport leadership, in front of the same people accountable for moving millions of passengers through the terminal each year. The data tool remains a reference for how the flow studies were run.
Limitations
What an internship window can and cannot establish
These were peak-hour observation windows at one terminal over two months — not a year-round network model of passenger flow. The findings characterize the peak conditions they were designed to capture, and should be read that way.
The checkpoint redesigns and OSS evaluation were delivered as recommendations to airport leadership. Implementation, construction, and any post-deployment measurement of wait-time reduction sit with the airport, not with this internship — so this case study presents the analysis and the redesign work, and does not claim measured after-results. The CTX baggage-machine work was evaluated at ticket-counter positions specifically.
Lessons
Measurement is a product
The VBA tool mattered more than the studies it enabled, because it made the studies repeatable at twice the speed. I learned that the tooling around analysis is often the biggest payoff of the work, and that presenting numbers to decision-makers requires the same rigor as producing them.