Shehzad Patel

• Assisting the Finance & Commercial Reporting Manager with the weekly, monthly and quarterly production of KPIs to be provided to the senior management team and Zellis central Finance team.
• Analysing large data sets, summarising into business trends to support business decision making.
• Assisting the Finance & Commercial Reporting Manager with monthly sales-to-revenue analysis.
• Supporting the wider Finance team where necessary with Revenue Assurance, ensuring revenue leakage is minimised.
• Regular reviews of Work In Progress (WIP) implementation projects, ensuring full monetisation of the implementation pipeline as well as ensuring the ageing of the WIP is up-to-date and there is minimal WIP still allocated to Sales.
• Producing weekly reporting and analysis on Churn notifications for the weekly churn calls, as well as monthly churn WIP reporting for Monthly Business Reviews (MBRs) and Board pack submissions for Group Finance.
• Producing weekly and monthly reporting on Sales ARR & FYR performance, including but not limited to, overall performance, performance by person, average deal size, number of deals, and mix of Sales to be signed off by Chief Sales Officer.
• Supporting with production of key metrics and slides required for MBR meetings.
• Supporting the Finance & Commercial Reporting Manager and Chief Sales Officer with quarterly Sales forecast / annual budget / 5 year plan cycles.
• Managing and producing SugarCRM / Power BI dashboards where necessary to provide management with comprehensive management information.
• Championing data integrity and ‘one version of the truth' through full adoption of SugarCRM and reduced ‘off system’ working.
• Acting as a first point of contact for any queries regarding contract processing from the Commercial Admin team.
• Management of New Customer creations within our Billing platform to ensure billing can be raised and revenue collected once services are live.
• Managing / allocating Commercial Admin contract queue as new deals are signed.
• Monthly updates of Existing Contract Value and Indexation Calculators to aid Sales in accurately claiming incremental revenue.
• Other ad-hoc projects and duties as required by the business.

• Support budget holders in the annual setting of service charges
• Produce annual accounts for audited and non-audited schemes in accordance with the group timetable
• Conduct monthly variance analysis of service charge income and expenditure by schemes to ensure costs are allocated correctly and provide commentary.
• Clean, Analyze and maintain large sets of Data in Excel and create financial reports
• To regularly meet and support budget holders and contract managers by providing analysis and scheme performance information highlighting overspends and poor financial management.
• Prepare routine journals to ensure the service charge accounts accurately report income and expenditure and the balance sheet accurately reports assets and liabilities for each period.
• Use the monthly variance analysis to support the production of the Directorate Packs, analysing in month and year to date variances against budget and projection and quantifying the year end impact and any potential impact to future years budgets.
• Advise and train budget holders in matters of financial understanding, service charges and budgetary control;
• Provide information for the annual service charge audit and respond to auditor queries ensuring a clean audit.

• Support Practices and Small to Medium Sized Businesses in Accounting
• Analyse financial data/statements to uncover and resolve discrepancies.
• Exceed targets on UK and Global Averages constantly
• Conduct investigations and testing to provide best experience and resolution to the customer
• Training members of the team on product knowledge and processes
• Showing excellent communication skills to customers
• Ran shadowing sessions to help train colleagues.

This role enhanced my skills further as I got to experience how the public sector works

Below are some of the duties that were carried out on a daily basis:

• Preparing financial documents such as invoices, bills, and accounts payable and receivable
• Completing purchase orders
• Completing financial reports on a regular basis and providing information to the finance team
• Assisting with budgets
• Entering financial information into appropriate software programs
• Managing company ledgers
• Coordinating internal and external audits
• Verifying balances in account books and rectifying discrepancies
• Verifying bank deposits
• Assisting the finance department and senior accounting staff members with various tasks, including preparing budgets, records, and statements
• Preparing annual budgets
• Completing year-end analysis
• Reporting on debtors and creditors
• Handling accruals and prepayments
• Managing monthly budgeting tasks
• Encoding accounting entries for data processing
• Sorting financial documents and posting them to proper accounts