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

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

-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

-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

-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

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

-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

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