Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sreenath Kommuru

Azure Data Engineer | SQL Developer
Hyderabad

Summary

Experienced SQL & Azure Data Engineer with over 2.5 years of hands-on experience in designing, developing, and managing data solutions on the Azure platform. Skilled in SQL development, data pipeline design with Azure Data Factory, and data lake management with Azure Data Lake Storage. Proficient in optimizing database performance and ensuring data integrity. Passionate about leveraging big data technologies such as Hadoop and Apache Spark to tackle complex data challenges and drive actionable insights.

Overview

3
3
years of professional experience

Work History

Application Development Analyst

Accenture
09.2021 - Current


  • Complex SQL Query Development: Designed and optimized complex SQL queries, stored procedures, and functions to support application development and reporting needs, resulting in improved data retrieval efficiency and reduced query execution times.
  • Database Performance Optimization: Analyzed query execution plans and implemented indexing strategies to enhance database performance, achieving a 50% reduction in query response times.
  • SQL Performance Tuning and Optimization: Conducted performance tuning and optimization of SQL queries and database structures, enhancing overall system performance and user experience.
  • Data Security and Compliance: Ensured data security and compliance by implementing appropriate access controls, encryption, and data governance policies, adhering to industry standards and regulations.


  • Data Pipeline Development: Designed and implemented robust data pipelines using Azure Data Factory(ADF) to extract, transform, and load (ETL) data from on-premises databases to Azure SQL Databases, ensuring efficient and accurate data migration.
  • Designed One-Time Extraction Pipelines: Developed and implemented one-time extraction pipelines using Azure Data Factory to transfer data from on-premises databases to Azure SQL Databases, ensuring seamless and efficient data migration.
  • Incremental and Daily Data Extraction: Designed and maintained incremental and daily extraction pipelines for moving data from on-premises databases to Azure SQL Databases and documents from on-premises data stores to Azure Data Lake Storage. This approach ensured timely data updates and enhanced data availability for business intelligence and analytics.
  • Error Handling and Logging: Implemented a robust logging setup within the destination Azure SQL Database to facilitate error handling in data pipelines. This setup improved pipeline reliability, provided clear insights into error occurrences, and streamlined troubleshooting processes.
  • Data Transformation and Cleansing: Performed data transformation and cleansing activities to ensure the accuracy and quality of data being processed and stored, supporting reliable reporting and analysis.
  • Performance Optimization: Conducted performance tuning and optimization of data pipelines and storage solutions to enhance processing efficiency and reduce data latency, leading to improved system performance.
  • Documentation and Training: Documented ETL processes, data workflows, and best practices, and provided training to team members, fostering a knowledgeable and self-sufficient team environment.

Education

Bachelor of Science - Computer Science

Sri Venkateswara College of Engineering
Tirupati, India
04.2001 -

Skills

  • Database Management Systems: SQL Server (SSMS), Oracle (PL/SQL)
  • Languages: PLSQL, Java, Python
  • Azure Data Services: Azure Data Factory, Azure Data Lake Storage, Azure SQL Database
  • Version Control Systems: Git
  • Big Data Technologies: Basics of Hadoop, Apache Spark

Timeline

Application Development Analyst

Accenture
09.2021 - Current

Bachelor of Science - Computer Science

Sri Venkateswara College of Engineering
04.2001 -

Similar Profiles

CREATE PROFILE
Sreenath KommuruAzure Data Engineer | SQL Developer