SUMMARY

• Microsoft business intelligence expert in the design, development, and administration of solutions to enable superior decision making, productivity, and collaboration. Architectural, project and technical leadership experience in translating business objectives and policies into robust, scalable, and efficient solutions and BI architectures.
• Provides advisory consulting services, training, and solution design and development with latest Microsoft Azure data and BI tools and services including Power BI, Azure SQL Database, and Azure Synapse Analytics (SQL Data Warehouse). Advanced knowledge in Microsoft data and adminstrative programming languages including DAX, Power Query (M), T - SQL, and PowerShell.
• Author of two well-regarded books from Packt Publishing - Mastering Microsoft Power BI and the Microsoft Power BI Cookbook. Regular public speaker at large technology conferences such as the Power Platform World Tour and the Data & BI Summit, former co-organizer of the Boston Microsoft BI Users Group, and an active technical blogger (Insight Quest).

TECHNICAL SKILLS

• Power BI
• Azure Analysis Services and SQL Server Analysis Services (SSAS)
• Azure SQL Database and SQL Server Database
• Azure Synapse Analytics (SQL Data Warehouse)
• Azure Active Directory
• Azure Automation
• Power BI Report Server and SQL Server Reporting Services (SSRS)
• Azure Data Factory
• SQL Server Integration Services (SSIS)
• Office 365
• T-SQL and standard SQL
• DAX (Data Analysis Expressions)
• M (Power Query Mashup Language)
• PowerShell
• TMSL (Tabular Model Scripting Language)
• KQL (Kusto Query Language)

PROFESSIONAL EXPERIENCE

Confidential

MSBI and Power BI Architect

Responsibilities:

• Lead Power BI architect driving architecture and governance decisions including Power BI Premium capacity and Pro license provisioning and allocation, user training and support, Dev & Prod environment configuration, reference diagrams and governance documents.
• Developed large-scale analytical models via Power BI Datasets and Azure Analysis Services to serve as semantic layer for data visualization, report development, and ad hoc analysis.
• Implemented row-level security policies in Azure Synapse Analytics (SQL DW) and within Power BI data models
• Delivered performance-enhancing recommendations on Azure Synapse Analytics data warehouse including partitioning schemes, sorted columnar indexes, and the use of materialized views
• Developed custom paginated reports with advanced T-SQL stored procedures
• Developed and deployed custom administration solutions to help manage Power BI and Azure environment.
• Performed assessments of multiple Power BI environments to identify risks, inefficiences, and opportunities
• Served as strategic advisor and technical architect for multiple Power BI and Azure deployments including target solution architecture, resources, licensing, user training, governance and administration.
• Served as escalation point for top stakeholders of clients to troubleshoot urgent, high impact issues related to availability, performance, security, and data accuracy.
• Led Power BI administration and monitoring efforts including development of custom, PowerShell-based administration solutions for logs and metadata associated with Power BI and Analysis Services.
• Created target architecture diagrams and led architecture meetings including server topologies and hardware requirements to support multiple environments (Dev, Test, Prod) for both Azure and On-Premises environments
• Converted client requirements and current state processes into modern and/or enhanced MSBI solutions leveraging Power BI, SQL Server Analysis Services and Azure Analysis Services, and other MS Azure technologies.
• Delivered MSBI and Power BI training at global events including the Power BI World Tour in New York and Seattle, the Data & BI Summit in Dublin, and the Power BI User Group Academy.
• Engaged with customers on current state analyses, ‘quick wins’, Power BI proof-of-concept (POC) projects, and Analysis Services development and tuning scenarios.
• Authored two advanced, technical books on Microsoft Power BI - Mastering Power BI and Microsoft Power BI Cookbook.
• Published many technical blogs highlighting development and administration scenarios, tools, and techniques
• Designed Analysis Services 2017 (1400 compatibility level) and 2019 (1500 compatibility level) Tabular Models including advanced DAX measures, detail row expressions, and supporting PowerShell and Tabular Model Scripting Language (TMSL) scripts.
• Provided performance tuning advisory and development services for existing SSAS Tabular models
• Developed custom paginated operational reporting solutions targeting Power BI Report Server and Power BI via both T-SQL queries against SQL Server and DAX queries against Analysis Services Tabular database leveraging report parameters and expression-based formatting.

Confidential

Technical Architect, Business Intelligence

Responsibilities:

• Technical lead for SQL Server Analysis Services (SSAS) and Power BI business intelligence program for large retail organization
• Developed SSAS design standards, data models, team processes, and drove migration to SSAS Tabular 2016
• Led performance tuning and monitoring efforts, provided user training, and led BI project meetings
• Collaborated with business leads and stakeholders to test, modify, and enhance reporting and analytics solutions

Confidential

Senior Consultant, Solution Developer

Responsibilities:

• Technical lead on multi-project scoping initiative for Microsoft BI migration with a Fortune 500 company
• Developed SSAS Tabular design and DAX query standards documentation to support BI development teams
• Developed complex SSRS reports for the supply chain organization of a Fortune 500 company and Power Pivot POCs

Confidential

Business Intelligence Consultant

Responsibilities:

• Lead consultant on multi-stage BI project for national retail brand; designed ETL, dimensional model, dashboards
• Collaborated with client stakeholders on targeted pilot projects and with IT
• Lead consultant on agile BI project for large manufacturer; collaborated with sponsor on BI solution and roadmap