Open to opportunities

mazen mohsen

@mazenmohsen1

Senior Merchandise & Data Analyst improving retail performance with sales analysis, inventory optimization, forecasting, and BI dashboards.

Egypt

Message

What I'm looking for

I’m looking for a role that blends data analysis with merchandising to drive sales growth. I want to own KPI tracking and dashboard reporting, strengthen demand forecasting and inventory optimization, and collaborate with teams to improve profitability and stock efficiency.

I’m a Senior Merchandise & Data Analyst with 7+ years across retail operations, merchandising, and data analysis. I combine sales analysis and data-driven decision making to turn business performance into actionable next steps.

In my current role as a Merchandise Planning & Data Analyst at COUP Cairo (Mar 2026–Present), I analyze sales, inventory, and product performance to support strategic business decisions. I develop dashboards and automated reports using Excel and Power BI, while monitoring KPIs to improve profitability and stock efficiency.

Previously, as a Store Manager at Mega Store (FRG, Skechers) (May 2024–Feb 2026), I led teams and managed large-scale retail operations by analyzing trends, inventory performance, and product movement. I also supported demand forecasting and inventory planning, collaborated cross-functionally on stock allocation and replenishment, and helped teams strengthen sales techniques and product knowledge.

Experience

Work history, roles, and key accomplishments

Current

Merchandise Planning & Data Analyst

Current

COUP Cairo

Mar 2026 - Present (4 months)

Analyzed sales, inventory, and product performance data to support strategic business decisions. Developed dashboards and automated reports using Excel and Power BI, monitored KPIs, and supported demand forecasting and inventory planning.

Sales Analysis Merchandising Planning Inventory Optimization Demand Forecasting KPI Tracking Excel Power BI

Store Manager

FRG

May 2024 - Feb 2026 (1 year 9 months)

Led team activities while managing retail operations, including analysis of sales trends, inventory performance, and product movement for merchandise planning decisions. Supported inventory optimization through stock allocation, replenishment planning, and product performance analysis using Excel, Power BI, and SQL.

Team Leadership Retail Operations Sales Analysis Inventory Optimization Replenishment Planning Reporting Excel Power BI SQL Product Merchandising KPI Tracking

Assistant Manager

ASTK

Jan 2023 - Jan 2024 (1 year)

Supported store management in a fast-paced fashion retail environment by training new hires and coaching staff to improve sales and product knowledge. Assisted with inventory follow-up, stock counts, sales reporting, and maintained visual merchandising standards.

Store Management Coaching Visual Merchandising Inventory Follow Up Stock Count Sales Reporting