Samuel Sparks
HireSamuel

Samuel

Seattle, Washington id="timeZone">--:--:--

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.

Hire Samuel
Skills
Years
1
2
3
4
5
6
7
8
9
10+
ASP.NET
Azure
Jira
SSRS
Salesforce
SSDT
SSAS
Active Directory
Visual Studio
T-SQL
PowerShell
Power BI
SQL Server
Excel
Tableau
Developer Personality

Independent

Collabrativer

Trailblazer

Conservative

Generalist

Specialist

Planner

Doer

Idealist

Pragmatist

Abstraction

Control

100
50
0
50
100
Feature Experience

Business Intelligence

Interactive Dashboards & Paginated Reports

Data Modeling & Row-Level Security

Network Security, File & Transport Encryption

Data Analytics

MODERATE
EXTENSIVE
EXPERT
Cultural Experience

TEAM LEAD

Consultant

Enterprise

MODERATE
EXTENSIVE
EXPERT
Portifolio

sparsena

BI Developer/Consultant

Work Experience : 2015-2020

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.

More

AIM Consulting

Power BI Developer

Work Experience : 2015-2020

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.

More

Seattle Public Schools

Business Intelligence Developer

Work Experience : 2015-2020

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.

More

Hire Samuel Sparks