Job Title: Doctor's Registration Database
Company: Post-Graduate Medical Education and Training Board (PMETB) UK
Duration: 2.5 Years
Role: Sole Database Analyst/Programmer
Software Skills used: SQL Server 2005, Access ADP, MS Word, MS Excel, XML, ADO
The Post-Graduate Medical Education and Training Board (PMETB) was responsible for processing applications for the registration of doctors in the UK (note that the PMETB has now been taken over by the General Medical Council UK). A Document Management system was intended to support this process, but the project failed to deliver. The requirement was to design, build and implement a solution that stored all of the applicants’ details and also handled the application workflow. The solution was a SQL Server database containing over 75 tables, 150+ stored procedures, 160+ user defined functions and secured access for 8 varying roles. Access was used to create a Data Access Layer (DAL) handling all of the communications between the presentation layer (also in Access) and the database. The front end is disconnected, all data retrieved from the database is stored in locally cached XML files and data updates are made via calls from the DAL to stored procedures. Excel is used for ad-hoc reporting and data analysis, Word is used to create documents including certificates with photos and Outlook Redemption is used for emails. The user base is 25+ users. The database was migrated from SQL Server 2000 to 2005 and the front end was tested in Office 2007.
I also assisted in the transformation of data collated from the National Surveys of Trainee Doctors and Trainers for the purposes of data analysis. The data from the surveys was collated and summarised using SSIS and Transact-SQL Scripts so that the web-site reporting tools could show statistical analysis of the results in tabular and chart forms. The website can be found at: http://reports.pmetb.org.uk
Many office workers and managers spend their days on repetitive tasks, trying to make sense of their workload and attempting to glean some information about their business from seemingly meaningless data. This is usually due to a lack of software systems, or poorly developed ones. With over 20 years of experience, my goal is to provide integrated systems that automate manual repetitive tasks and make sense of complicated data. This frees up people so that they can apply intelligence to their job...