Sap Life Insurance
Resume:
SIMON S. CUMMINGS
Port Chester, NY 10573
Email:***.********@*****.***
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