Education

College of the Ozarks / Undergraduate
2015 - Present

I am currently pursuing a double major in Computer Science and Mathematics with a GPA of 3.3 at the College of the Ozarks. College of the Ozarks is a work college, where students work 15 hours a week to pay for tuition. More information on the work program can be found at the college's website.

Work Experience

Helpdesk Technician / College of the Ozarks Computer Center
January 2017 - Present

I am currently employed at the College of the Ozarks Computer Center, the IT helpdesk for the college. Typical jobs include: troubleshooting PC’s, printers, and other associated devices; diagnosing issues over the phone; explaining technical concepts to faculty and staff; discussing issues via live chat and phone calls with manufacturers; and updating and troubleshooting a plethora of software from various vendors.


Web Developer / College of the Ozarks Computer Center
June 2017 - August 2017

For six weeks during the summer of 2017, I worked as a developer on the College of the Ozarks Computer Center's internal helpdesk website. This job involved working with API’s from various vendors, designing new web pages in the Web Forms paradigm with ASP.NET, retrieving and formatting data with Microsoft SQL Server Management Studio, and using SourceTree for source control.


Student Manager / Bobcat Food Services
August 2016 - December 2016

For a single semester, I worked as a student manager at Bobcat Food Services, the department of the College of the Ozarks responsible for feeding the students, faculty, and staff. As a student manager, I was expected to manage between six and twenty student workers, occasionally assisted by another student manager. Two full-time managers and small full-time kitchen staff provided supervision. I acted as an intermediary between upper management and the student workers, assured timely and safe preparation of food, and directed the student workers in maintaining a clean and professional dining environment. Occasionally, I was expected to assist or direct catered meals, including an annual alumni dinner. Expectations included conflict management, employee relations, and professional interaction with students, faculty, staff, and members of the public.


Projects

Student Helpdesk / Full-stack IT helpdesk web application
July 2017 - Ongoing

Due to liability issues, the Computer Center is not allowed to assist students or faculty with issues on personal devices. Two of my co-workers (who are also students at College of the Ozarks and emplyees at the Computer Center) and I decided to make our own helpdesk service unaffiliated with the college to capitalize on this market and extend our ability to help. I worked with a partner to design the database in MySQL Workbench and then deployed it on Google Cloud SQL. I personally wrote all of the 25 stored procedures for accessing data. We chose to employ the MVC design paradigm. I wrote part of the model and it's accompanying DAO. To boost security, we used the Google Sign-In API. Regular user functionality includes creating an account, creating a work order, viewing work orders a user has created, adding notes to work orders, and rating the experience. Technician functionality includes viewing all work orders, organizing work orders by operating system, joining a work order, and adding notes to work orders.

AwareNet / Full-stack Android application and web-crawler
October 13, 2017 - October 15, 2017

In the fall of 2017, my college's Association of Computing Machinery chapter participated in Major League Hacking's TigerHacks hackathon. I worked with a team of five classmates and we had 36 hours to complete our project. Our idea was to use a webcrawler to check FEMA's website for inclement weather and allow users to watch certain counties. Users would receive push notifications to their phones when a county they are watching experiences severe weather. I focused on writing the web crawler useing the Scrapy Python library, and this was my first experience really using Python in a project. The web crawler checked periodically for new severe weather on FEMA's website and formatted the report in a JSON file. I also focused on configuring the server we used, which was hosted on Amazon Web Services, using PuTTY. Our project received the Rookie of the Year award, as none of our team members had ever previously participated in a hackathon. While the project was not completed to production level, the team has plans to continue development in the future.

Best Books / Full-stack bookstore application
Spring 2017

For my Database Systems class at College of the Ozarks, taken in Spring of 2017, the final project consisted of an online bookstore. The professor allowed much freedom of design in pursuit of his requirements. My partner, Joshua Dowd, and I opted to employ a CLI for simplicity of design, testing, and deployment (using the Apache Commons CLI API for parsing the user input) and used MySQL as the backend. We used MVC design to streamline separation of functionality as well as enforce user permissions. Customers could create accounts, log in and out, search and view books, add books to their carts, and place orders. Admin capabilities, which I primarily focused on, included: CRUD functionality on a variety of information (user addresses, publisher contact information, prices, book information, and more); updating orders between processing, shipping, delivered, cancelled, and returned; managing user permissions; and generating reports in CSV format. The database included 11 tables in BCNF. My partner and I designed and deployed the database, populated it with data, wrote 107 stored procedures, wrote the objects for processing the data and accompanying DAO classes for storing it in the database, wrote admin and customer controllers for parsing user input and passing commands to the DAO, wrote a master controller to direct user input to the appropriate specialized controller, wrote a class for elegantly displaying information in the console, and wrote a class for translating information in the database into CSV format for report generation. Notable functionality includes: hashing of user passwords using the bcrypt algorithm; encrypting user credit cards with AES-256 (due to time constraints, with the professor’s permission, the key to each number was a hash of the CVV number, required for checkout); soft delete of user accounts allowing retrieval of information for data-mining or account reopening; and searching algorithms optimized to execute as few calls on the database as possible. The full source code of the project is available on my GitHub account.