Development of a quality performance reporting metrics management app

Tender description

Why the Work is Being Done To create an efficiency saving for the monthly production of the Quarterly Performance Report (QPR). Problem to Be Solved Lancashire Care NHS Foundation Trust have identified possible efficiency savings in the monthly production of the Quarterly Performance Report (QPR) by utilizing a metrics managements web based app to pull data for key KPIs directly from the Trust data warehouse and present to the networks via the app to review, sign off and record an audit trail. This will streamline the current approach which uses Excel to present manually collected data. Who Are the Users As a Service Manager I need a simple way to review automated figures so that I can make amendments to the data before the submission deadline. As an Information Specialist I need to manage the metrics that are processed by the system and assign service managers to review them so that the correct information is present in the QPR. I need to freeze and unfreeze a reporting period so that I can enforce submission deadlines for service managers . I need to view the history of corrections to automated metrics so I can provide audit reporting. Early Market Engagement Work Already Done High level discovery has been completed which identified high level user needs. Existing Team Will be working with the Trust BI team and performance team. Current Phase Discovery Work Location Between Lancashire Care NHS Foundation Trust sites from ranging from Blackburn to Preston. Working Arrangments For the initial design & development we envisage to be on site. The completed development, support and maintenance to be completed remotely. This approach will be subject to change. Security Clearance Additional T&Cs Skills & Experience Have at least 4 years experience using SQL Server Have at least 4 years experience working on web based app development projects Have NHS experience, ideally in a mental health and community Trust setting At least two years experience in software development with NHS datasets Nice to Haves Previous experience of working with the Trust No. of Suppliers to Evaluate 3 Proposal Criteria Technical solution Approach and methodology Team Structure Value for money Estimated timeframes for the work Cultural Fit Criteria Work as a team with our organization Use Agile principles as foundation of work Track record of previous collaboration Payment Approach Fixed price Assessment Method Written proposal Evaluation Weighting Technical competence 50% Cultural fit 20% Price 30% Questions from Suppliers Budget range