We provide IT Staff Augmentation Services!

Quality Analyst Resume

TX

SUMMARY

  • 5+ years of Experience as a Software Quality Assurance and analysis Engineer, testing data in data warehousing application and also in reports in Client/Server and Web Based environment.
  • Experienced in the design of Automated and manual testing of various applications for Web and Client/Server, Web services in Mobile Application domains.
  • Well experienced in developing Test Cases, Test Plans, Test Execution, Defect Tracking, and Report Generation using Quality Center test management tool Quality Center/HP ALM based on functional specifications.
  • Well versed with end - to-end testing, Database Testing, GUI based testing, UAT, White Box, Black Box, Smoke, Integration, Functional, End-to-End, Back-end and Performance testing in several applications such as the, EDI based applications, Mobile Applications and data warehousing applications, web services.
  • Experienced in Data Validation and Backend testing of databases to check the integrity of data. Used extensively SQL Queries to retrieve data from database.
  • Excellent Quality analysis and assessment in all phases of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) with good working knowledge of QA methodologies like AGILE, waterfall and Scrum upholding the Scrum Calls, Sprint Planning, Sprint Review, Retrospective meetings.
  • End-to-end defect management of assigned projects. Identify defects, assess root cause, and prepare detailed information for developers and business stakeholders.
  • Used Quality Center for Test Management, Defect Management and manage the automation scripts created using QTP
  • Good understanding of Object Oriented Programming languages such as JAVA, and .net framework.
  • Experience in testing of Data Warehouse/ETL Applications developed in Informatica, data stage, Ab initio using SQL Server, Oracle, DB2, and UNIX. Ability to evaluate ETL/BI specifications and processes.
  • Work closely with the Documentation team to insure the content is meaningful and correct
  • Experience in RDBMS, Microsoft SQL Server, Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge.
  • Strong expertise in functional testing of web applications using automation scripts with Selenium Web driver and Test NG and Protractor.
  • Extensive experience in object identification using various identification techniques like Locators, Xpaths and CSS elements etc
  • Written test cases to test application manually in Quality Center and performed automated testing by crafting automation framework using QTP, selenium Web driver/RC, SOAPUI and JIRA.
  • Experience in carrying out the regression testing after new build either by running the sql queries in the back- end database or by designing automation framework using QTP and selenium web driver.
  • Responsible for developing the Analysis and Defect Tracking protocol using HP Quality Center/ALM, Test Director, JIRA, IBM Clear Quest. Bugzilla,
  • Knowledge in Business Intelligence tools like SAP BODS, Microstrategy 9.0, Business Objects, Cognos and OBIEE
  • Sound knowledge and exposure in working with the various relational databases like Oracle, SQL Server etc.
  • I have 3 years of experience as a QA lead and 4+ of experience as a QA analyst.
  • 3+ years of experience in healthcare.
  • As a lead Conducted review meetings for S2T, BRD’S to tract anything that was not comprehended by the QA team on a high level pertaining to business or testing evaluation.
  • Accomplished huge and high budget, complex projects within the desired timelines.
  • Communicated and co-ordinated with the vendors and end clients to make sure the end client is receiving quality and desired data according to the requiremets.
  • Took the responsibility in developing the test plan, test suite and test scenarios either individually or sometimes with the co-ordination of QA team.
  • Experience in Handling On-site and Offshore team and running the meetings and tracking the status reports and reporting to the client and took over the responsibilities of the project and raised escalations whenever necessary.
  • Manage the resources effectively and maintained appropriate project sizing.
  • As a Quality analyst Implemented Optimization techniques for better performance on the ETL side and also on the database side
  • Experience with different databases like Oracle, Mainframes, Teradata, and MS SQL Server to extract and load data.
  • Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
  • Expertise in Defect Reporting and Tracking using Test Director/ HP Quality Center.
  • Extensive experience in testing applications on UNIX environment using shell scripting alone and also SAS for shell scripting.
  • Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

Quality Assurance Tools /Test Management: HP ALM 11/HP Quality Center 10, QTP, Test Director 7.5, QTP, IBM Clear Quest, Selenium,JIRA,Fitnesse

Environment: Windows 98/2000/NT/XP, IBM Mainframes, Unix, Linux, SAS for Unix

Languages: SQL, PL/SQL, UNIX Shell Scripting,JAVA,.NET

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008 , Teradata, Sybase, DB2

GUI/RDBMS Query Tools: SQL* Plus, Oracle SQL Developer, SQL Server Management studio, Teradata SQL Assistant 13.0, TOAD, WinSQL

ETL Tools: Informatica PowerCenter 8.x/9, Ab Initio, SSIS and Datastage

BI Tools: SAP BODS, Business Objects, Cognos, Microstrategy, SSRS and Hyperion

Job Scheduling tools: Autosys, ASG Zena.

SDLC/ STLC: Agile, SCRUM, Waterfall, Rapid SQL, V model.

PROFESSIONAL EXPERIENCE

Confidential, TX

Quality Analyst

Responsibilities:

  • Participated in daily scrums and requirement grooming sessions with business and technical analysis discussions in agile environment and updated the status to the business on a daily basis.
  • Created and maintained documentation needed by test team such as test plan, test summary, test cases and had the test cases uploaded in the ALM and created Requirement Traceability Matrix.
  • Reviewed Test cases and scenarios by Business Analyst for coverage and completeness.
  • Maintained regression test suite and reviewed the test results on a regular basis.
  • Created and maintained documentation needed by test team such as test plan, test summary, test cases and had the test cases uploaded in the ALM and created Requirement Traceability Matrix.
  • Tested the data flowing from a web applications to data warehouse and reports.
  • Prepared the Test data for the ETL process and compared the results to match the functionality.
  • Used SQLServer for performing Backend Testing. Worked with the development team to create staging tables, loaded them with data and used it for data validation against the target data
  • Extensively tested the data movement from GUI to backend and backend to GUI with multiple scenarios by creating SQL Scripts to analyze data from Database and performed routine analysis of data to ensure integrity and quality of data.
  • Experienced in extensively writing SQL scripts in order to test if the quality of the data is maintained according to the requirements.
  • Performed Data Analysis and data profiling using SQLServer and ETL Informatica.
  • Validated Business Objects Reports and Universes against Data warehouse/Data mart Database by writing SQL Queries.
  • Performed automation testing and authored test scripts using Selenium Web Driver, Selenium Grid and TestNG and Protractor for Angular JS application.
  • Implemented object identification using locator technique.
  • Involved in formulating Hybrid Frame work using Page Object Model, Keyword, and Data driven for automating the application.
  • Created reusable methods, used in various scripts and Involved in recognition of reusable methods and test data utilized in scripts and contributed to the maintenance of efficient code.
  • Used Id, Name, Links, XPath and CSS to work with dynamic and static elements in application.
  • Executed functional testing to identify various critical points in the application and automated it by using Selenium web driver. Developed data driven test scripts to check the functionality with multiple sets of data. .
  • Performed regression testing in all Browsers like Firefox, Chrome, Safari, IE8 and IE11 by executing Selenium test scripts
  • Developed new and updated existing Automation test cases using selenium Web Driver.
  • Used Maven as Build tool and Jenkins to create and run deployment jobs.
  • Integrated TestNG with Selenium using Eclipse to generate test execution result.
  • Performed Web Service Testing using SOAP UI.
  • Tested request and response XML’s based web services interface using SOAPUI.
  • Created test results document at the completion of entire testing process and sent detailed test execution and bug status report using HP ALM and participating in defect meetings.
  • Performed defect verification and regression testing for new builds and ensured that product quality is not compromised
  • Performed acceptance testing by integrating selenium remote control with that of Fitnesse to run the test suite created.

Environment: SQL Server 2012, UNIX, ETL Informatica, Selenium Web Driver, Protractor, Eclipse IDE, Serena Dimensions, BI Business Objects XIR4, Quality Center/ALM (HP Application Lifecycle Management 11.0), Jira,, JAVA, MS Office, Teradata 12, XML, HTML, Web services, SOAP UI.

Confidential, TX

ETL QA /Automation Tester

Responsibilities:

  • Involved in end to end testing of the application by analyzing the business requirement document and testing the business logic using the source data
  • Worked as a system and functional tester and validated the performance of the code in the test and higher environments and good knowledge about different testing types and techniques.
  • Also performed the acceptance testing by executing the test cases in Selenium using Fitnesse on different browsers.
  • Designed the test strategy and test plan and documented the test cases with extensive SQL scripts and got the test cases imported to HP ALM, and executed the test cases and documented the results.
  • Good experience in writing SQL in order to data validation in migration as part of backend testing.
  • Responsible for validation of Target data in Data masking strategy for the shared test environment
  • Debugging the SQL-Statements and stored procedures for various business scenarios
  • Performed the loading and validation of the source files using shell scripts on the Unix environment.
  • Created the project metrics and actively involved in documenting the defects in the code or logic and reported to the management
  • Performed Regression testing after each build and tracked the results.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Executed the autosys scripts, checked the existence of box jobs and command jobs and validated the job schedule and runs and the email notification after each run.
  • Participated in Interacting with the vendors and end client for verification and validation of the data in accordance to the business requirements.
  • Hands on experience in preparing the automated test data and test sets and executing the same.
  • Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
  • Performed Data Analysis and data profiling using SQL and ETL Informatica Data Explorer on various sources systems including Oracle and Teradata, netezza.
  • Co-ordinate with development and QA team for handling of defects with respect to data
  • Performed data quality analysis using advanced SQL skills.
  • Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, Jira, ALM and Quality Center .
  • Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries Microsoft SQL Server.
  • Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects
  • Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server and Oracle to load into the Oracle data warehouse
  • Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
  • Tested and validated the Tableau reports by running similar SQL queries against the source system(s).
  • Created the test suite and test script for automation using selenium in order to perform regression testing and created the reports.

Environment: ETL Informatica 9x, BI Business Objects, Selenium, XIR4,Tablea, Quality Center/ALM (HP Application Lifecycle Management 11.0), Jira,QTP, SQL Server 2012, UNIX, Oracle 11g, Datastage, SQL, PL/SQL,JAVA Oracle 10g, Agile, MS Office, Teradata 12, DB2, XML, HTML, Windows and Unix, Shell Scripting, Web services, SQL Server Data services 2012.

Confidential, MN

Sr. DWH tester

Responsibilities:

  • Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
  • Perform both manual and automation testing and created various test data to track the testing results.
  • Export requirement, test cases into the Quality Center/ALM, run manual and automation test cases from test lab and log defects from defects module.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
  • Tested Business Objects reports and Web Intelligence reports
  • Maintained an on-shore and off shore team and co-ordinated with both the teams by conducting KT sessions and resolved technical issues within the whole team
  • Responsible for a Client Interaction resolving the long holding issues and ensured easy Co-ordination between Client, development Team and QA team.
  • Mentored the on-shore and off shore team facilitated the training sessions and appraisals.
  • Following and collecting the daily status and reporting to the client and Contributed in client meetings comprising any design changes.
  • Validated the functional and integrated testing and UAT testing by co-ordinating QA and development team to ensure data quality and standards according to the requirements
  • Participated in the front-end testing using web services.
  • Testing functionality, integration, and stress testing on client and web based application.
  • Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
  • Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Performed extensive Data Integrity testing by executing SQL Statements on Oracle & SQL database
  • Developed UNIX shell scripts for the purpose of parsing and processing data files. Maintained and did trouble shooting for batch processes for overnight operations.
  • Involved in writing Test scripts for various test scenarios using QTP tool and in creation of Automation frame work. se Business Objects OLAP Intelligence to natively access and analyze OLAP servers
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance divisions and across geographies.
  • Tested ad hoc and canned reports for Business objects.
  • Performed data analysis and data profiling using SQL and ETL Informatica Data Explorer on various sources systems including Oracle and Teradata.
  • Wrote SQL queries to test Data Integrity and performed Database Testing for the Application
  • Validated data in between source and target after running Mappings by the Informatica developer team.
  • Used SAOP UI as an integration project to validate the request /response in data using assertions.
  • Good Experience on Selenium IDE and creating Scripts in selenium --RC by using Java
  • Used Selenium IDE for Open source web testing
  • Experience in working with open source tools Selenium (Selenium IDE, Selenium RC, Selenium Web Driver), JUnit, Eclipse and preparation of automation test framework.
  • Recorded and plays back test in Fire fox using Selenium IDE.
  • Created Automation test framework using Selenium
  • Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application.
  • Exported Test case Scripts (Java-Selenium RC) in Eclipse IDE and modified the selenium scripts and executed.
  • Run tests by using Selenium remote control in different browsers.

Environment: DWH ETL Informatica 8.5, BI Business Objects XIR3.1, ALM, QTP, Agile, PL/SQL, IBM, IBM DB2, Web Services/Web methods, XML, HTML Oracle 10g,, SQL, TOAD, Windows 2003/2007, UNIX, Soap UI

Hire Now