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:
SQL Programming
ETL development
Python Programming
Business Intelligence Analysis
Big Data
Google Big Query: Google Cloud Platform
Data Visualization: Tableau, Looker
Web Analytics: Adobe Omniture Analytics, Google Analytics
Programming: Java, HTML, C
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