Mohamed Abdella

Mohamed Abdella

Data Analyst/ Business Analyst
Egypt
German, Arabic, English

About Me

Data Analyst/ Business Analyst

Experience

Financial Controller

Lord pastry
Mar 2023 - Present · 3 years 4 months

1. **Cost of Goods Sold (COGS) Analysis:** Evaluate the cost components of pastry production, identifying areas for cost optimization while maintaining quality standards.

2. **Profit Margins:** Monitor and analyze profit margins on pastry products, implementing strategies to enhance profitability through pricing or cost efficiency.

3. **Ingredient Cost Management:** Efficiently manage the procurement and pricing of ingredients, negotiating with suppliers to control costs and maintain product quality.

4. **Sales Forecasting:** Develop accurate sales forecasts for pastry products, considering seasonality and market trends to optimize production and inventory levels.

5. **Menu Pricing Strategy:** Devise pricing strategies for pastry items, balancing competitive pricing with profitability to maximize revenue.

6. **Inventory Management:** Implement effective inventory control measures to minimize waste, ensuring optimal stock levels and freshness of pastry products.

7. **Market Trends Analysis:** Stay abreast of pastry industry trends, introducing innovative products or adapting recipes to meet changing consumer preferences.

8. **Cost-Benefit Analysis for New Products:** Conduct thorough financial assessments for the introduction of new pastry products, considering production costs, market demand, and potential revenue.

9. **Supplier Relationship Management:** Build strong relationships with key suppliers to secure favorable terms, discounts, and ensure a consistent and high-quality supply of ingredients.

10. **Compliance with Food Safety Standards:** Ensure compliance with food safety regulations, implementing and monitoring processes to maintain the highest standards of product safety and quality

Senior Financial Analyst and Cost Controller

Lord Pastry | Port Said, Egypt
Mar 2023 - Present · 3 years 4 months

Monitor and analyze profit margins on pastry products, implementing strategies to enhance profitability through pricing or cost efficiency.
Evaluate the cost components, identifying areas for cost optimization while maintaining quality standards.
Develop accurate sales forecasts for pastry products, considering seasonality and market trends to optimize production and inventory levels.
Conduct thorough financial assessments for introduction of new pastry products, considering costs, market demand, and potential revenue.

BI & Business Analyst

Cocacola | Port Said, Egypt
Jan 2020 - Dec 2022 · 2 years 11 months

Created and maintained data visualizations that educated, informed, and engaged business on key metrics and performance measures.
Interfaced with 100+ users to deliver results per their needs, standards, and deadlines.
Converted 300+ reports from SAP Reports into SSRS.
Identified and recommended process improvements that boosted sales by 25% in Port said depot year 2021.
Implemented necessary changes that successfully decreased coordination time with sales team by 40% after the system rolled out in 2020.

Junior statistician & Sales Support Specialist

Cocacola | Port Said, Egypt
May 2015 - Jan 2020 · 4 years 8 months

Handled vendor invoices, verifying coding, reconciling purchase orders and documenting approvals in Sharepoint.
Organized and updated file systems, keeping records easily retrievable.
Enhanced presentations and reports of sales and KPI's.

Supply chain coordinator

Cocacola | Port Said, Egypt
Oct 2012 - May 2015 · 2 years 7 months

Ensure that internal and external clients are served well.
Responsible for ensuring operations of the daily routine work to be carried out.
Provide cost-efficient and comprehensive solutions to lapses in company acquisitions or orders.

Senior Sales Representative

Cocacola | Port Said, Egypt
Sep 2010 - Oct 2012 · 2 years 1 month

Collaborated cross-functionally to ensure seamless product launches and promotions.
Utilized strong negotiations skills to secure favorable deals and partnerships.
Conducted thorough market analysis to identify growth opportunities and trends.

Skills

Budget Development General Ledger Accounting Generally Accepted Accounting Principles (GAAP) QuickBooks Sage Workers' Compensation Law Excel VLOOKUP Conditional Formatting Pivot Tables Power BI DAX Power Query API Tableau Python Pandas NumPy SciPy Matplotlib R programming dplyr ggplot tidyverse SQL SQL Server MySQL PostgreSQL Web scrapping Quick Typing on Keyboard Data visualization Trend analysis KPI monitoring Regression analysis Machine learning
Report this Profile?