Summary
Skills
Programming Languages
- Go (formerly Golang)
- Python
- C++
- JavaScript
- HTML/CSS
Software/Tools
- Git/Github
- UNIX Command Line
- Docker
- Qualtrics
Database
- Oracle (PL/SQL)
- Postgres (PL/pgSQL)
- MS SQL Server (TSQL)
- MongoDB (NO-SQL)
Data Manipulation/Visualization
- Alteryx
- Tableau
- Maptlotlib/Seaborn
- Plotly
Experience
Saint Louis University, St. Louis, MO | July 2023 - Present
Systems Specialist - Student Financial Services |
October 2024 - Present
- Design & develop systems for administering federal and institutional financial aid
- Utilize data manipulation tools like Alteryx and scripting languages like Python and JavaScript to automate processes
- Write SQL reports for high-volume Oracle databases, particularly the Ellucian Banner SIS (student information system) database
- Write scripts (primarily in Python) to generate SQL INSERT and UPDATE statements that automate Banner processes
- Automate survey response collection in Python using the Qualtrics API
Federal Work Study Coordinator |
July 2023 - October 2024
- Managed FWS (Federal Work Study) program
- Redesigned FWS community service agreement process in Qualtrics
- Analyzed FWS vs. non-FWS Student Worker data to find opportunities to maximize FWS spending, resulting in an additional ~$600,000 in funds being spent
- Designed electronic surveys in Qualtrics to digitize paper forms
- Customized Qualtrics surveys using embedded JavaScript to improve survey quality & accessibility
Washington University School of Medicine, St. Louis, MO | June 2022 - July 2023
Planning Assistant - Operations & Facilities Management |
June 2022 - July 2023
- Provided project support on the BJCIH Vertical Expansion Project, the Neuroscience Research Building, and the Ambulatory Cancer Building
- Coordinated and documented executive level meetings
- Created reporting materials using the Microsoft Office Suite, Adobe Acrobat, etc.
East West Gateway Council of Governments, St. Louis, MO | Jan. 2022 - June 2022
Urban Planning Intern |
Jan. 2022 - June 2022
- Studied urban planning principles, provided support to and observed several local planning projects
Education
M.S. Information Systems
Saint Louis University |
2024-Present
- I expect to complete my master's degree in Information Systems in winter 2026
-
Relevant coursework in:
- Python
- Systems Architecture
- JavaScript/React
- Cyber Security Principles
B.A. Educational Studies
Webster University |
2018-2022
- I completed my bachelor's degree in Educational Studies after completing several semesters in the computer science program
-
Relevant coursework in:
- C++
- Programming Principles
- Operating Systems
- Networking Principles
Open Source Projects
This resume! | github.com/jdetok/resume
- I built and maintain this resume using Hugo - a static website generator built with Go
My personal website: jdeko.me | github.com/jdetok/go-api-jdeko.me
- Go
- HTML/CSS/JavaScript
- Docker
- Postgres
- MongoDB
- Apache Web Server
- Cloudflare
- Designed REST API to access NBA/WNBA statistics from a Postgres database
- Designed custom logging system that logs HTTP requests to a MongoDB database
- Frontend built using plain HTML/CSS/JavaScript
NBA/WNBA Statistics Database | github.com/jdetok/bball-etl-cli
- Go
- Docker
- Postgres
- PL/pgSQL
- Designed a fully normalized relational database to store NBA/WNBA stats
- Calls official NBA API, cleans/restructures the returned JSON, inserts into database
GoPuml | github.com/jdetok/gopuml
- Go
- PlantUML (Puml)
- Regex
- Command line tool that scans a Go codebase for specific regex patterns, maps Go syntax to Plantuml syntax, and outputs a valid Plantuml script that renders as a UML class diagram