SUMMARY:

• Overall 10 + years of IT experience in complete software life cycle analysis, design, development and quality assurance, quality control, testing Client - Server/Web, Mainframe testing, Middleware applications.
• Authoritatively documented GUI Client-Server and Web testing methodology for successful QA testing, planning, implementation and management.
• Experience with automated and manual QA testing using tools such as Quality Center, PVCS Tracker, WI Data warehouse testing.
• Motivated and industrious with sound business judgment and solid work ethics, Good knowledge in Property and casualty Insurance, FX Trading, Clear quest, UAT, Manual testing.
• Good testing knowledge on Guidewire Insurance Suite.
• Mobile and cross-browser testing
• Good knowledge in Policy life cycle management and Underwriting applications, Data conversion, Data migration and reports validation.
• Authoritatively documented GUI Client-Server and Web testing methodology and Regression suites for successful QA testing, Validating back end using SQL queries and planning, implementation and management Experience with automated and manual QA testing using tools such as QC, PVCS TrackerREST, SOAP UI.
• Mainframe testing using TSO, MVS, CICS, JCL.
• Good experience in Agile testing methodology, Web Services testing, ETL, test automation
• Good knowledge in project coordination
• Good knowledge in Insurance Life cycle.
• Good experience in interacting and coordinating with offshore team
• Having Duck Creek P&C experience 4 years.
• Having Property and casualty experience 7 years.
• Experience in case design and software testing
• Policy life cycle management testing using Guidewire Insurance Suite.
• Claims Processing, Reports generation.
• Expertise in developing and maintaining overall test methodology and strategy, documenting test plans, test cases; editing and executing tests cases and test scripts based on baseline requirements.
• Expertise in ISPF editor, PMS system, Rate test, Mainframe Batch process.
• Participate in the testing of software to ensure the highest level of quality.
• Expertise in middleware, mobile, MDM, ETL, client/server, test automation, and user-interface test efforts
• Manage all phases of testing for assigned components ensuring test plans and test cases are completed and meet business requirements; Work with development teams, investigating and correcting software bugs and deficiencies based on testing results.
• Expertise testing in health care, banking applications; property and causality insurance policy types.
• Good knowledge in Life, Annuities,
• Property and Casualty, and Investments products
• Perform various types of testing, such as functional, regression, user acceptance, negative and installation testing.
• Good knowledge in requirements analysis, estimation, and status reporting
• Good knowledge in Visual Studio 2010/2012 and Team Foundation Server.
• Extensive experience in functional testing, unit testing, integration testing, regression testing, black box testing, white box testing, GUI testing, browser compatibility testing, and load/ performance testing, Component Testing on Windows and Mainframe.
• Good knowledge in FX Trading.
• Expertise in testing online applications for browser compatibility, verification and validation testing, system integration, functionality and regression testing.
• Actively participate with User Groups to perform extensive User Acceptance Test (UAT) and Integration Test (INT); Perform Regressive Design Verification and Validation Test and Data Conversion Validation Test in pre and post-production environments to verify design has been correctly implemented into the system.
• Experienced in setting up Test Bed including in installation and configuration operating systems, test tools, creating accounts and User Groups, Test Data Repository.
• Good experience in Agile & Waterfall methodologies.
• Good testing knowledge Life, Annuities and Investments products
• Good experience in UAT testing involving with Business users.
• Good knowledge in ETL testing.

TECHNICAL SKILLS:

Data Base/OSWINDOWS: UNIX Sun Solaris IBM AIX; MVSSQL DB2; Oracle; Teradata SQL Assistant; File Manager

Testing Tools: ETL/OLAPTest Director, Ab Initio, Quality Center, QTP and SOAP

User Interface tools: Mercury Quality Center, Business Objects; Crystal reportsClear Quest; TFS; Clear Case

IBM Rational Tools: Remedy ticket

PROFESSIONAL EXPERIENCE:

Confidential

Senior QA Analyst

Responsibilities:

• Tools Worked: MS Visual studio 2013, Remedy Ticket TFS, SQL server 2012, Windows server 2012, Visual Studio 2010/2012, Team Foundation Server and Microsoft Test Manager.
• Working on migration projects also program set up and patient intake web applications testing.
• Writing SQL queries and validating the backend data, processing referral files and loading the data in to SQL server.
• Perform Load Testing using Visual Studio.
• Involved in System Testing, Integration Testing, Load Testing, Functional Testing, Backend Testing and UAT testing.
• Writing manual test scripts in TSF.
• Requirements analysis, estimation, and status reporting
• SOX compliance and execution
• Support web services
• Security testing, Browser stack testing
• Testing middleware, mobile, MDM, ETL, client/server, test automation, and user-interface test efforts.
• Use MTM to manage and store test plans and test cases on TFS.
• Use Visual Studio 2012 for code deployment and test management.
• Opening IT issues using Remedy system.
• Defect reviews and test asset validation
• Using the Remedy ticket system assigning the bugs to programmers.

Onsite Test Lead

Responsibilities:

• Tools Worked: IBM Rational Tools, Quality Center, CHIPS
• This project is to provide System Integration Testing to CHIPS (Comprehensive Health Insurance Processing System) - WellPoint system.
• It involves SIT Testing for Claims and Membership area.
• Claims Testing involves testing of benefits and services, limitations for the services.
• Membership involves the testing of new fields in the system and PCP assignment to existing and enrolled new members.
• Performed overall test lead duties for various systems in the project and coordinated, completed the project on time for the implementation.
• Prepared detailed work plan and test strategy document for the various systems.
• Performed SIT Test Lead for various project and coordinated with offshore and completed the project on time.
• Defect reviews and test asset validation
• Supported end user for issues; developed and executed data conversion test cases.
• Involved production issues and worked with end user to resolve the issues.
• Involved data validation and data conversion testing modules.
• Conducted daily testing meeting for all the test leads for tracking the status and discussing issues
• Conducted defect triage call to discuss on the opened defects and their impacts, work-in-progress status.
• Handled 6 projects simultaneously and completed successfully within the deadline.
• Tested various benefits and services for the members and providers.
• Scheduled and provided the walk through to the customers for the test scenarios prepared.
• Prepared test plan and TESD (Test Evaluation Summary Document) for various projects.
• RQM, CQ, ReqPro, RFT.

Sr. QA Analyst

Responsibilities:

• Tools Worked: Mercury Quality Center; TFS; SSIS; Oracle.
• Extracting the data from the source system (database) as per the requirement using SAS Tools.
• Validating and cleansing the data.
• It’s a weekly report, business require the report with historical information.
• Creating DI jobs as per the requirement to read the external files into SAS.
• Extensively used the DI-Studio transforms for all the data manipulations.
• Case design and software testing
• Defect reviews and test asset validation
• Involved in deploying/re-deploying the jobs & scheduled the flows in Management Console
• Worked on ASPER application.
• Closely interacted with the business system analysts and was involved in the development and documentation of system test cases based on the functional system requirements provided.
• Wrote manual test cases, test scripts and user roles using TSF.
• Used Test Director in order to maintain and execute system, integration and Regression Test cases.
• Was involved in the creation of test data based on the system design and the FSR’s
• Executed the Ab Initio jobs deployed as wrapper scripts for loading the test data into the target database.
• Develop detailed test plans from use cases and develop test cases for Functional, Integration, System, Regression and User Acceptance Testing.

Test coordinator /QA

Responsibilities:

• Tools Worked: Mercury Quality Center; Ab-Initio; Teradata SQL Assistant; UNIX;
• Worked as a part of the CDW testing team in Confidential supporting them for the Data Warehouse Project.
• Closely interacted with the business system analysts and was involved in the development and documentation of system test cases based on the functional system requirements provided.
• Used MQC for creating test sets and keeping track of the system and integration test cases execution.
• Worked on creating test data using the UNIX text editors and also used the Affinium Campaign tool for data entry.
• Executed the Ab Initio jobs deployed as wrapper scripts for loading the test data into the target database.
• Wrote DB2 SQL queries to query the target database (DB2 on MVS) and compared the expected results with the actual results for data validation.
• Tested FX Trading application.
• Supported the extraction, transformation and loading process using Ab Initio for the data warehouse from various heterogeneous sources.
• Involved in the process of debugging and reporting errors in case of script failure and analyzed the rejected data for finding the cause of data reject.
• Worked closely with the development team for resolving the open defects.
• Involved in creating and sending out the daily Test Execution Status Report to capture daily progress.

Sr. QA Analyst / BSA

Responsibilities:

• Tools Worked: Oracle; Clear Quest; Quality Center; SAP; Java; PVCS Tracker; Tera database
• Esurplus is a new web based underwriting application.
• The system will quote, bind, issue the policy; this is primarily data capture application. The application writes different types of business, such as Property and Casualty and Surplus Lines of Business.
• The application contains New Business, Renewal, Legacy Policy Information; billing information is stored under SAP application; the application contains 1500 forms.
• Wrote the test cases and test plans; executed test cases; identifying and documenting the issues on PVCS tracker; worked closely with Development Team resolving any discrepancies.
• Functioned as a Lead over offshore testing team.
• Documented issues and attended daily status meetings; discussed the issues, problems and solutions.
• Tested policy life cycle, New, Renewal and Legacy policies; executed the test cases in UAT, production environments.
• Performed Duck Creek Testing.
• Testing Life, Annuities,
• Property and Casualty, and Investments products
• Non-functional test planning and execution
• MDM data element testing on masked and scrubbed data
• Testing P&C Application using Guidewire Insurance Suite.
• EDI Experience with Perfecto Mobile, IBM DB2, Eggplant tools and Property and Casualty products
• Tested full range of property and casualty lines of business and claims types.
• Tested Duck Creek Claims applications.
• Tested all the modules including New business, Renewal business using Duck Creek.
• Tested P&C LOB (General Liability, Professional Liability, Property, Commercial Auto, Umbrella, Inland Marine, etc.) and in specialty lines.
• Back end validation testing; develop detailed test plans from use cases and develop test cases for functional, integration, system testing, Regression and user acceptance testing.
• Gained extensive knowledge from Submission to Renewal and Cancel and Reinstate in Lexis.

Sr. QA Analyst / BSA

Responsibilities:

• Tools Worked: Mainframes; PMS; POS; Test Director; DB2; SQL
• Worked PMS v4 Bypass Renewal project; Validated Auto, WC policies renewal generation in PMSV4.
• Used TSO, ISPF, CICS environment; executed SQL and PL/SQL on DB2 database.
• Bypass renewal phase 1, created test plans and test cases; involved in Integration and UAT Testing.
• Created test requirements in TD 8.0.
• Worked in the business process of reviewing the data model for the various data marts.
• Responsible to prepare the BA check list for the development, UAT and production implementation.
• Life, Annuities, and Investments products tested
• EDI Experience with Perfecto Mobile, IBM DB2, Eggplant tools and Property and Casualty products interacting and coordinating with offshore team
• Property and Casualty, and Investments products
• Worked with business teams to determine the data dependency and data consistency.
• Creation of mappings using Visio diagrams, Rational Unified Process with Rational Rose, Data Modeling for data marts and transformation rules for ETL process.
• Detail design for mappings and reusable business process.
• Gained extensive knowledge from Submission to Renewal process in PMS v4.
• Guidewire Insurance Suite.