Praveenya Kasireddy

Developed complex SQL queries for data extraction and transformation processes. Developed SQL scripts to Load data into BigQuery. Managed data engineering tasks on GCP, ensuring efficient cloud infrastructure for analytics. Responsible for creating the GCP buckets, Datasets, Big Query tables in different layers of different BQ projects. Involved in developing data warehousing design using distributed SQL concepts, Python and Pyspark to cope up with increase in volumes of data. Involved in analyzing data to provide insights with Python using Pandas. Experience in using different file formats like Text, Sequence, Parquet, JSON and CSV. Worked on Creating Dag’s and tasks to deploy and run PySpark jobs in Airflow scheduling tool. Deployment process involved is through Jenkins CI/CD and code maintenance tool is github.

Involved in Integration Development, worked on configuring Cloud platform tasks. Troubleshoot Anypoint Cloud related issues and engage internal teams and vendor towards issue resolution. Worked on developing SQL queries to run the error logs in platform. Designed and implemented a relational database for a mock e-commerce site using MySQL. Worked on complex SQL queries to extract insights on customer behavior and sales trends. Good exposure in query tuning using Materialized views and indexes. Optimized SQL queries for major clients which resulted in 25% improvement in performance. Participate in Agile sprints to deliver data solutions efficiently.