Summary
Overview
Work History
Education
Skills
Internship
Timeline
Generic

Gauri Balachandran

Data Scientist/ Analyst

Summary

Data Science and Analytics professional with over 6 years of experience with expertise in SQL, Python, and cloud platforms (GCP, AWS) complements a proven ability to enhance decision-making and improve business outcomes to meet the organizational objectives through advanced analytics, A/B testing, and data visualization. Recognized for effective collaboration with cross-functional teams while maintaining a keen awareness of emerging industry trends.

Overview

7
7
years of professional experience

Work History

Senior Analyst - HTHD

Ford Motor Company
09.2022 - Current
  • Instrumental in constructing code logic to specify campaign timing windows, optimizing conversion rates for sales, service, and integrated subscription offerings.
  • Partnered with the data engineering team to develop a data product that structures data across all service commodities, sales, and integrated services products, illustrating conversions over 30, 60, and 90-day intervals, irrespective of campaign execution.
  • Executed in-depth assessments of multiple sales and marketing campaigns targeting current and former Ford owners and prospects, examining performance metrics such as incremental profit, conversion rates, and online engagement within specified timeframes.
  • Analyzed multiple service marketing initiatives for oil changes, pick-up and delivery services, tire changes, and extended service plans to evaluate which campaigns yielded optimal conversion rates suitable for long-term execution.
  • Established logics to analyze subscription conversion rates over 30 days for Integrated Services of Ford (BlueCruise, Connected Navigation, Stolen Vehicle Services, etc.) and pinpointed car models that achieved the highest subscription conversion rates for IS products.
  • Analyzed marketing campaign performance using an audience base generated from predictive models, examining conversion effectiveness through decile-wise split rates, to enhance stakeholder understanding of predictive model reliability.
  • Optimized reporting of major marketing campaigns (Sales, Service, IS) by creating Qlik Sense dashboards through joint efforts with the Data Analytics Team.
  • Engineered CRM engagement segmentation model utilizing the K-Means clustering algorithm to categorize customer segments based on email engagement over the last 365 days.
  • Analyzed communications data to identify root causes of issues, and recommend corrective actions. Developed user guides for CRM data utilization to enhance operational efficiency.

Associate Consultant – Analytics

Aryng
02.2021 - 08.2022
  • Penalty Analysis: Built predictive models on historical data to forecast potential ATM penalties, aiming to minimize company losses.
  • Budget Overrun Analysis: Demonstrated that exceeding the budget by USD 1.4B saved the company USD 7M in 2021 by reducing penalties, dispatch costs, and bank interest rates.
  • Terminal Theft Analysis: Optimized cash order strategies across 75 ATMs in Baltimore, reducing buffer forecasts by 21% on average.
  • Brand Campaign Analysis: Quantified marketing campaign impact on user metrics, reducing subscription costs by approximately 64%, and achieving 54% brand awareness.
  • Marketing Survey Analysis: Delivered insights on app features to guide teen-focused marketing strategies.

Knowledge Officer – Data Science & Analytics

ICT Academy of Kerala
10.2019 - 02.2021
  • Trained over 300 professionals, educators, and students in Statistics for Data Science.
  • Created curriculum and content on mathematics for machine learning and artificial intelligence.

Tax Analyst

EY
05.2016 - 07.2017
  • Prepared and reviewed 300+ UK tax returns for multinational corporations using advanced Excel models and CCH software.

Education

M.Sc. - Data Science

Liverpool John Moores University
01-2023

M.Sc. - Mathematics

Madras Christian College
01-2016

B.Sc. (Hons) - Mathematics

Sri Sathya Sai Institute of Higher Learning
01-2014

Skills

Internship

Indian Institute of Technology, Madras (2015)

Researched Advanced Number Theory concepts under Dr. Srilakshmi Krishnamoorthy


Timeline

Senior Analyst - HTHD

Ford Motor Company
09.2022 - Current

Associate Consultant – Analytics

Aryng
02.2021 - 08.2022

Knowledge Officer – Data Science & Analytics

ICT Academy of Kerala
10.2019 - 02.2021

Tax Analyst

EY
05.2016 - 07.2017

M.Sc. - Data Science

Liverpool John Moores University

M.Sc. - Mathematics

Madras Christian College

B.Sc. (Hons) - Mathematics

Sri Sathya Sai Institute of Higher Learning
Gauri BalachandranData Scientist/ Analyst