Patrick Driscoll

215-***-****

ad3mn9@r.postjobfree.com

Genesis Healthcare, Kennett Square, PA 2021 - 2023

Senior Financial Reporting Analyst

Provide essential financial planning and analysis and decision support to the consolidated business which is approximately $4B in annual revenues and expenses including acquisitions and divestitures.

Revise and develop the financial performance model for the Inpatient segment of 350 business units across 25 states which is used primarily to navigate the business.

Improve and streamline financial reporting by efficiently utilizing Excel logic within complex financial models.

Participate in survey and report on Government PRF reporting of all business units.

Execute accurate Income Statement, Balance Sheet, and KPI reporting and analytical support for the board review packages.

Run reports within PeopleSoft and report on Revenues, EBITDA, EBITDAR, EBITDARM, and Expenses.

Data querying and reporting skills in PeopleSoft software and analysis of large data sets utilizing Excel logic.

Blackline account reconciliations for key accounts utilizing GAAP.

Highly organized senior finance professional working collaboratively and independently and consistently meeting deadlines.

Effective communicator proficiently handling complex assignments and engaged in the financial strategy of the business.

Essential Utilities (Aqua America), Bryn Mawr, PA 2020 - 2021

Financial Analyst II - Contractor

SEC financial statement preparation experience for footnotes for the MD&A, 10K and 10Q including the basis of presentation, goodwill, taxes other than income taxes, segment information, assets held for sale, and the tie out of the financial statements including the balance sheet, income statement, and cash flow utilizing Kofax Power PDF Advanced.

Develop the goodwill impairment evaluation discounted cash flow models and the accounting memo.

Asset transfer testing for acquired pension and the annual benefit retirement reconciliation and work paper tie out.

Construct the O&M expense, revenue, and capital expenditures survey for the annual census differentiating various line items utilizing excel logic.

Report on and maintain the revenue and expense reports by entity for the finance team.

Assemble the statutory reports for the North Carolina subsidiary including the balance sheet, income statement, and cash flow and supporting work papers including the table of contents, hyperlinks in Word, and glossy for PWC.

Prepare cash flow support files out of Lawson into our Excel master files to support 10Q and 10K.

Produce the business segment financial statements for the regulated versus non-regulated segment for the income statement incorporating new gas acquisition.

Prepare memos for accounting considerations concerning long term debt and accounting for various financing transactions.

Review financial reporting templates for multiple entities for quarter close including the balance sheet, income statement, cash flow, headcount, organic growth, variance analysis, and other key performance metrics.

Key member of the SAP implementation team tracking reports to be configured from Lawson to SAP.

High level of proficiency with large data manipulation (Pivot tables, VLOOKUP’s, INDEX MATCH), and financial modeling.

Highly organized and detail orientated with the ability to multi-task and work in a fast-paced environment.

Strong organizational, administrative, interpersonal, verbal, and written communication skills.

Time management skills with consistently meeting deadlines in addition to ad hoc requests and project management skills.

Prepare monthly account reconciliations when support is needed for multiple entities for PP&E, A/R, A/P, unbilled revenue, and accrued taxes.

Lehigh White Cement, Allentown, PA 2018 – 2019

Senior Accountant - Contractor

Consolidate financial statements from plant accountants for the monthly reporting package for the leadership team.

Manage audit from KPMG with tracker in Excel and provide financial statements, work papers and queries from SAP.

Prepare AR aging reports 30/60/90/180+ and templates for sales executive team by region.

Prepare working capital, capex, balance sheet, income statement, and executive summary.

Prepare cash flow budget, prior year, and monthly variance analysis. Prepare fixed asset reporting and ad hoc analysis weekly for various teams. Prepared AP spend by vendor as a new metric and current cash position for cash flow analysis.

Key member of SAP integration team for controlling and finance areas.

Prepare DSO analysis, sales volumes, terminal expense reporting, and trade receivables.

Project Consultant, Arizona & Pennsylvania 2011 – 2018

Performed Accounting, Financial Reporting, and FP&A for multiple companies in various industries.

CEA Global, Matrix Medical Network, Brookfield Relocation Svcs, Dun & Bradstreet, Iron Mountain, Vanguard, & Advisor Group

Period End Close

Lead or assist all expense, revenue, fixed asset, and intercompany elimination entries for domestic and international portfolios for month end close for business units of $20M or more. Prepare accruals, run rates, purchase orders, and accounts payable month end entries. Reconcile fixed asset sub-ledger, AR, AP, balance sheet, & Intercompany accounts.

Perform account reconciliations, analysis, and special projects monthly and act as liaison for team in field for ad hoc requests.

Perform trend reviews and variance analysis by account and location for key metrics.

Lead SOX process for various entities or portfolios including fixed assets and supported audits for cash by providing cash statements, supporting documents, and work papers. Process returns and record cash disbursements to GL to ensure accuracy of accounts. Maintain schedules and prepare entries for the amortization of prepaid and other assets.

Review the completeness of revenue, and expenses booked each month to ensure all the expenses recurring and non-recurring are recorded and complete.

Research expense variances for both fixed and variable expenses. Prepare appropriate adjustments for review. Analyze budget versus actual and year over year variances for the income statement.

Preparation and review of balance sheet, income statements, cash flow, capex, fixed assets, and supporting schedules and comparative financial information.

Audit/SOX Support

Prepared audit schedules and supporting documentation for domestic & international entities.

Ensured procedures were in compliance with Sarbanes Oxley requirements and maintained documentation for domestic and international portfolios with revenues of $20M or more.

System Implementation

Automated Trial Balance download from Peachtree to implement into NetSuite general ledger.

Conducted UAT (User Acceptance Testing) for 40 business units transitioning into NetSuite general ledger system for $100M company from Peachtree.

Additional Experience

General Electric Trailer Fleet Services

Financial Analyst

Penske Truck Leasing

Financial Analyst

GNC World Headquarters

Staff Accountant

EDUCATION COMPUTER SOFTWARE

University of Pittsburgh PeopleSoft, SAP, Oracle R12, Lawson, Great Plains, Workday, NetSuite, Peachtree,

B.S. in Business Administration JD Edwards, HFM, Blackline, Oracle Financial Analyzer, Hyperion Essbase, Kofax

Major: Accounting, Minor: Economics PDF Editor Advanced, Hyperion Smart View, Business Objects, Business Intelligence, Excel, Word, Access, Teams, Zoom, Google Suite, and Power Point.

Contact this candidate