PROFESSIONAL SUMMARY:

• 8 years of professional experience in providing IT solutions at Client location Life Sciences, Insurance, Banking & Finance, Retail & Communication and Health care as a Data warehousing tester.
• Expertise with the Informatica, Cognos 8 BI tools, BO, SSRS, and SSIS as a Test Analyst.
• Have good exposure in test cases preparation and reviews, test plan preparation, test data preparation, Test Summary Preparation, Test Dashboard Preparation, Test Estimations, creating defect report, database queries.
• Sound conceptual knowledge and experience in Writing test cases, Test Summary Preparation, Test Dashboard Preparation, and Test Estimations, creating defect report, database queries and usage of Quality Center.
• Experienced in working closely with the clients and business users to understand the system in depth and provide appropriate solutions.
• Successfully completed s in Data Warehousing, Cognos reporting, Oracle9i and Teradata.
• Excellent interpersonal skills and capable of working as a member of a cohesive team, complementing the skills and work of team members.
• Broad technical experience in SQL and PL/SQL.
• Having an Onsite experience in Abu Dhabi (UAE) for 6 months in 2011.
• Well conversant with all the phases of a Software Development Life Cycle (SDLC).
• Excellent Team Player with good communication & leadership skills, ability to learn fast and take up responsibility & be proactive in any assignments given.

SKILLS PROFILE:

Primary Skills: Informatica, Cognos 8 BI tools, Oracle Discoverer reporting, BO, SSIS and SSRS.

Databases: Oracle 10g/9i,SQL Server and Teradata

Languages: SQL & PL/SQL

Operating Systems: Windows

Version Control Software: C20, Clear case, SVN Tortoise, Mantis, IBM Clear quest, JIRA

Other Tools: Ingenium, Temenous T24, AS400 & Platinum tool.

PROFESSIONAL EXPERIENCE:

Confidential, Eagan, Minnesota

Software/Tools: Informatica, SAS and Wherescape.

Onsite Test Lead

Responsibilities:

• Responsible for gathering detailed requirements by interviewing or facilitating meetings with subject matter experts (SME) across business functions and analyzing the business requirements effectively.
• Identify and implement new data quality rules and Perform daily, weekly and monthly s process.
• This involves estimation of requirements, obtain clarifications on requirements gap and defect management. Participation in client meetings for test environment set up, feasibility analysis and scope identification.
• Involved in the test data preparation, data extraction, and data validation process.
• Responsible for creating the test cases and test scripts in “Clear Case” tool get approval from stakeholders.
• Designs the test strategy and plan in accordance with requirements specifications and comes with test plan.
• Perform integration testing of enhancements and share the logs and results with Blue Cross asset owners for review and sign off.
• Responsible for coordinating with the offshore testing team activities and also act as a key liaison between the client and offshore testing team.
• Perform data profiling using tools like Atacama and create the test data for the testing as per requirement.
• Preparing traceability matrix.
• Perform code migration from Integration to Production and prepare CA7 scheduling plan and coordinate with Blue Cross Scheduling team, if required.
• Responsible for identifying defects during acceptance testing, managing them in Application Life Cycle Management and ensure retest/closure of the defects on fix.
• Provide warranty support and production hand over of Quality Assurance (Level 0 ) to EDIM data support team.
• Perform final run in production environment and also perform post production validation and share the results.

Confidential

Software/Tools: Informatica, OBIEE, Oracle database

Offshore Test Lead

Responsibilities:

• Provided L0, L1 and L2 estimates for various new projects.
• Participated in Review Team Meetings to analyze scope & feasibility of the testing for current system and Involved in requirement analysis
• Developed Testing Strategies, Test Plans, Test Cases, Requirement Mappings
• Defined entry and exit criteria for different phases of validation and prepared test data for interpreting positive and negative results.
• Lead a team of 10 members and was responsible for project initiation, delegation of tasks to peer team members, review of test cases and test results, presentation of test cases and test results to onsite and client team, defect management and tracking in QC and create/review of project repository.

Confidential

Software/Tools: Informatica, Teradata, Clear Quest.

Offshore Test Lead

Responsibilities:

• Interacted with Business Analyst to understand the business requirements. Involved in Client meetings for the estimation and Design for each releases.
• Analyzed project requirements, In Initial stage of the project Interacted with the Onsite Team and gathered the requirements.
• Analyze requirement, track requirement change and Forecast / Estimate project future requirements
• Involved in test dashboard Preparation and the Testing estimates at the initial stage of the project.
• Preparation of complex test scenarios and test cases for data loads between various systems.
• Supported in test plan (UAT) creation to the client and involved in the test case reviews & walkthroughs to the client.
• Involved in the Test Data preparation and also the test evaluation and summary preparation.
• Used Clear Case for tracking the test execution, defects, creating data warehouse test plan and handling test activities.
• Attending status call to discuss about outstanding defects and issues.
• Interacting with business analysts and users during user acceptance testing and ensuring that all business scenarios and requirements have been tested and qualified.

Confidential

Software/Tools: SSIS, SSRS, SQL SERVER, Clear Quest

QA Onsite Lead

Responsibilities:

• Knowledge Acquisition and successfully handover from Competitors.
• Test Requirement Study and Preparation of Test Estimates.
• Preparation of Test Strategy, test cases for ETL, Report Testing and Test Data Creation for Scenarios.
• Defect Management.
• Execution of Test cases in RQM.
• Preparation of Traceability Matrix (Mapping Test Requirement into Relevant Test cases in QC).
• Prepare test results documentation. Execute the test cases analyze the test results and report the issues tracking the defects to closure in Mercury Quality Center.
• Review the task completed by other Team members.
• Daily Task Progress mail to Client Manager.
• Defect Tracking/Retesting/Closing in Quality Center.
• Extensively involved in Test Strategy, Test Plan preparation, RTM, Test Design reviews, Test Execution plan, Defects Calls (Scrum meetings), Handling issues related to project, Metrics preparation, Dashboard and various reports preparation.
• Have experience in estimating projects for DWBI testing based on the Business logics.
• Communicate activities/progress to clients, project managers, business development and business analysts.
• Extensive Experience in Test Director which includes Uploading Requirement, Preparation of Test cases, Execution of Test Cases, Logging Defects in MQC, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.
• Excellent communication skills and inter - personal skills worked successfully on multiple projects in Agile and Iterative.

Confidential

Software/Tools: Cognos Reporting, Toad, Quality Center

Test Lead

Responsibilities:

• Test Requirement Study and Preparation of Test Estimates.
• Preparation of Test Strategy, test cases for ETL, Report Testing and Test Data Creation for Scenarios.
• Defect Management.
• Execution of Test cases in RQM.
• Preparation of Traceability Matrix (Mapping Test Requirement into Relevant Test cases in QC).
• Prepare test results documentation. Execute the test cases analyze the test results and report the issues tracking the defects to closure in Mercury Quality Center.
• Review the task completed by other Team members.
• Daily Task Progress mail to Client Manager.
• Defect Tracking/Retesting/Closing in Quality Center.
• Extensively involved in Test Strategy, Test Plan preparation, RTM, Test Design reviews, Test Execution plan, Defects Calls (Scrum meetings), Handling issues related to project, Metrics preparation, Dashboard and various reports preparation.

Confidential

Software/Tools: ETL Informatica and Oracle Database

Test Analyst

Responsibilities:

• Test Requirement Study and Preparation of Test Estimates.
• Preparation of Test Strategy, test cases for ETL and Test Data Creation for Scenarios.
• Defect Management.
• Execution of Test cases in RQM.
• Preparation of Traceability Matrix (Mapping Test Requirement into Relevant Test cases in QC).
• Prepare test results documentation. Execute the test cases analyze the test results and report the issues tracking the defects to closure in Mercury Quality Center.
• Review the task completed by other Team members.
• Daily Task Progress mail to Client Manager.
• Defect Tracking/Retesting/Closing in Quality Center.
• Extensively involved in Test Strategy, Test Plan preparation, RTM, Test Design reviews, Test Execution plan, Defects Calls (Scrum meetings), Handling issues related to project, Metrics preparation, Dashboard and various reports preparation.

Confidential

Software/Tools: Cognos Reporting, Toad, Quality Center, RQM

Test Analyst

Responsibilities:

• Knowledge Acquisition.
• Test Requirement Study.
• Preparation of Test Estimates.
• Preparation of Test Strategy.
• Preparation of test cases for ETL and Report Testing.
• Test Data Creation for Scenarios.
• Execution of Test cases in RQM and defect tracking.
• Interacting with clients meeting on test results walk through and defect Triage.

Confidential

Software/Tools: Data Transformation Services (DTS) SQL server, Quality Center

Test Analyst

Responsibilities:

• Knowledge Acquisition.
• Test Requirement Study.
• Preparation of Test Strategy.
• Preparation of test cases for ETL and bug fix testing.
• Test Data Creation for Scenarios.
• Execution of Test cases in RQM and defect tracking.