Budgeting Website Development

A local organization facilitates the translation of scientific discoveries in the lab into clinical trials and new patient treatments in Indiana and beyond.

The organization has numerous spreadsheets to assist in their budgeting and application of benefits for those involved in the trials, including the doctors, staff, etc.  Previous work done by the Living Lab has created a database (in Oracle) which contains tables and stored procedures, along with a basic website for viewing, editing, and creating data.  The focus of the continued development will be to continue working on the creation and editing of the data via a website, and making it so data can be imported (such as a Fringe Benefit schedule) at any time.

The website application has been updated so that quick entry of data can be entered without the user needing to click update constantly (using AJAX).  Also, the users can now import a file with the correct columns and update certain areas very quickly using an export from other various systems.  Along with these updates, some database structure changes were made to better fit the .NET Entity Framework and additional fields were added for auditing purposes.  Along with these fields, an auditing factory was integrated so that any inserts, updates, or deletions would be tracked.  The user interface was updated so the user does not have to “page” through data one web page at a time, and not get a list of hundreds of records at a time, a search function was integrated, along with other various improvements.  Finally, the application now uses IU CAS authentication to provide security of the website.  Overall, this was a fun, and at times frustrating, project to work on, and I feel confident leaving the project in the hands of the next programmer.  Utilizing the resources I have already worked into the main parts, and expanding on those to the other areas that are in need, along with the documentation I am providing, they should be able to get started quickly and efficiently move through the rest of the requirements for the client.

Project Student: Chad Beckner

Spiceworks-helpdesk ticketing system

Spiceworks Network Monitor keeps an eye on the networks performance in real-time from your desk.  We’re focusing on the help desk ticketing system portion of spiceworks. The local non-for-profit companies that are being monitored by the helpdesk need to have their tickets routed to the responsible coordinator of the company, to be viewed separately. We’re also researching how to set up each company as a remote site, which could possibly be another way to keep them separate.

We decided to create two virtual servers for the local non-profit companies. Windows Server 2008 and spiceworks was installed. After all the issues encountered with logging into spiceworks through the browser, we discovered that a new rule needed to be created for the firewall to allow such access.  The non-profit companies can now access spiceworks by entering the web address in the browser.  A user portal was also created for helpdesk ticket submission, but registration needs to be completed before logging in.

Project Student: Yolanda Winbush

Scientific Institute

A scientific research organization, in collaboration with various universities and other partnerships, wants to aid in translating research and scientific discoveries into practice and clinical trials. This project was previously created in spring by another student. Their mission is to increase translational biomedical research and to improve the health of people, and also gather information from the client, understand their needs and wants, organize their data, and design a database that integrates the data from all entry points and for all uses. We had to design and implement their database so the be able to access their data as the wanted.

Member: Amadou Traore

SNORT – Intrusion Detection System

The SNORT project is a continuation of building up a network security monitoring server to monitor the networks of classrooms located in a basement. There will be 2 phases that need to be accomplished.  The software that would be using to monitor the network would be “SNORT” , an Intrusion Detection Software.

Phase 1: Snort will need to catch the flow of the in and out traffic on one of the VLANs. Snort has already been built, but may need updates to continue on to the next phase. Security Onion was used initially for the Linux system, but new equipment should allow for SNORT to run on a direct Linux system. Possible start over for the build.

Phase 2: Snort will need to connect to an additional VLAN. Additionally have to make sure there is minimum – 0 redundancy and a way to have separate log files for the VLANs. No further information on this phase until checks on the first phase are complete.

Paused work on the snort project. Will need further research before continuing.

Project Team Members: Raffielle Miller, Shawnie Springfield

Mobile Banking Application Security

During the semester project in CIT 420, it was noted that banking apps for iPhone store some sensitive data in plain text.  This semester in Living Lab a similar process is going to be used to see what similar banking applications store on an Android Phone.  The apps will be downloaded from the Google Play store, used for a couple of weeks, then the device will be scanned and scoured through.  The iPhone apps will also be looked at in much greater depth.

Project Student: Chris Nakfoor

Cyber Security Open

The Cyber Security Open Project will serve the purpose of educating undergraduate college students in how to use Information Security tools such as Kali Linux, Nmap, and Wireshark. The project consists of six missions, each requiring the use of specific hardware and software tools. Our job is to review and edit the current documentation, and add more instructions to help the students understand the missions clearly. Also, we are going to test the missions to make sure that all the software is up to date and the hardware tools are functioning properly.

We were able to accomplish the missions and recreate documentations for each mission. Each mission now has a setup and step-by-step guides. We also added screenshots to each guide to make the missions easier to accomplish by other students.

Student Team Members:  Abdulaziz Alzaben, Toby Robinson


Form and Report creation using WordPress

A local not-for-profit company providing rescue for canines is needing to modify their web application submission process for adopting, volunteering, and fostering. Previously, the client had been using PDF forms that required several steps to complete and submit the forms. It has been identified that the use of online forms will help shorten the process and will allow the client to track the application process through the use of reports.

Currently, the online forms have been created using a third party plugin for WordPress called Formidable Pro. This plugin allows simple form creation and reports. With the use of the reports, the client can obtain two different views. The first view is an overview of the particular form that was submitted which includes several columns. Within this view, there is the capability to search the forms based on certain parameters. The second view is a detailed view of the form the user submitted. The client will then be able to change the status of the form to either new, pending, approved, declined, or inactive and add additional notes. Additionally, an email notification will be sent to the client when a form is submitted.

Project Student: Jonathan Hendrix

Error and Event Log Tracking and Analytics

A prominent business in the Indianapolis area has asked the Living Lab to assist them in creating dashboards in order to view information about their error and event logs in real time. This data will be used to perform analysis on the data and determine ways to optimize their up-time. Using Splunk, a data mining tool designed to analyze and store machine data, the Living Lab will create dashboards, which provide a real-time view of the necessary information, to track and monitor the logs and potential hazardous events. If this project is successful, the company will then install Splunk on a company server, and implement the changes in order to increase productivity for their Business Intelligence Team.

The project has been a success. The dashboards created have shown the client the need to activate additional auditing tables in their database so that they can start to obtain even more information. The use of Splunk as a reporting tool and for viewing semi-real time performance is now being discussed as an organization-wide tool for systems monitoring and is in further development for three additional systems.

Project Student: Thomas Scheel

IT Specialist consulting for non-profit organizations

This project was created to assist two non-profit organizations with any technical support needs that they should have. Both received assistance with their IT needs, and had wireless connectivity issues troubleshot. One organization additionally had donated and purchased equipment installed and set up, while the other was assisted in choosing a new ISP.

Project Team Members:  Evan Cloe, Ahmed Alhassoun, John Stipe