Dhanu Sampath kumar

Dhanu Sampath kumar

Data Engineering Expert
Canada

About Me

Senior Data Engineer with 10+ years of experience designing and implementing scalable data pipelines, ETL processes, and enterprise data integrations across healthcare, insurance, and financial services industries. Exten…

Experience

Senior Data Engineer

SS&C Technologies – Toronto, ON
Apr 2025 - Present · 1 year 3 months

Lead development of ETL pipelines using SQL Server Integration Services (SSIS) and KingswaySoft for data migration into Microsoft Dynamics 365 and Salesforce.
Designed and optimized data integration workflows between SQL Server and CRM systems, improving data accuracy and reducing integration failures.
Support and enhance Azure-based data movement solutions using Azure Data Factory and Azure SQL Database.
Perform data quality validation and troubleshoot ETL pipelines to ensure accurate CRM data migration.
Improved ETL pipeline performance by optimizing SQL queries and transformation workflows, reducing data processing time by 30% and improving overall data load efficiency for large-scale CRM integrations.
Collaborate with cross-functional teams including sales, marketing, and IT to deliver reliable CRM data integration solutions.

Senior Data Engineer

SS&C Technologies – Toronto, ON
Apr 2025 - Present · 1 year 3 months

Lead development of ETL pipelines using SQL Server Integration Services (SSIS) and KingswaySoft for data migration into Microsoft Dynamics 365 and Salesforce., Designed and optimized data integration workflows between SQL Server and CRM systems, improving data accuracy and reducing integration failures., Support and enhance Azure-based data movement solutions using Azure Data Factory and Azure SQL Database., Perform data quality validation and troubleshoot ETL pipelines to ensure accurate CRM data migration., Improved ETL pipeline performance by optimizing SQL queries and transformation workflows, reducing data processing time by 30% and improving overall data load efficiency for large-scale CRM integrations., Collaborate with cross-functional teams including sales, marketing, and IT to deliver reliable CRM data integration solutions.

Data Engineer

SS&C Technologies – Toronto, ON
Oct 2021 - Mar 2024 · 2 years 5 months

Developed ETL solutions using SQL Server Integration Services (SSIS) and KingswaySoft to migrate enterprise data from SQL Server into Microsoft Dynamics 365 CRM and Salesforce.
Built data transformation pipelines to support CRM integration, reporting, and downstream data processing.
Conducted data profiling and database analysis to understand CRM data structures and support migration planning.
Assisted in cloud migration initiatives involving Microsoft Azure data services including Azure Data Factory.

Data Engineer

SS&C Technologies – Toronto, ON
Oct 2021 - Mar 2024 · 2 years 4 months

Developed ETL solutions using SQL Server Integration Services (SSIS) and KingswaySoft to migrate enterprise data from SQL Server into Microsoft Dynamics 365 CRM and Salesforce., Built data transformation pipelines to support CRM integration, reporting, and downstream data processing., Conducted data profiling and database analysis to understand CRM data structures and support migration planning., Assisted in cloud migration initiatives involving Microsoft Azure data services including Azure Data Factory.

Software Configuration, Senior Technology Analyst

LifeWorks (formerly Morneau Shepell, now part of TELUS) – Toronto, ON
Mar 2016 - Sep 2021 · 5 years 6 months

Built HR data pipelines and custom ETL processes to extract, transform, and load data into dimension and fact tables.
Developed SQL queries and scripts to generate premium reports, billing statements, and data validations.
Performed data profiling, reconciliation, and validation to ensure accuracy across HRIS data systems.
Maintained data interfaces and system configurations supporting enterprise reporting solutions.
Collaborated with cross-functional teams to analyze data discrepancies and improve reporting accuracy.

Network Engineer, Technology Analyst

Sify Technologies | Chennai, India
Aug 2013 - Aug 2014 · 1 year

Performed advanced data profiling and analysis using SQL to support enterprise data migration initiatives.
Recognized with “Hero of the Month” award for successful project delivery supporting North American clients.

Skills

Python Structured Query Language (SQL) Microsoft SQL Server T-SQL Power BI Salesforce SQL Server Integration Services KingswaySoft Azure Data Factory Azure SQL Database Microsoft Dynamics 365 Power Apps Git SQL Server Integration Services (SSIS)
Report this Profile?