Experience

 

Sr. BI Developer [4/2016 – 8/2016] Sandia National Labs – Albuquerque, NM
  • Compare .NET DLL vs In-Report Code
  • Develop .NET Console tools to ensure the performance and success rate of SSRS calls
  • SSRS Development, Training, Optimizations
  • XML Web Service calls for Reporting Services
  • QA measure, test and improve Relational Database Performance
  • Web Browser Automation, Testing, Troubleshooting
ERP Developer [1/2016-3/2016] Boise, ID
  • Implemented ERP software for Small Business clients in Boise
  • Inventory, Accounting, Invoicing, Pricing, Bundling, Discounts, Human Resources
  • ETL import DB, XML, Text, Spreadsheet historical data
  • PostgreSQL Implementation, Backups, Troubleshooting
Data Warehouse Developer [2/2014-1/2015] Gorge Networks – Hood River, OR
  • Provide DB Development, Maintenance and Troubleshooting for mid-sized manufacturing company
  • Projects Replacing Cognos reports with Native Excel PivotTables
  • Warehousing DataMart Design, Dimensional Modeling
  • Database RedGate, Database Projects, Source Control Integration (RDBMS, SSIS, SSRS, SSAS)
  • ETL SSIS, Integration Services – Development, Optimization, Troubleshooting
DBA DB Developer [10/2012-2/2014] Stella Jones McFarland Cascade – Tacoma
  • Provide DB Development, Maintenance and Troubleshooting for mid-sized manufacturing company
  • Training SSRS Mentoring
  • Replacing Cognos reports with Native Excel PivotTables
  • Warehousing DataMart Design, Dimensional Modeling
  • Database RedGate, Database Projects, Source Control Integration (RDBMS, SSIS, SSRS, SSAS)
  • ETL SSIS, Integration Services – Development, Optimization, Troubleshooting, 3RD Party components
  • SSAS OLAP Multidimensional and Tabular, PowerView
  • SSRS Development, Optimization, Troubleshooting
  • System Center Reporting, Schema Repair, Backups Data Protection Manager DPM
DB Architect [12/2011-10/2012] EagleView Technologies HomeDepot.com – St. Paul, MN
  • Implement inventory and pricing applications involving the HomeDepot.com product catalog
  • Training Agile, Relational Design, Stored Procedures, Jr. DBA Training
  • Database Schema Design, Stored Procedures, Code Reuse, SQLCLR, Bitwise
  • DevOps Continuous Integration, Implement Source Control for SSIS, SSRS, RDBMS and DDL Triggers
  • ETL SSIS Integration Services – Development, Testing, Automation
  • SSAS OLAP Development, Prototypes
  • SSRS Development, Training, Optimizations
Senior ETL Developer [10/2010-12/2011] Alliance Enterprises – Lacey, WA
  • ETL Procedures, Troubleshoot Builds, Diagnose Errors for .GOV software provider
  • Database Table Partitioning, VLDB, OLTP, Blob, VarBinary(Max), FileStream
  • ETL SSIS Integration Services – XML Authoring, Development, Optimization, Custom ETL Tools
  • Oracle Query development, Blobs, Linked Servers
  • Visual Basic Visual Basic.NET .NET Console Applications
  • QA Continuous Integration, XML Parsing, Build Reporting, Automation, Source Control, DDL Triggers
DBA Systems Admin [10/2008-10/2010] Division of National Association of Realtors – Tacoma, WA
  • Manage databases and servers for multi-tenant SaaS platforms
  • Training SSRS Mentoring, CRM, Sales Automation, Sales Reporting
  • Administration 15 physical servers, Hyper-V, VmWare, IIS, SQL Server, Scheduling, Troubleshooting, Optimization, Repair
  • Administration 20 Desktops & Non – Production Servers, Printers, Antivirus, Optimization, Automation, Deployment
  • Database Schema Design, stored procedures, tables, indexes, schema, linked servers
  • SSRS Implementation, ReportViewer, Administration, Security – financial, real estate, Google Maps integration
  • Visual Basic Visual Basic.NET Classic ASP VBScript
  • MySQL Development, Installation, Troubleshooting
  • Exchange Administration, Troubleshooting, Outlook Automation
  • Web SEO, XML sitemaps design, IIS Log Management
Web Developer [5/2008-9/2008] AbcLegal.com – Seattle, WA
  • Develop Databases, Applications, Services and Websites for Legal Services firm
  • Troubleshoot RBAR solution from SQL to Set – based Architecture, receiving and sending email messages
  • Database Schema Design, Stored Procedures, Optimization
  • Visual Basic Visual Basic.NET
  • .NET Console Applications
  • QA Address verification software testing, implementation
  • Web Classic ASP VBScript Development, Troubleshooting
Lead Technical Consultant [7/2007-4/2008] G4Analytics – 75% Telecommute 25% Travel – Dallas, TX
  • Implement Pricing & Forecasting software for major retailers
  • Gather Requirements, Lead other developers with minimal supervision
  • Warehousing DataMart Design, Dimensional Modeling, Indexing
  • ETL SSIS Integration Services – development, Design, Maintenance, Testing
  • SSAS – OLAP and Data Mining, development, optimization, testing, querying
  • SSRS development
  • .NET Console Applications
  • QA Development of testing system for comparing results between 5 different database tiers
DB Developer Washington Department of Licensing – Olympia, WA
  • Migrate large .GOV Access application to SQL Server Reporting Services
  • Migrate 120k lines of business logic to SQL Server stored procedures, metadata management solution
  • Database Write hundreds of stored procedures, Schema Design
  • SSRS development, migration from MS Access
  • .NET Console Applications
SSRS Reports Developer Adaptis – Seattle, WA
  • Help large team of developers to migrate from Oracle to MS SQL Server
  • Training Leading Oracle Developers to SQL2005
    SSRS – Form Letters, Implement SoftArtisans ‘Office Writer’
XML XSLT Developer Forensics Firm – Kirkland, WA
  • Deliver XSLT scripts and develop automation scripts & testing tools
  • XML Hundreds of XML Data Files, XSLT Development
  • QA Design, Build and Implement XSLT Testing Harness for large body of XML Exports under variety of XSLT transforms
  • Web Design, Demonstrate and Implement Web Browser Automation
Access Data Projects Developer (MSSQL) Starbucks Corporation – Seattle, WA
Solutions – Improved performance of critical spatial data queries by filtering data
Business Intelligence SSAS DBA Safeco BI Center of Excellence – Seattle, WA
  • Administer 100 cubes on 20 SSAS Servers
  • Configure Security, Scheduling, Documentation, mappings, Connectivity Issues, DB2, TeraData
  • SSAS 2005 migrations and benchmarking
  • Warehousing Dimensional Design, Optimization, Automation, Troubleshooting
  • ETL SSIS, DTS, Automation solution for importing 10,000 Performance Monitor files, log reporting system
  • SSAS OLAP Development, Optimization, Design, Troubleshooting, Automation, performance and for 15 Servers
  • SSAS metadata reporting, collection & analysis, Develop PerfMon reporting solution to track performance over time
  • Visual Basic VBS Scripts, .NET Console Applications for administration utilities, Performance Reporting, Metadata
SharePoint ETL Developer [8/2005-12/2005] (ACS Group) Sound Transit – Seattle, WA
  • Collect, Prioritize requirements from various business owners to understand complex rules
  • Move data from bTrieve database to SharePoint without complex ETL solutions
  • ETL Design, Development, Scripting, Retiring legacy bTrieve system
  • Visual Basic Parsing algorithms, prioritizing and allowing critical data to be extracted where it was not previously searchable
DBA DB Developer – Point of Sale Ultimate Flooring – Renton, WA
  • Develop and implement new Point-of-Sale solution built on MS Access
  • Data Entry, Pricing, Quoting, Invoices, Order Tracking, Inventory
  • Database Schema Design
  • Microsoft Access Form Validation, Pricing Automation, Algorithms
DB Developer [6/2005-7/2005] SQL 2000 (Denali AI) Stockpot – Woodinville, WA
  • Provide DBA services for large manufacturing company while other employees on honeymoon
  • Database Backup, Restore, SQL Locking problems, Replication between AS 400 & SQL Server
SDE IV [1/2005-5/2005] Microsoft Operations Finance – Redmond, WA
  • Design, Build and Implement software solution for replacing merging spreadsheets in budgeting across Microsoft
  • Warehousing Dimensional Modeling, Automation, Relational Design
  • SSAS OLAP Development, Optimization, Design, Troubleshooting, Automation, Holap, Molap and Rolap
  • Visual Basic Classic ASP w/VBScript, VBA
  • Web Classic ASP VBScript, DHTML, COM Components, Development, Debugging, Implementation
Database Developer III [10/2004–12/2004] (SolutionsIQ) Safeco – Seattle, WA
  • Develop DataMart, Reporting and ETL for automating KPI Costing information
  • Web Classic ASP VBScript, DHTML, Development, Debugging, Implementation
  • Warehousing Schema Design, Dimensional Modeling
  • ETL DTS Automation
  • SSAS Development, Optimization, Design, Troubleshooting, Automation, MDX Queries and Optimization
  • SSRS Development, Configuration and Implementation
  • Visual Basic Classic ASP w/VBScript
  • Log SSAS Processing Troubleshooting, Event Log Management for dozens of servers
  • Web Classic ASP VBScript, DHTML, COM Components, Development, Debugging, Implementation
DB Developer IV [7/2004-10/2004] SQL 2000 MSN Quality of Service Microsoft – Redmond, WA
  • Monitor log files for data to investigate customer support issues
  • Web ASP.net error logs for dozens of clusters in order to investigate client problems
  • Log Web Application Troubleshooting MSN Passport Service
  • QA Test Web Clients, SQL Server, Locate and troubleshoot errors in scripts (batch, MSI Installers, Database DDL)
DB Developer III [10/2003-6/2004] SQL 2000 (Computer Associates) Microsoft Corp. Security – Redmond, WA
  • Develop better solution for managing ‘Big Data’ running on 32 bit SQL Server 2000
  • Training SSAS Tutoring for Developers, PivotTable Reporting for Users, DataMart Design, Inman Kimball Principles
  • Improve performance 1000x for 10TB Operational Data Store, a single server Pentium 3 8-socket server
  • Warehousing DataMart Design, Dimensional Modeling, Job Scheduling, troubleshooting, optimization
  • ETL DTS Automation, Scripting, Troubleshooting, Screen – Scraping
  • SSAS OLAP Automation, Troubleshooting, Performance
  • Log ISA Server Intrusion Detection, Event Log Management for hundreds of servers
  • System Center Microsoft Operations Management Implementation
  • Screen-Scraping pulling data from many security websites
  • Web Classic ASP w/VBScript, design, development, debugging, implementation
DB Developer [10/2003-6/2004] SQL 2000 DB Developer [10/2003-6/2004] SQL 2000
  • Develop Performance Management software to measure call center performance
  • Warehousing DataMart Design, Dimensional Modeling
  • ETL DTS – enterprise ETL development, design, DTS Automation, workflow, Visual Basic scripting
  • SSAS Development, Optimization, Design, Troubleshooting, Automation, MDX Queries and Optimization
  • Visual Basic Windows Script Host, VB6, Classic ASP
  • Log Call Center Performance Analysis, Optimization
  • Web Classic ASP VBScript development, Office Web Components, XML
DB Developer [5/2000-11/2001] Briazz IT Accounting – Seattle, WA
  • Solutions manage large investment in Microsoft Access
  • Database Stored Procedures, Schema Design, consolidate data from disparate systems, Enterprise Information System
  • ETL DTS Design, DTS Automation, Visual Basic Scripting, error handling
  • Reporting Crystal Reports, Microsoft Access
  • Microsoft Access Development, Maintenance, migrate to Office 2000 formats, migrate to SQL Server
Data Analyst [11/1999-3/2000] Microsoft / Lernout & Hauspie, Redmond, WA
  • Analyze Data and Record Anomalies
  • Manage Customer Relationship Management solution developed using Microsoft Access
Licensing Analyst [1/1999-11/1999] UltraBac.com, Bellevue, WA
  • Develop Licensing Agreements for software sales
  • Microsoft Access, Log Files, Excel Macros
QA Tester / Access Developer [1/1999-11/1999] Humongous Entertainment, Woodinville, WA
  • Find softwasre defects
  • Work in team of 30 QA Tester
  • Author Access Queries dozens of times per day