SUMMARY:

• Six years of IT experience with focus in Manual and Automated Software Testing utilizing tools such as Unified Functional Testing (UFT)/Quick Test Professional (QTP), Selenium and ETL testing.
• Exposure to various types of Software Development life cycle (SDLC) methodologies such as Waterfall, and Agile (SCRUM), Test Driven Development (TDD), Software Testing Life cycle (STLC), and Defect Life cycle.
• Good experience with Extract, Transform, and Load (ETL) process in database operations.
• Extensive experience in database testing and testing backend applications by writing SQL statements.
• Strong experience in object oriented, Automating Web Application Testing using Selenium WebDriver with TestNG framework.
• Experience in Data driven Testing, cross browser testing and Parallel Test execution using Selenium WebDriver, TestNG and selenium Grid.
• Hands on experience and good knowledge in various testing frameworks like Keyword Driven, Data Driven and Hybrid Frameworks.
• Good experience with SQL Server Reporting Services (SSRS).
• Solid experience in developing, executing and maintaining the Test artifacts - Test Strategy, Test Plans, Test Cases and Test Summary Report.
• Ability to find defects fast, report them and follow through to resolution.
• Ability to learn new technologies and operates well within a team.
• Ability to manage multiple projects simultaneously, able to prioritize and meet established deadlines.
• Ability to communicate effectively both orally and written and provide status updates to team leads and managers on time.
• Experience with offshore coordination of testing activities.
• Excellent analytical and problem-solving skills and ability to adopt to change; good interpersonal skills, highly motivated, ability to work independently, quick learner and excellent team player; ability to meet tight deadlines and work under pressure.
• Analytical problem solver, critical thinker, attention to details, with self-initiative and fast learner.
• Experience working in ITIL framework for Change Management, Configuration Management and Release Management.
• Extensive experience in database testing and testing backend applications by writing SQL statements.
• Excellent in creating pivot tables and modify spreadsheets to achieve analytical goals

TECHNICAL SKILLS:

Programming Languages: Java, C, COBOL, HTML, CSS

SDLC: Agile, Waterfall

Databases: SQL Server, Oracle, DB2, MS Access

Reporting: SQL Server Reporting Server (SSRS)

Operating System: Mainframe, Windows 7, Linux

Testing Tools: UFT, QTP, Selenium, Quality Center, ALM (Application Lifecycle Management), TestNG

Other: Eclipse IDE, Web Services, Soap UI, Nlyte, TOAD, HP Service Manager, Lotus Notes, SharePoint, Visio, Word, Excel, PowerPoint

Domain Experience: Insurance (Home, Life, Auto)

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, IL

Automation Engineer

• Customized and enhanced Test Scripts defining various Checkpoints, Synchronization points, Input value, Output value, Parameterize Test, Define Regular expressions, Recovery Scenarios, Optional Steps using UFT/QTP.
• Performed Functional and Regression testing using UFT/QTP.
• Developed Automated Test Scripts for Functional Testing using UFT.
• Performed testing for broken links and tested functionality on cross browsers.
• Created scripts for Accounting Screen, Client N/A Add Transaction, and AIMS Deliver Screen in QTP and ran scripts whenever it is needed.
• Entered data in RPS screens in Mainframes.
• Created Test Plans for Integration & Thunderhead products.
• Executed Test Cases and raised defects.
• Involved in integration testing of Firelight, Resonant and AIMS (Mainframes) testing.
• Created Apps in Firelight and delivered in Resonant for Relius piece of E2E Testing.
• Created web based for Life product scripts in UFT.
• Executed Test Cases for Day2 Items raised defects
• Involved in developing Test Cases from business requirements.
• Analyzed requirement documents to develop and executed Test scripts and documented Test Cases corresponding to business rules.
• Used ALM (Application Center Management) to prepare Test cases, procedures and Requirements Traceability Matrix.
• Verified the data in the reports with Claims and Admin tables. Involved in back-end testing of the application.
• Compared the data in the Multiple Policy Summary reports in Mainframe with back-end data using SQL and provided the analysis to developers that helped save some of developer’s time.
• Used SQL to perform data mapping and backend testing. Also documented all the SQL queries for future testing purpose.
• Tracked bugs using Quality Center/ALM and performed Regression Testing of the entire application once the bugs are fixed.
• Identified numerous user interface and Functionality defects and caveats in the Functional requirements that were addressed prior to User Acceptance Testing (UAT).
• Assigned web based system testing which included all of the functionality of existing mainframe system delivers today plus enhanced vital functionality.

Tools: UFT/QTP, ALM, SQL Server, Excel, SharePoint

Confidential, Bloomington, IL

Data Center Information Management

Data Analyst

• Created drill down, drill through, sub and linked reports using SQL Server Reporting Services (SSRS) as well as managed the subscription of the reports.
• Generated multi parameterized reports in SSRS allowing users the ability to make selections before executing reports in Nlyte.
• Created reports for duplicate Asset names, RFID locators it helps to manage and track assets in Data Center using SQL Report Builder.
• Actively Participated in Team meetings and discussions to propose the solutions to the problems.
• Analyzed Business Requirements for tooling changes for Critical Configuration Items of HP Service Manager and derived them into Functional, Technical and Non-Functional Requirements.
• Developed Context Diagrams, Use Cases, Event Lists, Process Maps, and Sequence Diagrams for Tooling Changes of HP Service Manager.
• Experience working with DCIM (Data Center Information Management) tool Nlyte that virtually creates the data center layout from the floor plan.
• Have in depth experience in Nlyte tool to Managed Incidents/tickets raised by Acuity team of Data Center in HP Service Manager.
• Used SQL queries to perform data mapping and verify data.
• Prepared UAT Test plans and conducted UAT testing with the business users.
• Coordinated Risk, Issue and Dependencies on TMO Projects. As the Risk/Issue Coordinator of the effort, prepared monthly status report and meet with individual projects to track the status and escalate high priority issues/risks to the Program Manager.
• Ensured a structured and successful approach for identifying, mitigating, and managing project risks was utilized in all projects.
• Created Transition Plans for the projects that has ongoing support.
• Gathered Requirements from Business users located in Houston and Nashville.
• Prepared Business Requirements/ Functional Specification Document for Life and Retirement Claims Enhancement Phase 4 applications. (PBI Death Match and Multiple Policy Search).
• Prepared Process Flows such as Business Process Diagram, Use Cases, Data Requirements, Non-Functional Requirements, and Compliance Requirements.
• Developed Test Plans, Test Scenarios, and Test Cases for Life and Retirement and Claims Enhancement Phase 4 applications.
• Conducted regular meetings with Business Partners and Developers.
• Coordinated with Developers (Onsite and Off-shore) to explain the requirements and assist them in preparing Technical Specification documents.
• Verified the data in the reports with Claims and Admin tables. Involved in back-end testing of the application.
• Compared the data in the Multiple Policy Summary reports with back-end data using SQL and provided the analysis to developers that helped save some of developer’s time.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL tool
• Wrote SQL, PL/SQL for implementing business rules and transformations.
• Created test cases and completed unit, integration and system tests for Data warehouse
• Joined Tables Originating from Oracle.
• Wrote test cases, test conditions for Various Derivatives and Subject areas.
• Used SQL to perform data mapping and backend testing. Also, documented all the SQL queries for future testing purposes.
• Logged the defects and make sure that the defects get resolved on time by coordinating with developers.
• Involved in User Acceptance Testing (UAT) of the application.
• Created Test Summary report and provided it to Managers.

Tools: SQL Server Reporting Services (SSRS), Nlyte, HP Service Manager, Excel, SharePoint, Mainframe, Informatica, Oracle, Quality Center, PMPI, Lotus Notes

Release Test Analyst

Confidential

• Gathered Business Requirements of projects in each Development Centers (Functional Areas) and analyzed them to develop the scope for End-to-End Customer Experience Test for Life Products.
• Conducted regular meetings with Test Managers/ Test Leads of Development Centers (Functional Areas) and provided updates on the scope to Release Manager.
• Created End-to-End Customer Experience Test Scenarios of Life Products through different channels such as Agent, Customer, and Customer Care Network (CCN) on different devices (Tablets, iOS, Android) and different browsers (Safari, IE, Chrome, Firefox).
• Developed Test Plans and created test cases in TestLink for Customer/Agent/CCN for Quote, Application, Purchase and LUSV (Life Underwriting Status View).
• Identified the test cases to be automated for the platform migration to Integrated Customer Platform (ICP) and implemented test automation framework using Selenium WebDriver.
• Performed Regression testing of Life products using Selenium WebDriver.
• Prepared Request and Response XML for all the test scenarios and executed SoapUI test cases.
• Created Test Summary report and provided it to Test Managers.
• Provided Test Support during the Defect Facilitated sessions.
• Coordinated the Functional checkout activities with Development Centers across several Test Environments. Updated Functional Check out Tracker of Release and Development Centers.
• Performed Functional Testing, Unit Testing, Integration Testing, Exploratory testing, User Acceptance Testing (UAT), and Regression testing of the new Integrated Customer Platform. Executed test cases and compared the actual results with expected results.
• Performed Regression testing of Life products.
• Gathered test data requirements that are required for end-to-end validation of the application.
• Used SQL to perform data mapping and backend testing. Provided data results to developers that helped in quick resolution of defects.
• Performed shake down activities on newly deployed builds.
• Involved in Functional check out of the application after every new deployment. Raised defects in Trac and worked with Case Managers and Developers to resolve defects in timely manner.
• Used Policy Health check tool to trouble shoot the issues after policy submission and if the policy has been replicated in TP (Technical Platform), Haplex and Life Legacy systems.
• Analyzed the impact of Risks and Issues of projects in Development Center on the Release testing.
• Used HttpWatch tool to capture defect logs on Java based application and provided those to developers.
• Coordinated on site and offshore testing. Assisted in preparation and execution of test cases.
• Conducted virtual device testing using Perfecto tool as well as direct testing on different devices and on different environments.

Tools: Selenium, SoapUI, Web Services, Trac, Service Manager, SharePoint 2010, Lotus Notes, DB2