The role was to migrate the on-prem Microsoft SQL Server data into Azure, improving various product features/reports for a large Pharma group. Their current infrastructure contained Azure Synapse and Data Lake structures using Data Factory Pipelines as a bridge between on-prem and cloud. Many Power BI reports, complex on-prem ETLs and Machine Learning algorithms were the foundation for the product team decisions.

Used technologies:

Azure Synapse, Microsoft Power BI, Microsoft SQL Server, SSIS, SSAS, SSRS, Azure Data Factory, Azure Data Warehouse, Azure Data Lake, MQuery, DAX, Machine Learning.