Asset Database Build & Exploitation Project at GreenSquare Group, South West England, 6-8 Weeks, £Fixed Price

  • Contract Spy
  • South West England, UK
  • Jan 08, 2021
Fixed Price

Contract Description

 
Overview
Summary of the work Design, develop an Azure SQL based database to capture our asset data with a mobile friendly PowerAPP interface for our surveying team and some critical PowerBI reports for management information & reporting.
Latest start date Sunday 31 January 2021
Expected contract length 6-8 weeks
Location South West England
Organisation the work is for GreenSquare Group
Budget range  
 
About the work
Why the work is being done This work will allow the Group to exploit it's refreshed asset data from its stock condition surveys that are being carried out.

The work must be completed by the end of March
Problem to be solved The data is currently being captured in a 3rd party SQL based database. Greensquare needs to build it's own Azure SQL database instance to replicate the table structures and allow migration of this data into our estate.

This data must be mapped, merged and migrated into the proposed solution.

It also requires the development of a simple PowerApp to allow surveying teams to interface with the database and the production of 1-5 PowerBI reports to support analytics.

This includes a front end application to view and interrogate the database.

As the the database will hold asset data on properties, with unique ID of which is held in another Progress based database, the database must be required to interface with this database to be uplifted when the property population changes.

We are very open to having innovative solutions based on the the CDS/Dataverse via PowerApps premium.
Who the users are and what they need to do As an asset management lead, I need to understand the current condition of all of my stock so that I can understand my investment planning.

As a surveyor, I need to be able to complete a survey on my mobile device that updates the database with the condition of the stock I find.

As a BI Engineer, I need to be able to extract the data into an Azure Data Warehouse to support PowerBI reporting and data modelling for predictive analytics.

As a database admin, I need to be able to ensure and monitor the size and efficiency of the Database for operational efficiency processes.

As a user of the data, I need a simple user friendly PowerApp application view to the data, so that at the most basic level users can search for a property and the data (and potentially repairs/maintenance/compliance responsibility) for that property can be returned in an easily digestible format. This is particularly useful for the Repairs and Maintenance teams, who need to do this kind of querying regularly - for example, they may decide not to repair some aspects of a kitchen if it's due to be replaced.
Early market engagement  
Any work that's already been done Business requirements have already been captured both functional and non-functional.
Existing team There is a business lead, surveying lead, a project manager and a data/BI Engineer support.
Current phase Alpha
 
Work setup
Address where the work will take place Chippenham Wiltshire - however fully expect to be working remotely.
Working arrangements Remote working during COVID-19
Security clearance  
 
Additional information
Additional terms and conditions  
 
Skills and experience
Essential skills and experience
  • Demonstrate excellent competence with building Microsoft Azure SQL databases
  • Demonstrate excellent competence with building integrated PowerApps into Azure SQL databases that are mobile friendly
  • Demonstrate excellent competence with designing PowerBI reports that interface with Azure Sql Databases
  • Demonstrate excellent competence with designing Azure SQL databases to best practice from a security posture.
  • Demonstrate excellent competence with working with field based colleagues to ensure solutions are fit for purpose
  • Demonstrate excellent competence in working in an Agile way to deliver capability in an incremental way
  • Demonstrate excellent competence in working on client side environments
  • Demonstrate the ability to deploy a competent team rapidly.
  • Demonstrate excellent competence in providing handover training and deployment support
  • Provide case studies of previous work.
  • Demonstrate excellent competence in building front end applications to interrogate and view the database.
  • Demonstrate Excellent Competence in data mapping/migration/merging
  • Demonstrate excellent competence in interfacing Azure SQL databases to other databases.
Nice-to-have skills and experience
  • Flex resources as required based on a dynamic approach
  • Provide innovative ideas whilst delivering the core requirements
  • Excellent experience in interfacing SQL with Progress databases
 
How suppliers will be evaluated
How many suppliers to evaluate 5
Proposal criteria
  • Technical Solution
  • Approach & Methodology
  • How the approach or solution meets user needs
  • Estimated timeframes for the work
  • How they've identified risks and dependencies and offered approaches to manage them
  • Team structure
  • Pricing Model
  • Key Assumptions & Exclusions
Cultural fit criteria
  • work as a team with our organisation and other suppliers
  • be transparent and collaborative when making decisions
  • take responsibility for their work
  • be comfortable standing up for their discipline
  • can work with clients with low technical expertise
Payment approach Fixed price
Additional assessment methods  
Evaluation weighting

Technical competence

75%

Cultural fit

5%

Price

20%
 
Questions asked by suppliers