Summary

• Software Quality Assurance Engineer with around 8 years of IT experience.
• Possess excellent skills in Manual Testing of various Web based, ETL/BI, Data warehouse and Client/Server applications.
• Experience in Writing and Executing the Test Cases based on Requirements, expertise in designing Test Plans and analyzing defects.
• Good understanding of Testing methodologies and Software development lifecycle SDLC
• Experience in Waterfall, Iterative and Agile methodologies
• Very good at defect tracking and reporting using the Defect Tracking tools like Quality Center, JIRA, Rational ClearQuest and Test Director.
• Worked on various IT domains like Banking, Educational, Insurance, Health Care and Retail.
• Proficient in writing SQL queries for Backend Testing. Extensively used SQL queries to interact with Oracle, SQL server and DB2
• Experience with Informatica ETL tool
• Experience in different types of testing like GUI Testing, Functional Testing, Integration Testing, Smoke Testing, System Testing, Back End Testing and Regression Testing.
• Experience with Batch testing in running batch jobs.
• Good understanding in Data Warehousing and ETL Testing concepts Dimension Data Modeling, Star Schema and Snowflake Schema, Surrogate Keys, SCD Types
• Possess good analytical and logical skills coupled with interpersonal, communication, presentation, documentation and self-organizing skills, a committed team player.
• Ability to handle multiple tasks and Work independently, as well as in team environment, to achieve project quality goals.

Technical skills

• Operating Systems : Windows, UNIX/Linux, MAC
• Languages : C, C , Java, SQL
• Scripting Languages : VB Script, TSL, HTML, XML, Java Script
• Testing Tools : HP ALM/Quality Center, Bugzilla, Clear Quest, Selenium IDE
• ETL Tool : Informatica
• Bug Tracking Tools : JIRA, Test Director, Bugzilla
• Databases : Oracle, MS SQL Server, MS Access, DB2
• Web Servers : Apache HTTP Server
• Microsoft To : MS Office
• Other Tools : SOAP UI, DB Visualizer, Sql Developer, Putty, WINSCP, Eclipse,
• SQL Server Management Studio

Professional Experience

Confidential

Role: Sr. QA Analyst

Confidential is an E-Commerce Banking Program. It has embarked on a major corporate initiative to refresh/build out the internet channel. The goal is make internet channel to be a primary hub for JP Morgan Chase customers to manage their financial needs, and act as a key channel for new and existing customers to establish and deepen Confidential project is a web based application designed for JP Morgan Chase customers for managing their finances through transfers payments and pay bills through online

Responsibilities:

• Analyze business requirements, use case, wire frame documents etc., create and execute test cases for web application to test various functionalities in Western Union, Zash Pay and Visa Money Transfer. .
• Communicate gaps in the requirements to the BA's and walk through requirement analysis.
• Create, modify and maintain defects using QC, Clear Quest DTS and discuss the issues with the development team.
• Performed User Interface testing - screen navigation test to ensure the links are established as per the requirements.
• Interacted closely with Western Union team to execute the scripts for various scenarios in their PI environment which is pointing to U.S. Bank UAT environment
• Responsible for testing complete functionality of Zash Pay for various Scenarios by setting up the users daily, weekly and monthly exposure limits.
• Responsible for testing Visa Money Transfer to the batch scripts.
• Transfer funds to another account using JP Morgan Chase Visa Money Transfer.
• Responsible for batch testing
• Updated test cases based on the functionality of the application depending on project change request PCR .
• Supported integration testing and end to end testing with all the upstream and downstream interfaces in IT and UAT environment.
• Co-ordinated with development team for testing issues and in resolving the issues
• Assisted with testing activities and other tasks in parallel with OLB/MM project.

Environment:JAVA, Hogan CICS , Rational Clear Quest DTS , HP-Quality Center, QC, Oracle, DB2, Share point, MS Office tools, Windows XP/Vista/7-IE, Firefox, UNIX

Confidential

ETL Quality Analyst

Project Description: The objective of this project is to provide a system which manages the Payroll activity i.e. the salary paid for each employee in a company depending upon their attendance. The users will consume less amount of time when compared to manual paper work through the automated system. This automated system will take care of all the payroll activities like managing each employee's attendance, the number of leaves taken by that particular employee and further provides calculation in a very quick manner. There is also a possibility of checking salary report at any time so that it doesn't lead to any miscalculation.

Responsibilities:

• Direct interaction with Business Analysts to understand technical requirements and business requirements.
• Responsible for recruiting the testing team members and knowledge transfer, Task Assignment and deliverables.
• Involved in Preparing the environments for testing, Creation of access requests for the environment and Planning the shared environments with other projects.
• Various reports are generated to actively contribute in planning the project delivery lines and played key role in shaping new Change Requests CR .
• Communicated with different production teams to develop test data for different applications and documented all the flow.
• Prepared High-Level and Low-Level test cases based on Design documents, Requirement documents and developed Test plans.
• Interacted with Development, Business and Reporting teams to make sure different applications on each mart are error free.
• SQL, PL/SQL is used to reflect the business logics on the source data bases and compared the same logics on Target data bases.
• Informatica code is debugged and parameter files are created to run different test data sets.
• Ab Initio Graphs are tested at coding level. The conversion is ensured error free by our team at data base level.
• Involved in End user web application AZ-WIZ, AZ-track testing so that downstream applications are live in production.
• WinSCP/Putty is used to log on to different boxes and track the Informatica log files.
• Quality center is configured as a common platform for different projects and different teams.
• UNIX scripts are used to automate the testing procedures for file loads.
• Performance testing, Load testing are done by collecting the production data statistics.
• Involved in Test Plan, Test result and Test Matrix Documents preparation. Involved in Regression testing, Functional testing and Integration testing.

Environment: Informatica Power center 8.6.1, Oracle 11g, SQL Server, Toad, JIRA, PL/SQL, UNIX Shell Scripts, Primavera, Visio, Excel.

Confidential

QA Analyst

Confidential process governs the establishment, construction, renovation and major medical equipment acquisitions of health care facilities, such as hospitals, nursing homes, hospice programs, home care agencies, and diagnostic and treatment centers. Through the CON process, the Department seeks to promote the delivery of high-quality health care services and to ensure that health care facility and home care services are aligned with community health needs. The CON process also reins in investments in excess facility capacity and unneeded medical equipment that drive up health care costs for everyone, without contributing materially to the health of our communities.

Responsibilities:

• Involved in all phased of testing process until project is deployed to productionand UAT.
• Worked on reviewing the business documents and converting them into manual test cases and documenting them in Quality Center ALM .
• Identify, analyze, and interpret trends or patterns in complex data sets. Interpret data and develop recommendations based on findings by extensive use of Oracle SQL Queries and advanced analytic functions.
• Understood the Business requirements and preparing the functional test cases
• Developed reusable Generic and Application functions using VB script, These functional can be used anywhere in the test scripts
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Authored and executed Test Cases and Compares the actual results with -expected results
• Worked on converting manual test cases in to Automation scripts VB Scripting and execution of those test scripts for the new builds
• Updated the test cases as per the new requirements changes, UI changes
• Involved in deployment of new build code on different server machines and perform sanity testing.
• Conducted Internal Reviews on Test Cases
• Involved in compatibility testing of the application with different browsers like Firefox, IE etc
• Worked on execution of high end SQL queries to test backend data insert in proper tables when the user does any transactions in the application
• Worked in Automation scripts development, Execution and debugging, reviews, batch scripts execution, analyze results and reporting defects Identify regression scenarios for automation and regression cycles
• Worked on documenting the defects found in defect tracking tool Quality Center ALM during test execution
• Worked in internal QA Peer-Reviews
• Performed various Black Box Testing techniques like functional and Regression testing
• Created traceability matrix to map test cases with requirements
• Involved in front end GUI testing and also Backend database validations testing

Environment: Windows 7/XP, MAC Unix, JAVA, Quality Center, QTP, Eclipse, XML, MS-Access, Notepad , IBM Rational tools, SQL Developer

Confidential

Role: QA Analyst

Confidential is being developed to replace external Siebel System and to enhance Symantec Sales Process, also used by other departments such as Operations and Confidential. This system has a capability to store account/customer information, manage contact details, alert IBM software renewal dates, enter and track commissions for sales team and timesheets for employees. Based on role a sales person can assign accounts to his team and track their activities. Leaves can be requested and approved for employees using this system.

Responsibilities:

• Coordinated with Business Analyst's and developers regarding issues with requirements, functional/user acceptance testing.
• Assisted Test Lead in developing Master Test Plan.
• Involved in developing Test scenarios for Accounts, Software, Account Team, Contacts, Activities, Opportunities, Requirements, and Green sheets, Projects, Time sheets and Leave approvals.
• Developed and executed various scripts using Quality Center of each module and Regression Testing of the applications.
• Created Traceability between Requirements and Test Cases.
• Involved in testing Web Services developed for Employees/ Consultants, Customers and Vendors.
• Validated users in different roles Inside Sales, Account Manager, Business Development Manager, Business Unit Executive, and Vice President have access to different screens.
• Verified various reports Activities, Opportunities, Requirements, Projects, Software Resale, and Sales generated for the management.
• Wrote SQL queries for Database testing End to End Testing and was also involved in performing Back-End Testing by writing SQL queries to extract the data from SQL database
• Responsible for Regression testing.
• Performed Regression testing to verify that bug fixes did not break some other parts of the system.
• Reporting and tracking defects/issues using Quality Center.
• Conducted defect review meetings with the development and team members.

Environment: SQL Server 2008, SQL, Quality Center 9.0, SOAP UI, MS-Word, MS-Excel, Windows XP

Confidential

Role: QA Analyst

Project Description: This system consists of modules for providers, membership and quotes. Provider module provides information about all the providers who are present in the network. Membership module provides detailed information about all the members. Quotes module helps individuals and groups to get new quotes. Individuals and groups can select the plan that is more suitable for them from the list of plans.

Responsibilities:

• Responsible for testing quotes module.
• Analyzed the user requirements by interacting with business analysts.
• Attended Business reviews and Functional walkthroughs.
• Prepared Requirements Traceability Matrix to map test cases with requirements.
• Preparation and Review of End-to-End Test Scenarios/Test Cases and Test Data based on the requirements of the application.
• Developed and tested Negative and Positive Test Cases.
• Performed Integration Testing with different modules.
• Defects detected were reported using Quality Center and defect review meetings were conducted with development team.
• Validated output files generated by batch jobs for quotes received from various agents.
• Verified different emails received by Agents during the quote processing.
• Executed SQL queries to check the data table updates after test execution.
• Performed in Smoke, Functional, Regression and Integration Testing of application.
• Maintain relationships with IT managers, Development, production support and business sponsors.

Environment: SQL, Java, J2EE,Quality Center 9.0, Oracle, Toad, VB Script, UNIX, Windows, MS-Office tools

Confidential

Associate Test Engineer

Project Description: This project is an e-commerce site. It provides access to catalog products that can be purchased using secure transactions over the Internet. It covers online sales, purchase, inventory handling and maintenance of the customer database. This Ecommerce site provides the sophisticated features to end users with advanced search with specific criteria's, Image resize, product cloning options and order management options with user friendly, intuitive, point- -click interface. The application is integrated with secured third party, most popular payment gateways to allow and process payments in real-time. This has Admin module provides time-saving store administration tools, smart sales and marketing features which can be used regardless of staff's technical skills

Responsibilities:

• Documentation review and update the documents in VSS version control system
• Performed test cases execution and log the defects in Bugzilla
• Involved in multiple modules testing and integration testing between different modules
• Performed various Black Box Testing techniques like functional, Re-testing, Regression testing
• Involved in compatibility testing of the application with different browsers like Firefox, IE
• Responsible to test application on different browsers for multi-browser testing and verify the navigation and functionality of the links of the application
• Worked on documenting the defects found in defect tracking tool Bugzilla during test execution,
• Involved in deployment of new build code on different server machines and perform sanity testing.
• Involved in front end GUI testing
• Worked on issues verification and test case updates

Environment: Windows, Bugzilla, SQL Server, SQL, MS Excel, Quality Center