Data Engineer at Amaris, Toronto, ON

Built and tailored Power BI reports to client requirements and strategically implemented data partitioning and distribution in Azure Synapse for performance and scalability. Developed and maintained data synchronization across systems, managed SSRS reports deployment, and implemented data masking in Snowflake. Leveraged Azure Purview for data retention policies, managed Azure Databricks integration, and enhanced ETL performance with tuning strategies. Collaborated on branching models for deployments and optimized data lake integration with Azure Logic Apps. Developed Python applications for financial analysis, utilized Azure Data Bricks MLflow for ML experiments, and conducted anomaly detection using unsupervised methods. Engaged in advanced data transformation within Azure Data Factory and Snowflake data cataloging, while ensuring report localization and multi-language support.

Senior Analyst Data Engineer at Home Depot, Toronto, ON

Established scalable processes for large-scale data analysis and report implementation. Communicated analytics insights to technical and non-technical teams, designed and created SQL-based reports, and collaborated with architects to ensure proper system design. Tuned performance, conducted data profiling, and developed complex stored procedures and SQL queries. Led business requirements gathering workshops, implemented comprehensive report types, and designed visualizations in Tableau. Supported testing phases and user acceptance, and provided post-implementation maintenance.

BI Developer at Co-operators, Guelph, ON

Worked with product owners to identify requirements and develop design specifications and data dictionaries. Designed and developed ETL strategies using SSIS, implemented data cleansing techniques, and utilized Azure Functions for serverless ETL operations. Managed DataStage job flows, change data capture, and created reusable jobs across heterogeneous sources. Supported business users during testing, converted legacy reports to Power BI, and developed dashboard visualizations using diverse data sources. Configured Power BI gateway for real-time updates and monitored database performance using automated schedules and performance dashboards.

BI Developer at HCL, Hyderabad, IN

Collaborated with product owners to analyze requirements and authored technical documentation. Developed SQL Server stored procedures and dynamic SSIS packages, created testing scripts, and implemented performance-improving concepts like materialized views. Managed DataStage Designer and Director activities including job scheduling, debugging, and monitoring. Conducted migration of ETL packages to Azure Data Pipelines and developed Power BI dashboards integrated with SharePoint. Applied dimensional modeling techniques and automated deployments using TeamCity and Octopus.

BI Developer at Genpact, Hyderabad, IN

Gathered requirements and developed use case stories with stakeholders. Automated SSIS package development using PowerShell and extensive BIML scripting. Developed complex T-SQL stored procedures and functions, performed dimensional modeling, and built custom ETL frameworks with logging and auditing. Produced and maintained Power BI dashboards and content packs, converted legacy reports to newer BI tools, and analyzed web analytics using Google Analytics. Supported data migration from on-premises to Azure cloud.

Data Engineer at Amaris

Built Power BI reports from scratch and tailored dashboards to client requirements. Implemented data partitioning strategies in Azure Synapse to optimize performance on large datasets and designed scalable data models for analytics. Developed and maintained ETL workflows using SSIS and Data Factory, integrating data from multiple sources including SQL Server, Oracle, SAP sources, and cloud storage. Implemented data masking/anonymization in Snowflake and established data retention rules with Azure Purview. Created and deployed SSRS reports across development, test, and production environments; enabled data governance and lineage. Wrote optimized SQL scripts and stored procedures, and supported monitoring for performance and capacity planning. Collaborated with data science teams via Azure Databricks and MLflow to support analytics initiatives. Coordinated with version control (Git) and implemented deployment pipelines in Azure DevOps. Implemented automated data pipeline orchestration wi

Senior Analyst Data Engineer at The Home Depot

Established scalable processes for large-scale data analyses and reporting. Led status updates to management on complex development projects. Communicated analytics concepts to technical and non-technical stakeholders. Assessed viability of packages and products for solutions. Designed reports per client requirements and created dashboards using SQL and visualization tools. Gained understanding of DW concepts (Dimensional Modeling, CDC, SCD) and performed performance tuning, data profiling, and validation. Built and tuned complex SQL queries and stored procedures; documented functional specs and training materials. Led requirements-gathering workshops and coordinated UAT. Worked with multiple data sources (SQL Server, Google BigQuery, AWS Analytics) and deployed reports via Power BI/Tableau.

BI Developer at Co-operators

Designed and developed ETL strategies using SSIS; leveraged DataStage for cross-source extraction (Oracle, DB2, flat files). Implemented data cleansing, file movement, and data loading into data lake/Blob storage. Created complex SQL queries and stored procedures; implemented DataStage CDC for DB2/Oracle. Built and deployed Power BI reports and dashboards; configured Azure Functions to invoke data pipelines based on Data Lake events. Worked with business users for UAT and delivered reports in SharePoint-integrated environments; performed data migration to Azure Data Lake/Blob storage.

BI Developer at HCL

Developed SSIS packages with robust control and data flow elements; contributed to cloud data warehousing through lift-and-shift to Azure Data Pipelines. Created and optimized reports in Power BI; supported data distribution via SharePoint. Implemented DataStage for cross-source integration, including CDC for DB2/Oracle files, and built reusable ETL jobs for ingestion from Oracle, DB2, and flat files.

BI Developer at Genpact

Used BIML to automate SSIS development; built Power BI dashboards and content packs. Migrated reports from legacy systems to SSRS, Tableau, and Power BI. Modeled data using star/snowflake schemes; developed data warehouses and performed data visualization for operational and research data. Led data migration from on-premises to Azure SQL and created dashboards in Tableau and Power BI; supported BI governance and reporting deliverables.

Data Engineer at Amaris

Lead the development of Power BI reports from scratch and tailor them to client requirements. Strategically implemented data partitioning and distribution strategies in Azure Synapse to optimize performance for large datasets. Built and maintained data models in Power BI ensuring data integrity, performance, and scalable storage. Orchestrated deployment of SSRS reports across development, test, and production environments. Implemented data partitioning in OLAP/OLTP databases for efficient data management. Applied data masking and anonymization in Snowflake to protect sensitive data while maintaining usability. Implemented PostgreSQL best practices for performance. Used Azure Purview to enforce data retention policies. Integrated Azure Databricks with data science workflows. Tuned ETL performance and optimized data lake integration via Azure Logic Apps. Established a branching strategy for environment-specific branches. Implemented database recovery and rollback procedures. Managed acce