Robert Spencer Email and Phone Number

To have an understanding of the strategic objectives within the Divisions and support them by providing meaningful Business Intelligence.Responsibilities include: • Support clinicians and business leads to understand data and how to use reports to maximise benefits to their service.• Carry out in depth analysis of information held on various databases. Using data query tools and spreadsheets to extract and manipulate the information required.• Support in the design and creation of performance monitoring reports and bespoke and ad hoc reports to customer's specifications and timescales. Understand the divisional needs of the customer, discussing with them their information requirements and making judgements and recommendations on the best way they can be met.• Model scenarios, provide forward projections (what if) and trend analysis as required by the Divisions.• To take responsibility for the completion of Divisional Dashboards, Scorecards and ad-hoc reports ensuring it is of high-quality and meets requirements.• Investigates any discrepancies in reporting to maintain consistency, transparency and accuracy, highlighting any data quality issues to the appropriate managers within the Divisions and to the Data Quality Manager, making recommendations for their resolution.• Participate in any projects by providing the information analysis expertise, providing advice on information management, data quality and availability, carrying out analysis of specific data and making recommendations based on the findings of the analysis.• Ensure procedures are in place to meet target dates for regular reports.• Assist the development of more junior members of team through training and coaching.• To provide support, development and use benchmarking tools and data on a Divisional level within the Trust.• Provide benchmark analysis to Divisional Managers highlighting areas where improvements can be made.

To provide technical and analystical expertise, supporting managers and operational staff in respect of activity and performance data.Responsibilities include: • Develop analytical capability across MCH in respect of performance management of it’s community services.• Processing and providing accurate and timely performance data from clinical and• support services.• Provide technical support for MS Excel and MS Access reporting solutions including both creation of new solutions and maintenance and training for existing solutions.• Advise and support service leads to help improve the accuracy and consistency of their activity recording and reporting and minimise data and information gaps• Take appropriate action or escalation when there are persistent quality problems.• Develop and implement effective models of interrogating and presenting monthly and quarterly performance data across multiple services, highlighting areas for change /investigation.• Support the development and production of accurate and user-friendly monthly service reports that demonstrate performance trends and areas of improvement or decline.• Provide advice, training and ongoing support to service managers and clinicians in the use of datao Communicate effectively with a range of people with a range of IT knowledge and skill (both verbally and written in the provision of guidance documentation).o Keep up-to-date with relevant legislation, policies and procedures and communicate to relevant parties.• Track incoming submissions of information and outgoing submissions of reports against deadlines and chase late submissions of data.• Provide bespoke MS Excel training for our support staff, clinicians and Managers.• Report writing using SQL to extract data from Community Healthcare System databases.

Assisting the Payroll Manager with the delivery of the Personnel/Payroll service, in accordance with approved timescales and procedures. Responsibilities include: • Processing the payroll for around 1300 staff members.• Acting as first point of contact for payroll or pension queries/advice.• Providing MIS reports for budgeting purposes.• Facilitate in rolling out and successful implementation of the 'Scheduled Hours' system module for Sessional staff including system testing and training staff members.• Producing year end returns for pension providers.• Keeping up to date with payroll legislation.• Achieved AAT level 2 qualification in payroll administration.

Working in a diverse virtual team, supporting a Bonus Incentive scheme and it’s web-based system, designed to increase productivity and customer satisfaction, whilst saving the company £millions in unnecessary overtime. Successfully contributed towards £1.8M annual savings and achieving above target for maintaining 99% accuracy of data for system users.Responsibilities include:• Collecting and manipulating bonus pay data for reporting & weekly analysis, using Oracle Applications, advanced MS Excel, Access and SQL.• Calculating bonuses where manual workarounds are necessary to timely deadlines.• Preparing and Uploading bonus adjustments, pay rates and benchmarking target measures.• Assist in development and implementation of any new requirements for the system and liaising with off-shore development teams.• Providing 1st & 2nd Line support for web based system.• Acceptance Testing of new Software releases.• Maintain system and data integrity including identifying issues, raising faults, supporting customer issues.• Providing any training/documentation for front-end users.• Help resolve complex data and development issues.• Regularly meeting with the customer, support staff and programmers to discuss ongoing requirements/development.• Design and maintaining the team website.

This role involved assisting in the management of the budgetary process for and on behalf of the Directorate, Finance Controller and Finance Managers within BT Government. Responsibilities include:• Ensuring all budget/expenditure transfers, loads and other changes are dealt with efficiently in order for accurate reporting of accounting data within our own reports and on the Finance Systems.• Production of regular reports relating to P&L statements, billed revenue, aged debt, FTE, expenditure and Capital computing, completed with accuracy and to demanding timescales.• Understanding the numbers and investigate any discrepancies, by drilling down reports using a variety of finance systems.• Perform regular audits on expenditure, and look a ways in how to control/save money.• Controlling and processing of external purchasing, capital and agency spend, and providing general finance support of an ad-hoc nature e.g. reports, issues, advice, queries• Produce and process accruals, journals vouchers, and Purchase Ledger.In this role, I had successfully demonstrated my technical/data handling skills by applying Macros/Visual Basic programming to producing our Cost Expenditure Reports in less than an hour, whereas before they would take almost two days to complete. This in turn has enabled our unit to spend more time on analysing the numbers before distribution, therefore increasing our efficiency. Dealing mainly with Tier 2 management up to Director Level, my work has to be both accurate and to strict timescales. Received a CAN DO Achievement Award for my efforts including a day out at Ascot.

A Commercial Analyst Assistant involved the development and production of regular reports relating to Manhours, Volumes and Productivity for the Financial Analysts and Zone Board. Responsibilities include• Preparation for 5 year Plan and QPB.• Managing and maintain Budgets and pay forecasting.• Produce manpower, cost reports and Weekly/monthly Overtime Forecast reports to timescales.• Produce Operating Statements.• Produce Overtime reports and audit any late authorised time.• Act as Administrator for a Finance system, providing a helpdesk facility for all users.In this unit I gained a wide variety of PC skills, especially a good knowledge of Microsoft Office, in particular Excel, where upon I automated reports, downloading data from in-house finance systems into Excel, using functions such as macros, pivot tables, lookup tables, and some Visual Basic programming. By using these skills to my advantage, most of my reports were produced simply at a push of a button, therefore increasing efficiency.With a keen interest in computing, I volunteered to develop the Finance web site, acquiring skills in using Microsoft FrontPage and some basic knowledge of HTML. I found the challenge both rewarding and interesting.I got job satisfaction in this role since the work I did involved planning and organisation, creative thinking, problem solving, data analysis, financial awareness, and self-management. It also gave me the freedom to teach myself new skills that my Manager considered me to have a natural ability towards.