We provide IT Staff Augmentation Services!

Senior Qa Analyst Resume

NY

SUMMARY

  • Over 9+ years of experience in IT industry in Software Testing of Client/Server, Reporting, Database, Data Warehouse and Web based applications with manual testing and using automated testing tools
  • Experience in testing Financial Domain applications which included Asset Management, Mutual Funds, Securities, Portfolio Management, Fixed Income and Trading Applications
  • Extensive experience withSoftwareQuality AssuranceTesting onGUIbasedClient - Server&Web Based applications, ETL, Web Services, Data Driven Applications, Data Warehousing projectsusingManualandAutomated testingprocedures
  • Involved in various stages of Software Development Life Cycle (SDLC) implementingWaterfall,V-Model,Agile, Iterationmethodologies
  • Experience in Testing Tools: HP ALM, HP/Mercury Test Director /Quality Center, JIRA, IBM Clear Quest, QTP/UFT
  • Proficient in developing/writing Software Test Plans, Test Case Design, and Test Scripts based on User Requirements, Specifications and System Requirements documents.
  • Worked onWeb ServicesTesting usingSOAP UI 4.0/3.0
  • Expertise in data validation using complex SQL queries on Database and creating queries using Cognos Query Studio and Report Studio for testing reports developed in COGNOS 10
  • Solid experience in back-end testing using SQL queries
  • Experienced in Black Box, White Box, Smoke Testing, Sanity, Shakeout, Integration, Regression, Functional, Front End and Back End Testing
  • Efficient in implementing QA processes, establishing standards, procedures and methodologies
  • Strong Business and Functional exposure on various business applications involving Portfolio Management, Mortgage Banking, Credit Ratings
  • Possess extensive experience in analyzing the Business Requirement Documents, Functional Specifications and Technical Specifications
  • Extensively involved in Creating Status reports and closely worked with Project Manager
  • Extensively involved in smoke testing, user acceptance testing, functional testing, integration testing, database testing and regression testing
  • Experience in working with offshore and onsite teams
  • Able to work under pressure to meet deadlines and the ability to work in a cross-functional environment. Effectively able to work as a team member as well as independently
  • Excellent verbal and communication skills with the ability to successfully work with all levels of IT professionals and end users
  • Ability to interact with end users, also quick learner and team player with good communication skills

TECHNICAL SKILLS

Defect Tracking /Project Tracking Tools: ALM, Test Director/Mercury Quality Center, Rational Clear Quest, Bugzilla, Version One, Serena, JIRA

RDBMS: Oracle, MS SQL Server, Sybase, MS Access, Progress DB 4GL

DB Tools: SQL DBX, SQL*LOADER, SQL Navigator, TOAD,SQL Developer, Squirrel

ETL Tools: Informatica

Text Editors: Ultra Edit, Text Pad

Operating Systems: Windows 98,NTand XP, UNIX

Testing Tools: Selenium, QTP, Win Runner

Web Services: SOAP UI

Languages: C, SQL, Visual Basic, Java & VBScript

Microsoft Suite: MS Office Tools

Reporting tool: Cognos 10

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior QA Analyst

Responsibilities:

  • Involved in testing of Hedging Calculator system which included verification of Hedge Factor sensitivity, security weights, Index & Fund Aggregate and number of Hedge contracts.
  • Performed data validation on new reportsusing COGNOS Query Studio, Report Studio, and Databases by SQL Queries.
  • Validated reports ofvarious funds (Alternative, Domestic Debt/Equity, Emerging Markets, Global Debt, Global/International Equity, and Global Multi Asset, Municipal Bond etc.) to master systems data.
  • Compared the reference data (securities, prices, benchmarks & index) data to security master. Locked the issues in Jira. Tested the issue after it has been addressed by Dev team.
  • ValidatedInvestments Data Warehouse security data to Bloomberg for common stocks & fixed income (foreign, corporate, muni)
  • Testing of ETL jobs that are scheduled for file transfers from Vendor Data Sources to designated file systems/directories
  • Responsible for validating the ETL process of data from various systems into IDW.
  • Responsible for validating the Duplicates, Not Null, Counts and Business Transformation rules on ETL
  • Performed extensive Database Testing by writing complex SQL Queries and by executing stored procedures on SQL Server Database
  • Involved in testing of reports that consists of Analytical and Performance data.
  • Involved in the meetings with Business Analysts, Technical Architects, and SMEs in understanding the requirements and the design decisions.
  • As a member of the scrum team participated in daily standup meetings, project status meetings as well as retrospective meetings and iteration reviews.
  • Deploying the reports and packages from Development to QA & UAT environments.
  • Extensively used the AutoSys jobs for the entire project.
  • Validation of data integrity across multiple related systems and their processes
  • Involved in Functional testing, Regression testing, Integration testing, User Acceptance Testing(UAT), Data validation Testing and End to End testing of the system after new enhancements were implemented
  • Involved in documenting test cases for the user stories tested in each sprint in ALM
  • Co-ordinate with Business Users and Technical team for the smooth process of UAT (Including coordination for test data, Bug reporting and tracking, conducting the daily status meeting on the testing)

Environment: Java, SQL Server 2012, SQL Server Management Studio, SQL DBX, Informatica Power Center 9.1, Windows 7, IE, Compare It, Flat files, Notepad ++, Tomcat6.0, JDK1.7,C#/.net, Jira, HP ALM 11, COGNOS 10, AutoSys, IXP, Visual Diff, AGILE/Scrum, Bloomberg Terminal, MARKIT EDM

Confidential, NY

Senior QA Analyst

Responsibilities:

  • Involved in the meetings with Business Analysts, Technical Architects, SMEs in understanding the requirements and the design decisions
  • Responsible for Test Planning, Environment Setup, Designing Tests and Execution of the test cases in different test cycles
  • Prepared Test Strategy, QA Test Plan, Test Procedures, Traceability matrix based on project Requirements
  • Co-ordinate with Business Users and Technical team for the smooth process of UAT (Including coordination for test data, Bug reporting and tracking, conducting the daily status meeting on the testing)
  • Responsible for UI, Functional, ETL, Reports Testing of Web, Reporting applications
  • Involved in Testing of NETX 360 application during implementation in Guardian/PAS, and integration testing with Envestnet application
  • Involved in discussions with developers for test cases, test plan, defect tracking, updating the bug status
  • Involved in Test effort estimation and dependencies
  • Responsible for validating the ETL process of data from the ODS and SharePoint source systems into the Flat File target system
  • Responsible for validating the Duplicates, Not Null, Counts and Business Transformation rules for the flat files
  • Performed extensive Database Testing by writing complex SQL Queries and by executing stored procedures on SQL Server Database
  • Validation of data integrity across multiple related systems and their processes
  • Involved in testing of data in Adhoc Reports and Standard Reports in ADW
  • Involved in testing of daily and quarterly reports issued
  • Validation of the order entry, position and balances, holdings of the account holders in Netx360 application
  • Involved in Data Analysis according to the BARS’ business rules and identify missing dataon clients and their accounts against the Vendor sourced client data
  • Participate in UAT phase for production releases and Enhancements
  • Participated in Production deployments and Sanity testing

Environment: - VB, Java, SQL Server 2008/R2,SQL Server Management Studio, NET 360, DB2, ASP.NET, IIS Server, Windows 7, IE, Text Pad, Beyond Compare, MS Excel, AGILE/Scrum

Confidential, South Brunswick, NJ

Senior QA Analyst

Responsibilities:

  • Reviewed and analyzed Requirements for developing test scenarios
  • Interacted with Business Analysts, Developers in Requirement Analysis, design reviews, testing and documentation for application developed in Agile environment
  • Developed test plans, test scripts and scenarios work flows according to the user requirements
  • Responsible for UI, Functional, Cross browser Testing of Web and J2EE applications
  • Involved in extensive DATA validation using Excel
  • Written SQL queries using joins, nested queries while performing back-end testing
  • Coordinated with offshore team in writing and execution of test cases
  • Actively participated in Scrum meetings, reviews and developed test scenarios for User stories
  • Involved in cross browser testing of the application.
  • Involved in End to End testing of the application for enhancements and defects retesting.
  • Involved in the preparation of UAT test cases and UAT testing
  • Documented and published test results in InfoPath, troubleshooting and escalate issues
  • Used Quality Center/ALM for defect tracking, test cases, test plan, updating the bug status and discussed with developers to resolve the bugs
  • Involved in Test effort estimation and dependencies
  • Participated in Production deployments and Sanity testing.

Environment: - PowerBuilder, Oracle 10/11g, Toad, SQL Server, SQL Management Studio, HP Quality Center, Version One, Serena, Windows XP, Chrome, Firefox, IE, MS InfoPath, Microsoft Excel, J2EE, Ajax, JavaScript, AGILE/Scrum

Confidential, Jersey City, NJ

QA Analyst

Responsibilities:

  • Participated in meetings with project team members on Overview and Architecture
  • Reviewed and analyzed Requirements for developing test scenarios
  • Developed test plans, test scripts and build scenarios, work flows according to the user requirements
  • Responsible for UI, Functional, Cross browser Testing of Web and J2EE applications
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Involved in testing of various interfaces involving databases, XMLs, Data Files
  • Validation of data integrity across multiple related systems and their processes
  • Validation of data passed downstream from one or more systems to make sure that it doesn't disrupt any other downstream systems
  • Validated straight pass through fields, derived fields and enumerated fields across all interfaces
  • Used FileZilla to FTP for downloading XMLs
  • Verified Test Data in XML and .DAT format for interface testing using Ultra Edit
  • Performed Database testing using Progress DB/Squirrel, Oracle/SQL developer to test database integrity
  • Involved in system testing, functional testing, regression testing and UAT on the application under test
  • Interacted with Business Analysts, Developers in Requirement Analysis, design reviews, testing and documentation for application developed in Agile environment
  • Actively participated in Scrum meetings, reviews and developed test scenarios
  • Documented and published test results, troubleshooting and escalated issues
  • Used Quality Center to document and open defects and track them from time to time
  • Participated in walkthrough and defect report meetings periodically

Environment: J2EE, HTML, Progress DB 4GL, Mainframes, Squirrel, JIRA, UNIX, XML, Quality Center 10.0,Oracle 10, SQL developer, Ultra edit, Windows XP, FileZilla, SharePoint, AGILE/Scrum

Confidential, Princeton, NJ

QA Analyst

Responsibilities:

  • Developed test plans based on Business Specifications for multiple projects.
  • Responsible for UI, Functional, Web Services, Cross browser, ETL, Reports Testing of Web, SOA, Reporting, J2EE applications
  • Analysis of data from different interfaces/feeds and Process Data files(Account, Transaction & Positions files) through Financial Data Network (FDN) process which involves data validation, Transformation, Normalization and Augmentation.
  • Involved in loading of FDN output data in to Confidential database using Data Load process.
  • Involved in testing of various reports in Confidential Wealth Reporting system
  • Involved in testing of values like Rate of Return, Gain/Loss in various assets like Stocks, Bonds, Mutual Funds which are included in the Performance Reports.
  • Involved in testing of Fixed Income Reports which includes Accrual details, cash flow projections and Yields.
  • Involved in functional and performance testing of Web Services/SOAP UI using various advisor and investor id’s
  • Involved in build release methodology, which is carried out between the development and testing phase.
  • Performed Black Box Testing, System Testing, System Integration Testing, Backend Testing, Regression Testing, Performance Testing, Functional Testing
  • Performed regression tests and sanity tests for various builds.
  • Coordinated with offshore team in writing and execution of test cases
  • Reviewed the test cases written by the team members and suggested any updates if necessary

Environment: J2EE, HTML, SQL, Informatica Power Center 8.1, QTP 9.2, Quality Center 9.0, Oracle 10g, Ultra Edit, Beyond Compare, Toad, Unix, Soap UI Pro, Windows XP, WinSCP

Confidential, Roseland, NJ

QA Analyst

Responsibilities:

  • Analyzed Business Requirements and General Design Documents
  • Involved in developing Test Plan, Test Cases & Test Scripts
  • Involved in developing BPT(s) in QC
  • Involved in testing of reports generated for dependents becoming ineligible
  • Performed End-to-End testing manually
  • Responsible for UI, Functional, Reports Testing of Web application
  • Analyzed the application, performed Black Box testing
  • Involved in analysis and testing of issues in UAT phase
  • Performed functional testing & Regression testing using QTP
  • Performed functional testing, Integration testing, System testing and Regression testing
  • Involved in Defect review meetings
  • Used Quality Center to track, analyze and document defects

Environment: J2EE, Java, JSP, IE, Web sphere 5.2, Oracle, eTracker, Rational Clear Quest, Rational Clear Case, Quality Center, QTP

Confidential, San Antonio, Texas

QA Analyst

Responsibilities:

  • Analyzed Business Requirements and General Design Documents
  • Involved in preparation of Test Plan and writing Test Cases
  • Created, Updated and maintained Test Scripts for different builds and releases
  • Attended several walkthrough meeting with the Business Analysts, Project Manager and developers and provided feedback accordingly
  • Responsible for UI, Functional, Cross browser Testing of Web and J2EE applications
  • Involved in preparing scenarios for the regression testing using QTP
  • Execution of the test scenarios and scripts and review of product functionality
  • Manually written the SQL queries to test the back end database
  • Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan
  • Performed web specific testing like Link testing, Browser page testing, Application Testing, Security testing

Environment: WIN NT/2000, Java 2, JSP, HTML, Servlets, XML, SQL Server 2000, Oracle, WSAD (Web Sphere Application Developer 5.1.1), WAS 5.1.1(Web Sphere Application server), Java Script, IE, QTP, Quality Center

Hire Now