Abhijeet Nisang

There was requirement where data from various data sources need to be fetched from transaction warehouse which need to be inserted into multiple staging table. This data movement need to be carried out in secured way and ensure all data needs to be transferred successfully.

Key Responsibilities

• Created proofs of concept for innovative new solutions Python and PostgreSQL.
• Enhanced data quality by performing through cleaning, validation, and transformation tasks.
• Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
• Identified issues, analyzed information and provided solutions to problems.
• Worked on Python and PostgreSQL extensively
• Worked on various Python library Panda and NumPy
• Optimized data processing by implementing efficient ETL pipelines and streamlining database design
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability

Prepare DevOps pipeline which automatically perform various operation such as VM and Storage Account Creation. Database Creation, Application Installation with on App and Web server. Automatic Server start and stop mechanism. Source code deployment on Azure environment.

Key Responsibilities

• Worked extensively on Azure DevOps CI-CD pipeline
• Built databases and table structures for web applications.
• Corrected, modified and upgraded software to improve performance.
• Coordinated deployments of source code and new software, feature updates and fixes.
• Reduced deployment times with introduction of CI/CD pipelines for multiple region.
• Azure CLI Command

In order to integrate AXIOM V10 into Azure Cloud Hosted Environment, Single Sign on (SSO) is implemented using SAML and LDAP. This SSO allow user to seamlessly login to system without entering the credentials,

SAML is acronym used for Security Assertion Mark Up Language Its primary role in online security is it enable to access multiple web application using one set of login credentials.LDAP is Lightweight Directory Access Protocol (LDAP) which is open, cross-platform software protocol used for authentication and communication in directory services.

Key Responsibilities

• Analysis multiple system in order to fetch required detail
• Keystore was generated which hold private and public key which will be shared to Federation team
• Established the connections between Service and Identity provider attribute data.
• Fetches all the Active Directory user data using LDAP
• Perform LDAP configuration on Axiom

Data is sourced from various upstream system such as SAP GL, K+ and EP. This data resides in staging table in Oracle-TWH where filtration logic is applied. Here, process and rules are defined to segregate Assets and Liabilities data. Under Assets and Liabilities where various product are classified.

• MAS_610

Worked on various MAS reports such as Annual B3_7, E1 and revamp AMR report into taxonomy

• AU_ARD

Extensively worked as Senior Axiom developer as part of ARD Decommission for APRA Regulator

· ARF_220_5: Movements in Provisions for Impairment

· ARF_117_0A: Repricing analysis - denominated in AUD

· ARF_221: Large Exposures - Foreign ADI

· ARF_222_0: Exposures to Related Entities

· ARF_118_0: Off-balance sheet business

• AU_EFS

Worked on below Apra Reports. Apra is Australian Prudential Regulation Authority.

· ARF_720_0A ABS/RBA Statement of Financial Position (Banks & RFCs)

· ARF_720_1A ABS/RBA Loans and Finance Leases (Banks)

· ARF_720_1B ABS/RBA Loans and Finance Leases (Non-bank ADIs & RFCs)

· ARF_720_2A ABS/RBA Deposits (Banks)

· ARF_720_2B ABS/RBA Deposits (Non-bank ADIs & RFCs)

· ARF_720_3 ABS/RBA Intra-group Assets and Liabilities

· ARF_720_4 ABS/RBA Debt Securities Held

· ARF_720_5 ABS/RBA Equity Securities Held

· ARF_720_6 ABS/RBA Securities on Issue

Key Responsibilities

· Participated in integrating Taxonomy with Axiom code.
· Engaged in the E2E design and development of reports alongside users and BFA.
· Coordinated with the Upstream team for processing data for product classification.
· Involved in Agile planning,effort estimation and Retrospective meetings.
· Configured new Axiom objects such as Data Source, Data Model, Modify Model, Portfolio, Aggregation, and Workflow creation.
· Designed Taxonomy objects like Measure or concept mapping, Dimension mapping, Hypercube generation, and report mapping modules.
· Resolved Taxonomy errors during report generation and ensured that reports yielded expected values.
· Performed deployment from DEV to SIT and UAT, provided support for the reports, and obtained user sign-off.
· Carried out Taxonomy code integration based on Axiom Taxonomy releases.
· Participated in upgrading Axiom from version 8 to version 9.

Transaction Data Ware House -Paragon

TWH is data ware house maintains information about all online and offline feed which comes from multiple Upstream source system

This feed data is loaded into staging table after pre processing based on GMI code which filter out non matching record from incoming files and perform required logic then data will finally load into main FDS table.

Key Responsibilities

• Involves in writing unix script and control-m jobs
• Involve in creating new CTL files along with respective table objects
• Involve in writing packages which captures data of various files and load into respective table.
• Designed data model based business requirement in order to capture party and party rating data
• Perform end to end testing of all received files and support user in regression testing
• Deployed code in production and performed validation successfully.

• Equity Derivative -Post Trade
• Swap One Reconciliation :- In this project,When trade is booked in TBS system it has gone through various downstream system such as Payment,Trade and MTM.This modules perform reconciliation between Shophis and Swap one system
• Microgen Cash/Deal :- This is applicable for sprac and Microgen
• Even this changes impacting various files such as MTM,INSTR,CASH and CROSS in all region (HBAP,HBUS and HBEU).
• Sophis Batch Processing :- This project process handles various downstream received from Sophis system
• This are sophis batches perform pricing computation for pricing module based on Row Maturity, Implied Vega Buket on submission grid,generated output file then generate reports for validation.
• File Data Analyzer :- This project perform validation of different pricing library placed on different path. It perform validation on primary key in table and generate comparison report
• This gives detail information of all folio which will used for validation.

Key Responsibilities

• Involves in Construction, Enhancement and New Requirement.
• Provide solution to business based on requirement
• Develop report structure using C++ and perl script
• Improve performance oracle SQL queries

• RECS Mediation
• In Mediation, Data is collected from different types of switches like Ericson, Next one, Alcatel and ZTE switches which are hosted on different server to received real time data
• Those received real time data is processed and generated respective type of format properly on server and transferred those type of format to another system for further business logic and data validation.

Key Responsibilities

• Design, Development and Unit Testing for various modules
• Worked on Unix,C and Oracle SQL/PL SQL code

TRIMS (Trade Record Information Management Systems)

• TRIMS are a comprehensive Global Trade Finance Division (GTFD) system that processes transactions from initial registration to final liquidation for all GTFD products
• TRIMS are designed to provide end-to-end Trade Processing support on a Single Global System Platform.

Key Responsibilities

• Involve in the Construction, Enhancement and New Requirement
• Involves in writing Unix scripts and Oracle SQL/PL SQL code

Visa/Master File Processing

• In this project, ISOBase24 switch message is received from client end on server side using socket programming

Key Responsibilities

• Involve in writing stored procedure and Unix scripting
• Involve in writing Pro*C and C code as per business requirement