David A. West

Issaquah, WA ***** cell: 425-***-****

adypsd@r.postjobfree.com LinkedIn

Summary

Data Warehouse & ETL

Louisiana Pacific, Hyland Marketing, SAG-AFTRA, T-Mobile, COSTCO, Microsoft, Airbiquity, Darigold

Architect of 20+ Data Warehouses utilizing SQL Server, Azure, Snowflake, and others.

High Performance ETLs integrating data from disparate sources while maintaining Data Quality,

with 25-50% improvement in performance, on average.

Darigold: 90% ETL performance improvement for financial data.

Business Intelligence

Everywhere

Architect and manager of Business Intelligence systems that provide valuable, actionable insights.

Darigold: Financial & Lot Traceability - 80% faster, 10% more accurate.

Microsoft: Super-fast Windows installations cube helped save $100M

directly and $400M indirectly in the Anti-Piracy program.

Snowflake

Louisiana Pacific, Hyland Marketing, T-Mobile

Architect and Team Leader of Snowflake migrations from a wide variety of sources, including Azure, AWS, and Salesforce.

Hands-on experience with Administration, Private Shares, Marketplace, Security/Grants/RBAC, Shares, Pipes, S3 Storage.

Data Governance / Data Steward

Everywhere, esp. Louisiana Pacific, T-Mobile, COSTCO, Microsoft

Dedicated to Data Governance and Data Quality.

Data Governance/Data Steward Lead, Author/Manager of Data Catalogs & Documentation.

In-depth Data Analysis and Data Quality assessments, encompassing different strategies, tools, reports, etc.

Leadership

Everywhere

Project Manager & Team Leader, with great strategic and tactical ability.

Able to clear obstacles, fix technical issues, mentor others, do Gap Analysis and outstanding Root Cause Analysis.

Forward-looking at project scope, direction, team utilization, and opportunities for people to learn and grow.

Skills

Best Practices

Gap Analysis

Root Cause Analysis

Business Requirements

Business Rules

Data Quality

Data Integration

Data Domains

Marketing – Segmentation, Analysis, Integration

Business – Business Analysis & Requirements, Functional, System, Acceptance Testing

E-Commerce – Sales, Returns, Commissions, Supply Chain, Financials

Operations – Customer, Subscriber, Tickets, Agile, IT Schedule, Team Status

Regulatory – Compliance, HR, PII, HIPPA, Privacy, SOX, Auditing, Reporting

Security – Active Directory, Authentication, Usage, Domain, VPN, Database, RBAC

Platforms & Tools

Data Governance – Collibra

Data Quality – Ataccama

Modeling – PowerDesigner, Erwin, TOAD, Visio, TOGAF

ETL / ELT – Informatica, Alteryx, ODBC, Linked Servers, API, Snowflake Stages/Pipes/Shares, SSIS

Azure Synapse, Azure Data Factory

Database – Snowflake, Azure ADLS, SQL Server, Oracle, Teradata, Postgres, DB2

Reporting – Tableau, Alteryx, PowerBI, DataBricks

HR – Workday, Active Directory, Clarity, Manhattan, Kronos, Fieldglass

Other – AWS, dbt, FiveTran, PowerShell, R, Python, PIER, ServiceNow, Jira, Confluence, CONTROL-M

Experience

Principal Architect Louisiana Pacific June 2022 – Dec 2022

Azure, Snowflake, Tableau, Alteryx, AWS

•Reviewed and improved Azure and SQL Server databases containing extracts from Salesforce, vendors, machines and monitoring equipment, PLC’s, etc.

•Built Snowflake databases to handle various data sources, including Product Sales Data in AWS S3 Storage, Zonda Housing Research in a Snowflake Private Share, and Snowflake Public Data.

•Juggled Data Migration, Integration and Legacy maintenance, including Azure, Alteryx Server, Snowflake Private Shares, and Python.

Sr. Architect Hyland Marketing Inc. Sept 2021 – April 2022

Azure, dbt, Alteryx, SQL Server, Snowflake, Tableau

•Growth & acquisitions necessitated constant review and integration of more information.

•Fixed access and permissions problems in Azure database, copied/extracted/exported data for Data Quality audits and migration.

•Architect of new Database Design, dbt objects, and Process Improvements.

•Improved Data Integration using dbt, Alteryx, SQL Server, Snowflake, FiveTran, and Python.

Sr. Architect SAG-AFTRA Feb 2021 – June 2021

SQL Server, Tableau, Alteryx

•Data and ETL architect and analyst for SAG-AFTRA Health Plan Database

•Business & Requirements Analysis

•Design, Process, and Performance Improvements in Alteryx and SQL Server.

•MDM and Database Tools

•Architect of High-Performance Alteryx ETLs, with new strategies and greater modularity.

•Data Quality: Pre/Post Integration, Automation, Reusability, Reliability

Sr. Architect T-Mobile Sept 2015 - March 2020

Azure, SQL Server, Databricks, SSIS, PowerShell, Collibra, Ataccama

•Azure: Move-to-the-cloud mandate required a POC project to compare Azure to on-site SQL Server using ADF, DataBricks, Azure SQL Server.

•Database Architect: Operational Data Store (ODS) (OLAP, PowerDesigner, SSIS, SQL, PowerShell): Established the architecture and strengthened the team’s reputation as we added 20+ sources. PowerDesigner used for Data Modelling, Forward & Reverse Engineering.

•ETL: Used SSIS, Alteryx, PowerShell to cleanse data from Teradata, SQL Server, files, and APIs.

Created Alteryx workflows to aggregate ServiceNow and PIER Ticket data into a Multi-Dimensional Data Model.

•Data Governance: Used Collibra and Ataccama to collect system-wide metadata for a new, interactive Data Governance Catalog and to implement Data Quality and cross-platform compatibility rules. Relentless focus on Data Governance, Data Quality and Business Process Improvement. Liaison and mentor to the new DG team, saving time and money department-wide.

•Business Analyst: Led Requirements Analysis with stakeholders. Formulated improvements to Business Processes that were dysfunctional, un-automated, or did not even exist. Applied Best Practices to improve Data Quality, Integrity & Timeliness, and better, more productive Agile Sprints.

•Monitoring and Reporting Lead: Requirements Analysis, Sprint Planning & Final Acceptance Testing, centered around HR data from Workday, Active Directory, Clarity, Manhattan, Fieldglass, & Kronos data to understand the relationship between team deployment and project roles, to determine spend efficacy and ROI.

•BI Architect: Designed & built mission-critical databases and reports in Tableau and PowerBI.

•Custom User Acceptance Testing to ensure everyone’s approval and happiness with the final product.

Sr. Data Steward / Sr. Architect Costco 2014 – 2015

DB2, Erwin, Blueprint

•Leadership: Led Data Governance team for the Sales Sourcing Strategy Phase 2 - Integrating Online and Warehouse Sales data in a new reporting database.

•Data Modeler: Architect of Reporting Database (OLAP, Erwin), conforming 3 very different data sources into one common schema.

•Business Analysis: Took on the responsibility of Business Analyst, cleaned and categorized the Business Use Cases, and mapped them to the associated Data Quality definitions and metrics to prove all Business Requirements could be met.

•Documentation: Produced extensive MDM documentation, including a huge Data Quality survey, metadata, statistics, data dictionaries, and projected the fitness of the new reporting database according to the Business Use Cases.

•Technical Debt: Reviewed Business Processes and legacy systems which lacked documentation and required analysis and documentation of the data flow to get business buy-in. Produced Wireframe Business Flows that included new and existing applications.

Sr. Business Intelligence Architect Airbiquity 2013 – 2014

SQL Server, SSIS, SQL, Excel, DBA

•Mobile applications vendor needed a versatile expert to build an Operations Reporting system (OLAP) and populate it with application and partner data using SSIS & SQL.

•Fostered relationships and gathered requirements with stakeholders on both the business and IT sides.

•Architected a new Data Warehouse for data analysis, created reports in PowerBI and Excel.

•Built a QA database for Data Profiling and Data Quality monitoring on new and legacy systems.

•Discovered and documented platform deficiencies and presented solutions to VP.

•Strengthened communications with clients to facilitate improvements in application functionality, reporting accuracy, and program efficiency.

•Normalized disparate schemas into Business Practice Groups to benefit business stakeholders.

•Transformed ad-hoc queries into reliable, scheduled reporting (SQL, Splunk, Excel, PowerBI).

Sr. Business Intelligence Analyst Seattle School District 2012 – 2013

Oracle, SQL

•Consulted in support of the next phase of the Academic Data Warehouse (Oracle, OLAP) build-out by sourcing, cleaning, and combining Discipline Events for Executive Reporting.

Sr. BI Architect / Sr. Business Systems Analyst Darigold Inc 2011 - 2012

Informatica, Oracle, SSIS, TOAD, SQL

•Lot Traceability: Served as Lead Analyst. Integrated SQL Server & Oracle data to streamline reporting, which saved 50%-75% time spent on product quality issues.

•Financial database: (Oracle, OLTP): Enhanced Sales & Commission numbers by 10% by including Hedging Warehouse Operations layered costs, a 5%-10% savings opportunity.

•Best Practices: Proposed and built reporting solutions based on Best Practices, which saved significant time and cost compared to legacy solutions.

•Set new standards for documentation, and authored and collected documents (ERD, High Level Data Flow, Business Requirements, etc.) and organized them in SharePoint.

Sr. BI Architect Microsoft 2009 – 2011

SSIS, SSAS, PowerBI, SQL Server

•Office Support Analytics: Created a Business Intelligence system to better integrate “Big Data” sources to provide a comprehensive view of Bug Report and Scenario Test results. Gathered requirements, managed expectations of stakeholders and was responsible for resolving differences. Identified a lack of support for the new reporting template early on, so I managed both old and new templates, giving the customer a choice, which they greatly appreciated (PowerBI, SSAS).

•XBOX Live: Insights Data Warehouse (OLTP, OLAP, SSIS, PowerBI, SSAS). Cut ETL runtime by 50%. Pinpointed data problems and devised solutions, which enabled 3 more KPI’s and a 25% increase in targeted marketing.

Customer & Subscriber: Volunteered to improve the Data Quality, which had been attempted 3 times before, without success. Eliminated ~20M rows of bad data.

Redesigned processes to take better advantage of teammates’ expertise. Migrated to VSTF platform, which enabled proper branching, deployment, and testing.

Optimized the 10 Tb+ Data Warehouse (OLTP & OLAP) with better indexing, code refactoring, data partitioning.

•Financial: Designed performance solutions for the EXTRA financial app and metadata source change from Excel to MDM. Discussed vision and strategy with EDW stakeholders and presented solution concepts, including a Business Rules Engine model (OLTP) and application upgrade/migration plan to support server consolidation.

•Legal: Built a new Data Mart (OLTP & OLAP) for better insight into business processes and expenditures, accomplishing a high-profile requirement to save millions of dollars. Architected an Analysis Cube (OLAP) for Business Domain Data and Business Rules, including MDX for custom metrics.

PM / Sr. BI Architect Puget Sound Energy 2008 - 2009

•5-month contract to create a new Inspection Data Collection application on SQL Server (OLTP) and .NET platform, including requirements gathering, design, development, testing, data migration, to consolidate 3 databases into one.

•Met with stakeholders to define requirements, improvements, and data quality. Wrote the new design documentation and established the project schedule with the PM.

•Designed and developed a new database (OLTP) and SSIS data migration package to consolidate 3 similar databases into one new one.

Sr. BI Architect Microsoft 2007 - 2008

•Window Genuine Advantage group needed a BI expert to improve their Business Intelligence reporting.

•Saved $100M directly and $400M indirectly in the Anti-Piracy program, with more accurate and timely reporting of pirated product keys.

•Refactored the Data Warehouse (OLTP), fixed SQL code, added performance features.

•Produced a very high-performance ETL in SSIS to aggregate Windows and Office installation data that could processes 100’s of Millions of rows in minutes.

•Architected 3 Cumulative Installation Cubes (OLAP) in SSAS for XP, Vista, and Office installation data to combat piracy and provide valuable, actionable Business Intelligence about buying and usage patterns.

•Developed new reports, fixed existing ones, and facilitated the transition to the Cumulative Installation Cubes (OLAP) as data sources for all reporting.

•The previous successes led to another: pulling Windows Telemetry data from SQL Server 2000 (OLTP), converting raw data into a new schema, de-duplicating it, and storing it on a new server (OLTP), which I also built.

Education

Seattle University

Bachelor’s Degree - Liberal Arts

Computer Science and Math Minors

Keywords

API, AWS, Acceptance Testing, Active Directory, Agile, Alteryx, Analysis, Analytics, Architect, Ataccama, Auditing Status &Results, Authentication, Azure, Best Practices, Business Requirements Analysis, Business Analyst, Business Intelligence, Business Intelligence Architect, Business Intelligence Consultant, Business Intelligence Solutions Architect, Business Intelligence Team Lead, Business Intelligence Tools, Business Objects, Business Use Cases, CONTROL-M, Clarity, Cluster Analysis, Collibra, Commissions, Compliance, Computer Science, Confluence, Customer, Data Analysis, Data Analytics, Data Catalogs, Data Engineer, Data Governance, Data Integration, Data Integrity, Data Management, Data Migration, Data Mining, Data Modeling, Data Quality, Data Steward, Data Visualization, Data Warehouse, Data Warehouse Architecture, Data Warehousing, DataBricks, Database, Database Architect, Database Design, Database Development, Database Optimization, Database Security, Databases, DB2, DBA, dbt, Dimensional Modeling, Documentation, Domain, E-Commerce, ELT Pipeline, ETL / ELT, ETL Pipeline, Enterprise Architecture, Erwin, Fieldglass, Financials, FiveTran, Functional, Functional Testing, Gap Analysis, HIPPA, HR, High Availability (HA), High Performance, IT Architect, IT Scheduling, Informatica, Integration, Jira, Kronos, Leadership, Linked Servers, Lot Traceability, MDM, Manhattan, Marketing, Master Data Management, Microsoft SQL Server, Microsoft Visual Studio Code, Multi-Dimensional Data Model, ODBC, OLAP, Operations, Operations Data Warehouse, Oracle, PIER, PII, Performance Tuning, Pipeline, Postgres, PowerBI, PowerDesigner, PowerShell, Presentations, Principal, Privacy, Process Improvement, Project Manager, Python, R, RBAC, REST, Reporting, Requirements Analysis, Requirements Gathering, Returns, Root Cause Analysis, SDLC, Senior, SOAP, SOX, SQL, SQL Server, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Tuning, SSIS, Sales, Security, Segmentation, ServiceNow, Snowflake, Snowflake Architect, Snowflake Pipes, Snowflake Shares, Snowflake Stages, Snowflake Stages/Pipes/Shares, Software Documentation, Software Project Management, Source System Analysis, Stored Procedures, Subscriber, Supply Chain, T-SQL, TOAD, TOGAF, Tableau, Team Lead, Team Leader, Team Status, Teradata, Tickets, Usage, VPN, Visio, Workday, XML

Contact this candidate