Khaled Mohamed Flayh

Khaled Mohamed Flayh

Data Analyst
Egypt
English, Arabic
Full-time On-site

About Me

Data Analyst and hypermarket Inventory Controller (about 50,000 items across 82 departments) with hands-on experience in store management, inventory control, purchasing coordination, and the full document cycle (purchase…

Experience

Inventory Controller

Arab Down Town · Port Said , Port Said , Egypt
Dec 2025 - Present · 11 months

<p>Run continuous cycle counts and surprise stock counts across 82 departments and about 50,000 items to verify actual balances.</p><p> Reconcile physical stock against system (book) balances, and investigate shortages and overages and their causes: unrecorded department withdrawals, point-of-sale quantity errors on look-alike items, and wrong scale item codes.</p><p> Record transfers between departments (for example, cheese issued from grocery to bakery for production) to keep every department's balances accurate.</p><p> Calculate production costs for manufactured items from their ingredients (for example, a pâté from flour, water and cheese) for each producing department (poultry, bakery, grocery, cheese processing).</p><p> Record wastage, monitor its cost, and compare it with previous periods.</p><p> Convert promotional bundle codes into single-unit item codes when an offer is broken, so stock stays accurate.</p><p> Handle the full document cycle: purchase requests and orders, goods receipt, goods issue, returns, and damage records; validate goods receipt and issue documents.</p><p> Prepare regular inventory reports (stock balance, movement, aging), track reorder levels, and coordinate with purchasing and sales to ensure product availability.</p>

Operations Manager and Cashier

Fun Group · Port Said , Port Said , Egypt
Mar 2019 - Present · 7 years 8 months

<p>Oversee day-to-day operations of the kids' area, ensuring a safe, clean, and welcoming environment.</p><p> Recruit, hire, train, and supervise staff for the kids' area.</p><p> Enforce safety standards at the highest level to protect children and staff.</p><p> Handle cash, receive customers, and process financial transactions as cashier.</p><p> Run the monthly closing of payroll and rent payments.</p>

Storekeeper

Happiness Store · Port Said , Port Said , Egypt
Sep 2025 - Oct 2025 · 30 days

<p>Ensured product quality and freshness for candy and snacks.</p><p> Managed packaging and labeling of goods according to store standards.</p><p> Oversaw receiving, storing, and issuing of inventory.</p><p> Conducted regular stock checks and maintained accurate inventory records.</p>

Skills

Excel Pivot Tables Power BI SQL Server Python pandas NumPy Matplotlib Seaborn Data Visualization Statistics Inventory Control Stock Counts Reconciliation Reorder Level Tracking Cycle Counting Wastage Control Shrinkage Control Production Costing Inter-Department Transfers Purchasing Coordination Goods Receipt Goods Issue Stock Aging Reports Inventory Costing Inventory Valuation ABC Analysis Purchase-to-Sale Document Cycle Shopify ShopifyQL Analytical Thinking Problem Solving Communication Performance Management Leadership Cash Handling Payroll Hiring Team Supervision Power Query T-SQL Stored Procedures
Report this Profile?