Data Analyst Accounting

Michael Jay Rosenfield

Oaklyn, NJ ***** 856-***-**** adbdkc@r.postjobfree.com linkedin.com/in/michael-rosenfield

Accounting & Finance Professional

Skilled, highly trained Accounting professional with 20+ years of experience, skill identifying and creatively solving issues, and proficiency delivering accurate reports/analyses in dynamic, high-pressure environments.

AREAS OF EXPERTISE

General Ledger Management

Accounts Payable & escheat

Accounts Receivable & Billing

Financial Statements & Reporting

Month-End Closing & Accruals

GAAP

Process Improvement

Data Analytics

Risk Management

Property / Casualty Insurance

Project Management

Vendor relations

Budgets & Forecasting

Account Reconciliation

Variance Analysis

Fixed Assets & Depreciation

ERP

Regulatory Compliance

PROFESSIONAL EXPERIENCE

STAFF ACCOUNTANT (1990-1996) DATA ANALYST (finance 1996-2010, actuarial 2011-2018)

AAA Insurance (CSAA Insurance Group / AAA MidAtlantic Insurance Group) – Wilmington, DE

1990 – 2018

Prepared financial statements (GAAP, STAT and internal) with supporting schedules and analysis

Reconciliation of assigned G/L accounts, journal entries and transaction flow

Branch profit/loss

Regulatory financial reporting

Provide data for year-end audit and SOX compliance

Support in interpretation and use of data to Financial, Actuarial, Financial Systems, Data Governance, Business Intelligence, Claims, Reinsurance, Product, Reserving, Pricing and other departments

Collaborated on annual budget and monthly analysis of variances

Ensure accuracy of all reporting for areas assigned

Represented financial department on various cross-functional project teams

Developed reports and transactional data pulls providing detailed analyses and reducing month-end financial closing process from five days to two days.

Improved contingent year-end branch profitability process cutting completion time 66%.

Wrote training pamphlet educating new associates on industry terms, policies, and procedures.

Reorganized year-end work papers streamlining state regulatory filing process.

Consulted with IT on financial interpretation when product data warehouse was being built for use by non-IT personnel

Served on team for data migration to new policy administration and claims systems

Extensive mapping of original system data to accounting and actuarial requirements, including regulatory reporting; drafted prototype reports, mostly for claims administration (most of which were adopted) and consulted on the re-write and upgrade of then-existing system reports for claims as part of y2k.

Participated in mapping and testing of the data for the data warehouse financial information and the regular analysis and reconciliation of monthly data.

Participated in the project to automate contingent commissions, by mapping and testing the data component elements

Understand business marketing and regulatory environment and changes therein

Additional experience:

Accounting Manager in commuter airline industry supervising staff across all areas of accounting (Payroll, A/P, A/R, Purchasing, Inventory, and Job Costing)

Develop and implement automated accounting system and payroll accounting system

Review staff deliverables

Implement and enforce accounting procedures

Returns for: Payroll tax, sales/use tax, excise tax

Revenue Auditor in hospitality industry auditing sales, revenue, receivables, and cash flow reports.

EDUCATION & ACCOMPLISHMENTS

Bachelor of Science in Accounting & Information Systems Stockton University – Galloway Township, NJ

Technical Proficiencies Microsoft Office SQL Database Design Data Extraction Guidwire policy and claims AS400 claims Proprietary Software

Microsoft Excel Functions VLOOKUP Pivot Tables SUMIF Array Functions

Uniform CPA Exam passed, not certified

Contact this candidate