OBJECTIVE

• Seeking a QA Tester Position that enables me to contribute to the organization by improving quality of applications and systems, and where I can utilize my strong academic, analytical, testing and BA skills in both client/server, web, ETL and mobile applications

SUMMARY

• Experienced Senior QA Tester with 8 plus years of testing Software applications for End to End functional, Automation, Web Services, Regression tests, Performance and UAT in Financial, Educational, Entertainment and Pharmaceutical domain.
• Extensive experience with Software Quality Assurance Testing on GUI based Client - Server & Web Based applications, ETL, Web Services, Data Warehousing Projects on UNIX, Mac and various version of Windows platform using Manual, Database and Automated testing procedures
• Expertise in SDLC and Testing Lifecycle Methodologies specializing AGILE methodology.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Expertise in ETL Tools (Data stage) and Reporting Tools (Business Objects).
• Created ETL test data for all ETL mapping rules to test the functionality of the Datastage mappings and other ETL processes.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analysed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Worked onWeb ServicesTesting usingSOAP UI 4.0/Pro, Rest Api, Apache Axis Client 2.x, Eclipse 3.4,
• Expertise in developing Test plans, Test Metric Reports, Test Execution Planning, Functional coverage Matrix, Automated Test Scripts, Defect tracking, Metrics Collection, Web testing, Load Testing, Software documentation from business, technical and functional requirements.
• Expertise Testing on Mobile Devices IOS, Android, Blackberry, XBOX, Roku and getting logs using web debugging tools xcode, adb, Fiddler, Charles.
• Experience in creating performance test scripts and configuration of performance tests Using Performance testing tool Load Runner, Neo Load.
• Experienced in working in very large scale projects which are fast paced with aggressive time lines with highest quality and challenging deadlines.
• Excellent skills of identifying defects and managing them during testing cycle using defect Tracking Tools (Bugzilla, fogbugz, Quality Center, JIRA).
• Good Experience in Design, Developing & Implementation of Automation Frameworks.
• Experience in working with Global teams, Onsite-Offshore model.
• Exhibits strong LEADERSHIP qualities including excellent judgment, relentlessly high standards, can dive deep and remain in touch with business details, drives innovation in their teams, invokes passion in others, can think big, and delivers results.
• Excellent communication skills.
• Able to work under pressure to meet deadlines and the ability to work in a cross-functional environment. Effectively able to work as a team member as well as independently.
• Friendly and flexible person and quick learner.

TECHNICAL SKILLS

Tools: Test Director, Quality Center, Jira, Soap UI/Pro

Operating Systems: Windows 2000/NT, XP, UNIX, UBUNTU 11.04, Mac

Languages: C, C++, SQL

Web Technologies: HTML, XML, VBS, JAVA, PYTHON, Shell Scripting, Apache ant, axis client

Databases: SQL Server 2000, Oracle 9i/10G, PostgreSQL1.12.2, MS SQL workbench, MYSQL

Data warehouse (ETL Tools): Informatica7.1.1, Datastage

Reporting Tools: SAP Business Objects

Data Analytics Tools: Omniture Site Catalyst

Automation tools: QTP, Selenium WEB DRIVER

Version Control Tools: GIT, SVN

Mobile Devices Tested: IOS (iPhone, iPad, iPod), Android (Tablet, Phone), various other Tablets.

Performance testing Tools: Load runner, Neo Load, Team Quest

PROFESSIONAL EXPERIENCE

Confidential

Sr.QA Engineer

Responsibilities:

• Responsible for UI, Functional, Web Services, cross browser, Automation, ETL, Reports Testing of Web, Reporting applications developed in JAVA.
• Involved in Requirements meeting, created Test artifacts as per Business and Functional requirements using Jira.
• Performed Back end Testing-using SQL queries, generating reports to ensure data integrity, Constraints and validate the inserted and updated data using complex Joins, Sub Queries, Stored procs etc.
• Responsible for running the ETL scripts and validated the source and Fact tables with various ETL Scenarios.
• Involved in SOAP and Restful web services using SOAP UI, axis client.
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
• Developed Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested.
• Developed Groovy scripts to test Report application output.
• Automated some modules of application using Selenium WebDriver, Eclipse and executed them using ANT.
• Maintained the nightly regression test cases using the CI environment of Jenkins and follow up as needed for the high priority issues.
• Troubleshoot the automation or web services failure by analyzing server log files.
• Facilitate the Testing Kick-Off Meetings, and prepare the PowerPoint presentation/Live meeting materials.
• Validate and approve entry/exit criteria forms for System Integration and User Acceptance Testing.
• Reporting Daily progress in Jira and also discuss during the sprint's Story Grooming, Demo and Retrospective meetings.
• Facilitate/Assist with daily/weekly meetings held by Testing Enablement to discuss status of testing and calendar activities.
• Escalated testing issues, risks, dependencies, resources constraints to the Testing Enablement Team leadership.
• Production Rollout - Support Production push. Run tests in production and sign-off to the Rollout Manager on test results

Environment: Jira, Selenium WebDriver, Groovy, Restful and Soap UI/pro, Web Services, XML, WSDL, SQL, Oracle 119, Junit, SQL, Windows, Java, Git, Ant, Jenkins, Unix, Putty.

Confidential

Sr.QA Engineer

Responsibilities:

• Involved in preliminary discussions of the Project with the Core Team according to Business Requirement Document.
• Prepared test plans and developed test cases according to the user requirements for manual and ETL testing.
• Experienced in installing builds from Test Flight, Gmail on different mobile devices and set up test environments and configure app settings for testing.
• Experience working with web debugging proxy tools and other mobile debugging tools like Xcode, adb logcat, Fiddler, Charles to get logs from related Application Server.
• Developed Complex SQL Transformation Queries to verify data is transformed correctly in to Data Warehouse from Omniture according to various business requirements and rules.
• Make sure that ETL appropriately rejects, replaces and reports invalid data without any data loss from source to Data ware house and Make sure that data is loaded in data warehouse within prescribed and expected timeframe.
• DB Validation to check the Field Size Validation, check constraints, Indexes, Stored Procedures and all the test cases which should match with the Functional Requirements.
• Knowledge of on how SQL Server Integration Services (2005) perform Extraction, Transformation, Loading.
• Writing and executing test plans, Test Metrics, debugging and reporting code bugs and pushing quality upstream
• Designed Daily Reports for BA Team using Business Objects (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Performed End to End testing on the Web Application and Mobile Application on Various Mobile OS (IOS, Android, and Xbox) as per Business Requirements which includes Positive, Negative, User acceptance, Edge case, Browser compatibility, Network, Retesting, and Regression Testing.
• As a Data QA Lead, Co-ordinated with BI, Research and Developers, Project Managers and QA Team to make sure requirements from Business is delivered properly and accurately to the developers and QA Team.
• Actively Participated in Weekly BI Meetings, Sprint Planning and Daily Stand up’s to update the team with QA status
• Using Jira for Storing, maintaining the test repository, bug tracking and reporting and discuss the issues found with Developers and prioritize them accordingly.
• Done Code Reviews for the complex Queries Team has written.
• Involved in Automating the Functional Test Scenarios using Selenium.
• Participated in load testing using Neo Load.
• Used Virtual User Generator to generate VuGen Scripts for web.
• Identified Disk Usage, CPU, and Memory for Web and Database servers and how the servers are getting loaded.
• Enhanced and modified the scripts according to the test case scenarios.

Environment: Business Objects, Omniture, Bamboo, SQL, SSIS, MySQL, Selenium, Neo Load, Confluence, Jira, GIT, Java, EXCEL, Mongo DB, Android, IOS.

Confidential

Sr.QA Engineer

Responsibilities:

• Involved in automating all test cases using Selenium Web driver in Eclipse.
• Created SQL queries to validate the data between user interfaces and databases.
• Manually performed Frontend Testing of web and Mobile application to make sure the functionality is as expected comparing with specifications.
• Created UML diagrams which enabled the team create more efficient test cases including Positive, Negative, Edge case, Browser compatibility, Use case, Data input and Usability scenarios.
• Used Fire bug as part of testing to monitor CSS, HTML and Web performance for different content posted.
• Monitored the Data Integrity, Data Validity, Data Manipulation and Updates by writing Complex SQL Queries after each nightly and Weekly ETL’s.
• DB Testing to check the Field Size Validation, check constraints, Indexes, Stored Procedures and all the test cases which should match with the Functional Requirements.
• Executing Load Test scripts for different QA Environments and identifying memory leakages using Load runner.
• Enhanced and debugged the scripts using VuGen and performed Parameterization and Correlation to meet the requirements.
• Work closely with the other members of the Development Team and Marketing to review the designs of systems, implement test plans, and test the quality of software products.
• Work closely with the Documentation team to insure the content is meaningful and correct
• Communicate with customers regarding installation issues and software defects
• Used Rally to keep track of all plans, team status and release status for agile methodology.
• Organized, contributed and participated in daily scrums, to provide my views and inputs which are very vital to track the team status for Sprint.
• Co-ordinated with developers, tech-leads, project managers, product owners, business analysts and with design teams for any inquiries from my testing team.
• Worked closely with the developers in fixing show stopper issues and high priority issues.
• Suggested new methods by presenting demos and helped team to implement those methods for the development of QA process to delivery of best product.
• Managed the Sprint retro, reviews and planning. Tasked out all the Stories for QA.
• Deployed the Source code, compiled it, and checked out different development branches locally to test the features before they are deployed on QA machines to catch the Bugs earlier.

Environment: UBUNTU, Manual Testing, Selenium WEBDRIVER, JAVA, PostgreSQL, SQL, Fogbugz, Rally, GIT, Cognos 8.4, Datastage,Load runner.

Confidential

QA Tester

Responsibilities:

• Performed Grey/White box testing on multiple databases after ETL (Extract/transform and load) from various educational software vendors’ databases
• Produced Test cases for ARIS project which includes the TRANSFORMATIONS and the DATA changing scenarios.
• Executed Python ETL (Extract, Transform and load) testing modules using nose script on UNIX to load the test data from source to operational databases and then to DW.
• Created shell scripts to call Datastage jobs and run ETL, and then run reports using Cognos for various Metrics provided by BA Team.
• Created complex SQL Queries that deal with multiple tables to retrieve the data which later will be compared with Functional Requirements.
• The entire Quality assurance test performed by me revolves around databases, which is central to the application.
• Performed Front end validations to ensure Data is properly displayed from application perspective.
• Performed rigorous testing like Functional, Regression, Integration, sanity, usability, compatibility, UAT testing.
• Performed end to end testing on the alpha version of the software application and detected several bugs.
• Expertise in writing test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements for Web Applications using Quality center.
• Recommended and implemented best practices for Quality Center implementation and usage.
• Managed QA tasks, requirements and defects in HP Quality Center.
• Participated in daily scrum meetings with developers, Business analysts, Project managers and QA team to discuss the progress of the project and QA tasks.
• Involved in the estimations of each sprint and prepare the burn down charts to keep the track of QA work.

Environment: Oracle9i, QUALITY CENTER, UNIX, JAVA, Ant, Git, SQL Developer, HTML, Python, QTP.EXCEL, RALLY, Cognos, Datastage.

Confidential, NY

QA Analyst

Responsibilities:

• Created Test Plan and Test requirement in Excel sheet from the Functional and Design documents and other available references and Exported to Quality Center.
• Analyzed the user requirements by interaction with developers and business analysts.
• Involved in Functional testing, Black box testing, Negative testing, GUI testing.
• Preparation and Review of End to End Test Scenarios/Test Cases, Coverage matrix and Test data.
• Conducted database tests by executing SQL queries to ensure the data integrity by checking various kinds of constraints.
• Managed Test Plans, Test Cases, Requirements, and Defects using Quality Center.
• Logged discrepancies to Test Director and coordinated their resolution with the development team participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts.
• Coordinated with the Development Teams and Business Users on Defect Analysis.
• Prepared Planning and Execution Status reports for the management.
• Identifying the functional problems in the Application under Test.
• Responsible for Traceability Matrix, Test metrics.
• Worked on Prime Brokerage and Equity Trading Applications.
• Tested the Web pages and business rules for the application.
• Responsible for the Regression Testing using QTP.

Environment: Java, XML, .NET, Oracle 9i, Test director, Main Frames, QTP, UNIX, SQL Queries.