Joseph Daniel Email and Phone Number

I worked for GATAS as a Self-employed on an Adhoc Basis and finished my last assignment as of this moment on 11/04/2024 and hence available & applying for roles in the finance sector. 1. Updated Accountancy firm’s client details on Xero, IRIS Elements Self Assessment Platform and Microsoft Planner. On few occasions issued invoices to clients using Xero, and also scanned client’s invoices and receipts and uploaded to Auto-entry for invoice processing. Contacted client’s supplier by email to request missing invoices. 2. Assisted the manager in process improvement / automation of Client’s working papers in Excel. Contacted different companies (e.g. Adobe, IRIS, myworkpapers, Xero) to research software/system capabilities in order to provide the manager with an overview of what functions would be useful for the accountancy firm to implement. 3. Contacted HMRC and Tolley’s Guidance on a few occasions with the assistance of my manager to acquire clarification on accounting rules and guidance on issues related to client’s accounts and to make note of the details discussed.

1. Assisted in the production of the continuing healthcare monthly and weekly financial reporting. Weekly financial reporting involved in updating the annual projection, budget, client movement figures and updating weekly graphs to distribute to finance business partners situated in Carmarthenshire, Pembrokeshire and Ceredigion. Monthly tasks involved in downloading CHC Database reports on set days to identify currently funded packages and invoices that require to be spilt based on cost and client codes. In addition at the end of every month prepared and submitted a summary of movements in clients packages to a portal shared with council authorities.2. Performed frequent reconciliations between Continuing Health Care Database (consisting of client’s invoices) and the general ledger. In conjunction also performed reconciliations between the general ledger and the projection to date of the client’s package cost. From performing the reconciliations I identified errors such as missing invoices and credit notes, variances in package rates, miscoding of invoices, issuance of invoices outside designated due periods, incorrect invoicing periods and missing inflation (uplift) cost of packages.3. Additional tasks involved in sending weekly New Clients list to the IT department for their accounts to be setup in Oracle.

• Regular day to day duties involve in posting invoices for two of the company's biggest suppliers.• On a few occasions provided support to colleagues by attending phone calls from suppliers who are chasing for payment.• Performed checks in purchase ledger on a few occassions to communicate whether invoices have been paid or being processed to be placed on the next payment run

• Performed the following duties: Posted and reversed monthly accrual journals for utilities and property related expenses such as Rent, Lease Incentive.• Prepared and posted monthly prepayments for building related expenditures (Rates, Security systems, Maintenance) as well other expenditure (stationery, uniforms, marketing).• Conducted fixed assets review related to property and worked in partnership with the FP&A and management accountant to recognize and capitalize fixed assets.• Maintained log of accrual and prepayment activity in Excel. Provide summary notes for important ledger movements when required.• Reconciled ledger balances for accrual and prepayments through comparing ledger postings in MAM with the maintained activity spreadsheet logs.• On 6th Working day of month, allocated costs from central account to local cost center level.• Performed corrective action to resolve miss-postings in ledger per the recommendation of the FP&A team and from the group management accountant

November 2019 to April 2020 : 1st Rotation in Internal AuditMay 2020 to December 2020 : 2nd Rotation in FP&A1. Internal Audit: I assisted my manager remotely in creating and performing new steps in the Audit work program. This was for testing Vendor Contracts to perform a Compliance Audit on the Netherlands Stanley Oil & Gas business. I created a detailed visio flowchart to illustrate Stanley Oil & Gas purchasing process and performed OFAC analysis on Vendors & data analysis on purchase orders and vendor records. Other Audit activities performed include (SOC Audit on Blackline and Ariba systems), Reviewing data samples of (Credit Memos, Cash Disbursement, Cash Receipts, Bank Reconciliations). 2. FP&A Analyst for Stanley Security Europe: Responsibilities included: Analysing Region Daily Sales, Consolidating Day2 Sales commentary from Europe regions on Month End, Running finance reports on month end (Day3 P&L) and Factbook (Detailed P&L) to be provided to European CFO. Performed Adhoc requests such as: (Divestures impact on P&L, Identifying variances in reporting in accounts through drilldown exercise, Europe Sales Rep Headcount report, Consolidating and analysing Business Update Briefing (BUB) to estimate fx impact and distributed this to senior finance managers.

1. Role: Business Data Analyst. Department: Compliance. Main responsibilities involve in screening HHF existing customers against recognised government watchlists (e.g.Gov UK OpenSanctions.org). The process is conducted in order to ensure (HHF) comply with Government Regulatory requirements. This is achieved by identifying if HHF has any dealings with customers who are Politically Exposed Persons or Sanctioned individuals where financial firms are forbidden from conducting business with. 2. In addition to the designated responsibilities, I have also provided Excel assistance to senior colleagues, in the form of creating Pivot Tables & Pivot Charts that update automatically erasing their need to manually update graphs which has helped to improve their productivity.3. In February 2019, my main manager entrusted me with the with the project of designing and executing a procedure which would allow HHF the ability to screen new customers onboarded into the business daily. As another analyst role was awaiting recruitment at the time, I was given additional responsibility to complete the daily screening of new customers on top of my existing duties. In the following month in March, I trained and supervised a new analyst recruited to the compliance team to takeover and conduct the screening of new customers onboarded. 4. In April 2019, I helped my line manager to supervise and delegate tasks between two other Compliance analysts to complete a joint project. The project involved in performing Enhanced Due Diligence (EDD) reviews on the Ultimate Beneficial Owners of the customer’s company which HHF has dealings with. 5. I am also in the process of inputting a Risk Register / (Scorecard) in Excel which would enable the business to distinguish between high risk issues and low risk issues. This distinction would help the business to improve their assignment of the necessary actions and timescales to resolve issues.

Role: Finance Analyst. Department: Finance & Commercial. 1. I also had the opportunity to work for the Customer Support Area Department. During my internship I have used Microsoft Power BI & Excel to build visuals of Gradwell’s Communication & Invoice data, through filtering and managing statistical information such as number and type of customers contacting Gradwell. Furthermore, I have Produced Year on Year Line Charts based on the company’s sales and profits figures as well as Pie Charts and Drill down graphs to illustrate data more descriptively. 2. During my internship I and another intern presented to the managers of the company on improvements to be made to their website operations through conducting a SWOT analysis and analysing competitor’s website. Managers have pursued some of the recommendations put forward.

1. Role: Finance Assistant. My responsibilities included, operating weekly reports on Excel such as Profit & Loss Reports, Margin Trend Analysis of SBU performance. Constructed Excel files to analyse NPD (New Product Launches) & Carryover products (launched 1yr before) performance in EANZ region over different time periods. 2. Recognised as No.1 Top Collaborator in 3 SBD Global Drawing Board Challenges, out of 50,000 SBD employees. The challenge allows employees to submit ideas for new products that the company can create in the aim to sell to consumers/businesses. In the Pet Power Challenge, I had my idea Prototyped and also had the opportunity to collaborate with engineers on building this product.3. Using IT Hyperion Essbase Software, SAP BW, Qlikview, BA&R (Business Analytics Review) software, to extract information needed for financial reports. Converted, pre-existing files from Essbase to new BA&R system to adapt to new financial structures and measurement. 4. Suggested recommendations for software improvements in Finance-IT meetings of the Qlikview System for user-role out. Presented a presentation to 30 people consisting of product and finance managers in the company on explaining Qlikview functions.

1. Role: Accounts Assistant. My work involved analysing and maintaining client accounts and examining financial data as well as investigating and dealing with financial irregularities.2. I used Sage software to prepare financial statements and accounting information as well as to provide a brief analysis of the client’s accounts. 3. Additional duties that I was involved with are : preparing budgets, monitoring client’s business performance through (profit and loss statements), calculating cash books, and Bank Reconciliations, as well as preparing journal preparation for Bank and Accruals.