Hi There
I'm John Schoeni, a professional in the analytics space with a background in business, economics, and marketing. I've primarily spent my time in marketing and data analytics, where I've learned the art of business with the technicality of data.
Much of my work has been spent around these two main areas in combination. However, I've taken on other projects that enter the space of process building and lean thinking. This has driven me to build skills around driving action from data. It's one thing to see the insights, but it's another to act on them and create change.
One thing I enjoy the most is creating tangible results. Either at the bottom line or in the processes KPI's. This drives me every day with the work I do. From work in marketing, sales, business intelligence, or process improvement, I love to have a hard goal that I can hit.
My Background
My education comes from the University of North Carolina at Charlotte. Here I graduated Cum Laude with a BSBA in Business Administration. My major focus was marketing and a minor in economics. I participated in the UNC Charlotte chapter of Global Business Brigades, where I served roles such as Vice President. This organization was focused on educating rural communities in Central America and Africa in basic aspects of business. The goal in mind was to help set up a local economy for the town/village. This organization helped give me a new experience with a different perspective.
In my school studies, I learned many concepts in the marketing and economic space. This includes branding, retail operations, B2C marketing, intermediate economic theory, and econometrics, to name a few. My favorite theme throughout my learning was business strategy and how they compete. I was fascinated with the tactics and methods used to build a competitive advantage in the place these companies play. These learnings stuck with me past school and into my current work today.
Since my graduation, I have been in the workplace for over two years. Mainly, I have worked for a large B2B manufacturing company. Here, I have had the opportunity to work in various spaces. This includes channel marketing, communications, creative design, process consulting, and data analytics.
Technical Capabilities
In my work experience, I've developed experience with multiple platforms for marketing and analytics-related work. Below I'll list out these platforms along with some of the work I've performed.
Google Cloud Platform and SQL - I've used GCP and SQL for about a year. Mainly writing SQL queries in Big Query to pull data into dataflow for Tableau.
Alteryx and Tableau Prep - I've used both platforms for about a year. I have an intermediate skill level with both platforms.
Tableau Desktop - I've used Tableau for over a year. I have an intermediate skill level, building multiple high-visibility dashboards for the business.
Python - I've had Python experience for about two years. I mainly use Python for data preparation (Pands and GeoPandas) and REST API pulls.
Marketo - I have over two years of experience in Marketo. For previous roles, I used Marketo for sending out high-visibility emails. More recently, I've worked with Marketo data for analytical purposes.
Adobe Creative Suite - I have over three years of experience here. Mainly with Photoshop and Lightroom. But I have also used Dreamweaver and InDesign.
Beyond Work
Outside of my work, I enjoy spending time with Madison, my girlfriend, and our three pets. I also love to get outside whenever I can. We currently live in the Charlotte Metro area. I grew up in this area and have enjoyed seeing the city grow and flourish. Some of my hobbies include kayaking, boating, hiking, biking, woodworking, and content creation. Particularly, I love to talk about all the places I love in the area on Just Chillin Outdoors. This is my personal blog, where I feature many of the great natural areas around Charlotte.
