Ahamedkabir P
Senior SQL Developer Data Engineer TSQL, SSIS, SSRS, PySpark, AWS 14 Yrs Exper
Compétences
Voir mes services

Expérience professionnelle
Senior SQL Developer Data Engineer Technical Lead
HCL Technologies • Temps plein
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.