Data & Business Analyst · Tabuk, Saudi Arabia

Where Data Meets
Decision — And
Revenue Follows.

I engineer the intelligence layer between raw operations and strategic decisions. From live hourly P&L reports to menu engineering, channel analysis, food cost breakdowns, delivery platform waterfalls, and customer loyalty systems — I build the full picture so the business can act with precision, not assumptions.

View My Work Get In Touch ⬇ Download CV

Revenue Under Management · Emboss Burgers

SAR 862K

Monthly Revenue — 3 Branches, Tabuk

↑ 314% growth in 6 months · from SAR 208K

122,897

Total Orders Processed

66.1%

Gross Margin Maintained

+509%

Delivery Channel Growth (Jan→May)

SAR 46.81

Avg Order Value (AOV)

About

Analyst. Architect.
Business Intelligence
Partner.

"I don't just report what happened. I build the systems that explain why — and show exactly what to do next."

With a B.Tech in Information Technology and deep hands-on experience across multi-outlet F&B operations, I combine technical depth with business fluency. I build complete reporting ecosystems — not individual dashboards.

Currently architecting the entire data intelligence layer at Emboss Burgers: hourly ops profitability, delivery platform P&L waterfalls, menu engineering, food cost auditing, channel growth analysis, morning window profitability, combo attachment analysis, and a fully custom digital loyalty program — all live, all connected, all actionable.

Built revenue intelligence that grew monthly revenue from SAR 208K to SAR 883K in 6 months
Engineered delivery channel strategy that drove +509% growth (Jan→May 2026)
Designed and deployed a live digital loyalty program with cloud database and WhatsApp API automation
Created daily hourly P&L reports applying full cost waterfall across 3-branch multi-outlet operations
Produced full P&L, food cost, menu engineering, and channel reports in Arabic and English

BI & Visualization

Power BIDAXTableauData Modelling

Databases

SQLMySQLPostgreSQLSupabase

Programming

PythonPandasNumPyAPIsGit

Spreadsheets

ExcelPower QueryGoogle Sheets

Analytics

EDAMenu EngineeringKPI DesignA/B TestingRCA

Systems & AI

ERPAI-Powered ReportingWhatsApp APIPOS Integration

Keeta Future Table Award — Emboss Burger

Keeta FutureTable Recognition · 2026 — Emboss Burger recognised by Keeta platform for outstanding delivery sales growth. Over 300% revenue increase achieved through data-driven strategy, Tabuk, Saudi Arabia.

Current Impact · Emboss Burgers

How I Grew a Multi-Branch Restaurant Group by 314% in 6 Months.

When I joined Emboss Burgers, there was zero data infrastructure. No hourly visibility, no platform P&L, no channel strategy, no food cost auditing. I built the complete intelligence system — and revenue followed every layer I added.

SAR 208K → SAR 883K

Monthly Revenue · 6-Month Journey

+509%

Delivery Channel Growth · Jan → May 2026

3 Branches

Full Data Intelligence Coverage · Tabuk

Live Reporting · Hourly P&L · Waterfall Model

Hourly Operations Report — Estimated Contribution Profit Per Hour

A comprehensive daily operations report produced for all branches — breaking down every trading hour with full estimated profitability after applying a multi-layer cost waterfall. Built to give management real-time visibility into when the business is truly profitable versus when it is running at a cost.

Revenue waterfall applied per hour: platform commissions stripped per delivery channel
Card payment processing fee removed from dine-in and takeaway revenue
Food cost deducted using live cost data — not estimated averages
Labour cost allocated hourly based on headcount and wage rate
Rent and marketing expenses prorated and deducted per hour
Result: Estimated Contribution Profit per hour — showing true operating performance
Demand band classification per hour: Lean, Build-Up, Peak, Critical Peak
Action notes generated for branch managers based on hourly performance

Why This Matters

This report transforms raw hourly sales data into a decision-making tool — enabling precise staffing, cost control, and operational adjustments based on actual contribution profit, not surface-level revenue

Executive Snapshot — All Branches

Hour-by-Hour P&L — Est. Profit Column Visible Hourly Table Full

Menu Engineering Dashboard — Power BI Menu Engineering Power BI

Menu Engineering Report — March 2026 · Bilingual Menu Engineering March 2026

Boston Matrix · Product Strategy · Bilingual

Menu Engineering & Product Intelligence

A structured product performance framework classifying every menu item as Star, Puzzle, Ploworse, or Dog — based on Contribution Margin percentage and Sales Mix percentage. Produced monthly in both Arabic and English for management and ownership review.

Contribution Margin per unit, CM%, Sales Mix% calculated for every SKU
Boston Matrix classification applied — clear action per product category
Stars identified and promoted through platform listing prioritisation
Dog items flagged for removal, repricing, or repositioning
Combo bundles engineered based on high-CM item combinations
Full bilingual report produced — Arabic for ownership, English for operations
Output directly feeds delivery platform strategy and pricing decisions

Business Impact

Menu restructuring and engineered combo bundles drove a 747% increase in delivery platform revenue over 5 months — from a low base to becoming the business's primary revenue channel

HungerStation · Keeta · Ninja · Jahez · Waterfall Model

Delivery Platform P&L — Revenue to True Profit, Step by Step

A complete financial waterfall model applied to every delivery platform — stripping each cost layer step by step to reveal what the business actually keeps. Built per platform, per branch, covering all 4 platforms in one consolidated view in Arabic and English.

Step 1 — Gross Sales: Total platform sales including VAT captured from POS per branch
Step 2 — Delivery & Commission: Platform commission rate and delivery fee deducted — each platform has a different structure
Step 3 — CPC Advertising: Restaurant-funded platform ad spend deducted separately from revenue
Step 4 — Net Settlement: Actual amount the platform transfers to the restaurant bank account
Step 5 — Food Cost: COGS deducted using live cost data per branch — not estimates
Step 6 — Gross Profit: True profit per platform per branch with GP% of total sales shown
All 4 platforms compared: HungerStation, Keeta, Ninja, Jahez — each branch independently then consolidated
Produced in Arabic for ownership — enables platform profitability comparison with full cost visibility

Why This Report Is Critical

Without this breakdown, management sees only gross platform revenue — misleading and incomplete. This model reveals the real money the business keeps after every cost layer, enabling platform-level profitability decisions and commission negotiation backed by actual data

Platform Waterfall — Selling Price to Gross Profit Platform Waterfall Model

Delivery Platform P&L — June 2026 · All Branches · Arabic Platform P&L June 2026

Champion Box — Full Cost & Profit Breakdown Champion Box Cost

Platform Breakdown — Multi-Price Scenario Model Platform 99 SAR

Pre-Launch Analysis · Pricing Intelligence · Cost Modelling

New Product Cost & Profit Analysis — Before Every Launch

Before any new product or bundle is launched, I build a complete cost and profitability model — calculating exact food cost per ingredient, gross profit, and GP% across all delivery platforms at multiple price scenarios. No product launches without full financial visibility.

Weighted average food cost per ingredient sourced from live cost data
Packaging and bag deduction applied correctly per item type
GP% modelled at original price and discounted price scenarios simultaneously
Platform waterfall applied — actual GP shown after each platform's commission structure
Allows comparison: which platform generates most profit for this product at this price?
Prevents launching products with unviable margins on specific platforms

Why This Matters

Every new product launched goes through this model first — ensuring pricing decisions are built on real food cost and real platform margins, not assumptions or historical averages

Cost of Goods · Branch-wise · Category-wise · Bilingual

Food Cost Breakdown — By Channel, Branch & Category

A complete monthly Cost of Goods Sold analysis breaking food cost into every channel and category — delivery platforms, dine-in, takeaway, employee meals, and owner meals — tracked per branch and reconciled against the live POS database. Produced in Arabic for ownership review.

Food cost isolated per delivery platform — each platform's cost tracked separately
In-store food cost split: dine-in vs takeaway, further split by till vs kiosk orders
Non-revenue food cost tracked separately: employee meals, owner meals, loyalty redemptions
Branch-level breakdown: each branch fully reconciled independently
All figures verified against POS control dashboard — zero rounding tolerance
Percentage of total food cost shown per category — reveals where cost is concentrated
Identifies cost anomalies across channels that would be invisible in a blended report

Why This Matters

Breaking food cost by channel and category reveals which order types carry the highest cost — enabling targeted reduction strategies rather than blunt across-the-board cuts

Food Cost Breakdown — Multi-Branch · Arabic Food Cost COGS

Monthly KPI Report Cover — Same-Period Comparison KPI Cover

Delivery Platform Breakdown — All 4 Platforms KPI Delivery

Monthly Intelligence · All Channels · All Branches

Monthly KPI Comparison Report — Same-Period, All Channels

A structured monthly KPI report comparing the same calendar-day window across all channels and branches — eliminating month-length distortion for a fair, accurate performance picture. All figures reconciled against the live POS database before distribution.

Same-period comparison window — removes month-length bias from comparisons
All channels covered: Dine-in, Takeaway, all 4 delivery platforms, other channels
Revenue, orders, AOV, and daily averages tracked per branch per channel
Channel shift signals identified — structural changes flagged vs temporary fluctuations
Grand total reconciled against POS FactInvoice database — zero discrepancy tolerance
Executive summary with key findings and actionable insights included

Value Delivered

Management receives one verified, reconciled source of truth each month — enabling channel strategy decisions based on accurate comparable data rather than raw unfiltered numbers

5-Month View · Channel Mix Evolution · Strategic Analysis

Channel Growth Analysis — Identifying Structural Business Shifts

A longitudinal channel analysis tracking how Dine-in, Takeaway, and Delivery have grown and shifted share over a 5-month window — distinguishing structural business changes from seasonal fluctuations. Designed to inform channel investment and operational strategy.

Month-by-month absolute revenue and share tracked per channel across all branches
Growth rate calculated both absolute (SAR) and relative (channel share %)
Structural shift identification: separates trend from temporary movement
Channel share evolution visualised — shows how the business mix is changing
Bottom-line narrative: what the data means for operations and investment priorities
Guides decisions on where to allocate marketing budget and operational focus

Key Finding

Analysis confirmed a structural channel shift — delivery grew from 25% to 54% of group revenue in 5 months, identifying it as the business's primary growth engine requiring dedicated investment

Channel Growth Analysis · Jan–May 2026

Morning Window Profitability Model — Branch Analysis Morning Profitability

24-Hour Operations · Window Profitability · Monthly Validation

Morning Window Profitability — Validating Extended Operating Hours

Following a recommendation to extend branches to 24-hour operations to address high prime cost, I built a dedicated monthly profitability model for the morning window — validating the decision with data every month rather than relying on assumptions.

Revenue waterfall applied per morning hour — platform commissions stripped per invoice type
Menu engineering retention ratio applied to adjust for product mix during morning hours
Labour cost modelled at lean headcount: wage rate × headcount × hours × electricity
Rent allocated proportionally to morning window based on branch trading hours
Marketing spend prorated to morning hours based on branch revenue share
Estimated Contribution Profit calculated after all deductions — hour by hour
Produced monthly per branch to track whether morning hours justify their operating cost

Why This Matters

This model converts a business decision into a measurable, trackable financial outcome — replacing gut-feel operational choices with monthly data-backed validation of whether extended hours generate real contribution profit

Item-Level Analysis · Cost Reduction · Combo Intelligence

Food Cost Analysis — Item-Level Excess Identification & Combo Attachment

Granular food cost analysis ranking every product by excess cost impact — separately for Dine-in/Takeaway and Delivery platforms, with a dedicated combo attachment analysis showing how standalone add-ons reduce effective food cost percentage across the order mix.

Every item ranked by Excess SAR: revenue × (actual FC% − target FC%) — highest impact first
Selling price and food cost calculated on ex-VAT basis for accurate comparison
Delivery platforms: FC% calculated on net received after commissions — not gross sales
Combo items: food cost equals sum of all components — no approximation
Clear status: Within Target ✅ or Exceeds Target 🔴 — immediately actionable
Combo attachment analysis: tracks how standalone items ordered with combos dilute FC%
Net rate impact quantified — shows exactly how much attachment improves overall margin

Value Delivered

Item-level excess ranking enables surgical cost reduction — targeting the highest-impact items first rather than applying blanket cost controls that miss the real drivers

Dine-in & Takeaway — Food Cost by Item Dine-in FC

Delivery — FC% of Net Received · All Platforms Delivery FC

Combo Attachment Analysis — Effective FC% Impact

Full P&L — Multi-Branch · Arabic · All Cost Layers

Multi-Branch · Full P&L · Arabic & English · Monthly

Full Monthly P&L — Complete Financial Picture Across All Branches

A complete monthly Profit & Loss statement covering every cost layer from gross revenue down to net profit — built for multi-branch operations with branch-level and consolidated views. Produced in Arabic for ownership and available in English for management teams.

Captures all revenue streams: delivery platforms, dine-in, and takeaway per branch
Food cost reconciled at two levels: VAT-inclusive for reporting, ex-VAT for operational control
Prime cost tracked as a combined food + labour metric — most critical F&B efficiency indicator
All operational expenses itemised: commissions, rent, utilities, marketing, admin, maintenance
Branch-level P&L produced independently — identifies which branches drive profitability
Consolidated group P&L produced alongside — gives ownership a single combined view
Arabic output for ownership · English version available for management and investors
All figures reconciled against live POS and bank data — no estimation or rounding

Why This Matters

A properly structured multi-branch P&L gives ownership complete financial accountability per branch — making it possible to identify cost drivers, allocate resources, and make expansion decisions based on verified data

Full-Stack Development · Cloud Database · WhatsApp API · Meta

Emboss Circle — Digital Loyalty Program Designed & Built In-House

A fully functional digital loyalty web application designed, built, and deployed across 3 branches — running live on branch tablets placed at the customer counter. The system handles the complete customer journey from first visit registration through to reward redemption, with automated WhatsApp reminders powered by Meta's Business API.

Tablet placed at branch counter — customer enters phone number to register on first visit
Customer enters name once to create account — phone number becomes their loyalty card forever
Every return visit: customer enters phone number → stamp added → card updates instantly
After collecting all stamps: reward screen appears → cashier confirms → free meal redeemed
All phone numbers collected automatically → customer database built with every visit
WhatsApp Business API (Meta) integrated — automated reminders sent when customers are close to reward
Admin dashboard: total members, daily stamps, redemptions, branch-level breakdown, CSV export
PostgreSQL cloud database — all data owned by the business, not a third-party platform
Progressive Web App — runs fullscreen on branch tablets with no browser UI visible
Separate tablet configuration per branch: Olaya, Masif, Muruj each pre-set automatically

Strategic Value

This system gives Emboss Burgers direct ownership of its customer database — enabling personalised WhatsApp communication independent of any delivery platform, building customer retention through data the business fully controls

Customer-Facing App — Branch Tablet View Loyalty App

Admin Dashboard — Member & Stamp Tracking

Daily Branch Challenge — Live Competition Report Branch Competition

Staff Performance · Gamification · Daily Tracking

Multi-Branch Daily Competition System — Driving Upsell Behaviour with Data

A daily inter-branch performance competition system designed to translate data directly into staff behaviour — tracking three key upsell metrics every session and converting them into a live points system. Built entirely from scratch using live POS data, distributed to branch managers daily.

Three metrics tracked per session: Combo Rate, Add-on Rate, Drink Attachment Rate
Combo Rate: percentage of dine-in & takeaway orders that included a combo box
Add-on Rate: percentage of orders that included extra patty, mushroom, bacon, cheese, or sauce
Drink Rate: percentage of orders that included a drink alongside the burger
Points system: branches ranked 1st/2nd/3rd per metric — 3 pts, 2 pts, 1 pt per metric
Maximum 9 points per session — rate beats volume: efficiency rewarded over raw numbers
Daily champion declared · monthly cumulative standings tracked per branch
Personalised next-session coaching notes generated per branch manager automatically

Why This Matters

Converting operational metrics into a live competition makes data meaningful for frontline staff — driving measurable improvements in combo attachment, add-on rates, and average order value through daily accountability and visible rankings

Day-to-Day Intelligence Work

What I Build, Every Single Day

Beyond the major analytical frameworks, this is the operational intelligence layer maintained daily — ensuring the business always has full data visibility to make precise decisions.

📊

Branch Performance Reports

Monthly narrative reports per branch — growth story, channel mix evolution, top product analysis, food cost trends, and specific focus areas defined for the following month. Produced per branch and consolidated.

🔍

Food Cost Auditing

Regular audits of food cost by order type — delivery, dine-in, takeaway, employee and owner meals — per branch. Flags raised on any item or hour where food cost exceeds defined targets.

⚙️

ERP Evaluation & POS Integration

Evaluating ERP systems to align accounting, inventory, and operations with live reporting. Coordinating API data flows and payment gateway reconciliation across all branches and delivery platforms.

📍

Platform & Google Business Management

Managing Google Business Profiles across all 3 branches. Optimising delivery platform listings on HungerStation, Keeta, Ninja, and Jahez — aligned with ongoing menu engineering and pricing strategy.

💡

Offer Strategy & Pricing

Designing offer timetables for dining and takeaway promotions. Building combo bundles based on margin analysis. Evaluating promotional impact on AOV, food cost, and platform GP before any campaign launches.

📱

WhatsApp API Automation

Managing Meta WhatsApp Business API integration — setting up message templates, tracking customer engagement through loyalty program data, and automating personalised reminders based on stamp collection patterns.

Projects

Selected Analytical Projects

Dashboards and tools built across tourism, education, and AI — the same data-first thinking applied across industries.

Tourism Analysis Dashboard

Interactive analytics dashboard visualising KPIs including tourist arrivals, hotel occupancy, and revenue trends. SQL-integrated for real-time reporting with advanced Power BI visuals for tourism board decision-making.

Power BISQLExcel

College Academic & Placement Dashboard

Combined academic and placement data with BRD-designed filters. Mapped placement trends by CGPA across Wipro, TCS and others — enabling targeted student intervention at scale.

Power BIPythonPandasJupyter

School Performance & Failure Insights

Analysed 18,000+ students' data to identify failure rates by subject, gender, and board type. Drill-down dashboards exposed curriculum hotspots and performed Root Cause Analysis for school management.

Power BIPythonExcelRCA

LLM-Based Resume Optimizer

GPT-powered tool to align resumes with job descriptions and improve ATS relevance. Built keyword extraction logic and side-by-side prompt-based analysis for early-career professionals.

GPTPrompt EngineeringPythonExcel

Experience

Professional History

Ongoing
2025–Present

Data Analyst / Business Analyst

Emboss Burgers — Multi-Outlet, Tabuk, Saudi Arabia

Built end-to-end data intelligence across 3 branches — Power BI models, hourly P&L reporting, full multi-branch P&L, food cost analysis, channel growth, morning window profitability
Grew total revenue from SAR 208K to SAR 883K monthly (314%) in 6 months through menu engineering, delivery strategy, and data-driven pricing
Designed complete P&L model per branch in Arabic and English — covering all revenue, food cost, prime cost, operating expenses, rent, marketing, net profit
Built and deployed digital loyalty program (Emboss Circle) with cloud database, admin dashboard, and WhatsApp Business API automation
Recognised by Keeta (FutureTable) for outstanding delivery sales growth achieved through data strategy

2024–2025

Python Programming Instructor

Malik's Institute

Delivered Core Python, Advanced Python (OOP, multithreading, DB connectivity) and Data Science with Python
Designed practical exercises and real-world problem-solving scenarios for industry readiness

2024–2025

Data Analyst

Sharath Tech

Enterprise dashboards across tourism, education, recruitment using Power BI, SQL, Excel
Root Cause Analysis with Python and Excel · EDA and A/B Testing to optimise decisions

2019–2020

Event Manager

Origin Events

Coordinated 15+ corporate & cultural events for MNCs — scheduling, vendor management, resource planning and billing

Education & Certifications

B.Tech in Information Technology — JNTU Hyderabad · 2019–2024

Google Cybersecurity Professional Certificate — Coursera

Python Full Stack Developer — Naresh i Technologies

Power BI for Data Analytics

Python for Data Science

Contact

Let's Work Together

Looking for a Data & Business Analyst who understands both the numbers and the operations behind them? Available for full-time roles, freelance projects, and consulting engagements.

Currently based in Tabuk, Saudi Arabia. Open to remote and on-site opportunities across KSA and internationally.

✉

Emailmohdfaraz744@gmail.com

📱

WhatsApp · Saudi Arabia+966 511 952 563

📱

WhatsApp · India+91 880 100 2721

LinkedInfaraz-mohammed-b5362a317

Where Data MeetsDecision — AndRevenue Follows.

Analyst. Architect.Business IntelligencePartner.

How I Grew a Multi-Branch Restaurant Group by 314% in 6 Months.

Hourly Operations Report — Estimated Contribution Profit Per Hour

Menu Engineering & Product Intelligence

Delivery Platform P&L — Revenue to True Profit, Step by Step

New Product Cost & Profit Analysis — Before Every Launch

Food Cost Breakdown — By Channel, Branch & Category

Monthly KPI Comparison Report — Same-Period, All Channels

Channel Growth Analysis — Identifying Structural Business Shifts

Morning Window Profitability — Validating Extended Operating Hours

Food Cost Analysis — Item-Level Excess Identification & Combo Attachment

Full Monthly P&L — Complete Financial Picture Across All Branches

Emboss Circle — Digital Loyalty Program Designed & Built In-House

Multi-Branch Daily Competition System — Driving Upsell Behaviour with Data

What I Build, Every Single Day

Selected Analytical Projects

Professional History

Let's Work Together

Where Data Meets
Decision — And
Revenue Follows.

Analyst. Architect.
Business Intelligence
Partner.