SUMMARY:

• 9+ Years of focused experience in IT Industry with a strong back ground in testing of Client Server and Web based applications.
• Expertise in all phases of testing life cycle including Requirements gathering, Providing Estimates, Scheduling, Testing, Defect tracking, Management and Reporting from Inception to Implementation phases using Agile, waterfall methodology.
• Having good noledge in Software Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC) which includes Requirement Gathering, Data Analysis, Application Design, Implementation and Testing of various applications and Software development methodologies (RUP, Waterfall and Agile).
• Experienced in Unit, Functional, Integration, Regression, System, black box, GUI, usability, back - end, and browser compatibility, Component, API and User Acceptance Testing (UAT) across varied domains and operating systems.
• Possess strong domain experience in Insurance, Health Care, Banking, Tele Communications, Production, Consumer Goods
• Worked in Agile SCRUM methodology of project development
• Extensive noledge in gathering and understanding BRDs (Business Requirements Document), FRDs (Functional Requirements Document), SRS (System Requirement Specifications) and Used cases.
• Experienced with LISA Virtualization.
• Created Java based scripts for Selenium Web Driver with Junit as automation frame work.
• Adept in using tools like Quality Center, Test Director, Quick Test Pro, SOAP UI, Rally, CA LISA and Jira.
• Proficient with using Web,Web Services, and Database protocols in CA LISA, DevTest and SOAP UI.
• Profound noledge of testing SOA services and test automation.
• Experienced to create the Test Data using ITKO LISA 7.5.0.812, DevTest 8.0.1, and Soap UI.
• Experienced to create the Test Data using Test Data Generator.
• Experience in all stages of testing namely Advanced Automation, GUI testing, Functional testing, Integration testing, AIT testing, System (SIT) testing, End to End testing and User Acceptance testing.
• Experience in Performance Testing using LoadRunner.
• Excellent noledge in setting up Test environment and Test data.
• Experienced in creating/maintaining Test Logs, Summary Reports.
• Involved in writing UNIX shell scripts and used them to batch automated testing process.
• Strong noledge in life cycle of Data Warehouse using Data Extraction, Data Transformation and Data Loading processes (ETL) and having profound noledge in Dimensional modelling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Expertise in RDBMS backend testing for data validation of the business rules to ensure data integrity using SQL Assistant.
• Experience in writing simple and complex SQL queries using TOAD, and Oracle SQL Developer/Navigator.
• An excellent team member with an ability to perform individually with strong verbal, interpersonal and written communication skills.

TECHNICAL SKILLS:

Technical Tools & Skills: QTP 10.0, ITKO LISA 7.5.0.812, DevTest 8.0.1, Soap UI, Selenium, LoadRunner.

Test management tools: Mercury Quality Center 9.0/10.0,Rational clear quest,, Jira, Bugzilla

Automation Tools/ETL Tools: Informatica Power Center 9.1/8.6, Informatica Power Mart 5.x

Internet Tools: Java Script, VB Script, XML, .NET Framework, HTML, and DHTML

Requirement Management Tools: TFS, Microsoft SharePoint 2013

Databases: MSSQL Server, Oracle11g,10g,9i/8i, Access,DB2,COBOL

Database Tools: WinSql, Toad, SQL Developer

Packages: MS Office

Languages: TSQL, PL/SQL

Operating Systems: Windows NT/2000/XP/7/8 and UNIX, Shell Scripts

Data Modeling and Design: MS Visio

Reporting Tools: SQL Server Reporting Services (SSRS), Business Objects and Crystal Reports.

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Automation Lead

Responsibilities:

• Analysing Business requirements, functional requirements and other development documents.
• Good Experience in Agile methodology with SCRUM Process for the product development.
• Good Hands on experience in generating the in Guidewire Policy Centre, Billing centre & Claim Centre for historical /non historical Test Data for Dev, INT Tiers and SIT QA.
• Performed Automation testing in Guidewire Policy Centre, Billing centre & Claim Centre.
• Participate in Daily stand-up SCRUM/STATUS meetings, Performed testing on multiple Sprints.
• Involved in test data analysis, project plan reviews and handling off-shore.
• Automated the test data generation in DevTest Workstation 8.0.1 and SOAP UI for the end user to test in Guidewire Policy centre, Claim centre and Billing centre.
• Define and standardize the Process for implementing Service Virtualization using CA Lisa.
• Created Multiple Virtual Service Environments Using CA DevTest.
• Good Hands on creating Virtual Service Image and Deploy Virtual Service Model on Server.
• Experienced with Web Services Calls Such as SOAP Services
• Worked on data requests from production support team to clone and recreate production data in lower environments for defect fixing and testing.
• Experienced in Recording/fixing the TestScripts in ITKO LISA/DevTest8.0.1.
• Experienced in GIT code fixing/code check-in/code Reviews.
• Developed and maintained automated Smoke, Regression test cases using Selenium
• Scripting the test cases for regression using Selenium WebDriver using Java
• Experienced with Importing/Exporting Jason Scripts using Selenium Integration in Dev Test 8.
• Written automation scripts for Regression test cases and executes using Selenium.
• Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.
• Responsible Performance testing, debugging, executing, analyzing complex applications using HP LoadRunner
• Developed and created performance test scripts to test performance and load testing on web applications.
• Create Lisa Automation scripts for web service testing using XML execution and Raw Soap Request step.
• Participated in Entire QA status meetings on alternate week with the End Users/Requestors.
• Attended the Defects meeting and interacted with development team and BA team for defect prioritization and resolution.
• Experienced in creating/maintaining Report Logs including Default and Risk/Dirty Reports.
• Extracted the property policies from Guidewire Policy Centre using SOAP UI
• Generated the XML’S to create the Property Policies in Guidewire Policy Centre using SOAP UI.
• Tested Web services, XML, WSDL using SOAPUI tool. Modified end points when we worked on difference servers and different versions of Web Services.

Environment: DevTest Workstation 8.0.1,ITKO LISA 7.5, SOAP UI 4.5.1, Selenium WebDriver, LoadRunner 12.0, Java, J2EE, JIRA, XML, Oracle, SQL, TOAD, Mainframes, Flat Files, QMF for windows and MS Office.

Confidential, Chicago, IL

Test Lead

Responsibilities:

• Reviewed and understand the User Stories/business requirement documents of various functionalities.
• Design and execute the Test Plans and Test cases using User Stories/Business requirements. Performed Sprint level testing, Functional, Systems Integration Testing and Regression Testing.
• Good Experience in Agile methodology with SCRUM Process for the product development.
• Review and Sprint Retrospective Sessions.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Requirement gathering and analysis for different test scenarios and Identify virtualization requirement for functional and performance testing of application.
• Experienced with Web Services Calls Such as SOAP Services/REST Services
• Created Virtual Service Environment using Request/Response Pairs, By Recording and From WSDL
• Executed multiple rounds of Load and Performance testing.
• Involved in analyzing, interpreting and summarizing meaningful and relevant results in a complete Performance Test Report.
• Performed SOA / web services testing using Soap UI, wrote adaptors to test / invoke web services.
• Used Selenium IDE for Open source web testing.
• Implemented automation test suite using Selenium WebDriver, JAVA, and Selenium Grid.
• Setup the Automation framework using Selenium IDE to run test cases in multiple browsers and platforms.
• Wrote and executed automated test cases using Selenium Web Driver to automate manual testing solutions.
• Created New scripts and Maintained in ITKO LISA work station
• Created Test Scripts/Test Suites, Run/Execute the Regression Test Scripts/Test Suits locally and on servers using ITKO LISA.
• Create Lisa Automation scripts for web service testing using XML execution and RawSoap Request step.
• Generate Operations for the given WSDL and Endpoint. Setup Filters and Assertions for web service and web testing to capture and validate the response. Create test steps to validate WSDL definition.
• Experienced to create the Test Data using Test Data Generator.
• Responsibilities included Test Planning, Test Case development and test script execution for Unit, Integration and System Testing.
• Prepared and provided status summary reports to the management on system status, system changes, problems and potential impacts.
• Participated in developing high-level System Test Scenarios and Full Cycle Test Scenarios
• Worked closely with Business Analysts to find out the gaps in functional requirements.
• Worked closely with development team to discuss and priorities the defect fix.
• Duties included documentation reviewing and analysis.
• Involving in QA / UAT / Production deployments by doing Shakedown testing
• Performed database testing by writing PL/SQL queries.
• Interacted with development team for defect prioritization and resolution using Defect Tracking Tool JIRA.

Environment: ITKO LISA 7.5, SOAP UI, Selenium WebDriver, Selenium Grid, LoadRunner 12.0, Java, J2EE, JIRA, XML, Oracle, DB2, SQL, TOAD, Mainframes, COBOL, CICS, JCL, Flat Files, XML, QMF for windows and MS Office.

Confidential, Austin, TX

Sr.QA Analyst

Responsibilities:

• Involved in writing Test Scripts for Functional Testing, System Testing and Integration Testing
• Extensively involved in Manual/Functional Testing of the Web Based Applications.
• Involved in Executing System Testing
• Used QC for Bug Tracking and for functional Specifications and Test scripts.
• Involved in Test Data Creation.
• Able to write Java Test Automation Script (.java) using Java, Selenium and Web Driver which does sanity testing on every deployment performed in QA Environment and sends Email Notification on failure.
• Expertise in Functional and Regression testing using Selenium.
• Responsibilities included Test Planning, Test Case development and test script execution for Unit, Integration and System Testing.
• Executed Performance testing on multiple arrays and servers using LoadRunner and Report generation.
• Used LoadRunner to execute multi-user performance tests, used online monitors, real-time output messages and other features of the LoadRunner Controller.
• Validated the Data in Back End by Writing SQL Queries in Oracle and DB2
• Created and executed test cases using Quality Center.
• Worked with development team to discuss the design and testing aspects of the application
• Reported the bugs, Email notifications to the developers using the Quality Center.
• Crated and maintained requirement traceability matrix to find out the gaps in requirement and test case coverage.
• Interacted with the Clients to perform Integration testing
• Performed data integrity and data validation by writing SQL queries in TOAD for RDBMS Oracle.
• Responsible for test data preparation for the System / Integration testing, traceability matrix to ensure the test case coverage and defect logging
• Interacted with developers, Business & Management Teams and End Users.
• Defect detection, reporting and tracking was done using rational clear quest.

Environment: Quality Center 10.0, ITKO LISA, Selenium WebDriver, HP LoadRunner, Java, J2EE, PL/SQL Developer 8.0.4, QTP 10.0,Oracle, DB2, COBOL, JCL, MVS, Mainframes, MS Excel, Windows XP and MS Office.

Confidential, West Trenton, NJ

QA Analyst

Responsibilities:

• Developed test plans, test cases based on functional specifications and design documents.
• Worked as a Member of the QA team, responsible for system testing before deployment.
• Handled Defect life cycle process independently and handled issues by interacting closely with Business Analysts, Developers, Performance Testers, end users and other members of the Team.
• Conducted peer reviews for the test plan and Participated in walkthroughs.
• Maintained requirements and created Traceability between Requirements and Test Cases.
• Good Experience in Agile methodology with SCRUM Process for the product development.
• Worked as an Automation tester to write and execute automation scripts for regression and smoke testing using QTP.
• Conducted Regression Testing and data Driven testing using QTP.
• Solid experience testingGuidewire Policy Center and Billing Center.
• Used Regular Expressions to define property values in object repository for the changing objects.
• Used GUI, Text, Bitmap, Database checkpoints and synchronization statements extensively to customize the QTP scripts. Parameterized the scripts and data drove them to improve the flexibility of the tests
• Tested web services using SOAP UI to test the XML requests and the responses for each of the operations.
• Designed and developed test scenarios (Use Cases) as per the requirements in Quality Center.
• Responsible for test data preparation for the System / Integration testing, traceability matrix to ensure the test case coverage and defect logging
• Executed test cases, logged defects, retested and closed the defects after dev fix.
• Used Quality Center for writing, executing test cases and managing defects.
• Wrote moderate to complex SQL queries to retrieve and modify the data needed for testing.
• Tested end to end internal and external Data Exchanges along with related XML’s and schemas as part of web service testing.
• Worked closely with developers to make sure that the fixes are done in time and efficiently.
• Done regression testing for the defects fixed in every build.
• Documented test cases, test results, test procedure and reported to client.
• Conducted Functionality, Performance and Regression testing during the various phases of the application.

Environment: Quality Center 10.0, Guidewire Billing, Policy Center, QTP, SQL Server, DB2, TOAD, Win SQL, SQL\PL-SQL, Windows 2000/XP, MS Office, Visio, Java, SOAP UI, XML, XSD, XML Spy, CSV Files, XML Files, COBOL, JCL, MVS, MainFrame, SharePoint.

Confidential

ETL Tester

Responsibilities:

• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Executed and scheduled tasks; batch processing, metadata management and data mapping.
• Facilitated meetings with business users, Project Managers, and IT personnel.
• Responsible for data analysis, business/systems analysis; ETL process documentation; user requirements/ functional specs; technical specifications.
• Created ETL documents detailing the ETL (database navigation and data transformation) logic used by developers as coding specifications.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Created customized and adhoc reports for various campaign execution based on certain criteria.
• Scrubbed data to accurately generate customer pull. Provide output files in various file format based on customer request.
• Reviewed specifications for feasibility of customer list pull criteria and commit date.
• Executed Campaign based on customer request and reviewed execution log to keep track of the number of records going into and coming out of every job step.
• Created waterfall reports to show total lead pull, number of records dropped as result of each suppression or set of suppressions.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels.
• Worked on generating reports using SQL Plus and PL/SQL. Worked on tuning SQL statements.
• Worked with T-SQL for validating the SQL Server 2000 data.
• Involved in complete life cycle activities like pre-testing phase and testing phase.

Environment: Quality Center, Informatica Power Mart 5.1, Erwin, Visual Safe Source, SQL Server 2000, MS Excel, T-SQL, SQL, PL/SQL, TOAD, Test Director, Oracle 8i, Windows 2000, UNIX, Shell Scripting (Korn)

Confidential

Software Engineer

Responsibilities:

• Testing (System, Regression, Report, Performance).
• Ensure end to end Data Consistency and Integrity across different layers of Datawarehouse (DRA-Data Reception Area, DSA- Data Staging Area, and ODW- Orbit Data warehouse & ALD-Aggregate Layer Datamart) making use of ETL tool OWB.
• Perform duplicate, count, incremental data checks on source and target.
• Run ETL jobs on OWB (Oracle Warehouse Builder).
• Write complex SQLs to validate the transformation and data cleansing rules in Datawarehouse.
• Train project team members on technologies implemented & business functionalities in the project.
• In charge of testing developed software against specified requirements.
• Accurately monitoring and recording results in test documentation.
• Preparing detailed test plans, acceptance criteria and test scenarios for each project.
• Analysing, writing reports & communicating results to colleagues & managers.
• Monitoring the testing process and identifying and logging test failures.
• Performing peer reviews and estimates.
• Involved in Performance Testing, Scalability / Stress and Load Testing.
• Testing full product suite's, identifying problems & resolving them with the development team.

Environment: Java, Oracle, Toad, SQL/PLSQL, HP Quality Center, UNIX