Kartik Chandna

Kartik Chandna

Data Analyst
India
Full-time On-site

About Me

Data Analyst with experience in SQL, Python, GCP, and Databricks, specializing in marketing analytics, A/B testing, and customer behavior analysis. Skilled in building scalable ETL pipelines, automating workflows using P…

Experience

Data Analyst

TATA Consultancy Services · Gurugram
Sep 2019 - Present · 7 years 1 month

<p>Automated ingestion and processing of marketing and campaign data from multiple sources using SQL and Python, building scalable pipelines that reduced manual turnaround time by 95%</p><p> Designed and executed A/B tests to evaluate campaign effectiveness, applying hypothesis and significance testing to validate results and support data-driven decision-making</p><p> Conducted pre- and post-campaign exploratory and diagnostic analysis using SQL on BigQuery and Databricks to uncover performance drivers and trends</p><p> Built and maintained ETL pipelines using Databricks (PySpark) and BigQuery for scalable data ingestion, transformation, and processing, ensuring data accuracy and consistency</p><p> Analyzed consumer behavior and customer journeys using SQL and Python (Pandas, NumPy) to uncover insights for improved targeting and engagement</p><p> Partnered with stakeholders to define key business metrics and translate requirements into data models, KPIs, and reporting frameworks</p><p> Developed interactive dashboards and KPI tracking systems in Power BI and QlikView to support real-time, data-driven business decisions</p><p> Performed data cleaning, transformation, and validation to ensure high data quality and consistency across reporting systems</p>

PROJECTS

Athlete Engagement Scorecard

DSG
Duration : 01-Sep-2025 - 05-Sep-2026

<p>Led development of a data-driven scorecard to track athlete engagement and performance metrics, engineering pipelines to integrate multiple data sources into a unified analytics layer– Engineered data pipelines to integrate and transform data from multiple sources into a unified analytics layer– Built dynamic Power BI dashboards using complex DAX queries and data modelling to visualize trends, KPIs, and engagement metrics in real time– Implemented Row-Level Security (RLS) and data governance practices to ensure secure and role-based data access– Partnered with cross-functional teams to define KPIs and reporting frameworks, aligning analytics with business objectives, and delivered insight-driven recommendations to leadership</p>

Certifications

Databricks certified Data Analyst Associate

Databricks · Delhi , Delhi , India · 2026

Skills

SQL Python Pandas NumPy BigQuery Databricks PySpark ETL Pipelines Google Cloud Platform A/B Testing Data Modeling Data Cleaning Data Transformation Exploratory Data Analysis Power BI DAX RLS QlikView MS Excel Agile Scrum
Report this Profile?