Information Analyst with a current (July 2015) Disclosure Scotland Certificate, 15+ years experience of Data Analysis. 10+ years NHS experience within PCT, CCG, CSU, Acute, Mental Health and over 1 years experience in Public Health, as an interim in the Midlands and further afield. Has transferrable skills from the NHS into the Private Sector, such as Payment by Results that can be transferred to Billing, Auditing & Performance and Fraud (Within NHS Contract Monitoring - Ensuring hospital is charging for genuine activity that is on the contracts and making sure that the hospital provides NHS Number or patient id to claim for costs of that patient). Previous areas of work include: Mental Health in MoD with SC access to Medical Records. Billing Analyst within Utilities such Water and Electricity & Telecoms Blue Chip company experience as Data Analyst for UK's biggest Pharmaceutical company and UK's biggest Credit Reference Company. COBOL programmer for one of UK's Biggest HR Solutions provider. Inexperience of previous roles, has become an advantage in gaining experience, as I have been moulded into learning IT systems, dataset and policies via on the job training allowing me to be adaptable in any working environment. ** Very competitive with my daily rate, which varies dependant upon location, along with travel and accomodation costs. ** Specialties: MS Access & Excel - Datasets & SQL, Pivot tables and Vlookups, - SQL Report Writing in MS Access and knowledge of SQL Server Report builder, Dr Foster, SUS/SLAM, CQUIN, PBC, PBR, Dashboards, Scorecards, Trust Contract Monitoring, ONS datasets (VS1-VS4 & VS4D), Census and Public Observatory Data. Experience of Unify2, CIVICA SLAM within Acute and CSU environment in terms of creating models in relation to loading data, for actual activity and plan data, calculating models and creating reports for internal finance stakeholders and CCG's, via PDF and Excel exporting. Institute of Advanced Motorists Motorcyclist

Business Intelligence Analyst @ Working in various offices across Oxfordshire & Berkshire in a hotdesk environment, using SQL Server and SSRS (pending training course) to extract data for routine and adhoc reports. Partake in Contract Monitoring of Primary Care Utilisation involving costs as per PBR and National Tariff costs from the Enhanced Tariff Option, Monitoring of NHS 111/999 and Patient Transport Services Performance reports. And Lead Analyst on a variety of projects as of the following reporting for several CCG's: Lead Analyst working on a project with Ernst & Young looking at Elderly Patients aged 65 and over and looking at their cohorts across various CCG's. Lead Analyst on 111/999 and Patient Transport Services, looking at frequent fliers, and identifying patients with Mental Health Issues, such as Substance Abuse, Self Harming, also looking at elderly patients who have had falls, across various CCG's and also working along side Social Services of various Councils in partnership of CCG's to identify at risk patients via Adhoc requests. Lead Analyst on data quality issues, with 111/999, Out of Hours and PTS data, reporting to one main CCG on contractual requirements of data. Working with CSU contract managers and 10 CCG's who want changes with their contracts with South Central Ambulance Trust. Looking at National requirements and local requirements. Assisting with providing evidence of breach of contract so contract team can take appropriate action by withholding payments. Taking part in conference calls using MITEL UCA software. From September 2015 to Present (4 months) Director @ I work through agencies on a contract basis, which allows me to work for various companies around the UK where I provide my skills and experience. As an Analyst, I provide services to organisations where I provide evidence in the form of raw data and graphical representation, I also provide recommendations and problem solving. As a Photographer I have been invited to attend various events around the UK, Europe and USA. Where I have been a guest of the Royal Air Force, French Air Force, German Air Force, US Air Force, US Navy and NASA. And have been fortunate to have several of my photos published in online articles of a leading UK Military Aviation website. Working with Data over all these years and as well as a photographer, I know all to well in how frustrating it is to have corrupt data from power surges, or accidentally delete photos or have corrupt memory cards. Therefore I have obtained various software that recovers a variety of different data types from hard drives and various types of Memory Card. The company was formed in December 2014. From February 2012 to Present (3 years 11 months) Interim Income and Contracts Analyst @ Bought in to replace a contractor, on a short term contract, whilst the trust has recruited a perm member of staff. The trust has recently acquired County Hospital (Stafford). And therefore my role was to use T-SQL to return and reconcile M1 data of SLAM against SUS. However the SLAM data was using 14/15 Tariff and the SUS was using R15 of 15/16 Enhanced Tariff which uses a different grouper and the trusts MFF is different in 15/16. Therefore the patient activity and costs do not match. So i created a fully automated spreadsheet using SQL Server, Excel and the National Tariff data, that would report on the differences between SLAM and SUS, for further monthly reconciliations. Deal with the forecasting of activity by using Forecast Outturn with an agreed percentage multiplier. From May 2015 to July 2015 (3 months) Interim Principal Contracts Analyst @ April 2015, saw the merger of South West CSU, Central Southern CSU and South CSU. During this time, the new organisation went through a significant change with staff. The provider trusts were having problems with submitting their CIVICA SLAM extracts, due to themselves having staffing issues, therefore I was required to step back from my original role, and move forward into supporting the Specialised Commissioning Team. The role encompassed the running of T-SQL scripts and views to provide challenge reports of various providers. Mostly duplicate records, inconstancies of critical care days based on discharge dates and charges for Welsh Patients and also challenges on Drugs which the trust should have applied to the Cancer Drug Fund. Other processes including processing Non Contract Activity Invoices, by requesting backing data. From April 2015 to May 2015 (2 months) Bristol, United KingdomInterim Principal Contracts Analyst @ Validating data of three hospitals of which two trusts use CIVICA SLAM and one doesn't. The trusts all have different headers and different definitions of Points of Delivery (PODS). So taking each trusts monthly submission in tern and then import it into SQL Server 2012, and by using case statements within pre existing T-SQL stored procedures to format the data into the correct PODs and column order. Then import the data in to CIVICA SLAM. Calculate and then load the data into a Cube within the data warehouse. Then using a spreadsheet with slice and dice filters within a Pivot table and reconcile the activity and costs against SUS and Plan that are stored in a Data Cube. Come the 1st April, hoping that all three provider trusts will provide extracts files via their own SLAM, using the agreed column orders and agreed names for PODs. Also tasked in leading a project involving SharePoint 2007. Because the old PCT used to have an intranet which contained reports for various departments. And the CCG now want the CSU to start providing reports via the intranet. Using Dr Foster to pull data for Benchmarking activity levels by speciality for each CCG and compare against their peer group. Partake in approving Non Contract Activity, by reconciling invoices against SUS data, and request Backing Data when required. From December 2014 to March 2015 (4 months) Bristol, United KingdomInterim Contracts & Performance Analyst @ The CCG pays out on SLAM and not SUS to its main provider trust of services. However the provider has been over performing in both activity and costs from that of plan. My role is to report to the associate director and also the head of finance by producing reports from data mining the SLAM data and report on where the over performance occurs. Reporting on A&E activity at HRG, Age, Length of Stay, Day of Week, out of hours, source of referral and discharge to activity. Look at Inpatient activity to see where patients from A&E have gone, and follow their pathways, and look at the Primary and Secondary Diagnosis, the HRG’s and Trim Point Activity, report on excess trim points, and ensure that HRG’s that fall in to Best Practice Tariff are being charged as such, and not at normal tariff with excess bed stays. The data quality isn’t great, as the provider uses their own inhouse system. Other tasks are to look at Antenatal data and check that those with booking dates, appear on the Inpatient activity, either in the form a live birth, still birth or termination. Where there is no match on the Inpatient, I then report on the ethnicity and GP practice of where the patient resided, as there is a lot of migration activity. From September 2014 to November 2014 (3 months) United KingdomInterim Senior PBR Analyst @ Initially a 9 hour daily round trip working for the largest CSU in England, working from the Bath & North East Somerset CCG office as a member of the contract provider performance team, and working to strict data quality control and report standardisation procedures. I supported a wide range of areas, including SLAM review and validation of YTD and Plan variances, SUS validation to provider contracting reports, Trend reports for contracting and Data Mining analysis for significant variations in Trend, Benchmarking Services from Providers. Contract challenges to providers using monthly processes, supporting routine reports to customers, supporting ad-hoc customers reporting and queries, overseas patient checks and Military patient checks, of which the entire reporting process covers the SLAM data from Royal University of Hospital Bath, Royal National Hospital for Rheumatic Diseases, North Bristol NHS Trust, University Hospitals Bristol, Great Western Hospitals NHS Trust and other contracted and non contracted provider trusts, also providing data reports for Wiltshire CCG and Swindon CCG. At the end of March, beginning of April, my contract was extended, and I was required to work from other offices. Whereby I was then based out of the Gloucester office providing the same quality of reporting to Gloucester CCG. I have attended a Tableau training course within Desktop Fundamentals and also Desktop Advanced dashboard reporting, hosted by a 3rd party training company. So I can partake in creating interactive Dashboards, as the CSU is now rolling out reporting Dashboards, modelled on 'Stephen Few's ' dashboard modelling techniques. I was also sent on an SQL Server Refresher training course with full Microsoft training manual. With various CSU Finance and Contracts staff having transferred to their respective CCG's employment. My role has seen an increase in SQL Server involvement. From January 2014 to September 2014 (9 months) Interim Contracts & PBR Analyst (4 Extensions) @ For 26 weeks I worked within a busy Finance department during a Trust Turnaround. My role was to ensure that the trust maximised it's income from it's agreed activity. Ensuring that all the activity data from the hospital datasets (Inpatient, A&E, Outpatient, Antenatal, Postnatal, Community, along with CAMHS & High Cost Drugs within Adhoc Block data) are loaded into a CIVICA SLAM system. Using the 2013-14 PBR Guidance to ensure that the data quality is of a high standard so the extract files can be sent to 14 CCG's who commission services and also the non contract activity for other trusts. Tasked with other activities which involve ad-hoc reporting on activity and costs from Elective & Non Elective excess bed days to Readmissions & High Cost Drugs, along with sensitive data requests such as Child Protection. Dealing with PBR queries from CCG's and replying with backing data, checking that the correct tariff has been applied and looking to see if the trim point PBR tariff reduction guidelines are being applied if a patient has been discharged within the Trim Point. Comparing 13/14 National Tariff with 14/15 National Tariff and reporting on the differences of costings and Trim Point changes.Using Excel 2010, Partaken within financial reporting and data modelling. For 12/13 the Trust was reporting over 302 UCodes (UZ01Z) for planned activity, the reports I was producing for 13/14, I was only reporting less than 20. I was also tasked with looking at what the hospital charged for it's amenity beds, and compare the cost against what other trusts in the area charge and then look at what other trusts in England charge. My findings were put forward, and the trust is reviewing it's amenity bed charges. The Trust has now appointed a new perm member of staff. From July 2013 to January 2014 (7 months) Interim PBR & Information Analyst @ Receiving SLAM data from 11 trusts around the Greater Manchester area. Importing the files into the CIVICA SLAM System by creating a model and PBR tariff year. Calculate the model, and produce standard and detailed reports, along with Calculation Result queries Plan v Actual. Then export the files into CSV format. Then update the monthly summary reports in POD order. And then pivot the data for each trust and update templates. Also required to download SUS PBR files from their source and using the DTS tool in SQL Server, upload the data to the server. Also required to monitor activity and perform comparisions of trust v England using the NHS Comparators system, for Commissioner and Provider views. Query SLAM and SUS extracts, in terms of invalid nhs number, invalid gp, multiple attendances. Month1 queried over £3m of activity for 1 trust alone. From May 2013 to July 2013 (3 months) Recovering from a RTA @ Whilst recovering from a Road Traffic Accident. I am currently updating my IT skills and also obtaining new IT skills. I have received training dvds in SQL Server 2012 and also PHP Programming. This training is ongoing. From March 2013 to May 2013 (3 months) Interim Information Analyst - Ambulance Commissioning @ Inherited 15 reports which covered 11 PCT's and 23 Acute Trusts,of Ambulance Daily Turnaround and Handover Reports, Weekly Sitreps, Weekly Handover and Turnaround Reports, 111 Activity Reports, Control Aided Dispatch, which is data extracted from East Midlands Ambulance Service and then I uploaded on to SQL server via Datamapping via the Import Tool. Report on the Monthly SLA and Forecast, using Forecast Outturn formulae to predict forth coming activity and costings. Attended meetings around the East Midlands with the Contract Development Group answering any questions to other trusts about the EMAS data we received. Also reported on the Ambulance Quality Indicator Reports from data supplied on the Department of Health website. Updated performance dashboards and email out daily performance packs to NHS trusts within the East Midlands. From February 2013 to March 2013 (2 months) Interim Performance Analyst @ The trust had an Information Analyst who refused to enhance their personal development within the job role, and in the end partake in a malicious act. I had been involved in identifying what reports this Analyst was involved in, by requesting the IT department to go through their backup data of the network drives where the analyst had created or updated files, and what processes they undertook, as there was no documentation, I sent out emails to ward managers and department heads enquiring if they were expecting any reports, and arrange meetings with these stakeholders, where I then had to "Reverse Engineer" reports as some of these reports were also weekly and monthly reports. I uncovered a lot of duplication and a waste of processing time of reports, that were created elsewhere within the trust, and also I had identified several databases that contained redundant data. I also inherited standard weekly/monthly/quarterly reports from Waiting Lists (PTL's) including 18 Weeks, non patient attendees (DNA's), to consultant activity. Of which I streamlined queries as some reports were taking too long to run, also created new processes and updated documentation as and when I was introduced to new reporting procedures. Used MS Access with SQL and amended forms and command buttons, created new queries and macros. Using Excel to create and update exisiting dashboards, and where possible returning data via SQL Views via ODBC links in Excel for quicker processing time, as I had sucessfully reduced a report which took over 2 hours to put together to be run, formatted and distributed within less than 30 minutes, by allowing Pivot Tables and charts to be automatically updated. This role was a refresher to update and reskill within Information & Performance. From August 2012 to January 2013 (6 months) Interim Maternity Information Officer (Public Health - Information & Intelligence) @ Following on from my 7 months as a Public Health Information Analyst with Solihull. Whilst this was a Band 7 role, I had been assigned to deal with Breastfeeding Data collated from 3 local hospitals and 74 GP Surgeries. Producing quarterly returns, as performance has been very poor for Sandwell. Since my appointment, the breastfeeding co-ordinator had left and I successfully implemented a data capture process, which has helped Sandwell meet and exceed Quarter 3 & 4 of 2011-12 and Q1 of 2012-13 breastfeeding targets. I was also tasked with producing reports on Child Mortality as Sandwell has the highest Child Mortality Rate compared to the Average of the West Midlands and England & Wales which is now on a decline. I was working on several social depravation projects as Sandwell is the 14 most deprived Council area in England. These projects include obtaining data from the Office of National Statistics and the NHS Perinatal Service for reporting nationally along with providing data for the Local Authortiy. I was also working on various data requests which involved geocoding and thematic mapping. As I was exposed and gained experience of MAPINFO Version 11 via bite size sessions with the deputy head of Public Health information & intelligence using existing documentation to produce thematic maps based on given criteria as well as Breastfeeding data using layers and 1:25000 and 1:50000 maps, Producing reports on Live Births, General Fertility Rates by Wards and mortality rates. From January 2012 to August 2012 (8 months) Voluntary Data Analyst - Market Research @ Whilst in the period of unemployment I have offered my services to Kings Meadows Enterprises where I have created a MS Access database to capture data from Market Research feedback from an online Survey Tool called "Survey Monkey". Kings Meadows Enterprises is a small organisation based within St Saviours Church in Nottingham, and are looking at ways of generating more income by utilising various parts of the buildings in terms of Cafe, Soft Play Area for under 8's, Football and Basketball courts and also rooms for educational workshops. Developed SQL script within MS Access to capture data from hard copy surveys as well as capturing data from the online tool. Then setup MS Excel to run the SQL script within Excel to import the raw data. Create Pivot tables on specific criteria. Perform data analysis and provide visual analysis in terms of graphs and detailed text to place into Information Packs ready to promote the scheme to potential sponsors and stakeholders. From April 2011 to March 2012 (1 year) Nottingham, United KingdomInterim Public Health & Performance Information Analyst @ Working as the only Public Health Analyst within the trust, I have quickly got up to speed in understanding the Public Health Services and their Data sets within SQL Server 2005. Services such as Sexual Health (Sexual and Reproductive Health Activity Dataset - SRHAD formally known as KT31, Contraception, Smoking Cessation, Weight Management Levels 2 & 3 formally known as Obesity, Breast Feeding and others to produce reports and returns. Forming links with Stakeholders such as Commissioners and Service Managers via face to face meetings at various locations to identify data for reports and contractual reporting and Metrics. Collect reports and types of data used and reverse engineer reports and recreate reports using SQL Server to link tables together to maintain and create views. And import data into Excel to create Dashboards and Contract monitoring reports in the form of Balanced Scorecards for Commissioners and Trust. Upload reports into Sharepoint and also format reports so they can be read on Apple Ipads in meetings. Apply LSOA mapping to postcodes for GIS (MAPINFO) so the local council can create maps. Send out CAP's (Corrective Actions Plans) to services so they can identify the reasons why their monthly performance is below par and state what action they are taking to resolve the issue to prevent it happening next time. Reporting on new CQUIN metrics for Alcohol & Smoking for Weight Management, Diabeties, Smoking Cessation and Respiratory. From June 2011 to December 2011 (7 months) Interim Contract Information & Performance Analyst @ Using Dr Foster to assist with the reporting of Practice Based Commissioning of the different GP consortiums around Nottinghamshire. Produce Funnel Charts to show where GP activity is derived from, and where budgets are being exceeded. Chosen by the Head of Finance as the Lead Analyst on a project that looked at specific care of patients involving a 3rd party supplier, using basic Contract Monitoring analysis I found a potential saving of over £1 million pounds over Three years as the Trust was being charged for patients that were not within the boundaries of the contract. Received training in SQL Server Express which allowed me to provide analysis of hospital provider activity of various specialties in terms of SLA’s and also Choose & Book activity against other GP consortiums. Using the Audit Commission website to look at provider performance and look at ways of saving money. Mostly in terms of Excess Bed stays v Pre Op Bed Days. Which showed over £600,000 in excess bed days for two providers. From May 2010 to September 2010 (5 months) Interim Contract Commissioning & Performance Analyst @ Reporting to various departments of Trust HQ including Finance, Performance, Commissioning as well as the PCT. Duties were to undertake the observation of the current methods of collecting data for the Trust Board meetings, and assist with developing a Scorecard based on the Contractual Performance requirements between the Trust and the PCT. Identify the Gaps and the processes involved by looking at what current reporting processes are in place and what is required on the Contract and report and update findings to the Performance Manager. Process the Framework Performance Report by capturing the data given by the Information Analysts and Business Analysts which is linked into the Board Report. Look at the NICE guidelines and setup targets for future reporting. Deal with adhoc queries by the Commissioning Manager which involved using Validated Commissioning Datasets of Inpatient, Outpatient and A&E data and also using the HRG Road Tester to group data via the use of an inhouse developed MS Access Database and then loading the files that are created into the HRG Road Tester developed by the Department of Health’s Information Centre. Run reports relating to Mortality, GUM for Sexual Health and standard returns for Sitrep Reporting. From January 2010 to April 2010 (4 months) Interim Contract Senior Information Analyst @ Working along side 2 project managers and commissioning managers. Analysing Inpatient and Outpatient activity and costs of Procedures from the patient datasets of University Hospital North Staffordshire who had an inpatient activity income of £139 million for 07/08. The project is commissioned from the Strategic Health Authority and looks at alleviating 70% of activity from the hospital and distributing it between local treatment centres made up of Health Centres and Community Hospitals and home care saving the PCT money in paying for excess bed days. Producing Data models via SQL in MS Access and Vlookups and Pivot tables in Excel, using ICD-10 and HRG3.5 and HRG.4 data from 2007/08 to 2008/09 and matrices on Pre Trim point , Trim Point and Post Trim Point. Hosting meetings with commissioners from North Staffs PCT, Stoke PCT and Clinicians from University Hospitals North Staffordshire. From October 2009 to December 2009 (3 months) Interim Information Manager @ Working between two teams, my duties were to create Performance reports based on audited data of Cardiac and Stroke activity within the West Midlands and sourcing data from the Strategic Health Authority as well as the West Midlands Commissioning Business Support Agency (WMCBSA). Using SQL in SQL Server Query Analyser and MS Access to interrogate the data. Other duties were to amend Excel workbooks that provided statistical data showing Funnel plots based on Standard Deviation, Standard Error and Wilsons Method covering observations over given population. From July 2009 to October 2009 (4 months) Interim Information Analyst @ Working for the West Locality of the biggest PCT in England. My duties were to update the Monthly Profiles of the 5 biggest Acute Providers from the monthly SLAM reports in terms of Payment by Results (PBR) and non PBR. Also ensuring that the Forecast Out Turn (FOT) for Year to Date (YTD) 08/09 data based on YTD at month 8 does not grossly exceed the actual data. Other activities were to attend the meetings involving the West Midlands Commissioning Business Support Agency (WMCBSA) based at Dudley PCT and go through the queries relating to the data. No experience of HRG4.0 was obtained as the CBSA did all the data validation before hand, however I was given the HRG4.0 codes and descriptions and the 2009/10 National Tariff. From April 2009 to July 2009 (4 months) Interim Strategy Analyst @ Working for the Strategy Directorate reporting directly to the Strategy Director. The trust is applying for Foundation Trust status, therefore my duties were to extract statistical information from the Department of Health website and using the Dr Foster Analysis reporting tool. And inserting the data into summary documents for each Specialty type and Directorate. Check on data quality and ensure that there was sufficient data over the 7 year period of two trusts and merge into one dataset and ensure that there was no gaps or duplication. I also had to sign the new Official Secrets Act for this role From January 2009 to April 2009 (4 months) Interim Information Analyst/Report Writer @ Working for this Mental Health Trust, my duties were to run reports on a weekly basis using MS Access and Excel. These were Weekly Delayed Discharges, Weekly Enhanced Discharges, Quarterly Returns (QM08), submitting Patients with no NHS Numbers to the National Tracing Service. Submitting flat files using Clearnet V5 formatting for SUS data extracts and checking that all the fields contained data, if there was no data, the report was rejected. Contacting Outreach teams in terms of ensuring clients were seen within 7 days from discharge. From October 2008 to December 2008 (3 months) Interim Information Analyst @ Using SQL in MS Access to create ad-hoc queries from a job queue that was held in an email account. Organised the priority of requests, and contacted the senders for more information. The queries ranged from A&E data, Inpatient and Outpatient tables, consultant tables, ICD-10 codes and HRG’s, also used an inhouse system as an end user to run daily and weekly waiting lists as well as 18 weeks reports, working along the side the data quality team to ensure that the data was complete especially where Freedom of Information requests were required. From June 2008 to September 2008 (4 months) Freelance Web Developer/Technical Support @ Working from home, using Dreamweaver to update and upload webpages onto the server, use Imagematics for creating Flash Banners. Provide technical support in terms of using MYSQL Administration on the Fighter Control Server to compact the forum database on a monthly basis. Other duties were to attended RAF bases on a press pass as cover to take photos for the magazine. From April 2008 to June 2008 (3 months) Interim Information Analyst @ Worked on daily reporting for this Trust that provides a specialist service. Using NSTS, PAS Datasets and Enterprise Manager in SQL Server and exporting into Excel to identify missing patient data in terms of data quality and to return datasets for ad-hoc reports as well as Monthly and Quarterly Returns to the Department of Health. Involved in creating datasets using SQL in MS Access via SQL Server ODBC connection for the Audit Commission via 3M. From January 2008 to April 2008 (4 months) Interim Performance & Information Analyst @ Received on the job training to help perform data quality checks on data for Service Level Agreement Monitoring submitted by the hospitals under the trust, to ensure that the data is complete, Comparing SUS and SLAM data, and checking for duplicated data, grouping patient id’s in terms of multiple attendances, and readmissions within 14 and 28 days, identifying multiple N12 issues on a patient level, and then using Vlookup in Excel to merge National Tariff costs in terms of Payment by Results (PBR) and Healthcare Resource Groups (HRG). Process weekly, monthly and quarterly reports, such as weekly waiting lists, as well as provider and commissioner reports as directed by the Department of Health and upload on to Unify2, skills used are MS Access to import tables via SQL Server ODBC connection and using SQL in MS Access import the dataset into Excel and create reports. Also participated in the producing Public Health reports via National Statistics Data such as VS1,VS2, VS3,VS4 and VS5 in terms of Mortality, along with ad-hoc reports including Sexual Health and other Public Health Reports along with A&E Data terms of Trend Analysis. With highlight of the lost Discs at the DWP, I was asked to perform a Risk Analysis Audit for the Chief Executive of the Information department in terms of the Data Protection Act and using the guidelines of Protecting Patient Information from the Department of Health, interviewing members of staff about how they store and transfer patient data, and reporting back to the board. From July 2007 to January 2008 (7 months) Interim Mental Health Database Manager and Senior Information Analyst @ Worked on a high profile project reporting up to ministerial level, involving the assessment of the Mental Health of Reservists who have been mobilised in to war zones since 2003. Assisted with the development of secure databases developed in MS Access with VBA to record the details of each reservist. And then produce high level reports and other statistics using Excel, MS Access and SQL. Because of my NHS background I had full security clearance to access MOD medical records. FMED4, FMED7 and FMED11. Shadowed a Canon consultant in terms of implementing a Canon ADOS system and converted Scanfiles into an ADOS system. I also signed the Official Secrets Act for this role. From November 2006 to July 2007 (9 months) Interim Information Analyst @ Produced daily reports and weekly returns in; A&E data including breaches, Outpatient waiting lists, Daycase and Elective activities, GP referrals, as well as the number of procedures under HRG environment for finance to calculate payment by results. Use the NSTS and Open Exeter online systems as well as OASIS and PAWs to track patients. Also worked on a project using Business Analyst and Auditing skills to produce an overall report of Trust Performance at every level. All using MS Access and SQL. From January 2006 to November 2006 (11 months) Interim Information Analyst @ Tested SQL scripts developed by a third party company to compare numbers of records returned on two systems working in parallel. From September 2005 to October 2005 (2 months) Interim Billing Analyst @ Worked on a project involving the billing of all Thameswater customers, using MS Access, Excel and AS400 to create datasets and plot trends of usage to identify possible leaks incorrect charge rates and illegal use of other water supplies. Used Business Objects V5, in terms of using existing universes for report creation. From July 2005 to September 2005 (3 months) Interim Information Analyst / Project Manager @ Worked in a combined role of Information Analyst / Project Manager , my duties were to work in a team of twelve other IA/PM’s, of whom we were allocated customers of which to conduct a Billing and Cleansing Audit, to locate a combined $300 million of unpaid service features. Duties were to drive Account Managers, Billing Specialists and Implementation Managers of Customer accounts to provide audit data of international customers based in Europe, North America, Latin America, Asia and Australasia that have Networks located at over 3000 international sites. My duties were to ensure data containing customer requirements and billing information were formatted correctly, then imported into Excel for statistical purposes for each customer for auditing and cleansing. Using reporting tools for checking the prices against the customer contract. Apply Rate Table Changes where prices do not match as well as upgrades and also lead daily meetings with customer account teams around the world. Using Excel, Specific Billing databases for different Countries as well as VANTIVE. From October 2004 to June 2005 (9 months) Interim Information Analyst @ Duties were to convert records of pupil assessment tests from Nursery through to Comprehensive Schools from SPSS in to Excel and then migrate them into Access, then use SQL to link each table to the main Education Department Pupil table and locate the unmatched or missing pupils. Record macro’s to automate the removal of comma’s spaces and replace with hyphens and apostrophes. From September 2004 to October 2004 (2 months) Interim Information Analyst @ Analysing Data from Northampton PCT, and related Acute Trusts, producing detailed STEIS and SITREP reports on a weekly basis using Access and Excel. Creating Macros and Pivot Tables, as well as other ad-hoc reports from the trust. Worked on a project that involved migrating older databases and spreadsheets from 1996, and creating new data sets according to the new IT programme standards, apply formatting and make sure that completed data meets the data quality checks, then import validated data into Access database, then check for duplicated data and complete partial postcodes and NHS numbers by cross checking other databases. From July 2004 to September 2004 (3 months) Interim Medical Directorate Data Analyst @ Working on the ECS project, analysing data from A&E & Primary Care Trust datasets, using Access, SQL, Excel and produce statistical reports on patients that have taken 4 or more hours from Admission to Discharge, and state what caused the excess waiting time. Produce Weekly & Monthly Reports comparing previous results to Hospital Board and a monthly report to the Department of Health via the online reporting procedure. Report to Steering Group members of the Trust, by producing a monthly report. Also use COGNOS to manipulate Cubes From February 2004 to June 2004 (5 months) Interim Management Information Analyst @ Using MS Access, SPSS and Crystal Reports to produce reports of all students who are attended courses with the Hereford and Worcester area along with Distance Learning students From January 2004 to February 2004 (2 months) Interim Data Analyst @ Receive data that has no data quality or formatting of dates or postcodes in Excel and Access formats, apply formats and check for duplicated data in Excel, and remove if necessary, convert in to CSV format and import in to Access, assign indexes, create SQL scripts using ALTER, UPDATE, SELECT, FORMAT(), LEFT(), RIGHT(), MID, UNION and INSERT, along with JOIN, INNER JOIN, GROUP BY and HAVING. Produce Reports in Access based on written findings and results of SQL scripts, along with Pivot Tables and export into WORD and Excel From December 2003 to January 2004 (2 months) Interim Purchasing Administrator - Birmingham HQ @ Check and create Product codes on Mainframe database from Purchase orders. From July 2003 to December 2003 (6 months) Interim Database Adminstrator @ Create Access database using Tables and Forms, along with SQL scripts and Parameter Queries. Created Adhoc reports for management meetings on a daily basis. Updated Tesco’s own reports using Formulas linking values of other worksheets into Charts, Pivot Tables and using VLOOKUP. From January 2003 to July 2003 (7 months) Interim Database Co-ordinator / Project Assistant @ Created Database for National Programme for IT using Access XP, designing Tables, Forms and writing SQL scripts to return specified data. From September 2002 to January 2003 (5 months) Interim Database Co-ordinator/Project Assistant @ Working on a project involving BP Oil Group for a Video Conferencing & Media Solutions company, I was creating Access databases by importing Excel spreadsheets, to monitor project progress and installation of equipment, project costs and staffing levels. Also using Excel spreadsheets to forecast overall Project costs of Equipment, Staff and Time. Liasing with local freight forwarders on a daily basis, obtaining quotes and creating delivery documentation, reporting to the Managing Directors confirming every stage of the project. From March 2002 to September 2002 (7 months) Interim Database Co-ordinator (Stock Transfer) @ Originally a temp to perm contract, but the Stock Transfer programme fell through, duties were to create an Access database of Council tenants from merging Mainframe files, for pending housing associating for South Birmingham. Using Forms, SQL scripts and reports. From October 2001 to March 2002 (6 months) Interim Database Administrator @ Updated Centro’s bespoke database of Travel Pass users, amended SQL to produce reports From September 2001 to October 2001 (2 months) COBOL Programmer @ Due to restructuring at Midland Software, I along with other employees were transferred across to ZEDA. where I maintained Online and Batch COBOL and IDEAL programs and tested document changes made. From March 2000 to September 2001 (1 year 7 months) COBOL Programmer @ Maintained COBOL HR and Payroll programs on Mainframe, AS400 and PC systems From June 1999 to March 2000 (10 months) Interim Data Analyst - Billing @ Using MS Access & Excel to analyse data from the Billing System on the IBM AS400 Mainframe. From January 1999 to June 1999 (6 months) Interim Works Order Staging Data Analyst @ Analyse number of new connections and types of Works Orders created. Report on number of disconnections. Using Datafiles from AS400 in Excel and MS Access From August 1998 to January 1999 (6 months) Interim Data Analyst - Store Planning @ Analyse sales and customer data of new out of town stores in MS Access and Excel. Take data from Till Transaction files from AS400 mainframe. From January 1998 to July 1998 (7 months) Interim Marketing Information Analyst @ Whilst gaining IT experience, I worked for Experian via 2 agencies partaking in FT Day work and also PT evening work. Using MS Access and Excel to analyse Marketing data and update company profiles of senior staff for mail shot software. From April 1997 to December 1997 (9 months) Transport Administrator @ During college and university term times, I would be working for a local Transport company, where I would be assisting with transferring data from a paperbased system into an electronic system. This role allowed me to put into practice of using MS Access version 2 and Excel, from what I had picked up at College and Uni. I assisted with creating various databases containing stock for import and export and notibly a database for storing HGV drivers, their experience in what types of Lorries and driving experience they had and also recorded their driving hours. Of which I still have and updated to MS Access 2003. From July 1992 to September 1997 (5 years 3 months) Nottingham, United Kingdom

BTEC 1st Diploma & BTEC National Diploma @ Broxtowe College - Nottingham From 1992 to 1995 Wilford Meadows From 1987 to 1992 Lee James is skilled in: Report Writing, Access, Excel, Change Management, Data / Performance Analysis, SQL, Intelligence Analysis, Data, Microsoft Excel, Balanced Scorecard, Thematic Mapping, Ranges in Thematic Mapping, Contract Management, Frameworks, CQUIN