1) Orchestration APP(Mule Batch Job) which notifies user with an email about the exact count of new documents available at the portal

This project is mainly related to creating mule batch jobs for three Preferences(i.e. Daily,Weekly,Monthly) of users for receiving Notifications through E-mail about the count of new Reports available at the portal.

Cronacle job was set up with Parameter like “frequency” which could be Daily,Monthly,Weekly and “notification Type” as Email, which polls SFTP server for a trigger file,as soon as it is found, the mule Batch Job starts with multiple steps as following:

Step1: Fetch list of users from USER_Preference Table with selected Frequency(Batch Input Phase)

Step2: Once all the users are available,fetch userInfo from Auth0(ext system managing user info) and his roles(Batch Process -Batch Step1)

Step3: Once all roles are available,fetch merged combination set of authorized and assigned Accounts and Portfolios (Batch Step2)

Step 4: Once all accounts and portfolios are available,fetch all documents after the lastUploadDate which would reflect the actual last Run date of Cronacle when user was last Notified. Also,find the count of the documents.

Step 5: Prepare email template and notify the user with e-mail.

Step 6: Update USER_Notifications Table with last Notified date as current date for the next run.

Step 7: Create output file and update Cronacle with the output file.