Tracking App - Tape Data Storage

Proposal created by: Ingen Digital

Opportunity

DataKnox has successfully bid for a contract to securely manage Data Backup Tapes.

Service provision requires DataKnox to catalog the items, and provide a process to track and monitor retrieval and return of items.

This simple yet highly critical process needs to be managed by an application that reduces the chance of errors.? For management reporting purposes and in the case of any discrepancy, the app will create an Audit log of all user activity in relation to the movement of a Data Backup Tape.

DataKnox may have a future need for other similar custom apps, therefore consideration has been given to centralised user management.

Key Requirements

The tracking app is required to 1. Maintain a record of the Data Storage Tapes and their location 2. Maintain an Audit Log of status and location changes (retrieve/return) 3. Allow external users to request a retrieval 4. Allow internal users to update status and location 5. User role and authentication to control the process 6. Recommended Option - Integrate Identity Provider

1. Maintain a record of the Data Storage Tapes and their location

Requires the ability to: - Create records (line items) for each storage tape - Delete records (eg. wrongly entered, no longer required) - Modify records - description, status or location information - Search, sort and filter records - Export records to csv Options/Future Scope: - Import records - Bulk update status / location

2. Maintain an Audit Log of status and location changes

Requires the ability to: - Write and store detailed log of every status/location change of each Item - View current status - View movements for an item - View all movements for a particular month (for a particular client) - Filter by date / time Options/Future Scope: - Print / Email Audit logs - Bulk update status / location - View in collapsible display (item, with collapsed audit info)

3. Allow external users to request a retrieval

Requires the ability to: Request Retrieval - External User to login and see all Items - Select which Items they would like to retrieve - Export to CSV (for cutting and pasting to email) Return Item - External user to select which items they are returning - Export to CSV (for cutting and pasting to email) Options/Future Scope: - Specify retrieval address for each retrieval (initially only one retrieval address) - Email directly from the application for retrieval or return - Some type of enforced verification of receipt (both in and out - eg. client has to change status from "Sent" to "Received")

4. Allow internal users to update status and location

Requires the ability to: - Login to search for Items - Change status (possibly multiple - requested, picked, sent, with customer) - View audit history for particular item - See audit history of particular time period (eg. "today" to check that marked as "requested" have now been sent) Options/Future Scope: - Bulk updating of records

5. User role and authentication to control the process

Requires the ability to: - Create, edit, update, delete: - Client Company - Client User - Internal user - Manage User role permissions - Admin User - create, delete records. Add new users. Add new client companies. - Internal User - modify records (check in, checkout). View audit logs - Client User - search and request Items - Lost password servicing

6. Recommended Option - Integrate Identity Provider

Setup user management with a cloud based identity provider using Open Id Connect protocol on OAuth 2.0. This to allows centralised user management - authentication (access) and authorisation (roles) - for both internal and external users. All future applications would be integrated with the same provider, allowing web based Single Sign On (or at the very least the same centrally managed login and password) for all Triforce and Dataknox applications. This extends to every 3rd party app that supports Login with Open Id. And (although it is not our area of expertise) we understand this can extend to internal networks as well eg. Active Directory. Useful if Triforce wants to control and provide employees with SSO on every app required to do their job.

Timing

Target Delivery Date is based on receiving the following; - Proposal Sign off - Provision of all required data fields - Provision of Sample data (at least a couple of rows of data)

Estimated Timeline:

Received items + 45 days

User Management + View Test Data

+20 days

Audit Log + External Users + Update Records

+25 days

Your Investment

Project Essentials The following elements are considered essential to the project: ? Setup hosting environment ? Setup database and connections ? Design user experience and user interface ? Develop HTML/CSS for application ? Develop responsive breakpoint for tablet (mobile specific design not required on this project) ? Test and debug beta version before launch (client responsible for User Acceptance Testing) ? Launch live website ? Manage code on bitbucket ? Integrate a backup schedule to protect the application Additional Option The following option is recommended to fulfil future additional app development and customer service goals: ? Create and configure Identity Provider (IdP) ? Integrate this Storage Tracking App

Base Application

$8500

Integrate Identity Provider

$4000

Total: $12500

Approve Proposal

We're looking forward to working with you. If you have any question please feel free to reach out directly to Ben: 0419 264 848

The digital space moves quickly. Sometimes hype and opinions get in the way of common sense. We've seen hundreds of thousands of dollars spent on sites that look great, but just aren't that great to use. We want to put a stop to that.

It is our mission use the right tools and right approach with a healthy dose of common sense, to build with real purpose and deliver something that delights.