SIMON S. CUMMINGS

*** ****** ***

Port Chester, NY 10573

860-***-****

Email:ac46xl@r.postjobfree.com

TECHNICAL SKILLS:

SAP FICO, SAP BPC, Oracle Financials, PeopleSoft Financials, Hyperion Essbase Add-In for Excel AS 400, HPQC Testing Tool, SQL-Intermediate, Footprints Help Desk Tool, Microsoft Office Applications (including V-look ups and Pivot Tables)

EDUCATION:

PACE UNIVERSITY - New York City, NY

Bachelor of Science Degree: Accounting

PROJECT DATES:

Rabobank, Dec 2017- March 2018

Sompo International, Feb 2017- November 2017

Guardian Life Insurance, Sep 2016- Dec 2016

A&E Networks, Jul 2016 – Sep 2016

National Grid- July 2011- Dec 2015

EXPERIENCE:

NY Based Accounting and Financial Systems Contractor

Clients Include: Rabobank, Sompo International, Guardian Life Insurance, A&E Networks, National Grid

Senior Accountant

Prepare all month-end close procedures including preparation of journal entries and account certification schedules and supporting documentation with a focus on compliance with internal control procedures and compliance with US GAAP and IFRS.

Prepare commentary and analytics of the daily Balance Sheet and P&L.

Assist with preparation and review of materials gathered for regulatory exams and audits.

Act as liaison for both internal and external auditors and prepare audit trail documentation.

Perform Entity Consolidation processes, intercompany eliminations and analysis.

Liaise with other groups across the bank to review and reconcile the monthly financial data feeds to adequately identify and resolve issues.

Manage departmental accruals and allocating monthly expenses per service level agreements.

Maintain a thorough understanding of business processes, auditing standards, and related risk and control frameworks. Provide ongoing analysis for revenue and expenses for multiple departments.

Update policy and procedures and end-user computing (EUC) documents for all month-end close procedures and certification of balance sheet accounts for assigned account groups.

Generating reports by utilizing Hyperion Essbase Add-Ins for Excel.

SAP ERP Consultant, SAP General Ledger Super User and SAP System Migration Support

Trained 80 plus current and new employees on the SAP Journal Entry workflow process and procedures. Coordinator of all Financial Accounting Help Desk Incidents related to SAP Ensure appropriate procedure documentation exists for all activities processed in the ledger.

Lead testing of remaining open process areas prior to live system implementation on 4/3/2017. Lead the continuous process improvement of the SAP General Ledger system.

Support Finance close activities including system administration activities and trouble shoot SAP issues as they occur with monthly/quarterly processing.

SAP Master Data (GL, Vendors, Cost centers, Profit Centers, Internal Orders, etc.). Business Warehouse and SAP Reporting.

First line of support for SAP FICO users, assist with the SAP conversion by reconciling data between the ECC (operational side of SAP) and BPC (reporting side of SAP) to make sure the numbers are converting correctly.

Assisting with the conversion of fixed assets into SAP.

Wrote step-by-step SAP test scripts for the core processes of the Finance (FICO) Module, identifying and documenting key dependencies.

Collaborated with the KPMG project manager to report progress, issues and concerns.

Employed National Grid user input and consulting group leaders' expertise to validate approximately 251 test scripts for use in SAP test environments prior to live implementation.

Perform unit testing, user performance testing and regression testing.

Assist in mapping People Soft G/L accounts to new SAP G/L accounts and tested for any discrepancies.

Review and reconcile various reports between the old GL ledger and new SAP GL ledger.

Analyzed and identify discrepancies/defects before involving project management and programmers.

Developed the interface procedures for incorporating Inventory Management reporting at the Syracuse location into the National Grid Corporate Balance Sheet.

Identify a 21 million discrepancy between the inventory sub-ledger and general ledger that was allocated to a suspense account due to the migration.

Notify the Controller and KPMG about the tax impact before making an entry to correct this issue.

Trained the inventory group, corporate accountants and KPMG regarding inventory process allocation.

02/2006 to QUEST DIAGNOSTICS - Dallas, TX

05/2011 Senior Accountant

Utilized People Soft for all financial reporting.

Coordinated the month end closing process to ensure accurate, on time corporate reporting and presentation in accordance with GAAP.

Performed Consolidations of monthly results for five Quest labs. Analyzed Billing reports vs.

actual collections to determine accrual estimates.

Performed all accounting duties to support the Oklahoma City and Tulsa labs, including

07/2004 to GELLER & COMPANY - New York City, NY

01/2006 Fixed Assets Accountant

Oversaw recording of Bloomberg fixed assets in offices residing in Sweden, Argentina, Taiwan and United

Kingdom.

Conferred with the auditors from Deloitte & Touche to review current acquisitions, disposals and variances. Monitored the global fixed assets reconciliation process by analyzing the Bloomberg/AS400 systems data prior to inclusion in SAP FICO reporting.

01/1999 to MERRILL LYNCH, JP MORGAN & TIAA-CREF - New York City, NY

06/2004 Accounting Contractor

Managed daily funding reconciliation by reviewing and analyzing daily client funds allocation among secured, unsecured and unregulated accounts.

Alerted Business Finance Investment teams of any differences or deficiencies. Reconciled Global and Domestic net income accounts.

Assisted with special projects.

Utilized SAP FICO, Oracle FICO, PeopleSoft FICO and Microsoft Office Applications.

07/1989 to CENTRAL PARKING SYSTEM - New York City, NY

12/1998 Accountant

Managed Accounts Receivables, Accounts Payables and Payroll departments

REFERENCES: Available upon request.

Contact this candidate