@ ugafinance sep 2022 - jun 2023
April 12, 2023
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:
- Data Archival in Events, Communications, & Related Notes through Salesforce's Storage. Reduced Cloud Usage by 25% , saving 💰 for UGA.
- 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 ;) 📝
- SQL Automation (ETL) Using Python's Pandas library to turn a multi hour process of layered
SELECT INTO
statements into a 5 minute process. 🏎️ - Developed a standardized structure for all data stored both locally and in the cloud. 🖇️