Analyst | Engineer


About Me

I'm a data analyst working in influencer marketing, always engaged in a variety of different projects. My work has spanned across various segments of daily life including packaging, retail, finance, travel, digital media, and more.


I automate and optimize processes every day. Using Python, SQL, Excel, Tableau, and similar tools, I explore data to find actionable insights. I’ve written programs to transform and clean data so that it’s ready for analysis, and I've written programs to generate regular reports. I also routinely create dashboards for displaying information and organizing findings.


I live in Tampa Bay, Florida with my beautiful wife, our wonderful children, and our two dogs. But you won’t always find me there because we absolutely love to travel! I learn something new every day, and I'm excited to see where the world of analytics and marketing innovation will take me.


Want to know more... Reach out!


Skills & Tools

Python

Data analysis, process automation, and misc script programming/personal projects

Proficiency: Advanced

Git

Version control for both business and personal projects using Git as well as GitHub

Proficiency: Intermediate

VB / VBA

Process automation and report generation, as well as various personal projects

Proficiency: Advanced

SQL

Database handling: creation, usage, manipulation, and maintenance

Proficiency: Intermediate

HTML / CSS

Professional web development as well as personal site maintenance

Proficiency: Intermediate

Tableau / Looker Studio

Interactive data visualization and trend/insight reporting

Proficiency: Intermediate

Portfolio

Portfolio 1

Reddit List Bot

Portfolio 2

Document Conversion

Portfolio 3

Warranty Database

Portfolio 4

Quote Generation

Portfolio 5

Wordle Solver

Portfolio 6

Portfolio Site

Portfolio 7

Serial Number Lookup

Portfolio 8

Hangman Solver

Portfolio 9

WFH Study

Portfolio 10

Project Scorecards

Portfolio 11

Baby Bottle Forecast

Portfolio 12

D&I Market Analysis

Resume/CV


EDUCATION

Master of Science in Industrial & Systems Engineering
College of Engineering, University of Florida
May 2018, GPA: 3.6/4.0

Bachelor of Science in Mechanical Engineering
College of Engineering, University of Florida
May 2015, GPA: 3.3/4.0


WORK EXPERIENCE

Analytics Lead
The Outloud Group, Apr 2022-Present
• Established Analytics department, including all data operations and reporting functionalities
• Managed Analytics personnel and created all documentation regarding best practices
• Introduced standardized reporting suite and kept all client reports current by automating data pulls from third party APIs (e.g. YouTube, Meta, TikTok)
• Developed conversion tracking system and proprietary scoring algorithm for evaluating media success based on both the content placement and the creator partnership as a whole
• Conducted in-depth granular analyses of individual media performances to identify factors correlated with success and produce predictive models
• Compiled quarterly industry reports, including vertical pricing and racial pay gap analyses
• Administered the organization's Salesforce database
• Raised organization's YouTube API quota to 550,000 per day (+5,400%) through negotiations with YouTube's Chief Of Staff
• Built bespoke Python module for the organization to facilitate processes involving internal logs, Salesforce, Google, Slack, and various media platforms
• Created a program to flag various opportunities (and potential concerns) by pinging relevant team members in Slack
• Conducted inventory analyses for retail clothing brand and created future order projections to drive restock decisions

Digital Data Consultant
Various, Mar 2020-Present
• Analyzed scientific, consumer, and survey data using Python and Tableau to find trends, explanations, and notable insights
• Created Tableau dashboards to display analysis results — dashboards were used for content marketing, inbound linking, and client web traffic improvement
• Audited client websites and related content — improved site navigation, developed copy, corrected miscellaneous page errors, revised documentation, etc.

Analyst, Advanced Analytics
Rakuten Advertising, Sep 2021-Apr 2022
• Developed and delivered analytics reports, presenting trends and insights directly to clients
• Analyzed budget allocation and spend for key clients in emerging affiliate verticals
• Built data programs and templates to automate report preparation for all clients across the global network using Python and VBA
• Managed the creation and deployment of digital tools to automate data handling and the execution of critical analytics processes

Business Analyst
(Previously Process Automation Engineer, Applications Engineer)
BW Packaging Systems, Jul 2016-Aug 2021

• Analyzed past project data to identify cost anomalies and amend pricing strategies for profitability — implemented improvements to prevent issues moving forward
• Automated quote creation and related pricing assessments using Python and VBA
• Improved warranty claim processing and response time ~70% by building database infrastructure and front end GUI for warranty claims using VBA and SQL
• Created a Python program for automatically analyzing external client files — distributed the functionality to management and engineering teams by constructing a Django site to serve it
• Automated project management and progress tracking through custom report dashboards
• Collected, transformed, and cleaned data to use for automation and analysis
• Tested clients' products and analyzed data for custom orders — average rate of 1.5 tests per month, 25% of which led to customer purchases
• Created master dashboard to organize and display all data related to past projects, spanning three separate product lines — used daily by engineering for quick reference
• Generated machine layouts and generated formal quotes for customers
• Supported the sales team with technical guidance
• Designed complex industrial filler and labeler systems for food/pharmaceutical products
• Designed components for Centritech centrifuge systems
• Overhauled existing designs to meet market price demands

Design Engineer
Bosch Packaging, May 2015-Jul 2016
• Designed comprehensive in-line and rotary packaging machines for various products/containers
• Created custom designs based on client specifications and material requirements
• Introduced entirely new assemblies to the product line
• Collaborated with other engineers and machinists to minimize cost and production time

Mechanical Engineer & Production Manager
SpinCore Technologies Inc, Nov 2013-May 2015
• Designed, manufactured, and assembled radio-frequency electronic product enclosures
• Managed quality control assessments, bills of materials, CAD, and vendor coordination
• Introduced/directed new projects and improved existing products
• Managed and coordinated customer orders with incoming/outgoing shipments
• Improved design output by optimizing workflow (reducing/eliminating tedious assembly work)

Resident Assistant
University of Florida, Aug 2013-May 2015
• Managed a large living-learning community of undergraduate engineers
• Planned/conducted engineering-related programs and activities to help students
• Maintained order and served as a resource for guiding residents to academic and personal success

Team Member/Food Service
Target, Jul 2009-Nov 2014
• Prepared and served food with exemplary customer service
• Monitored storage area temperatures to ensure high food quality
• Maintained a sanitary workspace in fast-paced environment