Call Center PRESENTATION

1
CALLCENTER MANAGEMENT
WELCOME
TO
FUTURISTIC SYSTEM
2

• PRESENTED BY-

• Bhabani Sankar Barik

GUIDED BY- Ms. ALAKA NANDA MOHANTY
3
CONTENTS

• ABOUT FUTURISTIC SYSTEM

• PURPOSE OF PROJECT
• HARDWARE SOFTWARE REQUIREMENT

• USER INTERFACE

• DATABASE DESIGNING

• CONCLUSION

4
ABOUT FUTURISTIC SYSTEM

• Established in 2004.
• Devoted towards Customer Satisfaction.
• Its yearly turnover jumped from
  20,000 in the 1st Year To 6 million in 2nd
  Year

5
PURPOSE OF PROJECT
Futuristic System maintains a manual system to
manage its departments and operations. When an
employee is inducted in Futuristic System, the
Payroll department maintains the employee
details. The employee details, salary
calculation, loan calculation, call register and
client feedback have also to be maintained. It
is very difficult to maintain all these records
manually. So, Futuristic System needs to be
computerized. We have been assigned the task to
create a project which will over come the problem
of maintaining all the information manually.
6
Hardware and Software Requirement

• Minimum Hardware Requirements-
• Intel Pentium IV Processor or higher
• 512 MB RAM or higher
• 18 MB Hard disk space
• Monitor with 800 600 Resolution
• Operating System Requirements-
• Microsoft Windows 2000 Professional Or
• Microsoft Windows XP Professional Or
• Microsoft Windows Vista
• Software Requirements-
• Microsoft Visual Studio 2005
• Microsoft .NET Framework
• Microsoft SQL Server 2005 or Higher

7
USER INTERFACE

• LOGIN

• WELCOME FORM

• HOME PAGE

• CALL DETAILS

• CALL REGISTER

• CUSTOMER HANDLING

• CLIENT FEEDBACK

• ADD EMPLOYEE

• TRAINING

• EMPLOYEE MANAGEMENT

• CHANGE PASSWORD

• SEARCH

8
USER INTERFACE
9
Different forms of our Project
Login form
Welcome form
Home page
Call details form
Call register form
Customer handling form
10
Different forms of our Project
Client feedback form
Add employee form
Training form
Employee management form
Change password form
Search page
11
1. LOGIN FORM
Group box
2 Radio buttons
2 Labels
2 Textboxes
Background image
2 Buttons
This form is used to enter into the project
providing the correct user name and password.
12
2. WELCOME PAGE
Label
Background image
2 Buttons
This is just a welcome form.
13
3. HOME PAGE
Menu strip
Background Image
This is the Futuristic Home
page. From this page, a user can switch to any
other form for further work.
14
4. CALL DETAILS
Combo Box
5 Text Boxes
8Labels
Rich text box
Background image
3 Buttons
This form is used to display the
details of an inbound call according to call id.
15
5. CALL REGISTER
Label
Tool strip combo box
Tool strip label
Tool strip button
Data grid view
Background image
3 buttons
This is the call register
form which displays the details of all the calls
those have been attended by different employees
according to employee id.
16
6. CUSTOMER HANDLING
2Tool strip combo box
2Tool strip labels
2Tool strip button
Data grid view
2Combo Boxes
5 Text Boxes
10 Labels
Background image
Rich text box
5 buttons
This form is used to save the details of an
inbound call and also displays the details of a
call according to contact number or call id.
17
7. CLIENT FEEDBACK
Tool strip combo box
Tool strip button
Data grid view
2 combo boxes
8 Labels
3 Text Boxes
Background image
4 buttons
This form is used to save,
update and view the clients feedback
18
8. ADD EMPLOYEE
numeric up down button
9 Labels
Rich text box
date time picker
Combo Box
3 Text Boxes
Background image
4 buttons
Using this form the details of a
new employee can be added.
19
9. TRAINING
Tool strip combo box
Tool strip button
Background image
2 Text Boxes
5 Labels
3 combo boxes
5 buttons
The details about the
training of an employee can be entered, viewed
and deleted using this form.
20
10. EMPLOYEE MANAGEMENT
Tool strip combo box
Tool strip label
Tool strip button
Data grid view
numeric up down button
Combo Box
10 Labels
7 Text boxes
2Radio button
Group box
3 buttons
This form is used to manage the employee details
and salary. The details of an employee can also
be viewed using a data grid view in this form.
21
11. CHANGE PASSWORD
Background image
combo box
4text boxes
5 Labels
3 buttons
The User name and password can be changed if
necessary using this form.
22
12. SEARCH FORM
Text box
2 Labels
combo box
Data grid view
Background image
3 buttons
The search form is used to search the details of
an employee either by his name or by his employee
id.
23
DATABASE DESIGN
24
ER Diagram of Futuristic Systems
FUTURISTIC SYSTEM
has
has
has
has
has
In-Bound Call
Employee
Log-In
has
has
Client Feedback
Training
25
Log-in Table
Log-In
User name
Password
The Log-in table stores the log-in Id and
password of the users.
26
Column Data Type (Length) Null able Constraint (Name) Reference Table(Column)
user_name varchar(20) No
password varchar(10) No
27
Employee details Table
employee_ details
empid
experience_in_years
empname
dateofjoin
age
designation
address
contact_number
gender
salary
The Employee table contains all the details of
the employee of Futuristic Systems
28
Column Data Type (Length) Null able Constraint (Name) Reference Table(Column)
empid varchar(4) primary key(pk)
empname varchar(30)
age int
Address varchar(50)
gender Varchar(6)
contact_number int
designation Varchar(20)
dateofjoin Varchar(30)
experience_in_years int
salary money
29
Inbound Call Table
Inbound Call
call_nature
contact_number
customer_id
callers_query
call_id
call_time
customer_name
empid
executive_name
The Inbound Call table contains all the
details of client of Futuristic Systems.
30
Column Data Type (Length) Null able Constraint (Name) Reference Table(Column)
call_nature varchar(20)
customer_id Varchar(5)
call_id Varchar(5) primary key(cid)
customer_name varchar(30)
executive_name Varchar(30)
empid Varchar(4) Foreign key(fk1) employee_details(empid)
call_time Varchar(30)
callers_query Varchar(50)
contact_number Varchar(15)
31
Client Feedback table
Client feedback
Employee_ID
Customer_Feedback
call_id
Customer_Query
Customer_Id
calltime
Customer_Contact_Number
This form is used to store the client feed back
on a call attended by a customer executive.
32
Column Data Type (Length) Null able Constraint (Name) Reference Table(Column)
Employee_ID varchar(4) primary key(pk)
call_id Varchar(4)
Customer_Id Varchar(5)
Customer_Contact_Number Varchar(15)
calltime Varchar(30)
Customer_Query Varchar(30)
Customer_Feedback Varchar(30)
33
Training table
Training
Module_id
Tutor_Name
Employee_name
Module_Name
Period_of_training
The Training table contains the detail of the
courses provided by the company to its employee.
34
Column Data Type (Length) Null able Constraint (Name) Reference Table(Column)
module_ID varchar(4) No
module_name Varchar(20) No
Tutor_name Varchar(30) No
Employee_name Varchar(30) No
Period_of_training Varchar(40) No
35
CONCLUSION
To conclude, we can say that in Call Center
Management, the successful development of Call
Center Management, needs highly computerized
management system, which is a significant
challenge for us in this modern era. This
requires the better knowledge of almost all
developed Call Center Management, but according
to our project we have implemented the simple
coding for developing the Call Center Management
project work . It make user to view update
data easily as per his requirement.

36