Tony Spencer Email & Phone Number

Data Engineer with work spanning Data Engineering, Data Analysis, and Business Analysis.Select projects:*City Utility Database and Dashboard Project: developed data model, database objects and ETLs that ingest and integrate data from on-prem SQL server, REST API, MS Sharepoint. Automated anomaly detection in ETL using SARIMA+ESD to alert staff to anomalous power consumption. Created dashboard front end in PowerBI. Saved City ~$80k/year by eliminating the impending need for an external software solution.*Nuisance Database and Dashboard Project: developed data model, database objects and ETLs that ingest and integrate data from on-prem SQL server, Energov, OneSolution, GIS server, AGOL API. ETLs perform complex geospatial and address transformations to aggregate into a single repository of nuisance incidents. Navigated issues with varying levels of data sensitivity. Built PowerBI dashboard, performed analyses in R and presented results to directors, City manager, and City Council on numerous occasions. *Fire Data Integration Project: developed data model, database objects and ETLs that successfully and efficiently ingest and integrate data from 3rd party API known to have issues with schema drift and complex data structure that have given numerous fire departments across the country costly and lengthy issues with integration. *Analytics database offerings: architected data hub and analytics database approach to offer analytics databases to departments throughout the City. Standardizes ability to offer access to data for departments, envisions use cases with varying data sensitivities, considers single and shared data ownership use cases, and is optimized for DBA management of user access to improve enterprise data management.

Colorado, United States

Principal Consultant providing data engineering, data analytics, and business intelligence services.

Fort Collins, Colorado Area

Engineer in municipal government with experience in Data Engineering, Data Analysis, and Business Intelligence.Select projects:*Reporting system for water use analytics: architected and developed dimensional database in SQL Server, developed and deployed ETLs to populate, created front-end reporting tool in PowerBI. Automated a previously manual process that cut staff time to produce recurring reports by ~80%.*Custom-coded long range planning app: project manager and technical contributor on software development project for long range planning tool. Expanded on open-source DSS tool to add custom functionality needed to adequately represent system, including MODSIM base model, custom code in VB.Net and C#, and RDBMS in SQL Server. App cut staff time needed to simulate planning scenarios by ~90%. RDBMS tracking of prior simulations eliminated duplicative model runs. Metrics engine tracking in RDBMS allowed detailed evaluation of multiple planning scenarios.*Analysis of residential and commercial water use: used R to perform linear regression to model water use based on explanatory variables such as business type, size.*Founded a Data Analytics Team: created a cross-departmental data community that met on a monthly basis to align business processes and foster community across divisions, leverage knowledge across groups to improve data-driven strategic decision making and improve business outcomes.*Presented work to other City departments, government entities, and the public about complex issues and data analyses, successfully explaining complex concepts to audiences with varying levels of data literacy.

Fort Collins, Colorado Area

Engineer in a consulting firm specializing in assisting Native American tribes with water rights issues.Select projects:*Acted as technical expert on behalf of Native American tribes in meetings with multiple governments, resource agencies, and the public*Designed and implemented environmental impact studies, and prepared technical documents and regulatory filings*Successfully navigated complex and controversial engineering projects, and presented work in public forums*Gave presentations educating tribal councils, government agencies and public about water resources and water rights issues

Fort Collins, Colorado Area

Master Of Science (M.S.), Engineering

Bachelor Of Science (B.S.), Engineering

Activities and Societies: AMD Jerry Sanders Annual Design Competition