Development of Custom Share Register

Project Brief

Provide a multi-fund solution that will enable the existing Excel based solutions to be retired and streamline the production of client, agent and fund documentation.

Introduce BACS payments for client payments and agent commissions. All historic data from the existing spreadsheets should be transferred to the new system.

Solution Implemented

This system was delivered using Microsoft Visual Studio 2005 and the .Net Framework 2.0 with data being held in a SQL Server 2000 database. Once the database had been modelled a series of conversion routines were developed to allow for the database to be populated.

The application was developed as a windows forms based solution using an MDI approach with easy access to all application functions. The program integrates with Microsoft Word for the production of various client letters when a dividend is declared. Management reporting and information is handled by Crystal Reports with BACS payments being processed via RBSI.

All database access is via an abstracted data access layer with extensive use of views and stored procedures throughout.

Built Using Custom Controls and Libraries Microsoft SQL Server Microsoft .Net Framework Microsoft Visual Studio Crystal Reports Microsoft Visual Basic .Net Microsoft Word Microsoft Office Automation

Services Provided Requirements Analysis and System Design Database Design Development Management Reporting Microsoft Office Integration Setup and Distribution Kit Data Conversion