SUMMARY

• Experienced in creating and designing Test Strategy Documents, Test Plan, Test schedules, Test Cases, Test Procedures, Test Scenarios and preparing Business Requirements Documents (BRDs).
• Solid Capital Markets E - Trading experience in Multi Asset trading platforms via different Electronic Communication Networks (ECN).
• Strong knowledge of different types of Financial securities: Equity trading, Fixed income and Derivative products: Swaps, Options, Futures and Forwards.
• Strong knowledge of payments SWIFT system and various message types (MT103, MT202, MT300, MT950).
• Strong knowledge of End to End SWIFT processing.
• Experience in using SQL Server Integration Services to Extract, Transform and Load (ETL) data.
• Experience working in Agile methodologies of Software Development Life Cycle including design, development, implementation, testing, deployment, and support maintenance.
• Experienced in writing SQL Queries and stored procedures on various relational databases.
• Extensive experience in using SQL Server Management Studio, DBeaver and Microsoft office tools such as Advanced Excel and PowerPoint.
• Proficient in the use of T-SQL for developing stored procedures, triggers, tables, views, user functions, SQL joins, Table Normalization, Data Import/Export Troubleshooting and query writing.
• Solid understanding ofMarket Data andData Analysisfor real time market valuations.
• Experience with participating in walkthrough meetings with business users and stakeholders to facilitate Business Requirements gathering and creatingBusiness Requirement Documents.
• Performed different types of testing like GUI testing, ETL testing, UAT testing, Functional, Regression, Integration, End to end, Backend, Positive and Negative testing.
• Extensive experience in bug-tracking and defect management tools like HP ALM and JIRA.
• Experience in End-to-End validation of different type of flows related to trading applications: Market Data Flow, Order Flow, and Post-Trade Flow.
• Good understanding of FIX Protocol and XML Message.
• Knowledge on different software development methodologies like Agile and Waterfall.
• Adept in reviewing Test Procedures, creating Test plans, Test Scenario, defining System & Integrating Test Cases, executing Test Cases, Test Data reviewing and maintaining and executing detailed Test cases for User Acceptance Testing (UAT), analyzing bugs, interacting with team members in fixing errors.
• Strong abilities to work in pressure-environments, effective problem solving skills, good communication and interpersonal skills.
• Experience in running automation testing codes in Selenium/Python.
• Experienced in SQL queries for Backend testing and data verification from different tables with use of Select statements, Aggregate functions, Joins, Where and Having clauses, Cases.
• Involved in ETL process testing usingInformatica PowerCenterETL tool.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source;
• API Testing using Postman
• Experience in automating test cases using Java, Eclipse IDE, Selenium WebDriver, Maven, TestNG

TECHNICAL SKILLS

Operating Systems: UNIX/LINUX, Windows, iOS, Android

Languages: SQL, HTML/DHTML, PHP, XML, VB, basics of Python

Databases: Oracle, SQL Server, Ms-Access, MySQL

Testing Tools: Quality Center, HP ALM, Quick Test Professional (QTP), JIRA

Web Technologies: ASP.NET, JavaScript, XML HTTP, HTML, DHTML, XML/XSLT, CSS, Windows SharePoint Serives (WSS), Web parts, and SharePoint Portal Server 2003

MS Suites: MS-Word, MS-Excel, MS-Office, MS-Visio, MS-Outlook

PROFESSIONAL EXPERIENCE

Confidential

QA Analyst / ETL Tester

Responsibilities:

• Written Test Cases for ETL to compare Source and Target database systems;
• Developed and implemented test cases under the guidelines of ETL Lead usingInformatica Power CenterETL tool;
• Performed ETL validation using Informatica PowerCenter Workflow Manager and Informatica PowerCenter Workflow Monitor;
• Used validations of various types of transformations such as Aggregation, Joiner, Router, Filter, Lookup;
• Conducted source to target data mapping;
• Used DBeaver in creating and executing SQL queries using Joins, Unions, Aggregation Functions, Cases for testing ETL process;
• Developed complex SQL scripts/queries for validating backend testing of Databases records;
• Did extensive work with ETL testing including Data Completeness, Data Transformation, Data Quality, Metadata testing for various data feeds coming from source;
• Involved in creating a Test Plan and a Test Report.
• Involved in User Acceptance Testing (UAT);
• Involved in API testing using Postman;
• Involved in a daily Scrum meetings;
• Developed automation scripts using Selenium WebDriver with TestNG Frameworks.
• Used Java language to Developed automation scripts.
• Executed automated Selenium scripts and reproduced failures manually.

Confidential, New York, NY

Sr QA Analyst

Responsibilities:

• Analyzed systems requirements and developed test plans to outline the scope, analysis, approach, resources, schedule of testing as well as writing test cases, test execution and test completion report;
• Performed testing activities based upon test plans and test cases;
• UsedHP ALMto organize and manage all phases of the software testing process, including planning tests, writing test cases, executing tests, JIRA for logging and tracking defect life cycle;
• Executed GUI, Functional, End to End, Regression, System and Integration testing of the application;
• Analysis of complex GUI;
• ValidatedMarket data flowfrom different ECNs;
• Performed automation scenarios in XML format for dynamic/static options for transfer test case to automation run. Confirmed/fixed Tag lines in XML files for a variety of scenarios;
• Performed End-to-End Validation of Order flow, Post Trade Flow;
• Manually tested Functionality of tradingfinancial instruments and validated different types of orders such as: limit order, market order, stop loss order;
• UsedFIX Protocol to understand various message types, also FIX logs and debug the issues;
• Used UNIX commands to monitor log files and troubleshoot different issues;
• Validating payment flow via payment platform and SWIFT Alliance Access;
• Tested Swift, MQ, payment types (wires, ACH, account transfer), various messaging formats (MT 103/202/300/942/950 );
• Tested various payment types SWIFT (MT 103/202/300/942/950 ), ISO 20022 (PACS.002, PACS.004, PACS.007, PAIN.001, PAIN.002, PAIN.008, CAMT.052, CAMT.053, CAMT.054), FIXXML;
• Confirmed/fixed Tag lines in XML files for a variety of scenarios;
• Member ofAgile/ScrumQA team focused on Bonds and Features trading;
• Performed problem solving and root cause analysis when defects occur;
• Interacted with developers to resolve software related defect issues;
• Part of the QA Groupthat ensured adequate testing of application both before and after completion, maintained quality procedures, conductedUAT Testing, and ensured that the documentation is in place;
• Performed risk analysis of the requirements to identify the key business risks areas for the project and prioritized the application testing;
• Facilitated weekly meetings with the review teams to continuously improve theQuality Assuranceprocess for the application testing;
• Interacted with the SMEs along with Operations Group, production support groups, and various teams on business side to help gather and analyze client specific business requirements and translate them in a various business artifacts to better understand the expected results;
• Participated in walk through sessions with the business users and the stakeholders of the project to facilitate the Business requirements gathering & documented them intoBusiness Requirement Documents (BRD) leading to BRD sign off process;
• Analyzed the existing business process flows for Fixed Income products to gain understanding of the existing system and documented the business process flows for the proposed system.
• Verified End to End Order flow from UI to downstream to Position Blotter (Risk and P&L)
• Executed different type of aggressive and passive orders with DAY, FAK, FOK
• Used HP ALM (Quality Center) to organize and manage all phases of the software testing process, including planning tests, writing test cases, executing tests, logging defects, tracking defects and creating Test Analysis Report (TAR).
• Experience in running automation testing codes in Selenium/Python.

Confidential, New York, NY

ETL Tester

Responsibilities:

• Involved in analyzing the Business requirement Documents (BRD) and Functional specification documents (FSD) to understand the application;
• Assisted the team with by writing and executing Test Cases, Test Plans for ETL testing;
• Interacted with developers to resolve software related defects issues;
• Ran SQL queries for data validation with Database;
• Developed estimation, test plans to outline the scope, analysis, approach, resources, schedule of testing as well as writing test cases, test execution, and test completion report;
• Attended walkthrough meetings for reviewing the testing process with the QA team, Developers, Projects Managers and Business Analysts;
• Developed several SQL queries to perform backend testing of the database;
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source;
• Extensively used SQL queries for data validation and backend testing;
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables;
• Prepared Test Cases based on ETL Specification Document;
• Tested all the ETL processes results developed to fetch data from front office trading application DB systems to the target Settlement Data warehouse using SQL queries;
• Tested the ETL results for feeds received from counterparties back office and compared with the data that was received from Front Office for consistency;
• Conducted source to target data mapping;
• Performed ETL validation using Informatica PowerCenter Workflow Manager and Informatica PowerCenter Workflow Monitor;
• Identified defects and errors in data prior to data processing;

Confidential

ETL Tester / SQL QA Analyst

Responsibilities:

• Developed SQL scripts to validate relational database tables.
• Written complex SQL queries for data validation and to verify the extract rules
• Database Validation (SQL) to check the update data in the database.
• Executed SQL queries on MS SQL Server Relational Database.
• Involved in writing and executing script for regression and functional testing using ALM.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• End to End regression and functional testing of all system components of the application and identifying test scripts for UAT.
• Utilized HP ALM for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Involved in testing of the trade settlement process for front office trading applications data;
• Tested all the ETL processes results developed to fetch data from front office trading application DB systems to the target Settlement Data warehouse using SQL queries;
• Tested the ETL results for feeds received from counterparties back office and compared with the data that was received from Front Office for consistency;
• Extensively used SQL statements to query the MS SQL Server for data validation and data integrity;
• Validated incremental iterative application releases using an agile process (Scrum);
• Tested User Interface inconsistency and application functionality;
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects;
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary;
• Created and executed test cases for all the required extracts and prepared test scripts for interface validation and End to End and Integration testing;
• Tested ETL solutions for integrating data from multiple trading and market data sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the data warehouse.
• Used JIRA to document and manage testing activities by creating and managing user stories, technical stories, use cases, and defects. Verified the optimal logics to load the data that business rules were based on flat file names or ragged hierarchy.
• Wrote SQL Statements to extract Data from Tables to verify the output Data of the reports.
• Performed all test assignments to ensure the application meets business requirements and Client expectations.

Confidential

Financial Institutions Specialist

Responsibilities:

• Cash management operations - maintaining and accounting of transactions on LORO and NOSTRO accounts of correspondent banks. Was personally responsible for “Raiffeisen Bank International AG” of Austria, “Commerce Bank AG” of Deutschland, Chinese bank “Agricultural bank of China” and some banks of Tajikistan, Russia and Uzbekistan.
• Correspondence and negotiations with correspondent banks on improvement of corresponding accounts services, searching of new and modern ways of transactions processing.
• Checking, routing and executing of SWIFT messages, customer and interbank payments, LC and guaranties (MT103 & MT202). Executing more than 200 outgoing and incoming payments daily.
• Daily forming/sending account statements of the banks.
• Forming and sending SWIFT requests and replies - amendments, cancelations, investigations of payments, about 300 compliance requests in a year, confirmations for forex transactions and interbank loans.
• Using technical facilities and tools of the Bank to improve operations of Financial Institutions Department.
• Participation in preparation of contracts on cooperation and maintaining the correspondent relations with local and foreign financial institutions.