RPA Developer

* Client - 2: NORTHERN TRUST
* Role & Tool: RPA Developer - Xceptor

a) ExodusPoint PnL Difference Check:
* Xceptor captures data from a daily email containing their PnL reconciliation data pasted within
the email and use it to create the output file.
* Each Portfolio's "YTD PnL Diff" value will be compared to the prior day's value.
* The difference will be reported in the output file, listed by portfolio, and writes comment if
recon (diff) is greater than $50,000 or if there are portfolios that does not exist on both files
and highlights those specific cells.

b) CarVal CL0 Reconciliations:
* It's a two-way reconciliation between parties to show breaks (missing/mismatch).
* Xceptor watches a particular folder location, recon 1 & 2 gets triggered once the NT file is
dropped.
* User can override data in DS if required before dropping the files that triggers next recons, 2
extra files might join in at times, altogether these 3 files would trigger 4 recs which produces
12 outputs.
* Users will receive emails with 4 consolidated output files that contains breaks specifically
split in multiple tabs along with a summary tab which shows the count of breaks in a tabular
format.

c) Elementum Total PnL Reconciliation:
* It's a two-way reconciliation between Elementum and NT, wherein relevant files from Elementum
comes encapsulated in a zip file via email.
* There are 8 different categories and multiple subcategories of files available in Elementum,
and based on the subject line specified, reconciliation would get triggered for that specific
category and yields output for the available files. It triggers an email alert listing out the
missing files if there's any.
* The reconciliation output file consists of 3 tabs: Summary - shows the "Total PnL" data from
both the files listed by Side pocket and its difference, Matched - shows the breaks and
Unmatched.
d) Automate transaction booking for One River's daily staking reward and fees:
* Xceptor extracts data received from external csv files: StakingReport emailed to HFS daily and
One security's price from GPx drops at a folder location.
* This data will be combined with default datapoints and business logic (calculations) to create
two different upload templates: ERAM Trade and SingleEntry Multipost along with an output file
that contains data from both the files.
* Also, replaces data with default values if the variance breaks threshold and alerts the users
in case of discrepancies.

e) CarVal CLO Compliance Test Results:
* This test result process compares Trustee's file to CarVal's. CarVal file combines with data
pulled in from mapping file (Translation tables) generates an intake file & stores it at a given
location.
* Xceptor consolidates the output files generated from reconciliation and sends it to the users
via email that shows break where difference exists listed by "Test Type" in ascending order in
the matched tab.
* Unmatched tab shows the data where there's a mismatch between the compare points. Summary tab
shows the count of breaks listed by "Test Type" in 2 tables.

f) Automated CarVal CL0 Reconciliations:
* Xceptor captures input data from the email attachments and last two emails would trigger all
the 4 reconciliations at the same time.
* In this, the last file holds data for all funds in a single file and the same file can be used
for multiple CL0s for generating output files. All these recs would generate a total of 12
outputs.
* Business user will receive 3 emails with consolidated output files that contains breaks
specifically split in multiple tabs along with a summary tab.

* Accomplishments & Responsibilities:
* Responsible for ensuring that the delivered processes provide the necessary functionality and
perform in accordance with the overall requirements and to the customer's expectation.
* Liaising with clients in deep-dive business calls for continuous improvement by generating
suggestions and assisted them understanding to-be process.
* Fixed defects with prompt and good analytical skills during production support.
* Provided live demos on how to run the processes in UAT and, also involved in day-to-day
monitoring and support activities of existing processes on UAT/Production.
* Have proficient knowledge in Xceptor data enrichment and reconciliation end to end design.
* Review the failures and fix the bug at immediate manner and send the RCA to business team as
well.
* Conducted KTs with the newly onboarded partners and developed technical documentation (ASD) to
describe process workflow, business logic and technical specification.

* Client - 1: CREDIT SUISSE
* Role & Tool: RPA Junior Developer - Blue Prism

* Credit Suisse-Early Termination: The objective of this bot is to provide RPA solution to automate
and reduce the manual effort to do an early termination of loans that customers have taken.
Generates an "Early Termination" letter in PDF format for the Customer once the ET is done and
sends it to the respective Customer.

* Accomplishments & Responsibilities:
* Perform Code fixes by following the report generated by Automation Workbench Tool.
* Create and configure environment variables.
* Perform unit testing on each object developed on a regular basis before deploying in UAT.
* Analyze the code and perform the necessary actions for maintaining the coding standards.
* Experience in troubleshooting the exceptions within predefined SLAs.