Product Hatching Ideas

Automate adjustment uploads for MSA type adjustments

Currently Bank of America is targeting MSAs throughout the country to better or worsen their pricing. Because MSA is at a zip code level we have to create all of these manually, enter the adjustments manually and update them manually. Currently 3-6 hours each week is spent for one person entering these adjusments and putting Mortech at risk with no automation involved. For the past 2-3 years BAC sent files separately on Wednesday and Friday but are now looking to impact their pricing with daily updates to these adjustments. There are potentially up to 800 adjustments that could change each day with 3-4 hours of manual work. We've pushed back and advised them we can update twice a week but that does not help their long term goals. 

A hackweek project was done to improve this process but needs sprint time (4-5 points) dedicated to fully finish. 

We have heard that other investors (like US Bank) are also interested in this. This poses another problem as US bank is a lender in multiple accounts. 

  • Luke Derowitsch
  • Aug 15 2017
  • Shipped
Rating BOB-3
Revenue or Retention? Retention
Workaround Present Yes
Impact to Existing Customers Multiple
Customer ID(s) 44bofa01
Business Value 3 - Important to moderate number, moderate impact on brand, moderate competitive advantage
Urgency 4 - Highly time constrained
  • Attach files
  • Admin
    Lori Rezac commented
    August 16, 2017 13:23

    Hackweek project was Regional Pricing:

    "Chase has region specific adjustments. The only current way we can support this is through customer level profit/cost adjustments. These are managed manually and in the chases production account. Since the regions are specific to chase, we don't currently have a way to test changes outside of production.

    Looking to automate this process."

    Theresa is currently attempting to locate the ticket associated with this project.

  • Admin
    Lori Rezac commented
    August 17, 2017 18:14

    Sending to BOB to be pulled into DWQ.