Skip to content
Omar Nagem.
All work
Case 02 of 05
Dallas Fort Worth International AirportDallas, TXField Research InternAug to Sep 2025Presented to leadership

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

FIELD WORKFLOW · AUG TO SEP 2025PRESENTED TO LEADERSHIP
01Tool in the field

Collect

Excel-VBA data collection tool built for peak-hour passenger-flow studies.

02−50% time · 98% data accuracy

Process

Manual processing replaced by automated pipelines at maintained accuracy.

03Repair prioritization

Visualize

Seat-condition heat map merging Excel, VBA, and AutoCAD for maintenance triage.

04One Stop Security

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.

Industrial engineering is a trust business. Your numbers drive big operational decisions, so instrument them properly first.

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.

© 2026 Omar Nagem