EXPERIENCE SUMMARY:

• Over 5 years of Professional experience in Information Technology with extensive experience in performing manual, Data warehouse and automated testing of client - server and web applications for major companies worldwide.
• Experienced in Design, Development and System Testing & Implementing product with zero defects.
• Experience in working in white box, black box and gray box testing.
• Excellent team player to work in conjunction with team of testers, developers and BA members in testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.
• Expertise in analyzing Business Specifications and develop Test Plans, Test Cases and Test Scripts and execute them.
• Extensive experience in Unit, Functional, Integration, Regression, User Acceptance, System Testing.
• Experience in writing Test Cases for ETL to compare Source and Target database systems.
• Proficient in Manual, Database Testing and exposure to Automation Testing with ability to manage, record and play functions based on the automation needs.
• Experienced in different phases of Software development Life cycle including Strategic Systems Planning Designing, Programming, Testing, Documentation, and Presentation to clients and preparing customer specifications as part of software technical requirements and Customer support
• Good expertise in the review and documentation of system test plans, creating and executing test scripts, test cases and data sets on the basis of product release features requirements and  technical documents
• Experience in using Automation testing Tools Quick Test Professional (QTP), and Microsoft Visual Studio and TFS.
• Ability to interact with developers and product analysts regarding Testing Status and Defect & Change Tracking using Quality Center.
• Extensive experience in bug tracking tools like Rational Clear Quest and Quality Center.
• Excellent logical and analytical abilities for understanding and developing system workflows, computing and verifying Software Metrics and well suited for communicating with both technical and non-technical professionals
• Expert in Manual Testing and Automated Testing applications developed on windows Environment.
• Good knowledge of identifying various test scenarios. Holds strong ability to handle multiple tasks and prioritize it.
• Experienced in working with software development team in resolving defects, presenting the defect status reports, resolving requirement.
• Execution of Manual Test Scripts and responsible to track and log the defects using Quality Center.
• Strong analytical, communication & documentation skills.
• Exceptional ability to quickly master new concepts, very co-operative team player, fluent communicational skills, and interpersonal skills, innovative and self-motivated.

TECHNICAL SKILLS:

Operating Systems: Windows 7, 98, 2000, XP, VISTA, UNIX

Testing Tools: Application Lifecycle Management, Quick Test Professional 10.0, Quality Center, JIRA, Confluence, TestRail

Databases: MS-SQL Server, Teradata, oracel

ETL Tools: Cognos 10, Informatica 9.1, SSIS

Languages: C, SQL, PL/SQL, SAS, XML, VB, Mainframes

Applications: Web Based, Client/Server

Miscellaneous: MS Outlook, MS-Office Suite and Visio.

Methodologies: Waterfall, Software Development Life Cycle (SDLC), Agile

Defect Tracking Tools : Bugzilla, Test Director, Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX 

Software Quality Assurance (SQA) Engineer

Responsibilities:

• Using Test Rail to create test plans and Test runs  (integration, functional, security, performance and regression)
• Consulted for an Electronic Data Interchange (EDI) Exchange, testing and upgrade to a medical data system.
• Talking to Business Analysts to understand the requirements and coming up with the test strategies
• Writing Store Procedures in Microsoft SQL server management studio for simplifying the flows.
• Executed complex back end logic test cases, setup test data and wrote SQL queries
• Scheduling daily SSIS jobs and making sure they run and the daily data is captured in appropriate tables
• Created Test Cases and scenarios for Unit, Regression, Integration as well as Back - end and System testing.
• User Interface Testing the front end interface that is accessible by Pharmacy users.
• Bug Tracking and reporting in JIRA
• Documenting the best known methods in Confluence.
• Interacted with developers, users and management to speed up the defect resolution.
• Validate and test the following reports that are sent to Third Party Administrators (TPA/PBM): Replenishments, Invoices, Reversals, Remediation.
• Understand the concepts for Claims (B1), Claim reversals (B2), Claim Approvals, Rejections and to populate a new table for Pending balance for each specific accounts.

Environment: Microsoft SQL Server, JIRA, Confluence, Test Rail, SSIS, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.

Confidential, Eden Prairie, MN

ETL QA Analyst

Responsibilities:

• Setup Testing Suite for the project.
• Create and maintain folder structure in ALM ( Application Lifecycle Management ).
• Participated in talent acquisition and resource management on the QA team
• Created Test Plan and Test Strategy documents for the project.
• Written Test Cases for ETL to compare Source and Target database systems .
• Responsible for training the project team and Users on required tools.
• Worked with the Subject Matter Experts to understand and analyze impacts of various data acquisitions.
• Responsible for reviewing Use cases with the Business Analysts and align the test scenarios accordingly.
• Reviewed Test Cases prepared by other QA team members.
• Created the reporting module in ALM to reflect test progress, defect tracking etc.
• Created test scripts for database and report testing.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules. 
• Performed cubes validation for reporting based on the technical specifications document.
• Reviewed test scripts ( SQL ) and assisted the team on test script tuning.
• Co-ordinated testing activities between onsite and offshore teams for handshakes on a day to day basis.
• Conducted Defect Triage calls to review and track down defects for each release.
• Responsible for leading efforts on UAT and to coordinate between the Users and the Design / Development teams on issues during UAT.
• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping. 
• Responsible for creating and maintaining QA documents on SharePoint for the project.
• Facilitate QA meetings with the business and source owners to mitigate risks and resolve issues.
• Organize daily triage calls with the testing team and the development teams to facilitate progress review, defect discussion and issue resolutions.
• Facilitated UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.

Environment: Informatica 9.1, SSIS, Teradata TD 12, SQL Server 2008, Cognos 10, Flat Files, Teradata SQL Assistant, TOAD, SQL, PL/SQL, HP Application Lifecycle Management ( ALM 11 ), QTP, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.

Confidential, Reston, VA

ETL Tester

Responsibilities:

• Prepared Test Plans, Test Strategies, and Test Scenarios for ETL and Reports testing.
• Performed Smoke Testing, GUI Testing, Functional Testing, Backend Testing, System Integration Testing, Sanity Testing, and User Acceptance Testing (UAT).
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements. 
• Used Informatica workflow manager to run the workflows and workflow monitor to check the status of workflows.
• Developed test plan with testing scenarios from the end user perspective for User Acceptance Testing (UAT).
• Worked on data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing). 
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Debugging and Scheduling ETL workflows/Mappings and monitoring error logs.
• Involved in validating the data moving from source to target using Informatica data validation option.
• Involved in day to day SCRUM in an agile environment meetings both on site and off shore teams providing the day to day updates on the testing schedules.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Used Rational Clear Quest as defect tracking tool. 
• Before the Load is accepted to test, have performed smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Done data validation for the Cognos reports.

Environment: Oracle 11g, Informatica Power Center 9.1, Informatica Data Validation Option (DVO), Clear Case, Clear Quest, Cognos 10, SQL, PL/SQL, UNIX, Putty, TFS, Flat files, XML, XSD, XSLT, Quality Center, Web Services, Soap UI, Agile, SQL Server 2008, DB2, Rapid SQL

Confidential

QA Analyst

Responsibilities:

• Analyzing and Understand the software Requirement Specifications and development of Test Scenarios.
• Involved in Test Case Preparation and Test Case Execution Manually.
• Successfully implemented HP ALM ( Quality Center 11 ) for Test Planning, Test Case writing, Test Execution and Requirement Mapping with Test Cases.
• Performed white box testing on various front end applications.
• Analyzed application to find out which part can be automated and which can be manually tested.
• Created Test Cases and scenarios for Unit, Regression, Integration as well as Back - end and System testing.
• Performed Positive and Negative testing using valid and Invalid data on Development, Test Database Environments on MS Access and SQL Server.
• Performed web services testing manually.
• Validated web applications against XMLs as part of testing.
• Interacted with developers, users and management to speed up the defect resolution.
• Wrote SQL statements to extract data from Tables.
• Performed front end and back end validations using SQL.
• Defect tracking and reporting using Quality Center.
• Determining the Entry and Exit Criteria for different phases in testing cycle of the application.
• Database Validation (SQL) to check the updated data in the Database using Toad (Data Query Tool).
• Performed User Acceptance Testing on behalf of End Users at client’s environment.
• Participated in Project Meetings, Conducted Knowledge Sharing Sessions and Training to End Users

Environment: Quick Test Professional 10.0, Oracle database, Quality Center 9.2, Windows 2000,SQL, VB Script, HTML, MS Excel, XML, MS SQL SERVER.