Design and Implementation of Customer Relationship Management

Design and Implementation of Customer Relationship Management

Project / Seminar Material
Reference ID: PS-4985-TM

DEDICATION

This research material titled “Design and Implementation of Customer Relationship Management” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Implementation of Customer Relationship Management” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION


    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.7.1 System Testing
    • 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”


    Design and Implementation of Customer Relationship Management

    CHAPTER ONE


    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.

    CHAPTER TWO

    2.0 Literature Review

    2.1 Introduction

    This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

    Summary Headlines for Design and Implementation of Customer Relationship Management