Moderator

• Nov 2022 - Present

Member

• Jul 2023 - Present

Senior DataOps Engineer

• Nov 2022 - Sep 2023

Analytics Engineer

• Nov 2021 - Aug 2022

• Strategized update of dbt SQL data transform for Data Mart for SEM marketing team which actionable insight increased SEM spend profit by $10k+/week. • Implemented CI/CD for improved SQL data modeling using GitHub for version control with a peer review process, including moving persistent derived tables, and hard-coded LookML logic to dbt SQL data transforms which improved Looker processing times. • Managed end-to-end migration from Google AdWords to Google Ads from AWS S3 buckets through Fivetran to Snowflake, transformed in dbt SQL data transforms to a Data Mart accessed through Looker. • Streamlined communication, and deliverables through refinement sessions, office hours, working sessions, and directing project and production support requests through limited channels. • Implemented documentation of data, and definitions including identification of cross-functional KPIs. Show less

Data & Business Intelligence Architect

• Dec 2019 - Jul 2021

• BI Architect for Pro Builder’s 2020 Builder of the Year & Largest Personal Home Builder in the Carolinas. • Improved SQL stored procedures, SQL views, and SQL user-defined functions (UDFs) by using SQL query optimization, and SQL performance tuning for SSIS ETL packages used for SSRS/Power BI reports for C-suite executive and their domain leadership teams for new insights for Sales, Supply Chain, HR, Accounting, and Planning Departments. • Implemented best practices, including ANSI standard SQL code, created standards for readable SQL code, eliminated deprecated SQL features, implemented UAT process, and set up a roadmap for improved policies and procedures. • Improved team culture and morale by exemplifying synergistic characteristics. Show less

Senior Systems Analyst

• Nov 2017 - Dec 2019

• • Implemented the integration of new student financial system SQL data, and existing student CRM system SQL data to automate, and track all student communications, file, and account status changes. • Managed projects and the training for other senior level team members including producing troubleshooting guides for the migration of SSIS ETL packages and SQL stored procedures from SQL Server 2008 to SQL Server 2012 integration server, and again to the SQL Server 2016 using TFS, the renaming of Kaplan University to Purdue University Global, and the archiving of SQL data. • Improved SQL query optimization and performance tuning of SQL stored procedures, SQL views, SQL indexes, and SQL UDFs for improved application and reporting processes. • Production support for application errors, SSIS ETL SQL integration errors, and SQL data cleaning. Show less

Senior SQL Consultant

• May 2017 - Sep 2017

• Managed the day-to-day operations of the previous data team the for REO project for Ditech as the sole SQL data resource on a skeleton crew working on a contract in the interim before offshore resources took over. • Streamlined processes and procedures for offshore resources by improving existing manual tasks of the previous data team by implementing SSIS ETL integrations, creation of scheduled BI reporting, and documentation of the processes based on weeks of research collecting artifacts of disparate communications through collaboration with remaining tech, and business domain teams. • Managed the training of offshore resources starting with basic SQL training, and providing very detailed, step-by-step production support documentation. Show less

SQL Application Engineer

• May 2016 - Apr 2017

• Improved HL7 integration, implementing changes for in-house policies, and state and federal laws. • Made significant changes to application forms for ease of use, fixing application errors, and updated SQL stored procedures, SQL views, indexes, and SQL UDFs for faster processing. • Improved reports by completing extensive analysis and design based on working sessions. • Managed project from data discovery of over $1 Million in un-submitted charges, including training staff on the process for insurance submittal within an application. Show less

SQL Application Developer II

• Sep 2013 - Apr 2016

• Implemented front-end and SQL updates for Meaningful Use Stages 1 and 2, as well as requirements for the Commission on Accreditation of Rehabilitation Facilities through rapidly changing priorities and requirements which assisted in the facility winning the Malcolm Baldrige National Quality Award twice over. • Improved SQL stored procedures, SQL views, SQL UDFs, and front-end code for ease of use, and performance of applications, and SSIS ETL integrations for internal cross-functional, state, and federal reporting. Show less

SQL Database Specialist II

• Mar 2012 - Aug 2013

• Implemented working sessions with cross-functional teams to perform a full analysis and design, and the eventual creation of training for departmental and agency-wide SQL reporting. • Strategized the improvement of KPIs by clarifying, and simplifying agency definitions, and creating documentation of how KPIs are recorded, tracked, and reported. • Streamlined required state, federal, and internal quarterly SQL reporting system by implementing new standards, and creating and documenting a system that increased ease of use, and speed of delivery. Show less

IMAGE/SQL Database Consultant

• Oct 2010 - Jul 2011

• Implemented automation of database tasks for TUFTS Health Plan in a UNIX environment on an HP3000 database system using IMAGE/SQL. • Generated BI reporting for cross-functional teams. • Production support for data cleaning • Implemented automation of database tasks for TUFTS Health Plan in a UNIX environment on an HP3000 database system using IMAGE/SQL. • Generated BI reporting for cross-functional teams. • Production support for data cleaning