Part Time Experience

Office Manager | Cougar Home Improvement – Hood River, OR | 12/2020 – Present

  • QuickBooks expert (accounting, reporting, sales, invoicing); CRM admin (Salesforce, Zapier automation).
  • Managed data entry, scheduling, communications, advertising, web/logo design, lead generation.

WordPress Developer / Systems Admin | Aaron Kempf, Inc – Hood River, OR | 11/2016 – Present

  • MeganFlips.com / JasperCraftHomes.com / GorgeHunt.com / THGDesignsOnline.com / SnowdenCommunity.org / +40 others
  • Managed Plugins, Users, Permissions, Upgrades, Logging, Backups, Google Analytics, SEO

Database Consultant & Freelance Programmer | Remote | 3/2000-Present

  • Expert RDBMS consultation & development (Postgres, MySQL/MariaDB, MS SQL Server): setup, config, admin, troubleshooting, training.
  • .NET console app development (website monitoring, alerting, crawling, data discovery).
  • Apache/Nginx server management; API management, DB migrations/upgrades, data retention policies.
  • Extensive ETL (SSIS, .NET, scripting – Bash, Batch, PowerShell) for automation, conversions, migrations.
  • Email/hosting control panel (HestiaCP, VestaCP, cPanel) config & troubleshooting; Log analysis (ELK, Graylog, Syslog).
  • Reporting [PowerBI(2016-Present), SSRS(2006-2012), Tableau(2008-2012), Crystal Reports (2002-2004), MS Access (1997-2007)]; Security testing; Scripting (Bash, SSH, DOS).
  • WordPress expert: design, admin, training, troubleshooting, setup, migrations, Multisite.
  • PHP Development: Troubleshooting, Testing, Optimization, Security
  • Microsoft Office VB6/VBA development & consultation.

Full Time Experience

Hadoop SysAdmin | Stealth Startup – Albuquerque, NM | 6/2016 – 11/2016

  • Hadoop setup, test, config; SSAS & data warehouse design/dev; Bash/SSH scripting for deployment (Bare Metal, VM, Docker).

MS SQL Server BI Developer | Sandia National Labs – Albuquerque, NM | 4/2016 – 8/2016

  • Led SSRS/SSAS design & dev; Managed Access to SQL migrations, metadata analysis, Stored Procedures; .NET tools for SSRS test automation.

PostgreSQL / Odoo / ERP Developer | Small Clients – Remote / Boise, ID | 1/2016 – 3/2016

  • PostgreSQL DB schema design (Stored Procedures, Tables, Indexes); Odoo modules/deployment training; Website & Hyper-V admin.

MS SQL Server Data Warehousing Developer | Gorge.Net Networks – Hood River, OR | 6/2013 – 2/2015

  • MS SQL BI Suite dev (SSAS, SSIS, SSRS); Data warehouse/datamart design, Stored Procedures, PowerShell, QA, text processing, index optimization.

Sr. MS SQL Server DB Developer / DBA | Stella Jones (McFarland Cascade) – Tacoma, WA | 11/2012 – 3/2014

  • SQL Server dev, optimization, admin (Relational, SSAS, SSIS, SSRS); DataMart design, SSIS ETL, SSAS (Multi/Tabular), SSRS reporting, PowerShell, SQLCLR; Financial systems migration.

MS SQL Server DB Architect | EagleView Technologies (HomeDepot.com) – St Paul, MN | 11/2011 – 11/2012

  • SQL Server DB architecture & dev; Optimization; SSIS ETL/API, SSAS design/reporting, SSRS dev, DQS, Stored Procedures, SQLCLR, PowerShell.

Sr. ETL Developer | Alliance Enterprises – Lacey, WA | 11/2010 – 11/2011

  • Automated ETL (XML, VB.NET); DevOps metrics reporting (SSRS); Oracle migrations (BLOB, VLDB); SQLCLR; .NET Console Apps.

MS SQL Developer / SysAdmin | Realtor.com / ePropertyData – Gig Harbor, WA | 10/2008 – 11/2010

  • SQL Server dev (Sybase), admin (SSAS, SSIS, SSRS); CRM (Act, Salesforce); SharePoint; Active Directory/LDAP; ~350 SSRS reports; Financial analysis suite.

MS SQL Developer / Lead Technical Consultant | G4 Analytics (A.C. Nielsen) – Remote / Dallas, TX | 8/2007 – 5/2008

  • Led SQL Server dev, SSAS Data Mining/OLAP (MDX), SSRS, SSIS ETL; Implemented retail pricing/forecasting software (AI/ML); DataMart design.

Early Career Highlights (1999-2007):

  • MS SQL Server DBA, Developer, BI roles: Microsoft (MSN, Corp. Security, Operations), Safeco, Expedia.com, Starbucks, T-Mobile, Adaptis, Sound Transit, Stockpot Soup.
  • Key Contributions: DataMart/reporting, SSAS cubes, SSRS/Crystal Reports, large DB migrations (Oracle to MS SQL), ETL (DTS/SSIS), performance tuning (10TB ODS), Classic ASP/VB.NET/SQLCLR dev, systems/log mgt.