Performed testing of client’s Internal Controls in compliance with SOX 404Performed Roll Forward Testing for 2017 SOX requirementsPerformed Flow Charting of innovative company IT robotics processesPerformed analysis of robotics processes versus human processes and control language

Performed testing of client’s Internal Controls in compliance with SOX 404Performed Roll Forward Testing for 2015 SOX requirements

Analysis of account balances and journal entries in CTI for JDE rolloutParticipated in system cleanup in advance of system conversionPrepared personal property tax renditions for annual filingsPerformed reconciliation of company-wide 401(k) accounts for annual auditPrepared files for annual outside auditPerformed variance analysis and reconciliation of accounts not performed in 3-4 quarters

Heavy use of PeopleSoft ERP systems, Hyperion Financial Management (HFM) and ExcelProvided project services during long-term contract with Internal Controls DepartmentProject 1: Performed follow-up audit of for Internal Controls DepartmentProject 2: Cleaned up internal records pertaining to new ERP system roll outProject 3: Performed testing of new ERP system to ensure successful roll outProject 4: Performed testing of SOX controls and procedures for Q4 2012Project 5: Prepared analysis of rejected submissions to new ERP system

Recovered over $10 million in property operating expenses in review of annual tenant billingsPrepared and distributed financial reporting packages, variance and other reports monthlyResearched and completed property management billing transactionsSetup, prepared and reviewed CAM reconciliations and established recovery best practicesScheduled charges and adjustments to Property Taxes, CAM and Percentage RentProvided guidance to property managers regarding financial and SOX reporting mattersWorked closely with regional and property managers to create and review annual budgetsProvided interpretation of leases for regional and accounting managementMaintained general ledgers, balance sheets and income statements including journal entriesReconciled balance sheet accounts including making correcting entries at month end closeManaged tenant lease data in JD Edwards and PeopleSoft with Excel and Hyperion EssBase

Prepared consolidated financial and statistical reports for executive reportingWorked with the FP&A department to support monthly close and forecast activitiesManaged statistical consolidation of headcount (staffing modeling)Provided analysis of operating results including fluctuation and variance analysisPrepared 10-Q’s and 10-K’s for SEC reporting purposes in $5 B corporationHeavy use of Microsoft Excel, PeopleSoft and Hyperion EssBase

Prepared journal entries, account reconciliations and other schedules for month-end closePrepared financial and statistical reports for executive and SOX reportingParticipated in biannual audit of property, plant and equipment and materialsManaged journal entry records in compliance with SOX standardsPrepared and recorded reconciliations to balance sheet accountsPerformed inventory at multiple manufacturing plants as independent observerAssisted in monthly close including general ledger maintenance and journal entriesHeavy use of Hyperion EssBase in Excel and Oracle Financials