SUMMARY

• 9+ Years of IT experience in diverse areas of Software Testing with expertise in ETL Data Warehouse Testing, Web Services Testing, Automation and with business knowledge in Property & Casualty Insurance (P&C).
• Has 6 years of experience in leading the QA team at Onshore and Offshore.
• Has 5+ years of experience in handling multiple running QA releases/projects of Data warehousing and Web based validations.
• Experienced in writing the complex SQLs based on the business logics, Data validation with various techniques along with running the mappings and monitoring the jobs.
• Executed one project in Testing the Informatica B2B Data Exchange.
• Well experienced in testing the SCD Type - 2, Type-1, Dimensions and Fact tables.
• Good knowledge on the Informatica Power Center 9.0.1 tools: Designer, Workflow Manager, Workflow Monitor.
• Thorough understanding on the Transformations used in the mappings which helps in finding the early defects. Experienced in testing the BOBJ Reports.
• Experienced in testing and data creation from the Guidewire applications- Policy Center, Billing Center.
• Has 2 years of experience in SOA testing. Proficient in testing Web services and Message Queues using Green hat Tester, SOAP UI and HP Service Test.
• Has experience in automation tool QTP 10.0. Automated the business scenarios on Mainframes with the help of Terminal Emulator for Humming bird client.
• Has good experience in Teradata & Oracle Database and knowledge on languages like VBA and SQL.
• Experienced in creation of Excel based macros (VBA). Created more than a dozen of tools till date, which received customer accolades and saved lot of effort and hours for customer.
• Experienced in HP Quality Center for Requirements Traceability, Test case Execution, Defect Tracking & Reporting and Project Management.
• Works closely with business users at various stages of the project lifecycle, including requirements gathering, design, and testing.
• Has experience in different kinds of testing like Smoke Testing, Functional Testing, Integration Testing, and SOA Web services Testing, E2E Testing, Regression Testing and Integration Testing.
• Possess working experience in creation of Estimates, Requirement Analysis, Test Strategy, Test Planning, Test Scenarios, Test Cases and progression from Test Execution, Defect reporting to Documentation.
• Experienced in using the test and project management tools like: HP ALM (Quality Center), Rally and JIRA.
• Proven ability to use applied research and problem-solving skills to support learning as well as lifelong personal and professional development
• Demonstrated proficiency in leading and mentoring individuals to maximize levels of productivity while forming cohesive team environments.

TECHNICAL SKILLS

Programming Languages: C, C++, HTML, VBA

DBMS/RDMBS: Teradata, Oracle 10g & DB2

Testing: Manual Testing Data Warehouse Testing, SOA Testing, Functional testing, Regression Testing, Integration Testing and E2E Testing

Automation Testing: Hybrid framework, Keyword driven and Data driven framework.

Methodologies: Testing/ Development Methodologies Water Fall Model & Agile Methodology

Tools: Test, Defect and Project Management HP ALM (Quality Center), JIRA, Rally

Automation: Quick Test Professional 10.0

MS office Tools: MS-Word Power Point, Visio, Excel

SOA Tools: Green Hat Tester Tool, HP Service Test, Actional Diagnostics, SOAP UI

Version Control: Microsoft VSS, Live link Calligo Explorer, Share Point

PROFESSIONAL EXPERIENCE

Confidential

ETL QA Lead

Responsibility

• Participating the Business requirements walkthrough and Analyzing requirements and proving the inputs for Estimates.
• Raising the ambiguities to BA to make sure the testing team is getting the right information.
• Leading the validation effort for the Policy, Member, Claim and Rx Claim domains for Data Integrations and Publication and Subscription Testing.
• Master Test plan and Test Scenarios preparation; conducting the walkthroughs with project team; getting the signoffs from them.
• Analyzing the data for the proposed changes and verifying the Transformation logics written by Business Analysts.
• Creation of Teradata SQL queries and Data validation as part of execution using various data validation techniques.
• Performing and Coordinating the Data Integration (DI) Testing and Publication and Subscription (PUBSUB) Testing in SIT environment.
• Reporting the issues to developers using HP ALM and explaining the defects to developer. Working closely with developers till the defect closure.
• Performing the DI, PUBSUB, Secure View and Semantic view validations in the UAT environment and handing over to UAT users.
• Creating the validation results and giving the demo to UAT Users as part of QA Proof of testing.
• Coordinating with offshore to document the results for each testing phase and sharing with the Project team.

Confidential

DW Test Lead

Responsibility

• Participating the Business requirements walkthrough and Analyzing requirements and coming up with the Estimates.
• Understanding the solution architectures and Designs for each of the new functionalities and sharing the knowledge with offshore team.
• Raising the ambiguities to BA, IDA and Tech Lead to make sure the testing team is getting the right information.
• Participating the scrums and other meetings and providing the updates and reporting the risks for future items.
• Test Strategy and Test plan preparation; conducting the walkthroughs with business stakeholders; getting the signoffs from them.
• Planning the testing activities for each sprint and updating the Rally
• Giving the architecture and Design walkthrough with offshore team.
• Test Scenario preparation and assigning the creation of Test case and Test data needs to offshore. Assisting them by resolving their questions/issues.
• Creation of the required test data in Policy Center, Billing Center and Integrated Claims System.
• Tracking the timelines of the project closely and giving the updates to the project manager and Scrum master.
• Participating the mapping review with developer and Tech Lead and proving the inputs to uncover the major flaws in the mapping which is being deviated from the Business rules.
• Running the mappings on Informatica Workflow manager and monitoring them. Reporting the issues to the Dev Tech Lead if any mapping failures and errors.
• Creation of SQL queries and Data validation as part of execution using various data validation techniques.
• Performing and Coordinating the three levels of testing; Integration testing, Application Integration Testing (AIT) and System Integration Testing (SIT).
• Integration testing is about validating the single integration point between any two systems. In this case, its Source systems - BIC and BIC - Financials.
• AIT is the E2E testing with the participating upstream and downstream systems at a time.
• SIT is the 2nd level of E2E testing with minimum number of scenarios performed in QA, which is production like environment.
• Reporting the issues to developers using JIRA and explaining the defects to developer. Working closely with developers till the defect closure.
• Documenting the results for each testing phase and requesting the signoffs from stakeholders based on the open defects.
• Preparing the Testing closure document with test results and fixed & deferred defect details. Requesting the signoffs from the stakeholders.
• Co-ordination with the offshore team of 8 to 10 and providing the sufficient information to get the work done from offshore.

Confidential

Test Analyst

Responsibility

• Preparation of estimations, following the Project plan and requesting the dependencies of other teams well before.
• Analyzing Business Requirements, Use-cases and review them with Business team.
• Analyzing issues and raise them to MetLife business SMEs
• Addressing the offshore team queries and continuously passing the information to them.
• Tracking the requirements, Test Scenarios, Test Cases and Defects in HP Quality Center.
• Executing the test cases and reporting the defects to the development team with the help of Quality Center and getting the regular updates on the fixes.
• Preparing the status reports and conducting the Defect triage meetings.
• Participating the discussions with clients and raising the flags whenever required.
• Analysis of technical designs of Message Queues and testing the MQs on Green Hat Tester tool.
• Automating the scripts in the GH Tester.