Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Timeline
Generic
Sreecharan Bellamkonda

Sreecharan Bellamkonda

Hyderabad

Summary

Results-driven Data Engineer with extensive experience at Bristlecone PVT LTD, specializing in Azure Data Factory and ETL processes. Proven ability to design and implement data solutions that enhance data quality and visualization. Strong analytical problem-solving skills complemented by expertise in SQL programming, delivering impactful insights for informed decision-making.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Specialist Data Engineer

Bristlecone PVT LTD
08.2023 - Current
  • Creating, prioritizing, and tracking issues throughout the project lifecycle.
  • Integrating Jira with other tools like Slack, Confluence for seamless collaboration.
  • Generating reports and dashboards to track project progress and performance metrics.
  • Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
  • Well experience in data extraction, Transforming and loading (etl)using various tools such as SQL Server integration.
  • Hands on experience in Data Migration and Transformation from different file formats like flat file, MS Excel to SQL SERVER 2016/2014.
  • Designed SSIS Packages to transfer data from flat files, Excel SQL Server using Business Intelligence Development Studio.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task.
  • Working knowledge in Creating tables, stored procedures, triggers, views, Indexes using transact SQL. performances.
  • Develop stored procedures/views in snowflake.
  • Develop SQL queries in Snow SQL.
  • Building and customizing reports for business users to analyze data trends and make informed decisions using MICROSTRATEGY TOOL

Azure Data Engineer

Bristlecone PVT LTD
08.2022 - 07.2023
  • Analyze, design, and build Modern data solutions using Azure PaaS service to support visualization of data.
  • Understand current Production state of application and determine the impact of new implementation on existing business processes.
  • Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and U-SQL [Azure Data Lake Analytics]. Data Ingestion to one or more Azure Services – (Azure Data Lake, Azure Storage, Azure SQL, Azure DW).
  • Create, schedule, and manage your data integration at scale with Azure Data Factory a hybrid data integration (ETL) service.
  • Work with data wherever it lives, in the cloud or on-premises, with enterprise-grade security.
  • Profile data and identify data quality issues.
  • Collaborate with project team to identify options to address data quality and make appropriate recommendations.
  • Migrating on-premises applications to Azure PaaS Applications.
  • Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL.
  • Data Ingestion to Azure SQL.
  • Design tables/views/ procedures to apply cleans, truncation, and apply business logic based on requirements.
  • Working on database programming SQL Server using T-SQL queries, stored procedures, views.
  • Perform data updates, indexing for data performances.
  • Design, create, and implement database systems based on the end user's requirements.
  • Create complex functions, scripts, stored procedures, and triggers to support reporting development.
  • Writing SQL, queries for data validation on Azure SQL ADW as part of data quality checks.
  • Optimization of SQL queries to track issues, and document changes.
  • Using joins to retrieve data from one or more tables for single data set for normalizing data to create processed tables based on logic requirement.
  • Develop Complex reports and dashboards as per the business requirements and automate the process to generate and send to users automatically.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.

Data Engineer

Sigma Allied Services Private Limited
08.2021 - 07.2022
  • Analyze, design, and build Modern data solutions using Azure PaaS service to support visualization of data.
  • Understand current Production state of application and determine the impact of new implementation on existing business processes.
  • Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and U-SQL [Azure Data Lake Analytics]. Data Ingestion to one or more Azure Services – (Azure Data Lake, Azure Storage, Azure SQL, Azure DW).
  • Create, schedule, and manage your data integration at scale with Azure Data Factory a hybrid data integration (ETL) service.
  • Work with data wherever it lives, in the cloud or on-premises, with enterprise-grade security.
  • Profile data and identify data quality issues.
  • Collaborate with project team to identify options to address data quality and make appropriate recommendations.
  • Migrating on-premises applications to Azure PaaS Applications.
  • Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL.
  • Data Ingestion to Azure SQL.
  • Design tables/views/ procedures to apply cleans, truncation, and apply business logic based on requirements.
  • Working on database programming SQL Server using T-SQL queries, stored procedures, views.
  • Perform data updates, indexing for data performances.
  • Design, create, and implement database systems based on the end user's requirements.
  • Create complex functions, scripts, stored procedures, and triggers to support reporting development.
  • Writing SQL, queries for data validation on Azure SQL ADW as part of data quality checks.
  • Optimization of SQL queries to track issues, and document changes.
  • Using joins to retrieve data from one or more tables for single data set for normalizing data to create processed tables based on logic requirement.
  • Develop Complex reports and dashboards as per the business requirements and automate the process to generate and send to users automatically.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.

Education

Bachelor’s - Mechanical engineering

Marri Laxman Reddy Institute of Technology
Hyderabad
01.2018

Intermediate -

Chaitanya collage
Hyderabad
01.2013

Schooling -

Sanghamitra school

Skills

  • Azure Data factory
  • Azure Data lake
  • Azure Databricks
  • SQL programming
  • Designing/modifying data warehouses
  • Data integration
  • ETL processes
  • Data migration
  • Data visualization
  • SQL Server programming
  • Microsoft Power BI
  • Analytic Problem-Solving
  • python
  • SSIS

Certification

  • Microsoft Certified- Azure Fundamentals
  • Python Udemy Certified

Personal Information

  • Total Experience: 3+ Years
  • Title: Azure Data Engineer

Timeline

Specialist Data Engineer

Bristlecone PVT LTD
08.2023 - Current

Azure Data Engineer

Bristlecone PVT LTD
08.2022 - 07.2023

Data Engineer

Sigma Allied Services Private Limited
08.2021 - 07.2022

Bachelor’s - Mechanical engineering

Marri Laxman Reddy Institute of Technology

Intermediate -

Chaitanya collage

Schooling -

Sanghamitra school

Similar Profiles

CREATE PROFILE
Sreecharan Bellamkonda