We provide IT Staff Augmentation Services!

Qa Analyst Resume

5.00/5 (Submit Your Rating)

Carmel, IN

SUMMARY

  • Around 6+ years of experience in Information Technology with emphasis on Software Analysis, Manual, Backed and automation Testing
  • Development and QA Testing in Client/Server and web based/ browser based applications/ Data Ware housing applications with Quick Test Professional (QTP/ Automation) and Load Runner (Performance Testing).
  • Involved in development of Test Processes, developed automation testing requirements, prepared test scripts, running tests, collecting test results.
  • Evaluate different frameworks in QTP and define the right one for testing based on testing needs.
  • Conducted System Testing/ Functional/ Integration and Regression testing using QTP.
  • Excellent in converting existing Manual Test Cases into Automation Scripts in QTP environment.
  • Worked on sharepoint testing and saved all test results in it.
  • Worked on Microsoft dynamic too.
  • Expertise in working with Checkpoints of QTP.
  • Have worked with Automation Framework (of QTP) like Keyword Driven and Modular Driver Framework.
  • Expert QTP engineer with VB script expertise. An eye for automation wherever possible to develop usable code.
  • Strong skills in backend testing using SQL queries, with analytical and problem solving skills.
  • Strong experience in ETL Application using SSIS with various source like flat files, excel, Oracle.
  • Working knowledge python scripting, C# and .Net too.
  • Excellent functional knowledge on various domains like - Finance, Banking, Telecom and Health Care.
  • Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) with emphasis on Testing and requirement gathering phases.
  • Experienced in Waterfall SDLC, V Model, Agile, RAD, CMM testing process; testing of applications in Iterative testing methodology in a rapid deployment model.
  • Developed technical and functional requirement documents using Test Director and Quality Center.
  • Worked on tools like HP Quality Center &, Clear Quest.
  • Expert in different types of testing that includes Regression, Functional, Integration, System, User Acceptance, Sanity, Smoke, Performance, Stress, Load, Back End/Database Testing, UAT testing..
  • Experience in testing various analysis reports generated in ETL/ DW Business Objects, (SSAS) and SSRS reports.
  • Excellent knowledge of web services testing using Service Oriented Architecture (SOA) tools SOAP UI.
  • Ability to apply technical expertise to organize and implement white-box and black-box test efforts and to analyze requirements for software design, development, and validation.
  • Experienced in creating Requirement Traceability Matrix to ensure comprehensive test coverage of requirements.
  • Proficient in writing SQL scripts, Stored Procedures and functions for database testing
  • Configuring and implementing Defect Tracking process to provide Test Metrics
  • Familiarity with Agile software development lifecycle (iterative and incremental), UML design documentation.
  • Experience in interacting with business analysts, developers, technical support & help them base line the requirement specifications.
  • Strong analytical, interpersonal, communication, coordination, problem solving and decision-making skills.
  • Effective in executing multiple tasks and assignments; dedicated team member with excellent work ethics and with capability to handle new technologies and situations

TECHNICAL SKILLS

Testing Tools: HP/Mercury Quality Center 11/10/9.2/9.0/8.2 , QTP 11.5/ 11/10/9.2/9.0/8.2 /8.0, SOAP UI, Bugzilla, SQL Developer

Defect Tracking Tools: HP/Mercury Quality Center/ALM, Bugnet, Microsoft Test Manager, JIRA

Application environments: C++, C#, .NET Framework, Web Services, SSIS/ SSRS/ SSAS, Crystal, SOA, Java, ASP.NET

Programming Languages: VB Script, shell scripting, windows batch

Databases Technologies: Oracle, SQL, MS Access, PL/SQL

Other Applications: MS Word, MS Excel, MS Access, Lotus Notes.

Operating System: UNIX, Windows 9x/NT/2000/2007/XP

PROFESSIONAL EXPERIENCE

Confidential, Carmel, IN

QA Analyst

Responsibilities:

  • Developed scripts in VB to test validity of data across databases.
  • Execute VB scripts using QTP to POC QTP’s ability to do backend testing directly.
  • Procure requirements from business analysts for the BASEL validations.
  • Build SQL queries to test the requirements manually first. Used TOAD.
  • Used Agile Software Development methodologies to enable efficient and effective high-quality software development.
  • Modify and tune SQL queries for faster performance. Used AWR reports to analyze SQL.
  • Extensively involved in back-end data warehouse and data mart testing using PL/SQL scripts to check the data consistency, ETL process, data integrity in the application and database as data was fetched from different databases.
  • Used share point to save test results.
  • Create VB functions for generic functionalities like comparing data from baseline to target line, getting two tables value same, expected value of tables same.
  • Created module in VB to automatically generate HTML reports in a specific directory.
  • Worked on testing scenarios involved with dependency injection in C# for various data patterns.
  • Compared database extracts using excel. Program module was written in VB.
  • Provide a daily update to senior management with key issues, highlights and accomplishments.
  • Preparation and Review of Gap analysis Document

Environment: QTP 11, Toad, Oracle 12c/11g, VB scripting, Power point, Excel, JIRA

Confidential, Bluffton, SC

QA Analyst/ Tester

Responsibilities:

  • Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
  • Worked on conversion of existing manual integration tests into automated tests using QTP for a few modules of the application.
  • Also developed automated test scripts using QTP to perform Functional and Regression testing for the modules for which I did system testing.
  • Extensively worked with Expert View and Keyword View in QTP.
  • Performed Data Driven testing with multiple test data inputs with QTP and MS-Excel.
  • Worked with different types of recording modes (in QTP), synchronization point.
  • Experience working with Object Identification and Object Spy (features of QTP).
  • Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
  • Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
  • Executed and managed test cases and reported bugs in Quality Center.
  • Used Agile testing methodology for achieving deadlines in UAT.
  • Formulate methods to perform Positive and Negative testing against requirements.
  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, user Acceptance Testing (UAT) and Data validation testing.
  • Prepared scripts, running tests, Analyzing results in Load Runner 9.1 for Performance testing.
  • Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
  • Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
  • Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
  • Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
  • Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
  • Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Environment: Windows 7, Vista, XP,UNIX, QC 10.0, QTP 10.0, SOAPUI, HTML, XML, Java, Oracle 11g, SQL Server 2012, TOAD, SQL, PL/SQL, Clear Case, Clear Quest, UML, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project

Confidential, Memphis, TN

QA Analyst

Responsibilities:

  • SQL Server Administrator for 360 View tracking software for freight. Primarily responsible for upgrade and migration to the new server.
  • Upgraded SQL server 2008 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
  • Created an implementation document for the step by step migration of data and schema to the new instance.
  • Set up Failover and SQL Mirroring on the new servers
  • Suggested /tested improvements: indexing/table structure, query code, hardware, database server configuration,
  • Worked on UAT Testing.
  • Worked on QTP and created VB function for automation.
  • Regression tested and implemented first in Dev and QA environment.
  • Provided 24 X 7 dedicated support for all Production, QA & Development MS SQL Server systems.

Environment: MS SQL Server, MS SQL Management Console, Windows 2008 server, Bugzilla.

Confidential

QA Analyst

Responsibilities:

  • Involved in creating Test plan and several test cases.
  • Analyzed the business requirements and wrote Test Cases and Test Strategy for functional requirements.
  • Responsible for Database testing using SQL queries in MS SQL Server.
  • Analyzed the system specifications and helped team members to achieve test goals.
  • Recorded scripts in Quick Test Pro to perform Functionality testing.
  • Experience in building automation scripts in Quick Test Professional to automate smoke, sanity and regression testing. Automate test data load for every build cycle.
  • Inserted various check points in QTP for testing the properties of objects.
  • Ensured that all the test cases were written and updated in Quality Center.
  • Reviewed test specifications, cases and performed manual testing.
  • Involved in writing SQL Queries for retrieving and transforming data from SQL server.

Environment: ASP.net, Windows 2000, QTP, SQL server.

Confidential

QA Analyst

Responsibilities:

  • Analyzed Business Requirements and System Specification documents and identify the test scenarios.
  • Prepare detailed test plan based on the specifications document.
  • Prepare Test Cases for testing the Business functionality, GUI, security, and usability.
  • Test Data set up for validating the system for different type of customers and rate plan.
  • Generating and verifying the bills of the customer
  • Execute test cases in Quality Center.
  • Perform End-to-End testing.
  • Perform Database validation using SQL.
  • Perform Integration, System and Regression testing.
  • Track and log defects in Quality Center and coordinated meetings with developers and business analysts to prioritize the bugs.
  • Perform Retest for defect fixes.
  • Coordination between Delivery, Design and development teams for resolution of defects
  • Participated in defect review & Go/No Go meetings.

Environment: Quality Center 9.0, UNIX, Toad, Oracle. Siebel

We'd love your feedback!