ANDREW P. MODRAK
Mooresville, North Carolina 908-***-****
LinkedIn www.linkedin.com/in/andrew-modrak *******@***.***
SUMMARY
Finance and accounting professional whose experience includes Big 4, Internal Audit, Sarbanes Oxley, and Corporate Accounting. Proven public/private auditor that has also consulted and mentored others on both technical and functional capacities within the finance area. Organized and able to thrive in a high demand environment, with the ability to collect and analyze financial information, and a drive to become a successful leader.
Corporate Accounting
Financial Analysis
Sarbanes Oxley
Project Management
Internal Audit
Mentor
PROFESSIONAL EXPERIENCE
Ingersoll Rand, Corporate Controllers Group, Davidson, NC 2008-2016
Record to Report Expense Team – Senior Expense Accountant, 2015 - 2016
Provided Senior/Management type accounting and supervision experience within the Record to Report Expense group.
Centralized Corporate and Sector level accounting processes to one consistent process, including Sales & Use Tax, Property Tax, Canada Tax payments, Concur Expense Reporting and Environmental accruals, leading a coordinated effort with US, Canada, European and Latin America tax, accounting, and finance groups.
Inherited new processes, including meeting with previous owners, discussing the processes, looking for synergies and incorporating team ideas in order to consolidate and complete over 80 reconciliations for 25 legal entities.
Trained and supervised 4 new employees at various levels, including employees off site. Taught Oracle, HFM, as well as delegated multiple processes to them, and oversaw their work for their first 6 months while managing new processes.
Served as Subject Matter Expert to all employees to assist in learning new processes and completing current Corporate accounting level tasks.
Senior Financial Analyst, 2014 – 2016
Provided Finance support to Director of Security on company Aircraft. Facilitated on a $5M annual budget, planned and performed monthly variance analysis, provided finance support and usage reports for 8 Executive Team quarterly meetings, third party collaboration and Invoice/Purchase Order management.
Senior Financial Accountant, 2008 – 2015
Increased level of responsibility within the controllers’ group. Initial responsibility was integrating and transitioning the Trane accounting roles with the Ingersoll Rand accounting roles during IR’s acquisition of Trane.
Liaised with and strengthened ties with all Controller’s group departments including Consolidations, Treasury, Tax, Technical Accounting, External Reporting, Pension and Compliance to streamline work.
Performed key variance analysis monthly/quarterly using HFM templates, including Corporate Asbestos Reserves, Environmental Reserves, Executive Insurance analysis, Royalty relationships, and Discontinued Operations, reporting directly to Controller and Chief Accounting Officer.
Team Leader responsible for preparing and approving over 80 monthly reconciliations, as well as the training, transitioning and supervision of staff and senior level accountants.
Subject Matter Expert, SME, for Oracle R12 implementation from Oracle 11i. Used both systems congruently.
Implemented and maintained Intercompany loan schedules, compute monthly interest, record daily cash movement, and input of loan information to Oracle Treasury. Included daily collaboration with Treasury and Global Cash Movement dept. This included Foreign Exchange, LIBOR rates, and recording Future Contracts.
Provided financial support for the Asbestos and Environmental exposure footnotes for 10-Q and 10-K filings.
Managed and maintained over 30 Trane and IR entities including Trane Corporate Ledger and foreign entities. This included journal entries, monthly submissions to HFM and Tax updates.
Statutory Reporting duties for 12 Non-US entities, improved 2 back to approved status.
Transferred several USD and EUR currency Trane ledgers from Peoplesoft to Oracle. Proficient and knowledgeable on both systems, as well as Hyperion Enterprise, HFM, Khalix, and LawTrac.
Maintained over 2000 IR and Trane Corporate Fixed Assets including depreciation and Cost Center transfers. Reduced asset listing by over 200 assets and $250k during physical asset inventory.
Implemented a Software Impairment process and impaired roughly $500k in unused software.
Project leader in mapping of General Ledger chart of accounts to HFM accounts, as well as mapping from Hyperion Enterprise to HFM.
Volunteered as an Internal SOX team tester.
The Siegfried Group, LLP, Short Hills, NJ
Senior Manager, 2004 – 2008
Responsibilities include accounting assistance, internal audit, financial reporting and analysis, budgeting and forecasting, acquisition or divestiture support, and special project implementation.
Ingersoll Rand/Trane
Accomplished timely migration of Trane’s Corporate Controllers group to Ingersoll Rand at its acquisition within 3 months, reporting directly to the Controller.
Documented the Trane Corporate Accounting processes and identified key controls to improve the processes and to minimize the risk of exposure.
Performed the monthly and quarterly accounting close procedures during the transition, utilizing PeopleSoft and Hyperion Enterprise.
American International Group-AIG
Performed detailed analysis of high profile insurance premiums. Insurance premiums included Workers Compensation, General and Product Liability and Auto Liability policies. Analysis included determining additional premium, return premium due client, and specific state tax calculations.
Worked concurrently with Deloitte Consulting on a global reconciliation project which required insured’s claim data utilizing Excel V-Lookup function, and presented in Excel Pivot Tables for Senior Director review.
PricewaterhouseCoopers-PwC
Conducted fieldwork of financial and Sarbanes Oxley audits of key business processes for client, Foster Wheeler Corp, in compliance with PCAOB Auditing Standards. Processes included: Project Acquisitions, Project Management & Control, Revenue, Financial Reporting, Treasury and Procurements & Disbursements.
Performed review and testing of Management’s remediated controls.
Performed substantive audit procedures - quarterly and year end- on various financial statement areas, including Reserve analysis and Debt Covenants, as well as assisting with the completion of the 10-Q and 10-K SEC reports.
Mellon Financial Corporation – Mellon Investor Services - NJ
Project Leader – Internal Audit, 2001 – 2004
Promoted from Internal audit to the Sarbanes Oxley test design and execution team, performing SOX testing in accordance with PCAOB Auditing Standards.
Planned and coordinated internal audits to test adequacy and effectiveness of controls and procedures for various business units including Employee Stock Purchase Plans, Stock Option Plans and Dividend Reinvestments.
Special projects – AML; quarterly pricing analysis with the Fin/Ops Manager on over 1200 Bond positions.
Deloitte & Touche, LLP – NY/NJ
Senior Auditor, 1998 – 2000
Performed substantive audit tests on account balances including analytical review and fluctuation analysis of balance sheet and income statement data, as well as documented, tested and provided recommendations directly to Management for internal controls systems on clients including Merrill Lynch and Custodial Trust Company.
Compiled financial statements and footnote disclosures for 10-K and 10-Q reports for entities with SEC filings.
Audited employee benefit plans in accordance with AICPA guidelines.
EDUCATION
Bachelor of Science, Accounting
Fairleigh Dickinson University, Florham Park, New Jersey
TECHNICAL SKILLS
HFM, Hyperion Enterprise, Oracle R12 and 11i, PeopleSoft, Khalix, Lotus Notes, SAP, JDE, Microsoft Office.