Projects
The following is a portfolio of my personal and professional projects.
Website Development
I have designed a variety of professional, community, and personal websites.
Si Chun Lam (SiChunLAM.com)
The official website of Si Chun Lam provides visitors with a way to find out more about me, read my Curriculum Vitae and view a portfolio of my projects.
Cost Calculator for Children's Services
The Cost Calculator for Children's Services (CCfCS) is purpose-designed software that currently calculates the costs of social care processes and placements for looked after children. It facilitates comparisons between the relative value of different types of care, making it easier to estimate the potential benefits of introducing a range of alternative packages. Analyses of costs with respect to the outcomes variables included in the CCfCS are also available.
The CCfCS website provides existing and potential users with a wealth of information about the software product. Potential users can find out about the research evidence that forms the basis of the software and a demonstration version; while existing users have access to frequently asked questions and a users forum, facilitating the exchange of information and ideas.
Cambridge University United Nations Association
The Cambridge University United Nations Association (CUUNA) aims to spread the spirit of the United Nations (UN) within the University of Cambridge and youth in the local community by promoting a greater understanding of the roles, functions and potential of the UN, its Charter and its agencies with special attention to the Millennium Development Goals. Founded in May 2006 and launched in October the same year, the CUUNA currently have over 1300 members and associates.
The CUUNA website provides members with news about the latest events organised or supported by the association; information about the association; campaigns; press coverage; sponsorship; and a photo gallery.
Software Development
I have developed and deployed financial and case management systems for multi-user environments, built using Microsoft Office Access and Visual Basic.
BaseCamp
BaseCamp is a case management system developed for a third sector organisation commissioned to provide aftercare services. This solution enables the third sector organisation to record core information about their service users; monitor weekly contact; record current activities undertaken; and evaluate outcomes.
The system feature a 'news feed', where all events are recorded on a single screen, similar to popular Web 2.0 applications like Facebook and Twitter. As such, it is easy for practitioners to use, yet powerful reporting features ensure managers can retrieve relevant information.
The successful implementation of BaseCamp will enable the third sector organisation to meet its contractual requirements to provide accurate and timely performance data to the commissioning organisation; and help ensure that a quality service can be delivered to their service users by making it easier for practitioners to share information between one another.
PlaceBook
PlaceBook is a database for managing the placements of children in internal and external foster care, residential homes, independent placements and secure units. It provides a children's placements team with an overview of all placements, and a way to view and manage vacancies.
The child module shows a list of children in local authority care and their current and historical placements. An event log provides users with the ability to record the activities involved in making a placement, so that any outstanding issues can be followed up in a timely manner.
The placements module shows all the placements known to and/or used by children in local authority care. Known vacancies and a list of children currently placed in each provision are also shown, enabling a children's placements team to make an informed decision about the suitability of a placement.
Life Chances Financial Database
The Life Chances Financial Database (LCFD) is an integrated case management and financial recording system to meet the strategic, operational and reporting requirements of a children's specialist service. This includes services for children with disabilities, and aftercare services for children leaving the care system.
Implementation of the LCFD enabled a unitary local authority, Coventry City Council, to track and record financial commitments for Direct Payments to children and families; monitor the uptake of community-based and residential Short Break services under the Government's Aiming High for Disabled Children scheme; and contributed to ensuring equality of access to the Leaving Care Grant for children leaving care.
PanelDB multi agency panel database
PanelDB is an electronic management information system to manage cases and processes for a multi‐agency (social care, education, health) joint working panel from start to finish.
Key features include recording individual cases and panels; tracking and monitoring panel events; generating decision sheets and minutes; and quick access keyboard shortcuts.
Implementation of this end-to-end solution at a unitary local authority provided the social care, education and health partners with a way to monitor the outcomes of the panel, and ensure that agreed actions are followed up promptly.