HACCP and SSOP record keeping system

Closed

We need a HACCP and SSOP system for our facility it needs to be IPAD, IPHONE, and PC based programs. The HACCP and SSOP needs the following items:

1) A daily pre-operational check, in which an operator checks boxes as acceptable, unacceptable or not in use. If it's marked unacceptable, then the operator must write a corrective action. We need the ability to add items to the pre-op check and remove them easily. This is a daily form.

2) We have operational monitoring that is done twice a day. This monitoring is done same as number 1, in which it's either acceptable or not acceptable.

3) Next form is Critical control point verification. In this form, we verify our products for cleaniness. 10% of all products are checked and 1% are double checked. There are 2 Critical control points on this form. This data needs to come from our current SQL database from our scale and needs to pop up automatically. So 1 out of every 10, there will be a ccp check and 1 out of every 100, there will be a secondary check. THIS NEEDS TO BE AUTOMATIC FROM OUR CURRENT DATABASE AND SCALE. IT NEEDS TO POP UP TO OUR OPERATOR. In this check it will say if the check was ok or not ok. Also on this form is verification for chemical concentrations, item temperatures, and product age check.

4) This is a final tally report. It lists each lot, what was in the lot, the time, origin and date of the lot and weight of the lot (FROM SCALE). This is tied in with item 5.

5) Is a complete antimortem system. This also has to be tied into the scale system. There are about 20 pen locations where items are pulled for production. Each pen needs to have inventory in the pen, when arrived, and origin. We need to select a pen, select how many we are removing from the pen, and have the ability to sign the slip before it's printed. There needs to be a place for two signatures and a date and time stamp. This is how item 4 gets it's lots. We need to be able to add inventory when needed.

6) We need to able to ammend any records on the fly. Admin logins will be able to do this.

7) There needs to be different log in levels.

8) This has to be a seperate MS SQL database. OUr scale database can not be modified for fear of errors. We need this database for HACCP and it needs to pull info from our scale database on the fly.

9) At the end of the day or at a later time, we then need to review records. There should be an automatic review in which it checks for missing data. Once missing data is located, we then must be able to sign the paperwork. We wish to do this on the fly on both IPADS and PC. Once records are completed they need to be printed, with the hand signature or e signature on it. Records should print formatted correctly.

10) Information must be available REAL TIME.

11) A seperate record for pest control that is completed once a day must be included.

12) A seperate record for proper handling of product must be included.

13) The software needs to be easily modified. Such as adding new forms, checks, CCPs, procedures and uploaded documents.

14) We also need an area for a flow chart for our haccp plan. We also need an area for our actually plans that can be brought easily on PC and IPADS.

15) There should also be different record print cycles for different departments, so only certain forms are printed in that print cycle.

16) More may come as we think of it.

THIS HAS TO BE AS STATED or WE WILL NOT PROCEED

Skills: Engineering, iPad, PHP, Software Architecture, SQL

See more: what need for an operator, sql inventory system, pre flow, need of tally, levels system, how do we write report, flow ipad, time record, Tally Software, system monitoring software, points system, pest, HACCP, fly to ms, fly for ms, chemical production, chemical engineering, ccp, print scale, operational plan, database record keeping, php flow system, sql report write, add record, slip report

About the Employer:
( 7 reviews ) Stockton, United States

Project ID: #4358974

4 freelancers are bidding on average $1325 for this job

steven6

Hello, we are a group of programmers based in Sheffield, UK offering 7 years experience in php, .net, c#, jquery, css, python and c++. I am proposing to carry out tasks required for this project and deliver it within 4 More

$1499 USD in 0 days
(26 Reviews)
5.5
bluecoded

Hi, Please check private message. Regards.

$1500 USD in 25 days
(6 Reviews)
5.0
codeware1

Hello , Hope you are well and doing good!!! we are eager to work with you.We are ready to start the project right away. Codeware is a website development company providing professional website design, website developme More

$1500 USD in 12 days
(11 Reviews)
4.0
getveltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$1300 USD in 25 days
(6 Reviews)
1.5
AbsoluteTech

Ready to work.

$1000 USD in 35 days
(0 Reviews)
0.0
blackgrapes1

It's an easy task for us. We have gone through the project requirements and may start working on it immediately. Please check PM for complete details.Thanx.

$1400 USD in 25 days
(0 Reviews)
0.0