SUMMARY:

• Over 6 years of experience in DWBI Testing, functional and database testing in Insurance domain.
• Experience in end - to-end DWBI testing including creation of test plan & test strategy, preparation of test estimates, test approach, defect tracking, test cases review and Metrics collation.
• Proficient in analyzing Business Requirements, System Requirements, Functional Requirement Specification (FRS), Design Documents, Use Case Specifications, and User Stories.
• Well acquainted with all phases of Software Development Life Cycle & Software Testing Life Cycle Concepts.
• Excellent Analytical, Problem Solving and Documentation skills including Team leadership coupled with aptitude to motivate team members towards goals, and strong interpersonal, written & oral communication skills and capable to work on multiple project/product assignments.
• Strong at testing ETL process & BI Reports and ensuring data correctness & data quality as per the Business requirements.
• Experience in setting up QA best practices and making sure that team is following the set process.
• Strong experience in DWBI Testing, Data Migration Testing, Database Testing, Regression, System Integration and UAT.
• Has experience in Agile Development Methodology.
• Sound knowledge and experience in Test Design, Test Execution and Test Results Analysis.
• Hands on experience in designing and executing test scripts.
• Extensive experience in test data setup based on business requirement.
• Extensively performed ETL (Data Stage) Testing and Report (OBIEE) testing.
• Good knowledge and working experience in using UNIX commands
• Validated reports developed in OBIEE.
• Experience in trading tools like Long View trading system (LVTS), iRouter, iCross, QAT, IPO applications.
• Having experience on IBM OPTIM tool.
• Experience in TDM (test data management) Re- Engineering data end to end process to analyze relationships between all tables from each DB to subset data using Optim tool.
• Experience in identifying PII elements to mask data for any DB.
• Possess Excellent problem solving skills and Flexible to the work environment
• Good understanding and experience of every phase of QA Life cycle, beginning with planning to the release of the product.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Strong knowledge in databases (Teradata, MS-Access, Oracle 10g/11g, DB2)
• Possessing Strong SQL skills.
• Closely worked with business to understand the features and design the test approach.
• Experience in GUI Testing, System & Functional Testing, Ad-hoc testing, Black Box Testing, And White Box Testing.
• Experience in Defect management, defect analysis and defect reporting using various Defect Tracking Tools.
• Lead team of testers of team size up to 6, Managed small to medium size projects, and have experience in interacting with offshore teams, onsite teams, clients counterparts.
• Has experience in test automation ETL testing by using Platinum (Cognizant in house proprietary Platform for Information Value Management).

TECHNICAL SUMMARY:

Database:  MS-Access, Oracle 10g/11g, Teradata

ETL Tools:  Datastage, Informatica, IBM OPTIM tool.

Reporting Tools:  OBIEE

Test Management Tools:  HP Quality Centre, ALM, JIRA

Operating System:  Windows, UNIX

Defect Tracking Tools:  Rational ClearQuest, JIRA, ALM

Languages:  SQL, VB, Java

Other tools:  Toad, MS Visio, SQL Developer

Version Control Tools:  MS Visual Source Safe (VSS), Rational Clear Quest

Automation Tools:  Platinum (Cognizant in house proprietary ‘Platform for Information Value Management’)

PROFESSIONAL EXPERIENCE:

Confidential

Test Lead

Responsibilities:

• Working as Test Lead.
• Handled team of up to 4 members and responsible for overall QA deliverable of the team
• Onboarding and off boarding resources to the projects
• Involved in functional, ETL, reporting, regression and system integration testing.
• Prepared the test cases and uploaded the test case into QC using QC add-in tool in Excel.
• Involving in discussion on the requirements with functional leads based on the implementation and testing of data- warehousing and reporting concepts. Also suggesting best practices and value ads.
• Based on the requirement determining the scope of work in the effort estimations.
• Involving in automating the scripts for test execution, writing medium to complex SQL Queries to test the functionality.
• Involving in test case, test script preparation, test data preparation process for files in Unix using putty and also in Test Execution using ETL and reporting tools
• Using HP QC as test management tool to track whole STLC phases from Requirement to Defect tracking.
• Responsible for designing and executing complex SQL scripts for data validation
• Created Dashboard to generate reports from QC.
• Preparing test closure documents
• Mentored new resources.
• Responsible for writing test strategy and test plans
• Entirely responsible for Planning, prioritization and allocation of testing tasks to team members
• Conducting test case reviews
• Timely escalations on critical issues
• Responsible for QA completion report & QA Sign off
• Test metrics collection & project postmortem & implementation of lesson learned
• Prepared the Daily status & weekly status Report
• Project progress tracking and resource management
• Providing guidance to team members on project scope & day today testing activities
• Responsible for test approach and test scenarios walk through to Development team and Business Analysts
• Responsible for assigning task and tracking the progress of team members
• Used the test management tool ALM for test design and test execution and Jira for defect logging and tracking
• Track and prepare the report of testing activities like Testing progress, Test case coverage and Defects discovered
• Responsible for defining test automation approach by using Platinum
• Participating in daily status calls
• Responsible for collecting and publishing monthly test metrics

Technology & Tools: Windows 7, UNIX, Data stage, Sql Developer, Putty, WinScp, HP QC/ALM

Confidential

Test Lead

Responsibilities:

• Worked as Test Analyst.
• Involved in functional, regression and system integration testing.
• Prepared the test cases and uploaded the test case into QC using QC add-in tool in xls.
• Based on the requirement determining the scope of work in the effort estimations.
• Involving in test case, test script preparation, test data preparation
• Raising defects in defect tracking tools, ALM. Track and follow-up the defects with Dev team till closure
• Preparing test closure documents
• Mentored new resources.
• Placed orders on LVTS and receive response from ICross engine once orders are executed.
• Involved in end to end testing from the time when order is placed until order was executed and send response back.
• Validated different scenarios as per requirement with traders in test environment.

Technology & Tools: Windows 7, UNIX, Putty, WinScp, LVTS trading tool, iCross, IPO, iRouter, Oracle 11G, Quality Center,

Confidential 

Test Lead

Responsibilities:

• Worked as Test Analyst.
• Involved in functional, regression and system testing.
• Prepared the test cases and uploaded the test case into QC using QC add-in tool in xls.
• Updating and tracking the work order in client project management system
• To run the jobs and check whether output files were created in expected location with correct format.
• Prepared Test Plan and the Test Strategy based on requirement documents.
• Experience in working with Confluence Unity Usage tool.
• Developed SQL queries based on ETL mapping and TDD documents.
• Executed Autosys and DS jobs and validated ETL mapping logic using SQL queries.
• Validated OBIEE reports by preparing SQL queries based on FRD and TDD.
• Created traceability matrix to map Test cases against Requirements using Quality Center.
• Prepared & reviewed Test scenarios, Test cases and Test Data, Test case Design, Execution
• Involved in reviewing and modifying test cases & scripts after initial iterations of testing phases to account for changes in project scope
• Verified whether the reports and extracts created are correct as per database by querying in sequel view point.
• To send the daily status mail to client.
• Mentored new resources.

Technology & Tools: Windows 7, Confluence Unity Usage tool, Datastage, Sql Developer, Quality Center, OBIEE

 Confidential

Test Lead

Responsibilities:

• Analyzed all tables in Prod copy DB and prepared doc like which tables need to copy fully, need to subset, need to ignore to ST4.
• Prepared data load strategy document to subset, mask and load data to ST4 from Prod back up.
• Created extract services in IBM OPTIM tool for the tables which need to do sub setting using Driver file (Pin/SSN/Plan/Contract).
• Executed extract services in IBM OPTIM for the tables which need to do sub setting using Driver file (Pin/SSN/Plan/Contract).
• Created load services in IBM OPTIM for the tables which need to do sub setting using Driver file (Pin/SSN/Plan/Contract).
• Executed load services in IBM OPTIM for the tables which need to do sub setting using Driver file (Pin/SSN/Plan/Contract).
• Validated data before and after sub setting by using sql queries.
• Analyzed few DB’s and identified PII elements from all tables for masking purpose.
• Validated data before and after masking for few DB’s by using sql queries
• Involved in ETL, regression and system testing.
• Prepared the test cases and uploaded the test case into QC using QC add-in tool in Excel sheet document (.xls).
• Mentored new resources.
• As a module lead I had managed a 3 members’ team.

Technology & Tools: Windows 7, Sql Developer, IBM OPTIM

Confidential

Test Analyst

Responsibilities:

• Worked as QA Tester
• Responsible for preparation of Test Plan, Test Design, Test Execution and Test Closure
• Responsible for preparing the impact analysis document for new project /Change Request (CR)
• Responsible for preparation of Test Scenarios & Test Cases and execution of the same
• Involved in Effort estimation and tracking of the project plan for QA activities
• Involved in creating the test cases based on Functional requirements, Business requirements, Mapping specifications, Entity relationship documents
• Responsible for Functional Testing of the web applications and backend using SQL’s
• Performed Regression testing with the server jobs result for successful completion of UAT.
• Performed SIT and QA testing for the files recreated for successful completion of UAT.
• Prepare the Test estimation, Test Plan and test cases.
• Involved in Batch Testing and Regression Testing
• Performed testing on Reports and Batch jobs
• Managed the defect tracking process using QC & conducting defect triage meeting on daily basis to prioritize the defects.

Technology & Tools: Windows 7, ADT tool, JIRA, Unix, Putty, WinScp, File Zilla, Sql Developer

Confidential

Test Analyst

Responsibilities:

• Worked as QA Tester
• Requirement analysis, Test Planning, Test Execution, Reporting defect, Coordination with Onsite
• Batch Preparation, Batch processing
• Data Warehouse Testing, End to End Testing, Sanity Check, Functional and Regression Testing
• Creating Master Test Plan, Creating test scenarios and Test cases, Reviewing test cases prepared by team members.
• Daily call with onsite/Offshore team members and clients, Executing Test cases, Task identification and Tracking, Preparing Metrics, “ETL” solutions to extract data into database (data warehouse).
• Tested the Data Validations in application using the SQL Queries in TOAD.
• Effective execution of test cases, Responsible for system testing.
• Peer reviewing of test design documents of my team members and guides the team in successful delivery of the projects.
• Initial load has been tested in ETL tool and incremental testing has been performed through Autosys.
• Managed the defect tracking process using QC.
• Prepared the Daily Status Report (DSR) and Weekly Status Report (WSR) and Monthly Status Report (MSR) for internal audit.
• Involved in test design review of the entire ETL tables.
• Involved in creating the Complex Queries to test the data Warehouse
• Performed ETL Functional Test case Execution.
• Responsible for creating the BI Report test plan, test estimation, test strategy, test design, test execution, metrics creation and overall test management.
• Continuously involved in executing the BI Reports for regression and smoke testing in various test environments.
• Prepared test phase summary report

Technology & Tools: Windows 6, Informatica, Sql Developer, Sql Server DB.