Title of the Project

Development of a Campaign Information System

Abstract of the project

An insurance company wants to start campaigns for its new products to be sold to the prospective customers. Campaign means advertising of the products through channels like Tele marketing, letters, signboards, TV Commercials, etc. There are different campaigns for different products and there is a specific period for each campaign.

Before the campaign starts, estimates are made on sales to be achieved, budget allocation for each campaign and variance allowed (%) both for sales and budget. When the actual data is captured, the actual variance(%) is calculated. The difference between the actual and the estimated variance gives the insurance company an insight into their estimation and it helps in making strategic decisions about budgets and campaign periods.

You have to develop the system, which captures the above functionality. It is an intranet application

abstract for development of campaign information system

[attachment=10350]
Development of a Campaign Information System
Abstract of the project
An insurance company wants to start campaigns for its new products to be sold to the prospective customers. Campaign means advertising of the products through channels like Tele marketing, letters, signboards, TV Commercials, etc. There are different campaigns for different products and there is a specific period for each campaign.
Before the campaign starts, estimates are made on sales to be achieved, budget allocation for each campaign and variance allowed (%) both for sales and budget. When the actual data is captured, the actual variance(%) is calculated. The difference between the actual and the estimated variance gives the insurance company an insight into their estimation and it helps in making strategic decisions about budgets and campaign periods.
You have to develop the system, which captures the above functionality. It is an intranet application
Keywords
Generic Keywords
Databases, Middleware, Programming
Specific Technology Keywords
Oracle Stored Procedures, ASP, HTML, JavaScript/VBScript
Project Type keywords
Analysis, Design, Implementation, Testing, Graphical User Interface
User will start with the login page in which username and password are entered. This screen should also provide a functionality to change the password. To change the password, it should ask for the old password, new password and confirm new password.
Based on the group, to which the user belongs, relevant modules are shown.
Modules are
• Campaign Master – which captures the master data for the campaigns for the product category and for the given period
• Product Master – All the new products for which campaigns are to be done.
• Estimated Budget Campaign - The information about the estimated campaign budget , sales target, period, type of campaign will be captured. Various formulae can be put to cross check the budget allocation with the period/type of campaign and type of product. For example, say for a campaign of 3 months by tele-marketing for xyz product type, the budget should be abc amount. These validations can be put on the client side. Assumption on various details(like gifts to be given to customers in campaign period, discounts, etc ) to be captured for a campaign apart from the ones mentioned can be helpful. Please Brainstorm on this.
• Actual Budget Campaign – This will be similar to the above module except that it will capture the actual data
• Statistics – Here different reports can be shown as follows
 Different campaigns for different products in a given time frame
 Variance reports (estimated vs actuals)
 Sales target reports vis a vis campaigns
• Help – Describing operation of the whole application
• Administration – Here users can be assigned to groups and the groups in turn can be assigned rights to different modules.
In addition to this , we can have a help page link on each of the modules.
Steps to start-off the project:
Microsoft platform: The system is developed using Active Server Pages as the front end and Oracle/SQL Server/DB2 as the back end.

Java Platform: The system is developed using Java Server Pages/ Servlets as the front end and Oracle/SQL Server/DB2 as the back end.