We provide IT Staff Augmentation Services!

Sr. /lead Qa Analyst Resume

GA

SUMMARY:

  • 7 years of Software Quality Assurance (QA) experience performing Manual, Automated, Functional, Regression & UAT Testing on Web and Client - server applications using leading tools & software testing techniques.
  • Having experience in Performance, Automation using Load Runner.
  • Proficient in various Defect tracking tools like Quality Center, Bugzilla, Test Director, JIRA and RTC.
  • Solid Back End and Front End Testing experience by writing and executing SQL Queries
  • Experience in ETL Testing with Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Having experience in White box and Black box testing methods for performance increase.
  • Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
  • Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL Development Toad, WinSQL, PL/SQL Developer, SQL Navigator, Perl, UNIX and Korn Shell Scripting.
  • Experience in using Oracle Databases and SQL Server.
  • Expertize in running Batch jobs.
  • Hold solid knowledge about SOAP UI.
  • Experience in working with BI tool.
  • Expertize in Load Runner and Performance Analysis using Load Runner.
  • Proficient in writing advanced DML and DDL SQL Queries like to retrieve data from databases for Backend Testing using tools like TOAD to check and analyze data integrity and validation.
  • Having good experience in Software Automation using QTP.
  • Strong skills in Back-end testing using SQL queries, triggers and DTS tools.
  • Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Performing Functional Testing, Regression Testing, System Testing, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC). Involved in all phases of Testing Life Cycle.
  • Knowledge of various software testing methodologies like waterfall, iterative and agile (Scrum).
  • Good hands on experience working on functional and business work flow validation.
  • Experience in Writing Test Summary Report, Preparation of Bug Severity Chart.
  • Contributed in designing core testing documents like Master Test Plan, Test case design and System Test Report.
  • Proficiency in Testing Client-Server and Web Applications.
  • Accurate and concise documentation skills, used for creating detailed test plans, test reports and other documents required within the test process.
  • Good communication skills and interpersonal skill and consistently being organized by management and peer for producing high quality works.
  • Ability to communicate effectively with onsite/offshore teams.

TECHNICAL SKILLS:

Test Management Tools: HP Quality Center, Microsoft TFS, VS 2010, Microsoft Test Manager (MTM),Rational Quality Manager, Rational Test Center(RTC)

Automation Tools: HP QTP 10.0, Load Runner, Cucumber

Defect Tracking Tools: HPALM, Bugzilla, TFS, Bug Central, JIRA, VersionOne

Configuration Management: VSS, Rational Clear Quest, Rational Clear Case, AWS, Jenkins

Program Languages/Scripts: HTML, Java Script, VB Script, Java, C, C++, SQL, PLSQL, Json

Web Services: Soap UI 5.1.3, HTML,XML, Restful

Operating Systems: UNIX, Windows NT/95/98/2000/ 7,8,XP,Linux

Other Tools: FACETS 5.0,Toad,putty,Oracle SQL Developer & Management Studio, WinSCP, BI tool (Oracle BI Publisher Enterprise), Swagger

Database Skills: Relational SQL Server 2005/2008, SQL Server, Oracle 10g and Mango DB, Oracle SQL developer 4.1.0.19

Domain: Healthcare, Supply Chain, Benefits Management System, Payment Processing System.

PROFESSIONAL EXPERIENCE:

Confidential, GA

Sr. /Lead QA Analyst

Roles & Responsibilities:

  • Develop and maintain test cases.
  • Test the product in every sprint to ensure its quality.
  • Log, track, and test the defect to certify the products quality is not effected.
  • Test in various environments namely Dev, QA, Pre-Prod and Prod to provide the best working and quality product to customer’s end of the day.
  • Take up responsibility to build team and help team in all aspects.
  • Validate the data in databases and ensure the user’s data is stored as expected and returned data when needed.
  • Maintain documents and test cases on SharePoint.
  • Smoke test the product on every new build for the existing functionality being stable and untouched with new changes.
  • Write, maintain and run automation scripts.
  • Run the performance tests for the developed product which helps to give a fast running and better performance product to customer.
  • Maintaining and scripting using Gherkins language and then run using Java script in cucumber.
  • Running the automated script in Jenkins using Maven commands.
  • Testing the restful webservices in Swagger using JSon Scripting

Environment: .Net, Sage 50, Sage100, Unix, Version One, SharePoint, MS Office, Jenkins, Cucumber, Mongo DB, Selenium.

Confidential

Sr. /Lead QA Analyst

Roles & Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Performed batch testing to ensure the batch picks up data and populates correctly into tables and picks data from tables and generate file with that data.
  • Involved in assigning the tasks, tracking the tasks and providing required help to complete them on time.
  • Prepared test matrix, scenarios and test cases to ensure all scenarios are covered.
  • Involved in creating test plans to ensure we have all the s/w, h/w requirements ready and test coverage done resource planning is done before we start execution.
  • Has been primary SIT tester and Interface tester and POC for Interface defects.
  • Have been part of Integration testing on interfaces for multiple modules.
  • Interacting with client and help on UAT testing at client location.
  • UAT defect testing and interacting with trading partners for the connectivity and testing applications with connectivity.
  • Data Driven testing with trading partners
  • Has been doing Interface testing on with trading partners.
  • Defect logging, assignment and tracking through Microsoft Test Manager.
  • Creating and maintaining test data for automated testing using Microsoft Test Manager
  • Have been doing Soap UI testing to check for the request and response acting as a midlayer.
  • Testing the web services through Restful web services and calling with different methods of service and different parameters. Analyzing the data after that.
  • Have created many scenarios to ensure the response to the system is correct.
  • Performing BI reports validations for administration to fetch the reports on any given day and any type of case.
  • Been using the Bi publisher enterprise tool to perform bi testing.
  • Have also verified many manual scenarios in the benefits management system.
  • Worked SQL developer to verify the accuracy of data and check for business rules.

Environment: HP Quality center 11.0, HP QTP 9.2, UNIX Shell Scripts, Teradata V2R6, Agile, SQL Assistant 12.0, Microsoft Test Manager, Team Foundation Server SQL server, PL/SQL, Rational Robot, Rational Clear Quest, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Rational Clear Case, IBM Mainframes, Oracle 10g, SQL Plus, Agile, MS Access, MS Office, XML, XML Spy, SharePoint, Jira

Confidential, Detroit, MI

Sr. QA - Database Tester (ETL Testing)

Roles & Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements. Extensively written test scripts for back-end validations.
  • Involved throughout the business solution Software Development Life Cycle (SDLC).
  • Worked with Quality center to document test results and validate test scripts.
  • Have used SSIS to upload flat files and transferring data from Oracle to SQL Server.
  • Used SSIS for creating queries for data movement, uploading to database and tables, creating small ETL packages.
  • Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
  • Experience of using testing tools like Quality Center, Microsoft Test Manager(MTM), Visual Studio 2008/2010, Team Foundation Server
  • Reviewed Technical Specs together with the team of two developers
  • Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
  • Performed White Box, Black Box, and Usability Testing
  • Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.
  • Creating test scripts using Quality Center and performing regression testing on new versions of the software.
  • Tracked and reported the bugs with Quality center.
  • Created Validation documents for Business, ensured that the mappings are correct and conducted data validation testing.
  • Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
  • Wrote SQL queries for Data Validation, Data Accuracy, Data Trending, Data Completion, Data Analysis and Data Profiling.
  • Logged issues found on Jira for everyone to access
  • Used Share Point to manage and define requirements and Data Quality Issues.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Using Pivot tables for reporting and creating pivot tables for understanding data in detail.
  • Involved in validating the aggregate table based on the rollup process documented in the data mapping.
  • Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.
  • Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
  • Prepared test plans/test schedules with inputs from Confidential manager and development team.

Environment: HP Quality center 11.0, SSIS, HP QTP 9.2, UNIX Shell Scripts, Teradata V2R6, Agile, SQL Assistant 12.0, SQL server, PL/SQL, Microsoft Test Manager, TFS 2013, IBM Mainframes, Oracle 10g, SQL Plus, Agile, MS Access, MS Office, XML, XML Spy, SharePoint, Jira

Confidential

QA - Performance Engineer

Roles & Responsibilities:

  • Participated in sprint planning and retrospective sessions.
  • As a PSR Test Engineer used new tool ‘Yammer Metrics’ through which I collect statistical reports by embedding into code.
  • Used ‘Load Runner’ to see Server Resource Utilization. Used ‘Visualvm’ to check JVM’s Health.
  • Added/Modified several test cases to test the new design using ABB test framework (Own Proprietary Framework of JDA).
  • Test the complicated max load used was ‘100 million data set’ includes with hundreds of tables relations and constraints.
  • Also wrote many functions and procedures as a PL/SQL developer to manage large data set which in turn helped the team a lot.
  • Monitored different graphs like transaction response time and analyzed server performance status, hits per second, throughput, windows resources and database server resources etc.
  • In depth knowledge of SDLC, Agile methodology and Quality Assurance methods.
  • Develop the Test Recommendations for each test pass and Test Results.
  • Load test execution and work with Product Management and Development determining the number of virtual users to be used during the performance test.
  • Defect logging and tracking through Microsoft Test Manager.
  • Experience working in Windows and UNIX Environment.
  • Involved in the testing of claims module and Network module of Facets.
  • Configured and Used QTP with Quality Centre and Maintained the Confidential information in Quality Center.
  • Called WinRunner scripts into Quick Test Pro.
  • Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
  • Tested the entire data reconciliation process for multiple source and target system.
  • Provided input into Confidential plans for database projects providing timelines and resources required.
  • Wrote Pl/SQL scripts for the usage in Performance testing.
  • Wrote SQL queries for Data Validation, Data Accuracy, Data Trending, Data Completion, Data Analysis and Data Profiling.
  • Implemented Agile Development Methodology for quick solutions.
  • Develop Test Plans from functional specifications as per the end user perspective and timely monitoring execution and assisting the team when they required.
  • Escalate the issues about Confidential requirements (software and hardware) to Confidential Managers.
  • Planning and scheduling release Dates along with the Team Lead.
  • Coordinated and assisted offshore team on day to day testing activities.

Environment: HP Quality Center 10.0, HP QTP 9.2, UNIX, MTM, Shell Scripts, TOAD, Oracle 10g, SQL server, PL/SQL, Team Track, Silk Central, Load Runner, Agile, Yammer Metrics, Visualvm, SQL, SSIS.

Confidential

QA - Database Tester

Roles & Responsibilities:

  • Develop Test Plans from functional specifications as per the end user perspective and timely monitoring execution and assisting the team when they required.
  • Load Runner testing for the performance.
  • Provided input into Confidential plans for database projects providing timelines and resources required.
  • Utilized Quality Center for directing, tracking and outlining needs during a Confidential SDLC.
  • Wrote Pl/Sql scripts for the usage in Performance testing.
  • Wrote SQL queries for Data Validation, Data Accuracy, Data Trending, Data Completion, Data Analysis and Data Profiling.
  • Documented the business requirements for the developers.
  • Maintained and kept track of stakeholders requests for enhancements and changes using Rational Clear Quest
  • Manually verified the validity of the failed test cases. Performed Positive, Negative and Black box testing on the application
  • Create technical design documentation for the data models, data flow control process, metadata management. Wrote Test Cases in Quality center that would test various Test scenarios.
  • Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
  • Optimized QTP scripts for Regression testing of the application with various data sources and data types.
  • Executed regression tests at each new build in QTP.
  • Defect Reporting & Defect Tracking using Quality Center.
  • Created and added tables to SQL database when needed and extensively used SQL queries for data validation.
  • Developed database tables using SQL. Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
  • Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.
  • Prepared test plans/test schedules with inputs from Confidential manager and development team
  • Monitored different graphs like transaction response time and analyzed server performance status, hits per second, throughput, windows resources and database server resources etc.
  • Performing Functionality tests, System Tests, Regression Tests, and Compatibility Tests on different versions of Web WORKS Foundation.
  • Configuring the Servers (Windows and UNIX servers) with the latest builds and make it ready for the use of team as required worldwide.
  • Participated in Agile iteration meetings and QA activities for all releases of the Confidential .
  • Manage onsite and offshore resources.

Environment: HP Quality center 10.0, HP QTP 9.2, SQL server, PL/SQL, Oracle 10g, Java, J2ee, UNIX, Shell Scripts, TOAD, Team Track, and Silk Central, Load Runner, Agile, MS Office, Agile.

Confidential

QA Tester

Roles & Responsibilities:

  • Involved in User story walkthrough
  • Client interaction for queries clarification
  • Designed and developed test cases for Smoke, Functional, Integration, Negative, Regression test suites.
  • Reviewing the test cases and executing the same.
  • Writing QTP Scripts and running the tests.
  • Tracking the results of the tests. Analyze and if possible fix the defects raised on the XML files as well as the database level.
  • Defect tracking and logging the defect with complete details.
  • Created/Maintain CR document which contains test status with the path to the CR details and understand the CR and help the team to understand the same.
  • Created requirement matrix
  • Participated in discussions for prioritizing work, developing time estimates and work plans and assisting team members. Conduct client demo along with creating documents for the same
  • Helping other Confidential teams with inputs on domain knowledge
  • Created a system flow document pertaining to different modules within the Confidential that has greatly helped the team as whole and also received client appreciation for the same.
  • Training for new comers on application, writing of appropriate test cases and execution of the same.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Created and executed SQL statements to retrieve data for testing analysis and test case validations.
  • Wrote complex SQL queries to validate Target and source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
  • Performed backend testing using SQL queries, generated the reports to ensure the data integrity and validated the business rules.
  • Worked closely with Developers and Functional Architects by following the Agile (Scrum) Methodology.

Environment: HP Quality Center 9.2, HP QTP 8.2, TOAD, Team Track, NET/Java, Rational Test Manager, SQL Developer, Windows NT/2000, MS SQL, PL/SQL, UNIX, Manual Testing, XML, Agile, Scrum, IBM DB2, Test Director9.0/8.0, Win SQL, Test link, Bugzilla, Oracle.

Hire Now