Abhishek Mahajan

PROJECTS:

Project : Finacle Treasury Migration from version 7 to 11
Duration : Apr’19 to Jan’20.

Description:
Migrating finacle treasury 7 to version 11 for 2 overseas branches. Worked in customizing reports as per business requirement.
Seamless flow and generation for SWIFT messages.

Auto STP for the deals.

Roles and Responsibilities:

1.Ensured all the outstanding deals with all data are migrated to the new system.
2.Integration with all the different interfaces and systems.
3.Created all the reports as per business requirement.
4.Documentation for all the issues faced during the migration phase and steps done to resolve the same.

Project : Finacle Nostro Reconciliation Implementation and Migration
Duration : Jan’19 to Jun'19

Description:
Worked as Business System Analyst.
Implemented FNR Plus for all the overseas branches and did migration for the Domestic branch
Using finacle script , created the query for fetching finacle core data into the system using a database link.

Worked in customizing menu's and report setup as per business requirement.
Roles and Responsibilities:
1. Movement of SWIFT File for nostro transactions seamlessly without any manual intervention.
2. Fetching the Data from finacle core for the mirror/internal transactions.
3. Created all the reports as per business requirement.
4. Used RPA for updating the Free fields and auto matching process.
5. During Migration, ensured that no data was lost and count pre and post migration was equal.

6. Worked upon sql tuning for the business required report as time for the report got reduced from 35 min to within 1 min.

Project :INR Non Deliverable Forward Trades in FT
Duration : May’20 to Jun’20.

Description:
Worked as Business System Analyst.
Worked in customizing reports as per business requirement.
Seamless flow and generation for SWIFT messages involving NDF deals.
Auto flow for deals insertion in the system.
Roles and Responsibilities:
1. End to end Solution for FCY/INR NDF trade execution and post deal processing including confirmation, settlement and valuation.
2. Worked upon creating templates for NDF trades to be reported to CCIL.
3. Created all the reports as per business requirement.
4. Created deal tickets and deal confirmations as per the market standards.

Worked for Ujjivan Small Finance Bank

Project Description :

• · Understanding the requirement/ issue for better and quick fix.
• · Taking care for Treasury Appplication, ADF,SAS and Fiancle issues in production.
• · Provided all related information to the customer for the query raised within the SLA time and ensured that SLA is not breached.
• · Providing end to end support related to payments to customer in production as well as in testing.
• · Also analyzing issues related to IB/MB related issues.
• · Experience in Account opening based on cron jobs and using Finacle Integrator.
• · Involved in DC/DR activities.
• · PL/SQL developer for extracting data from tables according to the banker’s requirement
• · Responsible for developing the batch jobs in PL/SQL and for auto deal flow from any application directly to the Treasury Application as per the client requirement.
• Troubleshooting CRM next , Appzillion Iexceed ,ESB and FSS CBS integration issues in production & UAT.

Project : SAS(AML,FTP,ALM)

Environment : SAS DI and Scenario creation (using ECM)

Duration : Jan’17 to Jan'18

Description: Using SAS Data Integration Studio, supporting ETL Process/Jobs for loading data into oracle database.

Worked in Front-end ECM for scenario creation in SAS AML(Anti-Money Laundering) and performance tuning for AML Jobs

Roles and Responsibilities:

Fetch data from Source systems like Oracle source systems through DI.

Filter the records based on the business date and modify the data as per the AML solution requirement.

Load data into target, maintained reconciliation table for all jobs.

Mail triggering facility to send alert mail with error code.