Mahdi Shabanzadeh
Operations & Processes Business Analysis

Portfolio

Mahdi
Shabanzadeh

Operations & Business Analysis

Warwick Business School MSc graduate with experience across retail operations, manufacturing, business research and project coordination.

I use Excel, SQL and Power BI to investigate performance, communicate findings and explore practical process improvements. I’m seeking Operations Analyst, Business Operations Analyst and related roles in the UK, particularly London.

Selected projects

Operational and commercial questions explored through independent case studies and academic analysis.

Transactions analysed
500K+
E-commerce project
Structured market queries
500+
Guiide research
Providers benchmarked
15+
Guiide research
Quantitative Methods
90%
MSc module mark

01 · In development

Operations Efficiency & Stock Flow Analysis

Zara | Independent Operational Improvement Case Study

Process mapping Planned: Excel · Power BI

Examining how delivery processing, stockroom organisation, picking and replenishment compete for available time and capacity, and how workload allocation could support stock flow.

Independent case study informed by first-hand workflow observations. This is not an official Zara project and contains no confidential company data. Scenario-based data and quantitative analysis are still in development.

Read the case-study scope

Operational problem

Retail teams coordinate delivery receipt, stock processing, storage, stock movement and replenishment as trading demand changes. This study investigates whether alternative workload timing and resource allocation could support replenishment without disrupting other work.

High-level process

  1. Delivery receipt
  2. Processing
  3. Storage
  4. Picking
  5. Replenishment
  6. Shop floor

Observed workflows

The working process map draws on my first-hand account of retail tasks and staff moving between activities. It provides context, rather than a measured assessment of store performance.

Assumptions and planned analysis

Task times, demand and available capacity still need to be defined for an independently developed scenario dataset. Planned measures include units processed per labour hour, request-to-ready time, picking time, backlog, workload by activity and processing capacity. These measures have not yet been calculated.

Findings and modelled results

No quantitative findings or modelled improvement results are available yet. The relationship between workload timing and replenishment delays remains a hypothesis to test.

Proposed scenarios

Compare earlier completion of eligible stock-movement tasks and workload-responsive resource allocation, holding total labour hours constant. Stock zoning and replenishment prioritisation are possible secondary investigations, not established causes of inefficiency.

Recommendations

Recommendations will follow the scenario comparison, including any trade-offs or cases where the current approach remains preferable. No operational changes or achieved productivity gains are claimed.

02 · Independent Portfolio Project

E-Commerce Commercial Performance Analysis

SQL Excel Power BI

Analysed more than 500,000 transaction records to explore revenue, customer behaviour, product performance and geographical trends.

SQL supported transactional analysis, with Excel and Power BI used to organise and communicate performance. An interactive Power BI dashboard presented customer segments, repeat purchasing and revenue concentration.

Business questions and output

Which customers, products and markets account for revenue? How does repeat purchasing vary across customer segments? Where is revenue concentrated?

The dashboard brings these patterns together to support commercial discussion. This independent portfolio analysis does not claim implemented recommendations or realised revenue gains.

03 · Academic project · Warwick Business School

Weather & Online Shopping Analysis

R ggplot2 ARIMA

Investigated how weather and commercial events relate to online consumer demand, using a dataset of more than 2,600 observations. Analysis in R combined visual exploration with ARIMA modelling.

The project demonstrates statistical analysis and interpretation. Relationships in the data do not establish causation or verified business impact.

My story

My background combines operational experience, business analysis and project coordination. I began in architectural project delivery, working with schedules, suppliers, budgets and stakeholders, before completing an MSc in International Business at Warwick Business School.

Since then, I have worked across fintech research, manufacturing and retail operations. These settings have developed my interest in how organisations coordinate workflows, allocate resources and assess performance. They have also shown me why useful analysis needs to account for the practical constraints people face in their daily work.

I now focus on using Excel, SQL and Power BI to understand operational and commercial performance, investigate inefficiencies and communicate findings clearly. Through my portfolio, I am building on hands-on experience with structured analysis and process documentation, with the aim of supporting practical, evidence-based business decisions.

Professional experience

Experience across operational settings

July 2026 – Present

Operations & Sales Assistant

Zara · Birmingham & London, UK

  • Support back-of-house operations, including stock processing, stock checks, replenishment and product movement between stockrooms and the shop floor.
  • Help maintain product availability by responding to replenishment demand and organising stock during high-volume trading periods.
  • Work within a fast-paced retail environment where workload, stock flow and operational priorities change throughout the day.
  • Coordinate with operations managers and shop-floor colleagues to support efficient daily store activity and customer demand.
  • Developed practical insight into stock-flow bottlenecks, workload allocation and replenishment processes, informing an independent operations case study.
June – July 2026

Manufacturing Operations Assistant

Parker Hannifin · Royal Leamington Spa, UK

  • Supported the assembly and production of hydraulic hose products within a structured manufacturing environment.
  • Followed production schedules, quality requirements and health and safety procedures during day-to-day operations.
  • Completed production documentation and supported accurate recording of manufacturing activity.
  • Worked across rotating shifts and coordinated with production colleagues to maintain workflow and output requirements.
June – October 2025

Research & Research Analyst

Guiide · UK fintech

  • Conducted structured research comparing AI tools and their potential applications within a financial-services context.
  • Completed more than 500 AI queries and reviewed 15+ providers to identify differences in capability, reliability and suitability.
  • Identified three key capability gaps and translated findings into practical recommendations.
  • Contributed to a 35+ page research report covering use cases, limitations, KPI considerations and potential ROI frameworks.
  • Presented complex findings in a structured format to support business evaluation and decision-making.
2021 – 2024

Architecture & Junior Architect (Project Coordination)

Sarv Group · Iran

  • Coordinated design documentation and supported project delivery across architectural and construction activities.
  • Worked with contractors, suppliers and internal stakeholders to resolve site issues and maintain project progress.
  • Supported quality-control activities through site inspections and review of construction work against design requirements.
  • Contributed to cost and material planning, including work that supported an estimated 10% reduction in material use.
  • Helped monitor project schedules and coordinate activities across multiple stakeholders, contributing to approximately 95% on-time delivery.

What I do

Operations & Process Improvement

Understanding how work moves through an organisation, identifying potential bottlenecks and analysing operational performance to support more efficient processes.

Process mapping · Workflow analysis · KPI analysis

Data & Performance Analysis

Using Excel, SQL and Power BI to structure data, analyse operational and commercial performance, and communicate findings through reports and dashboards.

Excel · SQL · Power BI

Business Analysis & Coordination

Translating business requirements into structured analysis, documentation and practical actions while coordinating with relevant stakeholders.

Requirements analysis · Process documentation · Project coordination

Skills

Developed through operational work, research, business analysis training and portfolio projects.

Professional focus

Operations & Improvement

  • Process mapping
  • Operational performance & KPI analysis
  • Root-cause & workflow analysis
  • Workflow optimisation & continuous improvement
  • Capacity & resource analysis

Analytical toolkit

Analytics

  • SQL
  • Excel
  • Power BI
  • Power Automate
  • Python — foundational

Supporting capability

Business Analysis

  • Requirements analysis
  • Stakeholder management
  • UAT
  • Agile & Kanban
  • Business case development
  • Commercial analysis
  • Presentation

Education

Academic foundation

MSc International Business

Warwick Business School · Merit

2024 – 2025

BSc Architectural Engineering

Islamic Azad University, Central Tehran Branch

2019 – 2024

Contact

Let’s discuss an opportunity

I’m interested in analytical operations roles and practical projects with startups and small businesses, particularly those involving commercial reporting, process documentation or operational performance.

View the CV currently on my website (PDF) ↗