Qualifications Summary

• Over 7 years of professional IT experience as a QA Tester, ETL Tester, Content Tester and QA Analyst roles in Banking, Airlines, Insurance, Retail and Educational Domains.
• Extensive experience in software quality assurance testing on ETL, Client-Server and Web-based applications.
• Proficient with the Manual Testing and Automated testing.
• Expertise on all phases of Software Development Life Cycle SDLC and Software Testing Life Cycle STLC ranging from requirements gathering to User Acceptance Testing, Defects Logging and Tracking till closure.
• Experience in Manual Testing GUI Testing, Field Validation Testing, and Functionality Testing of GUI and Web Applications.
• Black-box and Gray-box testing on the application after installation and configuration testing.
• Experience in analysing business specification documents, developing and execution Test plans, Test cases/scripts, Test Summary reports for Manual and Automation testing.
• Proficient in Validation, Functional Testing, Performance Testing, Integration Testing, Regression Testing, User Acceptance Testing, GUI Testing, and Compatibility testing.
• Full understanding of SQA, SQC and Agile SCRUM Methodology.
• Effectively communicate defect management process during software testing and generate reports based on the test results using bug tracking tools like Quality Centre, Rally.
• Good understanding of ETL testing principles and Data warehouse concepts.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Experience working in Agile and Scrum Environment.
• Hands on experience in developing test automation scripts using Quick Test Professional for regression and GUI functional testing.
• Extensively used SQL Queries for backend testing.
• Experience in PL/SQL, DML and DDL, writing Complex SQL and Testing scripts for Backend Testing.
• Testing web services using SOAPUI.
• Ability to work individually and as well as in a team by interacting with developers and business analyst regarding testing status and defect tracking.
• Experience of working with Customers, Delivery Managers, Project Managers and Technical Teams for securing executing concurrent projects.
• Excellent oral and written communication skills with strong problem solving skills and a result oriented attitude.
• Keen attention to detail/accuracy and ability to function in a stressful environment.
• Ability to learn new technologies and adapt to new skills at quick pace.

Technical Skills

Professional experience

QA Analyst

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Extensively involved in writing test cases, test scripts and execution of test cases, reporting and documenting the test results using Quality Centre
• Prepared test documentation , designed test plans and test strategies
• Involved in Scrum model Agile Methodologies which has daily meetings and there is a build delivered every week. Backlogs are identified through this daily meetings and were delivered in forth coming releases.
• Worked with team members to define test objectives
• Managed defects using Quality Centre
• Performed Manual Black Box testing on entire Project.
• Tested the web-services frame works which interacts with customers using SOAP-UI tool
• Generated and tested Data files , issue files for 3rd party vendors
• Worked with all stakeholders as an when required in regard to the QA effort
• Extensively executed SQL queries in order to view successful transactions of data and for validating data in Oracle Database.
• Attended the Bug Review meetings with results and was actively involved in planning for the next build and the changes to be brought into it.
• Coordinated with the Development Team on Defect Analysis arising in Test environment
• Extensively involved in interface testing by dropping files to 3rd party vendors using FTP and mailbox
• Monitored logs during complete testing cycle using CO-PILOT
• Extensively involved in requirement review , test plan review , test closure review meetings
• Conducted User Acceptance Testing along with the business owners
• Worked with development and testing teams to accomplish timely release objectives.

Environment: Windows XP, Java, XML , Quality Centre , Oracle 11i, TOAD, MS Project, MS Access, SOAP UI pro, Notepad ,WinSCP.

Confidential

Jr. ETL Tester

Responsibilities:

• Involved in gathering Business requirements and analysed functional specs for applications.
• Wrote Test Cases for EDW - Data ware house Source to Target .
• Validated Source - Target mappings applying various transformation rules and Business Rules.
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Created Test Cases in Quality Centre and RTM and mapped Test Cases to Requirements. Developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Responsible for writing, executing and debugging SQL queries to perform data completeness, correctness, data transformation and data quality testing.
• Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing.
• Validated Data ware house tables using Toad.
• Tracked the defects using Quality Centre.
• Created checkpoints and synchronization points for functional testing using Quick Test Pro QTP .
• Prepared status summary reports with details of executed, passed and failed test cases.
• Interacted with developers, Business Management Teams and End Users Participated in regular project status meetings related to testing.

Environment: QTP, Quality Centre, Java, J2EE, XML, TOAD, SQL, DB2, Windows XP, INFORMATICA

Confidential

QA Analyst

Responsibilities:

• Analysed Business Requirements Documents BRD to prepare the detailed Test Plan and Test cases.
• Prepared the test strategy and planning document, test cases and test procedures using Rally for testing the application under Test.
• Managed the entire QA efforts, including manual and automation, of an application in Agile Methodology SCRUM environment.
• Participated in Sprint Planning and Sprint meeting. Also attended story grooming meetings and estimated those user stories.
• Participated in review of Test Plan and assisted QA lead in updating the test plan
• Preparing Automation Test cases and QTP Script using VB Script Descriptive Programming based on Functional Requirement Specifications and executing the prepared QTP Script.
• Created Test cases and test scripts in QTP based on the requirement passenger transaction module, enrolment process, travel and payment process.
• Created Standard, Image, page, Text/Text Area, Bitmap, Database, checkpoints in Quick Test Pro script for validations.
• Responsible for functional and regression testing.
• Added verification steps to tests and managed objects in the Object Repository.
• Used the Object Spy tool to learn the properties/methods of the object under test.
• Imported and exported data from and to Excel to and from QTP.
• Used Parameterization in Global and Local Data Tables QTP extensively to perform Data-Driven testing
• Performed Integration testing to check the flow of application.
• Performed User acceptance testing in the final phase of software development process to check the functionality of the software.
• Used SQL Queries to verify the data from the Oracle database.
• Written Both Positive and Negative Test Cases.
• Prepared documentation for Business Process Components BPC.
• Preparing smoke test and regression test suites for every new Build on monthly basis.
• Creating member Firms and content pages with the Promos in the Author Site and checking in the Publish Mode Site.
• Tested the application on different browsers as a part of compatibility testing to maintain cross-browser functionality.
• Responsible for testing various applications in coordination with the offshore onsite team for work related and other issues.
• Created daily, weekly and monthly status reports and defect reports to capture testing progress for every release and regression suites.
• Scheduled the tests for execution and then did monitor, measure, control and report on the test progress, the product quality status and the test results, adapting the test plan.
• Communicated the status in daily Scrum meetings.
• Involved in updating the execution dashboard and build report for each build.
• Guide and mentor the junior team members in resolving their technical issues.

Environment: Oracle 9i, J2EE, JavaScript, UNIX/Windows 2008, SQL Server

Testing Approach: Quick Test Professional 11.5, Rally

Confidential

QA Engineer/Analyst

• Involved in regression and user acceptance testing of JC Penney Point of Sales applications for stores and kiosks.
• Actively participated in requirement gathering and Test Plan review meetings.
• Implemented defect management process and test case templates using HP ALM 11.0. Worked on defect life cycle management process.
• Involved in ecommerce testing of JCP.com for assortment, purchasing and shipping modules.
• Involved in jcp.com app on Libby IPOD for regression testing after each modification and new enhancements. Reviewed and analysed executed test results with business analysts
• Tested web applications in Waterfall and Agile development process.
• Built automated test scripts using QTP for JCP.com and POS regression testing.
• Tested system upgrades for JC Penney store workstations migrating from SQL server 2000 to SQL server 2008. Implemented SQL queries for test verification and to validate data in various databases.
• Tested the workstation and register upgrades from Windows XP to Windows 7
• Tested reporting tools for sales audit, loss prevention, cash room and electronic journal.
• Involved in quality assurance of business rules engine for store and online returns, store gift card purchases and Sephora gift cards.
• Tested POS software updates and new releases on Epicor and NCR
• Modified and maintained the existing test scripts in QTP to cover existing and new functionality.
• Tested Centralized Salon Capabilities and associate scheduling application.

Environment: HP ALM 11.0, QTP, SQL Server 2008, VB Script, Windows 7

Confidential

QA Tester

Responsibilities:

• Developed detailed Test Plans and Test Cases in Mercury Quality Centre and executed them.
• Analysed business processes and participated in Requirements gathering sessions. Fully understood Use-Cases and Requirements for creating test cases.
• Maintained requirements and traceability with test cases in QC.
• Performed GUI, Functional, System-Integration and Regression testing.
• Extensively used SQL for data integrity testing at the backend.
• Investigated Software defects and interacted with Analysts to resolve technical issues. Performed extensive data analysis.
• Analysed functional specifications for enhancement of existing functionality.
• Extensively worked on QC for bug tracking/reporting.
• Conducted Smoke testing on new versions. Trouble shooted network problems in the testing environment.
• Responsible for System Testing, Regression and User Acceptance Testing. Tested User Interface and application functionality.
• Recommended continuous process improvement, maintained QA standards and artifacts.

Environment: Windows 2008, IVR Systems, ASP, HTML, SQL Server, MS-Word, Ms-Excel, MS-Project, QC.

Confidential

Test Engineer, Content Tester, UAT

Confidential

• At Houghton Mifflin Company HMCO , the Math Web Services MWS is a project for the development of mathematics content for HMCO's online courses. The online course platform is called Eduspace. Eduspace provides an environment for interactively working through questions, which are similar to those in the textbook. Questions are generated dynamically from authored content and grading occurs online. The Maple Authoring Environment or MAE developed by Maple soft using the Maple computer algebra system handles the dynamic generation and grading of questions. For each question, an author develops a Maple worksheet within the MAE. The Maple worksheet is later translated into the Extensible Mark-up Language XML content files that Eduspace runs in its courses.
• It is an E-learning project of maths, based on various mathematical books that include various topics like Trigonometry, Probability, Calculus, Precalculus, Vector Calculus, Linear Algebra, Logarithms, etc.
• The Maple Authoring Environment MAE is a tool developed by Maple soft for Houghton Mifflin. The MAE provides a structured way for question authors to create questions and all question components. It is a template document form containing all of the required information in a question. The MAE is based on the Maple 10 desktop environment Version 10.05 which must be installed for operation. The native file format is a Maple worksheet .mw . Conversion tools are applied to .mw files.

Responsibilities:

• Worked on Maple soft 10.07
• Requirements understanding
• Create and program all question components using Maple Authoring Tool
• Author new step-by-step components using Maple authoring Tool
• Perform quality assurance Including accuracy checking, copyediting, and proofreading.
• Perform Content testing , Functional testing, Integration testing, Systems testing and compatibility testing
• Create and upload defects in excel
• Re-testing and Regression testing
• Deploy questions in preview environment for content acceptance testing by HM
• Perform project management Status reports to be submitted at least weekly, required to participate in weekly status meetings
• Helped other team members in Execution of the project during their critical dead lines
• Prepared a static data document which can be used during execution by everyone to reduce the problems faced because of static data
• Cross Training other teams on Math Content Testing
• Training New joiners on Product System
• Performed extensive Manual Testing on Client Server and Web based Applications.
• Actively interacted with the development team in resolving Bugs identified from testing Ability.

Environment: C, Maple Authoring Tool