Minneapolis, Minnesota, United States
Architecting cloud solutions ☁️ Excited about data, storage, virtualization, networking, monitoring, and security. Recent competencies: Snowflake, DBT, Octopus
Consulting at large and small companies in the following industries: - Health care - Transportation / logistics - ISP - Manufacturing - Oil/Refinery Developed and advised on: - Analytical models on most platforms - Azure Data Factory - Azure Data Lake Gen2 - Azure DevOps - Azure SQL - Azure Logic Apps - Azure Synapse - Azure/On Premise Analysis Services Models - Power BI Governance - Power BI Embedded - Power App Portals - Dimensional data warehousing (Kimball) - SQL modelling, replication, syntax, CTEs, optimization - Azure Data Sync - (AWS) Snowflake - (AWS) DBT - CDM / Dataverse
Coordinated and developed a distributed data migration (on-premises IBM DB2 to Azure), analytical modelling, reporting, and mass delivery solution for a large alcohol distribution company
Designed, developed and deployed Azure business intelligence solutions for companies in following industries: - Manufacturing - Medical - National bank survey - Distribution Built secure, automated systems to carry and consolidate disparate data sources in Azure. Delivered Microsoft Power BI Dashboard in a Day training, as well as a deep dive course into advanced Power BI topics based on content developed by myself. Leveraged many Azure resources to support solutions, including: Data Integration: - Azure Data Factory - SSIS - Azure Logic Apps - Azure Blob Storage / Azure Data Lake Storage Gen2 - Azure SQL Server / On-Prem SQL Server Data Modeling/Reporting: - Azure Analysis Services / On-Prem AS - Power BI - DAX - Excel - T-SQL - Power Apps CI/CD: - Azure DevOps - Azure Repos, GitHub