Data Analyst Analytics

MARC MCGRAW – DATA ANALYST

Dallas-Fort Worth Metroplex, TX 469-***-**** adwi62@r.postjobfree.com Linkedin Portfolio SUMMARY

Data analyst with a Master of Science in Advanced Data Analytics and recent graduate of the Thinkful Data Analytics Immersion Program. Proficiency with dashboarding, performance tracking, Pandas, Excel, SQL, Tableau, and Python to transform data into meaningful and easily understood visualizations and presentations. TECHNICAL SKILLS

Software: Microsoft Excel, Python, Tableau, SQL, PostgreSQL, Microsoft PowerPoint Data Methods: Statistical analysis, data visualization, presentation design, data cleaning, data discovery, data exploration, data modeling, A/B testing, t-tests, quantitative methods, big data technology, advanced data mining, exploratory data analysis, unsupervised algorithms, supervised non-linear algorithms, supervised linear algorithms, large data visualization, data harvesting, data structures, algorithm evaluation. Additional Skills: Project management, business strategy, business intelligence, report generation DATA ANALYTICS EXPERIENCE

Hemispheres Internet Remote

Data Analyst 10/2022 – Present

● Helped explore new products by analyzing their data sources for insight into the type of informational visualization products that would be useful to clients and potentially brought to market.

Data sources include:

■ Web log csv files

■ Excel spreadsheets

■ Customer data stored in relational databases

■ Public APIs

Analytics activities include:

■ Data cleaning

■ Data enrichment

■ Data visualizations

EDUCATION

University of North Texas, Toulouse Graduate School Plano, TX Master of Science, Advanced Data Analytics 12/2021 GPA 3.5

UNT Large Data Visualization Final Project

● A demonstration consisting of several data stories involving relationships by type and strength using SPSS, a large dataset of crime statistics using Tableau, a sales and profit dataset using Tableau and an analysis of NFL team draft performance. UNT Deep Learning Final Project

● Demonstrates building, training and testing a convolutional neural network on a CIFAR-10 dataset using TensorFlow.

UNT Harvesting, Storing, and Retrieving Data Final Project

● Demonstrates the execution of a deep learning process using SPARQ SQL and Hadoop big data technologies on the Google Cloud Platform.

UNT Analytics Capstone Experience Final Project

● A social demographic analysis of NFL anthem protests and their impact on sentiments of various demographics ranging from political backgrounds to occupational backgrounds. University of North Texas, G. Brint Ryan College of Business Plano, TX Bachelor of Business Administration in Entrepreneurship 12/2018 EDUCATION - Continued

Google Remote

Data Analytics Certificate 03/2023

● Gained an more immersive understanding of the practices and processes used by data analysts

● Expanded my understanding of how to clean and organize data for analysis, and completed analysis and calculations using spreadsheets, SQL and R programming

● Expanded upon my understanding of how to visualize and present data findings in dashboards, presentations and commonly used visualization platforms such as Tableau Thinkful Remote

Data Analytics Immersion Certificate 01/2023

● 390 hours of intense instruction focused on producing and presenting professional projects and presentations from concept to completion that focus on business forecasting, price modeling, and statistical analysis.

● Produced professional projects from concept to completion including:

Business Strategy Analysis - Revenue Growth Models - Lariat Rent-A-Car Link

■ Examined and cleaned historical sales data using Excel (VLookUp, pivot tables and t-tests).

■ Completed exploratory data analysis to identify strategic scenarios to increase revenue, assessed by KPI performance.

■ Presented models that showcased a 9.8% increase in profits, while lowering or maintaining operational costs.

Business Strategy Analysis - Revenue Growth Models - Housing Prices Analysis Link

■ Examined and tested multiple viable hypotheses to determine the biggest factors that drive sales price.

■ Completed exploratory data analysis to identify strategic scenarios to maximize sale price in houses, assessed by performance.

■ Presented t Test models that showcased the impact these parameters had on sales price, and provided recommendations for future housing plans and residential developments in order to ensure the highest and most consistent profits

Social Analysis - Marketing Growth Model - Anthem Protests Analysis Link

■ Examined and cleaned NFL anthem protest data using Python (Pandas, Numpy, Scipy, tTest_Ind)

■ Completed exploratory data analysis to identify strategic scenarios to determine ideal NFL customer profiles, assessed by survey data.

■ Presented T-tests and histograms that showcased the target customer base derived from the results and provided recommendations to steer marketing strategy within different demographics.

PCS Global Tech Remote

Relational Database Management Training 06/2022

● 200+ hours of intense training in conceptual, logical and physical database modeling, SQL, DDL and DML in SQL Server

PROFESSIONAL EXPERIENCE

Wingstop Frisco, TX

Manager 10/2021 – 04/2022

● Supervised and coordinated shifts for up to 10 people at once while managing day-to-day operations.

● Count drawers and safe, assign bags and totals for both deposits and cash drawers the following day.

● Managed inventory, customer relations, and cost controls. Scotty P's Hamburgers McKinney, TX

Supervisor 02/2021 – 09/2021

● Supervised and coordinated shifts for up to 10 people at once while managing day-to-day operations.

● Managed inventory, marketing, customer relations, and cost controls by balancing shift times

Contact this candidate