BRIAN M. PFLIEGER

ac4gjj@r.postjobfree.com

PO Box 460794 Denver, CO 80246

303-***-****

OBJECTIVE

Manage budget, planning, analysis, data manipulation, KPI, variance, scorecards and reporting

Develop MS Excel applications and business models using complex formulae and Visual Basic code

Consolidate data sources, automate routines and minimize manual processes across organizations

Improve productivity, accuracy, process, accountability and stakeholder results communication

Work with stakeholders; function as an integral contributor to team success and strategy

PROFESSIONAL EXPERIENCE

Consultant - Financial Planning & Analysis, Business Model Development 07/08-05/17

Accommodate and meet all month/quarter/year-end close timeline schedules and related reporting

Provide timely, accurate information, analysis and data modeling to support specific business needs

Work with stakeholders to understand budget inputs, requirements and reporting needs

Conduct deep-dive and root cause analysis, data regression, correlation and business case development

Develop and implement automated financial, operational and statistical data reporting models, process and scorecards; publish variance analysis and reports for actual, budget and forecast

Interface and integrate all source data; perform testing; manage size, calculation and functionality

Eliminate manual process, enable repeatable, automated mass data manipulation, analysis, and reporting

WestRock: Home Health & Beauty, Controller’s Office, Atlanta, GA 02/16-05/17

RockTenn/MeadWestvaco merger and $1.0B sale of worldwide Home Health & Beauty division

Facilitated account mapping, roll-up and consolidation of HHB worldwide operations for WestRock balance sheet and income statement account maintenance and audit readiness

Developed/maintained extensive HHB account level financial reporting vs. prior and budget for 10 US and 65 international entities; $400M annual sales, $40M SG&A

Applied foreign currency translation & balances to worldwide results; maintained foreign currency tables; automated calculation of foreign currency balances for any given user date range selection

AT&T: Customer Digital Experience, Atlanta, GA 04/14-08/15

Designed multi-variable alignment and correlation for focused delivery of $60M IT project impact on subscribers, calls, handle-time, CSAT, web based transactions & interactions; tracked benefits

Managed predictive IT business case valuation, proactive budget gap management; focused business case cost driver impact, enabled business decisions with respect to project cost, benefit, root cause, CSAT and KPI; produced all actual, budget, forecast and variance analysis

2015 delivery of 27% reduction in calls, 5% customer migration to web based customer service

The Coca-Cola Company: Controller's Office, Atlanta, GA 07/11-01/12 & 09/13-04/14

Built MS Excel model for Business Objects FC master data for isolation, selection and formal maintenance of 45 dimensions and 6,000 properties

Designed the master data request form for linking user selection with rules, dimensions, filters and properties facilitating audit protected documentation for formal submission and revision of the Company’s master data mapping and definitions

Guggenheim; Generation Mortgage; Accounting, Atlanta, GA 01/12-09/13

Transformed Accounting for Mortgage Bankers (AMB) GL output into highly functional and automated channel and departmental balance sheet and income statement results reporting

Built and managed Business Objects projection models by channel, product and property type using correlation analysis on funding rates to produce highly accurate funded unit forecasts

Managed annual $90.0M revenue, $50.0M operational expense, $5.0M capital expense, operational planning, budget and variance models

CARE USA; Organization Design, Atlanta, GA 04/11-06/11

Provided analysis and support to executives during an organization re-design

Reached FY12 $80M expense targets (from $100M) and established minimum revenue surplus margins by way of multiple capital and headcount scenarios

BRIAN M. PFLIEGER (cont’d)

MillerCoors; Finance & Brand Strategy, Atlanta, GA 07/09-08/10

Developed and maintained automated southeast region 70M case annual sales volume, variance and scenario optimization reporting by channel, brand, container, package and manager

Designed and maintained $280M financial gross profit results and variance reporting

Delta Airlines, Finance, Atlanta, GA 07/08-06/09

Northwest Airlines merger; developed 2009 $225M budget expense requirement for 25 divisions; posted monthly closing GL entries; completed monthly accrual reconciliation by age and account

Maintained $75M prepaid risk/liability calendars and respective cash flow reports

AT&T / BellSouth (regular employee), Internet Services, Atlanta, GA 10/98-06/08

Senior Manager - Financial Planning & Analysis

Secured $150M annually in budget required for worldwide customer care call center operation

Enabled statistical performance analysis for worldwide call center volume placement

Designed predictive business case valuation, proactive budget gap management, end-to-end automated business modeling and reporting; enabled business decisions with respect to project cost, benefits and KPI; internal patent applied

Developed & managed $50M IT capital portfolio selection, funding and benefits tracking, budget, planning forecasting and variance analysis; communicated performance through multiple mediums

Created & implemented process driving accountability & the first broadband customer care operational balanced-budget

Audited, accrued & payed $10M in monthly invoicing for worldwide call center locations

Achieved net-30 payment of worldwide invoicing, resolved invoice discrepancies/disputes

EDUCATION / INTERNSHIPS

University of Cincinnati, BBA Finance, Cincinnati, OH

Internships: The Chicago Board of Trade, Chicago, IL; The Cincinnati Gas & Electric Company,

Cincinnati, OH

MILITARY: U.S. Army, Battalion Administration, Headquarters, 3rd Battalion, 35th Field Artillery;

Frankfurt, Germany

SOFTWARE: Hyperion Essbase, MS Office (Excel expert), SQL (training), JD Edwards, AMB, Business Objects, SAP, Oracle, Crystal

Contact this candidate