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 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) Finastra | 31 January 2018 2
WHY SDK? Finastra | 31 January 2018 3
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 Finastra | 31 January 2018 4
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 Finastra | 31 January 2018 5
WHAT? Scripted Wizards XPath / XQuery Scripting Editor Internal Actions (Script) Controller Events Internal Actions (Java) User Defined Functions Scripted API User Defined G/L Entries Internal and External Validation User Defined Server Transactions EMPush Scripted Batch Event Management Shell Commands Object Model Browser Object Inspector Calculated Business Web Service Calls Objects Finastra | 31 January 2018 6
EVENT MANAGEMENT TRIGGERS 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. Finastra | 31 January 2018 7
EVENT MANAGEMENT TRIGGERS 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 Finastra | 31 January 2018 8
SCRIPTING EDITOR Allows to create and maintain the scripts referred to in the Event Management triggers table. Many sample scripts provided out of the box (on top of those used by core features). Finastra | 31 January 2018 9
SDK USE CASES Finastra | 31 January 2018 10
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 Finastra | 31 January 2018 11
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 Finastra | 31 January 2018 12
USE CASE 2 – CUSTOM VALIDATION 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 Finastra | 31 January 2018 13
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 Finastra | 31 January 2018 14
USE CASE 3 – CUSTOM BATCH PROCESS 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 o Batch Query -- Inquiry API, RID List, Object List etc. o Batch Action -- Action to be performed on Loan IQ Objects • Parameterized -- Ability to pass parameters similar to core Loan IQ batch processes Finastra | 31 January 2018 15
USE CASE 4 – API EXTENSION Requirement When creating a Deal via API, some fields of the Past Due Pricing Option are not supported. Finastra | 31 January 2018 16
USE CASE 4 – API EXTENSION 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 o API declaration o Request and Response structure declaration o API Action to define business logic • API can be tested using Scripting editor Finastra | 31 January 2018 17
WHAT OUR CUSTOMERS HAVE DEVELOPED WITH SDK 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 Finastra | 31 January 2018 18
EXISTING REQUIREMENTS WHICH SDK COULD ADDRESS 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) Finastra | 31 January 2018 19
WRAP-UP Finastra | 31 January 2018 20
SDK TECHNOLOGY – KEY CONCEPTS STANDARD PLATFORM 1 Access to Loan IQ java class interfaces. Customisation can be in JAVA or Javascript. Standard Eclipse IDE normally used. EXPOSED TECHNOLOGY 2 Business objects and attributes. Event management framework. Extend existing Loan IQ application structures. PREREQUISITES 3 No extra hardware requirements. SDK license is required. Loan IQ version 7.2.4 onwards. Finastra | 31 January 2018 21
BENEFITS Increased Automation Time To Control And Market Validation SDK Re-usability Extend And Loan IQ Resources Enterprise Integration Finastra | 31 January 2018 22
OTHER INFO SOURCES Appendix to this slide deck SDK Programming Guide – In Technical tab of Documentation Portal SDK Training courses SDK Working Group – Volunteers needed! Finastra | 31 January 2018 23
NEXT STEPS • Questions and Answers In one minute • Send Presentation PDF and link to Survey • Post Presentation PDF and Webex recording on Documentation Portal (Tutorial tab) Later today • Rate this session • Suggest topics for future TOM sessions • State your organisation’s interest in the features presented Survey • lorenzo.cerutti@finastra.com Anytime Finastra | 31 January 2018 24
QUESTIONS AND ANSWERS Finastra | 31 January 2018 25
Thank you Lorenzo Cerutti SAG Specialist lorenzo.cerutti@finastra.com @FinastraFS Finastra LinkedIn Finastra YouTube Finastra | 31 January 2018
Recommend
More recommend
