Resume

I'm hoping I can put my experience doing data analytics and my background in geological engineering towards helping our environment not collapse.

Data Engineering: SQL Server/T-SQL, Python, SSIS, ETL development, Data Warehouse development
Data Analysis: Data analysis and presentation, Power BI/DAX, SSRS, Pandas, some GIS
System Administration: Linux/Unix, Git, Bash/PowerShell, some SQL Server Administration
Other Technical Skills: C, some PHP, Apache2, MySQL, Some web development (see this website), NeoVim, VSCode, Xcode, Visual Studio, Smart Sheet, Excel
Soft Skills: Some project management, Team leadership, Mentoring other analysts, Soliciting user requirements, User stories, Software testing
Skills I haven't used in a while: Field work, field mapping, GIS

Built and maintain Power BI and SSRS reports.
Mortality ETL Project using SSIS, then converted to Python
DOH Serologies Project in Python
Organ utilization dashboard in Power BI
Worked with management to determine requirements for new dashboards.
Trained new BI team members on T-SQL/SQL server and SSRS.
Greatly sped up and reduced crashes on chart inspection project.
Leading effort to migrate SSRS reports to Power BI Paginated reports.
Presented data in weekly quality meetings and monthly staff meetings.
Implemented Github as source control for BI projects. Trained BI Coordinator usage.

Created and maintain the blog ninecirclesofshell.com, hosted on Linode.
Wrote a blog engine in PHP to handle article and image uploads; publishing and deleting entries; traffic monitoring and front page generation.
Wrote a simple REST API in PHP to expose blog entries as JSON.

Some of these I've basically abandoned. c_roll is under active development since I actually use it sometimes. Main projects page.

c_roll: A terminal based table top RPG dice roller.
Jurn: A MacOS journaling app written using Objective-C and Cocoa.
Colonnade: A utility written in Swift that converts a CSV file to a Markdown table based on the CommonMark specification.
mdsplit: A C# utility to split Markdown output from exported Ulysses sheets into individual files.

Wrote agile user stories for scripts and SQL based reports based on business requirements solicited from business management.
Coordinated with business units, developers and compliance office to ensure requirements were properly implemented and up to federal standards.
Tested development builds of scripts and SQL reports.
Wrote SQL queries to determine populations of test data.
Led a 1000+ hour project to automate Income Driven Loan forgiveness process.

Worked on project mapping risk to infrastructure from irrigation ditch failures in Reno, NV
- Used satellite imagery and field surveys to assess risk to infrastructure
- Flood hazard and mitigation potential for irrigation ditches
Sold publications to general public
Shipped orders
Printed new maps as needed
Helped public find maps and publications they needed
Helped migrate online store to new platform

Data entry for Abondoned Mines program
Found new mine locations in BLM documents and made maps for field teams to find them
Worked with Walker River Paiute Tribe to close mines on tribal land

B.S. Geological Engineering University of Nevada, Reno - Completed 2016

Associates Degree in Computer Science Salt Lake Community College - 2018

Nine Circles of Shell