Youssef Khoury / Analyst
Youssef Khoury

Portfolio — 2026

I turn operational data into clear decisions.

Order-to-delivery operations experience, turned into Power BI, SQL and Excel reporting that makes risk visible and names the next action.

01

Define the question — the decision it supports and what a good answer looks like.

02

Build the evidence — clean, model and validate the data into something you can trust.

03

Drive the decision — turn the finding into a cause, an owner and a next step.

Power BI · SQL Server · Excel · Power Query · DAX · Business Central · Xero

Power BI, SQL Server, DAX, Power Query, Excel, star schema and data modeling, KPI governance, requirements, process mapping, UAT, RAID logs, Business Central, Xero, dashboards, and AI-assisted workflows.

Selected work

2026

Four self-directed analytics projects, built end-to-end on synthetic data modeled on real order-to-delivery operations. Each ships a case-study PDF and its working file.

420-order model, data dictionary, star schema, 8 governed KPIs and a live interactive dashboard.

Output delivery-risk, supplier and overdue-cash exposure in one weekly view — every figure traceable to source.

420 orders across projects, suppliers, delivery milestones, invoices and payments — with no single view of where delivery or cash was at risk.
A star schema and data dictionary, 8 governed KPIs, an Excel control tower, a Power BI report, and an interactive web dashboard with a transparent Urgent / High / Watch action queue.
On-time delivery of 69.4%. Supplier lead time drove 45.7% of delayed order value ($1.24m) — the largest single root cause. $1.29m of receivables were overdue. 25 delayed orders had no recorded blocker, surfaced as a data-quality exception rather than a guess.

69.4% on-time delivery  ·  45.7% of delayed value ($1.24m) traced to a single root cause

360 invoices turned into aging, a DSO proxy, promise coverage and a cash-priority queue.

Output a ranked list of which invoices to chase first, by expected cash and customer risk.

360 invoices across 48 customers, with collections chasing by invoice age rather than by recoverable cash.
A formula-driven Excel command center — aging, overdue exposure, a DSO proxy, promise coverage and a cash-priority queue — plus a customer risk summary, a governed metric dictionary and reusable SQL.
88.7% of the $949k receivables book was already overdue, and $322k of that sat in the 90+ day bucket. Against a 55.7-day DSO proxy, open payment promises covered only 30.5% of overdue exposure — most of the cash at risk had no committed date behind it. Disputes, broken promises and aging risk are scored separately so the queue chases expected cash, not invoice age.

88.7% of the book overdue  ·  only 30.5% of that exposure covered by a payment promise

300 purchase orders scored for spend, OTIF, fill rate, price variance, defects and supplier risk.

Output every supplier sorted into a risk tier, with the drivers behind each score.

300 purchase orders across 20 suppliers, with supplier reviews argued from anecdotes rather than evidence.
A scorecard rating spend, OTIF, fill rate, delay, price variance and defects. Price, delivery and quality stay separate before combining into a transparent risk score. Plus a category-spend view and reusable SQL.
OTIF ran at 37.7% while fill rate held at 98.9% and defects at 0.64% — suppliers were shipping the right goods, an average of 4.0 days late. Four suppliers carrying $1.94m of the $9.61m spend scored 0% OTIF. Naming that as a lead-time problem, not a quality one, points corrective action at schedules instead of blanket pressure.

37.7% OTIF against a 98.9% fill rate — a lead-time problem, not a quality one

24 requirements with acceptance criteria, traceability, 30 UAT cases and readiness reporting.

Output 24 requirements as tested, signed-off, fully traceable delivery evidence.

Service requests arriving with inconsistent fields, unclear ownership and unreliable SLA handling.
24 requirements with testable acceptance criteria, a requirements traceability matrix, 30 UAT cases with pass / fail / blocked evidence, a RAID log and a go-live readiness summary — all linked in one Excel workbook.
120 service requests analysed into 24 requirements, 20 of them approved at the readiness review. Traceability coverage reached 100% — every requirement tied to a test case — with an 83.3% UAT pass rate (25 pass, 3 fail, 2 blocked) and 8 open high-priority items carried into the go-live decision rather than quietly closed.

100% traceability coverage  ·  83.3% UAT pass rate, with 5 fails and blocks carried openly into go-live

Flagship — liveInteractive

One governed view of value, delivery risk, supplier performance and overdue cash.

The 420-order model carries a data dictionary, a SQL star schema, reusable DAX measures, eight KPIs, an Excel control tower and BA artifacts — feeding one interactive dashboard.

Dataset is synthetic. Model, analysis and deliverables are original work.

● ● ●LIVE ANALYTICSFull screen ↗

Experience

2023 — Now

Operations & Projects Lead Alta Light

Cut end-to-end order-to-delivery lead time from 2–3 months to about 2 weeks by mapping the process, tracing recurring delays to three root causes and rebuilding supplier follow-up; management adopted 3 of 5 recommendations. Run 40+ concurrent orders and projects worth $1M+ across 20+ suppliers, and built the Excel dashboard used for weekly operations reviews.

Operations Associate Alta Light

Coordinated day-to-day order-to-delivery execution across suppliers, purchasing and delivery follow-up — the operational grounding that led to the Lead role.

Administrator UPM

Maintained the Excel tracker for ~30 client accounts, reported delivery and receivables status, reconciled records against invoices and payments, owned daily client follow-up.

Financial Consultant SNA

Supported client needs assessments, underwriting submissions, policy documentation, claims, renewals and audit-ready client files.

Project Coordinator Facilitate International

Coordinated 500+ construction, maintenance and residential service requests for US and Canada clients — progress, quality, issues and updates.

Contact

Let’s talk.

Email copied