Project - Collections Business Process Automation

This project is used by the a financing company. They were using a legacy application for managing their business process. So, my last company has taken this project to replace this system. The complete project has many modules like Loans, Legal and collection. And Each of these modules is managed by different teams. I was part of the collections team.

Our collection module can be assumed as linchpin between different systems. We receive some data from a system, store it as well as sent processed data to another system. Following diagram is simplest representation of it.

image-alt

My responsibility in this system is to manage all the arrows in the above diagram. These data are processed once a day, and some processing is done regularly at a particular interval. To manage this data flow i have created few batch utilities. They are written in java and some sprinkle of jdbc connection as well as my company's apis. I have also written a ton of stored procedures to do some heavy lifting.

Here is the tech stack that i used:

RoleTechnology
languagejava
databaseMicrosoft SQL Server, T-SQL