Experience – (P)eachy (W)ebsites

Software Engineer
IT Consultant · Freelance
Jan 2018 – Present · 6 yrs 11 mosJan 2018 to Present · 6 yrs 11 mos
Portland, Oregon Metropolitan Area · HybridPortland, Oregon Metropolitan Area · Hybrid

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
Jan 2018 – Present · 6 yrs 11 mos
Portland, Oregon Metropolitan Area

Sr Business Intelligence Developer
Sr Business Intelligence Developer
Sandia National Laboratories · ContractSandia National Laboratories · Contract
Mar 2016 – Aug 2016 · 6 mosMar 2016 to Aug 2016 · 6 mos
Albuquerque, New Mexico Area · On-siteAlbuquerque, New Mexico Area · On-site

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 Small Projects
Software Developer, Various Small Projects
Small Contracts · ContractSmall Contracts · Contract
Feb 2011 – Feb 2016 · 5 yrs 1 moFeb 2011 to Feb 2016 · 5 yrs 1 mo
Remote · RemoteRemote · Remote

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

DataWarehouse | DB Developer | Business Intelligence
DataWarehouse | DB Developer | Business Intelligence
Gorge Networks · Part-timeGorge Networks · Part-time
Jun 2013 – Jan 2015 · 1 yr 8 mosJun 2013 to Jan 2015 · 1 yr 8 mos
Remote · RemoteRemote · Remote

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
Sr DBA | DB Developer
McFarland Cascade · Full-timeMcFarland Cascade · Full-time
Oct 2012 – Feb 2014 · 1 yr 5 mosOct 2012 to Feb 2014 · 1 yr 5 mos
Tacoma, WA · On-siteTacoma, WA · On-site

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 | DBA | DB Developer | Business Intelligence
Database Architect | DBA | DB Developer | Business Intelligence
EagleView Technologies – building services for HomeDepot.com · Full-timeEagleView Technologies – building services for HomeDepot.com · Full-time
Dec 2011 – Oct 2012 · 11 mosDec 2011 to Oct 2012 · 11 mos
St Paul, Minnesota · On-siteSt Paul, Minnesota · On-site

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 | DBA | DB Developer | Business Intelligence
Sr ETL Developer | DBA | DB Developer | Business Intelligence
Alliance Enterprises · Full-timeAlliance Enterprises · Full-time
Nov 2010 – Dec 2011 · 1 yr 2 mosNov 2010 to Dec 2011 · 1 yr 2 mos
Greater Seattle Area · On-siteGreater Seattle Area · On-site

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
Systems Admin | DB Developer
ePropertyData · Full-timeePropertyData · Full-time
Oct 2008 – Nov 2010 · 2 yrs 2 mosOct 2008 to Nov 2010 · 2 yrs 2 mos
Greater Seattle Area – Division of the National Association of RealtorsGreater Seattle Area – Division of the National Association of Realtors

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.

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 | DBA | DB Developer | Business Intelligence
Lead Technical Consultant | DBA | DB Developer | Business Intelligence
G4 AnalyticsG4 Analytics
Jun 2007 – Apr 2008 · 11 mosJun 2007 to Apr 2008 · 11 mos
Houston, Texas Area | Commute & TelecommuteHouston, Texas Area | Commute & Telecommute
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
Business Intelligence Architect
Expedia, Inc.Expedia, Inc.
Jun 2007 – Jun 2007 · 1 moJun 2007 to Jun 2007 · 1 mo
Bellevue, WABellevue, WA
Migrate cubes from SQL Server 2000 to 2006
Develop Test Harness to Test Existing Adhoc Reports

DB Developer | Business Intelligence
DB Developer | Business Intelligence
AETEA Information TechnologyAETEA Information Technology
Mar 2007 – May 2007 · 3 mosMar 2007 to May 2007 · 3 mos
Greater Seattle AreaGreater Seattle Area
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
DB Developer | Business Intelligence
AdaptisAdaptis
Sep 2006 – Dec 2006 · 4 mosSep 2006 to Dec 2006 · 4 mos
Greater Seattle AreaGreater Seattle Area
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)

ETL Developer | Visual Basic
ETL Developer | Visual Basic
Sound TransitSound Transit
Sep 2005 – Dec 2005 · 4 mosSep 2005 to Dec 2005 · 4 mos
Seattle, WASeattle, WA
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 | Business Intelligence
DBA | DB Developer | Business Intelligence
StockPot, Inc.StockPot, Inc.
Jul 2005 – Aug 2005 · 2 mosJul 2005 to Aug 2005 · 2 mos
Woodinville, WAWoodinville, WA
SQL Backup / Restore
Troubleshoot SQL Locking problems
Configure / Troubleshoot AS/400 & SQL Server Replication

DB Developer | Business Intelligence
DB Developer | Business Intelligence
Russell InvestmentsRussell Investments
Jun 2005 – Jul 2005 · 2 mosJun 2005 to Jul 2005 · 2 mos
Tacoma, WATacoma, WA
Sybase Stored Procedures
Develop reports using Crystal Reports, Access, VB6

Safeco – Business Intelligence Center of Excellence
Safeco – Business Intelligence Center of Excellence
9 mos9 mos
Seattle, WASeattle, WA
DBA | DB Developer | Business Intelligence
DBA | DB Developer | Business Intelligence
2005 – Jun 2005 · 6 mos2005 to Jun 2005 · 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
Data Warehouse | DB Developer | Business Intelligence
Data Warehouse | DB Developer | Business Intelligence
Oct 2004 – Jan 2005 · 4 mosOct 2004 to Jan 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

Microsoft
Microsoft
10 mos10 mos
Software Design Engineer IV | DBA | DB Developer | Business Intelligence
Software Design Engineer IV | DBA | DB Developer | Business Intelligence
Jan 2005 – May 2005 · 5 mosJan 2005 to May 2005 · 5 mos
Redmond, WARedmond, WA
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 mosAug 2004 to Dec 2004 · 5 mos
Microsoft Campus – MSN Quality of ServiceMicrosoft 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

DB Developer
DB Developer
ACS GroupACS Group
2001 – 2005 · 4 yrs2001 to 2005 · 4 yrs
RemoteRemote
Access Development / VBA / Database Design

DB Developer III
DB Developer III
Microsoft – Corporate SecurityMicrosoft – Corporate Security
Oct 2003 – Jun 2004 · 9 mosOct 2003 to Jun 2004 · 9 mos
Redmond, WARedmond, WA
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
Sr Analyst / DB Developer
T-MobileT-Mobile
Jan 2003 – Jul 2003 · 7 mosJan 2003 to Jul 2003 · 7 mos
Bellevue, WABellevue, WA
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
DB Developer
MicroscanMicroscan
Sep 2002 – Dec 2002 · 4 mosSep 2002 to Dec 2002 · 4 mos
Renton, WARenton, WA
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

DB Developer | Web Developer
DB Developer | Web Developer
ETI TravelETI Travel
Jun 2002 – Dec 2002 · 7 mosJun 2002 to Dec 2002 · 7 mos
Kirkland, WAKirkland, WA
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
DB Developer
Jameco ElectronicsJameco Electronics
Apr 2002 – Aug 2002 · 5 mosApr 2002 to Aug 2002 · 5 mos
San Francisco Bay AreaSan Francisco Bay Area
Developed and optimized custom databases, reports & applications
ETL Automation-Importing data from AS400 / DB2
VB6 Optimization, Troubleshooting and Implementation

RAS Builders Inc. logo
DB Developer | DBA
DB Developer | DBA
RAS BuildersRAS Builders
Jan 2002 – Jun 2002 · 6 mosJan 2002 to Jun 2002 · 6 mos
Issaquah, WAIssaquah, WA
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 logo
DBA | DB Developer
DBA | DB Developer
briazzbriazz
May 2000 – Nov 2001 · 1 yr 7 mosMay 2000 to Nov 2001 · 1 yr 7 mos
South SeattleSouth Seattle
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
Reporting Developer
DeepCanyon.com / Hewlett PackardDeepCanyon.com / Hewlett Packard
Mar 2000 – May 2000 · 3 mosMar 2000 to May 2000 · 3 mos
Seattle, WASeattle, WA
Access Queries, Reports
Oracle Reporting
WebTrends IIS Log Analysis

Lernout and Hauspie Speech Products logo
Test Engineer
Test Engineer
Lernout and Hauspie Speech ProductsLernout and Hauspie Speech Products
Oct 1999 – Apr 2000 · 7 mosOct 1999 to Apr 2000 · 7 mos
Microsoft Redmond CampusMicrosoft Redmond Campus
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
Sales Support Analyst
UltraBac Software IncUltraBac Software Inc
Jan 1999 – Nov 1999 · 11 mosJan 1999 to Nov 1999 · 11 mos
Bellevue, WABellevue, WA
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
QA Engineer
Humongous EntertainmentHumongous Entertainment
May 1997 – Aug 1997 · 4 mosMay 1997 to Aug 1997 · 4 mos
Woodinville, WAWoodinville, WA
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