Welcome to my page! I am a data analyst with a passion for distilling complex data into digestable insights.
- Experience
-
The Walt Disney Company May 2022 - Present
Data Analyst - Core Bundle Analytics | Seattle, WA
- Analyze financial and customer data sets to identify trends, including subscriber acquisition and retention
- Design, execute, and analyze end-to-end A/B tests for product features, pricing, and marketing campaigns
- Leverage engagement data and cluster analysis to identify subscription predictors and patterns
- Conduct ad-hoc analysis and create data-driven recommendations for product features and user experience improvement
- Perform root-cause analysis on financial and customer data sets to identify trends in acquisition and retention metrics
The Pokémon Company International Jun. 2021 - May 2021
Business Intelligence Analyst II - Animation | Bellevue, WA
- Worked with the Pokémon Animation team to drive improvements in products like the Pokémon TV
- Designed and developed end-to-end reporting infrastructures using Tableau, SQL, and Databricks
- Automated tools and frameworks for monitoring internal and external data stacks across programming, marketing, licensing, and product, saving over 360 hours per month
- Built forecasting models with Python (Prophet) and visualized results using Plotly
- Developed custom scripts to automate data extraction and reporting, reducing report generation time by 20%
Goldman Sachs Jul. 2019 - June 2021
Senior Analyst - Internal Audit Data Analytics | New York City, NY
- Designed and developed analytical solutions for internal audit, specializing in App Infrastructures and Operations
- Spearheaded a Tableau performance uplift project, resulting in a 15% increase in dashboard performance and 90% increase in user engagement
- Automated analytical reports using VBA and Python, saving over 230 hours per month
- Revamped and presented an analytical training program to a global audience, increasing retention by 23%
- Cultivated long-term relationships with 20+ stakeholders, maintained ongoing projects, and facilitated solutions
Governor’s Office of Economic Development Mar. 2019 - Jun. 2019
i6 Intern | Sioux Falls, South Dakota
- Advised and assisted early-stage biotech executives with business development and product commercialization
- Coordinated and assisted SBIR funding request from the US Small Business Administration; helped raise $100,000 for the Phase 1
- Determined over 1000 potential clients for partnership in 4 major cities by conducting research on the target market
Sony Pictures Entertainment Sep. 2018 - Dec. 2018
Data Science/BI Intern | Los Angeles, CA
- Designed, developed, and maintained dashboards and tools to provide insights to help monitor the Crackle’s performance and operation
- Created topical research decks for sales support, such as overall industry trends, advertising trends and overall marketplace using Nielsen and comScore
-
- Analyzed and researched various acquisition, conversion and retention metrics using Python and Excel
Goldman Sachs May. 2018 - Aug. 2018
Summer Intern | Salt Lake City, UT
- Assessed the firm’s internal control structure, advised management on developing control solutions, and monitored the implementation
- Compiled and tabulated entitlements data in 3 databases for operational risk analysis, results were escalated to project manager
- Developed and implemented several process automation measures using VBA, saving over 10 hours per month
Click Rain Feb. 2018 - May. 2018
Data Intern | Sioux Falls, SD
- Quantified and uncovered trends or patterns in large data sets to gain actionable insights for internal and external stakeholders
- Optimized and tested customer acquisition through Google Analytics and AdWords, revamped the campaigns according to findings
- Automated the backend for the client-facing dashboard using Google Apps Script, reduced the wait time from 7 days to 1 day
- Education
-
University of South Dakota
Graduation Date: May 2019
Bachelor of Science in Economics, minors in Computer Science and Philosophy
- Projects
- Please check out my GitHub for more info!
- Skills
-
Technical Skills
Python, SQL (MySQL, Sybase IQ), VBA
Certifications
Tableau Certified Associate, Google Analytics IQ, AWS Certified Practioner
Platforms
Tableau, Google Analytics, AWS
Kevin@2023