SUMMARY

• Solutions oriented IT professional with 7 years of experience in testing various software applications like ETL process, Business Intelligence Reports, Web services, Client-Server applications and Web based applications
• Extensively worked in entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.
• Strong knowledge of Software Development Life Cycle SDLC , Software Testing Life Cycle STLC and QA Methodologies like Agile, Scrum, Waterfall, and Iterative process.
• Involved in preparing the Test Plans, Test Strategy documents, Test Cases Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing SIT , Software Validation testing, UAT, Batch Testing, Interface testing, and Performance Testing.
• Involved in preparation of Requirement Traceability Matrix RTM , Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents, Test Summary Reports.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in corporate-wide-ETL solutions using Informatica and DataStage.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Extensive experience in writing complex SQL Queries and PL/SQL scripts.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects, Micro Strategy including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in test management using HP Quality Center, Microsoft TFS and maintained Versioned objects using Rational Clear Case.
• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking bugs using HP Quality Center, Rational Clear Quest, Bugzilla.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Extensively worked on Batch scheduling tools Autosys, Control-M to run and monitor ETL jobs.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SUMMARY

PROFESSIONAL SUMMARY

Confidential

Sr.QA Analyst

Responsibilities:

• Analyzed the business requirements and Test Strategy documents.
• Involved in different phases of Project Life Cycle and Documentation.
• Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing .
• Involved in writing the test plan, test cases, and test scripts by analyzing the functional requirement document, mapping documents in QC.
• Involved in writing and execution of the various test cases and test scripts created for different test scenarios.
• Exported the test cases from MS Excel to QC
• Prepared Test Cases for the mappings developed through the ETL Informatica tool and executed those Test Cases.
• Worked with Business Analysts, Developers, and participate in the product design process including specification and other document reviews.
• Involved in testing the Business Objects reports by writing complex SQL queries.
• Logged defects in QC, tracked defects and created standard defect reports.
• Performed manual testing for checking Functionality during the various phases of the development of the application.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Performed Black Box testing, Ad hoc Testing, Smoke testing, Functional Testing, Integration Testing and Regression Testing in testing environment.
• Submitted and validated transactions for home loan mortgage
• Validated the customer data for loan applications on both UI screens and back end as well.
• Wrote SQL queries to insert and retrieve test data from database in a test script while running test cases.
• Documented the test scripts and generated the reports in Quality Center.
• Used Quality Center for generating Requirements, test plan, and test sets and for reporting defects.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of
• Worked closely with business analysts and developers to discuss the design and testing aspects of the applications.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Used putty to run the autosys job.

Environment: pl/sql,sql,informatica,ETL, SQL queries, Quality Center ,UI, MS Excel,Windows XP, Business Objects XI 3.1,XML,XSLT, Windows XP/NT.

Confidential

Sr.QA Analyst

Responsibilities:

• Created a test plan, test cases, test scripts by analyzing the Functional design document and Data Validation Document in HP Quality Center
• Performed Black box testing, Ad hoc testing, Smoke testing, Functional testing, Integration testing, Regression testing in Testing environment
• Verified data load, transformation into data warehouse without any data loss or truncation as prescribed and expected time frames to confirm improved performance and scalability.
• Responsible for testing Initial and daily loads of ETL jobs
• Participated in the creation, distribution and walkthrough of test cases, scripts and corresponding testing activities ensuring deliverables are conducted/ produced in compliance with company standards.
• Involved with ETL test data creation for all the ETL mapping rules
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Involved in extensive DATA validation using PL/SQL queries and back-end testing.
• Created SQL compare statements to validate Actual result with the Expected Results.
• Extensively used Informatica Workflow Manager to run the workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Created Query Pairs, scheduled and automated test Suite for execution for Regression Testing using Query Surge.
• Created and Exported high-level test summary reports to lower-level, detailed reports as Excel and PDF files and archived for future audit needs
• Created the test data for the positive and negative testing for functional, integration and regression testing.
• Reviewed the test cases with the business analyst and developer, Involved in defect Triage meeting for the defect reviews and discussions with developer and teams.
• Participated in the application walk-through and meetings.
• Daily updates on Requirement Traceability Matrix.

Environment: Informatica 9.1, Oracle 11g, SQL, PL/SQL, Toad HP Quality Center 10, Query Surge, UNIX, Putty, XML, XSD, XSLT, WinSCP, Leech FTP, Windows XP/NT

Confidential

Sr.QA Analyst

Responsibilities:

• Participated in the creation, distribution and walkthrough of software test cases, scripts and other documents surrounding testing activities and ensure that all testing activities and deliverables are conducted/ produced in compliance with company standards.
• Used Telelogic DOORS as version control tool for tracking requirements.
• Involved in preparing RTM by link and sync process, mapping the test cases with the appropriate requirements in Quality Center.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Wrote scripts to upload data into database tables on IBM DB2 Command center.
• Prepared Test Cases for system testing and uploaded them into Quality Center Linked the test cases to the business requirements Defects to Test Cases.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server and Oracle to load into the Oracle data warehouse
• Used Teradata SQL Assistant utility to write various SQL and executed them in Interactive mode and Batch mode
• Have tested different Informatica transformations like Source Qualifier, Lookup connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Created SQL compare statements to validate Actual result with the Expected Results.
• Extensively used Informatica Workflow Manager to run the workflows.
• Used SQL Profiler to monitor the performance of SQL queries.
• Worked on the batch testing using the Test batch runner tool.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Tested ad hoc and canned reports for Business objects.
• Extensively involved in System testing Regression testing and Integration testing
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible in testing Initial and daily loads of ETL jobs.
• Executed automated test scripts using QTP for Regression testing.
• Excel reports are validated using SQL and embodying complex formulas in the Excel.
• Lead the team to review the Test Results for the Full System and Final System Test cycle.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Oracle 11g, IBM DB2 V8, Informatica Power Center 9.1, SQL, PL/SQL, DOORS, RapidSQL, HP Quality Center 10, QTP 10.0, Mainframes, Apache Tomcat, Putty, Toad, Business Objects XI 3.1,XML, XSD, XSLT, Windows XP/NT.

Confidential

QA Analyst

Responsibilities:

• Evaluated business requirements and technical specification documents to craft test strategies and LOE assessments which would account for durations, constraints, assumptions, etc. that are required to accomplish test objectives.
• Developed and conducted a wide range of tests and analysis to ensure that software, systems, and services meet minimum company standards and defined end-user and system requirements.
• Involved in high and detail level design reviews to ensure requirement traceability and to determine application/component functional readiness requirements.
• Linking Requirements from DOORS, to Test Scenarios in Quality Center.
• Being part of the test team, responsibilities involved writing complex queries using SQL and PL/SQL to generate data based on the complex derivations for each attribute.
• Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface.
• Involved in validating various BOXI reports for Lay out and data quality.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Executed UNIX Shell Scripts for Batch Job Execution.
• Responsible to test the functionality of Ab Initio graphs.
• Validating the data passed to downstream systems.
• Worked with the development team to create a suite of test data Input files, Expected results , that fully exercises data validation detecting, rejecting bad data to test ETL functionality properly processing .
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
• Involved in maintaining the test environments with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Tracked and executed the User Acceptance Test Cases with respect to the requirements to determine the feature coverage.
• Involved in testing the batch scheduling programs by using the Autosys tool.
• Responsible for preparing test cases and scenarios for System testing and UAT testing.
• Have worked in Technical Operations team for CDW ETLs execution support.
• Creating and maintaining repositories, source systems, target databases and developing strategies for ETL mechanisms using Ab Initio.
• Involved in creating various data scenarios Excel Sheets having expected data and validating them before and after running the respective Autosys batches.
• Developed UNIX scripts for file archiving, file transfers and file management.
• Involved in Database Validations, Writing Test scripts Including the related SQL Statements by joining various tables depending on Requirements for both Positive and Negative Scenarios.
• Involved in Security Access Testing for Role based Internal and External Users, on S/IR System
• Automating the Data and Validating in various builds, using QTP and Quality Center.
• Attended and worked with agile scrum standup meetings.

Environment: Ab Initio 2.14 GDE, Op> 1.14, EME, Oracle 10g, SQL, PL/SQL, Toad, Autosys, Business Objects XI 3 Reports, DOORS, Oracle SQL Developer, Quality Center 9.2, QTP 9.5, UNIX, Putty, XML, XSD, XSLT, WinSCP, Leech FTP, Windows XP/NT.

Confidential

QA Tester

Responsibilities:

• Developed ETL Test Plans, Test Strategies and Test Cases.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Extensive testing on the Performance of the Stored Procedures in PL/SQL.
• Developed UNIX shell scripts to format the session log files and to extract the information from error logs.
• Used Datastage director for running the DataStage jobs and validated them.
• Involved in testing ETL and PL/SQL batches scheduled by using Autosys
• Tested UI Screens and Reports for cosmetic and data requirements.
• Involved in Usability Testing and coordinating with end users for giving Training on Web Based application.
• Defined and implemented verification and validation processes across the project and manage QA and regression testing environments.
• Tested the web pages, user login pages according to the user security roles and requirements.
• Worked with business team to test the reports developed in Cognos.
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Tested OLAP cubes to verify and validate the functionality of the reports.
• Monitored the performance of the reports.

Environment: Ascential Datastage 7.5, Cognos 8.0, Oracle 9i, DB2, PL/SQL, Autosys, SQL Plus, Quality center 9.0, UNIX, Shell Scripting, IBM AIX 5.0, UNIX, Windows XP

Confidential

QA TESTER

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Responsible for review of Functional Requirement Specification and System Design Specification documents for testing
• Performed extensive manual testing on critical functionalities of the application.
• Involved in project requirements analysis, writing test specifications, formulating test plan, executing test cases keeping track of the defects logged Using Rational Clear Quest .
• Tested ETL Informatica mappings to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them in to Oracle.
• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Involved in testing the ETL mappings, by validating whether the mapping adhere to the development standards and naming conventions whether the mapping do what the technical design says it should do whether the mapping work correctly in relation to other processes in your data logistical flow.
• Written SQL queries to validate Business Objects reports according to the system requirements.
• Prepare defect reports and tracked the defects in Clear Quest

Environment: Informatica 7.1, Business Objects XIr2, Rational Clear Quest 8.0, Oracle 9i, SQL, PL/SQL, Oracle SQL Developer, Log Files, PuTTY, SQL Loader, TOAD, Flat files, Windows NT and UNIX

Confidential

QA TESTER

Responsibilities:

• Understanding the business process manage testing activities.
• Formulate the Test Strategy, Designing, System Plan and Validations.
• Involved in life cycle testing, functionality testing, regression testing, performance testing, volume testing.
• Written SQL/Shell scripts to perform data integrity testing and validation of logs.
• Performed system test following the standard guidelines provided in the design documents.
• Identified bottlenecks in the network and database servers while performing volume testing of the application.
• Done Cognos Reports testing which includes data validation and cosmetic validation.
• Created and Executed System Test cases and User Acceptance Test cases for the application.
• Interacted with developers for resolving Change Request issues.
• Tested the application manually for its GUI objects and their functionality and reported the bugs.
• Performed extensive manual testing of the entire application suite.
• Developed Test Data and individual test cases to satisfy positive and negative testing.

Environment: Oracle 8i 9i, SQL, Cognos 7.0, J2EE, Apache Tomcat, Manual testing, TOAD, PuTTY, WinSCP, Log files, JSP, XML, Visual Basic, ASP, VB.Net, ASP. Net, Windows, UNIX