Mostafa Hassan
Business Data Analyst
Columbus,OH
Summary
Solutions-driven and experienced business analyst with 5+ of experience boosting company profitability. Seeking opportunities to use analytical skills and strong people management skills to create cost-effective solutions and improve efficiency.
Overview
5
5
years of professional experience
3
3
years of post-secondary education
2
2
Languages
Work History
Business Data Analyst
Charleys Philly Steaks & Bibibop - HQ
Columbus, OH
10.2018 - 04.2022
- Collects data and researches information with a high attention to detail from internal and external sources using special techniques and tools
- Cleans and analyzes data and information using MS Excel and SQL for a variety of reports
- Conducts data mining and statistical analysis using the data exported from the corporate business systems and compiles the information for different departments as needed
- Creates and develops weekly, monthly, and quarterly reports about business performance for the company's executives to assist them in decision making
- Gained comprehensive knowledge of MS Excel in a business environment such as, but not limited to, the creation of developing macros for the team's monthly and quarterly reports
- After just 2 months, was placed in charge of analyzing the company’s delivery performance and keeping track of the delivery sales on a weekly basis; one of the company's biggest goals for 2019
- Completes special projects and ad hoc requests, such as performing in-depth analyses of third party delivery vendors available in the market and increasing our revenue by 20% by conducting business with them
- Worked with the IT team on the company's new system to validate the data to be accessible for the whole company later on
- Conducts market and industry research while having the opportunity to suggest and work on projects/analyses of my own design
Cataloging Student Assistant
Ohio State University
Columbus, OH
05.2017 - 08.2017
- Utilized, updated, and created records for Arabic books by using OCLC's WorldCat online database throughout the three months
- Translated written material from English to Arabic and vice versa while ensuring that the translated version conveys the meaning of the original one
- Searched the database to successfully edit and/or input bibliographic records in Arabic and
- English as I was also responsible for interpreting them
- Revised database records and facilitated new descriptive catalog records primarily in literature
Data Analyst Intern
High Trading for Imports and Exports Co. LTD
Cairo
12.2016 - 03.2017
- Collected data by using a scripting language (SQL) to analyze and display them to my supervisor
- Explored and analyzed datasets with programs like Python and R and reported the results back to the relevant members of the business
- Collaborated with leaders and supervisors to determine and address data and reporting needs for various company projects
- Participated in gathering, understanding, and documenting detailed business import and export reports using PostgreSQL database
- Used Excel formulas to aggregate data to create meaningful reports as well as representing them visually using pivot charts
- Located and defined new process with the management to prioritize business and information needs to cut unnecessary costs.
Treasury Intern
Nissan Motors Egypt S.A.E
Cairo
05.2016 - 08.2016
- Worked on a team to find solutions and ideas to generate foreign currency after the shortage of USD in the market due to devaluating the local currency to meet ongoing operational requirements such as importing the needed body parts to close market deals
- Contributed in assessing the company's cash flow by anticipating its incoming cash and outgoing commitments
- Trained to use Oracle Database to input cash forecasting and cash positioning information
- Responded to audit inquiries, made calls to the bank directly to clarify adjustments or to clarify items on the bank statements in order to reconcile activity or properly code it multiple times
- Created, prepared, and printed suppliers' invoices and checks from Excel to give to their respective representatives
Financial Institution Intern
Commercial International Bank of Egypt
Cairo
06.2015 - 08.2015
- Praised for successfully answering and responding graciously to the clients’ requests on a regular basis throughout the internship
- Granted unlimited access to all prime corporate and business banking clients after showing diligence and outstanding dependability
- Maintained client confidence and protected operations by keeping information confidential
- Assigned by the team members to do real life buying and selling for the clients in the stock market; a sign of mutual trust and support
Sales and Marketing Intern
High Trading for Imports and Exports Co. LTD
Cairo
05.2014 - 07.2014
- Participated closely with a team in analyzing and designing distinctive sales and marketing plans on a daily basis throughout the internship
- Charged to use Excel to update, edit, and keep track of the company's inventory to know what the company has and needs to respond to customer needs quickly
- Analyzed the market to get a better perspective of the market needs in order to assist the company in increasing its revenues
- Supported the team in setting up and presenting number of sales exhibition to the board
- Professional Development
Education
Bachelor of Arts - Economics
Ohio State University
08.2014 - 08.2017
Skills
MS Excel - 7 years of experience in entering and editing data, writing formulas with pointand-click method, creating calculations with Excel functions, creating pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables, designing, recording, and executing macros to automate data entry inputs
Structured Query Language (SQL) - 3 years of experience in writing code to interact with tables, joining multiple tables together from a relational database, and summarizing data from multiple tables in a database
PostgreSQL Database - 9 months of experience in inserting and manipulating data, writing SQL statements, extracting data from multiple tables, and writing queries using various aggregate functions
MS Power Point - 4 years of experience in designing slides and applying animation effects, design powerpoint slideshows from start to finish and building tables in powerpoint and manipulating them
Python - 4 months of experience in exploring Python language fundamentals, including basic syntax, variables, types, and customize plots on real data
R -2 months of experience in using the program and computing statistical functions and exploratory data analysis
Data Analytical - 5 years of experience in solving problems, using clear, logical steps and excellent judgment to understand an issue from all angles before executing an action
Research - 4 years of experience in the ability to recognize and the need for, locate and credible information relevant to the question in hand
Power BI - 2 years of creating interactive dashboard to analyze and present data to help the company make important decisions
Timeline
Business Data Analyst
Charleys Philly Steaks & Bibibop - HQ
10.2018 - 04.2022
Cataloging Student Assistant
Ohio State University
05.2017 - 08.2017
Data Analyst Intern
High Trading for Imports and Exports Co. LTD
12.2016 - 03.2017
Treasury Intern
Nissan Motors Egypt S.A.E
05.2016 - 08.2016
Financial Institution Intern
Commercial International Bank of Egypt
06.2015 - 08.2015
Bachelor of Arts - Economics
Ohio State University
08.2014 - 08.2017
Sales and Marketing Intern
High Trading for Imports and Exports Co. LTD
05.2014 - 07.2014