Karthik Sudhala

• Developed and optimized SQL stored procedures, views, and indexing strategies for enterprise healthcare data systems. • Administered and monitored SQL Server environments, ensuring 99.9% uptime, high performance, and robust security controls. • Implemented backup, recovery, and failover strategies to ensure business continuity and data reliability. • Administered and monitored SQL Server environments, ensuring 99.9% uptime, high performance, and robust security controls. • Implemented backup, recovery, and failover strategies to ensure business continuity and data reliability. • Designed and built ETL pipelines using Informatica IICS and SSIS, integrating large data volumes from multiple sources. • Created advanced Power BI and Tableau dashboards for financial, operational, and compliance reporting. • Automated system health checks, ETL monitoring, and report generation using PowerShell and Python scripts. • Migrated databases from on-premises to AWS RDS, optimizing performance and reducing costs by 35% • Collaborated with DevOps teams to streamline database deployment using Jenkins and Git. • Ensured data governance, access management, and HIPAA compliance for sensitive healthcare information. • Worked closely with cross-functional teams in Agile sprints to deliver high-quality, data-driven solutions.

Engineered end-to-end ETL using SSIS and Informatica across CRM, ERP, billing, and support platforms. Developed stored procedures, functions, and views enabling self-serve analytics and curated marts. Optimized ETL by applying partitioning, window functions, and parallelization; throughput +50%. Implemented robust error handling and retry logic with audit tables, email/SMS notifications. Designed star schemas and dimensional models (facts for orders, invoices, renewals; conformed dims). Built scheduling/orchestration with SQL Agent; parameterized configurations per environment. Implemented CDC and incremental merge patterns to minimize load windows and lock contention. Created monitoring dashboards in Power BI to track job SLAs, durations, and bottlenecks. Supported migration from on‐prem SQL Server to AWS RDS with data validation and cutover plans. Collaborated with stakeholders to prioritize backlog; delivered iteratively in 2‐week sprints. Authored runbooks, deployment checklists, and rollback procedures; improved release confidence. Mentored juniors on SSIS patterns, logging, and package deployment (ISPAC). Standardized naming conventions, code style, and branching strategy for ETL repositories. Built data quality rules (completeness, uniqueness, referential integrity) enforced in staging.

• Designed and developed ETL workflows using Informatica Power Center and SSIS to consolidate data from Oracle, SQL Server, and flat files. • Created optimized SQL queries and database objects to support analytics and data warehousing operations. • Built Tableau dashboards and Power BI reports for KPI visualization and management insights.• Implemented database user access controls and maintained compliance with healthcare data standards. • Developed Python scripts for data cleaning, automation, and API integration. • Participated in client discussions, requirement gathering, and system design sessions to align technical solutions with business goals.