Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

POOJA SANJAY PATHAK

Senior Customer Insights Analyst
Melbourne

Summary

Data-driven Senior Customer Insights Analyst with expertise in advanced data exploration and actionable insights on customer behavior and growth opportunities. Skilled at generating impactful reports and providing strategic recommendations to optimize customer engagement. Experienced in championing customer analytics by aligning with stakeholders, addressing data needs, and integrating customer insights to drive informed decision-making.

Overview

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

Work History

Senior Customer Insights Analyst

Country Road Group
10.2021 - Current
  • Conducted data analysis to understand product range performance, retail strategy, and customer behaviour
  • Performed data deep-dives to uncover insights, and present actionable results to stakeholders, driving strategic business decisions
  • Conduct meticulous AWS data checks, identifying and resolving discrepancies across business layers to maintain data integrity and accuracy
  • Partner with Advanced Analytics on crucial projects like customer segmentation and churn prediction, ensuring robust testing and validation processes
  • Built target audiences for advanced analytics models and segmentation projects
  • Provided sales data and supported market segmentation projects to refine portfolio strategies
  • Designed and led rewards analysis and reports, supporting loyalty program insights
  • Acted as customer advocate in loyalty dashboard projects, aligning with data needs
  • Provided analytical expertise to the finance and audit teams, offering support in data analysis
  • Collaborated with IT and CRM teams to resolve data discrepancies and improve database efficiency
  • Pioneer new data attribute testing for enhanced customer insights, integrating discount codes and click-and-collect flags into analysis framework
  • Lead onboarding for new analysts, providing comprehensive training in data flows, SQL, and essential tools like Salesforce and Tableau

BI Developer

Leighton O'Brien
09.2019 - 10.2021
  • Developed analytical dashboards and reports for industry-leading products (Wetstock Live, SIRA Analyses) for major petrol companies across Europe, America, and Australia
  • Analyzed platform data to create custom BI analytics, writing optimized SQL statements
  • Managed data warehouse DBs and schemas, including performance tuning and updates
  • Migrated clients from legacy systems to Yellowfin BI and maintained server updates
  • Created internal reporting to track report usage, performance, and user interactions

Tableau Developer

Meta Inc.
09.2018 - 05.2019
  • Analyzed data and created visual reports for network capacity, overutilization, and provisioning
  • Developed data pipelines from Hive, MySQL, and Oracle using Presto for Edge Network Services
  • Collaborated with network provisioning teams to align report metrics with objectives
  • Created advanced calculations to measure capacity changes and performance metrics
  • Optimized multiple dashboards for better performance and tracked dashboard metrics

Tableau Developer/Server Admin

Apple Inc.
10.2015 - 09.2018
  • Developed interactive reports for Apple Support, Apple Communities, Real Estate, and Legal Services
  • Engaged with business users to understand requirements and create relevant metrics
  • Managed user access, groups, and report schedules on Tableau Server
  • Translated ad hoc requests to deliver timely and impactful data insights
  • Enhanced report performance by optimizing data connections and query efficiencies

Education

Master of Science - Electrical Engineering

University of Colorado
01.2013 - 01.2015

Bachelor of Engineering - Electronics and Communication Engineering

Anna University
01.2009 - 01.2013

Skills

SQL: BigQuery, SQL Server, MySQL, Hive, AWS, Teradata, Oracle, MongoDB

Data Visualization: Tableau, Power BI, Qlik, Yellowfin BI

CRM : Salesforce

Accomplishments

  • Leadership in Migration: Led BI team in migrating clients to latest Yellowfin reporting platform, delivering fast, innovative dashboards.
  • Design Improvement: Recognized for identifying and resolving design flaws in Meta’s network infrastructure portal.
  • Tableau Server Deployment: Successfully deployed Tableau Server for Apple’s Real Estate team, pioneering server-based reporting within the team.

Timeline

Senior Customer Insights Analyst

Country Road Group
10.2021 - Current

BI Developer

Leighton O'Brien
09.2019 - 10.2021

Tableau Developer

Meta Inc.
09.2018 - 05.2019

Tableau Developer/Server Admin

Apple Inc.
10.2015 - 09.2018

Master of Science - Electrical Engineering

University of Colorado
01.2013 - 01.2015

Bachelor of Engineering - Electronics and Communication Engineering

Anna University
01.2009 - 01.2013
POOJA SANJAY PATHAKSenior Customer Insights Analyst