Software Implementation of Customer Relationship Management

PRELIMINARY PAGES

• Title page
• Approval page
• Dedication
• Acknowledgement
• Table of Contents
• Abstract

CHAPTER ONE

INTRODUCTION

• 1.1 Background …
• …

CHAPTER TWO

LITERATURE REVIEW

• 2.1 Introduction
• …

CHAPTER THREE

SYSTEM ANALYSIS AND DESIGN

• 3.1 Methodology Adopted
• 3.1.1 Problem Identification Using SSADM
• 3.2 Analysis of the Existing System
• 3.2.1 Dataflow of the Existing System
• 3.2.2 Disadvantages Of The Existing System
• 3.2.3 Weakness of the existing System
• 3.3 Feasibility Study
• 3.3.1 Economic Feasibility
• 3.3.2 Technical Feasibility
• 3.3.3 Operational Feasibility
• 3.4 Analysis of the Proposed System
• 3.4.1 Data Flow Diagram of the Proposed System
• 3.4.2 Advantages of the Proposed System
• 3.4.3 Justification of the Proposed System
• 3.5 Functional Requirements
• 3.5.1 Use Case Diagram Of The Admin / User Privileges
• 3.6 Data Requirements
• 3.7 High Level Model of the Proposed System

CHAPTER FOUR

SYSTEM DESIGN AND IMPLEMENTATION

• 4.1 Objectives of the Design
• 4.2 Cohesion and Decomposition High level Model
• 4.3 Control Center / Overall Dataflow Diagram
• 4.3.1 Proposed System Operation Flowchart
• 4.4 System Specification and Design
• 4.4.1 Input and Output Specification
• 4.4.2 Database Specification and Design
• 4.4.3 Data Dictionary
• 4.5 Choice and Justification of Programming Language
• 4.6 Program Documentation
• 4.7 Implementation Techniques
• 4.8 Programming Module Specification
• 4.8.1 Installation
• 4.9 Computer Hardware Minimum Requirement
• 4.10 Software Requirement
• 4.11 Personnel / User Training
• 4.12 File Maintenance Module

CHAPTER FIVE

SUMMARY, CONCLUSION AND RECOMMENDATION

• 5.1 Introduction
• 5.2 Summary
• 5.3 Conclusion
• 5.4 Recommendation

References

Appendix A - Source Code

Appendix B - Object Program

Introduction

1.1 Background Of Study

Customer relationship management (CRM) is a term that refers to practices, strategies and technologies that companies use to manage and analyze customer interactions and data throughout the customer lifestyle, with the goal of improving business relationships with customers, assisting in customer retention and driving sales growth, (Raghu Ramakridhnan, 2005).

CRM designed to compiled information on customers across different channels or points of contact between the customer and the company, which could include the company’s website, telephone, live chat, marketing material, direct mail and social media. CRM systems can also give customer-facing staff detailed information on customers’ personal information, purchase history, buying preferences and concerns.

If a sales person wants to know about what issues are outstanding with customer service for a particular customer, then they have to make contact with the holders of that information and wait for a response. If the salesperson is chasing the customer, then the customer also has to wait. So, although many companies are information rich, the information is compartmentalized. It is not corporate knowledge and the ability to access information and to deliver it rapidly to customers is low − High quality customer service is compromised.

CRM enables companies to make the move towards being a customer centered organization by putting the customer at the centre of all the information that relates to them and allowing authorized people with the organization to access the information.

In a customer centered organization, sales people would have access to all information that affects their relationship with their customer. The conversations, the emails, the complaints, the complaint resolutions, all the information that has been sent to the customer, who else in the company had spoken to everything that affects their ability to service the customer and sell more product or service to them, (Lucy P. Roberts, 2004 − 2005).

CRM software consolidates customer information and documents into a single CRM database so business users can more easily access and manage it. The other main functions of this software include recording various customer interactions (over email, phone calls, social media or other channels depending on system capabilities) automating various workflow processes such as task, calendars and alerts, and giving managers the ability to track performance and productivity based on information logged within the system. Customers of a customer centered organization feel more valued. Their requests are dealt with more rapidly and accurately because all the information required to service the request is in one place. Customer centered organizations may have a higher customer retention rates than competitors organized along traditional lines because of this.

1.2 Statement Of Problem

Customer Data Management (CDM) is a solution mechanism in which an organization’s customer data is collected, managed and analyzed. CDM is geared toward resolving customer requirements and issues while enhancing customer retention and satisfaction, allowing an organization to convert customer data into Customer Intelligence (CI). Businesses need a thorough understanding of their customers’ needs if they are to retain and increase their customer base. There are problem faced by some companies like Nigeria port authority (NPA) that uses files and store information in cabinet. NPA also uses oracle database which also have the disadvantages like

Cost

The Oracle product can cost 9-10x as much as a comparable SQL server database solution for a mid-range solution. CRM final cost compared to the retail price for one license of Oracle Enterprise Edition (N14250000) retail though nobody pays full retail price.

Complexity

You don’t just “install Oracle” and be done with it. It is an incredibly complex engine and usually requires specialized skills to install and maintain. For example, for a device that needs an embedded database to store sensor data, the main disadvantage would be that Oracle requires a certain amount of resources that is usually not available in small devices. For a small company or non-profit organization the main disadvantage could be the price, since Oracle license is very expensive.

Depending on the human resources available, one disadvantage could be the level of knowledge/experience needed for someone to administer it correctly. (Hobby, J., 1999)

1.3 Aims And Objectives Of The Study

The objectives which the research work aims to achieve are as follows:

1. To design a user − friendly information system
2. To improve the transparency in the company
3. To ensure the proper filling information system
4. To reduce the time spent on arranging and keeping information
5. Enhance Your Sales and Support Teams
6. Expand Your Customer Base
7. Improve Customer Satisfaction
8. Improve The Efficiency Of Your Business

1.4 Scope Of The Study

This study answer subsequent design of the computer software is limited to Nigeria Port Authority (NPA) which includes:

Details of customers, customers complaint log.

This project proffers solution to the problem generated by the existing management system.

1.5 Research Questions

This work looks to provide answers to the following questions.

1. Does customer relationship management system enhance sales and services for companies?
2. To what extent would the customer relationship management system enhance a company service and credibility?

1.6. Research Hypothesis

The following hypotheses are drawn out of the research questions above.

1. Customer relationship management enhance safe keeping of customer
2. Adoption of the CRM system will greatly enhance company sales and service.
3. The growth of business by leveraging existing relationships, using information available to improve the customer relationship, the use of information to create and enable repetitive sales and support processes.

1.7 Limitation Of Study

While carrying out this project, some problems where encountered. They include;

1. Lack of financial assistance
2. Insufficient educational resources

1.8 Significance Of The Study

This project will help to promote sales and service to make the move towards being a customer centered organization by putting the customer at the centre of all the information that relates to them and allowing authorized people within the organization to access the information

1. Effective method of completing or filling of forms
2. Effective method of getting customer information

1.9 Definition Of Terms

Analysis:

Breaking a problem into successfully manageable parts for individual study.

Data Flow Diagram:

A diagram that shows the movement of data in a system from a point of origin to a specific destination indicated by a line and arrow.

Allocation System:

This is a set of methodology of assigning information and comment to a customer

System:

Regulatory orderly arrangement of components in a connected series.

System Design:

A plan for the structure and functions of an artifact.

Client:

A program that submit request to the server.

Data:

These are facts and figures sent into the computer for processing

Database:

A collection of persistent data that can be shared and interrupted.

Information:

Processed data or result (output).

Http:

Hyper transfer protocol, the protocols used to send and receive web pages over the internet using scandalized request and response messages.

Web Browser:

The tool (program) that allows the surfing of the web its used to locate web pages (e.g) Microsoft Internet explorer, Mozilla Firefox, Google Chrome,

CRM:

Customer relationship management

Customer data management (CDM):

Is a solution mechanism in which an organization’s customer data is collected, managed and analyzed.

Account Details - For USSD / POS Transfer

Account Name: Sparklyn Services Account No: 1222599051 Account Type: Current Bank Name: Zenith Bank PLC

Proposal Writing Format under Computer Science

Design and Implementation of Customer Relationship Management is a proposal topic for final year research work, which comprises the major and elective project proposal writing sections for Design and Implementation of Customer Relationship Management research work.

Major Sections

• Motivation for Embarking on the Project

• Brief Background of Study

• Statement of Problems

• Aim of the Study

• Specific Objectives of the Study

• Significance of the Study (Who benefits from the project and how?)

Elective Sections

• Methodology and Reason for Using It (such as; models, SSADM, or OOADM)

• Tools (programming languages and software used)