Shawn Brooks Email & Phone Number

Salt Lake City Metropolitan Area

Greater Salt Lake City Area

Greater Salt Lake City Area

Phoenix, Arizona Area

•Manage a team of analysts which provides analytic and strategic support for corporate and field partners•Oversee annual and quarterly forecasting and planning cycles for a $800M Service business•Provide store specific weekly and daily sales plans for 1,200+ sites and 3 unique businesses•Coach and mentor analysts and summer under-graduate intern; taught new analysts annual forecasting process•Develop long-range plan to inform the Services strategy; extensive experience in forecasting and Excel modeling•Assist in development of business cases and strategy; provide financial analysis and modeling to evaluate projects•Create analytic tools and reports to support business and identify drivers of, and risks to, sales and margin plan

Phoenix, Arizona Area

•Managed four person team providing analytics, sales forecasting, financial modeling, and business concept-testing•Implemented APT Test and Learn software; developed processes to measure dozens of concept-tests each year•Educated business on test and control methodology and the importance of using data to make decisions•Managed test-store capacity pipeline to minimize conflict and improve reliability of test results (~70 tests per year)•Worked with multiple functional groups to measure new initiatives; reported results to Executive team monthly•Researched macro-Economic trends and provided Finance leadership with an outlook on potential impact to sales•Drove decision to abandon a popular remodel-concept through analysis of initiative results and project NPV•Coached analyst in development of a category P&L model; provided visibility to the profitability of various categories

Phoenix, Arizona Area

•Provided analytic, strategic, and reporting support for Enterprise; served as an internal consultant to CFO•Significantly improved new site review process with a highly functional financial model to project cash flow and NPV•Identified area of business that was under-performing; garnered executive support to suspend activity in that area•Learned VBA (self-taught) to reduce complexity of financial models and more effectively model multiple scenarios•Analyzed PetsHotel business and built long-range NPV projection model to forecast shareholder value

•Supported Marketing Department with analysis and reporting to measure success of departmental initiatives •Performed market research and scoped opportunity for company to expand into a new line of business•Gathered, consolidated, and analyzed data from multiple sources into concise, actionable insights•Performed NPV, ROI, and incremental sales analyses to evaluate high-profile business initiatives

Greater Denver Area

•Justified $500M+ budget for equipment upgrades; secured incremental $70M to support retention initiatives•Worked cross-functionally with IT and accounting teams as project lead to develop a subscriber churn cube•Learned SQL (self-taught) to directly access data warehouse tables; greatly reduced turnaround time on analyses•Provided analytics to diagnose lack of success in direct-mail program; developed a change in strategy for program

Greater Denver Area

•Provided retention and churn analytics and forecasting for 12-million subscriber subscription service•Managed disconnect tracking process; identified key drivers of churn and provided suggestions to improve trends•Developed budget for $13M direct mail referral program; used CRM tool to optimize contact strategy for program

Provo, Utah Area

Balanced Branch nightly; responsible for tracking ~$80K in cash and ~$2.5M in checks and other negotiable items. Had highest loan volume in office during the 4th quarter of 2002; contributed $1.7M to the branch’s loan portfolio.

Mba-Im, Finance

Ba, Business/Finance