SUMMARY:

• Expertise in Quality / Data Analysis with over 8+ years of IT experience on all phases of a SDLC project in Insurance and Finance domain.
• Experienced working on QC and HP Application Lifecycle Management (ALM) to manage Test Plan, Test Cases, Test Execution, and to track & report defects. Extensively used QTP, Selenium Webdriver and Eclipse IDE for Automation testing.
• Extensive experience in requirement gathering, business and technical design sessions with clients, DBA’s, developers, and QA lead with integrated JAD sessions.
• Strong SQL development/scripting work experience: complicated query design, query optimization by using TOAD, SQL developer, WinSQL tools, DB studio.
• Collaborate with project, development and QA teams to understand automation requirement and define solutions.
• Design and drive implementation of end to end test automation strategies, frameworks needed to test all the dimensions of multiple insurance and financial services products including functional correctness, performance, scale and security.
• Create generic reusable core automation components that are easy to maintain even when underlying features change.
• Deep understanding of BDD process and should be able to plan automation in early stages.
• Define KPI for automation and publish automation metrics to stakeholders.
• Excellent skills in gathering business requirements, creating Data Requirements Document (DRD) and Functional Requirement Specification (FRS) documents
• Excellent knowledge of Selenium, QA process, Automation, Full understanding of TDD practices and Agile
• Excellent skills in Data Analysis, Requirement Analysis and Use Case Development using UML methodology
• Solid understanding of the ETL process from QA perspective, testing the aspects of ETL transformation using SQL
• Expertise in Writing and Executing Test cases based on functional specifications and business requirements in HP Application Lifecycle Management (ALM).
• Expertise in Developing Requirements Traceability Matrix (RTM), Meta Data Repository (MDR) Capturing Data Flow from multiple Sources
• Expertise in software development to build and use automation frameworks using technologies: Java, JUnit, Selenium, JBehave, Soap UI/Pro, Spring framework, REST, JSON and XML, Eclipse IDE, etc.
• Demonstrated experience developing high quality test strategies and test execution - specific focus on cross browser and cross device testing.
• Ability to create good acceptance and integration test automation scripts and integrate with Continuous integration (Jenkins/Bamboo) and code coverage tools (Sonar, Clover)
• Involved in different testing models - waterfall, V-Model, Agile Model, and Iterative Model.
• Expertise in test driven development and different testing types such as System Testing, Functional Testing, Integration Testing, Database Testing, Smoke Testing, Regression Testing, End to End Testing, UAT with defect tracking and management.
• Exposure working on Onsite/Offsite model
• Highly organized diligent and responsible, able to execute complex projects and programs to meet standards and deadlines.
• Excellent interpersonal skills; capable of handling multiple tasks and priorities; self-motivated; displays initiatives.
• Ability to understand and quickly apply new technologies and information.
• Creative and passionate problem solver with strong technical and analytical skills.

TECHNICAL SKILLS:

Methodology/ Techniques:: Rational Unified Process (RUP), Testing Process Design and Implementation, and SDLC

Process/ Model Tools:: MS Visio, Rational Unified Process (RUP), Rational Rose, Application Lifecycle Management (ALM), MSOffice, ETL, Mantis, IBM RTC, JIRA

Programming Languages:: C, C++, Java, SQL, PL/SQL, HTML

Operating Systems:: UNIX - Solaris, Linux, MS Windows

Databases:: Oracle 10g, MS Access & MS SQL Server 2000, DB2

Database Tools: TOAD, SQL Developer, DbVisualizer

Testing Tools: ALM, SoapUI, Cucumber, UFT, Selenium, Eclipse IDE

ETL Tools:: Informatica, Data Stage

Test Management Tools:: HP ALM 11.0; QC 10.0, 9.2; Rational Clear Quest

Version Control:: Clear Case, SVN, VSS

Project Management:: MS Project, Word, Excel, Power Point

PROFESSIONAL EXPERIENCE:

Confidential

Platform: Agile, Jira, Doors, RTC, Jenkins, Bitbucket, Cucumber, SoapUI, DBVisualizer

Test Engineer

Responsibilities:

• Validated responses in SoapUI for testing different offers for Auto, Property and PLP (Umbrella)
• Involved in Manual and Automation Testing in Service Oriented Architecture.
• Developed XML test data and implemented Functional and Data Driven tests using SOAPUI.
• Experience with test automation for web application using Cucumber and creating BDD scenarios
• Responsible for Automated Testing Environment setup for creating, and running automated tests using Selenium and Eclipse IDE.
• Extensively used DB2 and Oracle databases for test data, involved in testing back end jobs using SQL queries in DBVisualizer.
• Experienced in writing complex SQL queries using joins, group by, having clause to retrieve test data to feed in Soap requests.
• Expertise of agile and waterfall testing methodologies and tools such as JIRA, RALLY, Rational Team Concert, Quality Center, etc.
• Experienced in both Unit and Integration testing needs with exposure to data virtualization tools.
• Experienced in using JIRA and RTC to log, maintain and track defects till closure.
• Created test cases, test scenarios and test matrix to perform exploratory testing to meet the deadline of the project for Campaign Management and Third Party Agent squads
• Involved in functional testing for QBE auto and property applications
• Involved in setting up Jenkins Pipeline and configuring them with Bitbucket to run automation jobs in Jenkins for different applications
• Making sure presence of JUnit, Jasmin, JSHint, JSlint, Jacoco, SonarQube, Checkmarx, Checkstyle within pipeline and adding them where those are missing for any application and making sure pipeline is running successfully.

Confidential

Platform: MS Visio, Rational Unified Process (RUP), Rational Rose, MSOffice

Quality / Data ANALYST

Responsibilities:

• Involved in Functional, Integration, Regression and End-to-End testing of the application against user requirements for Auto, Motorcycle and Property.
• Conducting systems/quality assurance/integration testing and documenting test results.
• Using VDS tool for testing renewal transactions, Test Data Management (TDM) to manage test data, Mantis, IBM RTC, JIRA and Application Lifecycle Management (ALM) applications to track and manage defects.
• Developed test cases to cover whole business functionality of the application in ALM Test Plan Module for Manual Execution and mapped them into ALM Requirements Module with the project requirements.
• Involved in Functional, Integration, Database, Smoke, Regression, Web service, End to End testing, User Acceptance Test, Exploratory testing.
• Prepared Test Metrics and Requirement traceability Metrics (RTM) on project level using HP - ALM.
• Utilize Liberty Mutual’s software applications such as - Customer First Policy Administration System and Customer Service Workbench (CSW) to process and view and test policy transactions
• Involved in different SDLC/Testing models “Waterfall”, “V Model”, “Iterative”, “Agile”.
• Executed SQL queries, PL/SQL stored procedures, triggers on back end as a part of rate and premium analysis and data validation
• Executed complex SQL queries including joins, group by, having clause to retrieve required factors and values from the RATABASE.
• Isolated and simplified problems discovered during testing so that developers can fix them easily.
• Involved in Preparation of Test Strategy and Test Estimations & Reviews and Peer Reviews for the same.
• Involved in Planning, Tracking, Monitoring and Scheduling at Module level.
• Involved in “Agile Hardening” which includes sprint pre-grooming and sprint planning.
• Involved in Daily Scrum meeting.
• Prepared Test Scenarios from the Functional requirements / User Stories.
• Analyzed the source data coming from various data sources like Mainframe & Oracle by using TOAD, SQL developer.
• Involved in modifying automation scripts using VB Scripting according to changing project requirements for the existing scripts.
• Carried out GUI, Functionality, Integration and Regression testing using QTP.
• Executed, and customized scripts in QTP Hybrid frameworks using VBScript for web applications and data-driven network systems.
• Performed gap analysis between the “As-Is” model of the legacy system and the “To-Be” model to identify the gaps, logged issues relating to the identified gaps and worked with the SME to get clarifications.
• Gathered data requirements from business users and prepared Functional data requirements documents.
• Worked on Data Mapping documents by identifying sources and targets and provided transformations rules.
• Performed ad hoc Data analysis through UNIX command line
• Write, analyze, review, and rewrite programs, using workflow chart and diagram, and applying knowledge of computer capabilities, subject matter, and symbolic logic.
• Consult with managerial, engineering, and technical personnel to clarify program intent, identify problems, and suggest changes.
• Prepare detailed workflow charts and diagrams that describe input, output, and logical operation, and convert them into a series of instructions coded in a computer language.
• Involved in Debriefing to Peers/ BA’s on testing that will be performed.
• Responsible to identify the Test data and to prepare the dynamic test data scripts using SQL Loader.
• Arranged functional and technical walkthroughs for new joined resources.

Confidential

Platform: MS Visio, Rational Unified Process (RUP), Rational Rose, MSOffice

TEST ANALYST

Responsibilities:

• Successfully handled Publishing, PADES and Rating modules at onsite.
• Understand/ Analyze Requirements/coverage module level;
• Conduct Peer Review/ Review of Test Cases written by other team members;
• Understanding of Requirements from FAW Form Analysis Workbook and business Requirement Document.
• Writing Functional Test scenarios and Test cases for the modules.
• Identify integration points with other modules/systems;
• Demonstrate domain and functional knowledge and interact with the client in order to develop an understanding of the clients’ business.
• To present the walkthrough on the Test scenarios and Test cases creation to the client and business people.
• Prepared test data for positive and negative scenarios to test the application, along with their expected results and established test environment accurate for executing test scripts in collaboration with other test professionals.
• Extensively used Quality Center for logging defects.
• Performed SMOKE testing, Functional Regression Testing (FRT) once FRESH build is received.
• Interaction with SME’s for business test conditions and getting test Scenarios and test cases signed off.
• Prepared Test Artifacts (Test report, Test Specification).
• Prepared Various Test management Status report (Derived from Quality center)
• Test Coverage Report
• Test case creation Status report
• Test Case execution report
• Defect Summary report
• Attend Defect Triage meetings with client.
• To co-ordinate with development team to resolve the issues/defects.
• Interaction with offshore testing team to achieve releases.
• Extensively worked on other tools/SCM used in Project like SharePoint.
• Groomed Testing resources for functional modules, testing protocols used for project.

Confidential

Platform: MS Visio, Rational Unified Process (RUP), Rational Rose, MSOffice

QUALITY ANALYST

Responsibilities:

• Performing various types of testing, such as functional, regression, user acceptance, negative and installation testing.
• Generated test scenarios, test cases and test data. Executed tests, created problem reports.
• Reviewed and analyzed System Requirement Specs (SRS), High Level Requirements (HLR), Detailed Business Requirements (DBR) and design documents under Agile (Scrum) Environment.
• Isolated and simplified problems discovered during testing so that developers can fix them easily.
• Conducted regular team meetings to coordinate the progress or risks and the ways to mitigate those risks.
• Tracked the progress of test cases planning, implementation and execution results.
• Attending Functional Walkthroughs and then writing high level testing scenarios, Integration Test Cases and End to End Test Cases.
• Review of Test Cases developed by other team members.
• Involved in Functional, Integration, Regression and End-to-End testing of the application against user requirements.
• Defect Identification and defect tracking till its closure.
• Published defect reports and defect metrics on daily basis.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system
• Executed SQL scripts for backend data validation. Also, wrote SQL queries involving joins, inner joins, outer joins, left joins, right joins, unions and others.
• Prepared and executed test cases manually for different modules.
• Preparing Test Metrics from Quality Center.

Confidential, CLEVELAND, OH

DATA ANALYST

Responsibilities:

• Worked with business requirements analysts / subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Analyzed the source data coming from various data sources like Mainframe & Oracle.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Assisted in documenting the end-user’s AS-IS and TO-BE business processes (Gap Analysis) to ensure that the system initiatives are met.
• Defined key facts and dimensions necessary to support the business requirements.
• Worked on ETL design for various source systems.
• Involved creating the Data dictionary object using SQL server.
• Performed ad hoc Data analysis through UNIX command line.
• Worked with various OLAP tools for multidimensional data analysis.
• Reviewed all the systems design by assuring adherence to defined requirements.
• Meeting with user groups to analyze requirements and proposed changes in design and specifications.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
• Flat file conversion from the data warehouse scenario.
• Created Fact and Dimension tables in Mart.

Environment: Oracle, SQL, Rapid SQL, OLTP, TOAD, MS Access, Test Manager, Clear Quest, UNIX and Windows, OLAP