Seth Garrett

Experience

• 

  Pivotal Tax Solutions, LLC

  Nov 2007 - Mar 2008

  Accounting Staff

  Responsible for basic property tax issues.Assisted in developing a company database.

• 

  Arizona Department of Revenue

  Sept 2010 - Jul 2016

  - Predictive Analytics on big data for audit lead selection (SQL)- Utilize Visual Basic for Applications (VBA) programming language to maintain and update existing AZDOR tax calculation programs and databases (MS Access and MS Excel VBA).- Assist in the development of new tax calculation software that will be utilized by all of the cities in Arizona.- Design new Access databases for special tax types.- Maintain and develop 70 front-end and 20 back-end databases including SQL Server.- Perform queries and prepare reports for management.- Incorporate secure programming practices and internal controls to mitigate the risk of any internal or external threat to confidential tax information. Show less -- Specialize in TPT, USE, and Withholding tax audit.-- Lead Auditor with experience balancing many complex large audits. -- Advanced MS Excel usage.-- Applied understanding of tax law to search databases for companies exhibiting potential tax non-compliance.-- Analyzed many accounting records, including charts of accounts, general ledger summaries, sales records, bank statements, invoices, expense account detail, and other various documentation.-- Traveled interstate and locally to interview CEOs/CPAs of large businesses. Toured facilities and learned the processes of various types and forms of businesses.-- Researched Arizona statutes, administrative code, and court cases applicable to the taxpayer’s business activities and made decisions regarding completeness of tax base, validity of deductions, and other decisions.-- Compiled requested/received data in MS Excel, and used Excel for a variety of functions, including compiling, organizing, creating formulas, creating ratios, etc. Show less

  • Information Technology Specialist III

    Feb 2014 - Jul 2016

  • Revenue Field Auditor III

    Jan 2012 - Jan 2014

  • Revenue Field Auditor II

    Sept 2010 - Jan 2012
• 

  Educational Growth Gaming Systems LLC

  Jan 2011 - Jan 2013

  President

  I worked part-time as President of Educational Growth Gaming Systems LLC. I designed a variety of products and coordinate the production, marketing, and sales.

• 

  SkyTouch Technology

  Apr 2018 - Jun 2020

  Software Engineer I

  *Technology and Delivery*- Successfully managed code merges and database upgrades for 27 version of the web app and deployed to QA and PROD as Buildmaster - Java development for bug fixes and unit testing (front-end and back-end)*Resiliency and Performance Enhancement*- T-SQL stored procedures upgraded to be sargable and improve efficiency by 10%- Implemented indexes and keys in the database to improve efficiency by 70%- Transaction management adjustments to improve efficiency and reduce writelog waits by 90%.- Created a script that routinely cleans up bad data in the database.- Audited Spring web app security, identified and fixed security issues. *AWS Migration*- Upgraded configurations and altered app code to allow apps to migrate to AWS.- Built JMS bridge applications to assist in processing ActiveMQ messages.- Optimized messaging configurations by configuring policies and consumer/producer adjustments. Show less