Skip to content
Abdellah Boudlal

Open to Data Analyst / BI roles

Abdellah Boudlal, Data Analyst. Turning Complex Data Into Clear Decisions.

PHL to DATA

Data analytics, grounded in real-world operations experience at Philadelphia International Airport.

View projectsDownload resumeLinkedInContact
UTC-05 · Philadelphia01 / 06IndexScroll ↓

[recruiter view] · one page, no animation

Portrait of Abdellah Boudlal

Abdellah Boudlal

Data Analyst / BI · Airport operations · Philadelphia, PA

Data Analytics master's candidate working in airport operations at PHL. I build reporting in Power BI, SQL, Excel and Python that turns operational data into clear decisions.

Open to Data Analyst / BI roles

Download resumeLinkedIn →GitHub →abdellah9v@gmail.com
Current role
Bilingual Receptionist / Operations & Technology Support, Philadelphia International Airport (PHL)
Education
Master's Degree in Data Analytics, Northwest Missouri State University (Exp. Mar 2027)
Focus
Power BI · SQL · Python · Operational analytics
Languages
Berber / Tamazight (Native) · Arabic (Fluent) · French (Fluent) · English (Advanced)
Portrait of Abdellah Boudlal
Portrait of Abdellah Boudlal

02 — [about]

Airport operations, read as data.

I'm a Data Analytics master's candidate at Northwest Missouri State University (expected March 2027), with a bachelor's degree in Economics, Management and Commercial Sciences from the University of Tizi-Ouzou.

Since June 2026 I've worked for the City of Philadelphia's Division of Aviation at Philadelphia International Airport, assisting domestic and international travelers and supporting international-arrival operations alongside federal agencies. It gives me a ground-level view of the data an airport runs on.

My approach is practical: start from the operational question, clean and validate the data, then build reporting in Power BI, SQL, Excel and Python that a team can act on. Customs Flight Ops, my airport-arrivals analytics project, is that approach end to end.

[languages]

  • BERBerber / Tamazight· Native
  • ARArabic· Fluent
  • FRFrench· Fluent
  • ENEnglish· Advanced

[flight log]quick facts

Base
Philadelphia, PA · PHL
Role
Bilingual Receptionist / Operations & Technology Support, PHL
Study
Master's, Data Analytics · exp. Mar 2027
Stack
Power BI · SQL · Excel · Python
Seeking
Data Analyst / BI internships & roles

03 — [experience]

Flight log.

Experience and education, most recent first. DEP marks the start, ARR the end.

  1. DEP Jun 2026ARR Present6 mosExperiencePHL

    Bilingual Receptionist / Operations & Technology Support

    Philadelphia International Airport (PHL) · Part-time

    Philadelphia, Pennsylvania, United States · On-site

    Operations and technology support for teams at PHL, and as a bilingual receptionist I help travelers in 4 languages. On the side, I build tools that make the team's daily work easier.

  2. DEP Oct 2018ARR Present8 yrs 2 mosExperience

    Founder & Data Analyst

    Elite Visa · Self-employed

    Tizi Ouzou, Algeria

    Travel agency specializing in tourist visas and study-abroad applications. I founded it, and I'm the one who handles its data.

    • I track every application in Excel and Power BI, from the first meeting to the final decision.
    • Approval rates by destination and visa type.
    • Demand by month, so the agency can plan staff and promotions before the busy seasons, like the summer before the fall semester when study-abroad requests pile up.

  3. DEP —ARR Exp. Mar 2027Education

    Master's Degree in Data Analytics

    Northwest Missouri State University

    USA

  4. DEP —ARR —Education

    English Language & Mathematics Coursework

    Community College of Philadelphia

    Philadelphia, PA

    • English 101 and advanced English studies, plus mathematics.

  5. DEP —ARR Feb 2022Education

    Bachelor's Degree in Economics, Management and Commercial Sciences

    University of Tizi-Ouzou

    Algeria

    • Specialization: Business Economics and Management.

  6. DEP 2019ARR 2021Experience

    Sales & Marketing Associate

    Cobra Technology Store

    Algeria

    • Promoted technology products, supported retail and corporate customers, assisted inventory operations and contributed to marketing campaigns.

  7. DEP 2018ARR 2019Experience

    Customer Service & Account Management

    Algerian Postal Service

    Algeria

    • Processed account transactions, resolved customer inquiries and maintained accuracy in cash handling and documentation.

04 — [projects]

Work that starts from an operational question.

Featured builds first. Visuals are live renders over mock data: no internal airport data, no staff or passenger names.

Data flow · mock data, no internal airport data

Case study · repo private2026

Customs Flight Ops

Airport arrival analytics

Replaces shared-spreadsheet tracking of international arrivals with one pipeline: daily Excel, Google Sheets and FlightAware data, cleaned and validated, feeding Power BI reporting.

  • ETL-style workflow: extract, normalize, validate and load flight records.
  • FlightAware data to update ETAs and gates and flag canceled or diverted flights.
  • Power BI: passenger flow by hour, U.S. vs. non-U.S., peak arrival periods.
  • Supports staffing and resource-planning decisions.
  • Power BI
  • Excel
  • Google Sheets
  • SQL
  • Python
  • Supabase
  • FlightAware

[case study]

Customs Flight Ops — Airport arrival analytics

01 Overview

An independent airport-operations analytics project that centralizes international-arrival information (customs flights, passenger loads, ETAs, gates, alerts, staffing information and change history) and turns it into operational reporting in Power BI.

02 Problem

International arrival information was managed through shared spreadsheets, requiring repeated manual checking and updates.

03 Solution

  • Automated the import and preparation of daily Excel and Google Sheets data, standardizing time and flight-status fields.
  • Built an ETL-style workflow to extract, normalize, validate and load flight records into structured storage (Supabase).
  • Connected FlightAware data to compare and update ETA and gate information and to flag canceled or diverted flights.
  • Built Power BI dashboards for passenger flow by hour, U.S. vs. non-U.S. travelers and peak arrival periods.

04 Architecture

  1. 01Daily customs Excel · Google Sheets · FlightAware AeroAPI

  2. 02Import → Normalize time & status → Validate

  3. 03Structured flight records (Supabase)

  4. 04Operational dashboard · Power BI reporting

Pipeline design only · no internal airport data is shown

05 Business value

  • Less manual work

    Reduced repetitive spreadsheet checking and manual data handling.

  • Operational visibility

    Clearer view of canceled, diverted and delayed flights, ETAs and gate changes.

  • Staffing support

    Passenger volume by hour, U.S. vs. non-U.S. comparison and peak periods to support staffing and resource planning.

  • Power BI
  • Excel
  • Google Sheets
  • SQL
  • Python
  • Supabase
  • FlightAware AeroAPI
  • Node.js

Repository private for now · GitHub profile →

[all repositories]

Synced from GitHub.

Pulled server-side from github.com/Aboudlal and cached for an hour. Search, filter by tag, open any repository for details.

31 repositories

05 — [skills]

Analytics first. Engineering next.

Two honest states, no percentages: what I use in real work and projects, and what I'm learning.

Using applied in work or projectsLearning in progress

Analytics & BI

  • Using: Power BI
  • Using: Microsoft Excel
  • Using: Dashboard development
  • Using: Data visualization
  • Using: Operational reporting

Data preparation & SQL

  • Using: SQL
  • Using: Data cleaning
  • Using: Data validation
  • Using: Data transformation
  • Using: ETL fundamentals
  • Using: API data integration
  • Using: Google Sheets
  • Using: Supabase

Programming & tools

  • Using: Python
  • Using: Jupyter notebooks
  • Using: Git & GitHub
  • Using: Node.js

Machine learning

  • Using: Data preprocessing
  • Learning: Basic machine learning
  • Learning: Model evaluation

Cloud & data engineering

  • Learning: Data engineering
  • Learning: Microsoft Azure
  • Learning: Amazon Web Services
  • Learning: Databricks

[certifications & training]

Verified where a link exists.

  • Analyst BuilderJan 2026

    Git and GitHub for Data Professionals

    Analyst Builder profile →

  • UdemyDec 2025

    The Complete SQL Bootcamp: Go from Zero to Hero

    Jose Portilla / Pierian Training

    Verify credential →

  • Analyst BuilderCompleted

    AI for Data Professionals

    Analyst Builder profile →

  • Analyst BuilderCompleted

    Excel Training

    Analyst Builder profile →

  • Analyst BuilderCompleted

    Python Training

    Analyst Builder profile →

  • AnthropicCompleted

    Claude 101

  • AnthropicCompleted

    Claude Code 101

  • AnthropicCompleted

    Claude Platform 101

  • AnthropicCompleted

    Introduction to Claude Cowork

  • TrainingCompleted

    Basic Machine Learning Training

  • TrainingIn progress

    Cloud Computing Essentials for Azure, AWS and Databricks

06 — [connect]

Let's Turn Data Into Something Meaningful.

Open to Data Analyst / BI roles. Based in Philadelphia, PA.

[message]