Hesham Sameer

Hesham Sameer

Planning Analyst
United Arab Emirates
English, Arabic

About Me

Data Analyst & Reporting Specialist with 5 years of success in transforming complex data into strategic business insights. Proven ability to design and implement automated reporting systems and interactive dashboards tha…

Experience

Planning Data Analyst, Reporting Specialist

Clipsico Pack · Alexandria, Egypt
Aug 2023 - Nov 2025 · 2 years 3 months

I worked as a Data Analyst at Clipsico Pack, where I played a key role in steering the company toward smarter, data-driven decisions.I created in-depth analytical reports that led to a 44% improvement in overall operational efficiency compared to the period before implementing my reports. This included consistent quarterly growth in production, more effective inventory management, and aligning the marketing team with clear, data-backed objectives.My responsibilities also involved forecasting company purchases using historical data trends, producing regular quality reports to ensure compliance with product standards, and evaluating supplier performance to enhance supply chain quality.By translating data into actionable insights, I empowered various departments to make informed decisions that drove measurable growth and operational excellence.

Planning Data Analyst, Reporting Specialist

Clipsico Pack
Jan 2023 - Jan 2025 · 2 years

Analyzed planning data to uncover patterns and trends, leading to a 15% improvement in resource utilization and workflow planning.
Shared complex results in a simple format, helping non-technical teams make faster and more accurate planning decisions improved by 20%.

Operations Data Analyst, Reporting Specialist

Al-Andalus Wealth Group · Alexandria, Egypt
Jan 2021 - Aug 2023 · 2 years 7 months

I worked as a Reporting and Data Analysis Specialist at Al-Andalus Wealth Company, where I enhanced my skills in data analysis and data-driven decision-making, which broadened my perspective on leveraging data within industrial companies.I developed accurate analytical reports that contributed to a 18% increase in production efficiency and a 33% reduction in stagnant inventory by providing clear insights to management on market trends and performance metrics.

Operations Data Analyst, Reporting Specialist

Al-Andalus Wealth Group
Jan 2021 - Jan 2023 · 2 years

Supported daily production operations with focused data analysis and reporting.
Helped improve output consistency and informed better production decisions.

PROJECTS

Yearly Production Report

Duration : 01-Dec-2024 - 01-Jan-2025

I created a detailed report for an industrial company, based on the client’s request for a comprehensive overview of all items processed on production lines between January 1 and December 31, 2024.The items were categorized into groups, and the report was structured to include:• Total monthly production per category, with quarterly summaries.• Total monthly production per item, also aggregated by quarter.• Monthly production percentage relative to the yearly total.• Final yearly totals per category and per item.The project was executed using Power Query and advanced Excel formulas to ensure accuracy, clarity, and actionable insights for data-driven production decisions.

Customer Analysis

Duration : 01-Dec-2024 - 01-Jan-2025

I developed a production report and data analysis for an industrial company, focusing on merging, cleansing, and processing data from two production lines using Power Query and data cleaning techniques to ensure accuracy and data quality.The report includes sales analysis by main product categories distributed across the customer base, featuring key metrics such as:Sales per main category for each customer.Detailed sales of each item per customer.Total item sales per customer.Calculating the percentage contribution of each customer to total sales.Aggregation and analysis of sales data for precise customer allocation.A consolidated report presenting overall totals to provide a comprehensive view supporting data-driven decision making.The report was designed using advanced data analysis tools to deliver in-depth insights and interactive data visualization, facilitating better understanding of sales performance and identifying growth opportunities.

Certifications

Master Microsoft Office 365 and Power Platform

Microsoft · Redmond, USA · 2025

Google Data Analytics

Google · California, USA · 2024

Microsoft Power BI Data Analyst

Microsoft · Redmond, USA · 2024

Data Analysis Challenger Track

Udacity · Acton, Canada · 2023

Excel Skills for Business

Macquarie University · Ajax, Canada · 2023

Google Digital Marketing

Google Digital Academy (Skillshop) · California, USA · 2023

Skills

Structured Query Language (SQL) Problem Solving Business Intelligence Data Modeling Effective Communication Time Management Teamwork Power BI Data Tools & Technologies: Excel Python (Basic) Data Analysis & Preparation: Data Extraction Data Transformation Data Cleaning Data Organization and Formatting Reporting & BI: Dashboards Trend Analysis and Insights KPI Reporting Reporting Automation Business & Domain Knowledge: Marketing Fundamentals Operations Planning Production Reporting Soft Skills: Understanding Business Needs Critical Thinking Self-Learning and Continuous Development Excel Python Data Extraction Dashboards Trend Analysis Insights Marketing Fundamentals Self-Learning Continuous Development HTML CSS
Report this Profile?