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
Data & Tools: GCP (Big Query, Vertex AI), Python, Qlik Sense, MS Office
Analytics: Data Visualization, Machine Learning, A/B Testing, Predictive Analytics
Business & Strategy: Insight Generation, Problem Solving, Critical Thinking, Storyboarding, Project Presentation
Soft Skills: Cross-functional Collaboration, Effective Communication, Training & Mentorship, Stakeholder Management
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