An experienced SQL BI Reports Developer with many years of success delivering data warehouse reporting solutions based on the Microsoft BI stack, ranging from administering Power BI Service, Tableau Server, SSRS and IIS, through developing paginated reports, interactive dashboards, and custom BI portals. Deliverables include paginated reports in SSRS with supporting T-SQL queries and complex stored procedures for related analytics, as well as, interactive dashboards with Row-Level Security, and DAX measures with intuitive charts, graphs, and visualizations. Additional skills include creating semantic reporting layer, SSAS Tabular models, and data integration with SSIS and Tableau Prep.
Developed interactive dashboards and paginated reports, including optimized Datasets and Extracts, parameterized SQL queries and stored procedures with Row-Level Security and DAX/LOD measures, and Power BI Gateway for On-Premise data sources, including workspace/project management and refresh scheduling, as well as, Tableau Server administration.
Responsible for sales pipeline management dashboard from Salesforce data, parameterized interactive, multi-functional, paginated customer-facing reports and pdfs with SSRS, custom web portal leveraging Tableau to deliver reports and documents from various platforms, used PowerShell and SSIS to integrate Active Directory and Salesforce data for SSRS and Power BI Datasets, and performed outlier screening of transaction log data in TSQL via Interquartile Range Analysis.
Migrated 50+ District-wide SSRS reports including revised stored procedures and rebranding/reformatting, developed custom reporting interface via ASP.NET web application for IIS 10 on Windows Server 2016, automated test and validation of SSIS ETL packages with C# and SQLcmd and Data Quality Services, administered Tableau Server, publishing extracts, Row-Level Security, and embedding with JavaScript API, and created Power BI dashboard (on Tabular data model with DAX measures) for reporting of report utilization metrics.