Borhan Tarek — Planning & Scheduling Supervisor

Cairo, Egypt · Email: Borhan.Tarek.Haddad@gmail.com · Phone: +20 112 005 1731 · LinkedIn: https://www.linkedin.com/in/borhantarek/

Professional Summary

Planning & Scheduling Supervisor at RATP Dev Mobility Cairo with 8+ years of experience across rail operations, logistics, and supply chain. Skilled in HASTUS train timetabling, workforce rostering, Power BI, SQL, Python, and Power Apps. MBA candidate at ESLSCA University (Class of 2027) and Professional Diploma in Data Analytics from AASTMT.

Work Experience

Planning & Scheduling SupervisorRATP Dev Mobility Cairo

Mar 2022 – Present

  • Developed and optimized train service timetables and staff rosters in HASTUS, analyzing ridership, fleet availability, and staffing levels.
  • Lead digital transformation initiatives, transitioning paper-based workflows to PowerApps, Excel, and Power BI.
  • Coordinate with Operations, Maintenance and HR to ensure reliable service delivery.
  • Manage dispatching officers and maintain operational SOPs for Driver, CCP and ROM functionalities.
  • Previously served as Mainline Supervisor on Cairo Metro Line 3 — ensuring safe service under nominal and degraded conditions and supporting driver training and competency assessment.

Expansion SupervisorSpeedaf Egypt

May 2021 – Nov 2021

  • Led company launch and legalization efforts, including securing the Postal License.
  • Managed the setup of warehouses and hubs across Egypt.
  • Recruited and implemented operational, customer service, and sales teams.
  • Integrated telecom SMS solutions for automated shipment dispatch notifications.

Logistics Team LeaderNOON

Oct 2020 – May 2021

  • Managed operational performance for Hub and delivery operations, ensuring KPI and SLA targets were met.
  • Assigned delivery schedules to couriers and optimized route plans.
  • Developed industry best practices and SOPs for operations and customer service teams.

Operation ManagerPostex Egypt

Jan 2018 – Aug 2020

  • Managed shipping and receiving operations, ensuring safety compliance.
  • Supervised warehouse staff — recruitment, scheduling, and onboarding.
  • Developed safety and security protocols; conducted quarterly efficiency reviews.

3PL Account ManagerJumia

Sep 2017 – Dec 2018

  • Managed domestic logistics operations, including shipment scheduling and returns.
  • Negotiated with 3PL partners and resolved operational quality and scheduling issues.
  • Maintained strong partner relationships and trained teams on ERP usage.

Education

Skills

Certifications & Training

Full CV (PDF): Download Borhan Tarek CV

Cairo, Egypt · Available for strategic roles

Borhan Tarek

Planning & Scheduling Supervisor

Optimizing urban transport networks, train timetabling, and supply chain logistics through data-driven planning and workforce strategy.

RATP Dev Mobility Cairo
LRT & Metro Timetabling & Workforce Rostering
MBA Candidate
ESLSCA University · Class of 2027
Data Analytics Diploma
AASTMT — Python · SQL · Power BI
About Me

Where operations meet data & strategy.

Borhan Tarek
Borhan Tarek
Planning · Data · Operations
Cairo, Egypt
Borhan.Tarek.Haddad@gmail.com
+201120051731
iTEP Academic 3.8 · CEFR B2

I bring together 8+ years of operations leadership across mass transit and e-commerce logistics with modern data engineering and executive business strategy. Today I lead planning and scheduling at RATP Dev Mobility Cairo — building timetables and rosters in HASTUS, digitizing paper workflows into PowerApps and Power BI, and aligning Operations, Maintenance and HR around KPI-led service delivery.

Before rail, I scaled logistics networks and last-mile operations at Postex, Speedaf, NOON and Jumia — launching hubs, managing 3PL partnerships, and hardening SOPs. My MBA at ESLSCA and Data Analytics diploma at AAST connect the field-tested playbook with strategic finance, analytics, and process engineering.

8+
Years leading ops
5
Enterprise employers
3
Degrees & diploma
Education
  • MBA — ESLSCA University2027
  • Diploma in Data Analytics — AAST2022
  • Bachelor of Commerce — Cairo University
  • Bachelor of Aviation Science2015
Career Timeline

Experience across rail & logistics.

Data & Skills

Tech stack, tools & certifications.

Transit & Workforce Planning

HASTUSTrain TimetablingCapacity PlanningRoster OptimizationTransit OperationsSOP Engineering

Data Analytics & BI

Power BIDAXPythonSQLDashboard EngineeringAdvanced ExcelPowerApps

Operations & Leadership

Supply Chain Strategy3PL Account ManagementProcess EngineeringLogistics OptimizationERP · SalesforceTeam Enablement
Additional certifications
Intermediate Python — DataCamp
Python Data Science Toolbox — DataCamp
Data Preparation in Power BI — DataCamp
Intermediate SQL — DataCamp
Joining Data in SQL — DataCamp
Data Analysis in Spreadsheets — DataCamp
Train Troubleshooting (Rotem & Mitsubishi) — RATP
Train Driving License (Rotem & Mitsubishi) — RATP
Local Signal Box Course — RATP
Station Master Office Course — RATP
Projects & Case Studies

Data-backed work, shipped in production.

PowerBI Project | UK Train Rides dashboard preview
View project
Power BI · Maven Analytics

PowerBI Project | UK Train Rides

A full-stack Power BI dashboard analyzing UK national rail ticket data. Built for the Maven Analytics challenge, the report explores booking behavior, revenue patterns, payment preferences, and refund rates — turning raw ticket transactions into actionable commercial insights.

Online booking share
King
Most passengers book online, not at stations.
Credit card dominance
Top
Credit cards are the most popular payment method.
Refund rate
4%
Low refunds signal high satisfaction and service quality.
First class demand
20%
One in five tickets is First Class, showing premium appetite.
PowerBI Project | Unicorn Companies dashboard preview
View project
Power BI · Maven Analytics

PowerBI Project | Unicorn Companies

As part of my Maven Analytics project, I built a Power BI dashboard that breaks down the global unicorn landscape — from country share and sector leaders to the giants at the top of the valuation ladder.

US market share
52.38%
United States dominates the global unicorn landscape.
China share
16.12%
China holds the second-largest share of unicorns.
Leading sectors
Fintech & Internet Software
These sectors lead in total company count.
Top valuation
$180B
ByteDance leads, followed by SHEIN and SpaceX at $100B each.
HASTUS · Workforce

Transit Timetable & Roster Optimization

Advanced scheduling framework built in HASTUS for high-capacity public transport networks — modeling ridership, fleet availability and staffing to protect service quality across LRT and metro operations.

Logistics · Hub Setup

Supply Chain Expansion Framework

Network scaling playbook covering hub location, warehouse setup, licensing and last-mile routing — proven while launching Speedaf Egypt and scaling last-mile at NOON.

Power BI · DAX · PowerApps

Executive BI Dashboards

Interactive Power BI dashboards and PowerApps replacing paper-based workflows, giving operations leaders live visibility on KPI, SLA, and rostering health.

Get in touch

Let's build something operational.

Direct channels

Tap any card to copy — or reach out on LinkedIn.

Send a message