We provide IT Staff Augmentation Services!

Sr Qa Analyst / Ba Resume

New York, NY

SUMMARY

  • 5+ years of extensive experience as QA/BA Analyst delivering high - quality software solutions in Management, Human Resources, Banking and Capital Markets Domains.
  • Have excellent analytical/problem solving skills. Analyzed Business and functional system requirements and use cases to efficiently work together with project managers, business analysts, developer team, and QA team on-shore and off-shore.
  • Solid skills in analyzing requirements, developing Test plans, writing and executing Test cases, mapping test cases to the requirements by creating RTM.
  • Bug reporting, bug tracking, managing and analyzing defect life cycle using SDLC management tools such as JIRA and HP/ALM.
  • Full understanding of quality control cycles via Validation and Verification and processes to comply with specified requirements. Active participation in monthly releases, pre-testing in DEV, SIT and UAT environments etc.
  • Experienced in backend testing, data migration, ETL processing from the end-to-end testing perspective.
  • Experienced in ETL process testing and performed different types of testing like Metadata testing, Data Quality testing, Data Completeness, Data Transfer.
  • Extensive knowledge of RDBMS systems such as SQL Server and Oracle databases.
  • Proficient in writing complex SQL Database queries to validate various workflow processes.
  • Proficient in writing SQL, PL/SQL Stored Procedures, Triggers and complex queries as part of my testing requirements.
  • Advanced in MS Excel including PivotTables, VLOOKUP, INDEX/MATCH, and Data Tables.
  • Solid knowledge Unix commands for troubleshooting the application and process behavior by accessing the log files.
  • Experienced in different types of testing such as, Regression, Functional, Integration, System, User Acceptance, Sanity, Performance, GUI, Database, etc.
  • Active participation in Scrum meetings, daily JIRA review meetings, scheduled stand-up calls with onshore and off-shore team members.
  • Absolutely strong team player with full dedication and commitment towards setting up goals/deadlines and learning new material. Ability to work effectively in both independent and team situations with positive results.

TECHNICAL SKILLS

RDBMS: MS SQL Server, Oracle, Mongo DB, MS Access

Languages: C++, R, Java, VB scripting, C#, .Net

Applications: Microsoft Office Suite (Word, Excel, PowerPoint, Outlook, SharePoint)

Tools: /Web tools: HP ALM, JIRA, Beyond Compare, REST API, Tomcat

Testing Methodologies: Waterfall, Agile, Scrum, Kanban

Operating Systems: Windows, Unix/Linux

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

Sr QA Analyst / BA

Responsibilities:

  • Analyzed and mapped process workflows across all the components of the ERP application using Microsoft Visio.
  • Actively involved in SCRUM processes and verified if the requirements gathering, development and testing timelines followed properly.
  • Actively participated in the forming process of BRD /FSD, Release Notes, Change Requests, performed requirements analysis.
  • Developed RTM, test cases and scenarios.
  • By using strong interpersonal skills and managemental knowledge coordinated daily and weekly meetings between Developers and Clients, summarized and reported notes to Management.
  • Tested data and process flow among various components of the application to verify if all the components are fully integrated.
  • Tested User Interface inconsistency and application functionality.
  • Validated generated external report forms and content by comparing database data and report outputs using complex SQL queries.
  • Created complex SELECT, UPDATE, INSERT and DELETE statement using multiple tables and views to prepare test data based on the different test scenarios and validate the results.
  • Performed data validation on the source feed files that were generated in UNIX environment using UNIX commands, as necessary.
  • Participated in cross-functional discussions to review impact of added functionalities and/or change requests from internal/external interfaces on the quality of the application.
  • Performed Functional, GUI, Regression, System, and Integration testing.
  • Utilized JIRA to develop, organize, and manage all phases of testing life cycle.
  • Ensured comprehensive test coverage by understanding test scope and approach of dependent groups.
  • Logged and prioritized defects; performed root cause analysis to provide suggestions regarding process improvements and to avoid repeat issues etc.

Confidential - New York, NY

QA Analyst

Responsibilities:

  • Involved in analyzing the Business requirement Documents (BRD) and Functional specification documents (FSD) to understand the application.
  • Involved in functional, end-to-end and regression testing of Trade booking and settlement logic as well as related ETL processes developed to fetch data from front office DB systems to the target data warehouse using complex SQL queries.
  • Worked with the BA and dev team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
  • Extensively used SQL statements to query the Oracle Database 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.
  • Tested ETL with FO data as source and tables in the settlement databases warehouse as target.
  • Tested ETL process for feeds received from counterparties' back office and compared with the data that was received from Front office for consistency.
  • Tested all the reports generated using SSRS tool by validating the data in the report against the database according to the requirement specifications using SQL.
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse.
  • Developed several SQL queries to perform backend testing of the database.
  • Involved in writing and executing Test Cases for manual and automated Testing.
  • Used Quality Center to write and execute test cases, verified actual results with expected results.
  • Worked with Quality Center in writing and executing test cases, to track and report system defects and bugs and assigned severity ratings.
  • Performed End to end testing starting from the source to the report.
  • Managed Offshore team and Organized testing schedule and resource allocation.
  • Responsible to perform UAT and get UAT sign off from business users.
  • Designing the entire documentation like Test Plan, Test Scenarios, Detailed Test Cases and Test Results in HP ALM for specific projects.
  • Written modification requests for the bugs in the application and helped developers to track and resolve the problems.

Confidential - Jersey City, NJ

QA Software Tester

Responsibilities:

  • Verified End to End Order flow from UI to downstream to Position Blotter (Risk and P&L)
  • Validated different types of end-to-end flows like Order flow and Post trade booking flow.
  • Executed different type of aggressive and passive orders with Limit, Stop Loss orders.
  • Validated all components of e-trading application like ECN Gateways, Matching Utilities, User Session, Transaction Manager etc.
  • Used Unix for Process and File management and to monitor log files.
  • Worked with automation team by providing Test Cases for functional and regression testing.
  • Helped to QA lead in writing Test plans and Test strategy document.
  • Attended in walkthrough meetings for reviewing the testing process with the QA team, Developers, Projects Managers and Business Analysts.
  • Used HP ALM (Quality Center) to organize and manage all phases of the software testing process, writing test cases, executing tests.
  • Involved working with offshore team to deliver projects on timely manner and on budget.
  • Extensively worked with Trade Order Management Systems for testing the Trade Capturing, Processing, Confirmation/Matching, Settlement & Notification functionalities.
  • Handled responsibilities of identifying and preparing defect reports gathered from testing.
  • Performed the tasks of preparing test reports as well as developed formal acceptance test procedures.
  • Verified Order flow, trade booking and recording in DB via different trade scenarios including artificial trade status simulation. Used SQL to write queries for Back-End testing to verify data and trades scenario simulation.
  • Executed Functional, Regression, System and Integration testing of the application.
  • Validated Market data flow from different ECNs such as Market Access, Option Desk and FinPro.
  • Used JIRA to manage and organize all phases of the software testing process: writing test cases, executing tests, logging defects, tracking defects.
  • Performed problem solving and root cause analysis when defects occur.
  • Performed various testings for checking the reliability and response time of the application.
  • Involved in selecting the test cases to be automated.
  • Participated in daily Scrum meetings and weekly team meetings and discussed Enhancement and Modification requests.
  • Worked closely with Business Analysts, and Project Managers to discuss and collect business requirements.

Hire Now