Thomas K. Email & Phone Number

Lewes, England, United Kingdom

Lewes, England, United Kingdom

Responsibilities:- Provide high quality reporting and business intelligence from line-of-business databases and data warehouses.- Review the suitability of existing reports and identify potential improvements.- Responding to any issues with our data warehouses and implementing workarounds/fixes where appropriate.Experience Gained:- Reviewing SQL Server query performance and making code amendments where appropriate. - Tableau Server Administration,- Building dashboards using Tableau.- Writing CTEs (Common Table Expressions), Window Functions and Subqueries in SQL Server for business intelligence reports.- Providing training and guidance to other members of the team.

United Kingdom

Responsibilities:- Understanding business requirements and applying data analytics capability to enable insight for both operational and strategic decision-making.- Writing reports and developing dashboards using Microsoft SQL Report Builder for the Mental Health Support Team in Children's Services.- Advising on data quality matters relating to the Synergy database.Experience Gained:- Uploading the Mental Health Services Data Set (MHSDS) to the NHS’ Strategic Data Collection Service (SDCS) on a monthly basis.

Lewes, East Sussex, United Kingdom

Responsibilities:- Keeping our education database (Synergy) up to date in a timely manner, which included using fuzzy matching to prevent duplicate records from being created. - Using SSRS (SQL Server Reporting Services) reports to identify data duplication/errors and correcting these appropriately. - Updating INSET days on our schools database to ensure school holidays are correct on the East Sussex County Council website. - Keeping the data for the Security Incident Dashboard up to date.- Ad-Hoc data project work.Experience Gained:- Writing SQL in Microsoft SQL Report Builder to create reports and setting up subscriptions in SSRS so colleagues received reports on a monthly basis.- Updating existing SSRS reports for colleagues on an ad-hoc basis.- Providing support to users after system upgrade.- Providing data analysis using Excel for the laptop refresh project, which included discussing my findings with the project manager and project coordinator.- Using macros to automate existing processes.- Using Microsoft Access to clean data.- Handling sensitive or confidential information.- Attending team meetings with BI and Analyst colleagues and learning about challenges the team faces such as data warehouse etc.

Eastbourne, East Sussex, United Kingdom

Responsibilities: - Monitoring Spend and Performance in relation to the Apprenticeship Levy and discussing findings at Apprenticeship steering group meetings.- Promoting Apprenticeship Levy opportunities across the council. - Administering ESCC Levy funds to Training Providers via the Apprenticeship Service.- Mapping ESCC Posts to Apprenticeship Standards.Experienced Gained:- Submitting Individualised Learner Record (ILR) Data Returns to the Education and Skills Funding agency (ESFA) on a monthly basis. - Liaising with External Organisations.- Linking various data sets from different sources together.- Using a Management Information System.Knowledge gained:- A substantial understanding of the Apprenticeship Levy funding rules.- Extensible mark-up language (XML) code.

Eastbourne

Main purpose: Providing flexible support to the ISEND Business Development Team.Roles and responsibilities:Improving the Quality Assurance of ISEND Data Reporting by completing the following projects: - Improving our data entry and reporting spreadsheets for evaluations.- Improving our data entry and reporting spreadsheets for recording persistent and overall absences.Providing support to the Education Events team within ISEND:- Mentoring the Business Development Apprentice by delivering training and producing help guides.- Resolving any finance queries that arose.- Raising invoices for our pre-pay training customers.Providing support to the Agency schools payments team within ISEND:- Helping to reconcile our monitoring spreadsheets with their respective budget reports on SAP.- Helping to forecast future spend for the agency and out-of-county schools' budgets.

Eastbourne

Main purpose: Providing finance support to the ISEND Business Development Team.Responsibilities:• Assigning charges to training course attendees using the staff development software SDMS.• Uploading journals using SAP which is ESCC's bespoke enterprise software.• Checking electronic course registers for errors and correcting them.• Raising invoices using SAP.

Eastbourne

Providing finance support to the Workforce Development team. Responsibilities:• Assigning charges to training course attendees using the staff development software SDMS.• Uploading journals using SAP which is ESCC's bespoke enterprise software.• Checking electronic training course registers on SDMS for errors and correcting them.• Raising invoices using SAP.

Eastbourne

Responsibilities:• Responsible for providing financial support to social workers such as the issuing of petty cash and credit card procurement.• Ensuring posting of expenses to the correct cost centres and general ledgers. • Petty cash reconciliation to an ESCC bank account using ESCC’s Excel template.• Reconciliation of travel warrants issued in Excel using the VLOOKUP formula. • Using ESCC’s bespoke database ‘CareFirst’ to set up service package agreements and to assist with financial postings.• Reducing expenditure postings to team cost centres by charging VAT to the VAT account.

Lewes

Responsibilities:• Responsible for raising purchase orders for three departments: Economy, Transport and Environment, Governance Community Services and Public Health. • Deletion of unused commitments on purchase orders so managers get accurate reading of what is available to spend when budgeting. • Reconciling purchase orders that have imbalances on SAP so that goods received match goods paid for.Experience gained:• Providing feedback on transaction processes, for example suggesting improvements to ESCC’s requisition for goods and services form.

Birmingham, United Kingdom

• Operating a point of sale system and resolving self-service checkout issues.• Transporting goods using supermarket cages to restock shelves. • Operating an industrial cleaning machine.

Surbiton

Responsibilities:• Responsible for managing two paid employees in addition to my Business Development Assistant duties. Accomplishments:• I led two people on a project to build a 3D version of a learning centre.

Surbiton

Responsibilities:• Writing a business plan for the firm. • Supporting the company director in bid writing. • Assisting new Second Life users.• 3D Modelling

Brighton, United Kingdom

This was work experience focused on delivering a project. Responsibilities: • Development of a marketing database using Microsoft Access to be used by Journalist Works to help get more people onto their media training courses. • Working on a 1 to 1 basis with the Operations Director to identify user requirements.

Brighton

Responsibilities:• Using Twitter to promote the Backing Young Britain Campaign, a government initiative with the goal to get more organisations to offer more job opportunities to young people.• Promoting the Backing Young Britain campaign via e-mail to different companies.

Bachelor'S Degree, Business And Management Studies, Upper Second Class

Activities and Societies: Integrated Martial Arts SIFE Sussex (now Enactus Sussex) Enterprise ThursdaysModules completed: Third year.

Cima Certificate In Business Accounting, Pass

C01 Fundamentals of management accounting - exempt C02 Fundamentals of financial accounting - exempt C03 Fundamentals of business.

Education record

Activities and Societies: Young Enterprise HSBC School Bank - Assistant ManagerPost-16: AVCE Business - AA A Level ICT - B GCSEs: Applied.

Higher (Level 4), Data Analyst Apprenticeship, Distinction

Courses attended: Induction and Introduction to Data Introduction to Data Structures and Databases using Python and SQL Data Analysis.