Experience

Tunstall Healthcare (UK)

• United Kingdom
• Hospitals and Health Care
• 200 - 300 Employee

• Database Developer

  • Nov 2021 - Present

  Working as a Database Developer Working as a Database Developer



EV Cargo

• Hong Kong
• Transportation, Logistics, Supply Chain and Storage
• 500 - 600 Employee

• SQL Developer

  • Feb 2016 - Nov 2021

  I am currently working as a SQL developer at our Leeds office. My responsibility to update and maintain an in house ERP system, which is web based. We look after the Data within the Data Warehouse it is built on. We mainly use Stored Procedures, views and SQL queries to transform the logistics data. We use forms to display data on the platform and enable users of the system to update the data as the cargo moves on it's journey. Our job is the problem solve and advise and fix the best solutions. I am currently working as a SQL developer at our Leeds office. My responsibility to update and maintain an in house ERP system, which is web based. We look after the Data within the Data Warehouse it is built on. We mainly use Stored Procedures, views and SQL queries to transform the logistics data. We use forms to display data on the platform and enable users of the system to update the data as the cargo moves on it's journey. Our job is the problem solve and advise and fix the best solutions.



The Mid Yorkshire Hospitals NHS Trust

• United Kingdom
• Hospitals and Health Care
• 300 - 400 Employee

• SQL Developer

  • Apr 2015 - Feb 2016

  Supervising the ETL process of extracting the data from the Trust's Patient Admission System to the loading of the data into SUS. Providing Analysis support to the Information Management Department. Utilising BIDS for creating SSIS processes and SSRS reports. Creating and altering Stored Procedures in SQL 2008. Completing Information Requests involving data extracting down to the episode level using T-SQL queries. Supervising the ETL process of extracting the data from the Trust's Patient Admission System to the loading of the data into SUS. Providing Analysis support to the Information Management Department. Utilising BIDS for creating SSIS processes and SSRS reports. Creating and altering Stored Procedures in SQL 2008. Completing Information Requests involving data extracting down to the episode level using T-SQL queries.



Bradford District Care NHS Foundation Trust

• United Kingdom
• Hospitals and Health Care
• 500 - 600 Employee

• Finance Analyst

  • Jun 2014 - Apr 2015

  Provide expert advice around Activity Based Costing to Senior Managers and Directors. Preparing detailed analysis of patient income using complex methods of calculating cost of treatment. Writing SQL queries to extra and analyze data. Managed data flows for the costing and invoicing of patient activity. Maximising revenue by ensuring all patient activity has been invoiced. Writing Macros to automate processes as much as possible. Produced Service Line Reports that utilised my skills in SQL, Access, Excel and VBA to ensure Directors and managers got detailed reports. Present findings of reports to wide array of audiences including clinical and non-clinical staff.



NHS Yorkshire and Humber Commissioning Support

• United Kingdom
• Business Consulting and Services
• 1 - 100 Employee

• PBR Contracts Analyst

  • Jan 2014 - Jun 2014

  Provide expert advice around PBR to Senior Managers and Directors. Supported the Contract Management function with analytical queries and financial forecasting. Managed the process of producing demand plans for the negotiation of contracts between the commissioners and healthcare providers. Negotiated contracts between providers and the commissioners. Developed useful reports for the management of the CSU and CCG clients. Collaborate between clients and senior managers of the CCGs and the CSU. Wrote SQL queries to extract data from SUS and reconciled this data with SLAM/Trading Reports. Produced detailed analysis of SUS/SLAM data sets and communicated these analyses across the CSU team including directors.



Doncaster CCG

• Assistant Management Accountant

  • Dec 2013 - Jan 2014

  Produced management accounts for Corporate Costs including completing accruals and prepayments. Investigated variances for trend analysis. Developed useful cost centre reports from Trial Balance so budget managers could understand reports better. Produced management accounts for Corporate Costs including completing accruals and prepayments. Investigated variances for trend analysis. Developed useful cost centre reports from Trial Balance so budget managers could understand reports better.



Gleesons Homes

• Sheffield

• Assistant Accountant

  • Apr 2013 - Nov 2013

  I achieved a temporary position at Gleesons Homes. This involves assisting the Management Accountant and existing Assistant Accountant with day to day duties. Including Sub Contractor payments, CIS tax payments, Purchase Ledger payments, sending reports out to Quantity Surveyors, assisting with the transformation from Sun Systems to the new COINS system. I achieved a temporary position at Gleesons Homes. This involves assisting the Management Accountant and existing Assistant Accountant with day to day duties. Including Sub Contractor payments, CIS tax payments, Purchase Ledger payments, sending reports out to Quantity Surveyors, assisting with the transformation from Sun Systems to the new COINS system.



The AA

• United Kingdom
• Motor Vehicle Manufacturing
• 700 & Above Employee

• Direct Sales Force Agent

  • Oct 2012 - Mar 2013

  Following my redundancy from the NHS I took on this temporary role while I searched and found my next role within Finance. Following my redundancy from the NHS I took on this temporary role while I searched and found my next role within Finance.



NHS Rotherham

• Hospitals and Health Care
• 1 - 100 Employee

• Finance & Performance Officer

  • May 2009 - Sep 2012

  Providing complex financial analysis to Managers involving large amounts of data where accuracy and timeliness is important Manipulating data downloads from SUS into an importable format for Civica SLAM system. extracting data from Civica SLAM system and manipulating and analyzing data for PCT Managers, to view Local Delivery Plan and QIPP plans progress. Experience of NHS data sets including HRG coding. Complete Service Level Agreement monitoring and forecasting for three secondary care contracts, which values are £1.8 million, £0.8 million and £0.4 million. Compiling reports for the NHS Rotherham board on latest position, forecast and trends. Monitoring and forecasting of £4.6 million budget of GMS GPs. Completing contract variations. Dealing with queries from Practice managers. Design and implement new Practice Based Commissioning system which provides GPs with indicative budget and real time current spend and forecasting expenditure. Interpreting and explaining variances to managers, offering advice and solutions. Completing various regulatory and internal reports categorsing expenditure for internal and external bodies Creating complex database models and Excel spreadsheets for large data where accuracy is important. Reconciling £300 million of patient activity between two database systems to a high accuracy and detailing differences. Training other finance staff on what Payment By Results is and how to use complex formulas. Providing system administration for Civica SLAM system. Providing presentations and data analysis to GPs and other CSU staff. Apportioning fixed costs to GP Practices. I have used EMIS system for queries.



Sheffield Teaching Hospitals

• Sheffield, United Kingdom

• Assistant Account Manager

  • May 2008 - May 2009

  Providing financial support to Directorate managers. Completing monthly accruals, maintaining cost centres and budget and ledger journals. Apportioning Consultant costs throughout the Trust. Developed key working relationships with directorate managers and providing assistance with financial matters. Explaining and interpreting financial statement to non-finance trained managers.. Monitoring and forecasting spending on junior doctors. Providing financial support to Directorate managers. Completing monthly accruals, maintaining cost centres and budget and ledger journals. Apportioning Consultant costs throughout the Trust. Developed key working relationships with directorate managers and providing assistance with financial matters. Explaining and interpreting financial statement to non-finance trained managers.. Monitoring and forecasting spending on junior doctors.



NHS Assure

• South Yorkshire

• Internal Auditor

  • Sep 2006 - May 2008

  Planning and completing various audits on financial and non financial systems across all aspects of the business Reporting to the Deputy Director of Finance on findings and making recommendations. Communicating effectively with all levels across a range of disciplines ensuring recommendations were understood and acted upon Planning and completing various audits on financial and non financial systems across all aspects of the business Reporting to the Deputy Director of Finance on findings and making recommendations. Communicating effectively with all levels across a range of disciplines ensuring recommendations were understood and acted upon



Miba Tyzack Ltd

• Sheffield, United Kingdom

• Trainee Accountant

  • Oct 2004 - Sep 2006

  Assist the Financial Controller with day to day duties including Weekly Payroll, bank reconciliations, costings, Sales Ledger, month end preparation, control accounts, accruals and prepayments, Fixed Asset Register, dealing with other departments within the company, statutory reports, VAT returns, German VAT returns. Developed a self-reconciling cash book for all three bank accounts. Complete weekly payroll for 150 staff. Completing statutory deductions such as PAYE and NI contributions. Completing holiday pay calculations and holiday pay accrual. Completing year end processes and completing forms such as P35, P60’s and P11’s. Completing BACS payments for wages.