International Software Testing Qualifications Board ISTQB Certified

Experience Summary Professional Strengths

• Quality Assurance professional with 5 years of IT experience.
• Experience as an ETL Tester for 3 Years worked in Informatica tool and Data Ware House testing.
• Exceptional analysis skills with ability to transfer needs of business user and stakeholder in to functional/technical requirement in US Healthcare Industry with focus on Provider, Claim Processing, External Claim Pricing, Capitation Care Management Incentive and Trizetto.
• Proficiency in identifying Business Scenario, Creating data flow diagram, analyzing and documenting user stories, writing test plan test scripts.
• Have Back End testing experience for 5 years in Toad application with Strong SQL knowledge.
• Have been experienced in web based application for more than 2 years and worked on web application performance testing.
• Experience in SOA Service Oriented Architecture web based and using Soap UI Application Testing.
• Have been experienced in SR Service Request Quality Assurance testing.
• Experience as a Performance tester in waterfall and Agile Methodology.
• Extensive Experience in functional testing, Back End testing and Regression Testing.
• Experience in coordinating and mentoring offshore and onsite QA.
• Completed Bachelor of Technology B.Tech in Electrical and Electronics Engineering.
• Certified in Academy for Healthcare Management AHM 250 .
• Have been Certified in Six Sigma.

PROFESSIONAL EXPERIENCE SUMMARY IN TATA CONSULTANCY SERVICES

Confidential

Quality Assurance March 2013 Till Date

• Have hands on experience on multiple web application projects, experience in provider manager web application for more than 2 years and worked on governor web application in healthcare projects.
• Leading two Agile team of four quality assurance testers India to achieve current project targets with Onshore Offshore Model.
• Experienced as an ETL Tester for 3 years in Informatica application and worked as a QA Lead in Agile Methodology of testing, have good knowledge on Extract, Transfer and Load in Data Warehouse Testing process with Unix application Knowledge.
• Created full cycle test requirements and testing of Provider Manager Cigna Health care application Connect system to downstream system to Proclaim PMHS for claim processing.
• Have testing experience in Cucumber Automation Scripts in my current Project.
• 5 years experienced in Back End testing with strong SQL knowledge in Toad and Mainframe DB application.
• Participated in Business stakeholder meetings with client and cross regional teams on a regular basis to capture requirements and translate them into Business Requirements.
• Analyze business requirements and user stories to create execute detailed test plan, test case and test conditions for Conversion/Migration Process.
• Have been worked in SOA Service Oriented Architecture web based application with Soap UI application in Healthcare Project.
• Facilitate JAD Joint Application Design sessions to gather customized exchange process documents.
• Write SQL queries for backend testing
• Accountable for effectiveness, quality and timeliness of all regression runs from onshore perspective
• Use Quality Center for repository, reporting and tracking defects, and providing updates on resolved defects
• Use Application Life Cycle Management for repository, reporting and tracking defects, and providing updates on resolved defects.
• Use Rally for Requirement, reporting and tracking defects, and providing updates on resolved defects.
• Interact with DBA's, Developers, Systems Engineers during testing and isolating bottlenecks at different levels
• Responsible for testing of system Functionality and UAT testing for every new built released.
• Responsible for Data setup for various orders and conversion request based on the requirement.
• Have worked as a performance tester in system, Integration and Release testing phases for 5 years.
• Participated in weekly Triage calls with Business other Stakeholders to discuss issues / concerns / status in case of any requirement related issues
• Ran SQL queries to retrieve the data for data analysis
• Review requirements thoroughly to make sure any gaps/unclear areas are answered and obtain requirements sign-off from stakeholders.
• Executed automation code in QTP application for System Integration testing.
• Mobile Testing Experience in Cigna mobile application.
• In Trizetto Pricer application, ECSIF claim file will be received from Proclaim and PMHS then claim file will be send to Trizetto. Compare process will be done for before after file if the segments are matched, payment will be released for that claim.
• Handled various activities of the project like information gathering, analyzing the information gathering, and documenting the functional or business requirements

Confidential

Quality Assurance

• Have worked on BPM portal Web Application projects.
• Prepared of test plans and test cases
• Cigna major application of Health Care Pricing Reimbursement is PWB Provider Work Bench and found many production defects. This application will manage the Provider details and send the claims to downstream system for claim processing.
• Involved in test data creation creation of contract, plan, provider setup
• Involved in writing the test plan and test cases for the business process or application
• External Claim Pricing project and send the payment to Downstream Application Proclaim, PMHS, Trizetto, Viant Multiplan .
• Have found critical defect by writing the critical sql query in all the projects using toad and QMF application.
• Health Care Reimbursement application is Electronic Fund Transfer as per the Provider Payee details it will send the payment to the downstream by daily batch jobs in mainframe application.
• Provided Regular status reports to client lead. Identify problems and brings them to supervisor's attention with sufficient lead-time to avert crisis
• Experienced as an SR Service Request Quality Assurance tester.

Technical Skills

• EFT Electronic Fund Transfer
• Portico Provider Manager

Application

• Toad for Oracle 11.6
• Toad for Data Analysts 3.1
• Mainframe ISPF, DB2, File Aid
• QMF Query Management Facility for Windows
• Informatica Power Center
• WinSCP UNIX Server
• CA Computer Associates WA Workstation ESP - Enterprise Systems Platform
• Soap UI
• As a software Tester I was involved in system testing.
• Understanding the Functional Requirements
• Preparing Estimation based on Requirements
• Preparation of Test plan.
• Identifying the Test Data.
• Preparation of Test Scripts.
• Walkthrough of the Test plan and Test Cases
• Co-ordinating with Offshore Team Customers
• Review of deliverables
• Executing in Functional Testing phase, Integration Testing phase, Release Testing phase and Pfix Testing phase.
• Defect Management using HP Quality Center, ALM and Rally.
• Involved in Smoke, Functionality, System, Integration Regression Testing.
• Preparation of Daily Status Report Weekly Status Report.
• Preparation of Test Summary Report.
• Preparation of Test Metrics Document.
• Extensive involvement in identifying and automating time consuming testing activities to result in efficient and error free testing.
• Preparation of Dashboard report using QC, ALM and Rally tool.