Media Data Analyst Resume San Francisco, CA - Hire IT People

PROFESSIONAL EXPERIENCE:

Media Data Analyst

Confidential, San Francisco, CA

Developed R scripts to connect to Twitter’s API for network analysis, segmentation, visualization, sentiment analysis, text mining and top modeling to understand customer behavior.
Prepared deep dive analysis reports for social media campaigns such as Lunar New Year, Fx Currency, Treasury Management, Museum Selfie Day, Non Phishing campaign, etc. Interpreted metrics such as CPM, CPLC, CPC, CPE, CPVV, CTR, Reach and Engagement Rate accordingly to the campaign objectives and KPIs.
Presented campaign reports analysis to marketing consultants with the ability to translate data into actionable marketing insights, leveraging campaign strategies, optimization and ROI for WF services and products.
Assisted with sentiment analysis reports for social media campaigns such as Diwali, Android Pay, Convenience & Done, MLS Soccer, Millennial Checking and Home Renovation in collaboration with the Listening team.
Worked as part of a larger team in collaborative processes to create deliverables for the Annual Content Review project for all Wells Fargo Line of Business.
Recognized and identified inconsistencies or inaccuracies in data, tools and analytics and could take corrective measure. Uploaded data sources from Social Channels into SQL database.
Supported implementation of social media tools to drive new reporting solutions and improve our ability to operate efficiently.
Provided videos metrics and analysis for ad - hoc projects using YouTube Analytics.
Helped develop and optimize metrics dashboards and visualization in Origami and Tableau.

Advertising Data Analyst

Confidential, San Francisco, CA

Produced visually informative dashboard reports using Tableau and Excel for Confidential 's apps that showed data trending and insights.
Investigated social media metrics on Hootsuite, Sprout Social, Bitly and Sprinklr.
Established connection to MySQL database s on AWS to gather data and produce BI visualizations.
Schema design and data logical modeling of SQL and NoSQL databases tables/collections using Toad and Erwin.
Queried MySQL, PostgreSQL and Mongo DB databases to extract data and created reports and documents.
Researched on competitors metrics reports and Google Analytics APIs to compare and optimize Confidential 's apps reports.
Developed visualization report with Python and R programming.
Developed Python and R scripts to automate DSP reports presenting daily Data Charts, Budget Spend, CTR, CPM, CPC for each advertising campaign, and Revenue, Margin, CPM, Impressions, Top 10 sites, Top 10 Campaigns, Top 10 Strategies and Top 10 Segments for internal Confidential reports.

Junior Data Analyst

Confidential, San Francisco, CA

Applied different predictive modeling algorithms such as Decision Trees, Random Forest, GBM, Naive Bayes and Support Vector Machine to find what Google venues would be more likely to spend in advertising for the France, Japan and Brazilian markets.
Worked on data pre-processing steps such as replacing NAs, nulls or blanks with a meaningful value, creating new variables using transformations on one or more variables, scaling and centering continuous variables.
Used Rattle to compare predictive models to the models I created in R programming.
Prepared weekly reports presenting summary, accuracy, lift chart and ROC curve for the models.

TECHNICAL SKILLS

Data Analysis & Visualization using: R, Tableau, Origami, Excel, Google Fusion, Google Charts and Adobe Suite.

SQL databases: MySQL, Oracle.

NoSQL database: Mongo Db (intermediate).

Data Mining and Machine: Learning Algorithms

We provide IT Staff Augmentation Services!

Media Data Analyst Resume

San Francisco, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship