Company Project
Resume:
Eric Magier, CPA
Denville, NJ **834
*********@***.***
Accomplishments:
. Automated monthly processes with the use of Macros, Vlookups, Pivot
Tables and Hyperion Essbase queries, saving about 4-6 hours.
. Led a team of three in analyzing the expense allocation process which
is used in producing Product Profitability.
. Developed a flowchart showing the allocation process to be used in
allocating expenses by company, a statutory requirement.
Experience:
10/99 - 8/11 Selective Insurance Company
Branchville, NJ
Expense Management Senior Accountant, March 2008 to August 2011
. Performed and reconciled cost allocations utilized in determining
product profitability as well as various other reporting requirements.
. Developed cost studies by cost center which is used in performing
allocations by NAIC expense category for an Underwriting and
Investment expense exhibit and lines of business allocations used in
other various reporting exhibits.
. Lead team member in charge of analyzing the allocation process and
develop efficiencies.
. Performed and analyzed deferred policy acquisition costs calculation
including a cost study to determine at what rate the company should be
deferring these costs.
. Project team member for creating a questionnaire to collect
spreadsheet inventory for end user documentation.
. Tracked the completion of company goals used in determining the
company's ACIP bonus payout.
. Reviewed fixed assets and internal development.
Expense Management Staff Accountant, January 2003 to March 2008
. Project team member for implementing Lawson, a new General Ledger and
Fixed Asset system.
. Tracked and maintained the company's fixed asset inventory which
consisted of 19,000 assets as well as the internally developed
software projects and their related depreciation for the Statutory,
GAAP and Tax books.
. Performing and analyzing the various company accruals and amortization
of prepaid expenses.
. Writing up a monthly analysis of a year on year comparison of the
company's expenses.
Financial Planning Financial Analyst, October 1999 to December 2002
. Collaborate with cost center managers to develop budgets.
. Analyze budget to actual variances to provide explanations to cost
center managers.
. Generated department expense forecasts using a model for "what-if"
scenarios.
. Gold award recipient for regional budget.
. Assisted in answering questions from the company's executives during
budget meetings.
3/98 - 9/99 Welco Gases Corporation
Newark, NJ
Assistant Controller
. Prepare and analyze month & year end income statements and balance
sheet reports
. Analyze budget to actuals
. Maintain fixed assets and their respective depreciation
6/92 - 2/98 Bellemead Development Corporation
Roseland, NJ
Staff Accountant
. Prepare monthly balance sheets, income statement and cash flow reports
. Monthly general ledger account analysis and reconciliations
. Researched information in leases, common area charges, terms of
leases, security, interest charges and concessions
. Developed and maintained operating budgets for 5 office buildings
Education: Kean College
Union, NJ
B.S. Accounting in 1991
CPA - license #20CC03336200
Computer skills: Advanced Microsoft Excel, Proficient in Word, Access and
Powerpoint, Hyperion, SQL, Lawson, Cognos
Contact this candidate