SUMMARY

• 7+ years of professional experience in Manual\Automation testing for delivering of quality software products and applications to meet business, market and customer needs.
• Thorough knowledge in all phases of Software Development Life Cycle, which includes Analysis, Design, Development, Testing, Implementation and Support.
• Good knowledge of Relational & Dimensional Data models (Star and Snow Flake), Facts and Dimension tables, SCD, Normalized, Denormalized Data, Data Extraction, Data Integration.
• Experienced in preparing testing related documents like Test strategies, Test Plans, Test Scheduling, Test Scripts, Test Cases, Test Data, Test Summary report and Test Execution Report.
• Hands on experience on SQL Queries, Stored procedures and Tables.
• Thorough hands on experience with all levels of testing including Smoke Testing, Integration Testing, Functional Testing, GUI Testing, Security Testing, Browser Testing, Regression Testing and User Acceptance Testing.
• Experienced with ETL tools like Informatica, SSIS.
• Validated data consistency, data completeness, de - duping logics in data migration and data conversion projects.
• Worked on Project which followed Agile Methodology.
• Good experience on Windows and web based applications testing.
• Thorough knowledge in Quick Test Pro (QTP) and Quality Center (QC).
• Exposure in using Test Case Management Tools like Quality Center (QC/ALM) to design & execute the Test Cases and to map the Requirements with the Test Cases.
• Organized, detail-oriented and could work well in a time sensitive environment.
• Quick learner and excellent team player ability to meet tight deadlines and work under pressure.
• Have ability to understand and articulate the business requirements and perform a detailed analysis to map them to the technical and functional requirements.
• Good experience and knowledge of documenting, writing and modeling Test Cases, Use Cases, Functional and Non-Functional Requirements and creating flow diagrams.
• Managed multiple projects with critical deliverables and tight deadlines.
• Possess excellent team management, communication and analytical skills.

TECHNICAL SKILLS:

Database: SQL server, Oracle 9i, MySQL

Scheduling tools: Autosys, Informatica scheduler

ETL Tools: Informatica power center, SSIS

Programming Languages: C, SQL, XML

Operating System: Windows 8/7/XP/2003, UNIX

Web: HTML, XML, XSLT

Methodologies: Agile Scrum

Design Tool: MS Visio

Automation tools: Quality center (ALM), Quick Test Professional (QTP)

PROFESSIONAL EXPERIENCE:

Sr.ETL QA Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Informatica ETL tool.
• Test Case Execution and Adhoc testing
• Performed Integration, End-to-End, system testing
• Involving in Functional Testing & Regression Testing
• Developing Automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing and Volume testing of the application using LoadRunner
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
• Performed data validation testing writing SQL queries.
• Wrote complex queries in SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Experience assessing testing processes, creating and implementing testing strategies in UAT phase.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.

Environment: - Informatica8.6, SQL, Oracle, HP Quality Center, Microsoft Office, Internet Explorer7.0, WindowsNT4.0/2000, HP/Unix.

Sr. ETL tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzed application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing SQL queries to test the integrity of the application and SQL Server databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in SQL assistant to analyze the data
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts
• Created, maintained and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web based environment-using Quality Center.
• Extensively used Load Runner for generating the automated test scripts.
• Creating traceability relationship between requirements in the same module and between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating the test plan, procedures and Wrote test cases.

Environment: HP Quality Center, Oracle10g, QTP, SQL, DB2, SQL*Plus, UNIX, shell scripting.

DWH/ETL/UAT BI/ Guidewire Application Tester

Responsibilities:

• End to End testing of Guide Wire Insurance Suite 7.0 (Policy, Billing & Claims) and Supporting DWH and Business Intelligence Solutions.
• Sprint planning for determining& Documenting Testing efforts required for deliverables targeted for iteration/releases.
• Working with release manager/DBAs for deploying right application build into the Testing as well as Development environment.
• Application Clock Movement and Batch Run as well carrying out users/administrative roles/permissions(Agents/UW) in the application for testing functionalities supporting core insurance operations —underwriting, policy administration, billing, and claims.
• Tested Business Requirement/ETL Mapping Rules/Reports against various GW functionalities/modules and data flows from UI to OLTP DB to Replication DB to Staging to Data Mart/EDW to Reports
• Integration testing between the systems (Policy, Billing & Claims) to create test data/scenarios for ETL, BI and UAT Testing manually as well as by employing UFT
• Performed Back-End testing using SQL queries within the QTP Script to compare and retrieve data by using Data Base Check points.
• Worked in Product Testing, CRM Testing, Web Testing, DW-BI Testing and MDM Testing.
• Validating the Data Mapping logic against business rules, UI, data dictionaries and SQL query results
• Performed Negative testing using SSIS to find how the packaging performs when it encounters invalid and unexpected values
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Validating on-demand as well as periodic/delta/daily data loads/refresh and reconcile loads across
• various databases.
• Validating the data flow from UI through to Staging DB to Reporting Data Mart using SQL Scripts
• Validating Data Migration & Conversion of Policies, claims from multiple Legacy Sources into Guidewire Application and supporting DWH and BI solutions.
• Validating data flows/mismatch between staging DB and dimensional model
• Work with BA, DA, ETL Developer, BI Developer and Users for ad-hoc solutions/Reports
• Attended review sessions with Data Analyst for any structural change (Due to incomplete Business
• requirement/granularity issues) and upgrade in the Data Mart solutions/Table solutions
• Reviewing report requirement with BA and ensuring if they contradict granularity or is supported by existing functionalities as well as DWH solutions
• Data Creation in each Center for validating the UI & creating complex scenario that would suffice the Reports targeted for the sprint/iteration/releases
• Tested reports generated in business objects.
• Wrote Complex SQL queries to support and validate the tables and reports under test.
• Extensively involved in functional testing, regression testing, performance testing, volume testing
• Developed the complete Test documents like Test Plan, Test Cases, and Test Scripts by analyzing
• Business requirement documents, Technical and functional design documents, Use cases.
• Attended Defect Review meeting for tracking/escalating defect status to the team
• Tracking Defects, generating defect Reports in ALM/Quality Center as per Severity and Priority
• Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.
• Extensively involved in System testing / Functional, Regression testing and Integration testing
• Test Management through ALM.
• Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements.

Environment: Guidewire Insurance Suite, Agile, SQL, HP ALM, SSIS, SQL Server 2008R2, Windows, UNIX, Putty, Web Services, HTML

Manual Back-End Tester/ QA Analyst

Responsibilities:

• Analyzed the functional requirements of the application and developed Test strategy for the application. 
• Developed various Test plans and Test cases and analyzed Test results. 
• Analyzed and documented the test results for each build of testing. 
• Enhanced and modified the scripts according to the test case scenarios. 
• Prepared test data to verify different types of scenarios. 
• Extensively involved in the Backend / Data base testing using SQL queries. 
• Responsible for tracking defects using Test Director and made sure those defects are efficiently passed from one layer to another. 
• Involved in adding Requirements, associating Requirements to the test cases writing and executed test cases using Test Director. 
• Conducted Static Text Testing, Text-Link Testing, Image Link Testing, and Broken Link testing. 
• Tested the Applications compatibility for various versions of IE and Netscape. 
• Responsible for performing Functional testing by creating Manual and Automated Scripts using Win Runner. 
• Worked with UNIX shell scripts. Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups. 
• Responsible for user Acceptance testing by giving demos to the client and getting sign off. 
• Responsible for documenting the process for future references. 
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager. 

Environment: Test Director, Win Runner, XML, MS Office, PL/SQL, SQL, Oracle, Windows XP/2000, UNIX, MS SQL Server 2000

Test Analyst

Responsibilities:

• Creating test scripts, test conditions and Traceability Matrix from the functional specification using test management tool HP Quality Centre 9.2.
• Gathering requirements and creating UAT test data as part of test data acquisition plan and test script execution on the user acceptance testing environments.
• Test bed preparation, execution of manual test cases and defect management for every cycle of testing
• Performing health checks of the UAT applications daily and reporting the status to the UAT team and clients.
• Regression testing using QTP.
• Interaction with the client for understanding the application workflow, test requirements and status reporting.

Environment: Windows XP, Java, SQL, Quality Centre, Jira.