Sr. Qa Analyst Resume
Greensboro, NC
SUMMARY
- Accomplished, highly motivated technology professional with 7+ years of hands - on IT and quality assurance experience.
- Hand-on experience and in depth understanding of complete Software Development Life Cycle (SDLC) in client-server, intranet and working knowledge on mobile application development using OOAD, Agile (XP, SCRUM) and RUP methodology.
- Developed Test Plans, Test Scenarios, and Test Cases, Test Scripts, Test Reports and Test Metrics for Manual as well as Automated testing for various applications to ensure proper business compliance.
- Extensive experience in client/server and web application testing using System Testing, Functionality Testing (White & Black Box), Integration Testing, Regression Testing, Smoke Testing, GUI Testing, Database Testing and User Acceptance Testing (UAT).
- Strong experience in using Test management tools like Test Director, JIRA, Load Runner, Win Runner and Defect tracking tools like Issue Tracker and IBM Rational Clear Quest.
- Hands on experience in Developing, Documenting and Executing Test cases manually and generated Automation Scripts using Quick Test Professional, Quality Center and Selenium IDE, Selenium Web Driver, Test NG to ensure proper business compliance and worked closely with users and business analysts, Project Managers, Developers to understand requirements, business processes for testing and attended regular walkthroughs.
- Wrote Test cases in ALM and Defect report generation using ALM (Application Life Cycle Management)
- Extensive knowledge of the HIPAA implementation guidelines, ICD-9 and ICD-10 code sets.
- Experienced in maintaining the Requirements Traceability Matrix (RTM) and verifying forward and backward traceability between requirements and test cases.
- Excellent knowledge in ETL validation, Data Model Validations.
- Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
- Extensive work experience with different Databases like Oracle, SQL Server, MySQL, DB2, IMS, TOAD, PL/SQL and VSAM.
- Expertise in creation of UAT Plan and UAT Cases covering different business, functional and non-functional test scenarios and creation of expected test results.
- Have experience in Java based web services testing using SOAP UI tool, HTML, CSS, XML, VB and JavaScript.
- Experience testing mobile application on Windows OS, Android and IOS mobile operating system.
- Dynamic in working with all teams involving Developers, Business Analysts, Product team and Client Support teams for deliveries on time and budget with highest quality.
- Experience working with MS office tools like Visio, MS Project, Word, PowerPoint, and Excel.
TECHNICAL SKILLS
Test Automation Tools: HP/Mercury Quick Test Professional, UFT 11.5, Selenium, Load Runner, Win Runner, Advanced REST client for API testing, Cucumber
Test/Defect Management Tools: HP Test Director, SOAP UI, Test Director, Clear Quest, Microsoft Test Manager, Rational Quality Manager, Rational Functional Tester, Issue Tracker, HP ALM, Test NG, Eclipse, UAT, Rally
Platforms/Technologies: Different versions of MS Windows, UNIX, LINUX, VBScript, .NET, C#, Java, JSP, J2EE, JavaScript, JQuery, J Meter, J Unit
RDBMS: Microsoft SQL Server, MY SQL, PL/SQL, TOAD, ETL, Informatica, COGNOS
Software Methodologies: Waterfall, V-model, Agile(XP, SCRUM), Prototype
Browsers: Netscape Navigator, Internet Explorer, Mozilla Firefox, Safari, Chrome
Others: Macromedia Dreamweaver, I-frames and Microsoft Office (Outlook, Project, Excel, Word, & PowerPoint), Team Foundation Server (TFS)
Web Technologies: CSS,HTML, XML, iPad, iPhone, Android
PROFESSIONAL EXPERIENCE
Confidential, Greensboro, NC
Sr. QA Analyst
Responsibilities:
- Interacted with SME (Subject Matter Expertise) for better understanding of the application functionality.
- Analyzed business requirements documents and system requirement specification to put together a Test plan.
- Performed Smoke testing on the Build and manual testing for the GUI and Functionality of the application.
- Additionally, worked closely with the developers and business analysts to formulate the test cases.
- Tested web application interface, functionality, usability and performance, using SQL.
- Designed and Documented Test procedures and Test cases for User Acceptance Testing, Functional and Integration testing using Quality center.
- Developing new functionality for requirement including both back-end and front-end parts(.NET, AJAX, Web services, SOAP, XML, Oracle)
- Designed the Test Plans and Test Scenarios accordingly, which involved reviewing Business flow diagrams, and Dataflow diagrams that were created using Use Cases.
- Involved in end to end testing to test the complete application environment such as interacting the sanctions in payment and accounting systems.
- Perform HIPAA Validation of Clearing House application.
- Validate different Electronic Data Interchange (EDI) formats such as X-12, EMCDS, PCDS and 1500 formats.
- Validate different EDI formats and transactions under HIPAA compliance.
- Maintained bug lists for critical issues using Quality Center 10.0,JIRAfor bug tracking
- Assigned severity levels to different test cases and prioritizing them. Thereafter, performed testing in that manner.
- Mapped Requirements to test cases, providing Requirement Traceability Matrix to ensure project implementation within given timeline using Quality Center.
- Wrote SQL queries to check whether correct information was retrieved from the database.
- Did User Acceptance Testing on system before installation of the application to user environment.
Environment: Agile/SCRUM, SQL server 2012, MY SQL, PL/SQL, Oracle 11g, JIRA, .NET, JavaScript, JQuery, J Meter, SOAP UI, Quality Center, UAT, MS Office, MS Visio, MS Project, TOAD, QTP
Confidential, Bridgeton, NJ
Sr. Quality Analyst
Responsibilities:
- Responsible for analyzing business, functional and IT requirement documents and prepare complete Test Plans including system test plan, integration test plan, QA project plans and resource planning and allocation.
- Prepared Test Plan, test Cases, Test scripts and Test Metrics for the application as well as for the database verification based on the functional requirements, portal redesigned and test specs.
- Used automated scripts and performed functionality testing during the various phases of the application development using Selenium Web Driver.
- Used Selenium Web Driver for writing test scripts for regression test coverage.
- Performed white box testing using J Unit for class, method, & web services testing.
- Created Selenium J Unit test case for various functional modules, modified, debugged and executed using J Unit plug in to Eclipse IDE.
- Developed Test Framework in Selenium for UI Regression Test Automation and when necessary, and potentially execute Unit Test automation (Java/J Unit).
- Wrote Ant build scripts to automate the compilation and execution of J Unit test cases/suites for Lens Measurement screen, Lens Type Screen, Aftercare screen and two eye replication screens.
- Used ANT to build and run the Selenium automation framework. Once the script got over, framework used to send the automation reports over email.
- Involved in creation of automation framework in Selenium Web Driver using behavior driven approach like Cucumber.
- Extensively used Page Objects design and page navigation framework for readable test script and easy maintenance from developer perspectives.
- Used Firebug and Fire path to write automated test scripts using XPATH.
- Developed scenario based testing for the J meter scripts.
- Involved in SOAP & REST based web services testing using SOAP UI PRO web services testing tool.
- Developed script and performed Web Services testing using SOAP UI PRO tool for functional and regression testing.
- Tested request and response XML's based web services interfaces using SOAP UI.
- Conducted System Testing and User Acceptance Testing for every client and Conducted Backend testing writing extensive SQL queries.
- Developed automation test cases, executed these test scripts from test lab and logged defects in JIRA.
- Attended Defect Review meetings with Developers, Tech Lead, Team Lead and Project Manager to discuss issues regarding the Open defects, resolved defects and all other defects associated to the Source system.
- Involved in estimation and preparation of test case scenarios and test plan documentation for validating and reporting.
Environment: RUP, Selenium, SQL Server 2012, MY SQL, PL/SQL, Oracle 10g, Load Runner, Clear Quest, Rational Clear Quest, Selenium Web Driver, Cucumber, SOAP UI, XPATH, UAT, XML, J Meter, Java, J2EE, JavaScript, J Unit, Test NG, HP ALM, Jira, Eclipse IDE, MS Office, MS Visio, MS Project
Confidential, Orlando, Florida
Sr. Quality Analyst
Responsibilities:
- Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
- Developed Test Cases for ETL Data Validation and Report testing.
- Performed System testing, Regression testing, Systems Integration testing, and also User Acceptance testing.
- Developed validation steps and SQL using business requirements and rules.
- Updated test lead on change requests, test cases, SQL, execution and defect status.
- Analyzed the log file for an ETL job in Data stage Director and reported to developer.
- Interacted with DBA for setting up test environment in Oracle database.
- Executed SQL queries using Quest TOAD to validate ETL jobs.
- Written complex SQL queries and queried the Oracle database to test data stage ETL code.
- Worked on the pre-deployment validations and post-deployment validations and provided the production support also
- Performed database validation using SQL according to the business rules and specifications.
- Tested several complex reports generated by Cognos including Dashboard, Drill Down and Pivot.
- Created test data to test the functionality of the Data stage jobs.
- Used VI Editor to access and manipulate files in UNIX.
- Involved in testing the Cognos reports by writing complex SQL queries.
- Worked with Users to develop Test cases for user acceptance testing.
- Validated business reports like Drilldown and Cross Tab reports developed by Cognos.
- Maintained the test logs, test reports, test issues, defect tracking using Clear Quest.
- Involved in preparation of Defect Report using Clear Quest.
- Used Database links in SQL for Querying the Oracle database.
- Attended daily project status meetings and weekly QA status meetings.
Environment: Agile/SCRUM, ETL, SQL Server 2010, MY SQL, PL/SQL, Oracle, Cognos, Informatica, Java, J2EE, JavaScript, Test Director, QTP, Quality Center, QTP, UAT, MS Office, MS Visio, MS Project
Confidential, Austin, TX
QA Analyst
Responsibilities:
- Designed the efficient manual test cases (both positive and negative) based on the analysis of Business Requirement documents, SRS, Functional Specs, Technical Design documents and Use cases.
- Interacted with Specification requirements team and developers regularly.
- Responsible for performing the Regression tests for every new builds, interim builds, candidate builds and modifications in production, development and QA environments.
- Analyzed the business logic of trading and banking operations and designed test cases.
- Worked on different trading module stocks, Options and Mutual funds.
- Tested Confidential banking modules for brokerage and bank accounts.
- Analyzed end to end functionality by testing the application manually.
- Involved in user authentication testing for both Android and Apple devices.
- Tested Confidential application in iPad, iPhone, version 3 and 4.
- Tested different modules of application in Android.
- Used Quality Center 10 to design the scripts, perform baseline testing, execute the scripts and organize all the scripts systematically and generate reports.
- Updating scripts in Quality Center 10 and excel sheets.
- Interacted with business analyst to discuss better UI features that can be provided through the application to the clients.
Environment: Agile/SCRUM, SQL Server 2010, MY SQL, PL/SQL, Java, J2EE, JavaScript, Oracle, Quality Center, QTP, Test Director, UAT, MS Office, MS Visio, MS Project, IPhone, IPad, Android
Confidential, New York City, NY
Quality Analyst
Responsibilities:
- Involved in reviewing Business Requirements and Use Cases.
- Involved in writing Test Plans, Test cases and developing Test scripts using Test Director.
- Used Compuware’s Quality Assurance to prioritized Business requirements and form the basis for project test plans.
- Designed Module that extracts data on daily and weekly basis and loads the Oracle 10g database.
- Performed Compuware Application Performance Assurance that integrates performance profiling and transaction diagnostics with load and stress testing.
- Developed various Daily Data checks stored procedures using PL/SQL using business logic. Some of these checks were data driven.
- Worked on scheduling the Jobs i.e. VB Script by Scheduler for extract nightly loads from different clients server and putting on their websites.
- Encapsulated all data logic into Stored Procedures and eliminated all direct SQL calls and created triggers using SQL for SQL Server 2005/2008 database.
- Created SQL Queries against source table, target table and Distribution Tables.
- Performed the Quality Assurance of data quality & testing with data from Data ware.
- Tested Web Services calls used in the applications.
- Made X Path Queries on the XML Document from Web Services calls.
- Extracted data from different sources using SQL, PL/SQL and UNIX.
- Used XML, XSLT, X Path, and X Pointers to transform it before presenting to the Client.
- Involved in retrieving the data from XML and displayed it using Cascading Style Sheet (CSS) and XSL, XSLT, XSL.
- Performed end-to end testing on applications manually and automated with Win Runner.
- Rational Unified Process (RUP) was followed throughout the project and all artifacts are generated for each discipline.
- Automated the functionality using Win Runner.
- Communicated inconsistencies between system specifications and test results to development and/or analyst team.
- Performed regression testing of application for every new build released.
- Involved in generating virtual user in Load Runner for performance, and load testing of the application.
Environment: RUP, SQL Server 2008, MY SQL, PL/SQL, Java, J2EE, JavaScript, Clear Quest, Rational Clear Quest, HP ALM, XML, XSL, XSLT, XSL, CSS, Win Runner, Load Runner, MS Visio, MS Office, MS Project
Confidential, Boston, MA
QA Tester
Responsibilities:
- Analyzed Business, System Requirements and developed Test Scripts.
- Developed test cases for Functionality and Stress Testing of the entire product and analyzed the test results with the Customers. Used the features such as performance monitors, runtime checks checking for the Disaster Recovery Exercise.
- Verify the uploading of requirements and test cases to Quality Center and ensure that the appropriate modifications are enacted based on the requirements change requests
- Used Quality Center to track, analyze and document defects.
- Created performance testing requirements on Disaster Recovery by scaling down the transaction volume for the certification environment based on the production expected usage trends.
- Assisted Team Leader in Planning, coordinating and monitoring project levels of performance and activities to ensure project deadlines were met
- Performed Unit testing, Integration testing, System testing, Smoke testing, and Regression testing using QTP.
- Wrote and executed SQL statements to retrieve data from backend.
- Defect identification, defect analysis and defect tracking and monitoring the defect status right from open to close
- Effectively handled the defect management process and assigned severity and priorities to defects
- Assisted Users and Business Analysts in completing User Acceptance Test (UAT)
- Actively participated in preparing the Test Summary Report (TSR)
Environment: Agile/SCRUM, SQL Server 2008, MY SQL, PL/SQL, QTP, HP Quality Center, UAT, MS Office, MS Project, MS Visio
