SUMMARY:

• Over 6 years in Quality Assurance and Testing which includes significant experience in testing Web and Client/Server applications using both manual and automation tools.
• Skilled professional experience in ETL Testing, developing Test Plans, Test Cases, RTM’s, Test Report documents.
• Complete working knowledge of SDLC and STLC lifecycle models in Agile and Waterfall methodologies.
• Solid experience in automated - testing tools like Quick Test Pro, Quality Center.
• Professional experience in Unit testing, Integration, Functional, Regression, White Box and Black Box testing.
• Experience in testing application developed in Java, J2EE, VB.net.
• Worked in Banking areas such as Deposits, Customer Servicing Channels, eCoupon and IVR and Healthcare areas like Enrollment, Benefits, Claims, Medicare.
• Professional experience working in UNIX environments, writing SQL and DB validations. Experience in ETL testing for Data completeness and Data accuracy.
• Good experience in UAT which includes preparing the Test Plan, Coordinating with multiple users in assigning the UAT tasks on day to day basis, collecting and computing the results and reporting them to the customer.
• Strong experience in testing Banking, Insurance, Credit Bureau applications.
• Proficient problem-solver in envisioning business and technical perspectives and develop workable solutions.
• Demonstrated ability to succeed and learn quickly in challenging environment.

TECHNICAL SKILLS:

Automation Tools: Quick Test Pro 10

Project Management Tools: JIRA, Version One, Team Track, Quality Center 9.1

CM Tools: ITSM, Perforce, PVCS,TFS

SQL and PLSQL Tools: SQL Server Management, Oracle SQL Developer 3.0.4, DB Navigator, Toad.

Database: SQL Server 2008, Oracle 10g & 11g,Teradata

Languages: C, C#, SQL, VB Script

UNIX Tools: Putty, Cygwin, MS Tools MS Office Suite

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, OH

DW/ETL Tester

Responsibilities:

• Data Loads from Source to target through ETL Tool Informatica, and Autosys cheduler tool.
• Data Validations includes File Validations, Table Validations, DDL Validations in Database and Unix
• Carried out Test Execution in different cycles of Integration, System, Sanity
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Strong in writing complex SQL queries to profile and analyze the data.
• Used SQL queries & Join operations to Test database tables.
• Executed the developed Test Cases and Test Plans and also coordinate with the development team to run the workflows if needed and write the SQL scripts to test the test cases.
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Capturing results
• Preparation and Execution of Test Plans, Test Cases for the mappings developed through the ETL Informatica tool in the QA environment
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• IST and UAT Sign off handling.
• Worked on defect reporting
• Participated in offshore calls on daily development activities and coordinate with the developers and QA in there day to day testing efforts.

Tools: Teradata, DB2, Informatica, Autosys, UNIX.

Confidential, Dublin, OH

DW Test Engineer

Responsibilities:

• Worked on testing Datamarts, eCoupon and IVR and some parts of TDM
• Developed test cases in HP Quality center and associated them with Test Plan and Test set for traceability and progress.
• Setup test data before each execution and data cleansing.
• SQL queries used to validate source data versus data in the data warehouse including identification of duplicate records
• Writing QTP scripts for Database validations and saving results and same to be used for later rounds of comparison with new builds.
• Carried out Test Execution in different cycles of Smoke, System, Regression and Re-Testing
• Designed testing approach for ETL process for Sales Data Mart and Inventory data mart and ensure consistent and effective communication among all parties.
• Handled Test design reviews prepared by offshore, Supporting with critical path SQL queries.
• Worked on defect reporting and represented testing team in defect triage meetings.
• Participate in root cause analysis of defects and preparing processes to reduce the impact going forward.
• Escalating issues to Test Manager as appropriate and needed for quicker resolution
• Raise requests and coordinate activities with external groups as required for test environment.
• Sending daily, weekly status report to the management
• Followed continuous integration model for repeated testing for every automatic build performed by the build server.
• Participated in daily scrum meetings to update and discuss issues and resolution and give status updates
• Participated in offshore calls on daily development activities and coordinate with the developers and QA in there day to day testing efforts.

Tools: HP Quality Center, Database - Teradata.

Confidential, Dublin, OH

DW Test Analyst

Responsibilities:

• Worked on testing Credit, Channel and Deposit Datamarts, corresponding ICDW Staging Tables and Views and tables in the ICDW Lightly Modeled Layer
• Developed test cases in HP Quality center and associated them with Test Plan and Test set for traceability and progress.
• Setup test data before each execution and data cleansing.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Writing QTP scripts for Database validations and saving results and same to be used for later rounds of comparison with new builds.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Carried out Test Execution in different cycles of Smoke, System, Regression and Re-Testing
• Handled Test design reviews prepared by offshore, Supporting with critical path SQL queries.
• Worked on defect reporting and represented testing team in defect triage meetings.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Participate in root cause analysis of defects and preparing processes to reduce the impact going forward.
• Escalating issues to Test Manager as appropriate and needed for quicker resolution.
• Raise requests and coordinate activities with external groups as required for test environment.
• Sending daily, weekly status report to the management
• Followed continuous integration model for repeated testing for every automatic build performed by the build server.
• Participated in daily scrum meetings to update and discuss issues and resolution and give status updates
• Participated in offshore calls on daily development activities and coordinate with the developers and QA in there day to day testing efforts.

Tools: HP Quality Center, Database - Teradata

Confidential

ETL Test Engineer

Responsibilities:

• Participate in complete life cycle of the project from Iteration 0 to till production in Agile framework
• Participate in scrum meetings and provide/update the status and issues.
• Work closely with Dev and BA’s in understanding the logic and troubleshooting issues.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the messages published by ETL tool and data loaded into various databases
• Developing Automation test scripts in QTP for regression test suits AMCAS Reengineering project.
• Participate in daily scrum meetings and discuss issues and resolutions with PM and BA’s
• Served as a resource for analytical services utilizing SQL Server, Oracle, and SQL Developer.
• Prepare Test Plan, Risk Assessment, Entry and Exit Criteria documents, Final Test Report document.
• Raise requests and coordinate activities with external groups as required for test environment setup, test data setup and test execution.
• Preparing RTMS(Requirements Traceability Matrix) and Test Plans from SRS (System Requirements Specifications)and BRS(Business requirement specifications)
• Write SQL queries for data validation.
• Managing and maintaining QTP scripts and Object Repository.

TOOLS: QTP v10.0, Quality Center v9.2, Version One

SQL Developer

Confidential

Responsibilities:

• Participate in daily scrum meetings and update and discuss issues and resolution on the User stories assigned and give status update.
• Participate in offshore calls on daily development activities and coordinate with the developers and QA in there day to day testing efforts
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Develop test cases in Rally for each user story and associate them with Test Plan and Test set for traceability and progress.
• ETL Testing: analyzing the data from PDM and writing SQL queries based on transformation rules and compare against the target data.
• Developed Test cases for Claims Stream where data it acquired from various sources like Boeing, Behavior Health, SC and FACETS.
• Loading the extracts from these sources to QA environment and executing the test cases.
• Involved in ICD 9 codes conversion to ICD 10 codes and validated on the backend.
• Worked on verifying new tables in DB added to the ACORS Database and validated Masking feature PII (Personal Identifying Information) PHI (Personal Health Information)
• Performed UI validation on Clinical Care Advance and SSRS Reporting based on the data extracted from FACETS..
• Implemented data driven framework for regression testing and used MS excel as the data store.
• Performed integration testing by extracting the data from FACETS and applying it to various units of ACORS UI and integrated in to Data Driven frame.
• Used apache Jmeter to perform load tests on the application with critical functionalities and monitored the execution for any outages to be reported.
• Followed continues integration model for repeated testing for every automatic build performed by the build server.

TOOLS: Oracle, Toad, Rally, CCA, SSRS.

Confidential

QA Test Engineer

Responsibilities:

• Played key role as liaison between Business analyst and QA team on various fronts.
• Object repository and Test Data Management for QTP scripts
• Preparing Traceability Requirements Matrix(RTMs) and Defect Tracking Matrix
• Developed Combo and Robust scenarios for various functionalities.
• Responsible for the coordination of daily cross team bug reviews. As, well as feedback to the QA team relating to their bugs.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Responsible for logging in the requirements in Quality Center and trace them to test cases and test scenarios.
• Determine test strategies based on requirements and architecture.
• Managing and maintaining QTP scripts and Object Repository.
• Creating the scripts and modifying them accordingly to cover the requirements
• Performed end to end functional testing on Adding a Vehicle, Adding Driver.
• Performed full Regression on Claims, Counsellor Services.

TOOLS: QTP, Version One, JIRA, TOAD.