The System Development Life Cycle

February 10th, 2010

The System Development Life Cycle

[1] Identification of problems:
The proposal to develop a the new information system started with a formal request resulting from the identification of existing problems identified in the current systems used in the mail order and wholesales business operations.

Using the scenario information which provides details of the current installation, the areas of the companies operations to be redefined can be categorized into one of three areas., The opportunities for introduction of Information systems and technology are in this case not the objective of the business process re-engineering, but are more a by-product. These are as follows:

Information is an organizational resource which must be managed as carefully as other resources. Costs are associated with information processing.

[2]Feasibility study:
The need for a new system is clearly defined in the problem identification stage of the process. As identified by the clients, many of the company’s systems that support the procedures have not been modified for many years. Others are regularly maintained. In order to improve productivity, it has been decided to re-engineer some of the core business processes. When two separate functions are performed by different people, the existence of two separate transaction processing computer systems, operated at two different terminals is not seen as a problem. In the proposed system one operative will be performing one new business function and obviously the one terminal and one computer system should support the new function.

[3] Information gathering on the proposed system:
For each application identified as a candidate for redesign, as identified during the problem definition stage, the process associated with each was investigated in detail to determine the advantages and disadvantages of its operation, its running cost, overall effectiveness, how the problems came about, and the detailed functional and technical system requirements necessary for the current system to achieve its results.

A detailed definition of the systems’ functional operations and the flow of information in relation it is passed between organisational functions as follows here in an example:

a} Customer places order:
The customer places an order at your site, using their payment method of choice. When a customer places an order or requests a catalogue, information associated with the transaction is collected. This information required in fulfilling the order or catalogue request includes the customer’s name, mailing address, products ordered, shipping addresses, and credit card information. The information is stored on our customer file in a completely secure environment.

b) Sales:
Customer orders received by a sales function are passed to an accounts function for processing and invoicing as well as to stores for despatch of goods.

c) Customer Order Processing:
This includes all the activities related to processing of customer orders and inventory control in an organization, under the current system an order-entry clerk would directly enter any order by way of a keyboard,.

Processing can streamline the order management cycle and improve customer service and satisfaction This function handles: Perform online credit check, maintain accurate records, advise customers of order status and item availability, direct dispatch of goods and issue invoices promptly. Sales Analysis and history features provide a valuable tool for management.

d) Invoicing:
This function is responsible for the production of customer invoices, requesting payment for goods or services delivered. Information generated by this function (about the customers and stock) is stored and is used to produce invoices, usually on pre-printed continuous stationery.

To charge the customer the accounting function requires the necessary sales information, which is supplied by the sales function.

e) Accounting:
Financial accounting is the process of documenting the financial transactions resulting from the activities of an organisation almost all of which generate materials of this nature. This function also acts as a control mechanism over the financial transactions of a business. Accounting records can than be analysed to provide information on the performance of a business over a period.

f) Payroll: Payroll systems are concerned with the production of payslip for employees and maintenance of records required for taxation and other deductions. In a manual system the preparation of payroll figures and the maintenance of payroll records is an intensive task. Although tedious and repetitive, it is a vitally important task.

g) Transaction Processing:
Easy entry of customer orders including copy of previous orders, partial shipping and billing and automatic release of back ordered items for shipping upon receipt

h) Query open orders:
Drill down to shipping information on line items, customer order history, including current, year-to-date, or all, customer, credit files, stock Files:

i) Returns Files:
Returned or damaged merchandise handling, return merchandise authorization credit note generation and automatically generated accounting entries.

j) Payments and receipts:
These may relate to sales orders or purchase orders. Receipts are amounts received from debtors. Payments are made by a business to settle debts with creditors (suppliers to the business).

[4] System analysis:
The current business systems are operating on fundamental principles developed in the foundation of the company. The restructuring of its procedures to enable centralised support operations and planning. Many of these are legacy systems for management of stock, order, returns and account files for keeping track of individual customer accounts, returned goods, and payments; it also needs to have information on stock levels transferred to a single relational database system.

The way in which commercial transactions are conducted will be directly effected be the fundamental change in the shift towards the importance of information exchange that is not intrinsically part of the current computer based applications to facilitate business processes, new systems to capture information on customers

[5] Design of the system:
The potential systems subsystems, functional and technical component parts must be reevaluated to determine how the system is to meet the requirements identified at the analysis phase. Coding (if required) the information system would take place then testing and debugging.

In this instance a prototype system should be run in a simulated operational environment with real staff but test data which would not affect the real operation of the old system still continuing, and would allow the system to be tested safely and adequately on the sample data as well as the people who will have to make it work in future.

[6] Implementation and evaluation:
Once the evaluation stage has been completed, all lessons learned should be incorporated, and a final evaluation made to check this has been carried out.

First installation and operation on real data of the new equipment and software to form the complete system should take place at a single non-mission critical site for further testing until all subsystems work as intended.

Staff training should have been happening throughout, to the extent that staff had been involved in the evaluation stages, but the training of the remainder can start at this stage using this non critical site as the ‘school’. The new information system should be run in parallel with the previous operations of the company until the new system is working effectively, to ensure that the operation can continue to function if the system runs into unforseen complications at this late stage.

Parallel implementation should be must effective in this situation as this is the safest option where both the old and the new systems operate simultaneously and the results of the old system are used as a benchmark; which can be compared against the results of the new system to determine the reliability and accuracy of the new system.

[7] Maintenance:
The performance of the new system should be monitored by the installation team for the first weeks of its operation to establish if there are any unforeseen failings in the design of operational procedures and whether it addresses all the original requirements. Before the installation team log off they should put in place the continuing monitoring systems to be operated by the company’s staff, and any necessary back – up / technical support service.

Formal updates to keep management and the operations staff involved must be conducted at each stage during the system design, development, test, and implementation phases.

Michael Hart care of The Wandle Industrial Museum(http://www.wandle.org) established in 1983 by local people determined to ensure that the history of the valley was no longer neglected but enhanced awareness its heritage for the use and benefits of the community.

Source: http://www.websition.com/

Validating your code and testing a web-page for a variety of displays

February 9th, 2010

Many web designers make the mistake of designing their documents for specific screen resolutions. When the document is displayed on a smaller resolution the page elements tend to jam together or break across unexpected lines.

Your documents should be suitable for many resolutions. Although most users will be running at resolutions of at least 800×600 pixels, your websites may have the occasional user running lower resolutions or too high resolution. Therefore, it`s advised and is an industry standard to always test your documents at various locations & colour depths to look for many shortcomings.

Validating your document`s code is another very good idea. It helps double check your document for simple errors – typos, unclosed tags & so on – and also verifies that your code meets expected standards.

There are many ways to validate your documents, but they all rely on your documents containing a correct document type definition (DTD) declaration. For example, if you want to base your documents on Strict HTML 4.01, you would include the DTD declaration at the top of your docuemnt within angular brackets.

The DOCTYPE declaration informs any user agent reading the document what standard the document is based on. The information is primarily used by validation clients in validating the code within the document, but it might also be used by a display agent to determine what features it must support. Some of the tools/resources where the code can be validated are:

1. The online W3C HTML validation tool

2. The online Web Design Group (WDG) validation tool

3. Validation utilities built in to Web development tools such as Adobe`s Dreamweaver.

4. Any of the various separate applications that can be run locally. A comprehensive list is maintained on the WDG site.

5. The online CSS validation tool

Many a times, the document may look like conforming to HTML but the validators think otherwise. Some of the points that should be kept in mind before the validation takes place are like that the [input] element must be contained within a block element other than the [form] tag. Typically, the paragraph tag [p] is used but you can also use [div], a heading, [pre] and so on.

Advantages of Website development by a Dedicated Web Developer

February 8th, 2010

The Internet has revolutionized the world of communication. It is an integral part of our everyday lives now. Nowadays Internet helps us to shop, organize and print our photos, to access all different kinds of information, and many, many other day to day activities. It has also made quite an impact in the business world. To find out information about any particular company, the first thing that people do nowadays is to logon to the web and visit the company’s website. They would then read up about the company, find locations of its offices, look up the phone number, and place orders for the things they need. Also, if they are looking for a particular product, they would search for it and check out the first 5-6 websites or maybe 10 websites which pop up in the results.

After they have found what they need, they will most likely look on that particular company’s website for directions to their store. And then drive to the location. Hence, this helps the business as it gets customers via the Internet too. Searching on the Internet and then visiting the store is in the customer’s interest as it saves their time. In fact, they will appreciate the efforts you took as a business to put the information on the web for your customers’ benefit. For any new business to prosper, it is imperative for it to have a presence on the Internet. If you do not have a website, you are missing out on potential customers.

In order to have a great looking and efficient website, it would be in your best interests to hire a web developer. Hiring a dedicated web developer would be even better. A dedicated web developer would work solely on your website. He/she will 1.Create it from scratch 2. Make it user friendly 3. Put all important information about your business in a concise manner 3. Make it attractive 4. Maintain it. Apart from these functions, a dedicated web developer would perform a lot of other things to create a great website for you or for your business.

When you obtain the website, it is important to market it as well. What good is it if you have the website but very few people visit it? You should then hire an SEO expert to make sure the website is search engine optimized. The dedicated web developer can later do this too, as most developers are SEO experts too.

If you have a shopping website, you need a Zen cart developer. Hire a Zen cart developer to utilize ready made template for easy updating of data. Zen Cart’s default installation provides everything required to maintain a shopping cart web site.

–Pankaj SNV

Thankful for Open Source

November 7th, 2008

Well, we are deep in a financial down-turn and no one is immune. As I look back over the last decade and view all the twists and turns in my I.T. shop with different technologies and software…I have no regrets about embracing open source today.

When I first started at my present job we used DOS 6.1, Windows 3.11, Novell 4.11, Lotus, Oracle 7.34 and SPX/IPX protocol. For those of you who know what I just said…quit laughing. The rest of you are lucky to have missed all this stuff. Although, I do still like Oracle for a database. I just would have NEVER ran it on Novell with SPX/IPX packets bouncing aimlessly around my hub based network. But, that was what I inherited.

Mid-way, we transitioned to Windows NT 4.0 and 2000, TCP/IP, Office 97, Switches, Exchange Server, Oracle on Solaris and started dabbling in Apache web servers, not seriously though. This was an improvement, in that, I did not need to restart my Novell Oracle server everyday…but the Exchange Server took it’s place on a weekly basis. Praying that the datastore was not corrupted each time. Oh yea, and the innumerable pockets of corporate data created by Access97 was always fun, too.

Today, our entire core is either Linux or Unix. We run our email on load balanced linux servers running Egroupware. Oracle is still on Solaris SPARC machines. Our network file systems, domain controllers, authentication services, DNS, DHCP and all other related network service are run on Linux. Our only Windows machines are our Citrix farm and the few desktops we have left. This may seem silly, but we have server birthday parties based on the years they’ve been up since a cold or soft reboot. So far the record is 900+ days.

OK, so what does this all have to do with the financial down turn…try a nearly two-thirds cost ownership reduction over the same time period…enough said.

Transitioning

September 1st, 2008

Let me tell you…one thing I’ve learned is that there is never a ‘bad’ economy, the money is just shifting hands. You need to position yourself to be in the flow of money between point A and point B (or better yet, be point ‘B’). People are dumping a ton of money into on-line advertising and marketing as a cheaper yet effective alternative to traditional advertising and marketing methods.

In my last post, I re-emerged with a side business designing sites and doing some on-line application programming with a few partners (no one from Astro…again for those that care…) .It is going great! Every month we are doubling our gross income, with almost no overhead. You can’t beat it.

We are also getting exposed to many new industries. I’ve been in manufacturing for over 11 years. Now, we are diving into lending, health and beauty, oil, jewelry…even cookies. I couldn’t pay for this kind of education so quickly.

Anyway, to see some of our progress go to…

http://www.mcw-inc.com or http://www.marketbeauty.net

Wade Stankich

Web Design…

July 19th, 2008

I know it’s been a while since I’ve posted. I’ve been up to some new things and it’s been crazy. Any, I’m back.

Here’s somethings that I’ve been working on with a few other associates (not anyone from Astro, for those who care). We dived into a bit of web site design. Mostly for the beauty industy, but we’v got a few things in the works for jewelry and cookies. I know this is a far cry from manufacutring, but it’s a skill that can be applied to any industry, and I won’t get slamed for ‘competative advantage’ issues. Someday I’ll explain…

 Check some of these sites out in the mean time….

www.stylingone.net

www.hairtique.com

www.cdrmiami.com

www.legalhair.net

 These are a few sites we’ve done recently…leave feedback one them if you wish. All constructive criticism accepted.

Thanks,

Wade

How’s those software audits going?

February 4th, 2008

Software piracy and compliance issues are very important and can be costly. We need to stay vigilant and make sure our company legally owns the software products we have in house. If you don’t have an auditing procedure in place, you should think about one now. When you get the letter from the software police…it’s to late and it won’t matter if your company is actually guilty or innocent of copyright infringement. Your company will be adding an additional account to your company’s A/P and writing a check out to some legal entity, if you are not prepared.

To help with this ongoing project, there are some things to consider. First, it doesn’t really matter how many boxes, labels or license keys you can physically come up with in an audit. What really matters is having a document trail through your accounting department that lead to original paid invoices. Typically, I keep copies of the purchase order, the invoice, and the check that paid for it, and any additional information that would be useful in showing that I own the product. Then, associate that information to a device or user, depending on how the licensing agreement is structured. Additionally, if you are able to match the paid invoices to something like Microsoft’s licensing site…this is a plus. I have actually had the site eat a few licenses over the years, so your document trail is your only sure bet. Now, whether this trail is actually paper or digital, that is up to you…the point is to be able to come up with the documentation.

There are many software auditing products out there that you can install on your network…just Google it. For example, I use GASP and I can configure our software to audit the the devices on our network when a user logs into our Windows domain. When the login script runs, it searches the hard drive for a installed programs on an interval, such as a month. The results get stored on a share of your choosing. Then, using a report writer, your able to compile the results into a format that makes sense for your organization. This enables a person to compare what should be on the device with what actually is on it, and correct any discrepancies.

There are many different ways to design a good software auditing system. When designing one that’s right for your company, if the worst was to happen and a disgruntled employee decides to have some fun, most likely there will non technical lawyers arguing whether or not you own the licenses. It will all boil down to who has the most valid proof and who can argue the best…not necessarily if your actually holding a valid copy in your hand or not.

A situation like this can happen to the most ethical of companies. So, be prepared…

Wade Stankich
Information Technology Manager
View Wade Stankich's Profile at Spoke

Measuring Flow

January 19th, 2008

We need to measure the flow of a liquid through a pipe at work. This seems easy enough on the surface. I’m thinking…just “click” off the liquid in some measurement as it goes by…right? Well, it could be…maybe. In reality, it turns out that it may not be all that simplistic. There are other things to consider. What kind of meter should you use? There are many. What exactly are you trying to measure? What’s the density or viscosity of the liquid? Are these variable during the process? Are you actually trying to ‘regulate’ flow or ‘meter’ flow or both?

During the consideration of this task of measuring the flow of a liquid, we would need to define ‘flow’. The straight-forward definition is… the flow of material past a given location. When we dig into it further and look at actual formulas for measuring flow, it starts getting more complex.

For instance, look at this formula for ‘Flow Rate’ (FRV). This is a volume per unit time or ‘volumetric’…

FRV = V x A, where A equals the cross-sectional area of the inlet pipe and V is the average velocity of the liquid being measured. Now consider this formula in practice. We have liquid flowing through a pipe that has 2 square meters of cross-sectional area, traveling at an average velocity of 2 meters per second. So, I have a flow rate of 4 cubic meters per second.

Next, look at this formula for ‘Flow Rate’ (FRM). But this time, we will deal with ‘mass per unit time’ or a ‘mass metric’…

FRM = FD x FRV, where FD is the fluid density and FRV is our volumetric product from the first example. So, if 4 cubic meters per second of fluid is flowing through a pipe, with a density of 2 kilograms per cubic meter, your FRM is 8 kilograms per second.

Do you want to measure flow in terms of a ‘mass’ or ‘volume’? It depends on your application. In some instances the process may have a limit on the ‘volume per unit time’ measurement it can accept. Some examples might be…filling a tank, painting widgets, etc. Other processes may have a limit on the ‘mass per unit time’ it can accept…like mixing chemicals or measuring chemicals for sale.

You can see that a person can purchase a meter that measures flow in terms of volume or mass. I found that you can even buy meters that ‘infer’ volume and mass using a similar formula to ~ ‘1/2 FD x V x V’. These meters are commonly referred to as ‘head flow meters’. But, further reading indicates that this ‘inference’ approach is problematic and can introduce errors when calculating ‘mass’ flow.

Careful consideration of what you really intend to measure about ‘flow’ should lead you in the right direction when purchasing a meter. Do you want to measure velocity, mass, volume or inferential values of each?

Wade Stankich
Information Technology Manager

View Wade Stankich's Profile at Spoke

Digital Evidence and the System Admin…watch out!

January 13th, 2008

Many companies and organizations are increasingly being faced with having to collect digital evidence in response to situations like fraud, child pornography, intellectual property theft, sexual harassment…etc. These are all examples of cyber-crimes that are happening inside, as well as outside corporate walls. This means system administrators are finding themselves having to be constantly educated on current legal issues and laws concerning the reporting and collection of evidence concerning cyber-crimes in their companies. Not only do system administrators need to preserve and collect digital evidence in these situations, but they also have to recover quickly from an incident to minimize losses.

System administrators can be caught in a potentially career damaging position. Take this scenario for instance…finding child pornography on a computer in your workplace. If you simply delete the material, this may be interpreted as being criminally negligent. If the system administrator were to alert authorities to the material before getting the support of his/her’s employer, the system administrator could find themselves fighting the company, with their own money, time and lawyer. Ultimately, this could lead to the loss of the system administrator’s job.

Even well intentioned attempts to investigate child porongraphy allegations, have left the system administrators being prosecuted for downloading and possessing this material themselves! In light of these potential hazards, companies should have clear policies and procedures that outline how to properly deal with these situations.

These procedures should inform system administrators how to handle and preserve digital evidence of this kind. The companies policies should formally state the company’s position regarding illegal digital material. Employ the help of technically competent attorneys to aid in forming your policies and continue to have them review the policies periodically to stay up to date with technological changes.

Wade Stankich
Information Technology Manager

View Wade Stankich's Profile at Spoke

Bridging the Gap Between Maintenance and I.T.

January 5th, 2008

Over the years, it seems that past traditional roles of the maintenance department and the information technology department of a manufacturing company are (or have been) changing. The lines are getting blurred. Those guys in the ’shop’ with the wrenches need to be just as versed in techno-jargon as ‘those geeks’ in the computer room. The I.T. guys also need to understand plant operations and maintenance concepts and the language that goes along with it, too. Why?…plant automation.

Most backplanes you see on the plant floor have a multitude of different modules plugged into them besides just the PLC. Today, usually a person will find an ethernet module plugged into them. For the I.T. department this is another network device on their network. Many times an electrical engineer deploying a new machine with an ethernet module gives no consideration to an IP address that fits with the companies current scheme. They may not give consideration to broadcasting issues that can potentially bring a network to it’s knees.

Conversely, a typical I.T. department doesn’t give enough attention to what basically amounts to another I.T. department within maintenance. Most of the machines maintenance deals with have processors and can be networked today. The engineers in maintenance are skilled at programming ladder logic, and once that task is complete…it simply goes out. I.T. should be working with this department to help them successfully roll out there machinery and take on the more global considerations of the company’s network.

This cooperation of two departments, that are so different on the surface, is sometimes easier said than done. It can be a huge cultural shift for some companies. This cultural divide usually is established from the beginning because of typical organizational structures and the resulting presumptions. What I mean is, that typically the maintenance department falls under Operations and the I.T. department falls under Finance. Foundationally, the wall of separation is “…I.T. is administrative, and Maintenance is production.” This may have worked 30 years ago, but it is no longer a valid structure that serves it’s company well, or to the fullest potential.

The Maintenance department and the I.T. department need to be solidly joined at some level. Neither, falling exclusively under Operations or Finance, but working somewhere in the middle for the global good of the company. It starts with communication. Project managers of both departments meeting once a week to review projects would be a good start. At some point along the way each will realize they both share the same copper wires.

Wade Stankich
Information Technology Manager
View Wade Stankich's Profile at Spoke