* ***** ** ******* ******* experience as Sr. Quality Assurance Analyst / QA LEAD/UAT in banking and financial services.
Expertise in Testing in different testing methodologies like Water Fall, Agile, Scrum Methodologies.
Experienced in various types of testing like Black box, Functional test, Integration test, System test, User Acceptance testing, Regression test, Cross browser testing and, Security Risk Testing
Extensive experience in building and executing Test plans, Test cases and Requirement Traceability Matrix, documenting all phases of the QA process
Experienced in Database and Manual Testing
Experience in Web Services, API testing using SOAP, REST Assured API and Postman.
Experience in using GIT, JENKINS for CI/CD process.
Experience in using Splunk – Monitoring tool to verify the logs.
Experienced in ETL testing.
Used Selenium WebDriver, TESTNG for automation
Excellent on-the-job knowledge of all stages of SDLC.
Excellent communication skills, technically competent and result-oriented with strong problem-solving skills enabling effective interaction with project sponsors, developers and business users.
GIT, Jenkins, Splunk
QC, ALM, JIRA
TOAD, SQL SERVER, Oracle, DB2
BO Reports, MicroStrategy Reports
Rest Assured API, SOAPUI, Postman
Certified Devops Professional Certification from Devops University
FISERV Inc,Parsippany. NJ Feb.19 – current
Role: Sr. Quality Analyst/QA Lead
FISERV payments platform is a highly customizable and configurable payment workflow system which has ability to understand complex payment messaging networks like SWIFT / Fedwire /USACH/Instant
Payment and capable of implementing clearing house specific compliances. It has ability to integrate with many bank specific external systems meant for compliances fraud check and regulatory check, As of now, this product support over 50 clearing houses like EBA, SEPA etc.
A wholesale payments system offers customers the maximum flexibility in a robust, high-performance framework to help them to process, monitor real time cross border /international payments and stay ahead of competitors. In addition, this solution provides payment intervention, tracking, payment creation / repair, and full payment workflow management (cancellation, recall, rejections, returns)
• Developed test strategies, test cases as per the requirement specifications and business rules
• Collaborated with multiple teams for integration testing for test data needs.
• Interacted with team in offshore and coordinated testing effort.
• Automated UI screens with Selenium Web driver, TestNG.
• Analyzed the complexity and provide the estimation of hours for each user story in Sprint planning session.
• Involved in creating test messages SWIFT, Fedwire, EBA Step 2
• Process Incoming and Outgoing CT / DD through different clearing channels.
• Performed defect reporting, bug tracking using JIRA and followed up with development team
• Generated dashboard reports from JIRA to provide the report
• Experienced in using Web Services tools - SOAP, REST Assured API.
• Used Jenkins to configure jobs and create sandboxes for execution.
• Involved in testing SWIFT MX (ISO pain v09 messages to TG2 clearing), SWIFT GPI payments.
• Interacted with BAs and helped them in creating UAT scripts and assisted them in doing UAT validations for different work orders.
Bank of Tokyo Mitsubishi UFJ (BTMU),Jersey city, NJ May.14 – Jan.19
Role: Sr. Quality Analyst /QA Lead/UAT
Project: Volckers Metrics – Brazil /Mexico
Volcker Rule as part of Dodd-Frank legislation was enacted to restrict US banking entities from engaging in short-term proprietary trading of securities, derivatives, commodity futures and options on these instruments for their own account.
There are certain activities that are exempt from this rule around market making and/or risk mitigating hedging activities. In order to qualify for this exemption, a number of requirements need to be met to ensure that the activities performed by BTMUB are consistent with market making-related and/or risk-mitigating hedging activities and are not speculative in nature.
Volcker Compliance program has been successfully implemented in BTMU-NY and BTMUB is expected to be an extension of the existing risk management framework.
Project: Security - Centrify, PAM and PAMSC
Role: BA/ Sr. Quality Analyst
Centrify tool was implemented in the Bank for AD bridging, centralizing sudoers access.
CA PAM has been implemented in the bank to provide access to the servers using privileged credentials.
PAM SC is used for logging and non-repudiation.
Project: Liquidity Risk Management System –Phase II
Bank of Tokyo Mitsubishi UFJ (BTMU) has implemented Asset Liability Management (ALM) and Liquidity Risk Monitoring (LRM) as the Enhanced Prudential Standards (EPS) regulation slandered to comply with Federal regulations. The project will aim to establish an end-to-end business process meeting the BTMU New York Branch for EPS regulation requirements.
As per the BCBS 248 guidelines, intraday monitoring and collateral reports logic has been implemented and data has been processed from various BTMU systems such as MDH, CDL, ABCP, Genesis, OVS, P/S, Sophis, MCS, and Oracle GL for the ALM and LRM.
Foreign Account Tax Compliance Act (FATCA) which was enacted introduced new tax information reporting and withholding payments requirements for certain types of payments made by the US withholding agents to foreign entities. As US withholding agents, both MUFG Union Bank and US branches of BTMU are required to comply with the new FATCA reporting and withholding regime.
Project: Party Cross Reference
Sr.QA Analyst /QA Lead
PCR (party cross reference) project is to build a foundational capability to capture and
maintain a single, authoritative cross reference of party master data (and associated reference data) for managed relationship customers and other key parties (e.g., guarantors and risk parents of customers). This party master data will be sourced from UB, HQA and other MUFG Americas entities. This cross reference information is critical to business processes such as KYC/AML, Salesforce CRM, Credit Approval and Credit Risk Reporting.
Analyzed System specification documents, Business requirement document and developed Test Plans, Test cases, Test Scripts and Test procedures based on business requirement documentation for the testing of application software.
Lead the team of 7 people both onsite and offshore and was responsible in coordinating the test efforts between Bank of Tokyo and Union Bank testing team.
Performed ETL testing by checking if the data that was extracted from different MUFG, UB and HQA source entities was according to the requirements and the data was loaded correctly into the respective target tables.
Verified different daily and monthly operational reports that were developed for business.
Executed SQL queries to validate the data that appeared in the front-end application.
Used Selenium WebDriver and TestNG framework to automate UI screens
Tested data migration to ensure that integrity of data was not compromised.
Verified if the data from the main data base was being populated correctly into the outbound tables so that the downstream applications could absorb the data correctly.
Verified the BO reports to check if the data was pulled correctly according to the end user requirement.
Involved in data driven testing using Selenium
Involved in the UAT testing.
Standard and Poor’s (SNP),NY Oct.13- Apr.14
Project – Business Environment Data
BED project involved in the testing of ETL process wherein the data from different core data sources was extracted and was transformed based on the logic rules and then was loaded into target tables which was the source of the generation of business reports.
Analyzed the requirements and created the test Cases and test Scenarios in ALM.
Checked the mapping logic and created queries based on the logic and checked if the data was being retrieved correctly from the golden source tables.
Checked if the target tables are being loaded according to the mapping rules specified in the requirement document.
Checked all the different reports which were created in Micro strategy tool were according to the end user requirements and if the reports were picking up the correct data from the target tables.
Used ALM for defect tracking purposes.
Bank of Tokyo-Mitsubishi UFJ,Jersey city,NJ Jan.13 – Sept.13 Project: Central Directory Layer (CDL)
CDL (Central Directory Layer) redesign is a key project for BTMU and the goal of the CDL redesign project is to improve data quality and accuracy for customer and reference data throughout the enterprise.
CDL involves core banking applications - replacement and/or upgrade of core banking Applications including deposits, loans, trade finance, treasury, money transfer and General Ledger. CDL II and KYC/R will be more tightly integrated resulting in fewer redundant processes and data inconsistencies.
KYCR and KYCNR applications were used to verify if the customer who is on boarded is not a risk customer and are not involved in any Anti Money Laundering (AML) activities. Only the customers that have risk level as low and moderate can be on boarded and high or prohibited risk customers are subject to scrutiny by the BSAO officer.
Involved In the testing of CDL II application and checked if the application has features of the existing application.
Involved in testing the efficiency of the project as a parallel workflow construction.
Performing Back end testing with use of SQL Queries to validate the backend data of the application.
Interacted with Project team and users to get information about the application.
Wrote data driven tests to check how application performs with different sets of data.
Verified and validated the data integration - CDL to downstream systems.
FINRA (Financial Industry Regulatory Authority), NY May.10 - Dec.12
Project: Insider 2, Single Bluesheet System (SBS)
Senior QA Analyst
Insider 2 is a suite of different applications that got migrated from NYSE to FINRA. Through insider 2 application, users request trade data from the clearing firms for the trade date using the Clearsum application. Clearing firms send data to SIAC and SIAC formats the data and then sends the bluesheet data to NYSE. Every day evening, the BDL job gets executed which picks up the data received from SIAC and loads the relevant tables which is then later analyzed by the users.
Single Bluesheet System is the consolidated system which has combined features of NYSE and FINRA bluesheet applications – Insider 2 and VISTA. Data received is used by the insider analytics team to analyze and the trading cases that have an anomaly can be referred to SEC for further action.
NYSE Euronext, NY May.06 – Dec.09
Project: Enterprise Network Database (END-II)
END2 application is used by trading floor for management of all resources for firms and members. This application contains the modules that are used by the users to keep track of the activities, locations, resources, firms and people on the trading floor. Each module has different set of reports for analysis. At the end of each month Billing reports are generated for the members, for the devices that they use it on the floor and these details are sent to SAP database for billing purposes.
Masters in Information Systems, INDIA