Uploaded File
Andrew
andrew.mcilrath@gmail.com
904-718-9344
Jacksonville, FL 32266
Internal Auditor
5 years experience W2
0
Recommendations
Average rating
99
Profile views
Summary

Motivated and experienced accounting professional. Supports a risk-based departmental audit charter including external audit assistance involving Sarbanes Oxley and Substantive testing, domestic and international assurance and consultative engagements to increase efficiency and mitigate risk in a highly regulated environment. Experience in financial statement review, IT auditing, corporate accounting, inventory accounting, operational and physical inventory counts and new accounting system implementation. Excellent written and verbal communication skills. High level of analytical skills and high aptitude for learning new systems.

CORE COMPETENCIES

  • Oracle
  • Hyperion
  • Tableau (Tableau Desktop Specialist)
  • SQL (Limited)
  • TeamMate Analytics
  • Microsoft 365 & Office 2016: Excel, Visio, Word, etc

Experience
Internal Auditor
Information Technology
Aug 2018 - present
  • Test and document manual and application controls for Canon USA, Inc. and applicable subsidiaries to provide assurance that operations and significant risks are mitigated
  • Perform Sarbanes-Oxley testing on behalf of the external auditor to meet SEC reporting standards. Produced annual cost savings as a department averaging $1 million or more for Canon USA, Inc.
  • Plan, execute and close business critical audit projects reporting findings to Senior Management and provide improvement initiatives to Canon USA, Inc. and applicable subsidiaries
  • Act as a business consultant for our business units and subsidiaries, leveraging data and utilize data analytical software and tools available to analyze complex data, solve problems and streamline work processes. In Tableau, I have created a Sales Cutoff Analysis Toolkit for our Latin America subsidiaries, Monthly Activity dashboard for the Logistics department and assisted in multiple Logistics KPI and Freight Spend & Claim dashboards
  • Assist in continuous monitoring efforts such as T&E expenditures and duplicate payments, reporting findings to Accounts Payable and Senior Management if necessary
  • Lead and completed Gartner's Internal Audit Headcount and Budget enabling our organization to improve functional performance by assessing their strengths and weaknesses
Auditing Sarbanes-Oxley Mitigation IT Audit Financial Auditing Operational Audits Tableau GAAP
Remove Skill
Accountant
Information Technology
Jul 2016 - Aug 2018
  • Support monthly/quarterly/year-end closings by preparing journal entries, monthly account reconciliations, and analysis for Canon USA’s divisions, departments, subsidiaries and affiliates
  • Assist in inventory accounting for Canon USA and subsidiaries in the following areas: Estimated Cost, In-Transit, Cost Variance, WIP and physical inventory counts.
  • Coordinate with internal and external auditors to complete Sarbanes-Oxley testing and suggest improvements where necessary.
  • Selected to implement new accounting software for one of our medical subsidiaries. Tasks included create manuals for day-to-day accounting activities, transferring financial statement data and fixed assets, testing automated processes such as cash sweeps, depreciation etc
Accounting Auditing Reconciliation Sarbanes-Oxley Cost Accounting Hyperion
Remove Skill
Accountant
Dec 2015 - May 2016
  • Collaborated with Property Managers, Regional Property Managers, Assets Managers, and Portfolio Accountants within assigned portfolio to ensure activity is recorded and reports prepared within client requirements
  • Prepared monthly financial statements for assigned portfolio
  • Exercised strong ethics, professional skepticism and independent judgment relative to timeliness, recognition, classification and analysis in accordance with GAAP
GAAP Budgeting Accounts Payable Accounts Receivable
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Accounting and Finance
University of Central Florida, 2012 - 2015

Member of Delta Sigma Pi, Beta Alpha Psi and Tau Sigma Honor Society

Certifications
Tableau Desktop Specialist
Tableau, 2020
Skills
GAAP
2021
5
Accounting
2018
4
Operational Audits
2021
4
Auditing
2021
3
Cost Accounting
2018
2
Sarbanes-Oxley
2021
4
Financial Auditing
2021
2
Hyperion
2018
2
IT Audit
2021
2
Mitigation
2021
2
Reconciliation
2018
2
Tableau
2021
1
Accounts Payable
2016
1
Accounts Receivable
2016
1
Budgeting
2016
1
SQL
2020
1