Murtaza Somani

Professional Summary

Microsoft Azure Senior Data Engineer/ Data Warehouse Consultant with experience in data warehouse design and architecture. Worked across the whole spectrum of business intelligence from business analysis to data modelling and ETL/ELT solutions. Over 20 years of hands-on-experience in designing, development, implementation and supporting Business Intelligence Solutions. Experience working with Education, Retail, NHS, Construction, Finance, Logistic and Manufacturing industries.

Key Skills

• Experience of the Microsoft Azure data platform especially: Azure Databricks, Azure Synapse Analytics, Azure Data Factory (ADF), Azure Data Lake (ADLS) and Azure SQL Database.

• Complex data modelling using dimensional Star and Snowflake schema for actuarial analysis.

• Hands on with SQL, T-SQL, stored procedures, MSBI Stack (SSIS, SSRS, SSAS), MDX, DAX, data migration, custom importing and exporting data.

• Good knowledge of ETL, ELT, OLTP, Data Warehouse, Datamart, OLAP and Tabular cube data design.

• Business analysis, mapping requirements to solutions design, estimation, and project management

• Generating Business Operations reports, dashboards and analytics metrics using Power BI and Business Objects.

• Experience working with offshore developers and liaising with other work streams using AGILE methodology.

Primary Technical Skills

• Data Warehouse Architecture, Design and Data Modelling

• Azure Databricks, Azure Synapse, Azure Data Factory V2

• Python, PySpark, Spark SQL, T-SQL, MDX, DAX, C#, VB.Net, ASP.Net, Linq to SQL, Visual Basic 6.0, ASP, Java Script

• Azure SQL, SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 (SSIS, SSRS, SSAS and Tabular), MS-Access

• Power BI (Power Pivot, Power Query, Power BI Desktop), SharePoint Performance Point

• Azure DevOps, CI/CD, TFS, VSTS, Red Gate SQL Toolbelt