Excel & Operations Reporting Specialist | Dashboards, Data Analysis & Automation
I help businesses organize their data, improve reporting and simplify operations with professional Excel solutions. I build interactive dashboards and KPI reports, inventory and stock trackers, cash and bank reconciliations, data cleaning, and automated reports using advanced formulas, PivotTables and Power Query. I bring 9+ years of hands-on experience in inventory control, cash management and logistics. I'm currently Inventory Control Manager at a leading payments company in Lebanon, and I previously worked with clients like UNICEF, UNHCR, Spinneys and Carrefour. That means I understand the real operations behind the numbers, not just the spreadsheet. My focus is accurate, practical and easy-to-use tools that save time and support better decisions.

Interactive Excel dashboard tracking cash flow across a 30-branch retail network. Select a date range and all KPIs, rankings and charts update automatically: transactions, cash in/out, net cash, fees, top & bottom branches, denomination mix, hourly peaks, daily trend and monthly growth. Includes a damaged-notes report with an auto-generated executive summary. Built with SUMIFS, INDEX/MATCH, SUMPRODUCT, conditional formatting and 11 charts. Sample data for confidentiality.

Excel inventory system for a 60-SKU warehouse. Stock levels update automatically from an IN/OUT transaction log. Each item gets a colour-coded status (OK / Reorder / Out of Stock), days of cover and a suggested order quantity. A dashboard shows stock value, top sellers with margins, category breakdown and monthly movement, and the purchase list builds itself, sorted by urgency. Built with SUMIFS, INDEX/MATCH, data validation and conditional formatting. Sample data.

Shift-level reconciliation for a 6-branch supermarket chain (34 registers, 68 cashiers). It matches POS sales against counted cash and card terminal settlements, then classifies every shift as Balanced, Short or Over. A dashboard with branch filter shows variances by branch and cashier, flags high-risk cashiers, and builds an investigation list automatically. Tolerance and threshold are adjustable. Built with SUMIFS, INDEX/MATCH, data validation and conditional formatting. Sample data.

Turning a messy raw export into a clean, report-ready table. Removed duplicate records, unified mixed date formats, standardised names and branch spellings, converted text amounts ("950 USD", "1,200.5") into real numbers, cleared errors and blank rows, and put every phone number in one format. The result is ready for PivotTables, dashboards or importing into another system. Sample data.
0
وظائف منجزة
التقييم
0
التقييمات (0)
$15
بالساعة