e
epkabi

Ahamedkabir P

@epkabi

Senior SQL Developer Data Engineer TSQL, SSIS, SSRS, PySpark, AWS 14 Yrs Exper

Indien
Englisch
Einige Informationen werden in englischer Sprache angezeigt.
Über mich
I'm a Senior SQL Developer and Data Engineer with 14+ years of experience building and optimizing enterprise database systems — including 8+ years of deep, hands-on T-SQL and SQL Server work, and recent experience with PySpark, AWS, and cloud data pipelines. I specialize in: Fixing slow, underperforming SQL queries and stored procedures Query optimization, indexing strategy, and execution plan analysis Building and troubleshooting SSIS ETL pipelines Designing SSRS reports and dashboards Data warehouse and dimensional modelling (star schema) Excel automation, VBA, and data cleanup... Mehr lesen

Kompetenzen

e
epkabi
Ahamedkabir P
offline • 

Meine Dienstleistungen

Datenbank-Entwicklung
I will optimize sql server, tsql, and pyspark data solutions

Arbeitserfahrung

Senior SQL Developer Data Engineer Technical Lead

HCL Technologies • Vollzeit

Dec 2017 - Jul 2026 • 8 yrs 7 mos

**Senior SQL Developer & Data Engineer / Technical Lead** Enterprise IT Services | 2017 – 2026 I bring 14+ years of IT experience, including 8+ years of deep, hands-on SQL Server development and 4+ years of Big Data and AWS Cloud experience, gained delivering mission-critical systems for large enterprise clients in the energy and telecommunications sectors. **SQL Server & Database Development:** I led the SQL development lifecycle for a high-availability enterprise reporting platform supporting 1,000+ daily users, owning everything from database design to production support. My work included designing and optimizing complex stored procedures, views, functions, and CTEs for high-volume OLTP and OLAP workloads processing millions of records daily. I improved query performance by up to 35% through execution plan analysis, targeted indexing strategies, and resolving issues like parameter sniffing and blocking/deadlocks. I also built and maintained SSIS ETL pipelines and SSRS reporting dashboards, and owned end-to-end production governance — change management, deployment coordination, and root cause analysis for critical incidents. **Big Data & Cloud Engineering:** Alongside my SQL Server work, I designed and delivered scalable PySpark data pipelines on AWS EMR, processing large-scale structured and semi-structured datasets for enterprise analytics. I built S3-based data lake architecture using a medallion (bronze/silver/gold) design pattern, and improved Spark job performance by 30-40% through partition tuning, broadcast joins, and executor optimization. I orchestrated these pipelines end-to-end using Apache Airflow and AWS Step Functions, with retry logic and failure alerting to maintain reliable, SLA-compliant data delivery.