Pricing Quality Dashboard Project 1696408149

Project Background
Project Background
ABC Bank is upgrading its "Fund Accountant Work Bench" to enhance the operational efficiency
of its Accounting Associates. The updated system will support real-time processing, a departure
from the previous batch processing method. The "Portfolio Accounting Dashboard" will now
allow Fund Accountants to utilize UI screens to review and, if necessary, adjust the prices of
securities. Furthermore, the "Portfolio Holding" screen will empower Fund Accountants to
record transactions that update holdings in real-time. Any changes made to prices or holdings
will be instantaneously reflected in the "Portfolio Valuation" tab within the "Portfolio
Accounting Dashboard."
Asset Valuation
The total asset value of a fund represents the aggregate monetary worth of various assets
contained within the fund's investment portfolio. The value of an equity portfolio corresponds
to the market value of equities it comprises. The market value of an equity security is
determined by multiplying the security's price with the total number of corresponding shares in
the portfolio.
To ascertain the market value of the portfolio, a pricing analyst (in larger organizations) or the
fund accountant (in smaller firms) customarily examines the prices of securities to validate their
accuracy for Net Asset Value (NAV) computation.
As-Is Process
Presently, the procedure is manual. Security prices procured from vendors like Bloomberg and
Refinitiv are archived in a pricing data warehouse. Excel macros are employed to juxtapose the
latest prices with those from the preceding business day. Following this, analysts cross-check
prices on the Bloomberg terminal and input any required changes. This method is not only
sluggish and inefficient but also susceptible to errors.
To-Be Process
Security prices sourced from vendors such as Bloomberg and Refinitiv will be stored in the
pricing data warehouse. The new "Pricing Quality Dashboard" will display ‘EOD security prices’,
for securities listed in the "Securities of Interest" file and the prices used for valuation prior
business day. This system will then contrast the day's security prices with those from the prior
day, pinpointing securities with potentially erroneous prices and flagging them as per
established business rules. The pricing quality analyst will then verify these prices on the
Bloomberg terminal and make necessary adjustments if required. All updates made by the
analyst are meticulously logged and a supervisor approves these updated prices before they're
utilized in NAV computation.
User Stories – Pricing Quality Dashboard
User Story ID 1.1

As a Pricing Data Analyst, I want to view and compare security prices for the day with prior business
day security prices, and identify securities for which price changed by 5% or more, so that I can fix
any data issues.
BA’s Explanation to Agile team
• The system shall display the security prices from the API link:
https://api-intern.mondayskill.com/CM101/get
• The system shall display the following fields:
o Security Id
o Security Name
o Current Business Day price
o Previous Business Day price
o % Change in security price - (current Market Price – Prior day closing price) / Prior day closing
price
• The system shall compare the security prices for the day with security prices for the previous day. If the
price of any security changed (increased or decreased) by more than 5% (daily price change tolerance
limit), then it will mark the security price in red font for easily identification.
• The system shall allow Pricing Data Analysts to review and update the price. If the price for any security is
updated, the system will clearly identify that security.
Acceptance Criteria - Given that I want to view the security prices from the pricing file, when I click on the ‘Price
Review' tab on ‘My Pricing Quality Dashboard ‘
o I should see the security prices for the ‘Current business day ‘, ‘Prior business day’ and ‘% change’ in price
for the day compared to the previous business day, and
o wherever the change is more than 5%, it is marked in red font.
In the real-world BAs will write the user story in the on Jira as below . If you know about the
3C concept in Agile, then
1st C = Card ( user story)

2nd C = Conversation (Discussion in the team , BA explaining to the team the requirement and
team suggesting the process to define the final acceptance criteria ( This process of negotiation
is the ‘N’ in INVEST criteria)
3rd C = Conformation = Acceptance criteria defined by the BA in discussion with the team.
User Story ID 1.2
As a Pricing Data Analyst, I want to update the security price if the price in the file does not
reflect the correct market price, so that portfolio value calculations are accurate.

• The Pricing Data Analyst shall be able to review the price of any security. As a policy, the Pricing Data
Analyst must review the price for any security that breaches the 5% security price change tolerance.
• The system shall allow the Pricing Data Analyst to update the security prices if required.
• If the Pricing Data Analyst makes any update to the security price, the system should record the user id of
the Pricing Data Analyst and timestamp for the update.
• The system shall allow the Pricing Data Analyst to add comments if the security price is updated.
• The system shall clearly identify the security for which the prices have been updated.
• If the security price is updated, the system shall recalculate the % change in security price.
• If the security price has been updated, the system shall allow the ‘reviewer’ to view the original price,
change made, and the comments of the Pricing Data Analyst.
• The system shall allow the Pricing Data Analyst to review the security price and mark the security prices as
reviewed, without making any changes to the security price.
• If the security price has been updated or marked as reviewed, the font color for the security shall be
changed to blue, indicating the security price was updated or reviewed.
Acceptance Criteria
Given that I want to review and update the security price (if required), when I click on ‘Price
Review’ tab on ‘My Pricing Quality Dashboard ‘ and click ‘Review’ for any security, then:
o I should see the ‘securities price review screen’ to review and update the security price,
o and save the updated price,
o and enter reason for change as a comment,
o and the system should display a price update confirmation message,
o and should capture the user id of the associate editing the price,
o and should record the time stamp for the update,
o and on the ‘Price Review’ tab, the new price is reflected,
o and %change field for the security is recalculated,
o and the red font for the row is changed to blue font.
User Story ID 1.3

As a Pricing Data Analyst, I want to review the security price and mark it as ‘Reviewed’, without
changing the security price
• The Pricing Data Analyst can review the price of any security. The Pricing Data Analyst must review the
price for any security that breaches the 5% security price change tolerance.
• The system shall allow the Pricing Data Analyst to review the security price and mark the security prices as
reviewed, without making any changes to the security price.
• If the security price has been marked as reviewed, the font color for the security shall be changed from
red to blue, indicating the security price was updated or reviewed.
Acceptance Criteria
Given that I want to review the security price, when I click on ‘Price Review’ tab on ‘My Pricing
Quality Dashboard ‘ and click ‘Review’ for any security then:
o I should see the ‘securities price review screen’,
o and if I reviewed the price and marked it as ‘Reviewed’ and saved, then the system
should display the confirmation message ‘Marked as reviewed’
o and should capture the user id of the associate reviewing the price,
o and should record the time stamp for the update,
o and on the ‘Price Review’ tab, the red font for the reviewed security is changed to blue
font.
User Story ID 1.4
As a Pricing Data Quality Manager, I want to view any changes made to the security prices by the Pricing
Data Analyst and the reason for the change.
• The system shall allow users to click the review link and view the updates made by the fund accounting
associate.
Acceptance Criteria
Given that I want to review the updates made by the fund accounting team to security price,
when I click on ‘Price Review’ tab on ‘ My Pricing Quality Dashboard ‘ and click ‘Review’ for any
security, then:
o I should see the ‘securities price review screen’ with updates made by the fund
accounting team.

Pricing Quality Dashboard Project 1696408149

Uploaded by

Copyright:

Available Formats

Pricing Quality Dashboard Project 1696408149

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Pricing Quality Dashboard Project 1696408149

Uploaded by

Copyright:

Available Formats

Project Background

User Story ID 1.1

BA’s Explanation to Agile team

1st C = Card ( user story)

BA’s Explanation to Agile team

User Story ID 1.3

BA’s Explanation to Agile team

BA’s Explanation to Agile team

You might also like