Aodán Cummins (Ó Cuimín) (ACA)

Experience

• 

  Park Lodge Hotel, Spiddal, Galway, Ireland.

  Jun 2006 - Aug 2006

  Receptionist and Waiter

  - Worked at this hotel for the summers of 2005 and 2006.- Responsibilities included welcoming guests to the hotel and checking them in, dealing with any guest queries and complaints, answering the telephone and taking bookings, serving and clearing guest meals at large functions. - In addition, was responsible for logging supplier invoices onto the database. - Strengthened communication skills with guests and colleagues through working in a busy, high-pressure environment.

• 

  SeaWorld San Diego

  Jun 2007 - Aug 2007

  Simulator ride attendant

  - Responsible for welcoming guests and explaining what the simulator ride entailed.- Responsible for ensuring the ride cabin was clear before allowing the guests to board.- Explained the safety features to the guests prior to commencement of the ride.- Built up a good rapport with the other employees.- Strengthened communication skills through frequent interaction with the other employees.

• 

  Spiddal Medical Centre, Galway, Ireland

  Jun 2008 - Jul 2008

  Administrative Assistant

  - Administrative Assistant in the local Medical Centre in Spiddal, Galway, Ireland.- Responsible for scanning patients’ vital documents onto the medical centre’s main database, making appointments for patients over the phone, indicating when patients had arrived on the waiting list, distributing relevant letters to each of the doctors, collecting doctor consultation fees from patients and issuing receipts.- Developed my organisational skills through arranging my tasks on a continuing basis.- Strengthened my communication skills through frequent interaction with doctors, other staff members and patients. - Enhanced my computer skills through continual exposure to the Microsoft Access database software package. Show less

• 

  Towers Watson Ltd., Reigate, Surrey, England.

  Sept 2009 - Oct 2010

  Actuarial Consultant

  - Trained as an actuarial consultant in the Insurance and Financial Services sector.- Worked in several teams responsible for looking after a diverse portfolio of clients.- Developed strong knowledge of Microsoft Excel through continued use in carrying out my work.- Had exposure to industry-specific actuarial software.- Developed efficient communication, organisational and teamworking skills by working in multiple teams across different offices.- Achieved three actuarial qualifications – CT1, CT3 and CT7. Show less

• 

  Studio Solas, Indreabhan, Galway.

  Jan 2011 - Jul 2012

  Accounts Assistant

  - Accounts Assistant for four television productions.- Responsible for logging employee contracts, calculating gross wages of the production staff and the actors on a weekly basis, managing the production bank account, administering the petty cash account, issuing petty cash floats, recording invoices received, ensuring payments were up to date and accounting for any cheques issued.- Liaised with the Producer and Production Accountant on a regular basis on matters such as wages, petty cash, bank balances, and cheques required to pay suppliers.- Enhanced my Microsoft Excel skills through regular use in order to manage multiple accounts and budgets.- Worked effectively with members of the various departments through good communication and teamwork. Show less

• 

  Mitsubishi UFJ Fund Services

  Aug 2014 - Jun 2015

  Trainee Fund Accountant

  Responsibilities:• Assist in the preparation of Net Asset Value (NAV) calculations for various funds at various NAV cuts.• Accurately process transactions on the internal accounting systems as required.• Reconcile the cash balances of the funds.• Prepare schedules and reports for review by senior colleagues in accordance with organisational controls.• Adhere to deadlines set in Service Level Agreements.

• 

  HedgeServ

  Jul 2015 - Mar 2016

  Fund Accountant
• 

  DHKN

  Apr 2016 - Dec 2019

  Trainee Chartered Accountant

  • Trainee Chartered Accountant with DHKN Limited in the Galway Financial Services Centre.• Broad range of experience including Accounts Preparation, Audit, Corporation Tax returns, Income Tax returns, VAT3 returns, RTD returns, P30 returns, RCT returns, financial projections.• Work to deadlines throughout the financial year for the various tax heads mentioned above.• ACA qualification obtained on 31/12/19 with Chartered Accountants Ireland.• CAP2 results Summer 2017: Audit & Assurance – 69%, Financial Reporting – 72%, Taxation (ROI) – 75%, Strategic Finance & Management Accounting – 71%• FAE results Summer 2018: FAE Core – 67%, FAE Advanced Performance Measurement – 65% • Strong communication skills and IT skills. Experienced user of Sage 50, Relate Accounts Production (RAP), Alphatax and the Revenue Online Service (ROS)• Advanced Excel skills. Working knowledge of Excel functionality including Pivot tables, VLOOKUP, HLOOKUP, IF statements, SUMIFS function, MATCH function, nested MATCH with LOOKUP functions, conditional formatting, Data tables (What-If analysis), Array formulas• Intermediate VBA knowledge. Have learned to write VBA code to calculate the present value of a Bond based on its Yield to Maturity and Coupon payments. Have also learned VBA code to produce a Variance-Covariance matrix using nested For Loops• Firm interest financial modelling Show less

• 

  Veryan Medical

  Nov 2018 - Apr 2019

  Finance Assistant

  • Secondment for a period of 5 months in the medical devices industry as a Finance Assistant with Veryan Medical Limited.• Assisted the Financial Accountant and Finance Director on a broad range of Finance tasks including:- Invoice input on Sage 50 across 4 subsidiary companies and multiple currencies (EUR, GBP & USD).- Accounted for Intercompany transactions between subsidiaries as appropriate. - Updated FX rates as appropriate for each month.- Took responsibility for Creditor payment runs using Sage 50 reporting in conjunction with Excel pivot table functionality to make the process as efficient as possible.- Prepared the relevant online banking creditor payments for approval by the Finance Director.- Matched the online banking payments to the excel workings by pasting from the online banking portal to Excel and using appropriate Excel NUMBERVALUE functionality to enable easy comparison to the Pivot table values.- Imported Sales details to Sage 50 through the use of an Excel workbook template which used LOOKUP functionality to extract the appropriate information and convert it to a format suitable for uploading to Sage 50.- Responsible for keeping the bank reconciliations up to date regularly for several bank accounts across different currencies in different jurisdictions.- Assisted the Financial Accountant with month end Management Accounts prep including Payroll calculations, Accruals, Prepayments, Fixed Asset Depreciation & VAT.- Assisted the Finance Director with budgeting. For example I was asked to convert a TB of transactions for 1 year from EUR to USD using the appropriate FX rates. I then analysed the transactions under each month using the IF and MONTH Excel functionality to efficiently achieve same. Show less

• 

  Avaya

  Dec 2019 - Aug 2024

  Compliance/Revenue Accountant

  • Compliance & Revenue Accountant in Avaya Galway• Core skill is Advanced Excel knowledge - proven track record of improving excel spreadsheets & templates to drive efficiency and accuracy: Advanced Excel skills including: Pivot tablesPower PivotsVLOOKUP / HLOOKUP / XLOOKUPIF / IFS statements, SUMIFS function,SUMPRODUCT function,INDEX / MATCH function Nested MATCH with LOOKUP functions, INDIRECT functionTEXT / TRIM functionLEFT, RIGHT, MID, LEN functionsSEARCH / FIND / CONCATENATE functionsDATE functionConditional formatting, Data tables (What-If analysis), Array formulas• Responsibilities include preparing Compliance reporting and journals for the EMEA region including R&D entries• Worked on the preparation of Indirect Balance sheet reserves for the EMEA, North America, APAC & CALA regions. Prepared the Powerpoint slides for the conference call meeting with managers from the US, EMEA and CALA.• Responsible for reconciling the Deferred Revenue GL account on a monthly basis. This is a large GL account with lots of activity monthly. Created an excel template with good controls in order to assist in the reconciliation process each month.• Updated 2 VBA macro templates after migrating to a new journal posting portal. This provided time savings for Revenue reporting purposes.• Communication skills have improved through the use of Instant Messaging and Conference Call software. Show less

• 

  Goodman Medical Ireland Ltd

  Aug 2024 - now

  Senior Financial Accountant