DATA ANALYST Resume Glendale, CA - Hire IT People

SUMMARY

Expert analyst skilled at synthesizing company - wide data using Key Performance Indicators (KPI) and creating dashboards and presentations to marketing teams, senior management, and stakeholders.
Expert at defining complex analytics for software projects including website tagging, data warehouse definitions, creating KPIs for management to measure the success of the business.
Google Analytics Premium
Google Tag Manager
Expert MySQL and Advanced Microsoft SQL Server Query Creation Expert Google Analytics, including Tavic Excel plugin and GA Interface Programmer: Pivot Tables, Adobe® Marketing Cloud (Omniture) Client integration, Tavic’s Excel GA plugin, Interactive Dashboards with dropdown menus, Advanced String Processing, Chart Design, Implementation of Custom SQL Querie.

PROFESSIONAL EXPERIENCE

DATA ANALYST

Confidential, Glendale, CA

Responsibilities:

Evaluate KPI reporting requirements for new marketing initiatives, including writing design specifications for the technology team, modifying data collections within the internal database, and synthesizing data feeds into data warehouse. Create appropriate tagging within the Adobe® Marketing Cloud suite. Perform analysis to deliver insights and recommendations to increase marketing effectiveness and drive decision-making.
Augomated data extracts in Omniture and Survey Gizmo for internal usage.
Oversee user acceptance testing for any site tagging changes.
Extensive use of Adobe Adhoc (Discover) reporting for web analytic trends and identifying user segmentation.
GTM Tag Implementation.
Tableau dashboard creation.

Consultant Internet Analytics

Confidential

Responsibilities:

Created specifications to track individual hundreads of music properties withing multiple continets and Sony business units in GA Premium that was scailable framework.
Collaborated with their Word Press developers to implement tracking on their artist sites. Implemented reusable tracking tags within GTM.
Created scaleable rollup reporting for Sony Music business units.
Created a reporting framework for each individual artistsand their staff.
Trained Sony Music staff in Google Analytics Premium reporting and site creation.

Web Analytics Manager

Confidential, Santa Monica, CA

Responsibilities:

Chief marketing department analyst responsible for collaborating with marketing team to determine return on ROI including SEM, retargeting, offline media including TV and radio for all marketing spend.
Evaluate KPI reporting requirements for new marketing initiatives, including writing design specifications for the technology team, modifying data collections within the internal database, and synthesizing data feeds into data warehouse. Create appropriate tagging within the Adobe® Marketing Cloud suite. Perform analysis to deliver insights and recommendations to increase marketing effectiveness and drive decision-making.
Analyze previous client behavior to improve site conversion.
Create, modify, and prepare presentations for weekly free-form analytics forum with senior management.
Oversee user acceptance testing for any site tagging changes.
Develop ad hoc reports for stakeholders
Leading data warehouse team in integrating key site catalyst data into internal data structures.
Implementation of Google Analytics Premium across all business units.
Advanced use of Google Tag Manager for implementation of Google Analytics Premium and third party acquisition pixels.
Google Sheets, Tableau and Big Query integration for Google Analytics reporting.

Senior Business Analyst

Confidential, Gardena, CA

Responsibilities:

Imported nightly raw beacon file into an SQL-compliant database for regression analysis for prediction of lower-funnel events based on history of consumer’s previous upper-funnel actions. Created Tableau interface to allow end user to modify weights of actions to formulate optimal regression line.
Developed Excel report integration of double click reporting and query creation, and integrated DC query data into Tableau visual presentation.
Maximized advanced Excel functions, including developing chart design using automated movement of date ranges based on report value, allowing for movement of data into the next month without user having to change range specifications.
Supervised installation of company Tableau server and performed all administrative tasks to maximize usefulness.
Led team of analysts in creating client-specific reports and performed quality control functions.
Designed and specified tagging requirements and supervised development staff through implementation.
Wrote summaries of report data to keep internal management apprised of progress for external clients.
Created month-over-month and year-over-year analysis for client reports.
Prioritized daily, weekly, and monthly routine tasks to accommodate special projects and time-sensitive reports and presentations
Modified junior analyst reports to optimize automation and reduce end user error.