Demo of a script that I wrote in python that logs into Grants Portal and updates our Recipient Point of Contact (POC) and our Alternate Recipient POC for all Applicant Event Profiles (AVPs). This script saves FDEM about $5k every time it needs to be used.

It also creates lists of processed AVPs, AVPs that need subrecipient contact updates, and AVPs that get skipped due to error handling. When the program finishes, it puts those lists in csv files in a folder for review. This script mostly utilizes Selenium, but also uses Pandas for some of the work with the lists. To see the code, please visit https://github.com/Passett/Data_Entry_Automation.

Demo of a script that I wrote in python that downloads files from FloridaPA and Grants Portal daily, where no api is available to grab the data. This is done with Selenium and a few other libraries. I currently only move these files to a shared drive but I am capable of programmatically manipulating the data, taking the results and inserting them into a SQL database or performing any other data-related tasks. To see the code, please visit https://github.com/Passett/Automating_Without_API.

Demo of an internal app that I created using Retool and SQL Server. This app can replace an Access database that one of our bureaus relies on to complete their tasks. This tool is a sample idea for a larger project that I am working on, to replace all of our division's Access databases.

Demo of an app that I created in Python using sqlite3, tkinter, pandas, and Google Cloud Storage. This app parses all pdf forms in a given folder and returns the form questions and answers as key/value pairs. This used the latest machine learning technology from Google's DocumentAI at the time, which was in beta when I wrote the program. This app is dynamic, meaning it will work with any form without having to rewrite any code. This program can easily be further modified to automate the next steps in your process using win32com, Selenium, pyautogui and other libraries to handle your data. I am currently building a modified version for Florida Department of Financial Services to automate one of their processes. To see the code, please visit https://github.com/Passett/PDF_Parser.

An overview of my process improvements that reduced processing time by three months annually, improved reporting accuracy, eliminated a $50,000+ annual consulting contract, and earned me a 2020 Florida TaxWatch Productivity Award

This is the online version of my SEFA workshop, where I explain the SEFA process to all state colleges and universities and provide a live demo of my self-reviewing SEFA workbook template

A dashboard that I created for SEFA in order to quickly analyze data

Demo of a web scraping script I wrote in Python using regular expressions, pandas, and BeautifulSoup. To see the code, please visit https://github.com/Passett/PeopleFirst_Scraper.

I automated the review process and the reporting process for a court report that saved the local government team a month of labor annually