Our company have a been embarking on modernizing our IT Systems. There is good deal of progress so far however there are practices i just don't think are not using modern approach. One example is we have an application where their is a rule engine and from time to time the rule changes.
The rule engine works by processing an excel spreadsheet where there are columns defined as to how a specific logic will work. The business owners are usually the one who defines these rules and they gave us the final sheet to be uploaded into the system. There was a small process change back then where our senior management gave them the right to upload the sheets themselves so they won't rely on us to upload it for them.
I've seen this kind of process on many of our systems and it worked well but can't help thinking that this is not really a modern approach to doing things. I spoke to my boss about this and gave him my ideas (see below) but dismissed the idea saying there is no need to change existing process because its working.
My idea is to build another web page on the admin panel for business owners to make changes to these rules on the page itself. The page will have an interface where they can define the new rules and save it (persist in DB). They will also have an option to export the rules to excel or csv file from the admin page itself.
I see the following benefit in using my approach below:
- Business owners can change the rules on the admin panel and it will be timestamped and changes are logged in DB
- Business owners and managers can view the recent rules applied to the engine
- Centralized interface where only approved users are able to update the rules whereas previous approach doesn't log everytime a rule is modified
Really appreciate if I could get feedback from the community what they think about my approach. Thanks