CIS5200: System Analysis & Design Project for CPM Company

Desklib provides past papers and solved assignments. This project analyzes and redesigns CPM's sales system.

CIS5200: Professional Skills for Systems Analysis
Assignment-2
Student Name: Anurag Reddy Bondugula
Student ID: U1115751
Course:
Semester:

Abstract
This assignment aims at providing an overview and understanding of system analysis and design.
With the help of this assignment, we will be able to learn to design and analyze the system for a
company of choice. This assignment focuses on identifying and analyzing the issues and
challenges faced by the chosen company and design and implement the appropriate solutions for
the same. I have chosen a company named CPM is a sales and marketing-based company which
is situated in Australia. It is a part of CPM International Group. I have also included and
described the weaknesses and flow of process for CPM. It also includes solutions and
recommendations for the new system.
The purpose of the assignment is to be able to develop professional skills to design and analyze
the system. The completion of the assignment will result in the development of professional
skills in an individual and the ability to research the market to find out and develop better
solutions.
After the successful completion of this assignment, I will be able to acquire an overview of the
principles, techniques, and methods adopted and will gain some practical experience to build a
development project. The objective behind the report is to analyze system of CPM Company
which is a sales and marketing company. This system analysis helps the company to smoothly
and efficiently run their operations. This report includes the time management plan of the
analysis which is done using a Gantt chart. Also, it includes a comparison of existing AS-IS and
TO BE process diagram to show the improvement in the system, training and testing programs.
This report also suggests some recommendations to CEO of the company to improve the system.

Table of Contents
Abstract............................................................................................................................................2
Introduction......................................................................................................................................5
Task 1: Time Management Plan......................................................................................................6
Task 2: TO – BE process model....................................................................................................10
Task 3: Comparison between “AS IS” and “TO BE” Process......................................................11
Task 4: Entity Relationship Diagram (ERD).................................................................................12
Task 5: Data Normalization...........................................................................................................13
Task 6: Testing..............................................................................................................................15
Task 7: Training.............................................................................................................................17
Trainees and groups:..................................................................................................................17
Type of training:........................................................................................................................18
Task 8: System Changeover..........................................................................................................19
Task 9: Report to Top Management..............................................................................................20
References:....................................................................................................................................23

List of Figures
Figure 1: Work Breakdown Structure..............................................................................................6
Figure 2: Tabular representation of WBS........................................................................................7
Figure 3: Gantt chart for WBS.........................................................................................................8
Figure 4: TO BE process model......................................................................................................9
Figure 5: ERD for the system........................................................................................................11
List of Tables
Table 1: Comparison between AS IS and TO BE process............................................................10

Introduction
This assignment aims at providing an overview and understanding of system analysis and design.
This assignment emphasis on gaining information about system tools, analysis, techniques, and
methods. The assignment helps to understand the use of tools for project management and
developing and designing a system within the time limit. The company CPM has been selected
that a sales and marketing-based company which is situated in Australia. CPM is a part of CPM
International Group. In this document, solutions for the system has been designed and
implemented along with the process flow. It also includes identification of the issues.
The assignment consists of various tasks which help to develop a new solution for the company.
First task is to design a time management plan to which divided the assigned tasks and problems
into sub-tasks along with the given timelines for each task. In the second task, a “TO BE”
process diagram is designed which is helpful to illustrate the future state of BPM. In the third
task, the “TO BE” process is compared with the current “AS IS” process of the organization. In
task 4, an ERD for the business is created as per the solution provided. The ERD is designed in
its full 3 NF form in task 5.

Task 1: Time Management Plan
There are three main aspects of any project – time, scope, and budget. Out of the three main
aspects of project management, time management is the most important one. For the successful
completion of a project within the specified timeframe, it is very essential to design an efficient
and effective time management plan. As a business system analyst, a proper time management
plan has been planned and designed that would allow each and every task “TO BE” completed
within a sufficient amount of time so that the project can be completed before its deadline.
For a better time, management plan, Work Breakdown Structure (WBS) is developed that
defines the completion of every milestone on time. If each and every phase completes on its
defined timeframe, the whole project can be completed on time before the deadline.
A Work breakdown structure is a hierarchical structure that breaks down the larger complete
project into smaller modules. The smaller project modules are easily manageable and can be
completed within defined timeframe. To design the WBS for CPM, I have divided the complete
project into 7 modules including planning of project, background of organization, problems and
contests, planning of time management, research analysis, reporting, and final documentation
(Amato, et al. 2014).
This WBS serves the purpose to identify each task in your project and allow an estimated
duration to it.

Figure 1: Work Breakdown Structure

ID Task
Mode
Task Name Duration Start Finish Predecessors Actions Status
0 WBS for system analysis 28 days Tue 1/15/19 Thu 2/21/19 Late
1 Time management plan 3 days Tue 1/15/19 Thu 1/17/19 developed a WBS diagram using microsoft visio for identification of each taskLate
2 identification of all tasks and subtasks2 days Tue 1/15/19 Wed 1/16/19 Late
3 Developing WBS 1 day Thu 1/17/19 Thu 1/17/19 2 Future Task
4 To be process 1 day Fri 1/18/19 Fri 1/18/19 1 Developed a TO Be process diagram using Microsoft Visio by using BMPN and UMLFuture Task
5 identification of business process and dvelopment of To be process diagram1 day Fri 1/18/19 Fri 1/18/19 Future Task
6 Comaprision of AS-IS and TO BE process3 days Mon 1/21/19 Wed 1/23/19 4 Comparision with AS IS diagram of assignment 1Future Task
7 study of AS IS 1 day Mon 1/21/19 Mon 1/21/19 Future Task
8 Study of TO BE process 1 day Tue 1/22/19 Tue 1/22/19 7 Future Task
9 Performed comparision 1 day Wed 1/23/19 Wed 1/23/19 8 Future Task
10 ERD diagram 3 days Thu 1/24/19 Mon 1/28/19 6 develop an entity relationship diagram with the help of microsoft visioFuture Task
11 study the entities of the company1 day Thu 1/24/19 Thu 1/24/19 Future Task
12 study the realationship between entities1 day Fri 1/25/19 Fri 1/25/19 11 Future Task
13 developed an ERD diagram 1 day Mon 1/28/19 Mon 1/28/19 12 Future Task
14 Data normalization 2 days Tue 1/29/19 Wed 1/30/19 10 created fully designed 3NF table designs Future Task
15 identification of the dependencies1 day Tue 1/29/19 Tue 1/29/19 13 Future Task
16 removal of the dependencies and redundancy1 day Wed 1/30/19 Wed 1/30/19 15 Future Task
17 Testing 3 days Thu 1/31/19 Mon 2/4/19 14 determination type of testing and test data Future Task
18 Determination of type of test data1 day Thu 1/31/19 Thu 1/31/19 Future Task
19 determination of type of testing2 days Fri 2/1/19 Mon 2/4/19 18 Future Task
20 Training 3 days Tue 2/5/19 Thu 2/7/19 17 Future Task
21 identification of Trainees and groups1 day Tue 2/5/19 Tue 2/5/19 Future Task
22 listing of training topics 1 day Wed 2/6/19 Wed 2/6/19 21 Future Task
23 determination of type of training1 day Thu 2/7/19 Thu 2/7/19 22 Future Task
24 System changeover 4 days Fri 2/8/19 Wed 2/13/19 20 Future Task
25 identification and analysis of required changes in the system1 day Fri 2/8/19 Fri 2/8/19 Future Task
26 development of a system changeover plan2 days Mon 2/11/19 Tue 2/12/19 25 Future Task
27 determination of methods 1 day Wed 2/13/19 Wed 2/13/19 26 Future Task
28 Report to top management 2 days Thu 2/14/19 Fri 2/15/19 24 preparatin of a report which consist of processes, scope and objectivesFuture Task
29 list of processes involved in the project1 day Thu 2/14/19 Thu 2/14/19 Future Task
30 identification of scope and objective1 day Fri 2/15/19 Fri 2/15/19 29 Future Task
31 presentation and report structure2 days Mon 2/18/19 Tue 2/19/19 28 add cover page, review the report to check clarity and professionlismFuture Task
32 review the instructions 1 day Mon 2/18/19 Mon 2/18/19 Future Task
33 add cover page 1 day Tue 2/19/19 Tue 2/19/19 32 Future Task
34 finalizing the documentation 2 days Wed 2/20/19 Thu 2/21/19 31 add references, citation and review finally Future Task
35 analysis of reference style 1 day Wed 2/20/19 Wed 2/20/19 Future Task
36 add references and review finally1 day Thu 2/21/19 Thu 2/21/19 35 Future Task
Figure 2: Tabular representation of WBS

ID Task
Mode
Task Name Duration Start Finish
0 WBS for system analysis28 days Tue 1/15/19Thu 2/21/19
1 1 Time management
plan
3 days Tue
1/15/19
Thu
1/17/19
2 1.1 identification of
all tasks and
subtasks
2 days Tue
1/15/19
Wed
1/16/19
3 1.2 Developing WBS1 day Thu 1/17/19Thu 1/17/19
4 2 To be process 1 day Fri 1/18/19 Fri 1/18/19
5 2.1 identification of
business process
and dvelopment of
To be process
1 day Fri 1/18/19 Fri 1/18/19
6 3 Comaprision of
AS-IS and TO BE
process
3 days Mon
1/21/19
Wed
1/23/19
7 3.1 study of AS IS 1 day Mon 1/21/19Mon 1/21/19
8 3.2 Study of TO BE process1 day Tue 1/22/19Tue 1/22/19
9 3.3 Performed comparision1 day Wed 1/23/19Wed 1/23/19
10 4 ERD diagram 3 days Thu
1/24/19
Mon
1/28/19
11 4.1 study the
entities of the
company
1 day Thu
1/24/19
Thu
1/24/19
12 4.2 study the
realationship
between entities
1 day Fri 1/25/19 Fri 1/25/19
13 4.3 developed an ERD diagram1 day Mon 1/28/19Mon 1/28/19
14 5 Data normalization 2 days Tue
1/29/19
Wed
1/30/19
15 5.1 identification of
the dependencies
1 day Tue
1/29/19
Tue
1/29/19
16 5.2 removal of the
dependencies and
redundancy
1 day Wed
1/30/19
Wed
1/30/19
17 6 Testing 3 days Thu
1/31/19
Mon
2/4/19
18 6.1 Determination
of type of test data
1 day Thu
1/31/19
Thu
1/31/19
19 6.2 determination
of type of testing
2 days Fri 2/1/19 Mon
2/4/19
20 7 Training 3 days Tue 2/5/19 Thu 2/7/19
21 7.1 identification of
Trainees and
groups
1 day Tue 2/5/19 Tue 2/5/19
22 7.2 listing of training topics1 day Wed 2/6/19Wed 2/6/19
23 7.3 determination
of type of training
1 day Thu 2/7/19 Thu 2/7/19
24 8 System changeover 4 days Fri 2/8/19 Wed 2/13/19
25 8.1 identification
and analysis of
required changes
in the system
1 day Fri 2/8/19 Fri 2/8/19
26 8.2 development of
a system
changeover plan
2 days Mon
2/11/19
Tue
2/12/19
27 8.3 determination of methods1 day Wed 2/13/19Wed 2/13/19
28 9 Report to top
management
2 days Thu
2/14/19
Fri 2/15/19
29 9.1 list of processes
involved in the
project
1 day Thu
2/14/19
Thu
2/14/19
30 9.2 identification of
scope and
objective
1 day Fri 2/15/19 Fri 2/15/19
31 10 presentation and
report structure
2 days Mon
2/18/19
Tue
2/19/19
32 10.1 review the instructions1 day Mon 2/18/19Mon 2/18/19
33 10.2 add cover page1 day Tue 2/19/19Tue 2/19/19
34 11 finalizing the
documentation
2 days Wed
2/20/19
Thu
2/21/19
35 11.1 analysis of reference style1 day Wed 2/20/19Wed 2/20/19
36 11.2 add
references and
review finally
1 day Thu
2/21/19
Thu
2/21/19
31 3 6 9 12 15 18 21 24 27 30 2 5 8 11 14 17 20 23
December 2018 January 2019 February 2019
Figure 3: Gantt chart for WBS

Task 2: TO – BE process model
The “TO BE” process model of a project is designed to display the future state of the business
keeping in mind the ‘As-Is’ process of the current business. The “TO BE” process involves the
enhancements “TO BE” made so as to improve the business process of the company in the
future. The “TO BE” model designed is supposed to improve the CPM Company’s sales and
marketing process.
Figure 4: TO BE process model

Task 3: Comparison between “AS IS” and “TO BE” Process
To compare both “TO BE” and “AS IS” process of CPM, we will refer “AS IS” process
mentioned in assignment 1.
The “TO BE” process is far much better than the current “AS IS” process of the CPM business.
Even though the current “AS IS” process model includes the local area marketing, campaigns,
sponsorship programs, etc. the main issue or challenge faced by CPM lies in local area
marketing.
To solve the challenges faced in local area marketing, the “TO BE” process introduces the
segmentation of the marketing strategies. The marketing strategies may include roadshows,
maximizing customer interactions, advertisements, social sharing, and gatherings, etc.
To maximize the reach to customers and introduce the products and services offered, the
company should take advantages of this technological world. They shall consider promoting
their products and services on social media platforms, and through online advertisements. CPM
shall design and develop a website that offers a rich user interaction and the business models and
services of the company (Sharon & Dori 2015).
Table 1: Comparison between AS IS and TO BE process
AS-IS Process TO-BE Process
The current working business process state. Future business process state model.
Less efficient and effective process. More efficient and effective to maximize
business growth.
Challenges are faced during local area
marketing.
Challenges are resolved in the new process.
Common, less effective marketing strategies
like roadshows, campaigns, etc.
New strategies like online advertisements,
social sharing & gatherings, social media, etc
along with the old strategies

Task 4: Entity Relationship Diagram (ERD)
The below Entity Relationship Diagram (ERD) depicts the relationship between each and every
entity involved in the CPM business.
Figure 5: ERD for the system