Salutations, my name is Jeffrey Riley-Loy!
I am a front-end web developer with six years of experience writing web pages using JavaScript. I hold a Bachelor of Science degree in Business Technology & Analytics from Portland State University. During my senior academic career, I primarily collaborated remotely with team members across the country and expanded my data analysis skillset.
At the moment I'm currently experimented with AI-assisted programming and software development to develop Node.js web apps and also experimenting with ControlNet models for Stable Diffusion image generation.
Technical Skills
JavaScript
Proficient in building interactive web applications, primarily specializing in front-end development with plain Javascript and proficient with Node.js.
SQL
Certified by Oracle in Database Design, experience working with relational databases such as MySQL including designing database schemas and writing complex queries.
Python
Experience building backend applications and data processing pipelines using Python, including using popular libraries such as Pandas and NumPy.
Work Experience
Database Consultant - Nutri-Shield Preservatives
March 2021 - June 2021
Designed and implemented inventory and blending database using the Smartsheet platform, including designing the UI. Created automated systems to transition old Excel records to the new cloud-based database.
Database Consultant - Norpac Foods Inc. (Stayton Branch)
June 2021 - October 2021
Updated and cleaned SQL database code and management software, improve and automate data entry methods to increase efficiency, stayed as an on-call consultant in case of emergencies until factory closure due to COVID-19. Some situations I was responsible for handling was a major security breach and two accidental database deletions.
Freelance Web Developer
April 2019 - Present
Built custom HTML websites for clients on commission. Primary responsibilities included managing schedules, the creation and styling of front end webpages, and informing clients of the advantages of various hosting methods.
Projects
AI-Integrated Web Development
My most recent project has been applying OpenAI to web development primarily through node.js backend work. You can view a practical demo at https://jeffreyriley.neocities.org/WeatherChatGPT/.
Systems Analysis
Utilizing Access and custom SQL code, I created a nursing home database with a full graphical user interface and search function. Created for demonstration purposes, you can find a copy of the access file using this link.
Unity Development
I worked on several smaller Unity projects and technical demonstrations in early 2018. The project relied heavily on C# code to create desktop and mobile applications.