Yashasree Gurram

Project - Swiggy

• Migrated 90+ queries running on snowflake (snowflake sql) to Databricks
• Seamlessly transitioned snowflake SQL queries to Databricks SQL through a combination of code transpiler and manual transformation techniques.

Project - CommerceIQ

• Migrated 300+workflows from snowflake (snowflake sql) to Databricks
• Successfully migrated all workflow queries to Databricks SQL from Snowflake SQL through code transpiler and manual transformation in line with MTT model change.

Project - Pumpjack Dataworks

• Conducted Exploratory Data Analysis (EDA) on the provided dataset to gain insights and understand data patterns.
• Designed and implemented a Medallion architecture pipeline for both Bronze and Silver tiers, optimizing data processing and transformation.
• Developed streaming pipelines to facilitate the transition of data from Silver to Gold tiers in real-time, ensuring a seamless data flow.

• Project - Walmart
• Developed ETL jobs to extract, transform, and load data from various sources into the target system.
• Implemented real-time streaming applications using Kafka as source and Spark Structured Streaming.
• Worked on developing various pipelines using spark scala for reading the data from sources like Kafka, Azure Blob and loading the data into GCS, Big Query.
• Scheduled the jobs using Airflow and GCP dataproc clusters.
• Provided technical support to business users on using Big Data tools for their analytical needs.