We provide IT Staff Augmentation Services!

Qa Analyst/backend Tester Resume

0/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • As a QA Analyst / Test Engineer with more than 7 years of experience in all phases of software lifecycle, developing Test Cases for Client/Server, Windows, UNIX/Linux, Web Services and Web based applications. Good experience in Financial, Supply Chain Management, Insurance, Healthcare and Telecom Billing sectors with Business and Functional knowledge.
  • Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
  • Over 7+ years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications,Selenium, Data Warehousing, BI and ETL Testing
  • Expertise in Manual and Automated Testing in different testing methodologies like Agile, Scrum, Waterfall etc.
  • Hands - on experience in web services testing using standards like XML, WSDL, SOAPUI, Java Message Service, Web Sphere MQ and TIBCO Enterprise Message service (EMS).
  • Tested performance of Web Services, providing required input data to request XML and get the required data from response XML and use the response data from other request XML.
  • Worked on Protocols like HTTP, HTTPS, TCP/IP, SMTP, FTP, SSH, SOAP and DNS and knowledge on web methods and web services.
  • Involved in developing and executing Test plan and Test Cases for Functional and Regression testing.
  • Good working experience using Test Director / Quality Center, Rally, Clear Quest, Jira, Bugzilla bug tracking tools.
  • Perform manual and selenium testing of a web based application.
  • Good scripting experience in VB for HP/Mercury Quick Test Professional.
  • Developed test cases for Regression, and Data Driven tests.
  • Experience in Black box Testing, White box testing, User acceptance testing, Functional, Integration, GUI, System, Regression, Security, and backout testing.
  • Good experience in handling custom objects, exception handling/Recovery Scenarios in QTP and also familiar with String functions, Date functions, Math functions and other related QTP functions.
  • Participated in requirement review meetings, analyzing requirements, developing test plan and test cases, Requirement Traceability Matrix, Defect management, Reporting and tracking.
  • Good knowledge in VB, C, C++, HTML,JUnit and Java scripting languages.
  • Proficiency in Structured Query Language (SQL), Joins, PL/SQL stored procedures & Triggers.
  • Experience in preparing Test data by retrieving data from Relational Databases Oracle, MS-SQL.
  • Have good working Experience in Selenium, UNIX, shell scripts, Python scripts and ftp using WinScp.
  • Converted manual test scripts to automated test scripts in Quick Test Professional
  • Enhanced the scripts by adding user-defined functions.
  • Automated test scenarios for GUI, Functionality, Integration, Database, Boundary, Security and Regression Testing using Quick Test Professional
  • Good Analytical, Interpersonal and communication skills. Result oriented, committed and hard working with a quest to learn new technologies and undertake challenging tasks.
  • Highly motivated, self-starter able to work independently and collaboratively within a diverse technical team.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/00/NT/XP, MS-DOS and UNIX (HP-UX, Sun Solaris).

Testing Tools: HP Quick Test Professional, HP LoadRunner, Test Director, WinRunner Quality Center, IBM (Rational) Test Manager, Clear Quest, Bugzilla.

Languages: C, C++, Java, Visual Basic (VB), .Net, TSL, SQL,Selenium, HTML, XML, Java Script, JSP, VB Script, Visual source safe

Databases: Oracle 9, 10, 11, MS SQL Server, Sybase, and MS Access

Tools: SQL * Plus, Toad, Microsoft Office Suite, WS FTP Pro, WinSCP

App/Webservers and other tools: HTML, XML, Web Logic Server, WebSphere,Tibco, SoapUI, Web Services, SAP Adobe Flex and Adobe AIR, Informatica, Teradata, (ETL, Data warehouse)

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

QA Analyst/Backend Tester

Responsibilities:

  • Developed Test Plans, Test Cases.
  • Used Quality Center to develop Test Cases and Execute Test Cases
  • Performed Data Driven testing using QTP. Performed Cross Browser testing using IE and Fire fox on Windows Environment.
  • Performed Functional testing, Integration testing, UAT and Regression testing.
  • Creating test scripts using Quality Center.
  • Worked on issues with migration from development to testing
  • Performed Functional Testing and Back-end Testing using the database comparable results Manually
  • Perform Testing in Java using JUnit Framework.
  • Implemented Database Checkpoints for Back-end Testing
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
  • Detailed repeatable end to end test cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing in order to validate the back end utilizing SQL Plus.
  • Involved in fixing invalid mappings, testing of sessions and the target data.
  • Extensively created SQL scripts during pre and post load of data.
  • Scheduled several workflows for its execution.
  • Checked the data flow through the front and backend and used SQL queries to validate the output data with the database.
  • Performed Pre Migration Assessment, Migration & Post Migration
  • Performed Functional Testing and Back-end Testing using the database comparable results Manually
  • Tested several reports and automated using Quick Test Pro.
  • Written JUnit unit tests in NetBeans IDE.
  • Involved with extraction routines to verify all the required data loaded into target systems.
  • Extensively executed SQL queries in order to view successful transactions of data and for validating data.
  • Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
  • Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports.
  • Created the test data for interpreting positive/negative results during functional testing.
  • Involved in the whole testing life cycle covering the entire project from initiation to completion
  • Clearly communicated and documented test results and defect resolution during all phases of testing.
  • Used SQL queries and custom programs to perform data validation.
  • Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
  • Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.
  • Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
  • Extensively involved with backend testing by writing complex SQL queries.
  • Worked closely with the development teams to replicate end user issues.

Environment: Oracle 10g/9i, SQL Server 2008 R2, SQL, PL/SQL, Stored Procedures, HTML, Java Script, Quick Test Pro 8.0, Quality Center 8.2, Points Portal, Autosys, HTML, JAVA, JSP, JavaScript, Rational Clear Quest, Clear Case, RUP, TOAD, Requisite Pro, Test Manager, Automation/Manual Testing, UNIX

Confidential, Columbus, OH

QA Tester

Responsibilities:

  • Participated in weekly Assessment Meetings with BAs, SMEs, and Developers and coordinated between Business Analysts, Development Team, and Testing Team.
  • Worked with different LOBs (lines of business) like commercial, retail, treasury, asset and wealth, corporate finance and treasury & securities for business test case scenarios and execution till final sign off.
  • Wrote SQL queries to access the transactional data from the Inter systems Cache database tables and crosscheck the results with Online Analytical Processing(OLAP) database.
  • Developed VB scripts in Quick Test Pro to perform end-to-end testing and created a set of re-usable scripts.
  • Performed API (Application Programming Interface) testing for Web services by using HTML/XML
  • Worked with project team throughout the Lifecycle to assist and support the analysis, design, development, and implementation of developed systems/applications.
  • Analyzed System Requirements, Business Requirements and generated Traceability Matrix, Test Plans and Test Scripts accordingly.
  • Performed path analysis, and developed and executed test cases, and test scenarios that included Acceptance, Functional and Regression test cases using HP Quality Center 9.2.
  • Interacted with off shore team to resolve defects and functional issues of the application.
  • Mainly Worked on ETL process and Data Warehousing (Financial Data Warehouse FDW for SAP Revenue data)
  • Identifying, analyzing, and documenting defects, questionable functions, errors, and inconsistencies in application functions, outputs, and content.
  • Track test results for management, categorizing issues and creating/distributing defect reports and managing defect database using HP Quality Center 9.2.
  • Worked as Admin for Quality Center to add the new project member, password reset, change the properties of existing members and remove the users.
  • Tested Web Services request and response XML using SOAPUI.
  • Extensively used QTP for automated testing and VB script.
  • Working and communicating with programmers, project managers, and application rollout groups in order to set and meet quality standards and deadlines.

Environment: HP Quality Center 9.2, QTP (Winrunner), TOAD, BO, Ab- Inito, VB Script, Ultra EditLeech FTP, Oracle, HTML, XML, XML Spy, UNIX (HP AIX) and Windows XP

Confidential, Kansas City, KS

QA Tester

Responsibilities:

  • Developed Test Plan and Test Cases for e-bill, call rating based on the user stories (functional and technical requirements), based on the solution requirement specification (SRS) documents from Business analyst and technical design documents from Developers.
  • Attended sprint plan meetings to review the requirements.
  • Involved in manual testing of the application and tested the billing functionality and call rating.
  • Tested billing calculations based on multiple plans, features like text messages, downloading files etc.
  • Involved in web services testing using SOAPUI.
  • Executed Data Driven Test Scripts with using QTP.
  • Executed various SQL queries, joins to verify the Monthly bill reports on Oracle.
  • Conducted Integration Testing, Regression and Smoke Testing, System Testing, Security Testing, and GUI Testing.
  • Ensure all documentation above is approved by the QA Manager prior to carrying out any testing.
  • Coordinated with developers to fix the bugs and conducted Functional (Positive and Negative), and Integration Testing.
  • Participated in weekly meeting with the management team and walkthroughs.

Environment: C#, .net, QTP, Quality Center, MS Office, Unix, IBM DB2, OracleOLAP.

Confidential, Chicago, IL

QA Test Analyst (Manual/Automation)

Responsibilities:

  • Worked in Agile methodology. Attended Daily standup meetings. Developed Test Plan and Test cases based on the user stories (Functional requirements)
  • Detected Defects, Communicated to the developers using Bug Reporting Tool and Tracking the Defects using Quality Center.
  • Executed manual test cases and identified the test cases to be automated.
  • Extensively used Quality Center for test planning, bug tracking and reporting.
  • Uploaded Business requirements, test scenarios, test cases and defects to Quality Center
  • Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end & performed end-to-end testing. Tested Web Services and XML using SoapUI.
  • Developed test plans, test cases, test scenarios using the Quality Center and prepared test data.
  • Prepared Test Cases for GUI application. Developed test scripts for Data driven testing using parameterization in QTP by using Excel sheet for test data and Database Queries based on the functionality.
  • Converted manual test scripts to automated test scripts in Quick Test Professional, enhanced the scripts by adding user-defined functions. Worked on Automated test scenarios for GUI, Functionality, Integration, Database, Boundary, Security and Regression Testing using Quick Test Professional.
  • Involved in testing the backend Database retrieved the data from the tables using SQL.
  • Worked on the high-level framework, identifying the functional areas and created different functions to make the scripts reusable in Quick Test Professional.
  • Prepared test scripts using Quick Test Professional with checkpoints using regular expressions for handling windows with different names.
  • Identified bottlenecks, and discussed the same with business analysis team, developers and technical architects and attended meetings.
  • Executed shell scripts in Linux.
  • Reported the bugs, Emailed notifications to the developers using the Quality Center.

Environment: Java/J2EE, Quick Test Professional (QTP), Quality Center, Web Logic application server, UNIX, MS Office, Oracle, Web Services, SoapUI.

Confidential, Richmond, VA

QA Test Engineer (Manual)

Responsibilities:

  • Analyzed the specifications in the User Requirements Document, Functional Specifications and Technical Requirement Documents to prepare Test Cases.
  • Developed test cases and performed manual testing for each system build for POS, e-commerce apps.
  • Involved in Tese case and Test plan review meetings
  • Performed Backend Testing to verify the data with front end.
  • Conducted Regression Testing on various builds of the application and reported the defects to the developers using Quality Center for the bug fixing and tracking.
  • Tested SAP SD - Sales and Distribution module to validate the data and reports.
  • Quality Center was used to track defects and reported to development team.
  • Involved in entire QA Life Cycle, which includes Test Designing and Execution of the entire QA process and documentation of Test Plans, Test Cases.
  • Involved in weekly defect status meetings.

Environment: C# .net, VB Script, Oracle, SQLPlus, SAP SD module (Sales and Distribution), XML, Quality Center, MS Office, Adobe Flex.

We'd love your feedback!