SUMMARY:

• A highly - motivated Software QA Analyst/Tester with 8+ years of software quality functionality testing expertise 
• Good Experience of SDLC and STLC and Bug life cycle. 
• Proficient in all cycles of test life cycle from test planning to defect tracking and managing defect lifecycle. 
• Have experience of leading role for testing. 
• Involved in developing Test Plan, Test Cases using Requirement and Design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities. 
• Expert in test script development and coordinating with development team to fix bug. 
• Comprehensive understanding of Quality Center and Jira Defect Module, which supports the entire defect lifecycle- from initial problem detection through fixing the defect and verifying the fix. 
• Have good experience in Selenium automation tool. 
• Expertise in performing different types of Testing: Black box, Integration, System and Regression. 
• Good experience in web application testing. 
• Have worked on SOAP UI for testing web services. 
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using SSIS, DataStage and Ab Initio
• Sound database testing experience with Databases like Oracle, SQL Server and DB2. 
• Sound Experience in Transforming Data from Various Sources like Database, Mainframe, Flat files, and Loading to Target and Monitoring the Performance. 
• Expertise in data mapping and data validation running queries in SQL Server. 
• Gathered test data from SQL server using SQL queries. 
• Helped the users to test in SIT and UAT environment, trained users and prepared user-training documents. 
• Have good knowledge on IBM Cognos Report Studio to generate data reports. 
• Gathering test results and provide testing feedback to the Project Manager. 
• Experience in working with agile management framework. 
• Provided training to the new comers on testing tools and process 
• Developed training document to help the users. 
• Prepared data dictionary, SQL Repositories. 
• Good communication, analytical, computational and teaming skills. 
• Excellent interpersonal and customer relational skills. Proven communication, presentation Skills and Leadership Qualities.

TECHNICAL SKILLS:

Methodologies: Waterfall, Agile

Operating Systems: Windows, UNIX

Testing Tools: QTP

Defect Tracking Tool : Quality Center, JIRA

Reporting Tools : MicroStrategy, SSRS, Cognos Reporting Studio

Languages : Java, VB Script, ASP, HTML, JavaScript, XML, SQL, PL/SQL,

Databases Tools : Oracle, SQL Server, Teradata, My SQL, MS Access

ETL : Informatica, DataStage, SSIS

Servers : IIS, Web Logic (6.1/7.1), Apache Tomcat, JBoss

PROFESSIONAL EXPERIENCE:

Confidential

SQL/ETL QA Analyst

Responsibilities:

• Reviewed the Business Requirements Documents for better understanding of the application functionality.
• Participated in requirement gathering and walkthrough meetings, functional spec review and status meetings.
• Analyzed the Business Requirement Document and Acceptance Criteria to prepare Test plan for QA testing. 
• Created Test Scenarios, Test Cases as per requirements and uploaded them in Quality Center (QC) 
• Involved in Back-End Testing, database table manipulation of relational database systems by writing complex SQL queries. 
• Efficiently used SQL queries to test the required data were properly loaded into the Target Database. 
• Worked on Database validation using SQL queries. 
• Tested the application for specific performance and End User Testing on its compatibility on various web browsers like Chrome and Internet Explorer. 
• Tested various jobs and performed data loads and transformations using different stages of DataStage and pre-built routines, functions and macros.
• Worked as Data Miner for various project using DB2, Oracle, SPUFI, Mainframe. 
• Worked on Cognos Report Studio to prepare reports. 
• Used QC as the tool for Defect tracking and reporting and did follow up with developer team. 
• Performed manual testing and automation testing on web-based application. 
• Developed and execution of automation test using Selenium IDE, Selenium Web driver in Microsoft Visual Studio. 
• Worked with DataStage Shell Commands and checking the job status
• Involved in GUI Testing, User Acceptance testing (UAT), Regression testing, Functional testing, System Integration testing (SIT) 
• Worked on Web Service Testing using SOAP UI. 
• Responsible for writing SQL queries to find out correct data for testing. 
• Organized daily WebEx meetings with team members, team manager, business analyst and technical team for detailed discussion of the report. 
• Provided training to the onsite and offshore tester on tools and prepared document for training materials.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.
• Used PL/SQL programs for performance testing.
• Developed complex queries by joining different Dimensional tables to Fact tables and retrieved the data From EDM and validated the data against EDW.

Environment: Oracle SQL Developer, Cognos 8.4, ALM/HP Quality Center 11.0, JIRA, DataStage 8.5, Agile, Scrum method, JAVA, HTML, MS Office, MS SQL, Oracle, UNIX, Windows XP.

Confidential

QA Analyst

 Responsibilities:

• Analyzed the Business Requirements of the system. Worked with the development team to review project plans, requirements specification, design documents, and computer software.
• Examined and analyzed the business requirements to define the Test Plan and document the Test Cases in Quality Center.
• Created and executed test cases for DataStage jobs to upload master data to repository.
• Created Test Plan and Test Cases and executed automated test scripts.
• Interacted with various members of the team to discuss and resolve defects and their priorities.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the files.
• Involved in creating Test Matrix for various work streams for traceability purposes.
• Involved in writing Test cases for all the links and various data files based on ETL Mapping document.
• Performed Functional and Regression tests of enhancements using Mercury and Rational Tools.
• Designer for mappings and coding it using reusable mapplets using from various sources involving flat files and DB2 tables.
• Worked with DataStage tool as ETL for loading and transforming the data to test various jobs.
• Scheduling the session’s tasks comprising of different mappings in order to load data into DB2 database Tables.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Tested and maintained the universe and reports
• Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP.
• Using Import Wizard deploying the reports from Dev system to QA box.
• Used Sets, Metrics, Productive Analysis and Enterprise Performance Management (Scorecard and Dashboard).

Environment: Quality Center 10.0, QTP, MS SQL Server 2008, Oracle 10g, UNIX, Windows 2000/XP, DataStage 8.1, MS Visio, IBM DB2/400, IBM AS/400, Teradata 12.0

 ETL/QA Analyst

• Analyzed the Business Requirements of the system. Worked with the development team to review project plans, requirements specification, design documents, and computer software.
• Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Used UNIX to verify the session log files for error and warning details.
• Executed the Test Scripts in TOAD and documented the results in RTM.
• Imported data from tables in one schema to CSV files and exported to tables from another schema using SQL* Loader.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Responsible for testing Business Reports developed by Business Objects XIR2
• The reports that were created in Business Objects were testing by running the SQL statements
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Compared query result sets from different database systems using UNIX diff command.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.
• Used PL/SQL programs for performance testing.
• Developed complex queries by joining different Dimensional tables to Fact tables and retrieved the data From EDM and validated the data against EDW.
• Implemented data verification procedures for ETL processes in load testing.
• Used SQL and PL/SQL scripts to perform backend database testing.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings, Generated the detailed reports

Environment: Informatica 7.1, Business Objects XIR2, SQL, PL/SQL, DB2, PL/SQL, UNIX Shell Scripting, Toad, Oracle, XML, Autosys, TSO, JCL, VSS, Windows

QA ANALYST

Responsibilities:

• Analyzed the Business Requirements of the system.
• Excellent knowledge of Software Testing Life Cycle (STLC).
• Involved in Designing and preparation of Test plan and Test Cases.
• Creating Test Plan and Test Cases and executing automated test scripts
• Performed Backend Testing by using SQL Queries for the purpose of database integrity
• Performed Smoke test, System test, Functional, Integration, End to End, User Acceptance testing and Regression testing activities in Test environment and Production support environment.
• Preparing Requirement Traceability Matrix for test cases.
• Very Good in Test Execution Process, Defect Life Cycle
• Detecting bugs & classifying them based on severity, priority.
• Generated Test data for various types of testing like valid data and invalid data.
• As a Business analyst, the lead role was taken in assisting with the business case, planning and monitoring, organizing requirements, translating and simplifying the requirements.
• Run automated test script in QTP.
• Extensively Performed database testing and access database using SQL Queries/procedures.
• Automated the test cases using QTP for Regression Testing and verify results of all re-tested cases.
• Prepared Test Summary Report and Requirement Traceability Metrics Document.
• Stored, analyzed and proritized defects that were identified during the test execution into QC.
• Extensively performed Database testing in Toad and access database using SQL queries.
• Involved in Requirements analysis along with clients.
• Perform testing for multiple applications with complex interfaces on varying platforms including web and Intranet applications.

Environment: Quality Center, QTP, ASP.NET, HTML, Java, SQL Server, UNIX, Windows, Oracle.