Bhavana S.

• Designed and optimized custom SQL queries in BigQuery to process raw GA4 and Firebase event data, enabling real-time dashboards and actionable insights for marketing and product teams.
• Developed and maintained end-to-end ELT pipelines to ingest and transform data from cloud storage (GCP/AWS S3), Firebase, and on-prem SQL sources into BigQuery for analytics and reporting.
• Automated data cleaning, standardization, and enrichment workflows using Python and SQL, delivering trusted, high-quality data models for downstream analytics teams.
• Collaborated with cross-functional stakeholders to translate business questions into scalable Looker dashboards, leveraging custom dimensions and derived tables from BigQuery.

• Implemented data flow automation with Azure Data Factory, increasing operational efficiency by 40% for time-sensitive reporting.
• Actively engaged in performance tuning and optimization of Azure Databricks jobs, optimizing resource utilization and reducing processing time.
• Created Azure Databricks notebooks using Python, Spark, PySpark, and SQL to perform data transformations, ingestions, and modeling tasks on large and complex datasets.

• Constructed scalable and efficient ETL/ELT data pipelines for data extraction, transformation, and loading using Azure services for data processing and storage.
• Contributed to ETL batch and stream processing Azure Databricks jobs, transforming and loading data into various data zones.
• Automated repetitive data processing tasks, achieving a 45% reduction in manual workload and decreasing human error.
• Performed data transformation and cleaning operations to maintain data accuracy and quality standards.

• Implemented data integrations and validation checks in SQL and Microsoft Azure Synapse Analytics to ensure smooth data ingestion and flow.
• Built a real-time data processing pipeline that facilitated timely insights into customer behavior and market trends.
• Optimized batch data workflows for a leading e-commerce platform, ensuring sub-hourly availability of critical business metrics and KPIs, bolstering real-time decision-making.
• Collaborated closely with cross-functional teams to gather requirements, design robust data solutions, and provide valuable insights to organizational stakeholders.

Kroger is a major American supermarket chain offering a wide range of groceries, pharmacy services, and health products.

• Designed and implemented multiple scripts to reduce manual interventions and to have standard reports for specific ID configurations. - Created scripts/solutions for verification and automation (XID comparison, DIF status, close process). -Implemented several user stories related to scan bag go and click list, seasonal changes, and store closing procedures—only people working on the timely restrictions on different SKUs and festival changes from offshore.
• Improved efficiencies by 50% by revising case management procedures and training employees on revisions. Managed escalated customer complaints through resolution utilizing cross-functional and global resources as required.
• Created knowledge base, resulting in increased 1st tier support call resolutions and limited escalations to 2nd line and 3rd line support teams.
• Deploy changes made using GIT and working on the code conflicts.