Design And Implementation Of Financial Management Analysis System For Banks

With the increasing competition of domestic banks,the deepening of financial disintermediation,the marketization of interest rates and other factors,the prudential supervision of banks continue to strengthen,all these require domestic banks to develop from extensive and extensive development mode to intensive development mode,and gradually establish a customer-centric,product-oriented business model.However,the current financial industry is facing a large amount of data,the system is running slowly and the financial analysis statements issued lagged issues,this paper aims to give a set of financial management under the background of big data to the financial industry analysis system design and implementation.The primary works in this thesis are presented as follows:(1)On the basis of fully considering the system flexibility,versatility and efficiency,the B/S architecture design principle as the system architecture is determined,the framework of the Financial Management Analysis System is planed,logic modules of system functions,and the database structure are designed;(2)Based on the Hadoop + Oracle architecture,an integrated application architecture is constructed,which realizes the development of the front desk and the efficient distributed batch processing capability.To form the quick treatment competence on cost allocation,performance split and profit analysis by applying Hive technology,and with Spark technology to achieve rapid reporting of massive reporting data to meet the business needs of the timeliness;(3)The system takes Spring MVC + Spring + Hibernate technology framework based on Java,accesses Oracle data with SQL statement and accesses Hadoop data with HQL statement through JDBC service,through the Java application scheduling background system to meet user needs.The financial management analysis system designed and implemented in this thesis has been popularized in 36 branches of a large state-owned bank.The design of the system combined with the development of bank business needs and the new generation of IT planning requirements,taking into account the possibility of the future financial dimension management,the flexibility of financial accountinggranularity,the convenience of performance into the definition,etc,taking into account the advanced technology and ease of operation to ensure the system's high availability and scalability,to meet the needs of business management,cost sharing,performance sharing,profit analysis,and to achieve the requirements of financial management.The system has been stable since its inception,meeting the project's intended goals.