HeaderSIS.jpg

Difference between revisions of "IS480 Team wiki: 2012T1 Optimus/Project Overview"

From IS480
Jump to navigation Jump to search
(Removing all content from page)
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Image:592px-Optimus_logo_smaller.jpg|200px|center]]
 
  
 
{| style="background-color:#ffffff; color:#000000" width="100%" cellspacing="0" cellpadding="8" valign="top" border="0" |
 
 
| style="background: #50659B; font-size:90%; text-align:center; color:#ffffff" width="10%" | [[IS480_Team_wiki:_2012T1_Optimus|<font color="#ffffff" size="1" face="Arial"><b>Home</b></font>]]
 
 
| style="background: #50659B; font-size:90%; text-align:center; color:#ffffff" width="10%" | [[IS480_Team_wiki:_2012T1_Optimus/Optimus_Team|<font color="#ffffff" size="1" face="Arial"><b>The Team</b></font>]]
 
 
| style="background: #50659B; font-size:90%; text-align:center; color:#ffffff" width="10%" | [[IS480_Team_wiki:_2012T1_Optimus/Project_Stakeholders|<font color="#ffffff" size="1" face="Arial"><b>Project Stakeholders</b></font>]]
 
 
| style="background: #ffffff; font-size:90%; text-align:center; color:#ffffff" width="10%" | [[IS480_Team_wiki:_2012T1_Optimus/Project_Overview|<font color="#50659B" size="1" face="Arial"><b>Project Overview</b></font>]]
 
 
| style="background: #50659B; font-size:90%; text-align:center; color:#ffffff" width="10%" | [[IS480_Team_wiki:_2012T1_Optimus/Project_Management|<font color="#ffffff" size="1" face="Arial"><b>Project Management</b></font>]]
 
 
| style="background: #50659B; font-size:90%; text-align:center; color:#ffffff" width="10%" | [[IS480_Team_wiki:_2012T1_Optimus/Risk_Analysis|<font color="#ffffff" size="1" face="Arial"><b>Risk Analysis</b></font>]]
 
 
| style="background: #50659B; font-size:90%; text-align:center; color:#ffffff" width="10%" | [[IS480_Team_wiki:_2012T1_Optimus/Technical_Application|<font color="#ffffff" size="1" face="Arial"><b>Technical Application</b></font>]]
 
 
| style="background: #50659B; font-size:90%; text-align:center; color:#ffffff" width="10%" | [[IS480_Team_wiki:_2012T1_Optimus/Progress_Summary|<font color="#ffffff" size="1" face="Arial"><b>Minutes Repository</b></font>]]
 
 
| style="background: #50659B; font-size:90%; text-align:center; color:#ffffff" width="10%" | [[IS480_Team_wiki:_2012T1_Optimus/photos|<font color="#ffffff" size="1" face="Arial"><b>Photos</b></font>]]
 
|}
 
{| style="background-color:#ffffff; border-bottom: 3px solid #50659B; color:#000000" width="100%" cellspacing="0" cellpadding="4" valign="top" border="0" |
 
 
| style="font-size:90%; text-align:center; color:#000000" width="10%" |[[IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Project_Description|<font color="#50659B" size="1" face="Arial"><b>PROJECT DESCRIPTION</b></font>]]
 
 
| style="font-size:90%; text-align:center; color:#000000" width="10%" |[[IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Collaboration_Motivation|<font color="#A3A3A3" size="1" face="Arial"><b>THE COLLABORATION/PROJECT MOTIVATION</b></font>]]
 
 
| style="font-size:90%; text-align:center; color:#000000" width="10%" |[[IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Learning_Outcomes|<font color="#A3A3A3" size="1" face="Arial"><b>LEARNING OUTCOMES</b></font>]]
 
 
| style="font-size:90%; text-align:center; color:#000000" width="10%" |[[IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Client_Requirements|<font color="#A3A3A3" size="1" face="Arial"><b>PROJECT DOCUMENTATION</b></font>]]
 
 
|}
 
 
 
== '''Background / What is a Qualitative Scorecard''' ==
 
 
The Qualitative Scorecard is a tool that can be utilized by Relationship Managers (RMs) to manage and prioritize their oversight on the administrative matters of the business. It is a Tool that has been around since Q3 2009. It measures RMs’ qualitative performance (e.g. compliance, advisory excellence, etc.) on quarterly basis. There are currently '''28 measures''' in the Qualitative Scorecard and this is used in conjunction with RMs’ financial scorecard to determine RMs’ overall performance and bonus. While client asset gathering and retention are vital indicators of a RM's success, realizing a high standard of conduct is equally important for continued business sustainability.
 
 
[https://wiki.smu.edu.sg/is480/IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Client_Requirements/Paper_Prototype '''View Storyboard and Paper Prototype''']
 
 
 
[[Image:Dashboard-overview.png]]
 
 
 
In technical terms, our team will be building a Qualitative Scorecard dashboard that integrates with the bank's existing system which retrieves data from [https://wiki.smu.edu.sg/is480/IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Client_Requirements/Functional#Data_Points '''20 different data points.'''] Out of this 20 data points, automation of data collection from certain sources would be possible and for the rest, data would be retrieved by an excel upload. [https://wiki.smu.edu.sg/is480/IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Client_Requirements#Data_Flow_Diagram See Data-Flow Diagram]
 
 
[[Image:3_Layers_Circle_v2.jpg | 750px]]
 
 
There will be Four different types of users utilizing this Scorecard. [https://wiki.smu.edu.sg/is480/IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Client_Requirements#Use_Cases_and_Specifications See Use Case Diagram and Use case Specifications]
 
 
[[Image:Scorecard users.JPG]]
 
 
 
== '''Functional Requirements Checklist''' ==
 
 
[[Image:Screen-capture-9.png | 850px]]<br>
 
[https://wiki.smu.edu.sg/is480/IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Client_Requirements#Use_Cases_and_Specifications View Use Case Diagram]
 
 
Moving forward, our objective is to first develop a format for data extraction through the various systems, thereafter presenting and synthesizing our findings through the use of text comments, tables, simple graphs via [http://www.liferay.com/ Liferay]. Our first exciting challenge would be to communicate these statistics in a meaningful manner to Management and RMs.
 
 
The Scorecard dashboard will also feature workflow improvements and the automation of data collection from certain sources. The existing paper based approval approach is time-consuming very manual. Our dashboard automates the process by eliminating the need to print out stacks of scorecards for approval, reducing paper waste and paper consumption.
 
 
We intend to also develop a formal approval process within Scorecard that allows RM Line managers to acknowledge and inputs comments. The comments are kept in an audit trail and ultimately the comments are one component that determines the bonus of the RM. Should the need ever arise to view the workflow of the scorecard, users are able to see the status of the scorecard, whether it is 'Pending or Approved'. In this way, this feature makes the process more transparent.
 
 
[https://wiki.smu.edu.sg/is480/IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Client_Requirements/Functional View Functional Requirements]
 
 
[https://wiki.smu.edu.sg/is480/IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Client_Requirements/NonFunctional View Non-Functional Requirements]
 
 
== '''X-Factor''' ==
 
 
We will have a total of 240 RMs utilizing this Scorecard. 45 from Hong Kong, 72 from Singapore, 123 from the rest of the world (Zurich, London) etc. A survey will be conducted for RMs to quantify the satisfaction level of this Scorecard application.
 
 
 
Scorecard will be a front-end tool for RMs, middle and back office, that retrieves data from [https://wiki.smu.edu.sg/is480/IS480_Team_wiki:_2012T1_Optimus/Project_Overview/Client_Requirements/Functional#Data_Points 20 data points], data will be processed in preparation for the expected output, and the findings will populated onto a single dashboard. Scorecard will also include a formal workflow process that allows for approval escalation.
 
 
== '''What our team will do?''' ==
 
 
We will be developing a Qualitative Scorecard dashboard that performs data extraction from the systems, synthesize findings, automates the time-consuming manual process and provides a formal approval process as a replacement.
 
 
We will be responsible for the Initialization, Analysis, Design, Development , Test and Roll out of this Scorecard that will be integrated onto an existing system.
 
 
 
 
 
 
== '''The Collaboration and Motivation behind this initiative''' ==
 
 
The opportunity to work directly with Technology heads in the bank, Lead Developers, Business / System Analyst, RMs, Business Development Managers and everyone else at Bank Julius Baer; allows us to develop a variety of professional skills. Alongside their supportive Swiss culture and excellent mentor-ship program, we are not treated as students nor a FYP team, we are treated as employees / project management team of the Bank.
 
 
In addition, this Scorecard that we are working on definitely has impact and adds business value, one that will be utilized by top management and 240 RMs worldwide.
 
 
What we really love about our sponsor is that we are given autonomy, we are given loose directions and then sent free, being able to have the freedom to figure out the best way to approach the project and propose. In addition, we are allocated tech leads who will be present to answer questions related to the project. We are also tasked with idea generation. Being thrown a problem, we are challenged to think strategically and contribute to the solution rather than just standing there being part of the problem.
 
 
 
 
== '''Why then did we propose this project?''' ==
 
 
We identified an existing pain point in the bank. Whereby, every Relationship Manager (RM) is handed a hard copy overview of his/her key qualitative indicators; this would include the number of outstanding documents and number of Anti Money Laundering System (AMLS) comments overdue etc. RMs will be able to view at a glance whether their document deficiency list is growing tremendously and hence need looking into, or whether their increasing unfunded and inactive relationship numbers signal possible sales opportunities by re-engaging "long-lost" clients. In summary, RMs will have a tool to see if they meet the qualitative targets of the Bank, in addition to having Global MIS for the tracking of financial KPIs. We believe that this scorecard that is produced quarterly will facilitate the bank’s administrative responsibilities.
 
 
A robust Advisory framework is at the heart of every successful private bank. This scorecard would be aligned with the Advisory Framework. This Advisory Excellence process is a key value proposition for Julius Baer and aims to provide a more structured approach on servicing their clients. By building this application, the bank can leverage off this to ensure suitable and consistently high quality advice to clients, it aims to also create value for the Bank by achieving better acquisition and retention results, increased identification of additional sales opportunities and reduced legal, financial and reputation risks through enhanced RM competence and standard of conduct.
 
 
 
== '''Use Cases and Specifications''' ==
 
[[Image:RM_ScoreCard_System_v1.3.jpg]]<br><br><br><br>
 
 
==Use Case Specifications==
 
<div style="border-left border-right: #ffffff; font-family: Arial">
 
{| class="wikitable" cellpadding="15"
 
|-
 
! scope="col" width="20" style="padding: 10px 10px 10px 10px; background: #3357e7; color: #FFFFFF; | <b>Use Case</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; background: #3357e7; color: #FFFFFF; | <b>Actor</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; "background: #3357e7; color: #FFFFFF; | <b>Primary Function</b>
 
|-
 
|View Excel Files Status
 
|Admin
 
|Administrators are able to check via the Admin console  if the required excel files have been uploaded into the Scorecard system  by the respective data owners.
 
|-
 
|Upload Excel Files
 
|Admin, Data Owner
 
|Users are able to upload excel files to the Scorecard system, system will validate the uploaded files by performing a sanity check on the data within the excel file and prompt when errors are found.
 
|-
 
|Publish Scorecard
 
|Admin
 
|Administrators will be given the option to publish the Quarterly Scorecard when the key excel files has been uploaded (IT Relationships.xls) into the system by the data owners. This Publishes that particular Quarter's Scorecard data for RM's verification.
 
Administrators are also given the option to revoke Scorecard (RM will then not be able to view the release of the Scorecard for that quarter should there be any changes until Admin Publishes Scorecard)
 
|-
 
|Re-upload Scorecard with Comments
 
|Data Owner, Admin
 
|If RMs verify their Scorecard and finds that Data is wrong.<br>
 
2 situations – (i) when data is truly wrong e.g. he attended a training but it is reflected wrongly as non- attendance and (ii) System inadequacy leading to issues eg AMLS alerts overdue as RM was overseas and system does not allow for delegation)<br>
 
Users will fill up and submit a form that will be recorded in the system. If Data Owner has indeed made a mistake, he amends the data and re-uploads the excel file, A valid reason will keyed in by the Data Owner, it will be recorded and system will capture the user's UID, timestamp and reason. System will store these into an audit log.
 
|-
 
|View Scorecard
 
|Admin, RM, RM Line Manager
 
|Administrators are able to view Scorecards of everyone in the organization.<br>
 
RMs are able to view their own individual Scorecards for verification of data accuracy.<br>
 
RM Line Managers are allowed to view Scorecards of the RMs within his/her team<br>
 
|-
 
|Modify Scorecard Targets
 
|Admin
 
|Administrators are allowed to modify and set the targets for the RMs at the start of every the Year
 
|-
 
|Submit Scorecard
 
|RM Line Manager, RM
 
|RMs and RM Line Managers are supposed to submit their Scorecards with their comments to their approving Managers after verification for approval.<br>
 
RMs and RM Line managers clicks onto Submit  after agreeing to the entire SC for that quarter and has the option to add in some feedback on the comments portion (but which are not consequential to changing scoring; only for documentation purposes)<br>
 
RMs get 1 month grace period in system to submit. System will record the date and time when he submits.
 
|-
 
|Manage Comments Trail (add, view, submit, save, edit)
 
|RM Line Manager, RM
 
|RMs will submit their comments on their qualitative assessment for that quarter prior to submission of Scorecard. The are able to add, view, submit, save and edit the comments.
 
|-
 
|View Scorecard workflow status
 
|RM Line Manager, Admin
 
|RM Line Managers, RMs and Admins are able to track the status of the excel files uploaded, they will be able to see the status of their Scorecard (Open, Pending Approval, Approved)
 
|-
 
|Approve Scorecard
 
|RM Line Manager
 
|When the RM Line Managers logs into the Qualitative Scorecard system, he will be prompted for any outstanding / pending approvals through the Workbench Alert system<br>
 
RM Line Managers will be given the option to "Approve" or "Review" the Scorecard
 
*If the RM Line Manager disagrees with comments of RMs, he has option to “Review” with RM.
 
*When RM clicks “Submit”, final pop-up page will appear: “Confirmation that your submission is final and no further amendments to data is required”.
 
|}
 
 
==='''View Excel Files Status'''===
 
 
[[image:View Excel Files.jpg]]
 
 
 
==='''Upload Excel Files'''===
 
 
[[Image:Upload Excel File.jpg]]
 
 
 
==='''Publish and Revoke Scorecard'''===
 
 
[[Image:Publish-Revoke Scorecard.jpg]]
 
 
 
==='''Reupload Scorecard with Comments'''===
 
 
[[Image:Re-upload Scorecard with Comments.jpg]]
 
 
 
==='''View Scorecard'''===
 
 
[[Image:View Scorecard.jpg]]
 
 
 
==='''Modify Scorecard Targets'''===
 
 
[[Image:Modify Scorecard Targets.jpg]]
 
 
 
==='''Submit Scorecard'''===
 
 
[[Image:Submit Scorecard.jpg]]
 
 
 
==='''Manage Comments Trail'''===
 
 
[[Image:Manage Comments Trail.jpg]]
 
 
 
 
 
==='''View Scorecard Workflow Status'''===
 
 
[[Image:View Scorecard Workflow Status.jpg]]
 
 
 
==='''Approve Scorecard'''===
 
 
[[Image:Approve Scorecard.jpg]]
 
 
 
==='''Scorecard Submission Workflow'''===
 
[[Image:Workflow - normal scorecard submission workflow - v2.jpg]]
 
 
 
==='''Compensation Scorecard Submission Workflow'''===
 
[[Image:Workflow - compensation Scorecard workflow - v2.jpg]]
 
 
== '''Data Points''' ==
 
 
<div style="border-left border-right: #ffffff; font-family: Arial">
 
{| class="wikitable"
 
|-
 
| style="background: #3357e7; color: #FFFFFF;" colspan="6" |
 
<b>Data Points</b>
 
|-
 
! scope="col" width="20" style="padding: 10px 10px 10px 10px; background: #757272; color: #FFFFFF; | <b>No.</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; background: #757272; color: #FFFFFF; | <b>Data</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Current Data Source</b>
 
! scope="col" width="200" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Data Uploader</b>
 
! scope="col" width="200" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Automation Possible?</b>
 
! scope="col" width="200" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Remarks</b>
 
|-
 
||
 
1.
 
||
 
Document Deficiencies
 
||
 
Access DB
 
||
 
Operations - ACM
 
||
 
TBD
 
||
 
Source to be changed to CRM – to be analysed further, as this portion of CRM is not yet live
 
|-
 
 
||
 
2.
 
||
 
Advisory Due Dilligence
 
||
 
ADEX
 
||
 
BRM
 
||
 
Yes
 
||
 
Can be sourced from AdEx  (to be analysed further, as BRM performs data manipulation before uploading)
 
|-
 
 
||
 
3.
 
||
 
AMLS Comments
 
||
 
AMLS
 
||
 
Compliance
 
||
 
Yes
 
||
 
Can be sourced from AMLS
 
|-
 
 
||
 
4.
 
||
 
Acc Application Sent Back
 
||
 
Excel
 
||
 
Compliance
 
||
 
No
 
||
 
Manual data tracking by Compliance
 
|-
 
 
||
 
5.
 
||
 
Operational Loss / Gain
 
||
 
Excel
 
||
 
BRM
 
||
 
No
 
||
 
Manual data tracking by BRM
 
|-
 
 
||
 
6.
 
||
 
Call Report
 
||
 
iCare
 
||
 
iCare Support
 
||
 
Yes
 
||
 
Source will be changed to Call Report module of WB
 
|-
 
 
||
 
7.
 
||
 
Client Reviews
 
||
 
iCare
 
||
 
Compliance
 
||
 
TBD
 
||
 
Source to be changed to CRM – to be analysed further, as this portion of CRM is not yet live
 
|-
 
 
||
 
8.
 
||
 
Total AuM
 
||
 
GMIS
 
||
 
Finance
 
||
 
No
 
||
 
GMIS is hosted out of Zurich
 
|-
 
 
||
 
9.
 
||
 
Training Attendance
 
||
 
Excel
 
||
 
HR
 
||
 
No
 
||
 
Manual data collection from HR
 
|-
 
 
||
 
10.
 
||
 
Continuous Professional Development (CPD)
 
||
 
Excel
 
||
 
HR
 
||
 
No
 
||
 
Manual data collection from HR
 
|-
 
 
||
 
11.
 
||
 
PARC Goal Setting
 
||
 
Excel
 
||
 
HR
 
||
 
No
 
||
 
Manual data collection from HR
 
|-
 
 
||
 
12.
 
||
 
PARC Year End Review
 
||
 
Excel
 
||
 
HR
 
||
 
No
 
||
 
Manual data collection from HR
 
|-
 
 
||
 
13.
 
||
 
Inactive Accounts List
 
||
 
Olympic
 
||
 
Account Management
 
||
 
TBD
 
||
 
To be analysed further if extract file can be automated
 
|-
 
 
||
 
14.
 
||
 
Outstanding Written Confirmation
 
||
 
Access DB
 
||
 
Ops – Payments team
 
||
 
TBD
 
||
 
Source to be changed to CRM – to be analysed further, as this portion of CRM is not yet live
 
|-
 
 
||
 
15.
 
||
 
% of accounts in SG / HK
 
||
 
GMIS
 
||
 
Finance
 
||
 
No
 
||
 
GMIS is hosted out of Zurich.
 
|-
 
 
||
 
16.
 
||
 
Waivers and Refunds
 
||
 
Excel
 
||
 
Ops – CSS
 
||
 
No
 
||
 
Manual data tracking by CSS
 
|-
 
 
||
 
17.
 
||
 
Credit Exposure without prior Credit Approval
 
||
 
Excel
 
||
 
Credit
 
||
 
No
 
||
 
Manual data tracking by Credit
 
|-
 
 
||
 
18.
 
||
 
Team Hierarchy
 
||
 
Excel
 
||
 
IT
 
||
 
Yes
 
||
 
Can be sourced from IAFS
 
|-
 
 
||
 
19.
 
||
 
RM Hierarchy
 
||
 
Excel
 
||
 
IT
 
||
 
Yes
 
||
 
Can be sourced from IAFS
 
|-
 
 
||
 
20.
 
||
 
Account Mapping & Client Grouping
 
||
 
Olympic, iCare
 
||
 
IT
 
||
 
TBD
 
||
 
To be analysed further, if client grouping requirements will need to be change (in line with M4), and if Olympic extract can be automated
 
|-
 
 
|}
 
 
 
</div>
 
 
== '''Data Flow Diagram''' ==
 
[[https://docs.google.com/document/d/1HNPs1ICBsRbya1LPd8KcxyrOEk4wEcN4jIUisKcmEbY/edit Data Flow model]]
 
 
== '''ER Diagram''' ==
 
 
==='''Data Cache'''===
 
[https://docs.google.com/document/d/1HNPs1ICBsRbya1LPd8KcxyrOEk4wEcN4jIUisKcmEbY/edit view table structures here]
 
 
==='''ER Diagram v5'''===
 
[[Image:Scorecard ER Diagram v1.4.jpg |1000px]]
 
 
==='''ER Diagram v4'''===
 
[[Image:Scorecard ER Diagram v1.3.jpg |1000px]]
 
 
==='''ER Diagram v3'''===
 
[[Image:Scorecard ER Diagram v1.2.jpg |1000px]]
 
 
==='''ER Diagram v2'''===
 
[[Image:Scorecard ER Diagram v1.1.jpg | 1000px]]
 
 
==='''ER Diagram v1'''===
 
 
[[Image:Scorecard ER Diagram v1.0.jpg|1000px]]
 
 
== '''Functional Requirements''' ==
 
 
<div style="border-left border-right: #ffffff; font-family: Arial">
 
{| class="wikitable" cellpadding="15"
 
|-
 
| style="background: #3357e7; color: #FFFFFF;" colspan="3" |
 
<b>1. View Qualitative Scorecard</b>
 
|-
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; background: #757272; color: #FFFFFF; | <b>Functional Requirement</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Description</b>
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (a) View outstanding deficiencies
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
 
• User should be able to view the respective tabs such as Mandatory Documents (MAS 626), Mandatory Documents (Non MAS), Outstanding Written Confirmations, Outstanding Investment Profiles, AMLS Comments Overdue and Risk-based Clients’ Reviews Overdue<br><br>
 
• Components such as categories, previous four quarters, target, target trend and remarks should be displayed for user to see the trend<br><br>
 
• User should be able to view the account numbers when selecting values in the table<br>
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (b) View call report
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• User should be able to see the respective components such as categories, previous two quarters, target, target trend and remarks<br><br>
 
• User should be able to view the account numbers when selecting values in the table<br>
 
|-
 
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (c) View Quality
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• User should be able to see the respective components such as categories, previous two quarters, target, target trend and remarks<br><br>
 
• User should be able to view the account numbers when selecting values in the table<br><br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (d) View Advisory Framework page
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• User should be able to see the respective components such as categories , previous two quarters, target, target trend and remarks<br><br>
 
• User should be able to view the account numbers when selecting values in the table<br><br>
 
• Statistics for types of overdue alerts should reflect in this portlet<br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (e) View Human Resource page
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• User should be able to see the respective components such as categories , previous two quarters, target, target trend and remarks<br><br>
 
• User should be able to view the account numbers when selecting values in the table<br>
 
|-
 
 
<div style="border-left border-right: #ffffff; font-family: Arial">
 
{| class="wikitable" cellpadding="15"
 
|-
 
| style="background: #3357e7; color: #FFFFFF;" colspan="3" |
 
<b>2. Workflow Functions</b>
 
|-
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; background: #757272; color: #FFFFFF; | <b>Functional Requirement</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Sub-Functional Requirement</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Description</b>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (a) Approval Workflow
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 14px; width: 10.5%;" valign="top"|
 
(i) Submit Scorecard<br><br><br>
 
(ii) Email<br><br>
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 14px; width: 10.5%;" valign="top"|
 
• User will be able to submit scorecard to respective RM Line Manager upon selecting “Submit” option<br><br><br>
 
• Upon submission of scorecard, email alerts will be forwarded to the respective RM Line Manager; in the case of unavailability of the RM Line Manager, emails will be routed to the next highest level of authority<br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (b) Report Issues Workflow
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 14px; width: 10.5%;" valign="top"|
 
(i) 'No edits allowed'<br>
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 14px; width: 10.5%;" valign="top"|
 
• Regardless of the number of mistakes made for the various scorecard details, only the Administrative staff will be able to make changes<br><br>
 
• Other users will only be enabled to leave comments<br>
 
|-
 
 
 
<div style="border-left border-right: #ffffff; font-family: Arial">
 
{| class="wikitable" cellpadding="15"
 
|-
 
| style="background: #3357e7; color: #FFFFFF;" colspan="3" |
 
<b>3. Manage Comments</b>
 
|-
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; background: #757272; color: #FFFFFF; | <b>Functional Requirement</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Description</b>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (a) Create Comments
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• User will be able to create new comments on any scorecards<br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (b) View Comments
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• User will be able to view comments created by himself and other users<br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (c) Edit Comments
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• User will be able to edit his own comment<br>
 
|-
 
 
 
<div style="border-left border-right: #ffffff; font-family: Arial">
 
{| class="wikitable" cellpadding="15"
 
|-
 
| style="background: #3357e7; color: #FFFFFF;" colspan="3" |
 
<b>4. Administrative Functions</b>
 
|-
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; background: #757272; color: #FFFFFF; | <b>Functional Requirement</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Description</b>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (a) Activate scorecard for Q
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• Administrative User will be able to facilitate the activation of scorecards<br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (b) Deactivate scorecard for Q
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• Administrative User will be able to facilitate the deactivation of scorecards; upon 30 days of creation, changes to the scorecards will no longer be allowed<br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (c) View status of scorecards in workflow
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• Users will be able to view the status of their scorecards along the workflow<br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (d) View status of data points
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• <br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (e) Change qualitative target
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• Users will be allowed to edit the qualitative targets as can be seen in their scorecards<br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (f) Create scorecard extract
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• Upon successful completion of their scorecards, users will be able to create a PDF extract which they can print out<br>
 
|-
 
 
 
<div style="border-left border-right: #ffffff; font-family: Arial">
 
{| class="wikitable" cellpadding="15"
 
|-
 
| style="background: #3357e7; color: #FFFFFF;" colspan="3" |
 
<b>5. Data Upload</b>
 
|-
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; background: #757272; color: #FFFFFF; | <b>Functional Requirement</b>
 
! scope="col" width="50" style="padding: 10px 10px 10px 10px; "background: #757272; color: #FFFFFF; | <b>Description</b>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (a) Upload data (from excel file)
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• Users can upload data from excel files (or upload excel files?) for their scorecards<br>
 
|-
 
 
|-
 
| style="background: #FFFFFF; padding-bottom: 20px; padding: 5px 10px 0 18px; width: 10.5%;" valign="top" | (b) Replace data
 
| style="background: #FFFFFF; padding-bottom: 20px; padding-left: 16px; width: 14.5%;" valign="top"|
 
• In the case that users wish to make amendments to their scorecards, they will have to resubmit the excel file and overwrite the original file<br>
 
|-
 

Latest revision as of 00:48, 3 January 2013