SDK USE CASES Topic of the Month FusionBanking Loan IQ Lorenzo - - PowerPoint PPT Presentation

▶
sdk use cases
SMART_READER_LITE
LIVE PREVIEW

SDK USE CASES Topic of the Month FusionBanking Loan IQ Lorenzo - - PowerPoint PPT Presentation

Jan 23, 2024 295 likes •630 views

SDK USE CASES Topic of the Month FusionBanking Loan IQ Lorenzo Cerutti SAG Specialist Vishal Chandgude MSDC Principal Consultant January 2018 Finastra WELCOME TO THE FINASTRA TOPIC OF THE MONTH! Format 45 min presentation by

slide-1
SLIDE 1

Finastra

SDK USE CASES

Topic of the Month – FusionBanking Loan IQ

Lorenzo Cerutti SAG Specialist Vishal Chandgude MSDC Principal Consultant

January 2018

slide-2
SLIDE 2

Finastra |

WELCOME TO THE FINASTRA TOPIC OF THE MONTH!

Format

▪

45 min presentation by Finastra experts

▪

15 min Questions and Answers Objectives

▪

Present product features and market requirements new / little known / under spotlight

▪

Share views and help us understanding client requirements Frequency

▪

Monthly within Finastra – For Loan IQ 3-4 sessions per year

▪

Schedule in SAG section of Documentation Portal

▪

Invitations sent 2 weeks in advance to mailing list

▪

Open for topics suggestions (can use Survey)

31 January 2018 2

slide-3
SLIDE 3

Finastra |

WHY SDK?

31 January 2018 3

slide-4
SLIDE 4

Finastra |

WHY SDK?

Limits of traditional ‘funded development’ model If good for core, include in product roadmap If not, or urgent need, use SDK Extend Loan IQ capabilities – in a controlled way

31 January 2018 4

slide-5
SLIDE 5

Finastra |

WHO?

Bank staff Third party contracted by Bank Finastra Partners Finastra

Finastra as funded development (runtime license). Not recommended - support implications.

Standard Training course available – 3 days Suggestion: mixed Bank/Finastra team

First development: we do, client shadows Second development: done together Third development: client does, we shadow

31 January 2018 5

slide-6
SLIDE 6

Finastra |

WHAT?

31 January 2018 6

User Defined Functions User Defined Server Transactions Internal Actions (Java) Internal Actions (Script) Scripted Batch Scripted API Event Management XPath / XQuery Scripting Editor Object Model Browser Object Inspector User Defined G/L Entries Scripted Wizards Internal and External Validation EMPush Shell Commands Web Service Calls Controller Events Calculated Business Objects

slide-7
SLIDE 7

Finastra |

EVENT MANAGEMENT TRIGGERS

31 January 2018 7

Allows to link an SDK-written script to a Loan IQ event. For example, add validation when a Loan Drawdown is sent to approval. Better approach than adding triggers to the database.

slide-8
SLIDE 8

Finastra |

EVENT MANAGEMENT TRIGGERS

31 January 2018 8

Three types of actions

Publish data to external system Realtime – results of query processed on main Loan IQ server Near Realtime – results of query processed on Remote Execution server Pre-fetched – query executed before commit. Can halt upon error, or skip. Deferred - performed at end of day based on cumulated events (Balance) Perform custom validation Returns error code, message and type (E/W/I/S) Internal or External Perform custom processing, including update of Loan IQ objects Java or Script

slide-9
SLIDE 9

Finastra |

SCRIPTING EDITOR

31 January 2018 9

Allows to create and maintain the scripts referred to in the Event Management triggers table. Many sample scripts provided

  • ut of the box (on top of those

used by core features).

slide-10
SLIDE 10

Finastra |

SDK USE CASES

31 January 2018 10

slide-11
SLIDE 11

Finastra |

USE CASE 1 – EVENT MANAGEMENT USE CASES

Requirements Validation -- Block user from creating principal payment greater than USD 1000 Internal Action -- Update a Facility MIS Code value on release of loan drawdown Publishing -- Publish Cashflow/Payments information to Enterprise payments system

31 January 2018 11

slide-12
SLIDE 12

Finastra |

USE CASE 2 – CUSTOM INITIALIZATION & VALIDATION

Requirements Limit the Pricing Options that can be created for a Deal based on the Processing Area that the User belongs to Change the default value of Initial Fraction Rate for selected Pricing option (from 1/8 to 1/4) Validation – Initial Fraction Rate of 1/8 is not allowed for LIBOR Pricing Option

31 January 2018 12

slide-13
SLIDE 13

Finastra |

USE CASE 2 – CUSTOM VALIDATION

31 January 2018 13

Overview of SDK Solution

  • Used the Controller Events feature of SDK. This feature can be used to customize the Loan IQ

notebook values by defaulting fields with specific values, limit the drop down values, make required fields read only etc.

  • The Controller Events feature allows to invoke custom code on initialization of any Loan IQ

notebook by exposing "postOpenInitialization" method

  • This feature can also be used to implement custom input data validation
  • This feature allows to define custom code that gets executed before execution of core Loan IQ

code on button click operation

  • Controller Events feature provides hooks to call custom code in the form of "preActionFilter"

method

slide-14
SLIDE 14

Finastra |

USE CASE 3 – CUSTOM BATCH PROCESS

Requirement Release certain payments in advance during Loan IQ end of day batch Typically the cashflow/payment messages are released on release of Loan IQ transaction and certain payment methods like SWIFT, SEPA etc. take 2-3 days to clear Banks want to release the cash flows automatically a certain number of days prior to the transaction effective date

31 January 2018 14

slide-15
SLIDE 15

Finastra |

USE CASE 3 – CUSTOM BATCH PROCESS

31 January 2018 15

Overview of SDK Solution

  • SDK Scripted Batch feature used
  • Scripted Batch can be developed either using Java or JavaScript
  • Can be scheduled to run as part of Loan IQ Batch Net
  • Batch process has full access to Loan IQ Business objects and internal processes.
  • Involves creation of two components
  • Batch Query -- Inquiry API, RID List, Object List etc.
  • Batch Action -- Action to be performed on Loan IQ Objects
  • Parameterized -- Ability to pass parameters similar to core Loan IQ batch processes
slide-16
SLIDE 16

Finastra |

USE CASE 4 – API EXTENSION

Requirement When creating a Deal via API, some fields of the Past Due Pricing Option are not supported.

31 January 2018 16

slide-17
SLIDE 17

Finastra |

USE CASE 4 – API EXTENSION

31 January 2018 17

Overview of SDK Solution

  • Scripted API feature of SDK allows for extending the Core APIs or develop new APIs
  • Scripted API can be developed either using Java or JavaScript
  • Custom API process has full access to Loan IQ Business objects and internal processes
  • Created Scripted API "CreateDealCustom" that extends the Core API "CreateDeal"
  • Involves creation of
  • API declaration
  • Request and Response structure declaration
  • API Action to define business logic
  • API can be tested using Scripting editor
slide-18
SLIDE 18

Finastra |

Event-based accounting Avoid setting Ongoing Fee Payments to ‘Needs Review’ following a scheduled commitment change Check borrower global limits on central limits system Validate MIS Codes and Additional Fields with an external data source Generate a principal payment based on collateral revaluation Update the User Profile settings in Loan IQ if the master user profile permissions change in central HR database Generate additional General Ledger entries for FX realised profit/loss on loan repayments

WHAT OUR CUSTOMERS HAVE DEVELOPED WITH SDK

31 January 2018 18

slide-19
SLIDE 19

Finastra |

EXISTING REQUIREMENTS WHICH SDK COULD ADDRESS

31 January 2018 19

Interface to non-Finastra Origination system or Borrower Portal (if core APIs need to be amended) Create customers in a new location (automate the creation of the location in the Locations table) Create a conversion fee when a drawdown is in a currency different from the facility currency Create GL entries for the commitment as soon as deal is approved – before deal closure Copy SBLCs from one deal to another Create Deposit increase/decrease to reflect changes in exposure For PIK, merge notices for payment and repricing Create a commitment increase/decrease on a Facility based upon a commitment increase/decrease on another facility (from a different Deal)

slide-20
SLIDE 20

Finastra |

WRAP-UP

31 January 2018 20

slide-21
SLIDE 21

Finastra |

SDK TECHNOLOGY – KEY CONCEPTS

31 January 2018 21

EXPOSED TECHNOLOGY Business objects and attributes. Event management framework. Extend existing Loan IQ application structures. STANDARD PLATFORM Access to Loan IQ java class interfaces. Customisation can be in JAVA or Javascript. Standard Eclipse IDE normally used. PREREQUISITES No extra hardware requirements. SDK license is required. Loan IQ version 7.2.4 onwards.

2 1 3

slide-22
SLIDE 22

Finastra |

BENEFITS

31 January 2018 22

Increased Automation Time To Market Control And Validation Extend Loan IQ Re-usability And Resources Enterprise Integration

SDK

slide-23
SLIDE 23

Finastra |

OTHER INFO SOURCES

31 January 2018 23

Appendix to this slide deck SDK Programming Guide – In Technical tab of Documentation Portal SDK Training courses SDK Working Group – Volunteers needed!

slide-24
SLIDE 24

Finastra |

NEXT STEPS

31 January 2018 24

In one minute

  • Questions and Answers

Later today

  • Send Presentation PDF and link to Survey
  • Post Presentation PDF and Webex recording on Documentation Portal (Tutorial

tab)

Survey

  • Rate this session
  • Suggest topics for future TOM sessions
  • State your organisation’s interest in the features presented

Anytime

  • lorenzo.cerutti@finastra.com
slide-25
SLIDE 25

Finastra |

QUESTIONS AND ANSWERS

31 January 2018 25

slide-26
SLIDE 26

Finastra |

@FinastraFS Finastra LinkedIn Finastra YouTube

Thank you

Lorenzo Cerutti SAG Specialist

31 January 2018

lorenzo.cerutti@finastra.com

slide-27
SLIDE 27

Finastra |

SDK COMPONENTS

31 January 2018 27

Component, description, benefit Inquiry API

Based on industry standard XQuery, Inquiry API allows the user to develop scripts for extracting business information from Loan IQ without needing direct database access. Avoid replication of Loan IQ application logic to extract information from Loan IQ

Event Management Publishing Service

This feature allows clients to develop custom interfaces in an SOA manner by subscribing to Loan IQ Activities and thereby having relevant information delivered to various target systems. Ability to publish data to external systems through standard industry communication channels

slide-28
SLIDE 28

Finastra |

Internal (Java) Actions

Using Java language, users can implement complex validations and the necessary object updates as part of business event trigger

  • processing. Clients can use this

feature to implement customized processing needed to institute their business process steps. Allows custom validation s and actions to support business process workflows

User Defined Primitive Functions (UDF)

Enhance capabilities of Inquiry API by implementing primitive functions, callable from your scripts, in Java. This opens up Inquiry API script capabilities to significantly more powerful capabilities that can be implemented in Java. Use Java language express ability to support the business process workflows

SDK COMPONENTS

31 January 2018 28

Component, description, benefit

slide-29
SLIDE 29

Finastra |

SDK COMPONENTS

31 January 2018 29

Component, description, benefit Custom Validations

Ability to attach validations using Internal Validations to Loan IQ’s existing business object save validation logic. Additionally, internal actions and validations are now foreshadowed to apply validations preemptively. Efficient custom validations to support business process

Scripting Editor

Development tool for Loan IQ Scripting and API testing Loan IQ Specific development tool

slide-30
SLIDE 30

Finastra |

Loan IQ shell

Secure access to Loan IQ core

  • bject with the command line

Ease of use for SDK development support team to execute Java script programs

Scripted APIs

Ability to augment an existing API or write a brand new API including deeply nested XML Structures. API action logic is supplied in JavaScript that benefits from full access to Loan IQ business objects. Reduce dependency on Finastra for supporting extension of existing API’s and need of new API’s

SDK COMPONENTS

31 January 2018 30

Component, description, benefit Calculated BO attributes / BO Extensions

Ability to populate non persistent informational fields by using existing attributes in real time Custom calculated attributes in real time to support business process workflow

slide-31
SLIDE 31

Finastra |

User Defined Server Transactions (UDTx)

Ability is provided to call (from the Client) user supplied logic implemented in Java and running on the Loan IQ Server. This process flow leverages the same security and concurrency mechanisms from which all Loan IQ Server resident transactions benefit. Leverage Loan IQ Client –Server architecture to communicate with external application

SDK COMPONENTS

31 January 2018 31

Component, description, benefit Scripted Batch

Using JavaScript customers can write a multi-threaded batch process having full access to Loan IQ business objects. Custom schedule batch programs to support business process

slide-32
SLIDE 32

Finastra |

SDK COMPONENTS

31 January 2018 32

Component, description, benefit Controller events

Execute custom business logic within a controller( notebooks and dialogues) Simplification of manual tasks

Flexible search queries

Ability to configure search filters for the existing searches in Loan IQ through scripts Find information by custom searches

Deployment improvement and configurations

Ability to move and compare system configurations across Loan IQ envs. Helps in rolling out upgrades and rollout of new enhancements

slide-33
SLIDE 33

Finastra |

Scripted Navigator

Ability to control and create the layout of the Navigator desktop across the

  • system. Custom and

tailored Navigator desktop across the system based on certain parameters Customize desktop experience

  • f users and enhanced Loan IQ

CSI (client side integration)

Wizard launch descriptor

Ability to configure and launch wizards from Loan IQ notebooks and Navigator desktop as a menu

  • ption

Streamline business process to reduce manual steps

SDK COMPONENTS

31 January 2018 33

Component, description, benefit