BT

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 Supervisor — RATP 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 Supervisor — Speedaf 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 Leader — NOON

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 Manager — Postex 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 Manager — Jumia

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

BorhanTarek. — Planning & Operations Portfolio

Planning & Scheduling Supervisor

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

Explore Experience Connect on LinkedIn

RATP Dev Mobility Cairo

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..

Operations Portal | SOP & Compliance App dashboard preview
View project
Android & Web App · Offline-First

Operations Portal | SOP & Compliance App

A mobile (Android) and web application running on the same server for transit operations. It digitizes Standard Operating Procedures into guided step-by-step wizards, logs every action a user takes into the admin console, collects digital signatures and acknowledgements from employees whenever a new safety notice or process is issued, and runs station opening / closing checklists. Fully functional online and offline, syncing automatically once connectivity returns.

SOP compliance
Step-by-step
Every procedure is broken into auditable wizard steps — no skipped actions.
Full audit trail
100% logged
Each user action is time-stamped and visible in the admin dashboard.
Digital signatures
Acknowledged
New safety notices and processes are signed off by every employee.
Offline-first
Online & offline
Android and web clients share one server and sync when back online.
Operations Manpower Calculator dashboard preview
View project
Web App · Workforce Planning · Payroll Engine

Operations Manpower Calculator

A comprehensive workforce planning solution designed for operations. The application determines staffing requirements for Train Drivers, Station Masters, and Customer Service Agents by evaluating shift coverage, special duties, roster rotations, standby resources, leave, and expected absenteeism. It also creates individual annual rosters and forecasts monthly payroll and yearly workforce costs, including night-shift premiums and employer overhead. Every result is supported by a clear, step-by-step explanation of the calculations used.

Departments covered
3 + Combined
Train Drivers, Station Masters, CS Agents — plus a combined system overview.
Roster generation
365 days
Full-year shift calendars per staff member with rotation speed control.
Cost estimation
Payroll & budget
Monthly payroll, annual budget, and cost per shift — including night premiums and overhead.
Transparent math
Step-by-step
Every formula is explained — relief multiplier, shrinkage %, and final headcount.
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 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.

Open LinkedIn

Send a message