Kranthi Kumar
Senior System Analyst @Sickkids Centre For Global Child Health
Signup · Get unlimited contacts
WORK HISTORY
Senior System Analyst @Sickkids Centre For Global Child Health
Toronto, ON, CA
Maintained and monitored the Azure Data Warehouse, ensuring optimal performance and data integrity.• Managed Azure Dedicated SQL Pool (Formerly SQL Data Warehouse) to store, process, and analyze large-scale EPIC healthcare data.• Developed complex SQL scripts and optimized stored procedures, views, and ETL processes for efficient data extraction and transformation from multiple enterprise systems including Epic (Clarity, Caboodle) and data warehouse environments.• Design, develop, test, and automate ETL/ELT scripts using SSIS, Azure Data Factory (ADF), and SQL Server Integration Services.• Utilize SSMA to migrate data from legacy systems to the Azure SQL Data Warehouse.• Developed, enhanced, and maintained SSIS packages and SSRS reports for high-volume healthcare datasets.• Optimized existing SSIS ETL workflows for performance, leveraging SQL Profiler and tuning techniques.• Performed deep analysis and debugging of legacy SSIS packages to improve reliability and data consistency.• Collaborated with data consumers to translate business logic into optimized SQL stored procedures and reporting queries.• Applied best practices in ETL design and performance monitoring on Azure Data Warehouse.• Worked closely with report writers and end users to design and develop datasets in a normalized structure.• Developed Microsoft Power BI dashboards and reports, ensuring they align with business requirements.• Coordinate with data consumers to translate business needs into actionable Business Intelligence solutions.• Partner with Database Administrators (DBAs), System Administrators, Application Support Teams, and End Users for data-driven decision-making.• Developed and maintained analytical registries within Epic, aligning with integrated care pathways and organizational reporting requirements.• Leverage Epic Hospital Information System expertise to facilitate healthcare data management.
EDUCATION
George Brown College
Health Informatics
ABOUT KRANTHI KUMAR
I am a Senior Data Engineer and Systems Analyst with 6+ years of experience delivering enterprise data and analytics solutions across healthcare, insurance, and banking. Currently at The Hospital for Sick Children (SickKids), I design and optimize Azure-based data platforms that transform complex clinical and operational data into actionable insights.My expertise includes Azure Data Factory, Synapse Analytics, Azure SQL, SSIS, Power BI, and advanced T-SQL development. I specialize in building scalable data warehouses, optimizing ETL/ELT pipelines, performance tuning large workloads, and developing impactful BI dashboards. I have deep experience working with EPIC (Clarity & Caboodle) data models and ensuring compliance with healthcare data governance standards.Previously, I contributed to healthcare transformation initiatives at Providence Health Care, delivered BI and analytics solutions at Canada Life, and built enterprise reporting systems in the banking sector at ICICI Bank.I am passionate about building high-performance cloud data architectures that enable smarter, data-driven decision-making.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.