Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

DEEPTHI BHAT

San Francisco,California

Summary

Collaborative and technically-minded Analyst with 7+ years of experience in Business Intelligence and 10+ years of total work experience. Transforms complex insights into actionable business recommendations and manages high-impact projects. Specializes in data analysis, data visualization, data integration, automation, and data infrastructure. Consistently recognized with achievement awards throughout the career.

Overview

12
12
years of professional experience
6
6
years of post-secondary education

Work History

Senior Business Intelligence / Data Analyst

Paramount Streaming
San Francisco, CA
05.2021 - Current
  • Start-to-end ownership of all Google Big Query datasets, tables, views and other entities & team access.
  • Oversee execution of scheduled jobs and manage data workflows in Google Big Query.
  • Spearheaded the rebuild of the Marketing Analytics & Data Integration team's data infrastructure as project manager, enhancing ETL processes and data model accuracy.
  • Execute ETL procedures, collaborate with cross-functional teams to gather data requirements, monitor and improve data accuracy, and maintain finalized Paid Marketing data through data injections on production tables.
  • Develop and maintain interactive dashboards in Tableau & looker to provide actionable insights to marketing managers for daily optimizations and planning
  • Established and enforced a detailed naming convention for paid marketing campaigns, convincing media activation and strategy teams of its importance.
  • Partnered with data engineering team to create a central GitHub repository and led updates to improve team collaboration and operational processes.
  • Develop, test, version control, and schedule complex SQL workflows for data transformation in Big Query using Dataform.
  • Automate data ingestion and ETL processes in Big Query using Python and cloud shell.

Business Intelligence / Data Analyst

CBS Interactive / ViacomCBS
San Francisco, CA
05.2019 - 04.2021
  • Collaborate with data engineers, vendors & marketing managers to extract data via API for Facebook and various Google products - Campaign Manager, DV360, SA360, Verizon to save 6-8 hours weekly.
  • Build & Automate reports using SQL and Python from GCP/Big Query to save 10+ hours/week of manual work and provide overall daily campaign performance results.
  • Analyzed and interpreted complex data sets to provide actionable insights and recommendations for business decision-making.
  • Created and delivered comprehensive reports and presentations to communicate findings and recommendations to marketing managers.
  • Furnish in-depth analysis of marketing performance in Search, Social, App & Programmatic channels to include y- o-y & m-o-m comparisons for huge games UEFA, NFL including Super Bowl.
  • Managed brand awareness & acquisition campaign data in Web as well as App for the streaming service CBS All Access, for transition to Paramount+

Associate Business Intelligence Analyst

CBS Interactive
Los Angeles, CA
08.2017 - 04.2019
  • Analyze marketing channel performance and advertising effectiveness to provide recommendations with the objective of driving up subscriptions for CBS streaming service CBS All Access.
  • Build reports querying relevant data gathered from Teradata/Hive/Big Query to provide overall results.
  • Examine site data available through Adobe Omniture to manage various web traffic data.
  • Managed all things CBS All Access from ad hoc requests, recap reports, monthly & weekly reports to straight line pacing of budget
  • Setup reporting to determine revenue for CBS digital web properties

Business Intelligence Analyst Intern

VizSense Inc
Dallas, TX
07.2016 - 12.2016
  • Delivered strategic influencer insights that drove business operations and executed influencer and User- Generated Content Campaigns

Consultant- Integration Developer/Systems Engineer

Tata Consultancy Services
Bangalore, India
12.2012 - 06.2015
  • Coordinated approvals for Medical Device Reports from U.S. FDA for operating companies in Johnson & Johnson using WebMethods technology.
  • Orchestrated the workflow between applications like SAP and various databases at different delivery/quality centers in Europe, Middle East and Africa and North America regions
  • Served as developer; created new enhancements, maintained third party communication for over 400 interfaces
  • Analyzed error data and consolidated root cause analysis as performance metrics to reduce count by nearly 40% and single-handedly resolved failures/issues

Education

Master of Science - Business Analytics

The University of Texas At Dallas
Richardson, TX
08.2015 - 05.2017

Bachelor of Engineering - Information Science

New Horizon College of Engineering
India
09.2008 - 06.2012

Skills

TECHNICAL SKILLS:

Accomplishments

  • Won "CBS Interactive Superstar" award for going above & beyond as a part of Audience Acquisition team
  • Won the "Star Performer Award" for endless efforts and outstanding contributions in maintaining a stable project

Timeline

Senior Business Intelligence / Data Analyst

Paramount Streaming
05.2021 - Current

Business Intelligence / Data Analyst

CBS Interactive / ViacomCBS
05.2019 - 04.2021

Associate Business Intelligence Analyst

CBS Interactive
08.2017 - 04.2019

Business Intelligence Analyst Intern

VizSense Inc
07.2016 - 12.2016

Master of Science - Business Analytics

The University of Texas At Dallas
08.2015 - 05.2017

Consultant- Integration Developer/Systems Engineer

Tata Consultancy Services
12.2012 - 06.2015

Bachelor of Engineering - Information Science

New Horizon College of Engineering
09.2008 - 06.2012

Similar Profiles

CREATE PROFILE
DEEPTHI BHAT