Matthew Albayrak

Data Engineer @Cardinal Health Canada

Vaughan, ON, CA

Strong skills in creating and managing Databases, and various database objects like Tables, Views, Indexed Views, Complex Parametrized Stored Procedures, DDL/DML Triggers, Cursors, User Defined Data Types, User Defined Functions and Indexes (clustered, non-clustered, filtered, covering, with included columns, column stored) using T-SQL.· Develop and optimize Extract, Transform, Load (ETL) processes using Azure Synapse for seamless data integration and transformation.· Implement and manage data pipelines to efficiently transfer, transform, and capture metadata across various Azure storage and processing solutions.· Proficient in developing custom business applications using Power Apps, part of the Microsoft Power Platform.· Manage data storage and retrieval strategies within Azure Data Lake Storage, ensuring alignment with best practices and performance requirements.· Develop PySpark, Python applications for distributed data processing, optimizing jobs for performance and scalability.· Skillful in report development using SSRS/Power BI and creating various types of reports and dashboards with drill down/through, parameterized, cascading, conditional, slice and dice, bookmark, ad-hoc and sub reports features.· High-level experience in writing DAX in Power BI and Expert in fine tuning the reports;· Experience with sending email (SSMS, Logic Apps, ADF)· Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments.· Built efficient ETL packages, using Azure Data Factory ADF2 pipelines for processing Fact and Dimension tables with complex transforms and SCD type 1/ type 2 changes.· Scheduled ETL Packages to routinely deliver data into staging table and prepare the data before loading into Data warehouse.

Alaaddin Keykubat University, Turkey

Bachelor's degree