Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shwetha Gopalarathinam

Redwood City,CA

Summary

Experienced and collaborative data enthusiast with a keen eye for identifying, analyzing, and resolving data engineering challenges. Proficient in constructing ETL processes, data pipelines, dashboards, and conducting data analysis

Overview

11
11
years of professional experience

Work History

Data Engineer

Rothys
07.2023 - Current
  • Developed a spend analytics data pipeline that reduced monitoring time and improved reporting accuracy by implementing automated alerts and proactive error detection using SQL and Airflow
  • Created an end to end pipeline to track retail traffic and labour hours across various brick and mortar stores
  • Building core reporting data sets with data optimization techniques, that empower stakeholders with timely and accurate insights using Python and SQL
  • Planning and developing new data engineering solutions to address issues related to changes in vendors, site operations, customer tracking needs, enhancing overall data agility and adaptability


Senior Growth Analyst - Retention

Rothys
03.2022 - 07.2023
  • Delivered data and actionable insights to cross-functional teams, resulting in an increase in marketing campaign effectiveness and facilitated data-informed decision-making across departments using SQL
  • Analyzed and identified key trends and patterns in customer behavior enhancing understanding of customer preferences and behaviors, leading to an uplift in personalized marketing strategies using SQL
  • Built regression models to forecast spend across different marketing channels that enabled proactive budget allocation decisions using Python

Growth Marketing Analyst

Rothy's
03.2020 - 03.2022
  • Built and centralized vendor reporting on marketing performance reducing reporting time and enabling real-time comparison of marketing programs
  • Analyzed website behavior and identified optimization opportunities of different channels increasing website conversion rate
  • Provided data-driven insights on customer LTV by marketing efforts, purchase behavior, email, and social interactions resulting in an uplift in customer retention

Data Analyst

Scale Marketing
07.2018 - 03.2020
  • Obtained and integrated third-party data sources, resulting in a 25% expansion of data coverage and granularity using Python
  • Utilized SQL, Tableau Desktop & Prep to pull data from various systems and developed rich interactive visualizations resulting in improvement in stakeholder engagement and understanding
  • Performed Ad-Hoc analysis and identified key performance drivers that optimized marketing strategies based on real-time insights, using Google Analytics and Google Ads to drive marketing decisions

Engineer - Technology

Virtusa
05.2014 - 07.2016
  • Interpreted data from various sources using statistical techniques and provided ongoing reports using BIX tool
  • Contributed to UI Upgrade from Pegav6.2 to Pegav7.1.8
  • Analyzed various REST web services supporting both XML and JSON using Postman

Education

Masters in Information Technology and Management -

Illinois Institute of Technology
Chicago, IL
05.2018

Bachelor of Engineering -

Anna University
Chennai, India
03.2014

Skills

  • SQL
  • Python
  • Airflow
  • AWS
  • Looker
  • Tableau
  • Google Analytics

Timeline

Data Engineer

Rothys
07.2023 - Current

Senior Growth Analyst - Retention

Rothys
03.2022 - 07.2023

Growth Marketing Analyst

Rothy's
03.2020 - 03.2022

Data Analyst

Scale Marketing
07.2018 - 03.2020

Engineer - Technology

Virtusa
05.2014 - 07.2016

Masters in Information Technology and Management -

Illinois Institute of Technology

Bachelor of Engineering -

Anna University

Similar Profiles

CREATE PROFILE
Shwetha Gopalarathinam