Housing Management System Implementation Management and Data Migration

Tender description

Why the Work is Being Done CPBC are procuring a replacement HMS and migrating data from the legacy system Northgate OHMS to a modern SQL based solution. The successful HMS supplier will be selected by the end of March 2020. CPBC require the outcome supplier to commence engagement by 1 May. Problem to Be Solved CPBC are looking for external implementation project management and data migration capability to support the migration from a legacy ORACLE HMS, Northgate OHMS, to a modern SQL based HMS. Who Are the Users As a local authority we need to manage council housing, homelessness and all related tenancy matters. The housing department works predominantly from the one site with an additional 8 sheltered schemes throughout the borough. Early Market Engagement Work Already Done Existing Team The outcome supplier will be required to work closely with the successful HMS supplier and the internal CPBC Housing team. There will be an additional 1.5 FTE internal resources which will be required to be managed by the outcome supplier as part of the engagement. Current Phase Not applicable Work Location Castle Point Borough Council Kiln Road Thundersley Benfleet Essex SS7 1TF Working Arrangments We envisage the project management resource to be 3 days per week on average and expect these dates to be required on site. We expect the data migration resource to be managed as part of the project management role. Security Clearance Additional T&Cs Skills & Experience PM - Experience of managing HMS implementation and Data Migrations PM - Ability to develop and embed full project governance across all service areas to enable change requirements to be captured, challenged and delivered PM - Proven ability to manage a diverse team PM - Experience of managing UAT, performance and load testing programmes with business sign off PM - Experience of managing data migration, validation and reconciliation processes PM - Experience of providing input into the development of a data migration strategy based on other migration projects PM - Experience of working with suppliers on multi phased implementations of complex solutions including data migration from project commencement to go live PM - Experience of managing the implementation of an externally hosted modern SQL based HMS DM - Experience of designing and developing data migration (ETL) best practice frameworks and components to extract, transform and load source data into SQL based HMS DM - Experience of Microsoft SQL server and Oracle databases DM - Experience of Microsoft SSRS and SSIS component development to deliver reporting services DM - Experience of source data profiling and master data repository design and reporting DM - Experience of working with internal colleagues and third party suppliers to understand the data structures of source systems DM - Experience of analysing and interpreting functional requirements into technical specifications DM - Experience of analysing, designing and devleloping data validation and reconciliation reports DM - Experience of extracting source data from multiple data sources including CSV, Excel, Access DM - Experience of creating and maintaining up to date documentation regarding data formats, scripts used and developing procedures for the ETL bet practice framework DM - Experience of working with HMS suppliers to ensure source data mapping points to the correct transformed data sets Nice to Haves DM - Experience of data migration from Northgate OHMS to a modern SQL based HMS PM & DM - working with a similar sized housing organisation or department with limited internal capacity DM - Experience of working with and migrating data sources held by trusted partners DM - Experience of creating routines to archive data that will not be transferred to the new system, into a SQL repository, for business users PM - Experience of working with HMS integrations with e-Financials PM - Experience of working with HMS integrations with Civica Revenues and Benefits PM - Experience of working with HMS integrations with external repairs and gas contractors PM - Experience of working with third party suppliers to design and manage Microsoft SharePoint implementations PM - Experience of working with HMS integrations with Civica Abritas No. of Suppliers to Evaluate 5 Proposal Criteria Value for money Approach and methodology for Data Migration Referenceability Risks and dependencies for organisation of CPBC size versus project complexity and approaches to manage Approach and methodology for Project Management Cultural Fit Criteria Demonstrate strong leadership and management skills Demonstrate excellent communication skills at all organisation levels and be able to provide business challenge throughout the project Demonstrate being able to work as a team with our organisation and other suppliers Demonstrate they will share knowledge and experience with other cpbc members of staff Demonstrate transparency and collaborative working when making decisions Demonstrate they can work with clients with low technical expertise Payment Approach Time and materials Assessment Method Case study Reference Presentation Evaluation Weighting Technical competence 60% Cultural fit 10% Price 30% Questions from Suppliers No questions have been answered yet Budget range