February 2023 - Present
Senior Principal Data Architect Engineer
Bisnow · Portland, OR
Lead enterprise architecture and engineering standards for data platforms, integrations, and delivery execution.
Experience
Data and platform architect with hands-on delivery leadership across enterprise engineering, governance, and analytics.
career span
2008 - Present
primary focus
Enterprise Data Architecture
industry experience
Federal Government, Consulting, Commercial Real Estate
July 2021 - February 2023
Senior Principal Enterprise Data Architect
SAIC · Fort Collins, CO
Delivered enterprise data sharing, documentation, monitoring and deployment strategies across a large architect team. Led an analysis of alternatives for modernizing the HyDRA reporting application, and modernization strategies for the Water Climate Information System and Volunteer Tracking System.
June 2019 - July 2021
Principal Enterprise Data Architect
SAIC · Fort Collins, CO
Re-architected the database tier of the enterprise Application Authorization Management solution, modernized the analytical tier for NRCS and FSA, and contributed Data Management Maturity, Master Data Management and analytics assessments for the Data Analytics Center of Excellence.
March 2019 - June 2019
Team Lead - Principal Data Engineer
Xpanxion · Fort Collins, CO
Led delivery for the client engagement while building a CI pipeline that moved production data and schema into developer environments using BCP, T-SQL and PowerShell, and administering a MySQL cluster alongside SQL Server availability groups.
July 2017 - March 2019
Senior Data Engineer
Xpanxion · Fort Collins, CO
Cut report run times from 5-10 minutes to 1-30 seconds across 35+ reports, retuned the SSIS warehouse load from full nightly to incremental using C# hash indexing and CDC, saving 10+ processing hours, and upgraded SQL Server 2012 to 2017 with zero downtime.
▸ 6 earlier roles, 2008–2015
June 2015 - July 2017
Senior Database Specialist
LS3 Technologies · Fort Collins, CO
March 2014 - June 2015
Senior Database Administrator Support Technician
Solarwinds · Boulder, CO
July 2012 - March 2014
Systems Administrator
Center Partners · Fort Collins, CO
July 2011 - July 2012
Database Application Administrator
Center Partners · Fort Collins, CO
July 2009 - July 2011
Global Queue Analyst
Center Partners · Fort Collins, CO
June 2008 - July 2009
Technical Support for Digital Video Recording Equipment
Center Partners · Fort Collins, CO
November 2020
MCSE: Data Management and Analytics
Microsoft
Includes 70-767 Implementing a Data Warehouse.
Verify credential →
November 2019
CDMP Practitioner
DAMA International
DAMA-DMBOK2 Certified Data Management Professional.
Verify credential →database_technology
Database Technology
- AWS RDS (MySQL, PostgreSQL, Aurora), Microsoft SQL Server, Oracle, Sybase, and DB2.
- SSIS, SSRS, DTS, and Visual Studio.
- Information Builders (Webfocus, Data Migrator, iWay), Redgate Toolbelt, SentryOne, ApexSQL, MySQL Enterprise Monitor, and Toad Data Modeler.
server_and_platform_technology
Server and Platform Technology
- Microsoft Server 2000 through 2014, Ubuntu, Redhat, and CentOS.
- VMWare, vSphere, and Citrix.
- Git, Team Foundation, Solarwinds NPM/SAM, WS_FTP, Filezilla, WinSCP, Putty, Powershell, and Symantec Backup.
sql_administration_and_security
SQL Administration and Security
- High availability: Availability Groups, clustering, replication, mirroring, and transaction log shipping.
- Disaster recovery planning, restore testing, and archive management.
- Security controls including auditing, TDE, column encryption, temporal tables, SSL/TLS setup, and role/schema permissions.
business_intelligence_and_performance
Business Intelligence and Performance
- ETL and data warehousing architecture aligned to Inmon, Kimball, and Lindstedt methodologies.
- Reporting and analysis delivery with strong constraints, data typing, and data integrity practices.
- Performance tuning with DMV wait stats, Extended Events, Query Store, SQL Profiler, indexing strategies, and partitioning.
- ONLC - Oracle Database 12c: SQL Fundamentals (August 2014)
- Advanced Excel classes hosted at FRCC, courtesy of Center Partners (June 2009)