Brett Oakes
Analyst
ABOUT ME
Hello! My name is Brett Oakes and I currently reside in Des Moines, Iowa. I'm an experienced Treasury and Data Analyst with a Master of Science in Applied Business Analytics. I enjoy the challenges that come with being an analyst and finding new and exciting things through model development, data visualization, and analysis.
I also have a Master of Business Administration from Jacksonville University and a Bachelor of Business Administration in Marketing from the University of North Florida. I have several years in analytics, management experience in hospitality as well as logistics, retail, and entrepreneurship. I'm currently looking for a full-time opportunity in Des Moines, IA or remote.
EXPERIENCE
Treasury Analyst II
2021-2022
American Enterprise Group
Utilized Power BI and R to identify and recommended multiple changes to the company’s banking services resulting in a 6% reduction in fees for 2022. Utilized a cash flow analysis that provided a weekly forecast of inflows and outflows for the company. Automated regularly occurring tasks and reports in excel that resulted in saving 10+ hours of labor a month.
Assistant General Manager
2017-2020
Drury Hotels
Analyzed guest surveys in R and Tableau to find opportunities of improvement in quality and service. Utilized data mining techniques to identified trends. Managed the daily operations of the hotel including housekeeping, front desk, food & beverage, and maintenance.
Food & Beverage/
Convention Services Supervisor
2016-2017
Marriott International
Managed the setup, tear down, planning, and organization of 10-20 events per week including trade shows, weddings, corporate meetings dinners, and more. Events ranged from 25 to 2,000 people. Maintained a 100% even service score in 2017 by focusing on providing exceptional customer service, emphasized planning and communication among departments and the client's needs.
National Sales Representative
2015-2016
​
Anderson Trucking Service
Designed a pricing strategy by forecasting demand for ground transportation and analyzing seasonal demand trends. Number one salesperson for the first three months of employment with ATS in 2015. Obtained a $1.5 million contract by focusing on the client’s needs and recommending solutions to transportation problems.
EDUCATION
Master of Science in
Applied Business Analytics
2019-2020
​
Jacksonville University
Relevant Coursework:
-
Introduction to Applied Business Analytics
-
Applied Statistical Modeling and Analysis
-
Applied Data Visualization and Analysis
-
Data Mining and Predictive Analytics
-
Management of Analytical Projects
-
Applied Managerial Analytics
-
Applied Data Management
Master of Business Administration
2014-2015
​
Jacksonville University
Bachelor of Business
Administration in Marketing
2010-2014
​
University of North Florida
​
PROJECT EXAMPLES
Florida COVID-19 Tracking
Tableau Dashboard created to track COVID-19 testing, hospitalization, and deaths in the State of Florida compared to the United States. Dataset provided by covidtracking.com. Please message me if you would like a copy of the workbook.
Predict health insurance costs
based on the individual's profile
Analyzed information about members to determine the variables that would result in higher medical costs. This included items such as an individual's age, sex, BMI, number of children, if they're a smoker, a region of the United States, and historical changes.
Drury Hotel Guest Surveys
Analyzed surveys for Drury Hotels to find areas of improvement in quality and service. Identified common problems through data mining from guest surveys such as room cleanliness and F&B quality issues. Discovered a bias in survey scores from Drury Reward Members vs first time guests trying out the brand for the first time. Please message me if you would like a copy of the workbook.
Forecasting Corn Yield
with Machine Learning
Developed a model in R to forecast corn yield. Utilized public data from NOAA and USDA such as precipitation, planting progress, temperature, palmer drought index, historical yield data, and more. Was able to obtain an R-value of 0.96 by utilizing a multiple linear regression model.
Loan Default Predictions
Utilized financial data to develop a model to predict whether a loan will default based on FICO scores, debt to income ratio, and more. Generated data visualizations in RStudio to report my findings. Utilized an SVM, Naive Bayes, and Random Forest Model with a 99% specificity and 85% accuracy.
*This is a multi-project assignment combined into one document.
Property Management Database
in Oracle SQL Developer
Created a database in Oracle SQL developer for a property management company. Set constraints based on the data provided and performed several SQL queries.
*Click on any of the icons to download the file