SUMMARY

• Over 8 years of diversified experience in Software Testing including User Acceptance, Functional, Regression, Device testing and Integration Testing of Client/Server, ERP and Web applications.
• Extensive experience in Manual, Automated and web services testing using Mercury Interactive tools like QTP and Quality Center.
• Proficient in using both Manual and Automated testing tools such as HP Quick Test Professional,and HP Quality Center/ALM on Web - based and Client/Server applications, Rally, Jira, Bugzilla, BMC Remedy and Rational Clear Quest.
• Good knowledge in diversified fields of the Software Development Life Cycle (SDLC) and Software Testing Life Cycle.
• Good experience in Software Quality Assurance Process, Software Testing and various Methodologies in like Waterfall, Agile-Scrum and Rapid methodologies.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Proficient in finding bugs while doing Navigational, Functional and System testing manually.
• Experienced in writing queries using joins, Stored Procedures, Functions using SQL and validating the data based on query.
• Experience using Oracle SQL Developer, Microsoft SQL Server, MicroStrategy Report Tool.
• Expertise Using Databases Oracle, SQL Server, UDB DB2 and Teradata, Sybase.
• Expertise in creating Test plan and Test Scripts as per specifications and requirements.
• Performed Manual and Automated Testing on Client-Server and Web-based Applications.
• Excellent knowledge of QTP frameworks
• Good experience in using SQL queries to interact with SQL Server and Oracle databases.
• Good knowledge on UNIX commands.
• Hands on experience testing Android/IOS devices.
• Extensively used Notepad ++ and XML marker for xml file editing.
• Extensively used SQL and created SQL Queries for Back-end validations
• Experience in writing Test Plans, defining Test Scenarios and Test Cases, developing and maintaining Test Scripts, analyzing bugs, interacting with team members and track the bugs till closure.
• Good in understanding Business Requirements, Analyzing and interpreting the functionalities to create and execute detailed Test Strategies, Test Plans, Test Cases/Test Scripts/Test Scenarios, Requirement Traceability Matrix (RTM) etc. using Use Case, Business, Technical and Functional Specifications.
• Hands on experience in testing web based applications, developed in .NET JAVA and J2EE.
• Hands on experience running web services in SOAPUI.
• Proficient in Black Box Testing, System Testing, Usability Testing, Negative testing, Exploratory testing, Functional testing, Integration Testing, Acceptance/UAT Testing, IVR testing and Regression Testing in both Windows and Unix/Linux and Web Services Environments.
• Highly skilled in handling Enhancement Requests, Critical Requests and Rapid Deployment releases in short span and working closely with Business Analysts, Dev. Team, Env Team and Prod Support Team to deliver the code in the provided amount of time.

TECHNICAL SKILLS

Testing Tools: HPQC/ALM, QTP, Rational clear quest,Bugzilla,Rally and Jira.

Office Tools: MS-Office, MS-Access, MS Word, Excel, Power Point and Outlook.

Languages: SQL, PLSQL, C, C++, C#, Java, VB Scripting,ASP.NET, HTML Scripting.

Operating Systems: Windows 95/98/2000/XP/NT/7, DOS and UNIX.

Web Technologies: MS Front Page, HTML, DHTML, XML and CSS.

Web Browsers: Internet Explorer, Firefox, Chrome, Safari

Databases: Oracle 8x,9i, 10g, MS SQL server 2008/2008R2/2012, MS Access, DB2,Teradata.

PROFESSIONAL EXPERIENCE

Confidential

Sr. QA Analyst/ETL tester

Responsibilities:

• Involved in manual testing of the MicroStrategy dashboards, Reports, Unit testing of SQL Scripts using SQL Server Database in a Business Intelligence Environment
• Analyzed Business Requirements and functional specification to develop Test plan, Test cases and Test scripts
• Involved in Functional, Non-Functional and regression testing.
• Performed Input validations, UI Validations, Cross browser testing and navigating testing.
• Performed Backend testing to verify the data integrity by executing SQL Queries.
• Participated in daily Scrum meetings and provided daily status of testing.
• Performed ETL Validation of Data in the SQL Server database Between the Source and Staging and from the Staging to Data Mart Tables and verified the ETL logics being applied.
• Documented all the Test Scripts and bugs in Rally.
• Validated MicroStrategy dashboards for Metrics, Reports, Security and privileges, Goals and Collaboration and other features used in the application.
• Validated the MicroStrategy report-Data using the SQL Server Database from the Datamart.
• Performed Regression testing and created defects in Rally.
• Actively participated in Scrum, Sprint Planning’s and Retrospective meetings.
• Involved in product backlog grooming.
• Performed cross browser testing to verify if the application provides accurate Information in different (IE, Chrome, Firefox) Browser.
• Analyzed tests results and identified areas where regression testes could be conducted.
• Worked on UAT and Productions Defects with Business and Development team and created high Severity tickets in Rally for all Defects found.
• Involved in creating Reports and Project Metrics to present the status update to the leadership every Week.

Technical Environment: SQL Server 2008 R2, Flat files, SSIS, VB, MicroStrategy 9.4.1, Rally, MS Office, Windows, Web Services.

Confidential, Atlanta, GA

Sr.QA Tester/ETL TESTER

Responsibilities:

• Participated in both Manual and Automation Testing.
• Review the Business requirements and ensure the testability of these requirements.
• Developed project plan, Test Plan, Test cases for the QA Phase of the Global Data Warehouse. Created and Executed Test Scripts using Quality Center (HPQC/ ALM) (Test Plan, Test Lab and Defect Tracking).
• Worked on CRM (Customer Relationship Management), Online MPS (Message Processing System), Billing, Bill formatter, A/R(accounts receivable) and collection
• Worked on new projects where new environments, machines and billing functionality are being implemented
• Performed validation on data conversion and migration from source to data warehouse.
• Developed SQL queries to check data validity and database integrity.
• Involved in extensive Data validation on Data warehouse/Data mart Database by using SQL, PL/SQL scripts.
• Validated data in new Tables created in SQL Server from Oracle Source.
• Involved in Functionality, System, Integration, and Regression, User Acceptance Testing of Web based Reports.
• Used TOAD to connect to database and perform various operations such as executing SQL queries, View database schema etc.
• Developed complex SQL queries to verify the data loaded into the target tables. Validate the test data using MS access, TOAD, UNIX & MS Excel.
• Used Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Involved in defect coordination and analysis
• Involved in all phases of end-to-end testing which includes functionality testing, regression testing, GUI testing, system testing and integration testing of the application, its interfaces and client/server utilities.
• Updated modified test cases and test scripts into Test director as per the modified requirements.

Technical Environment: HPQC/ALM,UNIX, Web services, XML, ASP, Soap UI, Oracle 10g, Toad, SQL Server 2012, XML, HTML, Rational, JavaScript, SQL, .Net and Windows 7.

Confidential, Phoenix, AZ

QA Tester/ETL tester

Responsibilities:

• Analyzed business requirements and system specifications, Involved in developing the test plan for testing the entire application (Navigation, Integration Functionality, and Security testing).
• Involved in creation of Test scripts/Test cases for new requirements.
• Attend meetings, document user change requests. Analyze user change requirements, and to make necessary amendments to the test requirements.
• Developed test scripts and test cases using QTP, Quality Center (Test Plan and Test Lab).
• Involved in bug tracking using HPQC/ALM 10
• Coordinated the onshore and off shore team to resolve issues
• Designed and implemented automated QTP scripts for testing modules Disclosure Systems and its integration with Integration System
• Performed Functional tests using Standard, and Text Checkpoints in QTP
• Enhanced QTP scripts by inserting conditional statements and checks in VB Script
• Further used VB Script to perform other tasks such as importing excel sheet into QTP data table
• Wrote Complex SQL Queries using Microsoft SQL Server to test the correctness of the data.
• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Performed GUI testing, Functional testing, Regression testing, Usability and end to end testing.
• Involved in creation and maintenance of Test Matrix and Traceability Matrix.
• Performed Back-End testing using SQL queries
• Developed associated project documentation, test plan, test scenarios, performed gap analysis, and test tracking reporting for all phases of testing including user acceptance testing.

Technical Environment: Teradata, PL/SQL Release 9.2.0.4.0, HP Quality Centre,QTP, ETL, UNIX, Windows 7, DB2, MicroStrategy Reporting Tool, MS-Excel.

Confidential

Quality Analyst

Responsibilities:

• Extensively worked with the Business Analysts in understanding the requirements.
• Review and Analyze Business Requirements in testing and automation perspective view
• Involved in requirement analysis. Preparation of test scripts like Test Cases, Test Sets, User Stories, Test Plan and defects logging.
• Testing process included Functional Testing, Integration testing, Data Integrity testing, Regression testing and End to End testing.
• Validated the test scripts for the Functional and Regression testing.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Attend meetings, document user change requests. Analyze user change requirements, and to make necessary amendments to the test requirements.
• Involved in execution of overall test strategy, ensured test plans alignwith test strategy.
• Using standard concepts, practices, and procedures to ensure that new or enhanced software applications meet or exceed the quality standards established for the product’s functionality, usability and performance prior to its release.
• Analyze all report bugs for continuous process improvement and keep tracking on the SDLC critical path.
• Developed and executed the Test Plan, Test Scripts and Test case execution based on Agile SDLC methodology.
• Executed different web services in SOAPUI for validating transactions and account information
• Verified logs on the UNIX system using PUTTY
• Worked on QTP Data driven framework, identified functional areas and created different functions to make the scripts reusable in Quick Test Professional (QTP).
• Used to run tests in QTP through QC and logged the defects in QC.
• Performed Backend Testing using SQL

Technical Environment: Quality Center 9.2, QTP, SQL, UNIX, MS Office, Manual Testing, Agile scrum methodology, Web service, XML, Soap UI, DB2, TOAD, Web services, PUTTY,ETL (SSIS), WINSCP, Share point, Microsoft Visual Studio, Visual Basic 4.0.

Confidential, Dublin, OH

QA Tester

Responsibilities:

• Participated in the Requirement gathering, Functional Specification and Design reviews
• Reviewed Business requirements, design documents to extract testable requirements and test exceptions
• Involved in writing Test plan, Test strategy, Test scenarios to test business requirements
• Participated in Test Estimation, planning, defect tracking and weekly status meeting.
• Performed Smoke testing after all the code is moved to the production to validate the components that were enhanced to support the new front end and also to validate that other components are not impacted by the modifications
• Involved in Functionality, System, Integration, and Regression, User Acceptance Testing of Web based Reports.
• Maintained Defects list for critical issues using Quality Center/ALM.
• Used Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Used TOAD to connect to database and perform various operations such as executing SQL queries, View database schema etc.
• Conducted functional testing at GUI level as well as at module level by writing scripts in Quick Test Pro using VB Script.
• Prepared RTM matrix in excel and track the RTM to ensure requirements coverage in test cases.
• Generated enhanced graphs and reports using Quality Center.
• Wrote SQL queries for to prepare and validate test data.
• Prepared reports to provide the status of the testing efforts to Client/Management and also provided the list of Open, closed and Deferred Defects.

TechnicalEnvironment: Quality Center 9.0, UNIX, XML, Java, VBScript, Oracle8i, SQL, PL/SQL, QTP, TOAD, Quality Center/ALM.

Confidential, Dallas, TX

Quality Assurance Tester

Responsibilities:

• Worked closely with development and Product owners to understand product features.
• Extensively involvedin systemtestandintegrated testenvironments
• Involved in Design, develop andexecute test casesto validate product features
• Extensively used SOAP UI tool for testing web services
• Developed SQL queries to retrieve data for validation purposes based on thetest cases.
• Extensively configured and used simulator tools for submitting the messages in systemtestenvironment where the back end connectivity is unavailable.
• Extensively used HP Quality Center for creating test Cases and executing them.
• Created Defects for the failed test cases using HP Quality Centre.
• Actively participating in enhancement meetings focused at making the application more reliable and also responsible for submitting daily report status.
• Responsible for testing the Real time and near Real time transactions from POS
• Worked and coordinated with Onsite/Off-shore model Environment.
• Highly skilled in analyzing the requirements and framing the documentation for Test Package, Test Plans and test Scenarios.
• Involved in many Rapid Deployment processes, Enhancement Requests and Critical Requests as an important resource from QA.

Technical Environment: Oracle, DB visualizer,UNIX, Java, Quality Center/ALM, MS Office, SOAP UI, XML, Web Services.

Confidential

QA Analyst / Tester

Responsibilities:

• Written and execution of Test Cases based on the business requirements of the application.
• Execution of Test Cases and analyzing test results.
• Involved in Manual, Functional Testing.
• Analyzing requirements, preparation/review of Test Cases.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Detecting bugs and reporting them through bug tracking tool
• Developed test cases in Microsoft Excel files.
• Performed Black box testing, Unit testing, System testing, Stress, Security testing and Integration testing.
• Performed end-to-end testing manually and associated with User Acceptance Testing.
• Performed manual testing on the application to check the application is meeting the requirements as in the specification design document.
• Contributed in preparing documents at all phases of testing.

Environment: Manual Testing, Bugzilla, HP Quality Centre 10, Windows 7, UNIX and MS-Office.