$ cat ~/experience/ups-internship.md
role · atlanta, ga · 2025
Building & Systems Engineering Intern
UPS
Automated recurring reporting and asset-record maintenance on an enterprise asset management platform with Python, PL/SQL, shell scripts and cron.
- kind
- experience
- period
- Jun 2025 - Aug 2025
- location
- Atlanta, GA
- status
- completed
head -n 20 README
A summer in the Building and Systems Engineering group in Atlanta, automating maintenance data handling and asset-record validation on the enterprise asset management platform behind the sorting facilities.
Three pieces of work on the same platform. I fixed a character-encoding bug in a user-facing script, proving the change in a test script before touching the original. I replaced a weekly routine that people ran by hand, querying the database and uploading the generated files, with a shell script and Friday cron on the Maximo Linux server, tested locally then staged with production credentials (ready to launch by end of internship). And I extended a Maximo script to auto-assign asset failure codes from component type via a relationship table.
grep -n highlights
- 01Fixed a character-encoding failure in a user-facing script on the asset management platform.
- 02Replaced a manual weekly reporting routine with a shell script and Friday cron on the Maximo Linux server, tested locally then staged with production credentials (ready to launch by end of internship).
- 03Extended a Maximo script to auto-assign asset failure codes from component type via a relationship table.
- 04Wrote and tuned PL/SQL queries against the maintenance database.
whois ups
- industry
- Logistics & Supply Chain
- size
- 500,000+ employees
- about
- UPS is a global logistics leader, offering a broad range of solutions including the transport of packages and freight.