Hi! I'm Michael McGee, a passionate Data Analyst eager to drive business insights and strategic decisions through data analysis.

Tenured restaurant manager transitioning to data analysis, skilled in Python, R, SQL, Tableau, and Excel. Certified in various data analysis courses, ready to apply my skills to deliver actionable business insights.

Portfolio

Watershed Rental Analysis

Watershed Properties Analysis

Conducted an in-depth real estate analysis to assess the potential financial impact of converting long-term rental properties into short-term rentals. Provided strategic recommendations for optimizing cash flow and profitability based on a $500,000 initial CAPEX budget.

View Project

CoT Report Viewer

CoT Report Viewer

Developed a dynamic and customizable table to analyze 30 years of historical derivatives data from the Commodity Futures Trading Commission (CFTC), making it user-friendly and easily accessible for financial analysts and market enthusiasts.

View Project

World Bank Demographic Dashboard

World Bank Demographic Dashboard

Created an interactive global demographics dashboard to visualize and analyze demographic data from the World Bank, covering 217 countries from 1960 to 2021.

View Project

BRFSS Research Analysis

Behavioral Risk Factor Surveillance System

Analyzed data from the Behavioral Risk Factor Surveillance System (BRFSS) to answer key research questions related to health practices and risk behaviors. The study was conducted by the CDC in 2013 across all US states, the District of Columbia, Puerto Rico, and Guam, involving approximately 490,000 participants.

View Project

IMDb Rating MLR

IMDb Rating MLR

Conducted a comprehensive multiple linear regression analysis to predict IMDb movie ratings based on various features, providing insights into factors that influence movie popularity and ratings.

View Project

About Me

Tenured restaurant manager with years of experience in leadership, developing cost analysis programs, tracking guest satisfaction, and analyzing business financials. Skilled in utilizing data from POS and inventory systems to create detailed reports. Recognized for meticulous attention to detail and the ability to manage complex projects. Certified in various data analysis courses and eager to apply my skills to drive business insights and strategic decisions.

Certifications

  • Google Advanced Data Analytics | Google - Machine Learning, Statistical Modeling, Python
  • Google Data Analytics | Google - EDA, Data Visualizations, Excel, SQL, R
  • Data Analysis with R | Duke University - Statistical Analysis, Hypothesis Testing, R
  • Data Visualization & Dashboarding with R | Johns Hopkins University - Interactive Dashboards, R

Education

  • Bachelor of Science in Forensic Investigations | Keiser University, Miami, FL - May 2017
  • Associate of Science in Crime Scene Technology | Keiser University, Miami, FL - July 2015

Experience

Talk of the Town Restaurant Group | December 2018 – May 2020
  • Executive Chef: Trained management in inventory control and portioning, created a company-wide recipe and menu costing program. Conducted precise inventory analysis to maintain targeted food costs, utilizing data to drive operational decisions.
  • Beverage Manager: Coordinated staff training with local wine representatives, analyzed sales data to optimize inventory and enhance profit margins. Implemented data-driven strategies to improve guest relationships and staff performance.
Smokey Bones Bar & Fire Grill | April 2015 – October 2018
  • General Manager: Reconciled monthly P/L statements, identifying areas for financial improvement through detailed data analysis. Scheduled maintenance and inspections based on data trends to minimize operational disruptions. Implemented cleaning schedules and trained staff on new menu items, driving weekly alcohol variances from 8% to 1% using data monitoring and staff feedback. Communicated all food cost control efforts as well as labor cost control action plans. Conducted weekly food cost inventory. Managed all weekly food purchase orders. Created a local sales marketing team, increasing revenues by targeting businesses using sales data to identify key opportunities.