Skip to main content

¥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



Functional components of the project



Following is a list of functionality of the system. More functionality that you find appropriate can be added to this list. And, in places where the description of functionality is not adequate, you can make appropriate assumptions and proceed.

Users of the system : Employees of the Campaign department. Here again any number of groups can be assumed. For example, groups which have rights to view only the reports in HTML Format, groups having rights to enter/update/delete data, etc..

 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
╖         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 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.


The following steps will be helpful to start off the project

1.               Get a firm grasp on the above technology.

2.               Decide on the number of groups, number of products, period of campaigns, number of campaigns, business rules.

3.      Decide on the various details of the user and their groups that would be stored in the database (like employee/registeration-number, name, grade, location, system-login, password in cryptic form, etc)

4.      Make a super user who will be able to assign users to groups and will be able to assign rights to a group.

5.      Help should be very user friendly.

6.      UI should include good images and have a constant look and feel throughout the application.





Requirements


Hardware requirements

Number
Description
Alternatives (If available)
1
PC with 5 GB hard-disk and 512 MB RAM

Not-Applicable


Software requirements


Number
Description
Alternatives (If available)
1
Windows 95/98/XP with MS-office
Not Applicable
2

MS-SQL server/Oracle
MS-Access
3
Linux
Not Applicable


4


IIS for MS
Tomcat for java




     
      Manpower requirements

2 to 3 students can complete this in 4 û 6 months if they work fulltime on it.




Comments

Post a Comment

Popular posts from this blog

how make a good blog post!!

Most of us write blog for very many different reasons, but the sole purpose stands on the fact that we want to gain some attraction and popularity. The best way to do that is to be the best at what you do. The art of writing a famous blog is not an easy task, it takes time and patience, it is so because blogs are  one of the fastest-growing means of mass communication, they have gained a lot of attention since the 2000 and they are a now becoming a serious rival for traditional media like newspaper and other mass media. So here the few tips that I think will result in a good blog post if followed thoroughly: 1.      As the old saying goes “plan well before you do anything”, first  choose what type of blog you want to create. Have a rock solid idea about your main theme. The main success of the blog lies in the fact that you should consider your blog as an extension of yourself. Your blog identifies who you are. It exposes the person who you are on ...
30 comments
Read more

Next Generation E Paper Technology.

E-paper technology is designed in such a way to mimic the appearance of ordinary paper.   E-paper consists of thin electronic display, unlike ordinary display it reflects sunlight that gives the readers a much more legible text to read.  Electrophoretic display: E-paper technology consists E-ink suspened  between two transpare nt electrode layers. E-ink capsules are made of titanium oxide which are optically reflecting, when voltage is applied some particles move to viewing side of the paper thus causing the reflection of light it appears white  If the particles move to the rear side of the display dark colored moves up front and hence it appears black,thus alternating the voltage a pixel is formed and hence the image.   Further different types of colors can be obtained by placing suitable color filters color filters above the spheres Electrowetting: Electrowetting displays co...
8 comments
Read more

AMAZING FACTS ABOUT WARREN BUFFET: 3rd RICHEST MAN IN THE WORLD:-

1) Warren bought his first share at age 11 and he now regrets that he started too late! 2) He bought a small farm at age 14 with savings from delivering newspapers. 3) He still lives in the same small 3 bedroom house in mid-town Omaha, that he bought after he got married 50 years ago. He says that he has everything he needs in that house. His house does not have a wall or a fence. 4) He drives his own car everywhere and does not have a driver or security people around him. 5) He never travels by private jet, although he owns the world's largest private jet company. 6) His company, Berkshire Hathaway, owns 63 companies. He writes only one letter each year to the CEOs of these companies, giving them goals for the year. He never holds meetings or calls them on a regular basis. 7) Warren Buffet has given his CEO's only two rules. Rule number 1: Do not lose any of your share holder's money. Rule number 2: Do not forget rule number 1. 8) He does not socialize with the hig...
8 comments
Read more