Cedrick Allen

713-***-****

*** ***** ***, *******, ** 30315

abmqkg@r.postjobfree.com

SUMMARY

An accomplished results-driven Financial Manager with a broad understanding

of accounting theories and methodologies who's currently expanding

knowledge base with the pursuit of MS Corporate Finance. This energetic

professional is a team leader, with strong analytical and communication

skills and a proven track record of process and efficiency improvements.

PROFESSIONAL HIGHLIGHTS

. Highly skilled in various aspects of finance and accounting

including: Financial Statement Analysis, CAPM Pricing, DCF Analysis,

Firm Valuations Multi-Level Variance Analysis, Financial Modeling,

Gross Profit Margin Analysis, ROI Calculations, NPV Calculations, IRR

Calculations and WAAC calculations, Budgeting, Forecasting.

. Experienced in applying highly quantitative models used to research

and analyze complex data

. Deadline oriented and respected team lead who believes in a job well

done, on time, every time

PROFESSIONAL EXPERIENCE

Senior Financial Analyst

Verizon Wireless - Alpharetta Georgia (Wireless Telecommunications) 2009 -

Present

. Formulate and perform variance analysis on complex financial models

for quarterly sales forecasts and budgets for six regions across South

Area totaling over $2 billion.

. Create Quota Models to assign appropriate sales targets based on

account revenue projections.

. Audit Quota Models for various errors and communicate with Regional

Finance Managers to resolve any issues

. Manage the process of assigning accounts to over 200 Major Account

Managers across the South Area

. Provide sales KPI analysis through monthly trend reports for South

Area Management

. Calculate targets for Retail Sales Managers quarterly incentive

bonuses

. Provide various ad hoc reports for management via COGNOS queries, MS

Access databases, and Excel spreadsheets

Manager of Operational Accounting

Euramax International LLC - Norcross, Georgia (Metal Fabricating Company) -

2007 - 2008

. Performed Month End close including: Posting reversing entries for AP

accruals, Labor accruals, Freight Accruals, Unapplied Cash, and

Utility Accruals. Posting recurring entries to expense Property Tax,

Reserve for Cycle Count Adjustments, Amortize Advertising & Relocation

expense, Reserve for Customer Volume Rebates, and adjust IBNR Reserve.

Posting Inter-Company JE's and reconciliations to accurately state the

balance in various cash accounts including: Lockbox, Disbursements and

Payroll.

. Prepared and analyzed Balance Sheet and P&L and assisted with

consolidation.

. Analyzed, reviewed, and reconciled all Balance Sheet accounts

including: Lockbox, Payroll, Distribution, AR, Allowance for Doubtful

Accounts, Inventory, Fixed Assets, AP, Unvouchered Liability, Warranty

Reserve, IBNR Reserve, Freight Accrual, and Property Taxes.

. Performed journal entries needed to properly record Business Unit

payroll expense. Reconciled the payroll account to bank statement and

performed labor expense and fringe analysis to confirm the expense had

been properly recorded in the P&L.

. Reviewed Inventory reconciliations to ensure the balance in the

accounts were accurate and all JE's were done in accordance with GAAP

and company policy. Assisted Cost Accounting Manager in resolving

various Oracle 11i ERP issues. Assisted the Cost accounting Manager in

calculating the reserve needed for obsolete inventory.

. Reviewed Capitalized Labor and Overhead accounts to ensure that the

balance was properly stated and that the expense was following COS to

the P&L in a manner consistent with GAAP.

. Researched Fixed Asset discrepancies and performed JEs for all STAT,

cost basis and accumulated depreciation balances and reconciled them

to the Fixed Asset Register. Performed Inter-Company JEs to transfer

Fixed Assets to other entities.

. Verified Capital Expenditures were in accordance with GAAP and company

policy and performed stat entries to classify Fixed Asset activity for

the ease of consolidation.

. Created various Access Databases to streamline processes; including

one which acted as a GL cross validation tool

. Assisted in the implementation of Oracle 11i to other Business Units

by loading and verifying their historical GL data.

Plant Accountant

H.B. Fuller - Tucker, Georgia (Chemical Manufacturing Company) 2004 - 2007

. Performed Month End Close including - verifing the accuracy of

transactional data, adequacy of accruals, post journal entries,

perform account reconciliations. Analyzed Production Models for yield

and cost accuracy and error within the Prism ERP system. Prepared a

monthly Manufacturing Variance Report and narrative with charts &

schedules for conference calls with Director of North American

Operations and President of North American Adhesives.

. Performs Recovery Analysis to verify that the budgeted Overhead and

Labor costs will be fully absorbed by newly calculated cost driver

rates. Analyzed and reported on Labor & Overhead Absorption rates vs.

Actual Labor & Overhead Spending and Budgeted Labor & Overhead

Spending.

. Performed General Ledger Accounting and Manufacturing Variance

Analysis for 8 North American Production Facilities totaling $800M

worth of revenue.

. Served as point of contact for Facility Management and North American

Director of Operations.

. Analyzed WIP account for Production Reporting Errors, Usage Variances,

Routing Variances, and Cost not Synched Errors. Reconciled Perpetual

Inventory balance to the General Ledger Inventory Balance.

. Developed financial models utilizing IRR, NPV, and ROI analysis on

proposed Capital Expenditures. Also developed financial models to

illustrate Gross Profit Margin Analysis for "C" volume products

manufactured at tolling facilities.

. Performed Annual Standard Cost Update including - scrubbing &

calculation of underlying ERP tables, calculation and analysis of cost

driver rates, calculation and analysis of new product unit cost, lead

cost review meetings with facilities, and GL entries needed for

inventory cost revaluations.

. Financial Representative for 48 Lean Six Sigma Projects analyzing

projects for financial reasonableness and project impact to the bottom

line.

. Assisted in annual Operating Budget process including: creating

financial models, forecasting future labor and overhead costs, and

analysis of projected cost driver rates.

. Analyzed differences in plan vs. actual production volume variances

and overhead spending variances.

. Participated on various other projects, study groups, Kaizens, and

Greenbelt Projects all aimed at either improving financial statement

integrity or contributing a positive net impact to the bottom-line.

Accountant -Cost Analyst

M-I Drilling- Houston, Texas (Chemical manufacturing company - oil and gas

services) 2000 -2003

Prepared consolidated financial statements and assisted in quarterly and

annual SEC filings for Affiliates and International Entities. Analyzed

Gross Profit margins for Inter-Company sales and performed eliminations of

Inter-Company sales for Corporate Consolidations. Performed analysis for

purchase price, freight, material usage, labor, (Bill of Materials), and

revaluation variances. Analyzed 50 distribution centers, docks, and plants

both domestic and internationally for physical and cycle count adjustments

ensuring full compliance with GAAP. Lead Oracle 11i implementation for

costing team and trained colleagues in its use.

Tax Auditor

Gary Lambert CPA's- Houston, Texas (Specializes in sales & use tax

compliance) 1998 -2000

Prepared detailed reports of audit findings for various Tax Assessors of

Local Municipalities. Planned and participated in the execution of full

scope audits. Tested levels of controls to determine an appropriate level

of risk detection making audits more efficient and concise.

EDUCATION

Masters of Science, Corporate Finance - December 2010

Georgia State University, J. Mack Robinson College of Business

Bachelors of Business Administration in Accounting - December 1998

Sam Houston State University, Huntsville, Texas

A member of Institute of Managerial Accountants

SOFTWARE KNOWLEDGE

Oracle 11i, OPM, SAP, Cognos Finance & Impromptu, Excel, Access,

PowerPoint, Word, PRMS, PRISM, J.D. Edwards, Webex, Power-Steering, ADI,

Discoverer, Concur[pic]

Contact this candidate