Midlothian, VA - 804.754.5866 - scott.newby74@gmail.com - Resume
Senior Solutions Architect / Markel Corporation / Richmond VA /June 2018 - Present
Project - Enterprise DevOps System
Established continuous monitoring platform to monitor DevOps processes and automated testing along with other business KPI's
Utilized SQL Server, PostgreSQL, and various other sources of data to ingest into the continuous monitoring platform using Logstash
Used python, node.js, and ruby in various projects to provide monitoring capabilities
Senior Data Warehouse Developer / Department of Energy / Washington DC - Oak Ridge National Lab / March 2015 - June 2018
Project - National Power Outage Tracking - GIS
Responsible for improvements & maintenance of ongoing power-outage data collection ETL processes
Introduced OLAP star-schema, data warehousing, and reporting using SSAS and SSRS
Improved population coverage by 15% and ETL performance by 40% using spatial query logic
Data Warehouse Consultant / Logexsoft / Richmond VA / January 2015 - March 2015
Primarily responsible for designing databases and analyzing reports for federal reporting by the client company.
I also participated in data governance meetings and creating requirements for required reports.
Senior Data Warehouse Architect & Developer / Virginia DMV / Richmond VA / May 2007 - January 2015
Introduced OLAP star schema data warehousing and reporting using SSAS and SSRS.
Created SSIS packages for the import and export of system related data.
Improved data quality by integrating data validation into SSIS routines.
Created self-service access to data using SSRS Report Builder and semantic models, along with pre-defined parameterized reports.
Incorporated ArcGIS to enhance geographic reporting within TREDS.
ETL Developer / Health Management Corporation (Anthem) / Richmond VA / November 2007 - May 2008
Support, maintain, and significantly improve SSIS packages in support of the business.
SSIS process execution was improved from 16 or more hours to less than 45 minutes.
Senior Database and Application Developer / Ultratec Inc. / Madison WI / 2004 - November 2007
Architected and developed OLAP star schema data warehousing to improve efficiency of generating billing statements.
Data & process migration from Microsoft Access to Microsoft SQL Server
Improved performance from days to minutes.
Utilized SSRS to generate billing statements and standardized reporting.
Prototyped online applications using AJAX to deliver near-real-time voice transcription between the Ultratec call center and customers.
Application Developer / EDCI / Madison WI / 2003 - 2004
Application Developer / University of Wisconsin / Madison WI / 2001 - 2003
Application Developer and Team Lead / Optimator / Madison WI / 2000 - 2001
Application Developer / ProveIT / Madison WI / 1999 - 2000
Application Developer / Merrill Corporation / St. Paul MN / 1998 - 1999
Application Developer / The Talus Group /Minneapolis MN / 1997 - 1998
Economist and Junior Programmer / USDA / Madison WI / 1996 - 1997
Relational Databases
SQL Server
PosgreSQL
Analytic Databases
SQL Server Analysis Services - SSAS
Pentaho
NoSQL Databases
Elastic Search
ETL Tools
SQL Server Integration Services - SSIS
ElasticSearch - Logstash
Azure
Terraform
Google Cloud Platform (GCP)
Database
SQL Server Spatial Data Types and Functions
PostgreSQL - PostGIS - Spatial Data Types and Functions
Platforms
ArcGIS Online
QGIS - open source
Reporting
SQL Server Reporting Services
ElasticSearch - Kibana
Analytics
Predictive Analytics - SSAS & Visual Studio
Machine Learning - ElasticSearch
SQL / PLSQL
Node.JS
Python
Ruby
HTML / Javascript
R
University of Wisconsin - Madison - 1992 - 1997
BS Agricultural Economics