Summary
Overview
Work History
Education
Skills
Timeline
Generic

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

undefined

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

Similar Profiles

CREATE PROFILE
Mostafa HassanBusiness Data Analyst