BHASKAR YADAV

 Project Title : Finacle Treasury

 Role : Senior Software Engineer

 Client : IDBI Bank, Mumbai

 Environment : Oracle 11g, Windows

 Team Size : 11

· Finacle Treasury is an integrated treasury management solution covering several key markets such as Foreign Exchange, Fixed Income, Money Markets, SWIFT Messages, Nostro and their related derivative instruments.

· Treasury follows a modular approach and is structured by operations in front, middle and back office. While all the modules come together to work seamlessly as an Integrated Treasury, they also work well independently of each other.

Role & Responsibilities:

● Designed and developed the SQL queries to extract valid data as per business requirement.

● Written complex queries using join for Jasper reports.

● Development of business component using Procedure, Functions, Views, Packages.

● Worked on Deal Life Cycle flow, User Management,

● Performed technical upgrade of Oracle Database to 11 g.

● Worked on Scripts, Rules, SWIFT messages, Accounting data of Finacle Treasury. Extensively involved in Unit testing, Integration testing and FT application customization. Involved in patch deployment, holiday update, DR Drill activities. BOD, EOD process handling.

2) ITMS- Integrated Treasury Management System.

The ITMS- Integrated Treasury Management System provide the interface functionality between Finacle Treasury and Kondor banking system to validate the transaction and limits of the trade transaction processing with high accuracy.

Role & Responsibilities:

● Developed the Inbound and Outbound interface for FT-Kondor system.

● Created XML and transformation system files for the flow of trade deals through interface.

● Worked on Linux for the deployment of scripts and system files in the interface.

● Created custom sql scripts, table and view for the monitoring the trade flow.

● Developed reports to achieve the purpose of reconciliation of trade data for both FT and Kondor system.

● Writing complex SQL Queries using Joins, sub query and inline views to retrieve data from the database.

● Performed Unit testing and maintained test logs and test cases for all the business requirements.

3) Dubai and Gift City Finacle Treasury

New entity has been developed for IDBI bank Dubai and Gift city to provide the service the Banking Treasury related Services. Finacle Treasury provides an integrated treasury management solution covering several key markets such as Fixed Income, SWIFT and Nostro etc. .

Role & Responsibilities:

● Developed and tested business related Reports which is used in application

● Written Common Functionalities Which is used in project using Views, Functions, Procedures etc.

● Created Indexes to increase the performance.

● Requirement gathering and development of reports.

● Create DB Links to access the data from another servers.

Project Title : Worker Compensation

Role : PLSQL Developer

Client : Zurich Insurance group

Environment : Oracle 11g, Windows

Team Size : 06

Project Scope - Worker compensation is the module in insurance domain where protection against the injury and medical expenses of employee and employers liabilities are covered, There are different factors are considered while calculation of premium and surcharge. This project provides the solution to improved data quality, deployment speed, business efficiency, service, and successfully met the company's biggest data management challenge.

Role & Responsibilities:

• Wrote complex SQL Queries using Joins, sub query and inline views to retrieve data from the database.

• Wrote complex SQL Queries, Advanced SQL (Group by functions, Analytical functions and Connected-by-Prior, Co-Related Sub Queries and Inline views).

• Evaluate business requirements to come up with PLSQL mapping design that adheres to database standards.

• Designed and developed the SQL queries to extract valid data from source system and transform those data using PLSQL mapping and load the data into Target using PLSQL.

• Developing PLSQL subprograms (Procedures and functions) to build business rules to process data. Identifying the business requirement and developing the industry standard PLSQL objects to full requirements and resolve the issues.