MARC D. MILLER

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

Mableton, Georgia 30126

(moving to Denver)

404-***-****

acn3hv@r.postjobfree.com

WORK EXPERIENCE

Finance Manager – Financial Services, The Home Depot, Atlanta, Georgia March 2010 – November 2014

* Managed financial aspects of Home Depot’s extended warranty business by building pricing and profitability financial models to assist decision makers in maximizing profits while growing the business

* Provided finance support for the operations team with analyses of the profitability of promotional activity, financial impacts of structural changes to the warranty program, and ad hoc data and financial model requests from upper management and field teams

* Performed regression analysis to set appropriate pricing of extended warranties resulting in millions of dollars in incremental sales/margin

* Created key metric reports related to the warranty business including attachment rates by categories and classes of eligible products and calculated profit/loss impacts of the program from both retailer and insurer’s perspective

* Maintained Access databases and produced weekly flash reports of private label credit sales, sales penetration, and private label credit new accounts

* Coordinated accounting accruals/reserves and managed the receivables as necessary for the warranty business

* Utilized SQL, Access and Excel skills to provide financial reporting and ad hoc analyses to Home Depot Paypal and Project Loan financial services teams

* Provided guidance from a financial perspective on the RFP process of selecting extended warranty business administrator/insurer while presenting to senior management the ultimate impacts to total program margin dollars/rate dependent on the selection of the administrator/insurer

* Researched and analyzed other retailer private label credit card programs as well as provided NPV cost/benefit analyses of various options of reducing credit card interchange expenses

Sr. Financial Analyst – Financial Services, The Home Depot, Atlanta, Georgia June 2007 – February 2010

* Managed all financial aspects of bank card marketing programs Home Depot engaged in including building financial models that set minimum ticket and response rate requirements resulting in millions of dollars in incremental sales to Home Depot as well as managing marketing and markdown budgets for optimum performance

* Built financial models analyzing the profitability and feasibility of IT and Operations projects and made recommendations to management as to their efficacy in order to maximize private label credit card portfolio profit sharing

* Forecasted and tracked all sources of miscellaneous income (approximately $40M per year) derived from the Financial Services department’s activities and communicated with Corporate Accounting, FP&A, Receivables and Treasury departments to ensure proper receiving, recording and forecasting of revenue related to those activities

Accounting Supervisor – Consolidations, The Home Depot, Atlanta, Georgia November 2005 – June 2007

* Developed and trained Staff Accountants and Senior Accountants on the accounting of the consolidations process, including the eliminations of investment/equity, inter-company receivables/payables and inter-company sales/cost of goods sold to ensure GAAP and SEC reporting compliance

* Performed fluctuation analysis on consolidated balance sheet and produced relevant and insightful commentary on significant fluctuations for executive leadership team

* Reviewed and ensured the accuracy of key financial analyses including quarterly sales and inventory metrics, ROIC, cash conversion cycle days, and balance sheet analyses

* Reviewed for accuracy and suggested improvements of balance sheet account reconciliations (including SOX, internal audit and financial controls requirements), subsidiary financials, deferral entries, inter-company AR/AP reconciliations

* Trained external consultants for the India entity on Consolidations and GAAP reporting requirements including foreign currency valuation, monthly uploads, financials, and the statutory audit process

* Analyzed, proposed and carried out corrections and adjustments of Home Depot’s United Kingdom entity’s financials for the 2004 statutory audit and ensured timely and accurate completion of the 2005 statutory audit

Financial Analyst American Tower Corporation, Atlanta, Georgia March 2003 – November 2005

* Responsible for monthly financial close activities including journal entry preparation, account analysis and balance sheet reconciliations

* Performed detailed analysis of monthly financial statements and budgets including investigation into unreasonable actual to budget variances and balance sheet fluctuations in order to explain unusual financial activity to the controllers and finance directors

* Prepared and analyzed large portions of the quarter end and year end required reports including parts of the 10Q and 10K reports

* Originated necessary accruals and proposed appropriate unwinding of various accruals to ensure accurate monthly financial statements

* Persuaded internal/external contacts to obtain documentation and authority necessary to close all company petty cash accounts, freeing up over $300,000 in idle cash

* Produced an annual $36,000 of true cash savings by spearheading an analysis of tower monitoring costs

Staff Accountant Dempsey, Myers & Company, Alpharetta, Georgia May 1999 – May 2002

* Analyzed P&L statements, budgets, and internal cost accounting reports to forecast revenues and expenses saving clients millions of dollars in lost business interruption revenue insurance claims

* Demonstrated trends in production, labor, and profit streams to support business interruption claim calculations

* Prepared multi-million dollar ($150M) corporate property damage insurance claims quickly prompting advance payments resulting in increased client cash flows

* Obtained broad exposure in working with a variety of manufacturing and service providers to understand their business operations and reporting processes

Computer Skills Strong Microsoft Excel and Access, SQL, SAP, Oracle, SAS, Teradata

Education Bachelor of Business Administration, University of Georgia, Athens, GA, Major-Accounting, 1999