Pavan Chaitanya

About Pavan Chaitanya

SQL Developer | Data Analyst | ETL Developer I am a results-driven #DataAnalyst with over 5+ years of experience in the IT industry, specializing in Cloud and On-Premises environments. My expertise lies in #DataAnalysis,#ETL,#SQL,#BusinessIntelligence, and #BigDataAnalytics. Key Skills & Specializations:Proficient in #Python,#Java,#AWSHive,#AzureDataLake,#GCP, and BI reporting tools.Skilled in designing and optimizing Data Engineering pipelines, streamlining both batch and real-time data processing with advanced tools like #Hadoop,#Spark, and #Kafka.Experienced in crafting precise SQL queries, particularly adept in #Snowflake environments, and managing multi-cloud environments including #AWS,#Azure, and #GoogleCloud. Professional Experience:In my recent role at Austin Energy, I led initiatives in fine-tuning the Hadoop ecosystem and orchestrating Azure migrations. I optimized REST APIs using Python and collaborated effectively with Spark to enhance system performance. Additionally, I crafted machine learning models and developed ETL workflows, contributing to a 30% improvement in query response times.At Charter Communications, I focused on crafting machine learning algorithms for Telecommunication performance and successfully migrated on-premises applications to Azure. I engineered MapReduce/Spark Python modules and established robust Azure Data pipelines, optimizing Snowflake queries and Tableau reports for compliance throughout the system life cycle. Education & Certifications:I hold a Master’s degree in #BusinessAnalytics from Kent State University, USA, with GPA of 3.8 along with certifications in Database Foundations, Database Programming, and PL/SQL from Oracle Academy, Data Science from IBM, and Introduction to AI from Google. Data Analytics from AWS. Let\'s Connect:I\'m passionate about leveraging data to drive business insights and innovation. Let\'s connect to explore opportunities in Data Engineering, SQL Development, and beyond!#DataScience #TechJobs #DataAnalytics #CloudComputing

Experience

1. Data Engineer Sql Developer

   Austin Energy

   Apr 2023 — Present · Austin, TX, US

   Orchestrated Azure migrations, optimizing REST APIs with #Python and enhancing system performance with #Spark.Developed machine learning models and ETL workflows, resulting in a 30% improvement in query response times.#MachineLearning #ETLCollaborated effectively with fellow engineers to fine-tune the Hadoop ecosystem, ensuring seamless data management.#Hadoop #DataManagementCrafted compelling data visualizations using tools such as #PowerBI, driving actionable insights for business stakeholders.#DataVisualization #BusinessInsightsImplemented Snowpipe for effortless extraction of data from S3 buckets into Snowflake, facilitating seamless data flow.#Snowflake #DataIntegration

Education

• Kent State University

  Master's degree, Business Analytics

  2022 — 2023

• Loyola College

  Bachelor of Technology - BTech, Computer Science

  2014 — 2018