Basic Info

Ahmed GabAllah

Less than 1 year

Cairo, Egypt

Bachelor's Degree

Entry level

Work Experience

Happy Hat Frozen yogurt _ Increase Revenues & Restore Profitability at Egger Consulting (student activity)

Experience Details

Happy Hat Frozen yogurt _ Increase Revenues & Restore Profitability

Business Development, Analyst/Research

Student

Happy Hat, a U.S. national chain of frozen yogurt stores with about 500 stores in 40 states is asking for assistance with its business processes. The average number of visitors per store has held constant over the past several years, but revenues per store are down by an average of 10%, and many stores are no longer profitable. The client suspects that a large amount of inventory is being thrown away unused at the end of each day. At the same time, customer polling suggests that the yogurt flavor customers want is often not available, even when the flavor is posted on the menu. People also complain about stores being closed when they visit. Now, the chain is facing increased competition from frozen yogurt sold in 24-hour grocery stores. Happy Hat has asked your team to recommend business process changes that can help them increase revenues and restore profitability.

Happy Hat currently has the following data available:

- 4 years of cash register data for every store that has, for each transaction, the date and time of the purchase, the specific items purchased, and the sales price of each item purchased.
- 4 years of delivery data that lists how much of each kind of yogurt mix, flavoring, and topping was delivered to each store each week.
- Typical public company accounting data, including annual revenues, annual cost of goods sold, in-store inventory on hand at the end of the year.

No other company data is available.

As a business analyst at Egger Consulting, you will need to identify one business metric that could be extracted from the available data in the Happy Hat case study in order to suggest a business process change that could be related to improving Happy Hat’s revenue or store profitability.


Company Details

Egger Consulting (student activity)

United States

N/A

May 2017 to Jul 2017 (2 months)

Education

Aeronautical Engineering in Aeronautical Engineering

Education Details

Aeronautical Engineering

Aeronautical Engineering

institute of aviation engineering and technology, Egypt

C / Good / 65 - 75%

N/A

N/A

institute of aviation engineering and technology
2012 - 2016

Certifications

TOEFL
Nov 2016

Certificate details

TOEFL

Nov 2016

563 out of 677

https://drive.google.com/file/d/0B5c3LXaRZpJ1QVNiVVBlNTZ4Y2c/view?usp=sharing

1600232

AMIDEAST

N/A

Certificate details

Data Science Math Skills

Jun 2017

N/A

https://www.coursera.org/account/accomplishments/certificate/PN4UX34358JX

N4UX34358JX

Duke University

N/A

ICDL
Aug 2012

Certificate details

ICDL

Aug 2012

N/A

https://drive.google.com/file/d/0B5c3LXaRZpJ1em1qc0ZuZ2xsU3c/view?usp=sharing

N/A

N/A

Certificate details

Business Metrics for Data-Driven Companies

Jul 2017

N/A

https://www.coursera.org/account/accomplishments/certificate/NGVT6YNT7ZWJ

GVT6YNT7ZWJ

Coursera

N/A

Training and Courses

Training/Course Details

Data Science Math Skills

Jun 2017

Duke University

Data Science Math Skills introduces the core math that data science is built upon, with no extra complexity, introducing unfamiliar ideas and math symbols one-at-a-time. Learners who complete this course will master the vocabulary, notation, concepts, and algebra rules that all data scientists must know before moving on to more advanced material. Topics include: ~Set theory, including Venn diagrams ~Properties of the real number line ~Interval notation and algebra with inequalities ~Uses for summation and Sigma notation ~Math on the Cartesian (x,y) plane, slope and distance formulas ~Graphing and describing functions and their inverses on the x-y plane, ~The concept of instantaneous rate of change and tangent lines to a curve ~Exponents, logarithms, and the natural log function. ~Probability theory, including Bayes’ theorem.

Training/Course Details

Excel to MySQL: Analytic Techniques for Business Specialization

Jul 2017

Duke University

In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process. The Capstone Project focuses on optimizing revenues from residential property, and Airbnb, our Capstone’s official Sponsor, provided input on the project design. Airbnb is the world’s largest marketplace connecting property-owner hosts with travelers to facilitate short-term rental transactions. The top 10 Capstone completers each year will have the opportunity to present their work directly to senior data scientists at Airbnb live for feedback and discussion.

This profile is fresh!
Last update 1 days ago.

Jobseeker photo

Profile Skills and Keywords

Aeronautical EngineeringAnalyticalArabicBig DataBusinessBusiness AnalysisBusiness Data AnalysisBusiness Metrics For Data-Driven CompaniesData ScienceData Science Math SkillsEnglishExcel To MySQL: Analytic Techniques For Business SpecializationHappy Hat Frozen Yogurt _ Increase Revenues & Restore ProfitabilityICDLMatlabMicrosoft ExcelMicrosoft OfficeMySQLPlannerProblem SolverProgrammingPythonResearchSQLSocialTOEFLTableauTeam Player

Self-assesed Skills

Languages

English

English

: Fluent

: Fluent

: Fluent

: Fluent

Arabic

Arabic

: Fluent

: Fluent

: Fluent

: Fluent

Tools and Technologies

Microsoft Excel

Microsoft Excel

: Expert

: Extreme - I love it!

:

5-7 years

SQL

SQL

: Expert

: Extreme - I love it!

:

Less than 1 year

MySQL

MySQL

: Expert

: Extreme - I love it!

:

Less than 1 year

Tableau

Tableau

: Expert

: Extreme - I love it!

:

Less than 1 year

Matlab

Matlab

: Expert

: Extreme - I love it!

:

3-5 years

Python

Python

: Expert

: Extreme - I love it!

:

Less than 1 year

Microsoft Office

Microsoft Office

: Expert

: Extreme - I love it!

:

5-7 years

Fields of Expertise

Matlab

Matlab

: Expert

: Extreme - I love it!

:

3-5 years

Python

Python

: Expert

: Extreme - I love it!

:

Less than 1 year

Microsoft Office

Microsoft Office

: Expert

: Extreme - I love it!

:

5-7 years

Microsoft Excel

Microsoft Excel

: Expert

: Extreme - I love it!

:

5-7 years

Business Data Analysis

Business Data Analysis

: Expert

: Extreme - I love it!

:

Less than 1 year

Business Analysis

Business Analysis

: Expert

: Extreme - I love it!

:

Less than 1 year

SQL

SQL

: Expert

: Extreme - I love it!

:

Less than 1 year

MySQL

MySQL

: Expert

: Extreme - I love it!

:

Less than 1 year

Tableau

Tableau

: Expert

: Extreme - I love it!

:

Less than 1 year

Key Skills

Analytical, Planner, Problem Solver, Social, Team Player

Online Presence

https://www.linkedin.com/in/ahmed-gab-allah

I’m looking for work, please share my profile…

Get Your own Wuzzuf Profile Now !

Employer? If you're representing an organization or an enterprise, Signup here for FREE to see Ahmed's full profile and find more great talent and professionals to join your team.