Lee Andreae Email & Phone Number

Exeter, England, United Kingdom

Exeter, England, United Kingdom

Exeter, England, United Kingdom

Exeter, United Kingdom

• Produced daily, weekly & monthly performance reports on our activity as the out of hours healthcare provider in Devon & Somerset for NHS England, the clinical commissioning groups, and internal management.• Created new SQL queries in MS SQL server and the Adastra clinical system for use in these and other ad hoc information requests.• Auditing previous NHS reports that we had submitted for data accuracy and integrity.• Created Visual Basic enabled template for the lead trainer to report monthly training statistics and compliance.• Maintained other VB enabled templates to produce reports based on SQL queries.• Assisted the Senior Data Analyst in creating report templates & SQL queries for a new contract acquired by the organisation.

Exeter, United Kingdom

6 month fixed term contract, extended by 1 month. Tasked with the following projects: - Using disparate sources, including various database systems and multiple excel sheets, create a dashboard detailing all work undertaken by the South West office organised by company values.- Carry out an analysis of defects reported on the Clixifix database on behalf of the Head of Customer Services; results then summarized for the Managing Director in order to determine rewards due under the Site Managers’ Incentive Scheme. Visual Basic enabled template created for the Head of Customer Services' weekly report.- Analyse current reported build times and create a new excel based Build Release Monitor to assist sites in reporting their progress to head office in a more timely and accurate fashion.- Create a workbook detailing all staff training requirements and highlight/list any mandatory training that is due and provide montly stats on training days/costs for the Training Coordinator.- Produced contract cash summary on behalf of the Commercial Director detailing the cash position for all projects.- Compiled database for all projects past and present; detailing GDV, margin, unit numbers, affordable/private mix, etc.- Assisted the Commercial Analyst in the creation of a Build Sales Forecast Sheet.- Created reporting template for the Development & Communities Coordinator.

Exeter, United Kingdom

Responsibilities include all the same as R&R senior consultant and also:Time and motions studies across the entire case management assistance centre (CMAC).Assisting all team SMEs with the training, designing and implementation of new and improved processes.Reporting alongside the MI team to the Senior Leadership Team (SLT) on all aspects of the business conducted within CMAC.Designing processes & reporting functions for the implementation of new contracts from the DWP.

Exeter, United Kingdom

Responsibilities include all the same as PRaP Officer and also:Assisting the Revenue & Referrals SME in the implementation,designing and training of new processes.Designing and implementing iMacros to replace data entry tasks below.Reporting all revenue monthly to the finance department & reconciling performance for the performance analyst.Designing an MS Excel based calculator to assist in the validation of financial claims.

Exeter, United Kingdom

Responsibilities include: Data entry and reconciliation between the UK Department for Work and Pensions provider referrals & payments (PRaP) system and the Maximus UK case management system.Validation and submissions of payment requests to the DWP.Claim tracking for all payment requests.

Ireland

Organising corporate contacts and shopping centre bookings for the annual fundraising event: Happy Heart Weekend, assisting the corporate fundraiser on an ad hoc basis including organising the corporate christmas mailing and assisted in general admin work.

Exeter, United Kingdom

Organised, managed and led teams of between three and six fundraisers on sites around the South-West of England. Responsible for my team’s sign-up rate, as well as my own, and for organising and planning out the sites where we raised funds. On-site manager, responsible for my team’s comportment and their training if they were not scoring up to standard. My team and I raised a total of £44,000 through our face-to-face work over a period of 3-4 months

Exeter, United Kingdom

Provided phone support for customers of South West Water in dealing with any queries regarding their accounts.

Bsc (Hons), Biological & Medicinal Chemistry, 2.2

Activities and Societies: Symphony Orchestra, Concert Band, Gilbert & Sullivan Society, ExTunes, Shotgun Theatre, Bujinkan Budō.

Education record