PROFESSIONAL SUMMERY:

• Over 7 years of experience in Quality Assurance and Software Testing of various business applications in Client/Server, Web and in Data Warehousing solutions.
• Extensive knowledge of SDLC (Software Development Lifecycle) methodologies. Strong knowledge of all stages of Software Development Life cycle (SDLC).
• Experience in writing System Test Plans, defining Test Cases, developing and maintaining Test Scripts, Requirement Traceability Matrix and documenting all phases of QA Process.
• Experienced working with CMMI compliant projects to mitigate risks for product and service acquisition.
• Expertise in Relational Database Management System (RDBMS), and working experience in writing SQL queries using TOAD, SQL Developer, TeraData, DB2, SQL Server and Oracle database.
• Experience in Functional testing, System Testing, Regression testing, Compatibility Testing, Positive & Negative Testing, Smoke Testing, ETL / DWH Testing, GUI Testing, Sanity Testing, BI Report Testing, UAT Testing and Automation Testing.
• Experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Proficiency in HP/Mercury tools (Application Lifecycle Management/QC/QTP/UFT).
• Involved in running the Informatica work flows from Workflow Manager and verified the session logs from workflow monitor.
• Very good understanding of Data Warehousing concepts.
• Involved in validating the batch processes such as Informatica and UNIX Scripts scheduled using Autosys.
• Experience in Data Analysis, Data Validation and Verification, Data Conversion and Data Migrations.
• Experience use of UNIX commands.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center / ALM, SharePoint and JIRA.
• Manually conducted Functionality and GUI testing during the various phases of the development of the application manually.
• Experience in developing and executing SQL queries to validate Source - to-Target loading.
• Good exposure in using of QTP/UFT integrated environment (Step Generator, Synchronizations, Data Table, Actions, Parameterization, Recovery Scenarios, Regular Expressions, methods etc.)
• Developed Automation scripts in VBScript to automate most of the functional Test Cases, all common Application tasks, Error handling subroutines, Application state & features validation subroutines.
• Posses excellent knowledge in developing Data driven Test and User Defined Functions using QTP/ UFT.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers to identify and resolve issues.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNOLOGY SUMMERY:

Test Management Tools: Quality Center/ALM, JIRA.

Functional Testing Tools: Unified Functional Testing UFT/QTP

Languages: C, C++, .Net, Java, XML, HTML, Visual Basic 6.0.

DWH/BI Tools: Informatica Power Center

Databases: Oracle, SQL Server, SQL Developer, TOAD

Operating Systems: Windows, UNIX- Sun Solaris, HP-UX, AIX, Linux.

Defect Tracking Tools: Quality Center, JIRA, SharePoint

Other Tools: FileLoader, WinScp, FileNet, Microsoft Excel & Outlook.

PROFESSIONAL EXPERIENCE:

Confidential, Salt Lake City, UT

ETL/Datawarehouse/Report Tester

Responsibilities:

• Validated releases like Consumer/Construction, Commercial, and Deposit releases for Zions’ banking application.
• Reviewed Technical design documents, FRD, BRD and setup documents discussed with BA.
• Written Test plans and Test strategy documents according to the requirements.
• Tested the Front-end functionality of the application such as customers’ accounts, allocate loans and funds, collateral linkage, ticklers, follow ups, auditing, getting interests, testing regulators,..etc
• Developed Test Cases/Test Scripts and validated the scripts to make sure they have been executed correctly and meets the scenario description.
• Tested the ETL Informatica mappings and other ETL processes for check processing, payment and transfers for the Deposit releases.
• Validated data in DB2 for bank’s daily transaction storage by joining multiple tables using SQL.
• Developed SQL queries to test the data after executing transaction like deposit processing and check processing in batches.
• Supported the extraction, transformation and load process (ETL) for Data warehouse from different source systems to Target database using Informatica.
• Focused on transformation and data quality issues. Problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity from source to the Target.
• Written complex queries and scripts to validate the data moving from Source to Target.
• Written complex test cases for report testing, using multiple joins and defining tables from different data marts.
• Analyzed and tested Informatica mappings with OLTP Source data, staging, and target data
• Validated data for Change Data Capture (CDC 1, CDC 2) after an update.
• Validated Data warehouse DB2 tables using DB2 Visualizer.
• Written SQL to get the data from databases in required format from multiple table to compare against the data shown on reports.
• Wrote Test Cases for data validation for EDW - Data ware house (Source to Target) and Cognos Standard Reports ( OLAP and CUBES) after completion of EOD batches.
• Attended requirements and design meetings, Kickoff meetings, weekly status meetings, reviewed and analyzed requirements and design documentation.
• Generated project status reports thru ALM and responsible to report bugs using ALM and MS Excel and created Test lab and map the defects directly to the requirements in the ALM and run reports.
• Took part in meetings and reviews with the onsite and offshore project team to ensure that bugs are fixed and their status is updated.

Environment: Informatica 10, IDQ, Selenium, Oracle11g, DB2, DB2 Visualizer, Teradata, Cognos 10, Java, Microsoft Excel, XML, Flat Files, UNIX, TOAD, XNet, Sharepoint, FileNet, Autosys.

Confidential, Atlanta, GA

ETL/Backend Tester

Responsibilities:

• Executed tests and log results. Designed, Communicated, and enhanced QA testing plan for the application. Prepared and executed test cases manually for different modules.
• Manage the testing process, log and track defects using ALM
• Backend Testing for data validation after each process completed, to check that the process completed all business rules correctly
• Developed SQL queries to test the data after uploading vehicle, buyer, and saler information into Confidential databases.
• Participated in requirement analysis, kickoff meetings developed clearly defined Test Plan document and provided updates on work status in Weekly Status meetings.
• Conducted Black-box testing, functionality, GUI, and Regression Testing for the entire application for the various builds in a team environment
• Exporting and importing data into ORACLE Tables to perform database testing. Created complex SQL scripts and automate the Back-end testing. Worked in backend testing by executing SQL queries through TOAD
• Supported the extraction, transformation and load process (ETL) for Data warehouse from their Source database to the Target database using Informatica
• Analyzed and tested Informatica mappings with OLTP Source data, staging, and target data
• Monitored the session logs/ log files in Informatica workflow monitor
• Validated data moving from source to target using Informatica Data Validation Option (DVO). involved in testing Data Stage ETL jobs for the data quality and number of the records
• Involved in validating the initial loads and incremental loads according to functional specifications.
• Written complex queries and scripts to validate the data moving form Source to Target.
• Experienced in using Autosys for monitoring and designing scheduled jobs.
• Developed a clearly defined Test Plan to ensure the test scenarios will accomplish testing objectives.
• Attended requirements and design meetings, review and analysis of requirements and design documentation.
• Developed Test Cases/Test Scripts and validated the scripts to make sure they have been executed correctly and meets the scenario description.
• Used ALM and JIRA for defect tracking and creating reports.
• Performed manual, Automation testing for regression testing in all different Internet browsers (IE, Chrome, and Safari).
• Took part in meetings and reviews with the project team to ensure that bugs are fixed and their status is updated.
• Coordinated with the team in the validation environment for the UAT and assisted the business in UAT

Environment: J2EE, Windows NT/XP, IE, Firefox, Safari, Quality Center, Microsoft Excel, JIRA, QTP, MSOffice Suite, Toad, SQL Developer, Oracle 11g, UNIX, Linux, WinScp, SOAPUI, Informatica Power Center, XML

Confidential, Chicago, IL

Backend Tester/QA Analyst

Responsibilities:

• Involved in Analysis and Review of the Draft Use Cases provided by the Business Analysts for every Release.
• Involved in TDD (Technical Design Document) meetings with developers and BA’s from starting of the new release to know the prefect functionality of the project.
• Identified test scenarios, business flows, happy paths for regression and functional testing
• Wrote complex SQL queries using Joins and sub queries to properly pull the data from the database and to test for its display for a particular module
• Performed backend testing using SQL queries to make sure members, providers, facilities, information has been saved in the database correctly and able to retrieve correctly.
• Tested adding/updating/deleting of the providers, members, groups, facilities, and hospitals in Facets. Developed complex queries to verify enrollment using multiple joins.
• Worked on FACETS on module to validate the member eligibility and member enrollment for different plans.
• Tested application for Affordable Care Act and Healthcare Insurance Marketplace.
• Developed test cases, test scripts manually and also using automated tool Quick Test Professional.
• Prepared the test data for positive and negative testing used in data driven testing.
• Written and maintain test automation scripts using Mercury Interactive Quick Test Pro.
• Parameterized the test and performed the data-driven testing using Automation tool Quick Test Pro.
• Developed automation test scripts and reusable functions in UFT to automate smoke and regression testing.
• Performed black-box testing including regression, functional, and system testing Parameterized the scripts, handle errors and create checkpoints (GUI, text, bitmap) using Unified Functional Testing/UFT tool.
• Defects were tracked, reviewed, analyzed and compared using ALM/QC.
• Used to arrange meetings to discuss issues with developers and project managers. Worked very closely with developers to recreate defects found and also to verify fixes.
• Initiated and participated in Conference Calls, Walkthrough and Review Meetings and involved in supporting Production Releases.
• Written and reported defects using Quality Center. Verified fixes and closed during regression testing.
• Conducted system testing in the system test environment for the Benefit Module and LTC module to detect defects and ensure conformance with the requirements prior to code migration to CAT.
• Involved in Customer Acceptance Testing.
• Actively participated in enhancement meetings focused on making the application more effective.

Environment: Quality Center, UFT/QTP, SOUP UI, Microsoft Excel, Toad, UNIX, JAVA, J2EE, HTML, VBScript, SQL, ORACLE 9i, Teradata

Confidential, Moline, IL

QA Analyst

Responsibilities:

• Participated in entire Software Development Life Cycle (SDLC)
• Involved in writing Test cases, Test plans. Test cases would have the mapping for each of the business requirement in requirements document and test plan is to define the sequence of test case execution process.
• Involved in analyzing User requirements, identifying test cases and setting up test data.
• Performed Backend Testing to ensure data consistency on front end by developing and executing SQL Statements on SQL Developer.
• Developed SQL scripts to verify if each transaction has been saved accurately in the database..
• Developed complex queries by joining multiple tables to validate data for the Insurance policy, claim, agent and holder’s information.
• Performed System Testing, which includes functionality testing, compatibility, Backend Testing, GUI Testing, and Regression Testing.
• Performed database backend testing by field level validation in SQL to verify data integrity and consistency.
• Performed Crossbrowser testing on many different browsers like IE, Chrome, Firefox and Safari.
• Performed black-box testing including regression, functional, and system testing Parameterized the scripts, handle errors and create checkpoints (GUI, text, bitmap) using UFT/Quick Test Professional.
• Designed Automated VB Scripts by using Non-reusable Actions and Re-usable Actions
• Record and run tests using QTP functional Test Cases, all common Application tasks, Error handling subroutines, Application state & features validation subroutines
• Used Quality Center to log defects and monitored the defects for successful resolution.
• Generated weekly status reports to the team manager and attend the weekly status meeting with Technical team, Team managers, and Business analysts.

Environment: QTP/UFT, SOAP UI, Quality Center, Windows, SQL Server, SQL Developer, Oracle, UNIX, TOAD, IIS Server