Male | | from: United States of America
I am currently in Chicago IL

PAUL ROBERT JOHNSON
659 W Randolph St Apt# 714 | Chicago, IL 60606 | 773.791.2337 | prj111@gmail.com

EXPERIENCE
BLUE CROSS BLUE SHIELD ASSOCIATION Chicago, IL
Sr. Consultant, Financial Modeling & Analysis Sep 2008 to Present
 Projected national Blue labor membership and impact of healthcare reform by identifying high risk groups
 As SME for National Consumer Cost Tool documented and refined the analytics and protocols for creating consumer facing cost estimates and organized the Methodology Advisory Group a multi-Blue Plan panel that makes recommendations on consumer engagement analytics
 Built financial model of the network access fees for the top 30 Blue accounts and recommended new pricing structure for all Super-Jumbo accounts to decrease carve-out risk and reduce total annual fees by $39 million
 Analyzed Blue presence and change in the Fortune 500; the Blues increased membership 8% in 2009
 Automated the Hewitt Medical Discount analysis that benchmarks ranking & discount advantage in HHVI markets and illustrated the new Alt Net areas with an average improvement of 4.4 discount percentage points
 Reported 2009 Win/Loss showing major National Account enrollment changes for net gain of 37,000 lives
 Modeled the BHI cost budget and the impact to member Plans for differences in the Dues based & current BHI Apportionment model highlighting different possible scenarios for BHI Plan membership
SEARS HOLDINGS CORPORATION Chicago, IL
Sr. Financial Analyst, Merchandise Controls & Financial Analytics June 2007 to Sep 2008
 Analyzed $159 million in 1 time buy sales and implemented new upfront analysis & backend reporting to eliminate unproductive inventory for a projected increase in gross margin of $4 to $7 million in 2008
 Produced automated financial reporting for Kmart footwear division, a $650 million business, including profit pattern, sales/margin, assortment/sales balance, top 20 items, and size/market profitability analysis
 Prepared 2008 Plan Variance report comparing new 2008 plan to changes in marketing assets, holiday sales shift, Gross Margin, Ending Store Inventory, and 2007 actual balance of sales
 Executed operating budget challenges as the Acting Business Finance Manager for NYC Apparel Design Team resulting in savings of $4.2 million
 Developed Brand P&L’s for Craftsman, Die Hard, and Kenmore by month to show profitability
ILLINOIS BUSINESS CONSULTING Champaign, IL
Engagement Manager Aug 2006 to May 2007
 Prepared Activity Based Costing analysis of procurement process comparing current and proposed purchasing systems with an annual budget of $1.1 billion
 Conducted a financial analysis & sensitivity model of the secondary tier supply base to the space industry for Lockheed Martin Co allowing them to predict how a decrease in government spending would effect the competitive landscape; final deliverable used as evidence of negative impact when presented to DOD
 Developed a model to assess and quantify the quality drivers for IT investments and outsourcing as an enhancement to the financial analysis and ROI calculation for Allstate Insurance
FEDEX Memphis, TN
Financial Analyst June 2006 to Aug 2006
 Designed a new report to analyze productivity of sales account executives by segment using data on $8.5 billion in revenue and identified clear trade-off between incremental volume and effective discount rate
 Cataloged and analyzed the Executive Information Systems information flow for the Incremental Volume Report, Volume/Yield Forecast, Volume Attainment Tracking, Surcharge Report, and Margins Report
MANCHESTER GRAND HYATT San Diego, CA
Assistant Front Office Manager Dec 2004 to July 2005
 Oversaw and managed front desk operations and financials in a 1,625 room property with 31,000 to 40,000 occupied room nights per month
Assistant Executive Housekeeper Nov 2003 to Nov 2004
 As Acting Executive Housekeeper managed a department of 250 employees cleaning an average of 1,348 rooms per day and responsible for a $900,000 purchasing budget and forecasting for $4.9 million in payroll
 Implemented recycling and green program that reduced trash output by 762 tons saving $34,290 and decreasing laundry cost by $203,000 annually
Corporate Management Trainee Jan 2003 to Oct 2003
PARK HYATT BEAVER CREEK Beaver Creek, CO
Recreation Supervisor Aug 2001 to Dec 2002

EDUCATION
UNIVERSITY OF ILLINOIS Urbana-Champaign, IL
MBA, Finance May 2007
UNIVERSITY OF COLORADO Boulder, CO
BA, Psychology Major & Economics Minor May 2001

ADDITIONAL
I Ace Quarterly Award recipient March 2010 & I Ace Annual Award recipient for 2010
Executive Vice President of Finance, Graduate Finance Association, Jan 2006 to Dec 2006
Proficient in SPSS, Hyperion Essbase, PeopleSoft, MS Access, & Business Objects
Experience with SAS, VBA, & SQL
Recipient Faculty Scholarship and Merit Based Scholarship