PNN Soft’s solution is aimed at thorough financial and operational planning
The automated system provides the coordination of budget requests with the possibility of operational adjustments and operational control of the fund’s usage within the available limits. Besides, the system is aimed to forecast and plan-fact analysis creation of payment documents due to the integration of financial and operational planning processes. The solution is implemented as a business process run by IBM WebSphere Process Server and integrated into the Bank’s internal portal run by IBM WebSphere Portal Server. Implementing the project, PNN Company has integrated with the Bank financial planning application Oracle Hyperion Planning.
The automated system, along with Oracle Hyperion Planning, provides budget planning with the possibility of operational adjustments, operational control over the funds’ expenses within the available limits, forecasting and plan-fact analysis, and preparation of payment documents through the integration of financial and operational planning processes.
PNN Company has developed and implemented the following:
- Automated budget performance monitoring system within the approved plan (administrative and management costs and capital investments) at financial responsibility centres (structural units of the Bank) of multidivisional Bank;
- Digital signature tool (DSTU), which provides a reliable confirmation of the authenticity of an electronic document request to funds application.
System implementation advantages:
- The term of request agreement and payment accomplishment using paper or Excel file for preliminary control is reduced from 3-5 days to a few hours after the introduction of the system.
- Optimization of the staff involved in internal support of departments and in the financial control of the budget funds spending became possible.
- Planned Bank costs exceeding those caused by the lack of effective control is now impossible.
The automated budget performance monitoring system provides the following:
- User authorization and system access rights control based on the AD directory of the Bank;
- Creating and upgrading the applications for budget fulfilment by the Bank’s departments with the integration of the planning application Oracle Hyperion Planning;
- Integration with the automated Bank system B2 within the list of suppliers and employees, which appear in applications;
- Integration with IBM Lotus Notes applications for the documents creating that accompany requests for the budget funds expenditure; user system alerts about the changes in the request’s status;
- Coordination and approval using a digital signature by the Bank’s senior officials in accordance with internal Bank policies;
- Budget reserves formation and control over the available limits. The process provides centralized control over the fund’s expenditure;
- Automatic generation of the internal deals with the parameters of management accounts and transactions in an automated Banking system to make payments by the Bank departments;
- Collecting and storing the actual budget expenditures results and plan/fact analysis;
- Formed reserves, paid accounts and allocation of actual costs reports creation.
Technical features:
- Server Platform: IBM Process Server 7.0, IBM WebSphere Portal Server 7.0, Linux Red Hat Enterprise 5
- Target browsers: IE 8.0 and Google Chrome.
- GUI framework: JSP, JSF, Java portlets,
- Databases: Oracle SQL Server
- Data Access: JDBC, DB Link, Hyperion Java API
Business logic features:
- Business logic to work with the internal and external information sources implemented through Web Services, published on the Bank ESB;
- Support Group for the Business Process Choreographer application to provide immediate management of the approval of the request;
- Custom reports are built using the system based on the Jasper Engine.
Management and resources:
- Timeline: 3 phases: a pilot stage in the head office (3 months), experimental and industrial exploitation of the network (3 months), and commercial exploitation (3 months). Total – 9 months.
- Resources: project manager, senior analyst, a team of developers, analyst of ABS B2 (a system of Banking day), software testers.
- Technologies: planning for MS Project 2007, keeping the source code and documentation SVNB (Tortoise SVN client). The development environment IBM WebSphere Integration Developer V7.0, SQL Navigator 6.4 as a development environment schemes and packet data PL SQL procedures.
- Training technology: IMB Lotus Central Assemblies.
See similar projects on our blog.
