Available for consulting

WaelFrashy

Senior Data & Business Analyst

6+ years turning raw enterprise data into strategic decisions — across maritime logistics, FMCG, retail, and government. Power BI architect, ETL engineer, and AI automation builder working across the MENA region.

Let's work together See my work ↓
Wael Frashy
0+
Years experience
0+
Companies
0+
BI Dashboards
0+
Automations built
What I do

Core expertise

Full-stack analytics capability — from raw data ingestion and cloud infrastructure to executive-level insights and AI-powered automation.

📊
Data Visualization
Advanced Power BI dashboards across Finance, Sales, Ops, and Freight. ETL-connected, live, and built for decision-making at executive level.
⚙️
Data Engineering & ETL
Robust pipelines from ERP systems (SAP, D365, Odoo) into unified analytical models. SQL Views, CTEs, Python wrangling, and data quality frameworks.
🤖
AI & ML Automation
Document processing, predictive forecasting, AI chatbots, and custom clearance agents built on Power Automate, Copilot Studio, and Python.
☁️
Cloud Platforms
Azure Data Lake, Databricks, and Synapse Analytics for scalable warehousing. Spark-based big data processing and medallion architecture design.
🌍
Regional Experience
Delivered projects for NEOM, ZATCA, Beirut Airport, Sallaum Lines, and Baja Food — spanning government, logistics, FMCG, and finance sectors.
👥
Team Leadership
Leading and mentoring data analyst teams — assigning workstreams, reviewing deliverables, and aligning data outputs to business strategy.
Portfolio

Some of the BI reports I've built

End-to-end Power BI solutions across industries — from data modelling to live executive dashboards with automated refresh cycles.

TOTAL REVENUE $2.4M ↑ 12.4% NET PROFIT $386K Jan May Sep Dec Rev Trend
Finance Report
P&L dashboard with revenue vs expense tracking, budget variance, cash flow analysis, receivables aging by customer bucket, and rolling KPIs by department and period.
P&LBudget VarianceCash FlowReceivablesAging Report
TOTAL SALES 1,247 ↑ 8.2% vs last month Won 62%
Sales Report
Deal pipeline tracking, win/loss analysis, sales rep performance, quota attainment, and revenue forecasting by region and product line.
PipelineWin RateForecasting
STOCK LEVELS — 5 SKU GROUPS Reorder Raw Mat. 78% Finished 39% Packaging 84% WIP 29% MRO 65% On Hand Reserved Incoming
Inventory Report
Stock level monitoring with reorder alerts, slow-moving SKU analysis, warehouse utilization, and turn rate optimization across storage locations.
Stock LevelsReorder AlertsTurnover Rate
OPERATIONAL KPIs 76% OEE Efficiency 94% UPTIME Availability 97.9% QUALITY Pass Rate
Operations Report
OEE, uptime, quality pass rates, and downtime root cause analysis. Shift-level breakdown and maintenance scheduling insights.
OEEDowntimeQuality Control
PRODUCTION SCHEDULE — WK 12 Mon Tue Wed Thu Fri Line A Batch 001 — DONE Line B Batch 002 IN PROG Line C Batch 003 — SCHED QC QC CHK Maint. PM
Production Report
Production order tracking, Gantt-style schedule views, batch output vs target, WIP status, and machine utilization across production lines.
GanttBatch TrackingWIP
CAMPAIGN FUNNEL — Q1 2025 Impressions 125K Clicks 8.4K 6.7% Leads 1.2K 14% Conv. 28% 340 ROAS 4.2×
Marketing Report
Campaign funnel analytics with ROAS, conversion rate tracking, channel attribution, and customer acquisition cost breakdown across media types.
FunnelROASAttribution
BEY RTM SGP HOU JED SYD ACTIVE VESSELS 24 AVG TRANSIT 18.3d ON-TIME % 91.2% ROUTES 7
Freight Report
RoRo fleet tracking with port dwell analysis, transit time benchmarking, voyage profitability, and cargo manifest reporting for Sallaum Lines routes.
Fleet TrackingVoyage P&LPort Dwell
HOSPITAL OPERATIONS — Q1 2025 BED OCC. 87% AVG LOS 4.2d ER WAIT 22 min PATIENT SAT. 94.1% DEPT CAPACITY ICU 84% Surgery 62% ER 98% Pharmacy 71% Readmission rate: 3.2%
Hospital Operations Report
End-to-end hospital KPI dashboard — bed occupancy by department, average length of stay, ER wait times, patient satisfaction scores, surgery scheduling efficiency, and pharmacy stock levels.
Bed OccupancyER Wait TimePatient FlowLOS Analysis
AI & Power Platform

Automation solutions

End-to-end intelligent automation — connecting documents, data, and decisions with AI agents built on Power Platform and Azure.

PDF/Doc OCR Azure Doc Intel Extract Parse Invoice # 2041 Vendor Baja Amount $14K Date Mar 24 Structured D365 ERP Validate & Route
Document Processing Flow
Automated ingestion of invoices, bills of lading, and purchase orders. AI extracts, validates, and routes structured data directly into ERP — eliminating manual data entry.
Azure Doc Intelligence Power Automate D365 Integration
FORM Name... Amount... Category... Date... Submit Power Automate Dynamics 365 ERP Entry Created SharePoint Row Logged Email Approval Manager Notified Teams Alert Error → Retry
Data Entry Flow
Replaces manual data entry with intelligent forms that simultaneously update ERP, log to SharePoint, trigger approval emails, and notify teams — with full error handling and audit trail.
Power Automate Power Apps SharePoint Teams Integration
DataBot What's Q3 revenue? Q3 Revenue: $892K ↑ 14% Top product? Product A — $241K Ask your data... Copilot Studio Power BI Dataset Revenue $892K Margin 18.4% Live Data Query
Chatbot Linked to Power BI
Natural language chatbot that queries live Power BI datasets — users ask business questions in plain language and get instant data-backed answers, charts, and KPI summaries.
Copilot Studio Power BI API NLP Queries Teams / Web
INPUT DOCUMENTS INVOICE Invoice B/L Bill of Lading PACKING Packing List AI Clearance Agent Classify & Route ✓ HS Code Assigned ⚠ Flagged for Review → Duty Calc. Sent Customs Declaration Auto-Generated Filed with ZATCA / Port Authority System Processing time 4 min → 12 sec Accuracy rate 97.8%
Custom Clearance Agent
AI-powered agent that reads shipping documents (invoices, B/L, packing lists), classifies goods with HS codes, calculates duties, flags exceptions, and auto-generates customs declarations and port authority submission.
AI Agent HS Code Classification ZATCA Integration Power Automate
DATA SOURCES 📄 PDFs ✉ Emails 📊 Excel 🌐 Web 🗄 SQL DB Extraction Agent Clean STRUCTURED OUTPUT SKU QTY PRICE VENDOR A-1042 240 $14.50 Baja B-8831 55 $8.20 SMC C-0291 810 $2.10 Al-Tag D-5503 128 $31.00 NEOM · · · 2,847 rows extracted → Loaded to Power BI
Data Extraction Agent
Intelligent agent that connects to disparate sources (PDFs, emails, Excel files, web pages, databases), extracts relevant fields, normalizes the schema, and loads clean structured data directly into Power BI or SQL — fully automated.
Python Agent Power BI API Multi-source ETL LLM Extraction
Technical stack

Skills & tools

Full-stack data analyst capability — querying raw enterprise data through to deploying AI-powered automation in production environments.

Visualization & Reporting
Power BIDAXPower Query (M) Excel AdvancedPower PivotTableau
Data Engineering
SQL (T-SQL)PythonETL Design PandasNumPyApache Spark
Cloud & Infrastructure
Azure Data LakeAzure Databricks Microsoft FabricPower AutomateAzure Synapse
ERP & AI
Dynamics 365Business Central Copilot StudioLLM APIsscikit-learn
Power BI
SQL
Python
Azure
Databricks
Business Central
Excel
Tableau
Dynamics 365
Apache Spark
ML
Power Automate
Track record

Companies I've worked with

Government, maritime logistics, FMCG, retail, and finance — delivering data infrastructure across the MENA region and globally.

Let's talk

Have a data
challenge?

Whether you need a Power BI overhaul, an AI automation pipeline, or a full data strategy — reach out and let's figure it out together.

🌐
waelfrashy.com
💼
Open to consulting & freelance projects