UCSFB Strategic Sourcing Supply Chain Management About Us

UCSF/B Strategic Sourcing Supply Chain Management

About Us

What exactly do we do? • Structure and execute negotiations to maximize the opportunity for savings. • Run competitive bids and sign agreements. . • Act as “the bad guy” with Campus(es), Suppliers, Executives or Buyers to preserve timelines and chase savings. • Own all item level content, pricing, and catalogs in Bear. Buy(s). • Constructively wage disruption campaign’s against broken things. When punks start hasslin’ decent people, I make it my bidness! -BA Baracus

Our Structure Construction & Facilities IT • Joanne Petersen • John Arbolino • Alexis Perez • Joanna Santoro • Sandy Macasieb • David Houghton* Lab Supplies General Office • Ross Bausone* • Alex Butler • Sandy Macasieb • Alex Butler Analysts Susan Riddle* Alex Butler Alexis Perez * Works for UCOP or another campus, but co-locates with UCSF/B Sourcing. Say, are we a groovy, happenin' bunch o' guys, or what? -Murdoch

Analytics • In the beginning… + + IT Department Query Writing Everything was one time analysis, ad-hoc, never to be reproduced

Analytics • We outgrew that 2013 2012 2010 VBA used to automate Analysis Experimenting with Python, R, SAS, Bash, and Postgresql for analytic purposes. Also found our own data sources. Tricked new employees into using Python, Bash, and Postgresql; Alexis and Sumanjit took us too a new level.

Today • Have our own data sources. • Postgresql + Citrus. DB • Python 2. 7 (Anaconda distribution) • Tableau • Git • Bash • Most things are saved in i. Python Notebook with an eye toward, “What if I have to run this thing next quarter…”

Cool Projects • Bear. Buy content analysis & cherry picking contracts • Clustering UC departments by spend patterns (a collaboration with USF School of Business) • Optimize e. Pro enablement decisions (a collaboration with SFSU School of Business Faculty) • • (future) Hashing P 2 P transactions and visualizing them in D 3. js (future) Predicting the End of Blanket POs