Marketing Specialist Data Analyst

MICHAEL ERVIN – MARKETING SPECIALIST/DATA COORDINATOR

Pasadena, CA PH: 626-***-**** **.************@*****.*** LinkedIn SUMMARY

Experienced Data Asset Coordinator /Prospecting Marketing Analyst with a background in the Entertainment Industry(10+yrs). I found my love for Data during prerequisite courses in my BFA Digital Media program in college and later developed a love for manipulating data, finding insight, and creating Marketing strategies and visuals during my 3 month course at Thinkful Chegg Bootcamp Data Analytics program. During my time at Thinkful I sharpened my skills by pulling and manipulating datasets from ‘Kaggle’ and creating interesting visuals for Business Strategies on Tableau. I am now proficient with: creating dashboard models for clients and analysts, uploading and coding Pandas and Numpy libraries for Python, operating Advance Excel, SQL, and Tableau. I possess a comprehensive background in assisting department heads with data reports, account management, and business operation analytics. I am looking to find a company I can build with and eventually obtain a lucrative career in Business Intelligence, Marketing or Operations starting with an entry-level position in Exploratory Data Analysis or Marketing Specialist..

TECHNICAL SKILLS

Software: Microsoft Excel, Python, Tableau, SQL, PostgreSQL, Microsoft PowerPoint Data Methods: Statistical analysis, data visualization, presentation design, data cleaning, data discovery, data exploration, data modeling, A/B testing, t-tests

Additional Tools: Project management, business strategy, business intelligence, report generation DATA ANALYTICS PROJECTS

Business Analysis - Revenue Growth Models - Lariat Rent-A-Car Link

● Examined and cleaned historical sales data using Excel (VLookUp, pivot tables, and t-tests).

● Completed exploratory data analysis to identify strategic scenarios to increase revenue, assessed by KPI performance.

● Presented models that showcased a 20% increase in profits, while lowering operational costs. Statistical Significance - Pricing Factors - House Prices Link

● Developed a dashboard to assist shareholders within an investment bank in determining factors that drive housing prices and how they should allocate dollars into mortgage-backed securities.

● Dashboard data was supported through t-tests showing statistical significance. Inventory Analysis - Sales Trends - Wine Reviews Link

● Ran t-tests to determine the statistical significance between price, type, and origin of wine.

● Created visualizations in Python and presented data in PowerPoint to highlight inventory strategy to increase potential sales by 18% year over year.

DATA and ENTERTAINMENT EXPERIENCE

ViacomCBS - Remote - NY office 09/2021 - 09/2023

GCO – Global Content Operations Coordinator

● Collaborate with operational teams to bring Global archived content (including subtitling, dubbing, and access services), up to date and create audio packing to export to streaming platforms before launch.

● Bundled over 150 asset packages a day; including metadata, voice dubs, subtitles, audio, and video files.

● Cross-trained in Multiple departments gaining the ability to switch between job duties quickly and efficiently adding to the productivity of operations by 20%

● Composed asset reports on available and needed requested assets. The Walt Disney Studios - Los Angeles, CA 11/2019 - 03/2020 Data Management Specialist

● Migrated over 10,000 archive asset packages supporting the complex merger between Fox Studios and Walt Disney Studios.

● Composed asset reports on available and needed requested assets. continued

Paramount Pictures - Los Angeles, CA

iTunes Technical Operations Data Specialist 08/2019 - 10/2019

● Updated title ratings on the live streaming forum by scavenging metadata using database research software; prepared 600+ backlog bundle reports, in 3 weeks, and delivered the content to management to be posted on iTunes--2 weeks ahead of schedule.

● Communicated with international account managers to resolve complications with useful and accurate reports, conducted weekly international viral team meetings to discuss reoccurring issues, and updated current problematic procedures.

Apple Corporate

Data Quality Assurance Specialist 09/2015 - 09/2017

● Improved Customer Communication experience through agent-to-client correspondence evaluation, and determined customer needs.

● Retain customer loyalty by issuing refunds and incentives for company mishaps and maintaining personal interaction with clients.

● Successfully provided key support in troubleshooting and evaluating complex problems and escalating highly complex issues for Site Account Managers

● Contributed analytical proofreading skills and sharp attention to detail in evaluating agents' outgoing correspondence emails to ensure legibility in communication with customers.

● Promoted improvements to customer service and the billing department’s company style guide through weekly business meetings, bringing productivity up by 30% during the first year. EDUCATION

Thinkful Online

Certificate, Data Analytics 03/2023 - 07/2023

● Produced and presented professional projects and presentations from concept to completion focused on business forecasting, price modeling, and statistical analysis.

● Developed skills in data analytics systems including Pandas, Excel, PostgreSQL, Tableau, and Python, and methodologies including dashboarding, performance tracking, data wrangling, cleaning, and analysis" The Art Institute of Austin Austin, TX

Bachelor of Fine Arts: Digital Film-making and Video Production 10/2010 - 04/2014

Contact this candidate