We provide IT Staff Augmentation Services!

Sr. Qa Analyst Resume

2.00 Rating

Bridgewater, NJ

SUMMARY

  • Over 10+ years of professional experience in Information Technology, with extensive experience in performing Manual and Automation and ETL Testing.
  • Expertise in STLC (Software Testing Life Cycle) & Defect Management Life Cycle.
  • Extensive knowledge in analyzing requirements, writing and executing Test plans, Test cases and QA Procedures, setting up test environment, preparing test data, creating defect documentation, requirement traceability matrix and test summary reports.
  • Expertise in entire QA Life Cycle Process, which includes design and development of Testing Methodology, Test Strategy, Test Scenarios, Test Plans and Test Cases.
  • Experience in various aspects of (SDLC) Software Development Life Cycle and Agile/Scrum and Water fall SDLC Process.
  • Experience in manual testing using UI testing and proficient in Black and White Box Testing, Regression Testing, User acceptance Testing, Regression, Continuous Integration Testing with Iterations and API Testing.
  • Experience in Databases Oracle, SQL Server, MS Access, Excel and DB2 and Hive.
  • Experience in ETL Testing and BI process and Data ware house testing.
  • Experience in Testing Business Intelligence (BI) reporting tools using Cognos, BO, and Jasper. Have tested several complex reports including Dashboards, summary reports, master detailed, drill down, drill through and score cards.
  • Expert in writing complex SQL queries and data verification for back - end testing for Applications.
  • Expertise in Problem solving and Bug Tracking Reports using Bug tracking Tools like JIRA, ALM/QualityCenter and Bugzilla.
  • Experienced in SQA (Software Quality Assurance) including Manual and Automated testing with tools such as Selenium RC/Web-Driver/IDE/Grid and Junit/Test-NG, Quality Center, JIRA.
  • Experience in Designing and implementing in different automation frameworks from scratch like Page Objects framework, Keyword Driven framework, Data Driven framework and Hybrid framework.
  • Knowledge in BDD& ATDD scripts with Cucumber and writing step definitions for behavior.
  • Effective in working independently and collaboratively with offshore and onshore
  • Experience in continuous testing with Service Now.
  • Proven skills in Leading and training teams, Test Management and Meeting the deadlines.
  • Excellent interpersonal, verbal and written communication skills with the ability to collaborate and interact confidently with multifunctional teams that include programmers, project management, Systems Analysts, Business Process Engineers, and staff at all levels.
  • Experience in Supporting and monitoring the offshore teams with Onsite/Offshore model located globally

TECHNICAL SKILLS

Languages / Frameworks: JAVA, C#, Junit, TestNG

Automation Testing Tools: Selenium WebDriver / RC, Cucumber

Bug Tracking Tools: JIRA, ATTASK, Bugzilla

Testing Management Tools: HP QualityCenter / TestDirector, HP ALM

RDBMS: Oracle 11 / 10g / 9i / 8i, MS Access, MySQL

Scripting Languages: VB Script, JAVA Script, HTML5, CSS, XML

ETL Tools: Informatica Power Center 8.6.1 / 8 / 7.1 / 6.x, Power Connect, Power Analyzer, and Power, Confidential tools

BI Tools: Cognos 8 / 10, Business Objects

Operating Systems: Windows7 / 8, Windows Server 2008 / 2008R2 / 2012, MAC OS, Linux / Soloris

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, NJ

Sr. QA Analyst

Responsibilities:

  • Participated Sprint Planning for understanding the sprint goals, stories estimating the Story Points, Sizing and owning Stories and prioritizing stories.
  • Reviewing of the developed test cases with the BA and Dev teams over the stories.
  • Preparing any QA stories/tasks for any specific testing related tasks during the sprints.
  • Involved in the sprint Retrospective meeting at end of each sprint and discuss future Actions.
  • Test Plan, Test Scripts Preparation and getting the sign-off from test manager.
  • Expertise in testing Incident, Problem, Change, Release management,ServiceCatalog and CMDB in Service Now.
  • Validating Service Now Web services with SOAP UI pro.
  • Prepare the status report and Participate in the Weekly project status meetings.
  • Tracking the deferred requirements and testing it in the sub-sequent releases.
  • Mentoring the team members on the project tasks.
  • Developed Web Driver Scripts using TestNG, JUnit controllers using Maven/POM.xml for the Project building tool with Jenkins for the Continuous Integration.
  • Exposure to TDD, ATTD and BDD driven development practices.
  • Automated the Acceptance cases with Selenium Web Driver, Cucumber / Gherkin Syntax and JUnit.
  • Transformed the acceptance scenarios into Feature files and enhancing them into Step definition classes using Cucumber/Gherkin Syntax and Junit controller.
  • Updating the project status in metrics and sharing with the Test manager.

Environment: Service Now, Java Script, VB Script, Selenium Web Driver, SQL, Oracle, SOAP UI, Cucumber, Unix, HTML5, CSS3, XML, Eclipse, Unix, Jenkins, HP ALM, SharePoint

Confidential, Parsippany, NJ

Sr. QA Analyst

Responsibilities:

  • Developed and executed the Test Plans, Test scripts, Test Cases and test results reports.
  • Followed Agile testing methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables.
  • Regression test cases were written and automated using Selenium Web - Driver.
  • Developed automation scripts for new enhancements using Selenium Web Driver and Test-NG.
  • Involved in Functionality, User Interface, and Regression testing during the various phases of development using Selenium/Test-NG.
  • Used Java language and Test-NG framework for scripting.
  • Extensively used Selenium locators like (X-path, CSS Selectors, Fire Bug, Fire path locator) and Web-Driver to test the web application.
  • Write and update SQL queries to perform data validation from Oracle for ETL process for
  • Worked on Mainframe systems like EVS1 and DBL for Data creation and.
  • Interacting with developers, business analysts, UAT and Integration team for discussing requirement changes and defect status and resolution.
  • Designed and executed the Automation Test Scripts using Java in Selenium WebDriver for Hybrid framework (keyword and Data driven) and Page Object design pattern in Selenium using TestNG.
  • Performed functional testing of SOAP and RESTFUL Web Services using SOAP UI Tool.
  • Tested request and response XML's based web services interfaces using SOAP UI.
  • Reported software defects in Quality Center and interacted with the developers to resolve technical issues.
  • Developing Behavioral Driven Development (BDD) scripts withCucumber(gherkin)and writing step definitions for behavior using Gherkin and solid understanding of Acceptance Test Driven Development (ATDD).
  • Analyzed test results, tracked the defects and generated reports using Quality Center.
  • Prepared the data to cover various scenarios and wrote SQL scripts to verify the database updates, inserts and deletion of the records.
  • Followed Agile testing methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables.
  • Tested applications in different types of browsers and versions, such as Internet Explorer, Firefox, Google Chrome to simulate production environment.
  • ParticipatedQAweekly meetings and various other meetings and discussed Enhancement and Modification RequestIssues and defects in the application.
  • Validated Data Sharing rules in Salesforce workflow, approval processes, and validation rules for Weeks and point members.

Environment: Java, JIRA, Java Script, Selenium Web Driver, SQL, Oracle, Salesforce, SOAP UI, Cucumber, Unix, HTML5, CSS3, XML, Eclipse, Unix, Jenkins, HP ALM, SVN

Confidential, Bridgewater, NJ

Sr. QA Tester

Responsibilities:

  • Tests application for Functionality Testing, Integration testing, System Testing, Smoke Testing, User Acceptance Testing, Regression Testing.
  • Followed Agile/ Scrum Methodologies for all the project activities.
  • Actively participating and understanding application of Agile practices - Test Driven Development (TDD), Iterative development and Continuous integration.
  • Analyzed Business requirements of the product, worked with Developers, Product Owner, and other internalcustomers and team members to analyze Acceptance criteria and Prototypes.
  • Participated in sprint meeting and Actively participated in Daily Scrum meeting and updated the status of assigned task to the team members.
  • Uploaded Test plans and Test cases with different versions in QC ALM.
  • Analyzed the functional specifications and helped team members to achieve test goal.
  • Creating and updating Java test scripts using Selenium IDE and Selenium Web-driver and Xpath.
  • Worked on testing APIs, reading and writing into the database & checking server logs.
  • Validated reports by executing SQL queries.
  • Created Test Data for QA and UAT.
  • Created and Validated the data as per the Mapping Documents.
  • Prepared daily/ weekly status reports on Test case execution, defects, RTMs.
  • Involved in planning test execution activities, defect reporting and analyzing test metrics using JIRA.
  • Perform extensive System Integration and Regression testing to make sure existing functionalities are intact.
  • Preform backend testing using SQL Developer against oracle database.
  • Create, Track and Report defects using QC.
  • Participate in bug review meetings to triage bugs based on their severity and priority.
  • Provide Test Summary Reports to the management.
  • Working in Agile Development & Continuously Delivery Environment with frequently changing requirements and features.
  • Responsible to prepare the Daily Status Report and Weekly Status Report.
  • Tracked the project progress and effectiveness of test efforts across all teams and projects and report them to management.
  • Developed Metrics for capacity and performance testing for each release and updated to management.
  • Developed solutions to carry out the capacity and performance test against the metrics.

Environment: Quality Center 11.0/10.0, Java, Java Script, Selenium Web Driver, Linux, Oracle, Hadoop, SQL Server, JIRA, QC ALM

Confidential, Bridgewater, NJ

Sr. QA Analyst

Responsibilities:

  • ETL Data Validation, Metric Verification and Report Testing.
  • Validated ETL processes and made sure that the data from source to target tables are loaded correctly. Created and executed complex SQL queries to validate the flow of data. Tracked and reported the bugs with HP Quality center.
  • Executed the SQL's against the source database and tested against the Target database and compared the Results in the Cognos reports and Excel Sheets and Metadata validation.
  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Involved in ETL process testing using Informatica ETL tool.
  • Test Case Execution and Adhoc testing.
  • Writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
  • Performed data validation testing writing SQL queries in Toad.
  • Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
  • Validated the front end Cognos Reporting components created using Web Intelligence Reports as well as Back End testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse for Dash Boards with multidimensional cubes, Active Reports, Drill through and drill down and score cards.
  • Involved in coordinating the development, QA and production deployment activities. Hands on experience in metadata generation, testing and production deployment using cornerstone utilities and MYSQL and hive.
  • Validated data for Data mart tables from transactional level for end to end testing for ETL process.
  • Proficient in using Hadoopcommands to see the list of files, to take counts of the HDFS files.
  • Responsible to validate the data transferred through Sqoop between Oracle DB and HDFS.
  • Performed Regression testing after every enhancement, build installation and releases.
  • Responsible for Functional testing, User interface testing and User Acceptance Testing.
  • Worked closely with the Business analyst, System Analysts, Developers and DBA to solve the issues identified during the testing process in a timely manner and post Production.
  • Executed tasks proficiently meeting tight deadlines.
  • Experience in managing the offshore and onshore team members.
  • Designed and developed front end and Back end test scenarios and Test cases.
  • As a QA Lead, participated in walkthroughs for the evaluation of the test plan with the design and development.

Environment: Business Objects - Cognos 10.0.2/8, informatic Power Center 9.5/8.1, SQL, PL/SQL, SQL Server, Linux (sun Solaris), Oracle 11/10g, TOAD, HP Quality Center 10, Java, QC bug tracking tools, JIRA, CRM, Hadoop, HIVE SQL

Confidential, Bridgewater, NJ

QA Analyst

Responsibilities:

  • Created and executed test cases and automated test scripts for Regression testing.
  • Validated aggregate views for SLA level agreement counts.
  • Extensively executed SQL queries in order to view successful transaction of data and for validating data.
  • Executed Test Cases and reported defects using Bugzilla and tracked bug through resolution.
  • Responsible for weekly status updates showing the progress of the testing effort and open issue to be resolved.
  • Experience with Oracle Financial applications for Confidential Internal Billing system

Environment: Oracle, Windows, Java, Bugzilla, SQL

We'd love your feedback!