SIUE Projects

CMIS 450 - Database Design Project

08/26/2019 - 12/3/2019

Related Learning Objectives:

Analysis/Design knowledge and skills
Development knowledge and skills
Applying IS to frame or solve a business problem
Applying an element of general education to IS in organizations
Project Teamwork

Skills Used

Skills used in this project includes database design & customization, creating entity relationship diagrams, data flow analysis, and critical thinking.

Project Focus

This project focused on taking Excel spreadsheet data provided by Ms. Deanna Harman and developing a prototype database system. This system would allow her to input data, generate reports, and organize data all while preventing data redundancy

Contribution / Role

Project Manager / Database Designer

As the team manager for this course project, I learned that project management can be very tricky and difficult to navigate if not employing specific management tactics. This was not a simple project and managing the data was cumbersome at times, so it appeared that not every team member was fully engaged and committed to producing the best possible prototype.

Technology / Skills

This project did not require much technology to be used. The project was completed using computers, Excel spreadsheets and Microsoft Access.

Description

Deanna Harman is a graduate Assistant for the College of Arts & Science and was using an Excel spreadsheet to track all information for SIUE’s annual luncheon events. These Excel sheets tracked the scholarship awards, dollar amounts, award sponsors, scholarship recipients, and everyone attending the event. Ms. Harman added to the same Excel spreadsheet each year, so the data stored in the file would continuously grow and become more complex. It was inevitable that this would result in data inconsistencies, redundancy, and extra work to maintain. My team members and I took the Excel spreadsheet provided to us and organized the data by system entities in a new Excel sheet. Then, we uploaded the new Excel sheet into Microsoft Access to create the database entities and establish the relationships with each other. This database streamlined the entire process for Ms. Harman and gave her the potential to save a lot of time and effort, all while preventing many mistakes and inconsistencies.

CMIS 270 – Systems Analysis Project

01/14/2019 – 05/09/2019

Related Learning Objectives:

Analysis/Design knowledge and skills
Technical Area of interest
Applying IS to frame or solve a business problem
Understanding a non-IS business concept or issue
Applying an element of general education to IS in organizations
Project Teamwork

Skills Used

Salesforce CPQ training & critical thinking

Project Focus

This project focused on helping ATG with the implementation of the Salesforce CPQ software. This system was implemented to give the company a formal selling process and bolster their sales.

Contribution / Role

Project Manager / System Analyst

This was my first experience managing a project of any kind and I had learned much of what it takes to be a good project manager. Important things I learned from this project includes how to facilitate discussion, proper communication with team members & stakeholders, and proper documentation.

Technology / Skills

Technology used for the successful completion of this project includes:

Personal Computer
Zoom Video Conferencing
Salesforce CPQ
Smartsheet

Description

The purpose of this project was to assist ATG with the implementation of Salesforce CPQ to give the company a formal selling process and bolster its sales. Upon completion of the project, ATG was able to use the streamlined processes of the platform to quote orders from clients, store and easy access customer data, and overall expand on opportunities and improve efficiency in the sales process.