Development of database with external feeds and associated reporting
4604
$$
- Posted:
- Proposals: 7
- Remote
- #87527
- Archived
Expert Mobile and web - AngularJS, C#.NET, XAMARIN, PHONEGAP, React, VSTO, ASP.NET, WPF, MVC, VB.NET, HTML, jQuery, CSS, Winforms
City of London
Cyber Security Consultant. I am comited to the online security and peace of mind of every business owner around the world!
London
8213810665612329617426270461134685209685
Description
Experience Level: Intermediate
We are looking to develop a new product (effectively a database with a portal to information) that allows importing of external data and provides high quality and flexible management reports of this information.
The system must include:
The ability to create and administer users and companies, who can log into the system to see their own specific data. Company information will include details such as company name, address, contact number etc.
A login screen
The ability to allow external data feeds (maybe as simple of importing from an Excel document or via an API from another company – and this needs to be secure).
A dashboard (or portal) showing:
Level 1: Company information (Company name and so on), High level ‘at a glance’ information – specifically risk (based on low, medium or high – based on imported data – see below) and Risk by region. Also – training status (data from an external feed) showing the course name, number of people on the course, started, not started, finished
Level 2: The ability to show the same information but by region (so a subset of the company information)
Level 3: The ability to show information by lists of users (based on region or company). The user list will need to display a sortable list of users with columns of information taken from the external feeds (for example – a column might be called ‘COSTS’ and show costs taken in from external data but displayed here
Level 4: the ability to show an individual employee record showing detailed information pulled from external data and the ability to add free text information
The ability to create individual users records that company information – both current and historical about users).
About the information in the system: The system will contain information about each individual in the company. Types of information will include criteria for establishing a risk factor based on a low, medium or high risk. This is dynamic data that may change and will need to adjust the risk rating of the individual accordingly (it is to be determined how we enter updated details). This in turn will change the risk of both the region or cost centre) or company and the updated information will be reflected in the high level reports.
Reports: We will define the reports but they will be simple high level reports showing – for example – a graph with the number of users in a region and the percentage of low, medium or high risk. If it is possible, the ability to be able to define criteria of a report would be great but we would need to see if it is within budget
Alerts: the ability to create and define alerts based on company defined criteria. (So company A might want to know if a risk status has changed as so on)
Other: We would like to be able to add company specific information in the portal/dashboard showing links to PDF’s we can upload and add - so some CMS.
We have a training system and would like to discuss how we can link to the modules in our system from this system (possibly a phase 2).
We are open to using an off-the-shelf system if one exists. We would also like the developer to be able to offer advice on hosting and maintaining the system. Finally, we must be able to meet in person during the project. We’re perfectly ok if the work is outsourced but there must be a physical contact in the UK who we can meet with at key points. Ideally this will be a long term relationship with an individual or company who can maintain and update the system.
Thanks -
The system must include:
The ability to create and administer users and companies, who can log into the system to see their own specific data. Company information will include details such as company name, address, contact number etc.
A login screen
The ability to allow external data feeds (maybe as simple of importing from an Excel document or via an API from another company – and this needs to be secure).
A dashboard (or portal) showing:
Level 1: Company information (Company name and so on), High level ‘at a glance’ information – specifically risk (based on low, medium or high – based on imported data – see below) and Risk by region. Also – training status (data from an external feed) showing the course name, number of people on the course, started, not started, finished
Level 2: The ability to show the same information but by region (so a subset of the company information)
Level 3: The ability to show information by lists of users (based on region or company). The user list will need to display a sortable list of users with columns of information taken from the external feeds (for example – a column might be called ‘COSTS’ and show costs taken in from external data but displayed here
Level 4: the ability to show an individual employee record showing detailed information pulled from external data and the ability to add free text information
The ability to create individual users records that company information – both current and historical about users).
About the information in the system: The system will contain information about each individual in the company. Types of information will include criteria for establishing a risk factor based on a low, medium or high risk. This is dynamic data that may change and will need to adjust the risk rating of the individual accordingly (it is to be determined how we enter updated details). This in turn will change the risk of both the region or cost centre) or company and the updated information will be reflected in the high level reports.
Reports: We will define the reports but they will be simple high level reports showing – for example – a graph with the number of users in a region and the percentage of low, medium or high risk. If it is possible, the ability to be able to define criteria of a report would be great but we would need to see if it is within budget
Alerts: the ability to create and define alerts based on company defined criteria. (So company A might want to know if a risk status has changed as so on)
Other: We would like to be able to add company specific information in the portal/dashboard showing links to PDF’s we can upload and add - so some CMS.
We have a training system and would like to discuss how we can link to the modules in our system from this system (possibly a phase 2).
We are open to using an off-the-shelf system if one exists. We would also like the developer to be able to offer advice on hosting and maintaining the system. Finally, we must be able to meet in person during the project. We’re perfectly ok if the work is outsourced but there must be a physical contact in the UK who we can meet with at key points. Ideally this will be a long term relationship with an individual or company who can maintain and update the system.
Thanks -
Andy T.
100% (14)Projects Completed
18
Freelancers worked with
18
Projects awarded
39%
Last project
3 Jan 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies