Somasekhar Reddy Reddy

Data Professional

Bangalore, India 3+ yrs exp 87 · Excellent

About

Data Professional with 3.7 years of experience in Azure Data Engineering, SQL Development, and BI solutions using Azure Data Factory (ADF), Azure Databricks, PySpark, SQL Server, Azure SQL Database, Power BI, Python, and Microsoft Fabric. Experienced in building scalable ETL/ELT pipelines, Data Warehousing, cloud data platforms, and analytics solutions using ADF orchestration, Databricks, Spark SQL, Delta Lake, Delta Tables, and Medallion Architecture. Strong expertise in CDC, MERGE operations, Incremental Loading, Schema Evolution, Spark optimization, T-SQL, Stored Procedures, Views, Functions, CTEs, Window Functions, Indexing, Query Optimization, and Performance Tuning. Skilled in Data Modeling, Star Schema, Fact & Dimension Tables, SCD Type 1/2, Power BI dashboards, DAX, Power Query, KPI reporting, Drill-through, and RLS. Hands-on experience with ADLS Gen2, Azure Key Vault, Azure DevOps, Git, CI/CD, REST APIs, Agile, UAT, production support, RCA, and delivering secure, scalable data solutions through data integration, transformation, analytics, and reporting.

Skills & Expertise (76)

Azure Databricks Advanced

8.0/10

3.7

Years Exp

Azure Data Factory Advanced

8.0/10

3.7

Years Exp

PySpark Advanced

8.0/10

3.7

Years Exp

Azure SQL Database Advanced

7.5/10

3.7

Years Exp

Azure Synapse Analytics Advanced

7.5/10

3.7

Years Exp

SQL Server Advanced

7.5/10

3.7

Years Exp

T-SQL Advanced

7.5/10

3.7

Years Exp

Python Advanced

7.5/10

3.7

Years Exp

Git Advanced

7.0/10

3.7

Years Exp

KPI Dashboards Fact Tables Calculated Columns Measures Semantic Models M Language Power Query DAX Power BI Service Power BI Desktop SCD Type 2 Snowflake Schema Star Schema Dimension Tables Scrum REST APIs Agile Cd pipelines Azure DevOps Parquet Excel CSV XML JSON Drill-through NumPy Pandas Performance Analyzer Incremental Refresh Row-Level Security Bookmarks Tooltips Spark DataFrames Batch Processing Merge Operations CDC ELT ETL Medallion Architecture Delta Tables Delta Lake Schema Evolution Spark SQL Lakehouse OneLake Microsoft Fabric Azure Logic Apps Azure Monitor Azure Key Vault Azure Blob Storage Triggers Performance Tuning Query Optimization Execution Plans Indexing Subqueries Joins Window Functions CTEs Data Modeling Functions Views Stored Procedures Azure SQL Cache partitioning Optimize

Work Experience

Software Engineer – Data Engineering & BI

SmartConnect Technologies Pvt. Ltd.

Dec 2023 - Apr 2026

Designed and developed enterprise ETL/ELT solutions using Azure Data Factory, Azure Databricks, PySpark, SQL Server, Azure SQL Database, ADLS Gen2, Azure Synapse Analytics, and Power BI. Developed 30+ ADF pipelines using Linked Services, Datasets, Integration Runtime, Parameters, Variables, Lookup, ForEach, Triggers, and Dynamic Expressions for automated data ingestion. Built PySpark transformation frameworks using Spark SQL, DataFrames, Window Functions, Broadcast Joins, Delta Lake, CDC, MERGE, Incremental Loads, and Medallion Architecture. Optimized Databricks workloads using repartition, cache, persist, partition pruning, predicate pushdown, AQE, Delta OPTIMIZE, Z-ORDER, and VACUUM. Developed advanced SQL and Data Warehouse solutions using Stored Procedures, Views, Functions, CTEs, Window Functions, MERGE, Indexing, Query Optimization, Star Schema, and SCD. Delivered Power BI dashboards, CI/CD deployments, and production support using DAX, Power Query, Row Level Security.

SQL BI Developer – Data Engineering & BI

Sanfony Technologies Pvt. Ltd.

Aug 2022 - Sep 2023

Developed analytics-ready datasets using SQL Server, Azure Data Factory, Azure Databricks, and PySpark for enterprise reporting and business analytics. Built ADF pipelines and Databricks workflows for data ingestion, batch processing, data cleansing, transformation, validation, and curated data preparation. Developed PySpark solutions using Spark SQL, DataFrames, joins, and transformations to process large-volumed datasets. Created optimized T-SQL solutions using Stored Procedures, Views, CTEs, Window Functions, Indexing, Query Optimization, and business logic for Sales, Production, Manufacturing, Agriculture, and Nutrition analytics. Designed Power BI dashboards using DAX, Power Query, Star Schema, Data Modeling, KPI reports, Drill-through, and RLS for business insights. Performed data validation, reconciliation, performance tuning, UAT support, production fixes, and stakeholder collaboration.