Simon Lam Email & Phone Number

London, England Metropolitan Area

• Developing dashboard and reports on East London Health and Care Partnership Power BI for Primary Care Network data pack• Provide analytical support to Care City test bed programme work streams for Kinesis and Kardia, establishing baseline data before, during and after the intervention to help with the evaluation• Creating SQL script to identify high risk patients for integrated care management based on risk stratification. This enables commissioners to initiate proactive… Show more • Developing dashboard and reports on East London Health and Care Partnership Power BI for Primary Care Network data pack• Provide analytical support to Care City test bed programme work streams for Kinesis and Kardia, establishing baseline data before, during and after the intervention to help with the evaluation• Creating SQL script to identify high risk patients for integrated care management based on risk stratification. This enables commissioners to initiate proactive management plans and intervention for patients that are potentially high service users• Led a team of Information Officers to support the implementation of the NHS Health Check, coordinating stakeholder engagement meetings with organisation partners• Dementia operating plan- under reporting of dementia diagnosis across the CCG, liaising with NELFT memory clinic to reviewing patient information and informing practices to improve diagnosis• Data for high dependency beds. To understand the flow of all high dependency patients in “care homes” beds through the system. BHR CCG, Havering ASC, Havering Public Health• Solely responsible for creating and maintaining a Medicines Management report monitoring urinary tract infections for nursing homes using SUS+ as a data source. This was used to monitor the CCGs care homes admissions avoidance scheme Show less

• Working in Commissioning Support directorate to support GP pathfinders consortia during the transition • Developing Health Analytics as the main reporting tools (SUS, GP data) to automate reports so managers and GPs can use the information to make an informed decision • Implement Contract Monitoring Database to support world class commissioning, central hub for all contract managers to effectively monitor, view and track activities concerning all the contracts within the… Show more • Working in Commissioning Support directorate to support GP pathfinders consortia during the transition • Developing Health Analytics as the main reporting tools (SUS, GP data) to automate reports so managers and GPs can use the information to make an informed decision • Implement Contract Monitoring Database to support world class commissioning, central hub for all contract managers to effectively monitor, view and track activities concerning all the contracts within the directorate. Achievement: Ascertain WCC competencies 10 • Developed Paediatric Eye Clinic Database in MS Access for booking and maintaining patient appointments. Achievements: Data easily accessible and consistent than the old paper based system and have been in used for the last 7 years • Implemented a Polysystem Balanced Scorecard to measure Key Performance Indicators (KPI) using RAG rated methodology • Responsible for all DOH returns, including18 weeks RTT, Delay transfer of care, Diagnostics Monthly, Audiology Waiting Times Show less

Ilford, United Kingdom

• Developed GP Contract Review Reports to monitor performance of practices and raise awareness of key targets. Achievement: support practice meeting benchmark • QOF Prevalence, analysed practice prevalence and the implication the correction factor has on practice income. Achievement: helping affecting practices to better equip to changes • Developed Loxford polyclinic Business as Usual Report, and update metrics to measure capacity and ascertain value for money (VFM)… Show more • Developed GP Contract Review Reports to monitor performance of practices and raise awareness of key targets. Achievement: support practice meeting benchmark • QOF Prevalence, analysed practice prevalence and the implication the correction factor has on practice income. Achievement: helping affecting practices to better equip to changes • Developed Loxford polyclinic Business as Usual Report, and update metrics to measure capacity and ascertain value for money (VFM). Achievement: Measured the success of Loxford Polyclinic • Provide monthly monitoring of InHealth diagnostic activity as part of the PBC budget, to ensure practices have not exceeded budget spend. Also to scrutinise records to ensure the activity is billed correctly, as a result, PCT have recoup £10,000 thus far. • Developed Nationally Recognised Dental Reports, this enable manager to make informed decision on commissioning and effective contract management. Achievement: Met and exceeded patient access benchmark of 162000 as set out by NHS London. Show less

• Collate, validate and process Mental Health datasets from CSE Servelec's RiO v.4 Mental Health System. • RiO sys admin experience of creating user account. • XFB download of RiO backend database for data analysis. • Using PGP software to decrypt weekly extract of RiO data on CD as provided by BT. • Part of a team involving data migration from legacy ePEX and PiMS systems to RiO. Conducting gap analysis • Produce exception reports to help improve data… Show more • Collate, validate and process Mental Health datasets from CSE Servelec's RiO v.4 Mental Health System. • RiO sys admin experience of creating user account. • XFB download of RiO backend database for data analysis. • Using PGP software to decrypt weekly extract of RiO data on CD as provided by BT. • Part of a team involving data migration from legacy ePEX and PiMS systems to RiO. Conducting gap analysis • Produce exception reports to help improve data quality (missing diagnosis, missing MHMDS, duplicate records) • Developmental work: 7 day follow-up database to automate routine reports. • Submitting statutory returns- (Delayed transfer of Care) to Department of Health for Haringey PCT and BEHMHT Show less

Msc, Computing & Information Systems

Bsc, Biology