Abhijeet Nisang

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

• Created proofs of concept for innovative new solutions Python and PostgreSQL.
• Enhanced data quality by performing thorough 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.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
• Worked on Python and PostgreSQL extensively
• Worked on various Python library Panda, NumPy and Matplotlib

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

• 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 new software, feature updates and fixes.
• Reduced deployment times with introduction of CI/CD pipelines for multiple projects.
• Azure CLI Command, Terraform
• Designed and developed forward-thinking systems that meet user needs and improve productivity

In order to integrate AXIOM V10 into Azure Cloud Hosted Environment, Single Sign on (SSO) is implemented using SAML and LDAP.

• 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
• Keystore is generated which hold private and public key which will be shared to Federation team
• These metadata file describe SAML entire data (Service and Identity provider attribute data)
• Application uses LDAP URL to fetch all required details from Active Directory using technical account.
• Ensured data integrity by implementing stringent data validation processes during system integrations.
• Enhanced system performance by optimizing integration points and streamlining data flow between applications.
• Established connectivity between Service and Identity Provider

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.

Control-M job is getting triggered daily and monthly which will call unix script

Required number of objects are given as input to script

This script will call procedure to load data into multiple oracle object.

Key Responsibilities:

• Involves in writing unix scrip 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.
• GMIS code is maintained in static table as per business requirement
• Designed data model based business requirement in order to capture party and party rating data
• Handle multiple validation based on file id and checksum to avoid duplicate file processing
• Removes all data before processing multiple files in existing table
• Perform end to end testing of all received files and support user in regression testing
• Deployed code in production and performed validation successfully.
• Conducted product demonstrations to highlight features and redirect objections to positive aspects.

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:

· Involved in Taxonomy integration with Axiom code.

· Involve in end-to-end design and development of report with user and BFA

· Involve and Coordinate with Upstream team in order to process data for product classification

· Involve in Agile planning and estimating efforts

· Interpreted business requirement from multiple stake holders

· Involve in Agile Retrospective call to inform what went well good and bad. Take corrective action

· Configure new Axiom objects Data source, Data Model, Modify Model, Portfolio, Aggregation, Workflow creation

· Design Taxonomy object such as Measure or concept mapping, Dimension mapping, Hypercube generation and report mapping module

· Resolve Taxonomy error while generating reports and ensure that report generates expected values

· Perform deployment from DEV, SIT and UAT. Also, provide the support to the reports and get the user sign-off

· Perform Taxonomy code Integration based on Axiom Taxonomy releases

· Notify Issues and discrepancies observed in Report Results such Line-item Value discrepancies, Fact calculation changes and Dimension/Measure changes

· Involve in Axiom upgrade activity from 8 version to 9 version.

Worked on XBRL Taxonomy- Dimensions, Measures and Hypercube

• 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
• These entire modules written in SQL and Control-M.
• Microgen Cash/Deal :- This is applicable for sprac and Microgen
• Even this changes impacting various file 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 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 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.
• RASTAT (Revenue Assurance statistics) report generation
• This report basically contains RASTAT information of raw data received in various switches which describe about number of record processed properly or not along with its detail information like switch file name, batch id(unique to each raw file).

Key Responsibilities:

• Manage Change Requirements / Troubleshoot Reports by capturing business process requirements through client interactions
• Design, Development and Unit Testing for various modules
• Produced Resolution of issues raised by users during User Acceptance test
• Worked on Unix,C and Oracle SQL/PL SQL code
• Given training to new joiners about the mediations

• 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.
• TRIMS OLECA and OFAC System
• This is basically uses for compliance check whether particular bank is belonging to Islamic County or fraud party or name.
• Applicant information is sent to GI system from TRIMS system
• For Data Validation, after performing validation it will decide whether approve or not for that Applicant
• Key Responsibilities:
• Manage Change Requirements / Trouble Reports by capturing business process requirements through client interactions
• 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
• That message is parsed in Base24 format
• This information is displayed field wise on window using MFC.
• Master/Visa card Incoming fie and Master/Visa card Outgoing file
• Incoming file is written in C
• This file is called from front end (JSP) through JNI
• Java code call .so file
• Output of C file is given back to JSP for displaying purpose whether file is processed or not.
• In file handling, some file from client side contains junk value that create problem of mismatching record to avoid these certain changes needs to be made in program

Key Responsibilities:

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