Ahmed Ali Darwish
Giza, Egypt · Commercial Analyst

Where the business has a question, I build the answer.

Commercial analyst with a master data background, managing 30,000+ SKUs and building tools that make pricing and purchasing decisions faster and more accurate.

Commercial analyst with a master data and catalog background and hands-on experience in pricing intelligence, purchasing decision support, and supply & demand planning across B2B and B2C e-commerce. I manage a catalog of 30,000+ SKUs and build AI-assisted automation tools that improve data quality, cut manual work, and support data-driven pricing and purchasing decisions.

Pricing IntelligenceCommercial AnalysisSupply & Demand PlanningMaster Data & CatalogAutomation
Ahmed Ali Darwish professional portrait
Ahmed Ali DarwishCommercial Analysis · Master Data · Planning
Pricing IntelligenceHours → under 10 minpricing benchmark vs competitors
30,000+SKUs managed across B2B & B2C
Hours → <10 minpricing benchmark vs competitors
9business tools built & in use
30 min → batchOdoo SKU creation
About

From product data to pricing and planning decisions.

I started in master data — setting up and cleaning thousands of products across ERPs. Working that close to the catalog showed me where pricing and purchasing decisions were going wrong, so I moved closer to them.

Today I manage 30,000+ SKUs at MNT-Halan and work on pricing, purchasing support, and supply & demand planning — building the models and tools that make those calls faster and more accurate, together with Growth, Finance, Supply Chain, Marketing, and Tech.

01

Price

Competitor benchmarking, margin analysis, and supplier deal evaluation.

Competitors tracked automatically
02

Plan

Demand forecasts, run-rates, reorder quantities, and safety stock.

Daily safety-stock refresh for promos
03

Automate

Python, SQL, Excel, Power BI, and AI-assisted tools that remove manual work.

SKU setup: 30 min → batches in minutes
Selected work

Six systems built around real commercial problems.

Each one solves a real workflow at MNT-Halan. Screens use anonymized demo data.

01 · Pricing intelligence

Pricing Intelligence Model

Checking our prices against the market meant collecting competitor prices by hand — hours of work, often out of date by the time it was done.

  • Scrapes prices from top competitors automatically
  • Suggests prices using more than one method and shows where we stand vs. the market
  • Flags SKUs priced above market, and SKUs bought above competitors' selling price to trigger supplier negotiation
ImpactHours → under 10 minutes
PythonWeb ScrapingHTML / JS
02 · Purchasing decision support

Purchasing Intelligence Model

Buying decisions depended on many inputs at once — cost, selling price, margin target, deal terms, and market prices — and were easy to get wrong.

  • Tells the buyer whether to buy at all: Buy / Conditional / Hold / Review
  • Recommends the best supplier and buy price
  • Compares against the nearest competitor and market average, then suggests the selling price
ImpactA safeguard against wrong purchases
Decision LogicHTML / JSAI-assisted Dev
03 · Supply & demand planning

Replenishment Planner

Every morning the daily stock sheet had to be read line by line to decide what to order, from whom, and for which warehouse.

  • Upload the daily stock sheet and see every SKU flagged: order today, running low, safe, or dead stock
  • Suggests order quantity per warehouse for a chosen number of days of cover
  • Ranks vendors to call, flags OOS-with-demand and warehouse imbalances, and exports a ready PO per vendor
ImpactDaily stock sheet → vendor-ready orders in minutes
HTML / JSPlanningArabic / English
04 · Supply & demand planning

Dynamic Safety Stock & Promo Planning

Promo SKUs sold out before campaigns ended, or stock was locked away that could have been sold.

  • Uses current stock, run-rate history, warehouse, and campaign end date
  • Run-rate fallback: 7 → 15 → 30 → 90 days when data is thin
  • Refreshes daily and outputs upload-ready files
ImpactSelected SKUs stay available through campaigns
PlanningRun RateHTML / JS
05 · Master data automation

Odoo SKU Data Enrichment & Catalog Suite

Creating SKUs in Odoo was manual — about 30 minutes for every 10 products — and easy to get wrong.

  • Turns product barcodes into import-ready Odoo sheets
  • Maps brand, category, and ETA automatically, and reports issues before upload
  • Applies bulk status, classification, and visibility changes
Impact30 min / 10 SKUs → large batches in minutes
Odoo ERPMaster DataHTML / JS
06 · Internal commerce

Employee Offers Store

Staff offers were shared informally, with no clear catalog, no consistent prices, and no record of who ordered what.

  • A mobile-friendly store where MNT-Halan employees browse products by category at 50% off
  • Employees build their selection and confirm with name and phone — no minimum, pickup and cash at the warehouse
  • Orders reach the warehouse team in one place, with printable order summaries
ImpactEmployee offers run through one simple store
ReactSupabaseWeb AppArabic UI
More tools

Smaller builds that save time every week.

Commercial Dashboards

Power BI and custom HTML dashboards tracking sales, margin, and the commercial KPIs the business runs on.

Power BI · HTML

Volumetric Weight & Load Calculator

Calculates volumetric weight and vehicle load for bulky, lightweight SKUs — snacks, tissue, diapers — so oversized items are caught early.

Logistics · Excel

Internal Apps & AI Automation

Small internal tools and AI-assisted automations that remove manual work for business teams.

Automation · AI
Experience

Moving closer to business decisions.

From product-data operations to pricing, purchasing support, and planning.

MNT-Halan (Talabeyah)

B2B grocery e-commerce
Oct 2025 — Present

Supply & Demand Planning

Jul 2026 — Present

Demand forecasts, run-rates, reorder quantities, and safety stock; fast/slow movers, seasonality, and promotions; supplier pricing, margin, and deal evaluation; competitor price monitoring; commercial KPI dashboards.

Product Management Responsibilities

Dec 2025 — Present

Specify new features for the Tech team, translate commercial needs into system solutions, and build internal apps and AI-assisted automations.

Master Data & Catalog Specialist

Oct 2025 — Present

30,000+ SKUs across the Talabeyah and Halan Gomla platforms: product creation, taxonomy, and data quality across Odoo ERP, the in-house ERP, and internal product systems.

MNT-Halan (Halan Gomla)

Oct 2025 — Jun 2026

Master Data & Commercial Analysis — catalog and master data for the platform, plus day-to-day commercial analysis on product, pricing, and category data.

Operations Associate — Jumia Egypt

Jul — Dec 2022

Data accuracy across thousands of live listings, supporting searchability and conversion.

Sales & Operations — Darwish Sons (Family Wholesale Business)

2021 — Oct 2025

Wholesale operations: supplier negotiations, product selection, and commercial terms end to end.

Skills & education

What I work with.

Commercial & Planning

Pricing AnalysisCompetitor BenchmarkingMargin AnalysisSupplier Deal EvaluationDemand ForecastingSafety Stock & Reorder

Master Data & Systems

Master Data ManagementCatalog & TaxonomyData QualityOdoo ERPIn-house ERP

Data, BI & Automation

PythonWeb ScrapingSQLAdvanced ExcelPower BIHTML DashboardsAI-assisted Automation

Product & Collaboration

Product RequirementsCross-functional Coordination
EducationBachelor of Management Information SystemsPharaohs Academy · 2023
EducationAcademic Diploma in Computer ScienceCairo University · In progress
CertificationCS50: Introduction to Computer ScienceHarvard University
CertificationBasics of Pricing, Marketing SeriesUdemy · Dr. Ehab Mesallum
CertificationDigital Marketing & Content WritingCoursera
LanguagesArabic · EnglishNative · Professional working proficiency
Contact

Interested in data operations that actually improve decisions?

Open to Commercial Analysis, Master Data, and Supply & Demand Planning roles at Specialist / Analyst level.