We provide IT Staff Augmentation Services!

Senior Qa Analyst Resume

Boston, MA

PROFESSIONAL SUMMARY:

  • Senior QA Analyst with 15+ years of hands - on IT experience testing data warehousing/BI Reporting, mainframe, client-server and web based systems in the Financials and Capital Markets Domain.
  • Experienced in all phases of software testing life cycle (Requirements analysis, test planning, test case development, environment setup, test execution and test cycle closure).
  • Configured the QA environment and prepared appropriate mockup test dataset to execute test cases.
  • Solid experience in the design and development of functional/ regression test automation framework (Data-Driven/Keyword-Driven) using QTP/UFT and Quality Center/ALM.
  • Developed QTP/UFT scripts to support test automation using VB Scripting, object repository, Descriptive Programming, regular expression and XPath.
  • Proficient inperformance testing applications using load-testing tool such asLoad Runner
  • Experienced in Capital Market functions like Order Management Systems, trade processing, Trade Validation, Trade Enrichment, Allocations, Confirmation, Affirmations
  • Experienced in testing Trading applications using FIX/FIXML messages like heartbeat, logon, logout, resend request, reject, sequence, pre-trade, trade and post-trade messages.
  • Analyze and validated FIX messages in the log file using Unix commands and ValidFIX (FIX log analyzer tool)
  • Tested XML requests and responses of web services using SOAP and REST protocol on SOAPUI.
  • Strong domain knowledge in capital market products including equity, fixed income, Currencies (FX), Derivatives (options, futures, forward and swaps), ETF, mutual fund, and Swap.
  • Experienced in testing end-end trade life cycle for all asset classes including EQ, FI and Derivatives
  • Experience in testing payment versus payment (PvP) FX settlement, real time gross settlement (RTGS) systems and multilateral payment netting using SWIFT inbound and outbound payment messaging standard
  • Strong experience in reference data and market data feeds including Bloomberg, Reuters, NASDAQ and NYSE.
  • Solid understanding of RDBMS (Oracle, SQL Server and Sybase), relational (OLTP) and dimensional (OLAP) data model including star and snowflake schema
  • Wrote complex SQL queries using joins, subquery, inner query, nested query, inline view and oracle analytical functions for ETL/DWH/Business Intelligence Reports and backend testing.
  • Exposure to Dodd-Frank swap data reporting and regulatory reporting such as OATS and TRACE.
  • Extensively used JIRA and QC /ALM to manage test deliverables (requirements traceability, test plans, test strategy, test cases, test execution results and defects life cycle) using Waterfall and Agile /Scrum.
  • Led multiple projects with onsite and offshore resources, provided test estimates (resources and hours)
  • Managed sprint planning, daily scrum calls, monitoring and tracking defects and establish communication plan

TECHNICAL SKILLS:

Automation Tools: QTP/UFT/ALM

Messaging Protocols: FIX, SWIFT, MQ, SOAP, FTP, UDP, TCP/IP, TIBCO and HTTP

Scripting: VBScript, Java Script, Korn Shell and Perl

Testing Tools: LoadRunner, SQL Loader utility, VMWare, 3270 client, PuTTy, Splunk & Ultra Edit

Misc. Tools: UC4 and Control-M, JConsole and ValidFIX

Databases: Oracle, SQL Server and Sybase

Database Client Tools: TOAD, SQL Navigator and Oracle SQL Developer

ETL/Reporting Tools: SSIS and, Informatica Power Center, SAP Business Objects and IBM Cognos Business Intelligence

Environment: / Languages: DotNet, C/C++, C#, Java, J2EE, SOA,WSDL, XML, UDDI,Websphere, Apache and Tomcat

Configuration Management: VSS, CVS and SVN

Test Management Tools: IBM Clear Quest, JIRA and HP Quality Center/ALM

Operating Systems: Windows, Mainframe, Unix Solaris and Linux

Domain Experience: Capital Markets, Exchange, Asset Management, Trading and Investment Services

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Senior QA Analyst

Responsibilities:

  • Used Agile/Scrum methodology to ensure the new features meet the customer requirements (user stories) and acceptable quality assurance standards
  • Analyzed user stories to create project documentation, including Test Strategy, Entry Criteria, Exit Criteria, Test Scripts, Test Execution Plans and Test Exit Report.
  • Communicated effectively with Project Managers, Development and Test teams throughout the test life cycle to provide clear objectives and report on progress and issues in a timely manner using ALM/QC
  • Performed functional, integration and regression testing using ALM/QC tool
  • Automated regression scripts using Automation Test Manager (QTP/UFT) framework (data & keyword driven)
  • Configured test environment, created the test data and mocked up the existing data to simulate test conditions.
  • Validated accrual calc for short trading (borrowed) and margin lending (rehypothecated) long position
  • Performed end-end trade-locate matching process in the prime brokerage workstation
  • Tested trades, positions, pricing rules, accrual rules and client profile rate/locate schedules for shorts and Long
  • Tested revenue share reports for hard to borrow securities.
  • Wrote complex SQL queries to verify PBW business rules and data quality
  • Extensively used UNIX shell scripts and commands for fetching and checking the Log files.

Environment: HTML5, CSS3, Angular JS, JAVA, Mainframe, Rumba 8.1, Tomcat, MQ Series, QTP/UFT 12.2, ALM/QC, JIRA, Oracle SQL Developer, Oracle 11g, DB2, Linux, VI, SSH Tectia and ETL (Informatica).

Confidential, New York, NY

Senior QA Analyst

Responsibilities:

  • Reviewed & analyzed business requirements, functional requirements, and other technical documentation to create Project Documentation, including Test Strategy, Test One Liners, Entry Criteria, Exit Criteria, Requirements Traceability Matrix, Detailed Test Scripts, System Regression packs, Test Execution Plans and Test Exit Report.
  • Worked towards process improvement while leading global team meetings, stakeholder group meetings, strategic defect tracking, managing onshore and offshore resources, analyzing variances and initiating corrective actions inclusive and collaborative with all project stakeholders.
  • Collaborated with Risk Business Analysts & Developers for review and updating COSS (Core Settlement Simulator) used by CLS risk management team for simulation and modeling of settlement process using DB2 and SQL Server databases which included performance testing of the Settlement Engine with large datasets.
  • Performed smoke, functional, integration, regression and UAT testing using ALM
  • Configured test environment, created the test data and mocked up the existing data to simulate test conditions.
  • Performed settlement risk testing (Liquidity Risk, Credit Risk and Market Risk) for FX Transactions i.e. FX Spot, FX Forward, FX Swap and FX Options
  • Conducted end to end testing of trade life cycle including trade capture and validations, matching, netting and funding
  • Developed complex SQL queries to validate FX core business rules, risk parameters and data integrity
  • Used VI editor, UNIX commands/utilities such as Grep, AWK, Sed etc. for fetching and checking the Log files.

Environment: J2EE, SWIFT, WebSphere, XML, MQ Series, ALM, JIRA, Oracle SQL Developer, Oracle 11g, SQL Server, DB2, Linux, VI editor, SSH Tectia, UltraEdit-32, CyberArk and ETL.

Confidential, New York, NY

Sr. QA Analyst

Responsibilities:

  • Participated in requirements and technical specification review meeting with business user, BA, developer and system engineers to identify test strategy and define testing scope for manual and automated testing
  • Developed and executed test scenarios and test cases from the use cases/user stories to conduct smoke, functional, integration, regression and UAT testing using ALM
  • Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage
  • Configured test environment, create the test data and mock up the existing data to simulate the test conditions.
  • Communicate effectively with Project Managers, Development and Test teams throughout the test life cycle to provide clear objectives and report on progress and issues in a timely manner.
  • Verified SWIFT confirms/advices for Payment, investment and securities request as per mapping specs
  • Tested end-end funds payments and ARs at various state including OFAC scanning and STP vs Repair
  • Performed trade life cycle testing for Outright Treasury (T-Bills, T-Notes, T-Bonds, TIPS and Floating Rate Notes) and Outright AMBS and SecLending Operations
  • Simulated and validated Fedtrade Repo operation for three collateral types: U.S. treasuries, Federal Agency Securities and Mortgage Back Securities
  • Developed QTP/UFT scripts in Standard and Low level recording format and used Shared Object Repository to store all test objects. Implemented synchronization points, standard check points, Text check points and XML checkpoints to carryout Regression testing.
  • Design complex SQL queries to validate business rules, data integrity and customer balance reconciliation
  • Investigate issues found during QA cycle by searching log files and database tables using unix commands/utilities such as grep, awk, sed as well as shell scripts and SQL Queries
  • Analyze test results and tracking defect life cycle and generate daily test execution and defect reports

Environment: J2EE, JMS, JDK, SWIFT, WebSphere, XML, MQ Series, QTP/UFT,VBScript, ALM, JIRA, Oracle SQL Developer, Oracle 11g, ETL, Linux, VI editor, SSH Tectia and UltraEdit-32

Confidential, New York, NY

Senior QA Analyst

Responsibilities:

  • Participated in requirements (user stories) and technical specification review meeting with business user, BA, developer and system engineers to identify test strategy and define testing scope for manual and automated testing
  • Developed test strategy and test cases based upon user stories to conduct functional, integration and regression testing using Quality Center
  • Collaborate often with development, business and support teams to clarify specs, raise issues/concerns and identify risks throughout the software development life cycle (Agile/Scrum)
  • Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage
  • Set up accounts, set up dollar-trading limit for owner's accounts, permission products for accounts and permission brokers to trade certain accounts as a Clearing Member using the Account Manager Tool
  • Managed entitlement to users, traders and firms using Security Admin GUI Tool
  • Construct FIXML deal/trade messages based on CPC API implementation template using XML Spy
  • Validated deal clearing status in the CPC GUI trade blotter screen by submitting deal with various financial products (Futures, Options, Swaps and OTC FX Forwards) through CPC GUI and CPC API (FIXML) via HTTP and MQ transport
  • Validate the settlement prices for various futures and options contract in the ESS
  • Perform backend testing using complex SQL queries to check business rules and data integrity
  • Performed data validation using excel VBA, VLOOKUP, HLOOKUP and other built-in excel functions
  • Analyzed and summarized large amount of data to create Ad-hoc report using excel pivot tables
  • Analyze test results and tracking defect life cycle and generate daily test execution and defect reports
  • Investigate production issues by recreating in test environments, working with development for resolution and coordinating with support for release.
  • Investigate issues found during QA cycle by searching log files and database tables using unix commands/utilities such as grep, awk, sed as well as shell scripts and SQL Queries
  • Provided training, mentoring, and troubleshooting for Junior Quality Assurance Team members

Environment: XMLSpy, XML, FIXML, JDK 1.6, HTTP, MQ Series, Splunk, Sonic, UC4 Job Scheduler, Quality Center, JIRA, Clear Quest, TOAD, Oracle 10g, Linux, vi editor and PuTTy

Confidential, New York, New York, NY

Senior QA Analyst (Risk Technology)

Responsibilities:

  • Developed test strategy, test plans, test scenarios, detailed test cases using use case documents, business requirements and functional specifications and executed test cases for smoke, functional, cross browser, cross platform, integration and regression testing using Quality Center. Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage
  • Tested sensitivities (VaR and PnL) across all risk classes for all financial instruments via Monju UI (Java)
  • Implemented data-driven test automation framework in QTP/VBScript for regression testing of Monju UI
  • Written shell scripts to invoke the SQL Loader to load the data into oracle DB from flat files using control files
  • Developed and executed advance SQL statements for data extraction, data creation and data validation
  • Validated risk measure calculations (prices, greeks such as delta, vega, gamma, FX Exposure, Rho) in the GMRR database for front office trading system feeds such as the internal equity trading system
  • Reconciled the market risk data in GMRR against existing applications in Nomura such as applications (cubes) to show Equity and FX sensitivities
  • Strong data analysis skills and ability to track data element from source through transformation to target using advanced excel functions, OLAP cube and Pivot table to validate and reconcile market data
  • Performed ETL/data warehouse testing (metadata, data completeness, data accuracy, data transformation and data quality, constraint, date, null, duplicate validation and data cleanness) using SQL queries
  • Validated cube and query data from the reporting system back to the source system.
  • Analyze and report test results. Report, track and monitor defects in JIRA
  • Escalate concerns, issues and risks to the appropriate stakeholders in order to meet project deadlines

Environment: SSIS (ETL), SQL Server 2008, SAP BO, Autosys, Java,J2EE, JIRA, Quality Center, QTP, VB Script, Java Message Service (JMS),OLAP Cube, Pivot Table, Linux 2.6 and PuTTY

Confidential, New York, NY

Senior QA Analyst

Responsibilities:

  • Participated in requirements and technical specification review meeting with business user, BA, developer and system engineers to identify test strategy and define testing scope for manual and automated testing
  • Developed test strategy, test plans, test scenarios, detailed test cases using use case documents, business requirements and functional specifications and executed test cases for smoke, functional, integration, regression, performance and UAT testing using Quality Center
  • Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage
  • Implemented keyword driven test automation framework using QTP to reduce regression testing cycle time
  • Performed trade life cycle testing (trade capture, execution, validation, confirmation, clearing and settlement) in Longview trading system (OMS)
  • Validated order flow in the Longview OMS and port ware (execution system) with FIX Trade Messages
  • Developed ETL test scenarios and test cases based on test matrix to perform ETL/DWH testing (data completeness, data accuracy, data transformations, data quality, data cleanness, performance and scalability)
  • Developed and executed SQL queries to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
  • Performed count validation, dimensional analysis, statistical analysis and data quality validation in data migration and extensive SQL querying on staging, data warehouse and data maEnsured error logs and audit tables are generated and populated properly
  • Involved in troubleshooting, resolving and escalating data related issues to improve data quality
  • Written shell scripts to invoke the SQL Loader to load the data into oracle DB from flat files using control files
  • Worked with ETL group and business analyst for understanding mappings for dimensions and facts
  • Tested a number of complex ETL mappings, maplets and reusable transformations for daily data loads
  • Extracted data from various sources like Oracle, flat files and DB2 server
  • Tested FIX messages like heartbeat, logon, logout, resend request, reject, sequence, pre-trade, trade and post-trade messages using Exchange simulator QuickFix/J (Fix Engine) and FIX message Parser.
  • Analyze and validated FIX messages in the log file using ValidFIX (FIX log analyzer tool)
  • Performed data analysis, developed SQL queries for testing and troubleshooting against data warehouse
  • Developed and executed automated UNIX shell scripts to reduce data analysis and testing efforts by up to 50%
  • Performed data warehouse testing using complex SQL queries with oracle analytical functions.

Environment: FIX Protocol, Exchange Simulator (QuickFix/J), ValidFIX, Control-M Job Scheduler, Cognos BI Tool, Oracle, TOAD, SQL Loader, QC, QTP, VB Script, LoadRunner ETL and PuTTY

Confidential, New York, NY

Software Quality Analyst

Responsibilities:

  • Heavy interaction with the user, business analyst, development team, DBA's and System engineers to test the web based financial systems such as Equity, Fixed Income and Options trading
  • Designed and developed test plan, test scenarios and test cases from technical specification and requirement documents for Equity Product (gsonline) in the Equity Capital Market Division
  • Developed an automation model to automate manual test scripts (smoke test scripts) for Private Wealth Management product (gs.com) using QTP
  • Significant experience testing trading/portfolio management applications.
  • Develop LoadRunner scripts for Load/performance testing of the Confidential financial applications (gsonline and web portal ) for institutional client
  • Performed smoke, functional, system and regression testing utilizing Quality Center
  • Strong business knowledge of equity, fixed income and options trading
  • Web based QC is Utilized to manage the QA life cycle (including bug life cycle)
  • Created and manipulated large test feeds and setup QA environment for User Acceptance Testing
  • Developed and implemented complex SQL statements for back end database testing for financial applications
  • All projects went live successfully on-time within budget without major issues

Environment: Oracle, QTP, LoadRunner and Quality Center

Confidential, Jersey City, NJ

Senior QA Analyst

Responsibilities:

  • Reviewed user stories/use cases/BRD with business user, BA, developer and system engineers to identify test strategy and define testing scope for manual and automated testing
  • Developed test strategy, test plan and test cases based upon specification documents and performed functional, cross browser, cross platform, integration, regression and failover testing using QC
  • Developed and executed data-driven test automation framework in QTP/VB Script to conduct regression testing
  • Performed trade life cycle testing (trade capture, execution, validation, confirmation, clearing and settlement)
  • Validated order flow in the Order Management Systems via applications such as Trade Architect, Strategy Desk, Streamer suite, command Center and SnapTicket to the AOM Broker GUI.
  • Validated flow of trades to the Confidential Back Office System (BOS) via AOM order management system
  • Validated Market Data across various TDA Quote Plant components (Data Includes: Bonds, Stocks, Options, Future Options, Equities, Mutual Funds, and Money Market Funds) using Web Services via SOAP/WSDL
  • Tested Market Data flow in the TDAmeritrade Consuming GUI applications such as AOM Broker GUI, Trade Architect, Strategy Desk, Streamer suite, Quote Tracker, command Center and SnapTicket
  • Tested FIX messages like heartbeat, logon, logout, resend request, reject, sequence, pre-trade, trade and post-trade messages using Exchange simulator QuickFix/J (Fix Engine) and FIX message Parser.
  • Analyze and validated FIX messages in the log file using ValidFIX (FIX log analyzer tool)
  • Design complex SQL queries to validate business rules, data integrity and customer balance reconciliation
  • Developed and executed FIX Session- level and application-level test cases with expected behavior
  • Investigate production issues by recreating in test environments, working with development for resolution and coordinating with support for release.
  • Investigate issues found during QA cycle by searching log files and database tables using unix commands/utilities such as grep, awk, sed as well as shell scripts and SQL Queries

Environment: SOA, SOAP, WSDL,XML,UDDI, JDK 1.6, JConsole, JMX, Quality Center, OATS/TRACE, FIX Protocol, Exchange Simulator (QuickFix/J), ValidFIX, QTP, TOAD, Oracle 10g and Unix/Linux/PuTTY.

Hire Now