Led data engineering initiatives supporting compensation and payroll analytics for North American operations. Designed scalable cloud-based data pipelines and optimized financial reporting systems across global teams. Designed and optimized ETL pipelines processing large-scale payroll and revenue datasets using SQL Server, SSIS, Databricks, and Azure Data Factory. Implemented Azure Data Factory pipelines to orchestrate ingestion from on-premises and cloud systems. Improved SQL performance by up to 40% through indexing strategies, execution plan analysis, and partitioning. Automated data cleansing and reconciliation workflows using Python and SQL, reducing manual intervention. Built executive-level Power BI dashboards tracking revenue, KPIs, and compensation metrics. Implemented data validation frameworks ensuring high accuracy and compliance of financial data. Established ETL best practices, version control standards, and governance frameworks. Mentored data engineers and analysts, improving team delivery standards and technical consistency. Supported Azure storage optimization, backup, and recovery strategies for business continuity.

Delivered enterprise data integration and reporting solutions focused on payroll and compensation systems across multiple business units. Designed and maintained SSIS-based ETL pipelines integrating large-scale compensation and payroll datasets. Developed complex T-SQL stored procedures for transformation, validation, and aggregation. Built interactive Power BI and SSRS dashboards for compensation analytics and audit reporting. Integrated SAP Commissions with Azure SQL and enterprise data sources. Optimized ETL packages and SQL jobs, reducing execution time and improving system reliability. Conducted root cause analysis on data inconsistencies and implemented corrective measures. Created technical documentation, data dictionaries, and mapping standards. Enforced data security and access control aligned with regulatory requirements. Mentored junior developers and supported production deployments.

Supported enterprise reporting and business process automation through SQL-based analytics and ETL development. Developed SSIS workflows automating data extraction from legacy systems. Built SSRS reports supporting finance, HR, and operations departments. Designed SQL queries and stored procedures for reconciliation and analytics. Implemented data validation and audit controls to improve reporting accuracy. Automated reporting tasks using Python scripts. Improved system performance through SQL query optimization and job scheduling improvements.