Spreadsheet: rick_buy__32775__Green Light projects
Sheet: Green Light

No. | Project Name | Project Type | Project Description | Status | Comments | Prty | Resources |  | Expected Benefits
 |  |  |  |  |  |  | Business | IT
 | Data Validation |  |  |  |  |  | TBD
 | Validate current RiskTrac configuration |  | Portfolio clean-up (verify there are no duplicates, that all positions are being captured) Re-design hierarchy structure for easier maintenance Verify usage of other root portfolios (AGG_CREDIT, Discounting, etc) Check curve mappings | Inception |  | High | Burton / Nancy | Ramesh's team | - Ensures accurate position and VaR reporting - Eliminate entries in multiple portfolios - Promotes flexibility when moving portfolios (due to trader movements, DPR changes, etc)
 | Enhance exception reporting across systems and processes |  | - Officialization loads - VaR diagnostic report - business rules around exceptions (eg. Materiality) | Team to be identified | add timestamp / Credit columns in Active/Inactive | High | [NAME] | Ramesh's team | - Ensures completeness - Ensures accuracy - Reduce time/effort in resolving daily issues
 | Prevent book/portfolio duplications |  | Develop checks to prevent duplicate books and portfolio criteria | Current approach being enhanced |  | High | [NAME] | Ramesh's team | - Prevents duplicate capture of positions
 | Enhance RiskTrac reporting capabilities |  | [NAME] reporting and DPR loads VaR reporting and DPR loads | Team to be identified |  | High | [NAME] | Ramesh's team / Won? | - Eliminate need to reconcile benchmark file with RMS - Faster benchmark processing - Simplifies benchmark reporting, encouraging risk groups/users to run benchmark reports themselves (vs. GRO)
 | Book archiving / aging |  | Process to archive books and prevent use in all upstream systems Book aging functionality | Inception | May be able to use GCP inactivation to drive archiving process | High | [NAME] | Ramesh's team | - Clean-up books/portfolios (leads to better system performance) - Prevents use of Archived books
 | Online book creation |  | Online form with input validation;  Automatic back-end table updates; Audit trail database | Inception | Online form created; no database yet Back-end update currently not in scope | High | [NAME] | Ramesh's team / Won? | - Make GRO user process more efficient - Provides audit trail - Encourages book admins to submit complete and accurate book requests
 | Tool for assigning a book to a portfolio/s |  | To eliminate tedious process in VB app, specially if book needs to be entered in multiple portfolios | Requirement identified |  | Med | [NAME] | Ramesh's team | Make GRO user process more efficient
 | Moving sub-portfolios |  | Highlighting a group of portfolios and copying to another portfolio; currently, user can only move portfolios one at a time | Requirement identified |  | Low | [NAME] | Ramesh's team | Make GRO user process more efficient
 | Renaming books (with no trading history yet) |  | Currently, the process is to create a new book with the correct name (since we also cannot delete books, old book ends up being unused) | Requirement identified |  | Low | [NAME] | Ramesh's team | Make GRO user process more efficient
 | Document current RiskTrac set-up procedures and develop checklists |  |  | Creating draft | No IT role here | Low | [NAME] | None | - Minimize user errors when setting up books - Facilitate knowledge transfer within GRO
 | Re-design application that calculates monthly reserves |  | The application uses book [NAME] from Discounting UK and [NAME] portfolios. The re-design of the application will make use of one of the production portfolios (maybe AGG-PROD_BU?) | Requirement identified |  | Low | [NAME] / Anita | Ramesh's team / Won? | - Eliminates the need to maintain [NAME] and [NAME]
 | Business Process |  |  |  |  |  | [NAME] (PM)
 | Re-define RiskTrac user roles and responsibilities |  | Identify user groups and define different levels of access to data groups and functionalities | Inception | User group definitions submitted to IT; start with UK risk group | High | James / Fergus | Ramesh's team | - Decentralizes some RiskTrac functions, reducing GRO workload and promoting risk groups to take more responsibility for risk processes
 | Re-define risk controls processes and segregation of responsibilities |  |  |  |  |  | [NAME]
 | Source Feeds Processing |  |  |  |  |  | Greg Couch (PM)
 | Faster ERMS position capture process in RiskTrac |  |  | Inception phase | ERMS and RiskTrac IT groups setting up a project; [NAME] will provide status of meetings | High | Greg | RiskTrac IT, ERMS IT | Faster RiskTrac loads
 | Document current state of position capture |  | Some groups' positions are not being captured in RiskTrac Some groups' have separate loads to RiskTrac and CAS (eg. Canada) | Requirement identified | Need to determine % of positions not captured through RiskTrac Need to determine % of positions on RiskTrac but failed to load | High | Greg | TBD
 | Address inconsistent un- and re-officialization processes across RiskTrac, CAS, Infinity |  | Need to document differences in RiskTrac, CAS, Infinity, and make sure that we're not missing, duplicating positions | Team to be identified |  | High | ?? | ?? | Ensures capture of same positions in RiskTrac, CAS, Infinity
 | Address inconsistent processes when system finds no post-id (eg. Infinity takes previous day's data, RiskTrac does not) |  | Need to document differences in RiskTrac, CAS, Infinity; if differences cannot be addressed, then we need to develop a way to tack the differences | Team to be identified |  | Med | ?? | ?? | Ensures capture of same positions in RiskTrac, CAS, Infinity
 | Document any hardware-related issues impacting system performance (as well as any plans to address these) |  |  | Team to be identified |  | Med | ?? | ?? | Identify opportunities for improving system performance
 | Running parallel RiskTrac load processes (from ERMS) |  |  | Running in production | Significant improvement in RiskTrac load times; need to monitor impact on ERMS processing times | Med | None | Ramesh's team | Faster RiskTrac loads
 | ERMS function to prevent officialization of empty books (similar to EnPower) |  | There are a large number of empty books that are being calc'd and officialized through Meta-calc stream | Requirement identified | Per Ramesh, impact will be low on RiskTrac load times (more of a clean-up project) | Low | [NAME] | ERMS IT | - Improved peformance in RiskTrac loads (minimal impact, per Ramesh) - Eliminates unnecessary ERMS processing