Monday, December 8, 2008

Case1 A systems Analysis and Design Project at Pine Valley Furniture

Case Background

Juanita Lopez, head of the manufacturing support unit of the Purchasing Department at Pine Valley Furniture Company (PVF) is concern about the growing backlog and quality of work in her department as PVF expands. The purchasing Department manages all interactions between external suppliers and internal PVF departments. These interactions include the following simultaneous processes.

· Identifying and selecting approved vendors for different materials and supplies

· Negotiating prices, order quantities, and other terms with suppliers

· Placing and tracking orders

· Monitoring the quality of materials received

· Working with vendors to identify defects and improve quality to meet PVF standards

· Working with PVF departments in helping choose a vendor when materials are required.

· Working with PVF departments to determine acceptable inventory levels and order lead times to ensure uninterrupted operations.

Juanita is concern about delays in placing vendor orders, inefficiencies in determining the status of vendors orders, and late management summary reports. Furthermore, relationships with vendors are becoming more critical as just-in-time inventory control methods are implemented by PVF manufacturing operations. As Juanita has been charged with solving these issues without adding office staff, she is hoping that new automation can help. A systems analysts for each business unit (like purchasing) works as a liaison between that unit and the IS development group. Juanita calls Cris, the systems analyst assigned to purchasing, to discuss her concerns.

Chris has been with the PVF for six years. He joined PVF right after graduating from baccalaureate program in the Computer Information Systems program in the business school of Valley State University. His first job was a Programmer/Analyst I, in which he coded and maintained financial application systems written in COBOL.

As Chris become more experienced in his job, he was asked to take additional program design work and was soon promoted to Programmer/Analyst II. He assumed somesupervisory responsibilities on projects and gained more authority in structuring programs, in choosing methods to access databases, and even in recommending functional changes to systems in order to take advantage of technology.

Eventually, the growth in systems work at PVF necessitate the expansion of the information systems development unit, and Chris was promoted to a Junior Systems Analyst position in the group supporting manufacturing operations. In this assignment, Chris participated on the team that developed a five-year plan that would enable information systems to support manufacturing at PVF. This plan considered all aspects of manufacturing and its interactions with other parts of the business, such as marketing, accounting, and purchasing. Chris also worked on one initial projects gathered from this plan which dealt with product structure (or bill-of-materials) data. As part of this project, Chris was responsible for designing files and databases to maintain this data. Since some product data (primarily physical characteristics) depended on vendor specifications, he had to analyze relevant Purchasing computer files to obtain data descriptions. As a result, at the time of Juanita’s call, Chris was already aware of some of the pressure on Purchasing caused by the growth and change in manufacturing operations and had a basic understanding of Purchasing systems at PVF.

IDENTIFYING THE PROJECT:

Juanita’s career has also progressed rapidly. Her work has been rated very highly and she is well respected. Juanita has never worked on a systems development project, however, and her education at a small liberal arts college did not include any exposure to information systems. Although Juanita knows the operations of her department very well and has fairly clear idea of some problems as well as opportunities for improvement, she does not know how to translate these into precise requests for help from systems development. The IS development group is highly regarded and Juanita believes her open management style and Chris’ expertise can complement each other in working together.

At their first meeting, Chris explains that his role at this point is to help Juanita state what her business problem is and to suggest how support from any new or improved information systems could solve her problem. In fact, one of their early joint responsibilities is to develop a brief justification for their proposal. Chris points out that, due to the huge demand for new and improved systems at PVF, not all requests can be accommodated. Further, PVF has instituted a charge-out, transfer pricing, scheme whereby business units requiring systems development have to pay for the work done by the system development unit. Thus, Juanita has received approval from her boss to fund any work performed by Chris’ unit.

Chris outline the process he and Juanita will have to follow. He explains that several years ago PVF had instituted a structured systems development methodology (SDM). He gives Juanita a copy of a chart summarizing the various steps that have to be followed for projects managed by the IS Unit. Using this methodology means that all project requests, proposal, and development efforts follow a common and well-defined process. This methodology also specifies how a systems project will managed and how progress will be measured, the role of different people involved on the project team, the deliverables due to each steps, the tools and techniques used during each step, and the form and content of a project dictionary or repository to document the project. This is common development methodology – the PVF Systems Development Methodology (SDM) – allows for

· Consistent management of projects

· Easier estimation of project times and cost

· Higher quality of work since people have been trained in the specifics of the methodology

· A more understandable process for both Chris and Juanita

·

=====================================================================================

PVF Systems Development Methodology (SDM) – Overview

1. Product Identification and Selection

1.1. Systems Service Request Evaluation

1.1.1. Develop SSR

1.1.2. Analyze SSR by Systems Priority Board

1.1.3. Assign SSR Disposition

1.1.4. Allocate resources for Project Initiation and Planning phase

1.2 Established project management procedures and modifications to SDM

2. Project Initiation and Planning Phase

2.1. Develop Project Plan

2.1.1. Develop overview of user requirements

2.1.2. Analyze stakeholders and risks

2.1.3. Construct work plan.

2.1.4. Describe resource requirements for Analysis phase

2.2. Develop business case

2.3. Review Project Initiation and Planning Phase*

3. Analysis Phase

3.1. Determine requirements

3.2. Structure requirements

3.3. Select system direction

3.4. Refine business requirements

3.5. Update project plan.

3.6. Review Analysis Phase*

3.6.1. Review work done to date

3.6.2. Review updated business case

3.6.3. Allocate resources for Logical Design Phase

4. Logical Design Phase

4.1. Document information Flows

4.2. Document data requirements

4.3. Document processing logic

4.4. Document user interfaces

4.5. Refine business case

4.6. Update project plan

4.7. Review Logical Design Phase*

4.7.1. Review work done to date

5. Physical Design Phase

5.1. Select technology

5.2. Design database and files

5.3. Design programs

5.4. Develop test plan

5.5. Plan installation

5.6. Refine business case

5.7. Update project plan

5.8. Review Physical Design Phase*

5.8.1. Review work done to date

5.8.2. Allocate resources for Implementation Phase

6. Implementation Phase

6.1. Programming

6.2. Testing

6.3. Education

6.4. Documentation

6.5. Installation

6.6. User acceptance testing

6.7. Final installation

6.8. Project Termination

6.8.1. Evaluate personnel

6.8.2. Review project with management

6.8.3. Release personnel

7. Maintenance

7.1. Annual system review

7.2. System audits

7.3. Submit Systems Requests for systems changes

The first is to develop a System Service Request (SSR). An SSR briefly states the business problem or opportunity and presents general ideas on how an information system could deal with the problem or opportunity.

PVF has a standard SSR form, which Juanita and Christ need to complete together. Juanita and Chris will then submit this form to the Systems Priority Board, a diverse group of business and systems managers representing a cross section of some cases, the board suggests that the end users making the request attempt to develop their own systems using user-friendly tools such as electronic spreadsheet package or simple database management system. The board also rejects some requests. In most cases, however, the Board assigns a priority to the request and places it in a backlog of such requests in decreasing order or priority. Although this is a very formal process, the systems development group tries to make it painless as possible for the requesting end-user through the help of some from the liason staff, like Chris.

Over two-week period Chris and Juanita meet and talk on the telephone several times as they put together the SSR. The SDM calls for only a cursory analysis of Juanita’s situation for the SSR. The idea is to lay out the scope and basic issues involved, not to thoroughly evaluate the situation. Later steps in the methodology refines the analysis. Chris explains to Juanita that one o the basic premises of the methodology is incremental commitment. Using incremental commitment, there are many review points during a project, each successively dealing with the information system request in greater depth. The goal is not to sink significant resources into a project until the work is reviewed and the organization is willing to commit further resources to the project. In this way, incremental commitment allows projects to be easily redirected or killed.

Below shows the System Service Request Chris and Juanita develop. As you can see, the request briefly describe the situation in Purchasing. Juanita shows this SSR to her boss, Sal Divario, who signs the form. Sals signature does not commit him to funding the project, only to support the request being sent to the board. Chris then submit this form to the systems priority board for their decision.

Pines Valley Furniture

Systems Service Request

REQUEST BY: Juanita Lopez DATE: November 1, 1994

DEPARTMENT: Purchasing Manufacturing Support

LOCATION: Headquarters, 1-322

CONTACT: Tel: 4-3267 FAX: 4-3270 email: jlopez@yahoo.com

TYPE OF REQUEST: URGENCY

[ x] New System [ ] Immediate – Operations are impaired or opportunity lost

[ ] System Enhancement [ ] Problems exist, but can be worked around

[ ] System Error Correction [ ] Business losses can be tolerated until new system installed

PROBLEM STATEMENT

Sales growth at PVF has caused greater volume of work for the manufacturing support unit within Purchasing. Further, more concentration on customer service has reduced manufacturing lead times, which put more pressure on purchasing activities. In addition, cost-cutting measures force Purchasing to be more aggressive in negotiating terms with vendors, improving delivery times, and lowering our investments in inventory. The current modest systems support for manufacturingpurchasing is not responsive to these new business conditions. Data are not available, information cannot be summarized, supplier orders cannot be adequately tracked, and commodity buying is not well supported. PVF is spending too much on raw materials and not being responsive to manufacturing needs.

SERVICE REQUEST

I request a thorough analysis of our current operations with the intent to design and build a completely new information system. This sytem should handle all purchasing transactions, support display and reporting of critical purchasing data, and assist purchasing agents in commodity buying.

IS LIASON: Chris Martin (Tel: 4-6204 FAX: 4-6200 email: cmartin@yahoo.com)

SPONSOR: Sal Divario, Director, Purchasing

--------------------------------- TO BE COMPLETED BY SYSTEMS PRIORITY BOARD ---------------------------

[ ] Request approved assigned to _____________________________

[ ] Start date _____________________________

[ ] Recommend revision

[ ] Suggest user development

[ ] Reject for reason _______________________________________

_______________________________________

_______________________________________

Tuesday, November 25, 2008

Report Topics

1. LAN and WAN
2. WI-FI & WI-MAX
3. LinkSys Technology (Wireless)
4. Biometrics
5. Portable Storage Devices
6. Types of Printers for Business (Brands)
7. Output Devices for Business
8. VPN
9. Microsoft Licensing & BSA
10. Relational Databases (sample)
11. Popular Operating Systems
12. Popular Programming Languages
13. Open Source
14. N-Series Technology/ Extenda
15. Inhouse vs Outsource Technologies
16. Brief Features of an Inventory System
17. Brief Features of an HRIS System
18. Brief Features of an Accounting/Financial System
19. Popular Virus Scanners and its Features
20. DSL technologies
21. SAP Enterprise
22. Navision Enterprise
23. ACCPACC Enterprise
24. QuickBooks
25. What is an Island of information?
26. Laptops
27. Personal Computers (PC's)/Desktop
28. File Servers
29. Search Engines
30. Internet
31. Intranet
32. Teleconferencing
33. Email Server
34. Access Rights
35. IP Address
36. File Formats
37. Data Warehousing

Format:
Definition of Terms
Business Impact
Cost
etc.

Monday, November 24, 2008

Handout-SAD001

Systems Analysis & Design SAD 001

SYSTEMS is an interrelated set of components that function together to achieve an outcome.Components: INPUT PROCESS OUTPUT
ELEMENTS OF THE SYSTEM:
1.Purpose – the reason it exists or the reference point for measuring its success.
2.Subsystems – parts or elements which perform specified tasks that are compatible with the goals of the larger system of which these are parts.
3.Environment – the people, facilities, rules, policies, and the regulations that surround a system.
4.Boundary – the perimeter or line of demarcation, between a systems and the environment.
5.Connections – transmit the flow of material and information that coordinate the systems components.
6.Control Mechanism – rules and logic that govern the individual subsystems and the interactions among them.
Ø Computer System – Terminal + Computer + File
Ø Business System – Policies + Procedures + methods + machines +etc. to achieve a goal
Ø Information System – Collect + Process + Store + Output the needed information to complete a business task.
Components of Information Systems include:a. Work Practice – methods and procedures used by people to perform work.b. Information – can include formatted data, text, images, and soundsc. People – persons, who enter, process, and use data.d. Information Technology – includes hardware and software that perform one or more data processing tasks.
Below are the reasons for the need of an information system:1.Growing size of the organization and the number of competitors2.Growing ability of computers to process large amount of data with great speed.3.Dramatic increase in volumes of data generated.4.Advances in communication technologies to permit faster data transmission.5.Increase in pace of business transactions6.Much more sophisticated technology today

TYPES OF INFORMATIONS SYSTEMS

1. Transaction Processing Systems
Gather all the input necessary for other types of information systems.
ex. Sales Orders from customers
Bank deposits & Withdrawals
2. Management Information System (MIS)
Designed to take the relative raw data available through the TPS and convert them into summarized and aggregated form for managers, usually in report format.
* Summary Report, Exception Report, On-Demand Report, and ad-hoc report)

3. Decisions Support Systems (DSS)
Instead of providing summaries of data, as with MIS, DSS provides an interactive environment in which decision makers can quickly data and models of business operations. DSS depend on a database as a source of data.

4. Office Automation Systems (OAS)

Support general office works for handling and managing documents and facilitates communication.
* Word processing, spreadsheets, desktop publishing, electronic scheduling, and communication through voice mail, email, and video conferencing.


5. Expert Systems (ES)

Also called knowledge-based systems. Perform a task that would otherwise be performed by a human expert.
Some expert systems are designed to take the place of human expert, while others are designed to aid them.
ES are part of a general category of computer applications known as Artificial Intelligence.
* Systems that can diagnose human illness, make financial forecasts, schedule routes for delivery vehicles.

6. Executive Information Systems

Provide a generalized computing and communication environment to senior managers to support strategic decisions. These rely on the information generated by MIS and allow communication with external sources of information.

General Systems Principles

1. The more specialized a system is, the less able it is to adapt to different circumstances.
2. The more general-purpose a system is, the less optimized it is for any particular situation. But the more the system is optimized for a particular situation, the less adaptable it will be to new circumstances.
3. The larger the system is the more of its resources that must be devoted to its everyday maintenance.
4. Systems are always part of a larger systems, and they can always be partitioned into smaller systems.
5. Systems grow. This principle could not be true for all systems, but many of the systems with which we are familiar do grow, because we often fail to take it into account when we begin developing the system.

Players in the System Game
1. System Sponsors/owners – pay for the system to be built and operated and set the vision and priorities for the system. (view information in terms of costs and benefits)
2. System Users – are the people who actually use the systems on a regular basis to support the operation and management of the organization. They define the business requirements and expectations for the system. Systems users are also internal systems customers and they come from all levels of the organization.
3. Systems Designers – are technical specialist that translate the business requirements into feasible technical solutions. Thus they view an information system in terms of design blueprint to guide the construction of the final system.
4. Systems Builders – are technical specialists that built, test, and deliver the information system. Thus, they view an information system in terms of the actual working hardware and software to implement the system.
5. Systems Analyst – are people who determine the requirements that must be met by the information system.

Roles of the Systems Analyst
Serve as a facilitator or coach, bridging the communication gap that can naturally develop between the non-technical system owners and users and the technical systems designers and builders.

Primary Roles of the Systems Analyst
1. Systems Consultant – address specific information systems issues within a business.
2. Supporting Expert – serve as a resource for those who are managing the project (hardware & software and their uses)
3. Agent of Change – agent of change whenever they perform any activities in the SDLC and are present in the business for an extended period. Advocates a particular avenue of change involving the use of information systems.

Required Knowledge & SkillsTECHNICAL
a. Computers and how they work
b. Devices that interact with computers, including input devices, storage devices, and output devices.
c. Communication networks that connect computers.
d. Databases and database management systems.
e. Programming Languages
f. Operating Systems and Utilities
g. Software Packages such as Microsoft Access that can be used to develop systems.
h. Integrated development environment (IDEs) for specific programming languages.
i. Computer-Aided systems engineering (CASE) tools that store information about system specifications created by analysts and sometimes generated program code.
j. Program code generators, testing tools, configuration management tools, software library management tools, documentation support tools, project management tools, and others

Required Knowledge & SkillsBUSINESS
a. What the specific organization does?
b. What makes it successful?
c. What is the strategies and plans are?
d. What its tradition and values are?

Required Knowledge & SkillsPEOPLE

Understand How People:
a. Think
b. Learn
c. React to change
d. Communicate
e. Work (in a variety of jobs and levels)