Senior Data Engineer

• Nov 2022 - Present

Senior Data Engineer

• Jan 2022 - Nov 2022

• Implement modern data warehouse architecture design. • Build ELT processes with staging, curated and aggregated layers. • Optimize database and stored procedures for performance and stability. • Automate business processes using ADLS, data factories and logic apps. • Design and Implement CI/CD deployment pipelines. • Implement modern data warehouse architecture design. • Build ELT processes with staging, curated and aggregated layers. • Optimize database and stored procedures for performance and stability. • Automate business processes using ADLS, data factories and logic apps. • Design and Implement CI/CD deployment pipelines.

Senior Data Analytics Consultant

• Jan 2017 - Oct 2021

• Interact with the client through workshops, stand-ups, and project/status meetings. • Gather and document requirements and translate them into data engineering tasks. • Design conceptual, logical, and physical data using Kimball methodology. • Develop and lead data warehouse projects using Azure and on-prem infrastructure. • Hands on experience with deploying the code using CI/CD pipelines. • Follow agile methodologies using Azure DevOps. Conduct backlog-grooming, standups, peer reviews, and retrospectives.

Senior SQL Developer

• Apr 2016 - Jan 2017

• Develop BI solutions using T-SQL, SQL, MDX and XMLA • Develop and support databases, SSIS, SSAS solutions and SSRS reports • Develop and support PowerShell scripts for SQL Server management • Monitor and tune databases and processes using SQL Server tools • Address data quality issues and ensure database integrity, stability and availability • Share knowledge and mentor team members and end users as needed • Perform the design and extensions of existing models • Manage capacity planning, disaster recovery and performance analysis

Database Analyst and Business Intelligence Developer

• Mar 2012 - Apr 2016

• Maintain SQL Server high availability, security, performance, integrity, disaster recovery plans and backups for SQL Server instances running from SQL Server 2008 through to SQL Server 2014. • Develop and support high performance ETL using SQL and SSIS. • Develop and support high availability solutions using HA groups, replication, log shipping, SQL Server clustering and mirroring. • Perform capacity planning, performance tuning, monitoring, troubleshooting and optimization of databases and reports. • Develop SSAS databases for POS Sales, Financial Reporting and Planning, and demand planning. • Peer code review for other SQL developers and promote code into production. • Develop Cognos BI Reports and Framework Manager packages. • Develop Tm1 TI processes, cubes, cube rules and feeders. • Maintain Tm1 security and monitor performance. • Responsible for developing and supporting Cognos Business Intelligence and Cognos Tm1 for Performance Management.

SQL Developer

• Oct 2010 - Mar 2012

• Design and develop SQL Server backend for ecommerce projects using SQL Server 2008R2. • Develop web services using C# Freight and ERP integration. • Develop frontend customizations using HTML, JavaScript, jQuery, and CSS. • Develop integration logic using Dynamics AX 2009 AIF web services for integration of sales orders, customer, contacts, and address into the ERP system using C# • Develop automation test scripts using Selenium. • Design and develop SQL Server backend for ecommerce projects using SQL Server 2008R2. • Develop web services using C# Freight and ERP integration. • Develop frontend customizations using HTML, JavaScript, jQuery, and CSS. • Develop integration logic using Dynamics AX 2009 AIF web services for integration of sales orders, customer, contacts, and address into the ERP system using C# • Develop automation test scripts using Selenium.

Senior Consultant

• May 2008 - Oct 2010

• Design and develop Analysis Services OLAP cubes, write-back processes. • Develop complex cube calculations using MDX queries. • Develop ETL processes using SQL and SSIS packages to import data from various sources. • Perform database migration, maintenance and optimization. • Develop test scripts and facilitate testing sessions with clients to ensure the requirements are met. • Provide technical design & support documentation to clients. • Design and develop Analysis Services OLAP cubes, write-back processes. • Develop complex cube calculations using MDX queries. • Develop ETL processes using SQL and SSIS packages to import data from various sources. • Perform database migration, maintenance and optimization. • Develop test scripts and facilitate testing sessions with clients to ensure the requirements are met. • Provide technical design & support documentation to clients.

Software & Database developer

• Oct 2003 - Apr 2008

• Design and develop data warehouse schema using Sybase Power Designer. • Design, develop and support web based Customer Management solutions using Microsoft Technologies. • Design, develop and support ETL processes using T-SQL and DTS/SSIS. • Monitor software performance and isolate areas for improvement. • Develop documentation for use cases, project scope, proto-types, user manuals and development designs. • Design and develop data warehouse schema using Sybase Power Designer. • Design, develop and support web based Customer Management solutions using Microsoft Technologies. • Design, develop and support ETL processes using T-SQL and DTS/SSIS. • Monitor software performance and isolate areas for improvement. • Develop documentation for use cases, project scope, proto-types, user manuals and development designs.

Developer

• Sep 1997 - Nov 2002

• Scope projects and document deliverables, costs, constraints, risks and priorities. • Facilitate application development sessions to gather system and business requirements. • Develop and implement solutions to assist in the detection of fraudulent banking activities. • Support internal solutions and maintain technical documentation. • Database analyst supporting SQL Server 7/2000 and Access databases holding national branch losses for CIBC and President’s Choice Financial. • Produce ad-hoc and month-end reports and research database any discrepancies. • Develop and support a national loss tracking system developed in Access7 & SQL Server. Insure the databases integrity and security. • Build ETL processes for data-mart with GL losses downloaded from the mainframe and produce monthly reports for trend analysis.