e
epkabi

Ahamedkabir P

@epkabi

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

India
Inglés
Parte de la información aparece en idioma inglés.
Sobre mí
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... Lee más

Habilidades

e
epkabi
Ahamedkabir P
desconectado • 

Revisa mis servicios

Desarrollo de base de datos
I will optimize sql server, tsql, and pyspark data solutions

Experiencia laboral

Senior SQL Developer Data Engineer Technical Lead

HCL Technologies • Tiempo completo

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.