Open to opportunities

Sonal Garg

@sonalgarg

Message

Senior Data Analyst turning ambiguous business problems into scalable, experimentation-ready data insights.

India

Message

What I'm looking for

I’m looking for a role where I can turn business questions into measurable decisions—building reliable SQL/Python/BigQuery pipelines, running A/B tests, and exploring AI/LLM-assisted workflows to strengthen analytics and experimentation.

I’m a Senior Data Analyst with 8+ years of experience transforming ambiguous business problems into data-driven decisions across e-commerce, digital marketing, and real estate platforms. I’m an expert in SQL, Python, and BigQuery, and I build scalable analytics pipelines, dashboards, and experimentation frameworks for fast-moving, high-volume environments.

I also love partnering across product, engineering, and business teams—communicating findings clearly to technical and non-technical stakeholders, and driving reliability through QA, anomaly detection, and root-cause analysis. Recently, I’ve been curious about AI/LLM-assisted workflows and how they can strengthen business intelligence; in parallel, I’ve delivered measurable impact through automated reporting, funnel/cohort analysis, propensity and fraud logic, and 20+ A/B tests.

Experience

Work history, roles, and key accomplishments

Data Specialist

YipitData

Jun 2025 - Apr 2026 (10 months)

Owned QA and reporting workflows across 10+ datasets, defining data quality KPIs that reduced data inconsistencies by ~10% and improved decision-support reliability. Automated end-to-end reporting pipelines in Python, eliminating 15–20 hours/week of manual effort, and performed anomaly detection and root-cause analysis to improve pipeline reliability.

SQL Python BigQuery Data Pipelines Report Automation Anomaly Detection Root Cause Analysis

Senior Business Analyst

Karatcart

Nov 2023 - Jun 2025 (1 year 7 months)

Built SQL and BigQuery pipelines to integrate online and offline sales data into a unified reporting layer, reducing reporting inconsistencies by ~15% and improving KPI visibility. Developed Tableau dashboards used by 10+ business stakeholders, conducted cohort and pricing analysis in Python to improve gross margin by 2%, and automated recurring reporting workflows, cutting manual effort by ~25%.

SQL BigQuery Tableau Data Integration Report Automation Cohort Analysis Pricing Analysis KPI Analysis Python

Senior Data Analyst

Pivotroots

Aug 2021 - Nov 2023 (2 years 3 months)

Built end-to-end BigQuery pipelines integrating Google Analytics, backend, and financial data across 5+ clients to enable unified cross-functional reporting. Developed lead propensity models in Python and R to improve targeting efficiency and increase lead conversion by ~8–10%, and designed/analyzed 20+ A/B experiments to drive conversion improvements.

BigQuery Python R Google Analytics A B Testing Lead Propensity Modeling Experimental Analysis Data Pipelines

Product Analyst

Proptiger Realty Pvt. Ltd.

Jun 2018 - Aug 2020 (2 years 2 months)

Analyzed large-scale user behavior using SQL and Google Analytics to identify funnel drop-offs and optimize user journeys for a high-traffic real estate marketplace. Ran A/B experiments that increased page conversion from 4.5% to 4.7% (+4.4% uplift) within 2 months, and built Tableau dashboards for product and regional sales teams to support data-driven planning across markets.

SQL Google Analytics A B Testing Tableau Funnel Analysis User Journeys Dashboards Data Visualization

Business Analyst

OYO Rooms

Sep 2017 - May 2018 (8 months)

Automated KPI dashboards using Python and R, reducing reporting time by ~35% to enable faster operational decisions. Analyzed user behavior patterns with Google Analytics to identify high-value segments and built P&L forecasting models to support revenue estimation and business planning.

Python R KPI Reporting Google Analytics User Behavior Analysis Customer Segmentation Data Visualization

Assistant Manager, Analytics

Indiamart Intermesh Pvt. Ltd.

Dec 2015 - Sep 2017 (1 year 9 months)

Performed complex SQL and R-based analysis on large datasets to support product performance and pricing strategies across a B2B marketplace. Built fraud detection and recommendation logic to improve platform efficiency and user experience, delivering actionable insights to product and business teams to optimize category-level performance.

SQL R Fraud Detection Recommendation Systems Pricing Analytics Data Analysis KPI Reporting