Summary
Skills
Programming Languages
- TypeScript/JavaScript
- Go
- HTML/CSS
- Python
- C/C++
Software/Tools
- Git/Github
- UNIX Command Line
- Docker
- UML/PlantUML
Database
- Oracle (PL/SQL)
- Postgres (PL/pgSQL)
- MS SQL Server (TSQL)
- MongoDB (NO-SQL)
Other Notable Skills
- ArcGIS Maps SDK for JavaScript
- PostGIS
- Tableau/PowerBI
- Alteryx
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 M.S. in Information Systems in Decemeber 2026, after completing my Masters Research Project.
-
Relevant coursework in:
- Systems Architecture
- TypeScript/JavaScript
- Python
- Database Design/Admin
- Cyber Security Principles
B.A. Educational Studies
Webster University |
2018-2022
- After completing several fundamental courses as a Computer Science major, I completed my undergraduate education with a degree in Educational Studies.
-
Relevant coursework in:
- C++
- Programming Principles
- Operating Systems
- Networking Principles
Open Source Projects
jdeko.me: Personal Website | github.com/jdetok/go-api-jdeko.me
- Go
- TypeScript/JavaScript
- HTML/CSS
- Docker
- Postgres
- MongoDB
- Nginx
- 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(transpiled from TypeScript)
STL Transit Map: Masters Research Project | github.com/jdetok/stl-transit
- TypeScript/JavaScript
- ESRI ArcGIS Maps SDK for JavaScript
- PostGIS
- Go
- HTML/CSS
- Docker
- Postgres
- Designed an open source and locally-hosted PostGIS/Go backend for serving GIS data to a TypeScript frontend using the ArcGIS Maps SDK
- Built an accessible and intuitive frontend utilizing ArcGIS web components and ESRI Calcite Design System components
This Resume!: Custom resume built with Hugo | github.com/jdetok/resume
- I built and maintain this resume using Hugo - a static website generator built with Go
NBA/WNBA Statistics Database: Supports Personal Website | github.com/jdetok/bball-etl-cli
- Go
- Docker
- Postgres
- Designed a fully normalized relational database to store NBA/WNBA stats