Michael S. Email & Phone Number

United States

Data insights, optimization, and visualization to provide revenue growth and user monetization

Client: Nationwide Insurance-Act as singular reporting analyst for Nationwide insurance-Wrote scripts in Python using Pandas to automate the compilation of reporting metrics in Excel eliminating extra manual labor time-Stood up data pipelines to pipe historical data and created data warehouse for all marketing data-Construct custom variables to classify data and calculate metrics to provide insight to client and ensure accurate reporting data-Constantly QA and manage data ETL process to ensure data governancee

Los Angeles, California, United States

Client: Universal Home Entertainment-Dashboard developer, product manager, and insights guru for Universal Pictures Home Entertainment-Create Ad hoc reports and insights of cross platform, audience level and creative level performance to help Universal execs make business decisions-Led weekly status round-tables with NBCU VPs to report on campaign pacing-Contribute insights in Universal’s quarterly benchmark review, a comprehensive analysis of all titles ran in the quarter and present takeaways and suggestions based on analysis-Trained and mentored analysts promoted to my position upon vacating

Los Angeles, California, United States

-Big data querying and report creation to provide insights on advertising fraud, brand safety, campaign performance, publisher revenue generation, 1p vs 3p impression discrepancy to drive business decisions-Build dashboards to eliminate routine processes, increase insight efficiency and provide data transparency and accuracy-Forecast future revenue and campaign performance using regression analysis based on benchmarks of comparable campaigns-Led A/B tests post pandemic to see where to allocate spend according to platform and which platforms were driving best performance during lockdown

Los Angeles, California, United States

West Covina, California, United States

-Work with time series data to find and detect bugs in the billing cycle-Provide IT support to billing team -Build smart sheets in excel to improve efficiency in the analytic process of billing

Orange County, California, United States

-Build data visualization dashboards to convey various business performances to management such as product performance, store traffic, and quarterly KPIs-Assist with ETL process-Big data query to provide insights on various requests from sales

Florence, Italy Metropolitan Area

-Convened with dozens of local businesses, discussed their goals and visions for marketing campaigns and published local news publications to help meet advertising goals

Sacramento, California, United States

-Contribute analysis in weekly meeting; a Seminar by Senior Vice President of Global Wealth Jeffrey Won, a group meeting with our admins and a workshop taught by the admins. -Weekly stock pitches based on personal analysis -Group sector analysis project -Individual sector analysis report based on analysis of industry trends

Fairfield

-Door to door canvassing -3rd overall in lawn sign implementation for all canvassers

Master Of Science - Ms, Applied Data Science, 3.6

Currently attending online Master’s of Science in Data Science while working full time

Bachelor Of Science - Bs, Business/Managerial Economics, 3.45

Activities and Societies: Davis Accounting Society, UC Davis MBA Club, Morgan Stanley Financial Training ProgramAwards: Dean’s List Honors.

Certification, Data Science And Machine Learning, 4.0

Completed 6 month data science and machine learning bootcamp through UC Berkeley and Emeritus University focusing on building models.