Gregory Smith Email & Phone Number

London Area, United Kingdom

Oversight and management of service improvement interventions driven by root cause analysis, working closely with strategic directors and heads of service to understand & analyse performance, providing challenge and identifying & delivering upon opportunities for improvement and cost/efficiency savings.Delivery of a Digital Transformation Programme across Adult Social Care, including the migration of all existing reporting functions from SAP Business Objects to SQL - development of Adult Social Care datasets from the Mosaic IT System for shared use in reporting/analysis - implementation of a suite of bespoke Power BI dashboards fulfilling operational and SMT data & performance monitoring needs - automation of statutory returns: Safeguarding, SALT, DoLS DHSC - in addition to the planning and provision of staff support around digital change and advocating the benefits of better ways of working.

London, England, United Kingdom

Complete review of existing performance management framework after implementation of new cloud-based repairs management IT system, including; system configuration; SQL script development; self-service reporting solutions; and full automation of KPIs and management dashboards via Microsoft Power BI.Information needs analysis, report design & production and reporting solutions developed and implemented for a newly established Customer Services & Complaints Team. Giving access to all relevant resident and repairs associated data in relation to legislative complaints process and associated data requirements - data derived from various CRM databases on various DB platforms (MS Sql Server, Oracle, Data Warehouse) - in a self-service format.Advanced/Expert in; Autonomous MI reporting; ETL (Extract-Transform-Load) workflows; complex SQL query development; live dashboard deployment; visualisation design; Power BI reporting; and SSRS self-service implementations.Development and review of data quality programme and system audits including the drafting of appropriate procedures and methods, to advise on remedial action where appropriate.Working with repairs managers and HoS to develop systems for capturing performance information effectively and efficiently.

London, England, United Kingdom

Responsible for the establishment of computer based and other systems for the monitoring, calculation and audit record requirements associated with Operative Payroll, including timesheet entry, bonus payment calculation and job-code (SoR) breakdowns, to replace key day-to-day functions previously managed via dedicated payroll IT system.Production and provision of all ad-hoc, daily, weekly, monthly and annual MI /Performance / Data reporting using various reporting tools & techniques (e.g. SQL, Power BI, SSRS, Business Objects) in line with agreed service delivery deadlines.Various ad-hoc and programmed financial and pay related analyses including but not limited to; payroll modelling; budget forecasting; internal/external audit investigation and evidence provision; bonus pay calculation; fleet management cost and environmental impact analysis; supplier cost profiling; and financial reconciliation.Providing Repairs Managers with performance and financial information to enable effective development of appropriate training programs for staff.

London, England, United Kingdom

Full automation (SQL/SSRS) of monthly and annual performance indicator reporting for the following Housing services: Housing Rents (Income Collection); Leasehold Service Charge & Major Works (Income Collection); and Repairs & Maintenance Service (KPIs).Coordination of system upgrades and testing (i.e. distribution and collation of test scripts, reporting and logging bugs identified with external system developers, communicating upgrades issues, undertaking user acceptance testing.Scheduling and maintaining batches which perform critical system processes across various service areas and monitoring of batch processes, resolving any issues. Liaising with software suppliers / developers to troubleshoot bugs and issues.Development and design of MI in a variety of visual formats including statistical reports, charts and diagrams for use by internal and external clients.Project management, including to plan, estimate, coordinate and execute system development projects, with a focus on feasibility, cost vs. benefit and potential return on investment.Gathering and documenting complex data requirements from clients (EBUs, IBUs and other Stakeholders) to develop functional and fit-for-purpose reporting solutions ensuring proper validation and testing, preserving quality control and data integrity.

London, England, United Kingdom

Forecasting: Temporary Accommodation, including advanced statistical analysis techniques and report provision.‘Price per Property’ analysis of spend on void properties and responsive repairs for the purpose of identifying opportunities for savings and stakeholder buy-in.Data management and collation of London-wide benchmarking initiative, with a focus on information pertaining to repairs and voids charges.Monthly monitoring, update, reporting and information dissemination of borough-wide stock movements.Acting as a specialist resource in benchmarking and developing bespoke surveys to measure the impact of service reviews and projects.Leading and supporting on consultation through a range of methods, such as focus groups, workshops and surveys.Responsible for the accurate collation and completion of LAHS returns and property data.

London, England, United Kingdom

Member of team of three project coordinators delivering on large scale dementia training project to train a minimum of 12,000 NHS general hospital staff across LETB for North Central and East London region.Regular reporting of in-depth and top-level findings to a wide range of project stakeholders.Data-metric reporting, specification and design. Outsourcing of data input and handling, including contractor liaison and management.Relationship management of network of Trust leads and clinical trainers, including effective communication, responding to and resolving queries and requests, problem solving and miscellaneous management support.Design and production of project related promotional materials and advertising, including monthly project newsletter production coordination and editing.Events planning, sourcing of service providers, procuring goods and services in conjunction with corporate finance and coordination of various activities to schedule and budget.Working with GPs and Practice Nurses to coordinate training sessions in relation to dementia awareness and early intervention and assessment, including venue and catering sourcing and organisation.Delivery of Dementia Awareness training directly to NHS non-clinical staff across Trusts in the region.

London, England, United Kingdom

Project management and task coordination for all elements of a cross-organisational Dementia Training Initiative, to train 2000 NHS acute general hospital staff at seven NHS partner Trusts, in dementia care.Managing a network of NHS Trust leads and clinical trainers, including effective communication, responding to and resolving queries and requests, problem solving and miscellaneous support.Budget management, invoicing, monitoring and financial reporting.Project website design, development, coding (HTML, CSS, JavaScript), hosting and management.Data monitoring system design, implementation and management, including; provision of dashboards & visualisations and the analysis of numbers trained by job role breakdown and staff feedback.Regular reporting of in-depth and top-level findings to a wide range of project stakeholders and interim reporting of progress to the funding body, at pre-defined stages throughout the initiative.Formulation and production of questionnaires and evaluation mechanisms, which form the basis of the research element of the initiative.SurveyMonkey data management, follow-up email and hard-copy scheduling, monitoring and reporting on response rates and category breakdowns and download of responses.

London, England, United Kingdom

Project management and delivery of patient records filing system relocation and reorganisation. Including sourcing of transportation for office based equipment, office floor plan design & agreement and information dissemination.Review of patient files across four boroughs, including audit compliance and archiving and electronic patient database management, update and analysis.Benchmarking returns for quarterly Department of Health key performance indicators.Management & oversight of PO and Non-PO invoice coding and approval for NHS patient related fees and equipment.Financial investigations into past supplier charges and detailed invoice history, including provision of remittance advice in relation to palliative care charges.Care provider liaison and relationship management.IT systems staff training and support.

London, England, United Kingdom

Design, implementation and continuous improvement of systems used to measure resident satisfaction. Identifying trends and patterns within satisfaction data across the organisation. Interrogating data to enable profiling, to ensure an equal level of service to all resident groups.Managing and improving the existing resident mystery shopping programme.Developing an overview of satisfaction levels with service providers, including benchmarking and working with housing providers to identify areas of dissatisfaction to address these to achieve targets for satisfaction.Carry out annual STATUS survey in-house and through use of contractors, adhering to strict budget and timescales.Regular satisfaction based report writing and feedback to senior management and Board.

London, England, United Kingdom

Coordination of HouseMark annual cost and performance benchmarking.Design, update and management of organisation-wide strategic action plan, including regular reporting and analysis of statistical data to EMT, Board and Service Improvement Committee.Planning and project management and implementation of resident mystery shopping initiative to test service standards across the organisation. Including analysis of resident profiling data to ensure a true representation of tenant population, eligibility criteria checks and implementation of measures to ensure adherence to legal obligations.Management and delivery of all documentary evidence required for electronic submission to the Audit Commission for inspection accreditation. Including formulation, format and submission of responses to interim and final feedback.Analysis of existing website and coordination of major updates to underlying structure.Delivery of group based and one-to-one IT and systems related staff training sessions.

London Area, United Kingdom

Delivery of numerous research projects, including results analysis & information dissemination throughout the organisation.Design and creation of complex MS Excel solutions to numerous monitoring and analysis scenarios, including improvement and maintenance of existing workbooks.Analysing Health & Safety reports, summarising and compiling data for management action.Developing and maintaining an effective intranet based library of policies and procedures, in a range of accessible formats.Leading on monthly residents meetings for discussion on specific service area improvements.