Resume
BI Analyst/Developer. Trying to use data to make the world better.
Skills
- SQL Server/T-SQL.
- Data Warehouse design.
- Programming languages: T-SQL, DAX, Python, C#, PHP, Swift, Java, Objective-C, C, Javascript, Bash scripting.
- Other technologies: Power BI, PBI Paginated Reports, SSRS, SSIS, ETL Development, Git, HTML, CSS, Ubuntu, Apache2, Regular Expressions, Xcode, Visual Studio.
- Soliciting Business requirements for application development projects.
- Data analysis and presentation.
- Writing Agile user stories.
- Software testing.
Experiences
BI Analyst (2021 - Present)
- Built and maintain Power BI and SSRS reports.
- Built ETL process using SSIS and T-SQL.
- Worked with management to determine requirements for new dashboards.
- Trained new BI team members on T-SQL/SQL server and SSRS.
- Mentored and guided new BI team members on technical matters.
- Designed data warehouse.
- 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.
Solo Web Development (2019 - Present)
- 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.
Other Solo Projects (2018 - Present)
- 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.
Business Systems Analyst (various other positions), UHEAA; Salt Lake City, UT (2016 - 2020)
- 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.
Education
B.S. Geological Engineering University of Nevada, Reno - Completed 2016
Associates Degree in Computer Science Salt Lake Community College - 2018