EXPERIENCE SUMMARY:

• Over 5+ years of experience in Quality Assurance performing Manual and Automated testing.
• Expertise in analyzing Business Requirements, Technical requirements, and High Level Design Documents for all projects
• Hands on manual and automated software testing using tools QTP, HP ALM.
• Hands on experience on Data warehousing and ETL testing.
• Experience in preparing Test Plans, Test Strategy, Test Cases, Test schedule planning, Test Traceability Matrix, Defect Reports, Test results documents for projects
• Have strong knowledge in Software Development Life Cycle and Software Testing Life Cycle concepts and its implementation in projects and Well versed with Waterfall, V Model Testing Methodologies
• Innovative and articulate in different types of software Testing Methodologies, procedures and technique such as Black Box
• Developing Test cases per the requirements/client change requests and experience in conducting and managing Smoke, Functional, Integration, System, Regression, Database on the testing applications and Involved in the client User acceptance testing
• Experience working in Quick Test Professional with expertise in creating data driven framework in QTP for automation of test
• Developed and Maintained Automation Test Scripts for Functional and Regression Testing for Web Based and Client server applications
• Worked on database testing and validating the applications against the database
• Expertise in using the HP Quality Center, Whizible for Defect Tracking, Organizing, Managing, Planning, Writing and Executing the tests Cases
• Possess Portals, HRMS, Whizible and Banking domain experience
• Team player and self starter always committed to Organization, Quality and improve customer satisfaction
• Proficient experience in different Databases like Oracle, DB2, SQL Server, and Teradata.
• Experience with dimensional and relational database design.
• Strong in Data warehousing concepts, Star Schema, and Snowflakes Schema, methodologies, understanding business process/requirements.
• Proven success in Multitasking, handling multiple projects and responsibilities
• Motivated to take independent responsibility as well as to contribute to be a productive team member. Strong Team building and mentoring skills and excellent Team leadership capability
• Work with development team to evaluate unit testing coverage, ensure that any coverage gaps are documented and addressed
• Communicating with the client on project issues and enhancements for future versions
• Experience in Bug Tracking System, Defect analysis using Whizible, HP Quality Control
• Good knowledge on JIRA tool.
• Good knowledge in the Agile methodology.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/Vista, Windows XP, UNIX

Databases: Oracle 8.1/9i/10g/11g, SQL Server 2000/2005, SQL Server, DB2

Testing Tools: HP Quality Center 9.0/10.0, QTP, Test Director, Tracker, Clear Quest, Rational Suite.

Defect Tracking Tools: HP Quality Center 9.0 - 10.0, Test Director, Bugzilla & Clear Quest.

Query Tools: TOAD, SQL Developer, TeraData SQL Assistant 12.0, SQL Navigator

Others: MS-Office, Visual Studio 2005, File Zilla.

PROFESSIONAL EXPERIENCE:

Confidential

ETL TESTER

Responsibilities:

• Analyzed Business Requirements Document (BRD), Detail Design Document (DDD), Solution Design Document (SDD) and prepared High-level test plan.
• Involved in writing the test cases and Test plans based on Data Mappings from source to target.
• Actively participated in Iteration Planning and Scrum meetings as part of Agile methodology.
• Involved in Manual Testing, Integration Testing, System Testing, UAT Testing, Regression Testing, Functional Testing and Performance Testing.
• Wrote test cases and test scripts for the functional testing and Regression Testing
• Worked closely with DEV team to resolve issues being agile.
• Worked closely with Development team to get the deployment to Test and QA environment
• Involved in Stress and Performance Testing.
• Validated the data flow from Source to Target tables by verifying the Source to target mappings.
• Wrote the SQL queries on EDW tables and Data Mart Staging Tables to validate the data results.
• Involved in writing the test cases and Test plans based on Source to Target Mapping documents and Data model diagrams.
• Analyzed the different scenarios to be tested and documented.
• Prepared manual test scripts covering different scenarios and documented in Mercury Quality center.
• Involved in unit testing, system testing, integration, and performance testing of the jobs.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Used different joins on the tables to retrieve information from different tables in database to check the database on a regular basis using SQL queries.
• Executed test scripts to check the data flow from Source tables to Data Warehouse and Data Marts.
• Used aggregation functions like Average, Max, Mean, Min and Sum in data retrieve for various tables in DW, DM.
• Procedures, Functions, Triggers and packages are validated for the business logic as per the Solution Design Document (SDD)
• Involved in the Testing of the reports and updating the Bug Tracking Tool
• Defect logs were created in Quality Center and coordinated with Development team in fixing the defects.
• Conducted Regression testing on the fixed defects and also to validate the related functionalities.
• Validated the application in multiple environments (QA, Stage and Prod) and also was actively involved in mock Go live and Go live activities.
• Also was involved in the Production support of the application by validating the Action Requests (AR’s)
• Involved in system testing, data integrity testing and ETL testing.
• Written and implemented System level Test plan, test cases and test scripts.
• Responsible for data validations for initials loads and deltas
• Extensively used UNIX command level and UNIX shell scripts.
• Wrote shell scripts to copy files, create directory structure for new projects.
• Responsible for validating the no. of records for the update transformations
• Involved in validating the ETL mappings from various systems (CRM, OLTP) to transaction history/reporting database
• Interacted with Solutions analysts, system staff, ETL developers and the data Load staff.

Environment: HP ALM, Oracle 9i,XML, Flat files, PL/SQL, SQL Assistant 12.0, SQL Navigator, UNIX, Manual testing, Microsoft SQL Server 2005, IE, Firefox, Whizible, Window XP/7/8, Toad, HTML, IE, Microsoft Visual Source Safe, Functional, Regression & UAT, Bugzilla, Sql Developer, WINSQL.

Confidential

Quality Analyst

Responsibilities:

• Managed requirements using Mercury Test Director / Quality Center.
• Documented Test cases corresponding to business rules and other operating conditions in Mercury Test Director / Quality Center
• Involved in Developing Test Plans, Test Cases, Test Scripts and Test Data.
• Performed End-to-End testing manually.
• Responsible for GUI Testing, API Testing, System Testing, Regression Testing and Acceptance Testing.
• Tested the backend database (Oracle/DB2) using SQL queries.
• Developed automation test scripts in VBScript for Smoke testing of the application using QTP.
• Extensively testing the application with multiple inputs using Data Driven framework using QTP
• Communicated defects encountered during regression test and follow up with developers until all issues were resolved
• Created the complex SQL queries to fetch data from the multiple tables based on the Test cases.
• Responsible in providing regular test reports to the management.
• Reported the defects to the developers using Mercury Test Director / Quality Center.
• Investigate software defects and interact with developers to resolve technical issues.
• Responsible for test data preparation for the system/integration testing, traceability matrix to ensure the test case coverage and defect logging.
• Participated in defect review meetings with the team members.

Environment: Mercury Quality Center, QTP, VB Script, Oracle 10g, Win SQL, Windows 00/XP, MS-OFFICE.