nolan pestano 👨‍💻

@ ugafinance sep 2022 - jun 2023

April 12, 2023

sketches

Experience @ UGA

I was with the process team from September 2022 to May 2023. We accomplished many things, and I'm proud of the work we did. More than anything, I learned a lot about how to work with a team, and how to make a difference in a large organization. Technically speaking, I learned a lot about Python, namely Pandas, SQL, Spring API, and Salesforce.

Process Team

Some accomplishments we've hit:

  1. Data Archival in Events, Communications, & Related Notes through Salesforce's Storage. Reduced Cloud Usage by 25% , saving 💰 for UGA.
  2. Process Automation for Data Entry in Salesforce; instead of manual entry for large numbers of records, we can now use a CSV file to upload records, which is also built automatically ;) 📝
  3. SQL Automation (ETL) Using Python's Pandas library to turn a multi hour process of layered SELECT INTO statements into a 5 minute process. 🏎️
  4. Developed a standardized structure for all data stored both locally and in the cloud. 🖇️

Nolan Pestano, 2023. Built with 💟, Wilco's Yankee Hotel Foxtrot, GatsbyJS, and ☕. Last Updated 2024-09-09