1 / 13

FTPS Fund Transfer Pricing System

FTPS Fund Transfer Pricing System. FTPS Overview. FTPS computes FTP Income after Deducting Cost incurred in arranging Funds through Treasury It Incorporates both Retail & Commercial Lines of Businesses, Deposits & Loan products

ellie
Download Presentation

FTPS Fund Transfer Pricing System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FTPS Fund Transfer Pricing System

  2. FTPS Overview • FTPS computes FTP Income after Deducting Cost incurred in arranging Funds through Treasury • It Incorporates both Retail & Commercial Lines of Businesses, Deposits & Loan products • It provides way to "Mid Office" of Bank to Compute FTP Income Value to Funds Gathered & Lent/ Invested by Commercial & Retail Banking divisions • It Aims at Creating Scalable Platform for Treasury Operations Related Pricing Calculators

  3. Key Features • Data Management Comprehensive Web Based Data Management System with Web Based Reporting Engine & Easy to Use Menu Driven Product • FTP Calculation for the products specified below • Commercial Loan • Retail Loan • Deposits • Mortgage • System Maintenance Activity Database Archival, Purging, Restoring can done from the front-end of Product

  4. Key Features • Upload Feature All the input files required in the system can be uploaded directly from the network drive / server. Basic validation are supported in the application & other validations can be configured • Reporting Engine User defined front end based reporting configuration to develop multiple reporting structures & pre defined Reports • History of Records Audit trail of all the entries made in the system with date time stamp, user information stamp etc

  5. Key Features • Asynchronous Execution of ComputationAsynchronous Execution of computations allows Application users to continue with their processing even if the computation is in process • Lock/Unlock Utility This utility ensure that data is not uploaded simultaneously by the users

  6. Architecture

  7. Key Modules • Masters • Product , Currency • Compounding Frequency • Exchange Rate • Non Performing Asset Rate • Premature Withdrawal Charges • Liquidity Premium Matrix • Libor Rate • Interest GL • Adjust FTP Percentage • Retail Penalty Rate • Product Classification • Spread Product Master • Behavior FTP Rate

  8. Key Modules • Daily Activities • Import Data • FTP Rate • Computation • YieldCurve2 FTP Rate • Contracts • Deposit • Loan -> Retail Loan • Loan -> Commercial Loan • NPA • Closed / Cancel Cases • GL Reconciliation • Repayment Schedule • Mortgages Contracts

  9. Reports • Income Report • Loan Report • Commercial Loan Report • NII Report • Mortgage Report • Average Balance & Yield Report • Cash flow report

  10. Technology Architecture • 3 tier browser based architecture • Database server – MS SQL server 2008R2 & above / ORACLE 10 & above • Application server – JAVA, J-boss • Browser - Firefox, Internet Explorer, Google chrome • Separate environments for development, UAT & production Other technical aspects • Ability to log all amendments done on any master data sets viz. Models, parameters, user information, counterparty data, etc amongst others. • Effective tracking of any amendments by virtue of predefined audit trail reports which log records of all amendments conducted. • Any changes made on master data set contents can be easily & effectively tracked on a user level. • Auditing & logging for data loads, process executions etc.

  11. Implementation Phase3 Design & implementation phase Phase 0 Programme initiation phase Phase1 Business analysis Phase2 Implementation road map Formation & deployment of implementation team – system installation Define business rules for implementation Business analysis Establish project scope Implement business rules Understand: - Bank structure - Programme structure - Diagnostic review of as is position - Key decisions / aspirations Model analysis & identification Identification of project resources Design reports Deploy configuration module – through parameterization & static information Discuss the drat implementation plan with the bank once the business scope is finalised Detailed action plan for project implementation & management Deploy logical data model & overall technical architecture for implementation First implementation run & UAT for output. Resolve pending UAT & client observations Go live (data migration, final deployment, go live testing, roll out, reporting) Dedicated program management office for overall management, design & monitoring of solution implementation

  12. Critical Success Factor • Top Management Buy-in is mandatory for Success of Critical Implementation Programs • Formation of Committed Team from Client & Nucsoft for Implementation • Complete Involvement from Client’s IT & Business Teams for Data Mapping Exercise • Planned & Swift Execution of UAT • Project Plan which is Tightly Monitored at Close Intervals • Quick Turnaround Time for Requests – for Key Decisions as well as Data • Good Connectivity available between UAT Environment in Client & Nucsoft Development Environment - to Facilitate Offshore Activities

  13. Thank you

More Related