Capstone – Project

Automating and visualizing FHLBSF community impact for policy makers

A Collaboration Between

Project Synopsis

The mission of the Federal Home Loan Bank of San Francisco (FHLBSF aka the Bank) system is to support and stabilize home ownership across the United States through access to funds by financial institution’s involved in mortgage lending. In the service of that mission the Bank’s Legislative Affairs group engages with state and national policy makers about the impact the bank makes on local communities. This project will work with the Bank’s Data Science team to support these efforts in the following ways:

1. Prepare vivid and informative GIS visualizations that showcase the Bank’s impact via its members lending activities. (Show maps where the bank makes a difference in terms of mortgage lending)
2. Identify key constituent demographics and bank coverage (Figure out where voters reside and local demographics)
3. Automate slide deck and interactive dashboards (create slides on the fly, programmatically and help develop interactive web apps)

Stretch goals include lead prioritization of different districts and regions where the bank makes the most impact and collecting information about each legislator from public sources.

Project Topics

Company Information

CompanyFederal Home Loan Bank of San Francisco
HQN/A
RevenueN/A
EmployeesN/A
StageN/A
Hiring PotentialN/A
Website

Company Overview

N/A

Experiential Learning Program Details

SchoolMontclair State University
Engagement FormatCapstone - Small Team Consulting Project - Students work in consulting teams of 3-5 directly with faculty and client liaisons on developing real solutions to real-world challenges.
CourseBusiness Analytics Masters Capstone (Spring 2021)
Level
  • All Graduate
Students Enrolled8 Students (Teams of 4 Students per Project)
Meeting Day & TimeTuesdays 7:00 - 8:15
Student Time Commitment4-7 Hours Per Week
Company Time Commitment2 Hours
Duration13 Weeks

Program Timeline

Key Project Milestones

Project Resources

There are no resources currently available

Industry Mentors

Company Admin

Ruo Jia

jiar@fhlbsf.com

Academic Mentors

Instructor

 

zhangy@montclair.edu

Instructor

Manveer Mann

mannm@montclair.edu

Instructor

 

frascaj@montclair.edu

Instructor

 

shecaucus@gmail.com

Instructor

Rashmi Jain

jainra@montclair.edu

Instructor

 

malagar@montclair.edu

Instructor

Nicole Koppel 

koppeln@montclair.edu

Instructor

Jonida Dervishi 

dervishij@montclair.edu

Instructor

Geoff Chellis

gchellis@expediaconsulting.com

Assigned Students

There are currently no students assigned.