HeaderSIS.jpg

Difference between revisions of "IS480 Team wiki: 2014T1 Chocolicious"

From IS480
Jump to navigation Jump to search
Line 134: Line 134:
 
===Analytic Dashboard===
 
===Analytic Dashboard===
 
Our system will offer analytic for technical and non-technical purposes. This feature will be able to give insights and help make decisions for maintenance and user operations.<br/>
 
Our system will offer analytic for technical and non-technical purposes. This feature will be able to give insights and help make decisions for maintenance and user operations.<br/>
<b>1. Technical Analytic</b><br/><br/>
+
====Technical Analytic====
 
<b>Pages load time</b>
 
<b>Pages load time</b>
 
<ul>
 
<ul>
Line 147: Line 147:
 
</ul>
 
</ul>
 
Updating and maintenance then could be done to serve users'needs more accurately. <br/><br/>
 
Updating and maintenance then could be done to serve users'needs more accurately. <br/><br/>
<b>2. Non-Technical Analytic</b><br/>
+
====Non-Technical Analytic====
 
Non-technical analytic will be designed to fit the different users, such as Budget Analytic for Finance Secretaries and Sensitivity Analysis for the SMUSA Finance Secretary.<br/><br/>
 
Non-technical analytic will be designed to fit the different users, such as Budget Analytic for Finance Secretaries and Sensitivity Analysis for the SMUSA Finance Secretary.<br/><br/>
 
<b>Budget Analytic</b><br/>
 
<b>Budget Analytic</b><br/>

Revision as of 12:56, 3 August 2014

Chocoliciousmenu.jpg
Overview Project Management Documentation
1. Project Progress 1. Our Team 1. Documents
2. Project Description 2.Time Line 2. Database
3. X-Factor 3. Schedule 3. Use Cases
4. Stakeholders 4. Risks & Constraints 4. System Diagram
5. Learning Outcomes 5. Metrics

Project Progress

Iteration 5 Start End
Planned
1-Aug
14-Aug
Actual
1-Aug
Milestone
Acceptance Presentation (Thu, 14 Aug 2014)
Start Time: 11:00 AM
End Time: 12:00 PM
Venue: SIS SR2.1


Resrce.jpg
Ruby | Bootstrap 3 | JQuery 2 | Rails | Asana | Team Viewer | Google Drive | Dropbox | Bootply | Draw.io | Aptana 3 | D3.js | Handsontable | Bootstrap Validator | AWS SDK for Ruby | Twitter Bootstrap Gem

Resources Details
Project Management Asana
Design Tool Draw.io
Collaborative Tools Team Viewer, Google Drive, Dropbox
Prototyping Bootply
Server Amazon Web Service (AWS)
Server Environment Linux OS running Ruby on Rails
Database MySQL 5.6.17
Programming Language Ruby
Development Framework Ruby on Rails
Development Methodology MVC (Model, View, Controller)
Web Interface Framework Bootstrap 3
Javascript Framework jQuery 2
IDE Aptana 3
Graphing API D3.js
Form Validation Bootstrap Validator
Web Excel Sheet Handsontable
Libraries/Packages AWS SDK for Ruby
Twitter Bootstrap Gem

Project Description

This service portal will serve the accounting purposes of the many student clubs and societies, such as managing their club funds accounts, propose budgets or submit and track claims.

Each year, there are 2 budgeting cycles and currently, club funds are allocated arbitrarily and there is often poor utilization of budgeted funds. This is caused by the fact that there is no unified approach to bookkeeping and the large number of student clubs makes tracking difficult. The current claims process is convoluted and students have found that the process is too long; causing much unhappiness as students often have to fork out their own money which may amount to thousands. There is also no direct way to track the progress of the claim request.

The new system will bring all clubs’ accounts together and include tools such as report generation as well as an analytics dashboard.

In doing so, SMUSA will be able to more efficiently allocate budgets to the clubs and students will know the status of their claims. The unified approach to bookkeeping will also simplify audit efforts and eliminate current problems like irreconcilable account balances.

We also aim to eliminate the underutilization of budgeted funds. This system will affect all SMU students who are involved in school clubs, especially students with leadership positions.

X-Factor

XFactorChoco.jpg

Integration with SAP

Generated SAP report from Office of Finance (OFIN) will be able to be uploaded to system.
This report will enable:

  • Auto claims approval
  • Auto deposit of funds approval

Analytic Dashboard

Our system will offer analytic for technical and non-technical purposes. This feature will be able to give insights and help make decisions for maintenance and user operations.

Technical Analytic

Pages load time

  • Slowest page load time
  • Page visit frequency


This could help with maintenance as it could, just to name a few possibilities,

  • identify code inefficiencies,
  • determine the degree of need for certain functions,
  • help diagnose the content management.

Updating and maintenance then could be done to serve users'needs more accurately.

Non-Technical Analytic

Non-technical analytic will be designed to fit the different users, such as Budget Analytic for Finance Secretaries and Sensitivity Analysis for the SMUSA Finance Secretary.

Budget Analytic
Breakdown of budget and expense estimations show any inaccurate estimations and help pinpoint mistakes.

Business Analytic
Using regression and the comprehensive data in the Accounting Information System (AIS), the Business Analytic will be able to help forecast club income and revenues, helping in the management of accounts and funds management.

Sensitivity Analytic
A technique used to determine how different values of an independent variable will impact a particular dependent variable under a given set of assumptions. This technique is used within specific boundaries that will depend on one or more input variables, such as the effect that changes in interest rates will have on a bond's price.

Sensitivity analysis is a way to predict the outcome of a decision if a situation turns out to be different compared to the key prediction.

Fund transfer from clubs can affect the clubs' account and the overall account in varying proportions. The sensitivity analytic will be able to identify all the changes with the sliding of the percentage to be moved from each account. This feature will be able to help increase efficiency in funds allocation and decision making.

eReceipts & ePayment

Besides our core functions abilities, our system will be able to generate e-receipts.

Currently, clubs have the ability to sell tickets/t-shirts for income. At the moment, every time they receive cash from students, they need to write a receipt to the student. The process uses much paper work and is very time consuming. Using the AIS, we want to introduce e-Receipts to reduce wastage and save time, creating a paperless system. e-Payment integration allows for cashless transactions, working hand-in-hand with the e-Receipt feature.

Vendor Recommendation

This feature keeps a record of trusted vendors used in the past and allows students to enter new vendors into the system when making vendor claims. By allowing students to input more information about the vendor (yet to confirm fields, possibilities include cost, quality etc), the feature will then process the vendors collected using an algorithm to rate and rank the vendors. This will allow the feature to be a potential aid when searching for vendors and sponsors in the future.

Stakeholders

Supervisor Prof Youngsoo KIM
Sponsor Mr WONG Yew Tong, Associate Director (Student Leadership) of the Office of Student Life (OSL), SMU
Client OSL
End Users All finance secretaries in SMU

Learning Outcomes

LearningOutcomesChocolicious.jpg


Koh Ying Ying Trecia Ng Zhen Jie Phang Ming Min Terence Chu Tailun Lee Jinq-Yi Mohamed Safiullah
Usually having high expectations on myself, as the quality analyst, I would like to apply these expectations on this project and help in building a robust application. Using my artistic talent and skill in IT, I would like to design an application so beautiful that it is jaw-dropping. As the Project Manager, I wish to hone my managerial skills with this project being my first stepping stone. As the Systems Analyst, I aim to better my understanding in system architecture in hopes of creating an application that is useful, user-friendly, fast and robust all at the same time. I like to constantly challenge myself and push my boundaries. Given that we are using new technologies for this project, I hope to master these tools and come up with the best project in the shortest time possible.​ As the lead developer, I aim to bring my team to greater heights. One of the obstacles in our way is our lack of prior experience in this language. However, I have the confidence to guide my team to overcome these and any other obstacles that stand in our way. Using my previous experiences in developing applications, I hope to apply my widely gained knowledge and while at the same time learn how to design the web application with flat design philosophy.