Software Engineer
IT Consultant (Freelance), Remote
Dec 2000 to Present / 24 yrs 2 mos

  • Developed innovative solutions for data rescue, wifi penetration testing, Android security, databases, and web design in a hybrid work environment.
  • Trained less technical individuals to understand technology, bridging the gap between technical and non-technical teams.
  • Conducted troubleshooting and testing for cPanel and VestaCP to ensure smooth operations.

WordPress Developer
Aaron Kempf, Inc (Freelance), Portland, OR / Remote
Jan 2018 – Present / 6 yrs 11 mos

Sr BI Developer
Sandia National Laboratories (Contract), Albuquerque, NM / On-site
Contract Mar 2016 – Aug 2016 / 6 mos

  • Developed custom browser automation tools using .NET Console Applications to streamline processes.
  • Implemented SSRS DLL to centralize business logic and improve data reporting efficiency.

Software Developer
Various Projects (Part-time), Remote
Feb 2011 – Feb 2016 / 5 yrs 1 mo

  • Developed database designs for various small projects using SQL Server, mySQL, and Postgres.
  • Prototyped and tested Hadoop HortonWorks for data processing efficiency.
  • Conducted troubleshooting and testing for Microsoft Office, Visual Studio and SQL Server BI Tools

Data Warehouse Developer / DB Developer / Business Intelligence
Gorge Networks (Part-time), Hybrid
Jun 2013 – Jan 2015 / 1 yr 8 mos

  • Developed ETL processes for storing reporting and performance metrics, enhancing data accuracy and efficiency.
  • Trained developers and end users on SSAS/Olap, improving data analysis capabilities.
  • Designed and implemented Datamart for dimensional modeling, optimizing data storage and retrieval.
  • Automated SSIS/Integration Services tasks, streamlining data integration processes.

Sr DBA / DB Developer
McFarland Cascade (Full-time), Tacoma, WA / On-site
Oct 2012 – Feb 2014 / 1 yr 5 mos

  • Developed SSIS packages for accounting, billing, and archiving using 3rd party components from ‘Pragmatic Works’ and ‘CodePlex’.
  • Designed Datamarts and implemented Dimensional Modeling for efficient data storage and retrieval.
  • Trained 2 developers on SSRS Reporting Services for optimized reporting and troubleshooting.

Database Architect
EagleView Technologies – building services for HomeDepot.com (Full-time), St Paul, MN / On-site
Dec 2011 – Oct 2012 / 11 mos

  • Developed and optimized complex relational database algorithms using SQL Server 2012 and SQLCLR 2.0/4.0.
  • Led the development, testing, automation, and training of junior DBAs in SSIS/Integration Services at EagleView Technologies.
  • Implemented SSRS/Reporting Services solutions and SSAS/Analysis Services for prototype reporting applications.

Sr ETL Developer / DB Developer / Business Intelligence
Alliance Enterprises (Full-time), Olympia, WA / On-site
Nov 2010 – Dec 2011 / 1 yr 2 mos

  • Developed ETL processes using SQL Server 2005/2008, XML, and Oracle queries for Alliance Enterprises.
  • Implemented Table Partitioning and Source Control Integration for efficient data management.
  • Automated ETL processes, resulting in increased efficiency and accuracy in data reporting.
  • Collaborated with cross-functional teams to design and implement proprietary ETL packages.

Systems Admin / DB Developer
ePropertyData – a Division of the National Association of Realtors (Full-time), Tacoma, WA / On-site
Oct 2008 – Nov 2010 / 2 yrs 2 mos

  • Designed and implemented SSRS reporting services for financial and real estate data with Google Maps integration.
  • Managed and optimized SQL Server 2008 stored procedures, tables, and indexes for efficient data retrieval.
  • Administered 15 physical servers, including IIS and SQL Server, ensuring smooth operation and scheduling.

Web Developer / DB Developer
ABC Legal Services (Full-time), Seattle, WA / On-site
May 2008 – Jul 2008 / 3 mos

  • Developed SQL Server stored procedures, databases, and applications for ABC Legal Services in the Greater Seattle Area.
  • Implemented address verification software testing and schema design for efficient data management.
  • Created .NET Console Applications for consuming and sending text messages, enhancing communication capabilities within the company.
  • Developed SQL Server stored procedures, databases, and applications for ABC Legal Services in the Greater Seattle Area.
  • Implemented address verification software testing and schema design for efficient data management. • Created .NET Console Applications for consuming and sending text messages, enhancing communication capabilities within the company.
    Skills: ASP | Database Design | Databases | Visual Basic | Business Analysis

Lead Technical Consultant
G4 Analytics (Full-time), Houston, TX / Hybrid
Jun 2007 – Apr 2008 / 11 mos

  • Schema Design / Datamart Design / Dimensional Modeling
  • SSAS / Analysis Services-development, querying
  • SSRS / Reporting Services-development
  • SSIS / Integration Services-development, design, maintenance
  • Design large solution(s) with minimal supervision
  • Automate and improve hundreds of existing database objects
  • Implement indexing strategies
  • Development of testing system for finding cross-database inaccuracies

Business Intelligence Architect
Expedia Inc (Contract), Bellevue, WA / On-site
Jun 2007 – Jun 2007 / 1 mo

  • Migrate cubes from SQL Server 2000 to 2006
  • Develop Test Harness to Test Existing Adhoc Reports

DB Developer / Business Intelligence
.GOV / AETEA Information Technology (Contract), Olympia, WA / On-site
Mar 2007 – May 2007 / 3 mos

  • SSRS / Reporting Services – development, migration
  • Migrate 120k lines of business logic to SQL Server stored procedures
  • Write hundreds of stored procedures
  • Manage Development schedules, develop & implement metadata management solution
  • Design complex systems with minimal supervision

DB Developer / Business Intelligence
Adaptis (Contract), Seattle, WA / On-site
Sep 2006 – Dec 2006 | 4 mos

  • Datamart Design / Dimensional Modeling
  • SSAS / Analysis Services – Automation, Troubleshooting, Performance, Consulting
  • SSRS / Reporting Services 2005, Soft Artisans Office Writer
  • Author TSQL statements against a large schema (800+ tables)

XML Developer / DB Developer
Forensics: eDiscovery (Contract), Kirkland, WA / On-site
Oct 2006 – Nov 2006 / 2 mos

  • XSLT Development
  • Schema Design
  • DevOps / Build Automation

ETL Developer / Visual Basic
Sound Transit (Contract), Seattle, WA / On-site
Sep 2005 – Dec 2005 / 4 mos

  • Design and develop ETL for retiring legacy bTrieve system.
  • Work with various business owners to understand complex rules
  • ETL scripting solution for parsing of document titles, definitions

DBA / DB Developer
StockPot Inc (Contract), Woodinville, WA / On-site
Jul 2005 to Aug 2005 | 2 mos

  • SQL Backup / Restore
  • Troubleshoot SQL Locking problems
  • Configure / Troubleshoot AS/400 & SQL Server Replication

DB Developer
Russell Investments (Contract), Tacoma, WA / On-site
Jun 2005 to Jul 2005 / 2 mos

  • Sybase Stored Procedures
  • Develop reports using Crystal Reports, Access, VB6

Business Intelligence / DB Developer
Safeco / Business Intelligence Center of Excellence (Contract), Seattle, WA / On-site
Jan 2006 to Jun 2006 | 6 mos

  • SSAS / Analysis Services-Development, Optimization, Design, Troubleshooting, Automation
  • SSAS / Analysis Services-Manage performance and availability for 15 Servers
  • SSAS / Analysis Services-metadata reporting, collection & analysis
  • SSAS / Analysis Services-Develop PerfMon collection + reporting solution to track performance over time
  • DTS Automation solution for importing 10,000 Performance Monitor files
  • Configure security roles / mappings, Assign Permissions, Manage DNS cNames
  • Troubleshoot connectivity problems-2005 x64, DB2, TeraData, OWC
  • Develop administration utilities using VBS, XMLA and VB 2005
  • ETL / log reporting system
  • SSAS / Analysis Services-Development, Optimization, Design, Troubleshooting, Automation SSAS / Analysis Services-Manage performance and availability for 15 Servers SSAS / Analysis Services-metadata reporting, collection & analysis SSAS / Analysis Services-Develop PerfMon collection + reporting solution to track performance over time DTS Automation solution for importing 10,000 Performance Monitor files Configure security roles / mappings, Assign Permissions, Manage DNS cNames Troubleshoot connectivity problems-2005 x64, DB2, TeraData, OWC Develop administration utilities using VBS, XMLA and VB 2005 ETL / log reporting system

Business Intelligence / DB Developer
Safeco (Contract), Seattle, WA / On-site
Oct 2004 to Dec 2005 / 4 mos

  • SSRS / Reporting Services-Development, Configuration and Implementation
  • Classic ASP / VbScript-development, debugging & implementation
  • SSAS / Analysis Services-Development, Optimization, Design, Troubleshooting, Automation
  • DTS Automation
  • MDX Queries and Optimization

Software Design Engineer IV
Microsoft – Operations (Contract), Redmond, WA / On-site
Jan 2005 to May 2005 / 5 mos

  • SSAS / Analysis Services-Development, Optimization, Design, Troubleshooting, Automation
  • Classic ASP / VbScript-development, debugging & implementation
  • VB.net, VB6, ASP, DHTML development
  • SQL Server Modeling, Automation, Relational Design
  • SSAS / Analysis Services-Development, Optimization, Design, Troubleshooting, Automation Classic ASP / VbScript-development, debugging & implementation VB.net, VB6, ASP, DHTML development SQL Server Modeling, Automation, Relational Design
  • DB Developer IV – MSN Quality of Service
  • DB Developer IV – MSN Quality of Service
    Aug 2004 – Dec 2004 | 5 mos
    Microsoft Campus – MSN Quality of Service
  • Parse log files, build database automation procedures, automate work flow, etc
  • SSRS / Reporting Services testing, exploration and recommendation
  • Find errors in scripts (batch, MSI Installers, Database DDL)
  • Datamart Design / Dimensional Modeling
  • Parse ASP.net error logs for production MSN systems in order to investigate problems
  • Test for accuracy and consistency of complex stored procedures
  • Access Development / VBA / Database Design

DB Developer III
Microsoft – Corporate Security (Contract), Redmond, WA / On-site
Oct 2003 – Jun 2004 / 9 mos

  • Intrusion Detection / Log Analysis. VLDB, Datamart, DTS Automatation, Implementation of Analysis Services databases (dozens).
  • Classic ASP / VbScript-design, development, debugging & implementation
  • SSAS / Analysis Services – Automation, Troubleshooting, Performance
  • DTS Automation-Scripting, Troubleshooting, Screen-Scraping
  • Datamart Design / Dimensional Modeling
  • SSAS / Analysis Services – Training developers
  • SSAS / Analysis Services – Training End-Users
  • SQL Server Job Scheduling, troubleshooting and optimization

Sr Analyst / DB Developer
T-Mobile (Full-time), Bellevue, WA / On-site
Jan 2003 to Jul 2003 / 7 mos

  • Schema Design / Datamart Design / Dimensional Modeling
  • SSAS / Analysis Services development-databases, queries, data marts and reports
  • DTS Automation-development, design, automation, shaping, job workflow/scheduling
  • Classic ASP / VbScript – development
  • Office Web Components, Excel Pivot Tables, VB6, XML, MDX

DB Developer
Microscan (Contract), Renton, WA / On-site
Sep 2002 to Dec 2002 / 4 mos

  • Migrate 100s of Access Queries to SQL Server Stored Procedures
  • Re-write 100 Access Reports as Crystal Reports, deploy into Crystal Enterprise
  • Classic ASP / VbScript-development, debugging & implementation

Full Stack Developer
ETI Travel (Contract), Kirkland, WA
Jun 2002 to Dec 2002 / 7 mos

  • Crystal Reports 8.5 – Report Development, Testing, Migrations
  • VB / SQL CRM Development
  • Classic ASP / VbScript-development, debugging & implementation
  • ETL / screen-scraping application
  • Datamart Design / Dimensional Modeling

DB Developer
Jameco Electronics (Contract), San Francisco Bay Area
Apr 2002 to Aug 2002 / 5 mos

  • Developed and optimized custom databases, reports & applications
  • ETL Automation-Importing data from AS400 / DB2
  • VB6 Optimization, Troubleshooting and Implementation

DB Developer
RAS Builders Inc (Contract), Issaquah, WA
Jan 2002 – Jun 2002 | 6 mos

  • Migration of large system from Access to SQL Server.
  • Migration of business logic from Jet Queries to SQL Server Stored Proceudres
  • Migration of forms from Accesss/Jet to Access Data Projects

Briazz Inc
DBA / DB Developer (Contract-To-Perm), South Seattle
May 2000 to Nov 2001 / 1 yr 7 mos

  • Schema Design
  • Developed Reporting & Data Entry Solutions for ERP, CRM, General Ledger, Auditing and Sales
  • Developed & maintained SQL Server and Microsoft Access Databases, Applications and Reports
  • Developed Enterprise Information System for reporting on a dozen data feeds
  • SQL Server-Stored Procedures
  • Access Development, Maintenance
  • Access to SQL Migrations
  • SSAS / Analysis Services – Development / Prototypes for Mission-Critical EIS / DSS

Reporting Developer / Log Reporting
DeepCanyon.com / Hewlett Packard (Contract), Seattle, WA
Mar 2000 – May 2000 / 3 mos

  • Access Queries, Reports
  • Oracle Reporting
  • WebTrends Apache / IIS Log Analysis

QA Test Engineer
Lernout and Hauspie Speech Products, Microsoft Redmond Campus
Oct 1999 – Apr 2000 / 7 mos

  • Collected and audited spoken data for the testing of Voice Recognition software
  • Demonstrated Project Management principles in keeping project ahead of schedule

Sales Support Analyst
UltraBac Software Inc (Full-time), Bellevue, WA
Jan 1999 to Nov 1999 / 11 mos

  • Created Licensing Inventory Spreadsheets to analyze the licensing needs of clients
  • Authored corporate naming conventions / standards for Goldmine CRM data entry
  • Authored Excel VBA that enabled the automation of repetitive tasks
  • Data Consolidation

QA Engineer
Humongous Entertainment (Contract), Woodinville, WA
May 1997 to Aug 1997 / 4 mos

  • Wrote 100s of Access Queries to improve the quality of bug reports
  • Searched for bugs and worked in a team environment in order to determine the accuracy of bug reports