Qa Analyst Resume
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