Data Analyst

About

Highly skilled professional transitioning from a 20-year career in video editing to a Data Analyst role. Known for translating creative visions into engaging content, handling diverse projects honed a strong analytical mindset, exceptional attention to detail, and sharp problem-solving abilities - essential for turning complex data into clear, actionable insights. Eager to leverage technical expertise and project management skills to deliver meaningful visualizations, and data-driven decisions.

Resume PDF

Tableau Portfolio

Education

Boston Univeristy: Bachelor of Science in Film Production (1999-2003)

Certificates

Google Data Analytics Certificate 2025 (Google - Coursera)

Google Advanced Data Analytics Certificate 2025 (Google - Coursera)

Learn SQL Basics for Data Science Specialization 2025 (University of California, Davis - Coursera)

Data Visualization with Tableau Specialization 2025 (University of California, Davis - Coursera)

Skills

• Speadsheets: Excel, Google Sheets
• Coding: SQL, Python (Pandas, Numpy), R
• Visualization: Tableau, Looker
• Advanced proficiency in the Adobe Creative Suite
• Visual Design

• Video Editing

• Strong analytical and problem-solving skills
• Excellent communication skills

• Project management and team collaboration

• Exploratory Analysis
• Descriptive statistics
• Machine Learning
• Regression Analysis
• Statistical Hypothesis Testing

Data Analytics Projects

• FBI Hate Crime Analysis

  Data Source: FBI Crime Data Explorer - Hate Crime in the United States

  Dataset (Clean): Hate Crime

  Goal: Discover trends and/or correlations between the offenders, the offenses, and when they occured.

  Tools: SQL, Tableau

  Code: SQL Script

  Visualizations: Coming Soon

• TSA Claims Analysis

  Data Source: TSA Claims Database

  Dataset (Clean): TSA Claims

  Goal: Identifiy claim patterns that can improve efficiency and financial solvency.

  Tools: Excel, Tableau

  Visualizations: TSA Claims 2000-2015 Dashboard

• Operating Room Efficiency Study

  Data Source: 2022 Q1 OR Utilization

  Dataset (Clean): OR Utilization Q1

  Goal: Find operating room scheduling inefficiences and any root causes.

  Tools: Google Sheets, SQL, Tableau

  Code: SQL Script

  Visualizations: Operating Room Utilization Dashboard

• 120 Years of the Olympics

  Data Source: 120 Years of Olympic History

  Datasets: Athlete Events, Host NOC, NOC Regions

  Goal: For the Learn SQL Basics for Data Science Certification, test hypotheses of whether (1) there is an advantage for athletes from the host country; (2) competing in multiple events affect outcomes; (3) there is a correlation between physical attributes and winning medals.

  Tools: SQL, Python

  Code: Phase 1, Phase 2, Phase 3

Video Editor Highlights

Video Editing Portfolio

• Rachael Ray for CBS
  • Promoted from Assistant Editor to Editor after 3 seasons
  • During 6 seasons on the show, edited and helped deliver over 1,000 episodes
• Moving in 2008 and Dean Darling feature films for 19th Floor Productions
• People/EW Network Streaming Series & Shorts for Time
• International Champions Cup Branded Content for Vaynermedia
• Plus: Award-winning short films, many more hours of television, and compelling ad content
• Visit my video editing site for more info

Offline Activities

• Little Harbour School PTA: Treasurer for 3 years, Board Member for 5 years
• Temple Israel of Portsmouth: Membership Committee Co-Chair for 2+ years, Board Member for 3+ years (ongoing)
• Master of Tempo & Teamwork (aka Drummer)
• Photographer: Street, Documentary, Land/Sea-scape

Contact

• Email: dyellin13@gmail.com
• LinkedIn: @dovyellin
• Video Editing Portfolio: dovyellin.com