WIXLIB

SDK USE CASESTopic of the Month – FusionBanking Loan IQLorenzo CeruttiSAG SpecialistVishal ChandgudeMSDC Principal ConsultantJanuary 2018Finastra

WELCOME TO THE FINASTRA TOPIC OF THE MONTH!Format 45 min presentation by Finastra experts15 min Questions and AnswersObjectives Present product features and market requirements new / little known / underspotlightShare views and help us understanding client requirementsFrequency FinastraMonthly within Finastra – For Loan IQ 3-4 sessions per yearSchedule in SAG section of Documentation PortalInvitations sent 2 weeks in advance to mailing listOpen for topics suggestions (can use Survey) 31 January 20182

WHY SDK?Finastra 31 January 20183

WHY SDK?Limits of traditional ‘funded development’ modelIf good for core, include in product roadmapIf not, or urgent need, use SDKExtend Loan IQ capabilities – in a controlled wayFinastra 31 January 20184

WHO?Bank staffThird party contracted by BankFinastra PartnersFinastraFinastra as funded development (runtime license). Not recommended - supportimplications.Standard Training course available – 3 daysSuggestion: mixed Bank/Finastra teamFirst development: we do, client shadowsSecond development: done togetherThird development: client does, we shadowFinastra 31 January 20185

WHAT?Scripted WizardsXPath / XQueryScripting EditorInternal Actions (Script)Controller EventsInternal Actions (Java)User Defined FunctionsScripted APIUser Defined G/L EntriesInternal and ExternalValidationEvent ManagementObject InspectorCalculated BusinessObjectsFinastra 31 January 2018User Defined ServerTransactionsEMPushScripted BatchShell CommandsObject Model BrowserWeb Service Calls6

EVENT MANAGEMENT TRIGGERSAllows to link an SDK-writtenscript to a Loan IQ event.For example, add validationwhen a Loan Drawdown is sentto approval.Better approach than addingtriggers to the database.Finastra 31 January 20187

EVENT MANAGEMENT TRIGGERSThree types of actionsPublish data to external systemRealtime – results of query processed on main Loan IQ serverNear Realtime – results of query processed on Remote Execution serverPre-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 ExternalPerform custom processing, including update of Loan IQ objectsJava or ScriptFinastra 31 January 20188

SCRIPTING EDITORAllows to create and maintainthe scripts referred to in theEvent Management triggerstable.Many sample scripts providedout of the box (on top of thoseused by core features).Finastra 31 January 20189

SDK USE CASESFinastra 31 January 201810

USE CASE 1 – EVENT MANAGEMENT USE CASESRequirementsValidation -- Block user from creating principal payment greater than USD 1000Internal Action -- Update a Facility MIS Code value on release of loan drawdownPublishing -- Publish Cashflow/Payments information to Enterprise payments systemFinastra 31 January 201811

USE CASE 2 – CUSTOM INITIALIZATION & VALIDATIONRequirementsLimit the Pricing Options that can be created for a Deal based on the Processing Areathat the User belongs toChange 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 OptionFinastra 31 January 201812

USE CASE 2 – CUSTOM VALIDATIONOverview of SDK Solution Used the Controller Events feature of SDK. This feature can be used to customize the Loan IQnotebook values by defaulting fields with specific values, limit the drop down values, makerequired fields read only etc. The Controller Events feature allows to invoke custom code on initialization of any Loan IQnotebook 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 IQcode on button click operation Controller Events feature provides hooks to call custom code in the form of "preActionFilter"methodFinastra 31 January 201813

USE CASE 3 – CUSTOM BATCH PROCESSRequirementRelease certain payments in advance during Loan IQ end of day batchTypically the cashflow/payment messages are released on release of Loan IQtransaction and certain payment methods like SWIFT, SEPA etc. take 2-3 days toclearBanks want to release the cash flows automatically a certain number of days prior tothe transaction effective dateFinastra 31 January 201814

USE CASE 3 – CUSTOM BATCH PROCESSOverview of SDK Solution SDK Scripted Batch feature usedScripted Batch can be developed either using Java or JavaScriptCan be scheduled to run as part of Loan IQ Batch NetBatch process has full access to Loan IQ Business objects and internal processes.Involves creation of two componentso 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 processesFinastra 31 January 201815

USE CASE 4 – API EXTENSIONRequirementWhen creating a Deal via API, somefields of the Past Due Pricing Optionare not supported.Finastra 31 January 201816

USE CASE 4 – API EXTENSIONOverview of SDK Solution Scripted API feature of SDK allows for extending the Core APIs or develop new APIsScripted API can be developed either using Java or JavaScriptCustom API process has full access to Loan IQ Business objects and internal processesCreated Scripted API "CreateDealCustom" that extends the Core API "CreateDeal"Involves creation ofooo API declarationRequest and Response structure declarationAPI Action to define business logicAPI can be tested using Scripting editorFinastra 31 January 201817

WHAT OUR CUSTOMERS HAVE DEVELOPED WITH SDKEvent-based accountingAvoid setting Ongoing Fee Payments to ‘Needs Review’ following a scheduled commitment changeCheck borrower global limits on central limits systemValidate MIS Codes and Additional Fields with an external data sourceGenerate a principal payment based on collateral revaluationUpdate the User Profile settings in Loan IQ if the master user profile permissions change in centralHR databaseGenerate additional General Ledger entries for FX realised profit/loss on loan repaymentsFinastra 31 January 201818

EXISTING REQUIREMENTS WHICH SDK COULD ADDRESSInterface 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 currencyCreate GL entries for the commitment as soon as deal is approved – before deal closureCopy SBLCs from one deal to anotherCreate Deposit increase/decrease to reflect changes in exposureFor PIK, merge notices for payment and repricingCreate a commitment increase/decrease on a Facility based upon a commitment increase/decrease on another facility (from adifferent Deal)Finastra 31 January 201819

WRAP-UPFinastra 31 January 201820

SDK TECHNOLOGY – KEY CONCEPTS1STANDARD PLATFORMAccess to Loan IQ java class interfaces.Customisation can be in JAVA or Javascript.Standard Eclipse IDE normally used.2EXPOSED TECHNOLOGYBusiness objects and attributes.Event management framework.Extend existing Loan IQ application structures.3PREREQUISITESNo extra hardware requirements.SDK license is required.Loan IQ version 7.2.4 onwards.Finastra 31 January 201821

BENEFITSIncreasedAutomationTime ToMarketControl AndValidationSDKRe-usabilityAndResourcesExtendLoan IQEnterpriseIntegrationFinastra 31 January 201822

OTHER INFO SOURCESAppendix to this slide deckSDK Programming Guide – In Technical tab of Documentation PortalSDK Training coursesSDK Working Group – Volunteers needed!Finastra 31 January 201823

NEXT STEPS Questions and AnswersIn one minuteLater today Send Presentation PDF and link to Survey Post Presentation PDF and Webex recording on Documentation Portal (Tutorialtab) Rate this session Suggest topics for future TOM sessions State your organisation’s interest in the features presentedSurvey lorenzo.cerutti@finastra.comAnytimeFinastra 31 January 201824

QUESTIONS AND ANSWERSFinastra 31 January 201825

Thank youLorenzo CeruttiSAG inastra LinkedInFinastra YouTubeFinastra 31 January 2018

SDK COMPONENTSComponent, description, benefitFinastra Inquiry APIBased on industry standard XQuery,Inquiry API allows the user to developscripts for extracting businessinformation from Loan IQ withoutneeding direct database access.Avoid replication of Loan IQapplication logic to extractinformation from Loan IQEvent ManagementPublishing ServiceThis feature allows clients to developcustom interfaces in an SOA mannerby subscribing to Loan IQ Activitiesand thereby having relevantinformation delivered to various targetsystems.Ability to publish data to externalsystems through standard industrycommunication channels31 January 201827

SDK COMPONENTSComponent, description, benefitFinastraInternal (Java) ActionsUsing Java language, users canimplement complex validations andthe necessary object updates aspart of business event triggerprocessing. Clients can use thisfeature to implement customizedprocessing needed to institute theirbusiness process steps.Allows custom validation s andactions to supportbusiness process workflowsUser Defined PrimitiveFunctions (UDF)Enhance capabilities of Inquiry APIby implementing primitivefunctions, callable from yourscripts, in Java. This opens upInquiry API script capabilities tosignificantly more powerfulcapabilities that can beimplemented in Java.Use Java language express abilityto support the business processworkflows 31 January 201828

SDK COMPONENTSComponent, description, benefitFinastra Custom ValidationsAbility to attach validations usingInternal Validations to Loan IQ’sexisting business object savevalidation logic. Additionally,internal actions and validations arenow foreshadowed to applyvalidations preemptively.Efficient custom validations tosupport business processScripting EditorDevelopment tool for Loan IQScripting and API testingLoan IQ Specific development tool31 January 201829

SDK COMPONENTSComponent, description, benefitFinastraScripted APIsAbility to augment an existing API orwrite a brand new API includingdeeply nested XML Structures. APIaction logic is supplied inJavaScript that benefits from fullaccess to Loan IQ business objects.Reduce dependency on Finastrafor supporting extension ofexisting API’s and need of new API’sLoan IQ shellSecure access to Loan IQ coreobject with the command lineEase of use for SDK developmentsupport team to execute Javascript programsCalculated BO attributes /BO ExtensionsAbility to populate non persistentinformational fields by usingexisting attributes in real timeCustom calculated attributes in realtime to support business processworkflow 31 January 201830

SDK COMPONENTSComponent, description, benefitFinastra User Defined ServerTransactions (UDTx)Ability is provided to call (from theClient) user supplied logicimplemented in Java and running onthe Loan IQ Server. This processflow leverages the same securityand concurrency mechanisms fromwhich all Loan IQ Server residenttransactions benefit.Leverage Loan IQ Client –Serverarchitecture to communicate withexternal applicationScripted BatchUsing JavaScript customers canwrite a multi-threaded batch processhaving full access to Loan IQbusiness objects.Custom schedule batch programs tosupport business process31 January 201831