SUMMARY:

• Over 5 + years of rich experience in IT Industry in Data Warehousing and Integration Projects, Performance Testing, Automation and Database Applications using ETL tools.
• Experience in Data Warehouse applications testing using Informatica Power Center on multiple platforms. Reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools. Overseeing Test Data Management, creating test data suite, tracking the results and using for regression testing.
• Experienced in data warehouse development works involving data migration, data conversion, and ETL operations using Power Center 6.2/5.1.
• Fine - tuning SQL overrides for performance Enhancements.
• Developing complicated SQL script for Data validation testing by running SQL script, procedures.
• Participating in all aspects of SDLC; build and execute test suite using Microsoft Test Manager (MTM). Proficiency in SQL and experience in Performance Tuning of SQL and Stored Procedures.
• Working on Performance Tuning of mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Knowledge in Unit Testing, System testing, Integration, Regression, End to End Testing.
• Estimating and preparing schedule for different phases of Test cycle.
• Handing Critical Defects and Production Related Defects. Knowledge of UNIX Utilities, Shell Script to automate process. Using ETL tools like Informatics, SSIS, Ab Initio and Data stage.
• Testing business reports developed in Cognos. Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
• Providing Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Assisted in creation of Test plan documents with the lead and created numerous test scripts and test case documents and Traceability matrices.
• Assisted with Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant.
• Served as the liaison between the offshore team and the onsite QA team.
• Communicated the requirements and helped the offshore team in understanding the requirements and arranged meetings with the business analysts.
• Scheduled the jobs using Autosys and automated the jobs to be run at specific time and automated the reports.

PROFESSIONAL EXPERIENCE:

QA Coordinator/Manual Tester

Confidential - Post Falls, ID

Responsibilities:

• Analyzed system requirements and developed detailed Test Plan, Test cases.
• Responsible for creating Test Strategy document(s), Test Plan(s), Testing Tracker(s), Test Execution Status Reports, and Defect Reports.
• Coordinate the testing activities across the project/program and engage all testing parties
• Hold testing kickoff meetings and meet with all project stakeholders
• Ensure ambiguity reviews are completed either as part of the agile process or through a formal review, confirming any ambiguities identified are appropriately assigned and resolved
• Facilitate the development of test plans, by test planners, across all areas and bundling into comprehensive test plan package with end to end coverage confirmed
• Facilitate the development of appropriate test cases, scenarios and scripts by test planners/testers and support test data, test IDs and test environment requirements
• Identify testing dependencies & risks with requirements, scope, and application availability as well as understanding dependencies between testing teams
• Review testing results summary certification and driving the approvals process
• Conducted Functionality, Security Testing
• Worked with iterative development environment using Waterfall Model.
• Participated in reviews, high level design walk through and evaluations of the application at all stages of SDLC.
• Performed smoke, functionality, integration, end-to-end, system, regression and user acceptance testing and documented the test results.
• Used UNIX to verify the session log files for error and warning details.
• Involved in preparing test data for UAT and participated in UAT signoff
• Managed the testing process, bug reporting, test results, track the progress of the testing, and provide daily status to test lead / project manager.
• Worked on Waterfall, and Agile methodologies
• Developed test harness for Web Services automated testing by means of SOAP UI
• Logged defects using Quality Center, linked defects with requirements and generated defect reports in Quality Center.
• Verify the invoices for payment with Mobility and Tax vendors as it relates to global Mobility programs.
• Developed Test Cases and Test Scripts for System and UAT Testing
• Interacting with Developers to discuss about the requirements/status of the defects.
• Involved in gathering test Data for User Acceptance Testing and executed the same.
• Developed SQL statements to query the database for consistency of data, data quality, and data storage and data retrieval.
• Worked on issues with migration from development to testing and testing to UAT environments.
• Interacted with Development teams to ensure overall quality of the software
• Investigated software bugs and interacted with developers to resolve technical issues.
• Extensively involved in Functional and regression testing.
• Timely and efficient entering, tracking, maintaining and updating defect logs in Quality Center.
• Involved in writing the UNIX scripts and UNIX commands and validate the log files in UNIX environment.

Environment: Agile, HP Quality Center, Waterfall, HTML & DHTML, UAT, SOAP UI, Windows, UNIX, SQL Server, Skype, Lync and WebEx

UAT/ETL Tester

Confidential - Idaho Falls, ID

Responsibilities:

• Tested SQL scripts to validate the data and performance of the database.
• Validate the data of Metadata.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Tested the reports generated by OBIEE and verified and validated the reports using SQL.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications.
• Conditional testing of constraints based on the business rules.
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in HP Quality Center with Pass/Fail/Blocked status.
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Compared query result sets from different database systems using UNIX diff command.
• Preventing occurrences of multiple runs by flagging processed dates.
• Written Test Cases for ETL to compare Source and Target database systems.
• Ran the Job/batch in Autosys.
• Execute the Autosys batch process to test the data quality, data accuracy and data complexness on the tables and files.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center.
• Maintained the Control and Data file in Winscp.
• Dashboard (Tableau) Visualization for end user requirements.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Identifying duplicate records in the Tableau staging area before data gets processed.
• Extensively written test scripts for back-end validations.

Environment: Metadata, Informatica 9, SOAP UI, Tableau, Quality Center, MS SQL Server 2008, Oracle 11g, SQL, IBM DB2, Agile, Teradata 12.0, Autosys, UNIX, Windows XP/2000 and Winscp.

Confidential - Eagan, MN

SeleniumTester

Responsibilities:

• Developed test automation in an Agile development environment using a Test-Driven Development (TDD) approach.
• Developed on the test automation framework for 6 corporate e-Commerce Web and Mobile applications: Williams-Sonoma, Pottery Barn, PB Kids, PB Teen, Mark & Graham, and West Elm.
• Built out the automated testing framework using Selenium 1.0 and 2.0 (WebDriver), Java, TestNG, JUnit, Maven, XML, SQL, and JavaScript.
• Created automated scripts for CCT API WSDLs using VU generator in LoadRunner (webservices protocol) for regression scenarios.
• Created reusable function library that can be used across various scripts for provisioning GUI and API/XMLs
• Used an Object-Oriented (OO) approach to design and develop automated tests in Java, which included inheritance, composition, polymorphism, and page objects.
• Committed framework source code to repository in Subversion (SVN).
• Documented processes and procedures on the Wiki and SharePoint portals.
• Configured Bamboo jobs to build and run Selenium tests from Maven and TestNG in a Continuous Integration (CI) environment on the Grid and Sauce Labs Cloud.
• Developed XML GUI maps using CSS selectors, XPath, and IDs to locate Web page elements.
• Data-driven parameterized tests using multiple data sources, such as XML data files and SQL queries to access Oracle databases.
• Pass JavaScript to Selenium to read dynamic Web page content.
• Track test failures and defects by build in JIRA and Bamboo.
• Configured the test lab machines for Internet Explorer, Firefox, Chrome, and Safari on Windows and Mac OS X.
• Configured test profiles for Firefox and Selenium.
• Met with Development regularly to collaborate on processes and standards to improve automation.
• Prepare UI and low level automated test suites from application specifications.
• Coordinate the successful integration and operation of "White Box" test suite.
• Perform tests to validate code implementation, security functionality, and to uncover exploitable vulnerabilities.
• Methods of test design included: data flow, control flow, information flow, coding practices, exception and error handling, branch testing, and path testing.
• Performed "Black Box" testing to ensure application functionality of created and executed test scripts and test cases.
• Work with Business Analysts to cover gaps in Business Requirements, User Stories, Use Cases, and UX Design.
• Crafted large test plans, designs, test cases, and large data sets.
• Reviewed and audited test cases, and documented and establish QA best practices and processes.
• Worked closely with Developers to guide them in a quality centric approach to development.

Environment: Jira, Selenium, Use Cases, Black Box, Oracle, UNIX, Lync, Windows and SDLC

Manual Tester

Confidential - Charlotte, NC

Responsibilities:

• Performed manual testing using the test cases for positive and negative testing.
• Created Test Plan and developed a test suite for testing purpose.
• Supported BA and Business Users during UAT phase.
• Involved in Agile development methodology.
• Defect Tracking and Bug Reporting was performed using Quality Center.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans.
• Reviewed Test assignments and executed test cases as assigned.
• Performed UAT testing.
• Created Test Cases, Test Scenarios in Quality Center ensured traceability to Business Use Cases and according to application.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Performed extensive Data Integrity testing by executing SQL Statements on Oracle & SQL database.
• Executing the Test cases for the mini regression and full regression testing.
• Supported the business team during User Acceptance Testing.
• Involved in Smoke, Functional, Integration, System, Regression, UAT Test Execution and Management.
• Prepared the Test Plan and Testing Strategies for Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Extracted data from various sources like Oracle, flat files and SQL Server.

Environment: Quality Center 9.0, A, UNIX, Oracle, Series, Oracle8i, SQL Server 2000, Windows 2000, HP ALM, JIRA

ETL/Cognos QA Tester

Confidential - Austin, TX

Responsibilities:

• Extensively involved in business analysis and requirements gathering.
• Loading Flat file Data into Teradata tables using UNIX Shell scripts.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatics Workflow Manager.
• Tested data feeds from XML to Database.
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Planned and conducted OBIEE report tests for wide variety of applications.
• Tested -reports, Dashboards and other functionality within the OBIEE suite.
• Tested the reports generated by OBIEE and verified and validated the reports using SQL.
• Used OBIEE DAC to run the data load jobs.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested several Informatica Mappings to validate the business conditions.
• Performed data validation testing after the ETL process using Informatica.
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications.
• Conditional testing of constraints based on the business rules.
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in HP Quality Center with Pass/Fail/Blocked status.
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Compared query result sets from different database systems using UNIX diff command.
• Preventing occurrences of multiple runs by flagging processed dates.
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Identifying duplicate records in the staging area before data gets processed.
• Extensively written test scripts for back-end validations.

Environment: Cognos, Informatica 9.1,ALM/HP Quality Center 11.0, MS SQL Server 2008, Oracle 11g, SQL, IBM DB2, SQL,UNIX, Windows XP/2000

Manual Tester

Confidential

Responsibilities:

• Analyzed the use cases given by the business analysts and developed test cases using them.
• Created test cases to test Web Application.
• Gathered specifications and requirements to develop test plans and to create test cases using QC.
• Responsible for complete manual testing of application under test (UAT).
• Maintained Test Logs and Reports in Quality Center.
• Written complex SQL queries for data validation and to verify the extract rules.
• Performed black box/functional testing, regression testing on Application under Test.
• Wrote and executed SQL Queries for Data validation.
• Generates functional test cases that capture actual code behavior as a deployed application is exercised.
• Performed database integrity check using SQL.
• Written complex SQL queries for data validation and to verify the extract rules.
• Did extensive backend testing using SQL, UNIX and PL/SQL.
• Written complex SQL queries for data validation and data verification.
• Executes the test suite to identify regressions and unexpected side effects.
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources).
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, UAT and Regression testing.

Environment: Quality Center, SQL, PL/SQL, Windows NT, Shell Scripting, MS-Office Tools, XML, XSLT, Web Services, SOAP, Manual Testing, Test Director