SAIKIRAN KEDARISETTY
Specialist - Data Engineering
Hyderabad
Summary
With 6+ years of IT experience in Data Engineering and Analytics, specializing in Azure technologies like Data Factory, Data Lake, Databricks, and Synapse. Microsoft Certified Azure Data Engineer Associate with expertise in ETL, Data Warehousing, and Power BI. Skilled in SQL, query optimization, and working with relational databases. Known for strong work ethics, proactive approach, and being a dedicated team player.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
Work History
Specialist - Data Engineering
LTI MindTree
09.2023 - Current
- Developed Extensive ETL Pipelines utilizing Azure Synapse Analytics, leading to a 30% increase in a workflow Efficiency.
- Developed and maintained end-to-end data pipelines using Azure Synapse Notebooks, enabling efficient data integration, transformation and analysis.
- Achieved an 18% reduction in Azure SQL database and storage account costs through targeted optimization strategies.
- Implemented CI/CD Pipelines within Azure DevOps for Azure Data Factory, Azure Synapse Analytics & Azure SQL Database to enhance team productivity and shorten release cycles.
- Automated routine data processing tasks, saving the team an average of 10 hours per week.
- Designed and implemented personalized visuals in Power BI to present data in a more meaningful and visually appealing way for stakeholders.
- Developed and created parameterized Power BI reports, enabling dynamic data filtering based on user defined inputs for more tailored and interactive sights.
- Experienced in developing & scheduling power bi reports and dashboards from multiple data sources using data blending.
- Created row level security as per the roles assigned to users.
- Proficient in writing and applying basic dax formulas in Power BI to calculate measures and create calculated columns for data analysis.
- Successfully managed and delivered over three projects simultaneously, ensuring timely completion and high-quality results through effective prioritization and coordination.
Consultant
Deloitte
01.2021 - 09.2023
- Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL
- Data Ingestion to one or more Azure Services-(Azure Data Lake, Azure Storage, Azure SQL, Azure Synapse Analytics)and processing the data in Azure Databricks
- Created Pipelines in ADF using Linked Services/Datasets/Pipeline/to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure Data Lake, Azure Synapse Analytics, SFTP, SAPBW, SAP HANA and organized suitable triggers in Azure Data Factory
- Developing Spark applications using Spark – SQL in Databricks for data extraction, transformation and aggregation from multiple file formats for analyzing &transforming the data to uncover insights into the customer usage patterns
- Designed and Developed Azure DevOps pipelines to manage the resources across multiple subscriptions in azure
- Used Azure DevOps services such as Azure Repos, Azure Boards and Azure Pipelines to plan work and collaborate on code development built and deployed application
- Produces SQL code (Stored Procedures, Functions and any other database specific code) and optimized solutions meeting technical specifications and business requirements
- Performed Analysis and identified cost saving opportunities and potential program Enhancements in Azure
- Responsible for estimating the cluster size, monitoring and troubleshooting of the Spark databricks cluster
- Lead code reviews, shares knowledge and mentor junior resources
- Gather requirements, assessed data and issues and directed concerns to business unit leadership
Senior Systems Engineer
Infosys
08.2018 - 01.2021
- Analyzed business requirements and implemented data mart solutions for data mining and reporting
- Experience in Writing T-SQL Stored Procedures , Constraints and Indexes using Various DDL and DML Commands
- Developed reports with consistent drill-down functionality including Drilldown report and Summary report
- Imported data from various sources (Files, SQL Server DB, Azure SQLDB, Azure Datalake) to PowerBI to generate reports
- Created DAX queries to generate computed columns in Power BI
- Expert in creating Dashboards, Cards, Charts, for further data analysis using PowerBI desktop
- Published reports and dashboards using PowerBI
- Created Pipelines in ADF using Linked Services/Datasets/Pipeline/to Extract, Transform and load data from different sources
- Designed suitable triggers (Schedule, Tumbling window, Event) based on client requirements
Education
B.Tech - Electrical & Electronics Engineering
Vignan’s Institute of Information Technology
Visakhapatnam, India 04.2014 - 04.2018
Skills
- Azure Data Factory
- Azure Data Lake
- Azure Synapse Analytics
- Azure Databricks
- Azure DevOps
- SQL
- Spark SQL
- Pyspark
Certification
Microsoft Certified: Azure Fundamentals
Timeline
Specialist - Data Engineering
LTI MindTree
09.2023 - Current
Consultant
Deloitte
01.2021 - 09.2023
Senior Systems Engineer
Infosys
08.2018 - 01.2021
B.Tech - Electrical & Electronics Engineering
Vignan’s Institute of Information Technology
04.2014 - 04.2018
Similar Profiles
Subash Chandra RSubash Chandra R
Director Architecture | Enterprise-AI at LTI MindtreeDirector Architecture | Enterprise-AI at LTI Mindtree
Priyati RaneePriyati Ranee
Azure Cloud Solution Engineer at LTI Mindtree LimitedAzure Cloud Solution Engineer at LTI Mindtree Limited
Hiranya NagunooriHiranya Nagunoori
Scrum Master at LTI MindtreeScrum Master at LTI Mindtree