2018-19AppliedProjects&Consultants


1		Analytics Consultants	Client Name	Project Title (a link to project summary document)	Public Presentation #	June 7 - Public Presentation Schedule	Team's Primary Speak Persons (please include names of team members who will be the primary presenters as behalf of your team)	a link to poster	Brief Description of Project (Make sure to review & edit team project description. This description will be used in all showcase and applied project marketing content.)
2	7	Green, Kevin C; Subramanian, Minu; Simas, Jason	City of Tacoma	Comparative Cost of Business Calculator	117-1	Joy 117 - 9:10 am - 9:30 am	Green, Kevin C; Subramanian, Minu; Simas, Jason	https://canvas.uw.edu/courses/1301234/assignments/4789207/submissions/3753641	The purpose of the project is to build a prototype tool that showcases various costs involved in starting/operating a business depending on the business type, size and expected annual revenue.
3	6	Favors, Morgan Anthony; Mehmood, Mahrukh; Stjern, Nick; Whitfield, Quinita; Singh, Akanksha	Metro Parks Tacoma	Financial Analytics	117-2	Joy 117 - 9:40 am - 10:00 am	Mehmood, Mahrukh; Singh, Akanksha; Stjern, Nick; Whitfield, Quinita		The purpose of this project is to create a Power BI dashboard that combines actuals data from a Munis database with detailed budget information in Microsoft Excel spreadsheets.
4	5	Bowman, Karessa; Lampman, Brynn Amber; Bachhuka, Komal; Zhao, Yi	Harbor Wholesale Foods, Inc	Pricing Matrix	117-3	Joy 117 - 10:10 am - 10:30 am	Bowman, Karessa; Lampman, Brynn Amber; Bachhuka, Komal; Zhao, Yi		The purpose of this project is to create a prototype that utilizes analytical techniques to reduce the duration of an ETL process that generates dynamic customer pricing.
5	1	Deshmukh, Ankita; Goja, Gargi; Garces, Natalie Beth Newvillamor; Vadloori, Arunitha; Shibuya, Takumi	Microsoft	Supplier Climate Change Impact	117-4	Joy 117 - 10:40 am - 11:00 am	Deshmukh, Ankita; Goja, Gargi; Garces, Natalie; Shibuya, Takumi; Vadloori, Arunitha		The purpose of this project is to develop a predictive model that will forecast supplier carbon emissions reductions based on historical data, allowing Microsoft to analyze current and future supplier emissions. This model will predict suppliers’ CO2 performance so that Microsoft can make decisions of resource allocation in accordance to which suppliers need to be monitored in order to be up to par on industry average emission targets.
6	8	Santos-Richter, Cazandra; Dhaliwal, Gursimran; Cortez, Johnny Roman III; Wu, Yang	CHI Franciscan	Orthopedics & Medicare Hospital VBP	215-1	Joy 215 - 9:10 am - 9:30 am	Cazandra Santos-Richter, John Cortez		The purpose of this project is providing insight into estimated revenue recoupment and risk resulting from the HVBP. This will be accomplished through identifying deficiencies in performance across peers and metrics laid out by CHI Franciscan. Ultimately, we aim to improve CHI Franciscan’s ability to project the financial return on pre- and post-operative care coordination, their quality of care performance metrics, and their scores compare to nationwide hospital performance.
7	4	Bennett, Jeff; Dehmlow, Adam; Nguyen, Jimmy; Kakati, Prayashi	Regional Healthcare Leader	Surgical Volume Forecasting Tool	215-2	Joy 215 - 9:40 am - 10:00 am	Jeff Bennett		The purpose of this project is to utilize existing historical and personnel data to forecast surgical volume changes.
8	3	Hahn, Kendra; Rumph, Aaron; Soete, Weston William	Community Bank	Banking Risk Management	215-3	Joy 215 - 10:10 am - 10:30 am	Hahn, Kendra; Rumph, Aaron; Soete, Weston		The purpose of this project is to improve knowledge used in a community bank's strategic decision making. This will be accomplished through the identification of an appropriate peer group for benchmarking and development of meaningful KRIs through sentiment analysis. The project will also provide insight into how the bank can reduce the amount of labor to create their risk management reports and create a repeatable process for creation of a peer group using statistical analysis.
9	2	Cowan, Allison; Lee, Glacia Michele; Sagar, Gaurav; Bhole, Snehal Rahul; Martinez, Victorino	Columbia Bank	Columbia Bank Marketing	215-4	Joy 215 - 10:40 am - 11:00 am	Victor Martinez, Gaurav Sagar		Develop data-driven processes to utilize digital marketing technology to increase customer retention and product engagement.