Web Application Design for Credit Evaluation: Proposal in a Financial Institution

Web Application Design for Credit Evaluation: Proposal in a Financial Institution

  IJETT-book-cover           
  
© 2023 by IJETT Journal
Volume-71 Issue-7
Year of Publication : 2023
Author : Flor de Maria Milagros Ramirez Yovera, Anahí Adriana Mondalgo Castillo, Miguel Angel Cano Lengua
DOI : 10.14445/22315381/IJETT-V71I7P225

How to Cite?

Flor de Maria Milagros Ramirez Yovera, Anahí Adriana Mondalgo Castillo, Miguel Angel Cano Lengua, "Web Application Design for Credit Evaluation: Proposal in a Financial Institution," International Journal of Engineering Trends and Technology, vol. 71, no. 7, pp. 252-268, 2023. Crossref, https://doi.org/10.14445/22315381/IJETT-V71I7P225

Abstract
This article highlights the importance of implementing technological solutions in financial institutions to adequately manage credit risk since the main problem of financial organizations currently lies in the credit process. The objective of this research work is to design a web application to control the granting of credits in order to reduce the high-risk portfolio of the financial institution. The project was carried out by applying the scrum methodology, starting with the analysis for which information was collected through meetings and the use of tools such as questionnaires to identify then the necessary variables that will allow the selection of the ideal neural network algorithm that will allow us to improve the control of credit granting. Finally, the application prototypes are presented, so the respective measurement is carried out, for which the survey is divided into 4 dimensions.

Keywords
Credit risk, Neural network, Credit granting, Scrum methodology, Financial institution.

References
[1] G. Prieto, “Credit Risk estimation in Mexico,” International Magazine of Pension Funds, vol. 2, pp. 45-52, 2000.
[Google Scholar]
[2] Maria Luisa Saavedra Garcia, and Maximo Jorge Saavedra Garcia, “Models to Measure Bank Credit Risk,” Administration Notebooks, vol. 23, no. 40, pp. 295-319, 2010.
[Google Scholar] [Publisher Link]
[3] Ruben Chavarin Rodriguez, “Delinquency in the Payment of Credits and Profitability of Commercial Banks in Mexico,” Mexican Magazine of Economy and Finance, vol. 10, no. 1, pp. 73-85, 2015.
[Google Scholar] [Publisher Link]
[4] SBS, New COOPAC Supervision Scheme, 2020. [Online]. Available: https://www.sbs.gob.pe/coopac
[5] Por Carlos Fernández, and Y Sarah Arbieto, Savings and Credit Cooperatives must lose their Fear of Regulation, 2019.
[Publisher Link]
[6] Laura Calapiña et al., Web System for the Management of Credit Processes and Portfolio Recovery, Universidad Técnica de Ambato, 2016. [Online]. Available: https://repositorio.uta.edu.ec/jspui/handle/123456789/23658
[7] Cáceres Yujra, and Rosy Mirey, “Use of the Scrum Methodology in the Software Testing Process of the Development of a Mobile Application for the Banking Sector,” Cypertesis Digital Theses Repository, 2021.
[Google Scholar] [Publisher Link]
[8] Carlos Espino Timón, “Predictive Analysis: Techniques and Models Used and Their Applications - Open Source tools that allow their Use,” Open University of Catalonia, 2017.
[Google Scholar] [Publisher Link]
[9] Recalde Cortes et al., “Predictive Model for the use of Digital Banking According to the Demographic Behavior of the Young Segment of the City of Quito,” Technical University of Ambato, 2018.
[Google Scholar] [Publisher Link]
[10] Claudio Alfredo López Miranda, Predictive Model of Delinquency Range for Bank Loans using Simulated Data, 2013.
[Google Scholar]
[11] Fredy Perez, and Horacio Fernandez, “Neural Networks and Credit Risk Assessment,” Engineering Magazine University of Medellin, vol. 6, no. 10, pp. 77-91, 2007.
[Google Scholar] [Publisher Link]
[12] Manuel Valdivia Carbajal, “Comparison of Credit Risk Forecasting using Cloglog Asymmetric Binary Regression and Multilayer Perceptron,” La Molina National Agrarian University. 2019.
[Google Scholar] [Publisher Link]
[13] Stefan Lyócsa et al., “Default or Profit Scoring Credit Systems? Evidence from European and US Peer-to-peer Lending Markets,” Financial Innovation, vol. 8, 2022.
[CrossRef] [Google Scholar] [Publisher Link]
[14] Min Lin, “Innovative Risk Early Warning Model under Data Mining Approach in Risk Assessment of Internet Credit Finance,” Computational Economics, vol. 59, pp.1443-1464, 2022.
[CrossRef] [Google Scholar] [Publisher Link]
[15] Ekaterina V. Orlova, “Decision-making Techniques for Credit Resource Management using Machine Learning and Optimization,” Information, vol. 11, no. 3, 2020.
[CrossRef] [Google Scholar] [Publisher Link]
[16] Luis Cano et al., “Data Mining Algorithms for Risk Detection in Bank Loans,” 5th International Conference on Information Management and Big Data, pp. 151-159, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[17] Fatima Uriarte, Superintendence of Banking, Insurance and Private Pension Fund Administrators (SBS), 2016. [Online]. Available: https://www.sbs.gob.pe/Portals/0/jer/ddt_ano2016/20160916_SBS-DT-001-SBS_FUriarte.pdf
[18] Jichen Huang, and Meixuan, “Domain Adaptation Approach for Credit Risk Analysis,” International Conference on Software Engineering and Information Management, pp. 104-107, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[19] Gourab Chakraborty, “Evolving Profiles of Financial Risk Management in the Era of Digitization: The Tomorrow that Began in the Past,” Journal of Public Affairs, vol. 20, no. 2, 2020.
[CrossRef] [Google Scholar] [Publisher Link]
[20] Ariza Miller et al., “Risk Selection Model, Applied to the Granting of Microcredit in a Colombian Credit Financial Intermediary, Supported by Artificial Neural Networks,” Atlantic Review of Economics, 2012.
[Google Scholar] [Publisher Link]
[21] Sesme Zambrano, and Lida Ursulina, “Development of a System that Allows Managing the Risk Class of Customers in the Southern Area of Guayaquil with Overdue Portfolio,” Guayaquil University, 2020.
[Google Scholar] [Publisher Link]
[22] Aguilar Ventura, and Jeyson Junior, “Implementation of a Credit Line Proposal System for the Optimization of Credit Line Management by the BANTIQ System of La Financiera TFC S.A.C.,” National Technological University of South Lima, 2020.
[Google Scholar] [Publisher Link]
[23] Edgar Alirio Restrepo Castillo, and Fhánor Vásquez González, “Proposal for the Development of a Software Model for the Web that allows the Evaluation of the Credit Risk of the Entities of the Cooperative Solidarity Sector,” Ingenium Magazine, vol. 5, no. 9, pp. 15- 24, 2011.
[Google Scholar] [Publisher Link]
[24] Bendezú Tenorio, and Nataly Delia, “Implementation of an Information system in a Process Approach, for the Improvement of the Operation of the Credit Area of the Microfinanciera Crecer,” National University of Central Peru, 2014.
[Google Scholar] [Publisher Link]
[25] Calapiña Laura et al., “Web System for the Management of Credit Processes and Portfolio Recovery,” Technical University of Ambato, 2016.
[Google Scholar] [Publisher Link]
[26] OkHosting, Software Development Methodologies. [Online]. Available: https://okhosting.com/blog/metodologias-del-desarrollo-desoftware/#Metodologia_Scrum/
[27] SCRUMstudy, Una guía para el cuerpo de conocimiento de Scrum (Guía SBOK™), 2016. [Online]. Available: https://www.scrumstudy.com/SBOK/SCRUMstudy-SBOK-Guide-2016-spanish.pdf
[28] Juan Ricardo Cogollo Oyola, “Analysis, Proposal and Representation of Indicators in Agile Projects with SCRUM,” Active Notebook, vol. 5, 2013.
[Google Scholar] [Publisher Link]
[29] Walter G. Barrios et al., “SCRUM: Application Experience in a Software Development PyME in the NEA,” Journal of Computer Science & Technology, vol. 12, no. 3, pp. 110–115, 2012.
[Google Scholar] [Publisher Link]
[30] Llocclla Huaman Luisa, Cano Lengua Miguel Ángel, and Miguel Angel Chávez Herrera, “Design of a Web Application to Manage the Costs of the Basic Family Basket in Metropolitan Lima,” International Journal of Engineering Trends and Technology, vol. 71, no. 5, pp. 402-414, 2023.
[CrossRef] [Publisher Link]
[31] Anthony Carlos Montañez Ayala et al., “Proposal for the Development of a Web Platform to Improve the Attention of Specialized Consultations on Agricultural Practices, 2023,” International Journal of Engineering Trends and Technology, vol. 71, no. 5, pp. 350-364, 2023.
[CrossRef] [Publisher Link]
[32] García Paraizaman Anaclaudia et al., “Design of a Web Application to Increase the Sales of the Company Neverland in Lima, Peru,” International Journal of Engineering Trends and Technology, vol. 71, no. 4, pp. 387-402, 2023.
[CrossRef] [Publisher Link]
[33] V. Ragavi, and G. Vinodh Kumar, “Developing Data Driven Configuration for Service Oriented Situational Web Applications,” SSRG International Journal of Computer Science and Engineering, vol. 3, no. 4, pp. 9-12 , 2016.
[CrossRef] [Publisher Link]