★ Professional Personas★★ Management Translation★★ Dev Team Leadership / Mentor★★ Product Owner Collaborator★ Dev-DataOps & Delivery Management★ Azure Cloud Data Services★ Business Intelligence★ Data Analytics★ Visual StorytellingGlobal Awards• Microsoft Data Platform MVP• Microsoft Executive Recognition Letter• Microsoft Certified Trainer (MCT)• Friend of Redgate Public Engagement• Azure Microsoft Certified Trainer• SQL Saturday Speaker • SQL Server User Group Speaker Certification• Azure Data Engineer Associate• Azure Fundamentals

Data Team leader responsible for SQL Server backend of a Microsoft C# WebApp using T-SQL, APIs, and Python as well as data governance and DBA tasks. Azure services include Azure Bot, Azure OpenAI, Azure Data Lake Services, Azure SQL Server, and Azure SQL Database. Data Team Fabric Administrator, Power BI report builder, and DAX programmer. Maintained legacy SSRS reports and SSIS packages.

Azure DevOps Delivery Manager supporting the Future Long Range Assault Aircraft program and responsible for cross-team collaboration, design, and development.Digital Thread tracks FLRAA helicopter part events from birth, including repairs, installs, and removals both on and off a helicopter. Other events include configurations, holds, demand, investigations, inspections, inventories, and overhauls; plus, to many others to list. Used SSIS packages and SSISDB environments to stage, transform, and load star schemas into test and production. Used Ole DB and flat file sources to load data from csv files and an IT ODS / data warehouse. Led a cross-team investigation for a future version to be migrated to Azure Services including: Databricks Data Lakehouse, Data Lake Storage, Data Factory, Automate (PowerShell), and SQL Database.Program Metrics established a FLRAA data mart using T-SQL to create a staging layer and a star schema (transformation layer) that used a T-SQL framework to track load metadata such as SSIS package (or stored procedure) start and end times, a master load ID to tie together all packages (or stored procedures) that were associated to a single ETL load, and error logging to track errors to aid in debugging failures. Developed an ETL using SSIS to stage and load data marts and star schemas for Power BI models / dashboards. These models enabled program leaders to create their individual dashboards according to their individual requirements including affordability, multi-ship BOM tracking, engineering releases, make / buy parts, financial, procurement, inventory / stock, vendors, plants, part demand, and profit center data.SSRS and Power BI reports deployed to the Power BI Report Server and the GCC-High (Government) Power BI Service. Created and maintained dashboards for Digital Thread, Program Metrics, and Organizational Breakdown Structure (OBS). Built reports using SSRS Report Builder, and Power BI Desktop.

Designed Power BI using Azure Automation to extract data from Power BI Service and Log Analytics APIs. Prepared reference diagrams and offered guidance to business analysts and developers. Maintained internal company legacy SSIS packages and SSRS reports. Created SSRS reports to track legacy SSRS report migrations to Power BI. Azure services included SQL Database, Data Factory, and Power BI.

Responsible for content (slide / transcript) creation, demo markdown, and audio-video recording. Provided training for Azure DP-200, 201, 300, AZ-104, 204, 900 and Power BI including Microsoft Official Content. Topics included Power BI, Azure SQL Database, Azure Analysis Services, and Azure Data Factory.

Corp to Corp Contract roles with TekLeaders ** See Job / Role Details Below ** • American Heart Association • TricorBraun • Joyce Meyers Ministries • Acuity Brands • Smith Group JJR

Implemented Alteryx to stage data integration for Salesforce Marketing into Enterprise Data Camp (stage). Created SSIS packages to load the staged data into SQL Server. Setup SSISDB Environments on SQL Server to connect to project parameters allowing connection strings and email details to be changed by database admins during deployments from Dev to Test and to Prod. Built SSRS and Power BI reports using the Power BI Report Server. Created Power BI Reports for Azure DevOps Percent Complete, Sprint Burndown, and Pipeline Duration.

Delivered on-premises database migrations to Azure SQL Database (lift and shift) using Data Migration Assistant and Service. Completed analytics platform system migrations to Azure SQL Data Warehouse. Used Azure services including Azure Data Factory (including SSIS and Self Hosted Integrated Runtimes) and Azure SQL Database. Legacy SSIS packages were executed using the SSIS IR and then added to a prioritized list for migration to Azure Data Factory pipelines while new ETL was created in Azure Data Factory.

Built SQL Server Reporting Services row level security (RLS) on the employee dimension. Created SSRS report parameter queries that used cascading parameters. Designed PowerShell to stage user data for the RLS tables using the active directory module (AD Security Groups). Designed SSIS ETL to populate RLS user (entitlement security) table and a bridge table after the AD data was staged. Bi-directional filtering was enabled between both the employee and bridge table and between the user (entitlement security) table and bridge table. Created Power BI and SSRS Daily Gross Profit Dashboard Reports for testing RLS and AD Groups.

Designed data extracts using PowerShell and the Watson Campaign Automation Rest API. Built identity and access management (OAuth2) to the Rest API. Used PowerShell to load data into SQL Server Database staging. Once the data was stagged, a SSIS ETL process transformed the data to be loaded into the data warehouse.

Implemented Azure Analysis Services row level security (RLS) using AD Groups., user (entitlement) table, bridge table, and dynamic SSAS roles. Participated in the Azure Data Lake design and loaded using Azure Data Factory.

Built T-SQL scripts for pay type analysis, rate diversity assessment, and payment / geo data time analysis. Provided geo data parsing (latitude / longitude) for out of state and on duty analysis. Executed POLE (People, Object, Location, Event) data analysis using T-SQL scripts and stored procedures and SSIS for data load orchestration.

Created analytics project using transformed star schemas and SSAS tabular cubes. SSIS ETL process to stage, transform, and load the star schema. Documented a road map for an Azure SQL Database, Azure Analysis Services, and Data Factory hybrid design including on-premises data. Data models and star schemas for loan, escrow, customer transfer interaction, and transactions. ETL execution and cube processing using SSIS.

Evaluated current environment and designed a roadmap including a star schema model. Developed an SSIS ETL process with error flows and error collection to JSON SQL type. Documented data warehouse (BI) procedures, best practices including source control, DevOps, and Agile methodology.

Built large analytic projects using data partitioning and validation using Azure Analysis Services. Designed conceptual, logical, and grain modeling using ERWin. Created business process diagrams using Visio. Collaborated with local and offshore teams using SSIS, SSRS, SSAS, T-SQL, and PowerShell.

Created SSIS packages and orchestration for Vendor Feed Supply Chain and UPS Origin data integration. Designed Analytics Delivery Dashboard, Sales Commission, Pricing Rebates, and Daily Freight Process reports in SSRS. Built SSAS Tabular models used with Power BI.

Built Power BI real estate reports and dashboards. Wrote T-SQL scripts for fact / dimension compliance, auditing, and query tuning. Created SSIS projects for ETL orchestration and load data into stage, transform, and star schema. Data models for accounting and OMS data marts, star schemas, and ETL data lineage.

Built SQL Server SSIS packages using project deployment model including data models and star schemas. Wrote T-SQL scripts for data warehouse tables, stored procedures, and indexes. Designed SQL Server data validation using row, column-based auditing and T-SQL sanity checks. Created SSRS reports for this data validation.

Data models for data marts, star schemas, data repositories, and ETL data lineage. Built SSIS projects using parameters, SSISDB environments, and SQL jobs. Designed SSRS Tablet Usage reporting and SSAS Multi-Channel Product Dashboard. Migrated XBOX digital content games to Azure SQL Database.

Responsible for the emergency department analytics including SSIS ETL and data discovery. Built SSAS KPIs for patient volume, 72 hour re-admits, and length of stay. Data models for data warehouse, data marts, star schemas, and data lineage. Migrated American Medical Response (AMR) Ambulance and Vital Signs to Azure.