Professional Work
Sales Dashboard
I created a dynamic sales dashboard for our ecommerce customer where they can view historic sales and compare fiscal years. In this Google Sheet they can change parameters to best fit what they are looking for. Data is updated every week and the dashboard is constantly changing based on customer needs. Feel free to open the sheet and play around with the parameters highlighted in yellow (Cells B1 & H1)
Custom Excel Grids
I create various customized Excel grids for my team in order to organize and track stock. This example tracks individual purchase orders of books coming into our warehouses before they are bunched together for our customer, what we call a “PPK” or pre-pack assortment. Feel free to download the example and see the formulas and formatting
Excel Macros
I’ve created several Excel macros for my team. This enables us to download reports and instantly format them to suit our needs. All of my macros are coded rather than recorded with actions in order to provide ease of editing and flexibility for later use. Take a look at the text file which includes my VBA code
Academic Work
CRM Academic Article Analysis
This article analysis is designed to demonstrate my ability to read and understand a complex, detailed academic article and then be able to analyze it from a business perspective. Through this, I hope to communicate my ability to write clearly, scholarly, and in a detailed fashion
Analytical paper on human resources and strategic management
In this paper I synthesize Human Resource and Strategic management theories with Christian church leadership. This was an attempt to understand business organization and leadership as applied to a non-business setting
target market project
I compared two phone companies in order to determine their strengths and weaknesses. Ultimately, I created a mock third company with a niche in the market based off of my observations. Through this project, I learned marketing strategies and how to analyze different companies
"West Lake lanes" Management case
The backbone of this particular management class was built around a case study where we analyzed a particular situation from a manager's viewpoint. The West Lake Lanes bowling alley was struggling to be profitable so students were tasked with identifying problems and creating solutions
"rosewood hotels" case
In this assignment, students analyzed the situation of a chain of hotels called the Rosewood Hotels. We were required to acknowledge the variables in the case, generate options based off of the costs and benefits, and choose a particular option based off of our analysis. In this write up, I demonstrate the importance of marketing strategy on a large scale for a large corporation
Human Resource Management Paper
In this paper, I explore an issue where a talented employee feels dissatisfied at his current job. According to the paper prompt, my goal was to apply theories and techniques in order to provide practical solutions to not only keep the employee happy, but also grow and improve
Digital Media Projects
Digital Strategy Whitepaper
Taking the different tools of digital strategy into account, I created a whitepaper which discusses the abilities and uses of digital media for marketing. It includes examples and best practices for marketing in the real world
Social Media Campagin
In this project, I was tasked with creating a social media campaign, for a company of my choice, to expand reach and interaction with customers. I used programs such as Hootsuite and Meltwater to listen and measure engagement, and then come up with a strategy to increase customer interaction
SEO Audit
Here, I looked at another company through the lens of SEO strategy. I analyzed a company and determined the strength of their current SEO strategy based off of their website. Through my knowledge of SEO, I was able to identify strengths and weaknesses, and therefore make recommendations
Slide Design
I believe in a clean, readable slide design which tells a story. The information on the screen should be enough to give the viewer a general idea, while the speaker supplies the details. While a confident speaker is important, the power of pictures and graphics also helps to empower viewers to understand better, and on multiple levels. Here are some samples of slides I have worked on in the past.
Custom Graphics
While I am not a graphic design artist, I do have an eye for aesthetic and am capable of creating graphics for flyers, banner ads, and other forms of advertisement. The majority of these graphics were created using Canva, a free-to-use graphic design software. Here are some samples of graphics I have made in the past.
Additional Academic Papers
Torrey paper
In this paper, I synthesize the works of two writers: The Apostle Paul (1 & 2 Corinthians and 1 & 2 Thessalonians) and Thomas Aquinas (The Summa Theologica). The goal of this paper is to demonstrate how Aquinas' three theological virtues complete Paul's vision for the Christian Church