We are looking for a developer to build and deploy a time sheet entry application developed in ASP.Net 4.5 using visual studio version 2013. The WEP application will be access primarily from smart phones (iPhones and android) as well as windows 7 desktop computers.
The site will allow uses to select a job and enter their time. When a job is selected the customer name and job name would be displayed.
For the selected job the user would enter the date, start time, end time, activity code and notes. The system will then determine the users total hours works (End time minus start time) for the entry. The user is then able to make multiple entries for the day and then at the end of the day review the complete list of entries and submit.
The user will be able to look up prior submissions but will not be able to change them. They would be able to add time to a prior day which would be no different then making the current days submission except that it would be on a prior date. User would be able to view a summary of the totals hours submitted by day for the last 30 days.
Users should be able to make entries, review, modify through the day and then decide when to submit the values. Submitting depending what the final solution may be to change a flag on the entries to indicate they are final after which the server if free to process and the user can only view but not change.
The user application should be designed such that the time entry is only one aspect of the users possible activities. In the future the application will allow users to look up their schedule for any day, manage safety compliance and allocate material to jobs. The future function should have place holders on the screen and when accessed the user is notified "Coming soon".
User interface must be designed to make it quick an easy for a user to enter data. Things like assuming the next entry is the same job, same date and that the start time is the end time for the last entry should be some of the features included to stream line the data entry process.
On the server side there will be functions to:
- provide the user with the available job numbers and activity codes
- provide the user with job number details
- Receive the users time sheet submission
- Provide the user with a prior days submissions
- Provide the user with the total hours submitted for each of the last 30 days
The server would be reading and writing to a Microsoft SQL database. The table that would be used would likely be a time submission table, available job number/details table, activity type table.
The deployment of this would be done on a local server in our facility and the scope of work is to include all the configuration work needed to get the application operational on the server. The application would need to be implemented securely and through the process our IT support person is to be provided with guidance on how to ensure the implementation remains secure. Configuration items needed on our side such as configuration on the firewall would be completed by our team with guidance provided but the developer. All implementation on the live server would be monitored and/or supervised. Remote access to the server would be provided once the application is developed to the point that it can be implemented. The work should primarily be done off site on the developers resources. Access will only be provided for the final testing and implementation.
We have an existing production system that contains all the actual live production data. Through the design process the work is to include determining how the final deployment should be completed. Will the WEB server talk directly to our production database or will the WEB server have it's own database and in the back ground we feed from the production server the needed data on the WEB server (replicate the data) and the have the production server read any needed data from the WEB server?
The work is to include providing a complete tour of the application and orientation to our IT support team so they can maintain the application going forward. The application must be throughly documented. The work is also to include providing all the code and setting up the project on two development stations that already run visual studio 2013 so that our developers can then seamlessly talk on supporting and enhancing the application. We user Perforce to manage revisions.
The developer will be required to work through some of the details that may be missing and help in determine the best course of action to accomplish the desired outcome.
Once the time entry portion of the project is completed the next 3 item (shed use look up, safety Management and material allocation) would be looked at next. The developer of the time entry portion of the project would be considered for the next 3 phases.
Responses should include a time line and milestones for deliverables.