Sum Kmr

ETL Production Support Engineer with 5+ years of experience managing mission-critical data pipelines processing 600M–700M messages daily at 99.9%+ uptime. Expertise in incident management, root-cause analysis (RCA), and permanent defect remediation across Ab Initio (GDE, Control Center, EME, Co>Operating System) environments. ITIL-aligned support lead with deep hands-on experience in SMPP/A2P telecom platforms, zero-downtime infrastructure operations, and full-stack observability (Dynatrace, Grafana, Kibana).

Consistent record of reducing MTTR, automating manual workflows, and delivering measurable reliability improvements.

Production Support Lead at Hoonar Tekwurks Pvt Ltd (2022-10 – Present)

Owned end-to-end production stability of Ab Initio ETL and DLT Blockchain platform processing 600M–700M messages daily, sustaining 98.9%+ pipeline uptime across 12+ consecutive months.

• Owned end-to-end production stability of Ab Initio ETL and DLT Blockchain platform processing 600M–700M messages daily, sustaining 98.9%+ pipeline uptime across 12+ consecutive months.
• Led full incident management lifecycle for all P1/P2 incidents; identified 8 recurring defect patterns and implemented permanent fixes, reducing repeat ticket volume by 35% within 6 months.
• Managed SMPP-based A2P messaging pipelines for high-volume SMS traffic; applied Wireshark packet inspection to diagnose bind failures, routing issues, and throughput bottlenecks.
• Automated 15+ recurring batch and continuous workflows in Ab Initio Control Center, eliminating 30% of manual operational effort and reducing overnight on-call alerts by 40%.
• Commanded change management lifecycle for 100+ production deployments within strict maintenance windows — zero unplanned outages attributed to change in FY 2024.
• Built and maintained observability stack (Dynatrace, Grafana, Kibana, Power BI, Azure Monitor), reducing incident detection time from hours to under 15 minutes.
• Orchestrated security patching and infrastructure upgrades across 350+ production nodes with zero service interruption; eliminated 100% of critical CVEs within SLA.
• Authored system architecture diagrams, operational runbooks, and DR plans — reduced MTTR by 25% and cut new engineer onboarding time by 50%.
• Ensured TRAI and data governance compliance for high-volume ingestion pipelines; passed 100% of regulatory audits with zero compliance findings.
• Expanded skills in Apache Kafka (consumer lag metrics, topic management) and IBM MQ / JMS (queue depth monitoring, pub/sub patterns) to support real-time streaming integrations.

ETL Support Engineer at Hoonar Tekwurks Pvt Ltd (2020-10 – 2022-10)

Developed and maintained Ab Initio graphs for data ingestion from on-premises Oracle and SQL sources, migrating 5+ source systems processing 50M+ records per load cycle.

• Developed and maintained Ab Initio graphs for data ingestion from on-premises Oracle and SQL sources, migrating 5+ source systems processing 50M+ records per load cycle.
• Performed Ab Initio Co>Op job monitoring, DML scripting, and sandbox management to ensure pipeline stability and data accuracy.
• Built reusable data quality validation framework (null checks, duplicate detection, row-count reconciliation), catching 500+ data integrity issues before production deployment.
• Implemented GST and DCMS data governance standards across 3 data domains, achieving 100% compliance on all quarterly audits.
• Created comprehensive ETL and support documentation suite, reducing L1 resolution time by 20% and accelerating team ramp-up from 3 weeks to 10 days.

Bachelor of Engineering in Electronics & Communication Engineering – Lakshmi Narayan College of Technology (2016 – 2020)