Brian Johnson

**** ****** **** ***. *** Walnut Creek, CA 94597

acgxdz@r.postjobfree.com 707-***-****

EXPERIENCE

Supply Chain Strategies Analyst II Safeway Inc. Pleasanton, CA October 2014-Present

• Created store level product allocations using Teradata SQL queries and Access to support in store

promotional activity resulting in increased sales

• Collected financial data on impact of consumer demand decisions using Teradata SQL and Excel and

presented results to senior supply chain management

• Collaborated with cross functional Safeway teams to identify inventory investment purchase opportunities

resulting in net savings of $3 million per month

• Facilitated weekly conference calls with various vendor partners to present and discuss key supply chain

metrics

Supply Chain Strategies Analyst I Safeway Inc. Sept. 2012- October 2014

• Accurately completed promotional forecasting using year over year analysis and Teradata Demand Chain

Management that maintained management’s service level goal of 98%, period inventory goal of $30 million and a

yearly spend of over $100 million

• Worked in conjunction with vendor partners to reduce cost of goods sold by implementing advanced

purchasing methods such as direct plan ship and bracket costing

• Analyzed and negotiated with vendor partners to resolve inventory liabilities from discontinued items

reducing Safeway’s exposure to dump loss

• Collaborated with VMI and CRP program vendors to increase communication of issues between the

various Safeway organizations such as pricing, logistics, and Consumer Demand

• Managed cross functional teams within various Safeway business units pertaining to key transportation

and warehousing issues reducing retail out of stocks by 3% year over year

Home Loan Officer NorthBay Home Loans Petaluma, CA July 2011-Sept.

2012

• Established strong partnerships with lenders, real estate agents and escrow companies to ensure completion of loans

prior to sales contracts’ expiration

• Maintained high attention to detail to comply with all FHA, HUD, and CFPB regulations

• Managed an average pipeline of 25 active loans in various stages of completion while negotiating with loan

underwriters to ensure funding was completed in a timely and accurate manner for the customer

• Analyzed intricate tax forms including;W2, 1099,and 1040 to summarize and audit clients assets and income to

determine specific borrowers ratios

EDUCATION

Sonoma State University Rohnert Park, CA Class of

2011

Bachelor of Science in Business Finance; Economics Minor (GPA: 3.9)

Accomplishments: Graduated Cum Laude and with Distinction, Dean’s List Fall 2008 –Spring 2011

Skills

• Advanced knowledge of Excel including; Vlookup, Index match, Sumif, and Pivot tables

• Extensive experience with Teradata SQL, Teradata Demand Chain Management, and QMF for Windows

• Proficient in Microsoft Word, PowerPoint, and Outlook

Contact this candidate