Consultant
Current- Migration to Azure
- Migrate SSAS OLAP on-premise cubes (accounting, budgeting, opex, forecasting, oil and gas production, reserves …) into Power BI dataset based on tabular model
- Migrate or create ETL packages from SSIS into Azure Data factory pipelines; sources from on-premise SQL and Oracle, cloud PosgreSQL, Azure SQL and Snowflake, APIs; sinks into Azure Data Lake, Azure Synapse, Azure SQL.
- Migrate or create ETL packages from SSIS into Azure Data factory pipelines; sources from on-premise SQL and Oracle, cloud PosgreSQL, Azure SQL and Snowflake, APIs; sinks into Azure Data Lake, Azure Synapse, Azure SQL.
- Using Azure DevOps Repos to maintain the source control, repositories branching and merge, Pipelines for CI/CD; Boards for Agile sprints and backlog maintenance
- Tools: Visual Studio SSDT and VS Code, SQL Management Studio and Azure Data Studio, Azure Storage Explorer, Tabular Editor and DAX Studio, Power BI Desktop, Databricks portal