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

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

How Embracing AI Transformed My Everyday Life

I still remember the first time I spoke to a virtual assistant. It was a chilly morning, and I was running late for a meeting. Frustrated with my disorganized schedule, I hesitantly said, “Hey Siri, set a reminder for my 10 AM meeting.” To my surprise, it worked seamlessly. That simple interaction marked the beginning of a transformative journey with Artificial Intelligence (AI) that has profoundly changed how I live, work, and connect with others. For over three years, I’ve witnessed technology evolve at an unprecedented pace. Yet, nothing has impacted me as personally and profoundly as the integration of AI into my daily routine. I’d like to share how embracing AI not only streamlined my life but also helped me become better at what I do. A Personal Assistant in My Pocket Juggling a demanding career and personal life often left me feeling overwhelmed. Deadlines were missed, birthdays forgotten, and important emails buried in my inbox. But everything changed when I started using AI-po...
Post a Comment
Read more