Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Dan Pavlu

Atlanta,GA

Summary

Detail-oriented data professional with knowledge in data cleaning, transformation, analysis, and visualization. Organized and dependable with a willingness to learn new skills and hone existing ones. Ability to handle multiple projects at a time with excellent communication skills.

Overview

2
2
years of professional experience

Work History

Dashboard Engineer

Fitzco
03.2023 - Current
  • Built data and reporting infrastructure for new client projects using SQL and Tableau to provide insights for their advertising campaign performance
  • Created interactive dashboard for Shipt that marketing team used to increase ROAS by 50% YoY
  • Utilized various advertising platforms to gather data for use in dashboards (Meta, TikTok, Google Ads, Snapchat, Impact Radius, among others)
  • Created tool in Python to stack campaign performance reports
  • Communicated regularly with executives to make sure all were aligned on dashboard visualizations, functionality, and timeline
  • Tools Used: Tableau, Looker, SQL Server, Python, Excel

Analyst, Customer Marketing

Inspire Brands
02.2022 - 03.2023
  • Established and owned reporting for Buffalo Wild Wings and Dunkin’ gift card programs, including quarterly fiscal reports for organization’s leadership team
  • Developed new metrics to better understand customer base and product offerings (Customer Segmentation, Seasonality, Clumpiness)
  • Analyzed effects of removing happy hour menu items from Arby’s locations and provided recommendations to marketing team based on results
  • Conducted initial research for new in store employee performance measurement tool
  • Maintained and made updates to customer database within Snowflake
  • Tools Used: Snowflake, Tableau, Datagrip, Excel, Jira

Education

Data Analytics Career Track -

Springboard School of Data
Remote
12.2021

Bachelor of Arts - Sports Management

Flagler College
St. Augustine, FL
04.2018

Skills

  • Tableau
  • Looker
  • Microsoft SQL Server
  • Snowflake
  • Python (Pandas, Numpy, Matplotlib)
  • Microsoft Excel

Projects

Predicting Medical Insurance Charges, https://public.tableau.com/shared/2ZPH2YCBF?:display_count=n&:origin=viz_share_link, Conducted analysis of insurance claim dataset with the goal of accurately predicting medical insurance charges based on a variety of variables including age, sex, BMI, and whether the policyholder was a smoker. 

King County Property Sales Analysis, https://public.tableau.com/app/profile/dan.pavlu/viz/shared/9B8JG9F3X, Conducted analysis of property data in the King County region of Washington with the goal of finding which variables have the highest correlation with price of properties and building a regression model in Python with those variables.

Timeline

Dashboard Engineer

Fitzco
03.2023 - Current

Analyst, Customer Marketing

Inspire Brands
02.2022 - 03.2023

Data Analytics Career Track -

Springboard School of Data

Bachelor of Arts - Sports Management

Flagler College
Dan Pavlu