John Behr
New York,NY
Overview
4
4
years of professional experience
Work History
Revenue Analyst
Disney
New York, NY
08.2023 - Current
- Spearhead the analysis of ABC Primetime, Latenight, and Specials advertiser revenue, providing strategic insights and tailored pricing solutions to maximize revenue, resulting in an improvement in revenue efficiency
- Optimize displacement and pro forma requests by collaborating with programming and finance teams, driving revenue growth and enhancing financial performance
- Coordinate with multiple departments to manage inventory loads, ensuring seamless operations and minimizing discrepancies by 15%
- Direct the creation of comprehensive weekly, monthly, quarterly, and yearly forecasts, enabling leadership to make informed decisions for future growth
- Revamped reporting structures, saving 3-4 hours per week and improving data accuracy
- Collaborate with ESPN, Hulu, and Disney+ teams for aligned forecasting, resulting in a 10% improvement in pacing accuracy
Data Analyst
Horizon Media Inc
New York, NY
08.2021 - 07.2023
- Developed advanced forecast models, enhancing forecast accuracy by 10% and improving future campaign performance predictions
- Architected an automated data infrastructure using Tableau, SQL, and KNIME, reducing manual work by 4 hours per week
- Deployed regression models to solve client challenges, resulting in an increase in client retention through strategic insights
- Executed A/B testing strategies, improving customer conversion rates and driving significant business results
- Led the monthly creative recap reporting process using Tableau, resulting in a 5% increase in customer engagement across multiple campaigns
Data Analyst
Willis Towers Watson
West Chester, PA
08.2020 - 08.2021
- Managed large, multi-dimensional datasets using advanced Excel functions, driving insights that informed high-level business decisions
- Collaborated with project managers and cross-functional teams to deliver in-depth analytics, applying advanced quantitative techniques
- Designed and implemented predictive models, resulting in more accurate forecasting and an increase in strategic decision-making for clients
- Streamlined data analysis processes, reducing time for data cleansing by 20%
Education
Master of Science - Applied Statistics
West Chester University
West Chester, PA04.2022
Bachelor of Science - Mathematics
Arcadia University
Glenside, PA05.2020
Skills
- Programming Languages: SQL, R, Python
- Data Visualization: Tableau, Advanced Excel, Google Analytics
- Statistical Modeling: Linear Regression, Logistic Regression, Predictive Modeling
- Product Analytics: KNIME, A/B Testing, Amazon Web Services (AWS)
- Data Management & Analysis: Data Cleaning, Normalization, Forecasting, Performance Monitoring
Timeline
Revenue Analyst
Disney
08.2023 - Current
Data Analyst
Horizon Media Inc
08.2021 - 07.2023
Data Analyst
Willis Towers Watson
08.2020 - 08.2021
Master of Science - Applied Statistics
West Chester University
Bachelor of Science - Mathematics
Arcadia University