Derek T.

Media Analyst Iii @Progressive Insurance

Cleveland, OH, US

Plan and schedule terrestrial radio, broadcast, syndicated TV, working with media buyers and traffic coordinator using Excel, SQL,and Snowflake to ensure accurate execution and resolve scheduling conflicts. Collaborate with marketing, control, management, and the creative agency to coordinate, report, and communicate rotations, andspot airings to stakeholders. Manage media consumption reporting using MRI-Simmons survey data to inform traditional media buys, estimating businesscustomer segment habits to optimize strategy. Develop and publish industry benchmarking reports using iSpot data to estimate share of voice (SOV) on linear TV, analyzingcompetitor rotations, spend, and impressions. Streamline planning and reporting workflows across OTT, radio, broadcast, and syndicated TV using Tableau, Excel, SQL,Snowflake, and Alteryx. Designed and executed a terrestrial radio test across six states, analyzing state-level quoting projections, listener demographics, andpricing factors to determine test and control states, then validating execution through station logs and quoting behavior.

Columbus State Community College

No Degree, College Credit Plus

Ohio University

Bachelor's degree, Marketing, Business Analytics

Teays Valley High School

Valedictorian, Honor's Diploma