MASfin Client Reporting

[ Home ] [ Success Stories ] [ Power-Tools ] [ Expertise ] [ Profile ] [ Clients ] [ Partners ] [ Employment ] [ News/Events ]

Technology Solutions for the Finance and Insurance Industry

Project Profile: Client reporting

Business Situation

As part of the installation of a new back office infrastructure, the client, a large asset management company, re-designed and implemented a new infrastructure for their client reporting and statement generation. The objective of the new infrastructure was to implement a fully automated process to accommodate several thousand client accounts, the back office users and access to the client reports for several hundred brokers across the country. The total transaction volume was above one million, with an estimated annual growth of 10 to 15%.

The role of Masfin Consulting

Masfin Consulting was involved in the design and implementation of the new processing infrastructure backbone for the application and database components using a servlet-based web architecture. The end-to-end straight-through process was modeled and tested as a proof-of-concept. As part of the stress testing, data from client accounts was used. The processing infrastructure was subsequently scaled up using a server farm and load balancing.

The database server was integrated in the stress test and scaled up by fine-tuning stored procedures, splitting up statements via interim and temporary tables as well as fine-tuning the installation of the database server.

The integration was achieved through the following steps:

	Design of the physical architecture
	proof-of-concepts for the end-to-end process
	scaling up of all software components involved
	create probes for all software components to identify and eliminate bottlenecks
	optimize the load balancing process that distributed the report generation and the associated high load for computation across several work performers.

Some of the performance improvements between the proof-of-concept and the rollout included

	Detection and recommendation of solutions for several network bottlenecks, in particular between the work performers and the database server
	Upgrade of both ODBC and JDBC drivers to a third-vendor solution
	Introduction of an application server based load balancing concept for the computationally intensive components
	Break-up of several hundred highly complex SQL statements into smaller pieces to ease the load on CPU and memory
	Fine tuning of the database server software and the setup of the operating system

Benefits of the solution

	Brokers throughout the country have online access to various client account reports
	Process to send account reports to clients is fully automated from the trade capture to sending the print files to a print shop
	Flexible component architecture allows production of tens of thousands of reports with a back office staff of no more than two
	System architecture is highly scalable to allow for growth by an order magnitude without the need for re-engineering
	Web architecture is fully portable across operating systems and web servers

Products used

Servlets, Java, EJB, IIS, COM+, SQL Server, Seagate Info Application Server

Download PDF version

[ Home ] [ Success Stories ] [ Power-Tools ] [ Expertise ] [ Profile ] [ Clients ] [ Partners ] [ Employment ] [ News/Events ]

Email: contact@masfin.com / Tel: (201) 459-9902 / Fax: (201) 459-9904/ Add: Masfin Consulting Inc. 26 Journal Square, Ste.1100 Jersey City, NJ 07306