Monarch Exercise 31 - ICE/Black Knight MSP S-21K Participation Consolidation of Remittance Analysis

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited January 23 in Altair RapidMiner

Exercise Info

  • Application (Classic vs Data Prep Studio): Classic
  • Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
  • Skills/Features Tested:  Standard Trap, Append, Group Footer, Summary
  • Systems of Record: ICE Mortgage Black Knight MSP
  • Estimated Time to Solve: 15 mins
  • Exercise files required are attached Below;
    • S-21K Participant Consolidation of Remittance Report.txt

Exercise Overview

You are an Investor Reporting Analyst at a Financial Institution and your Manager has asked you to perform some analysis on the S-21K Participant Consolidation of Remittance Report.txt in your Black Knight MSP system.

You are asked to answer the following questions;

  • How many accounts had Service Fees?
  • How many accounts have a Participation % that is not 90%?
  • How many loans have a Due Date that is > Paid Date

Answer

  • Please upload your answers below in the comment section for the exercise
  • A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.
Tagged:

Categories