SUMMARY

• Around 7 years of IT experience in Quality Assurance for testing Web Services, ETL, Web based, Backend, Client/Server applications both manually and using Automated Testing Tools.
• Experience in Healthcare, Insurance, Web Apps.
• Understanding of complete software development lifecycle (SDLC). Extensively worked with different software development methodologies like Agile, SCRUM, Waterfall, Spiral methodologies.
• Expertise in developing test plans, test cases, test scenarios and test data utilizing business requirements and functional design specifications.
• Expertise in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Expertise in Functional testing, Database testing, Web Service, Integration testing, End to End testing, Security testing, Ad-Hoc and Regression testing.
• Expertise in Automation Testing using Quick Test Pro (QTP), Quality Center, Test Director, Win runner.
• Worked on HP ALM/ Quality Center (QC)/ TestDirector, Rally for organizing Test Cases, Requirements, Test Execution and Defect Management like reporting, tracking.
• Writing tests and test suites for Web Services in SOAP UI.
• Good understanding of SOA requirements and SOA Reference Architecture. Ability to design and execute SOA services functional tests
• Extensive experience in testing and implementing Extraction, Transformation and Loading (ETL) of data from multiple sources into Teradata, Oracle data warehouse using Ab-Initio, Oracle SQL developer, Squirrel SQL client, TOAD, IBM DB2.
• Extensively used SQL queries to perform backend database testing for data integrity.
• Expertise in ETL testing in Verification, Validation, and Transformations of input data comes from text files, XML files, excels.
• Experience in Rational Clear Quest for defect management.
• Expertise in working with XML files.
• Strong working experience in Extraction, Transformation and Load (ETL) of data from Legacy systems using Ab-Initio and Teradata, Oracle SQL developer data warehouse.
• Extensively participated in production shakedown testing.
• Expertise in demo script preparation and giving demos to Business users.

TECHNICAL SKILLS

QA Methodologies: Agile, Scrum, Waterfall and Spiral Methodology

QA Tools: Rally, Quick Test Professional (QTP)Mercury Quality Center 8.2, WinRunner, Test Director

IBM / Rational: Rational Clear Quest.

Operating Systems: Unix, Windows 98/2000/ NT/ XP/ Win 7.

Programming Languages: C, SQL, PL/SQL, XML, WSDL.

RDBMS/Tools: DB2, Oracle, SQL Server, MS-Access, Teradata, TOAD, SQL Developer, Squirrel SQL Client

Other Tools: SOAP UI, WINSCP, LDAP JXplorer

Internet Tools/browsers: Internet Explorer, Chrome, Firefox.

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton CA

Sr. Functional Tester

Responsibilities:

• Analysed requirements for KP RX Benefits, OPCS, Drug load tracks for all 8 regions such as CO, OH, CA, HI,.
• Responsible for Web Services, Functional, ETL, Security, User Interface, Regression, performance testing for OPCS, DRUG, Benefits tracks for all regions.
• Decide the strategy and identify various test scenarios for all the tracks.
• Responsible for test case preparation, load, test data set up, test execution, defect tracking.
• Getting the test data from each region for validating the RX Benefit rules for every plan such as HDHP, HMO, Part D,.
• Preparation of test files for all the tracks as per the test scenarios for functional testing and comprehensive files for performance testing.
• Extensively worked with Web Services Request and Response validations for KP RX Benefits, OPCS, Drug load tracks using SOAP UI
• Performed functional testing of KP RX benefits, OPCS, Drug load web services by validating the third party payer information and Intervention details.
• Performed integration testing between PAS (Pharmacy analytical system), ESB services and EPS systems data flow.
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provide setup help to other team members.
• Extensively worked on ETL by Performing Back end testing using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.
• Worked with Informatica power monitor for status check of all individual and scheduler JOBS and Oracle SQL developer for validating backend data loads. Worked with LDAP JXplorer for User authentication tests.
• Responsible for test management and defect tracking and task management by using Rally.
• Responsible for user story acceptance by writing demo scripts and giving demos to the business users for each of the user stories and make sure those get accepted by solving any impediments involved.
• Participated in daily scrum stand-up calls to resolve impediments that are blocking the user story progress such as data related, access related and bug related issues with developers, QA team, business users and Scrum master
• Participated in weekly review meetings with Team members to keep track of defects and provided update on User Story development, testing progress to the Scrum Lead.
• Also provided daily status, weekly status updates to the Scrum lead.
• Worked closely with development and business teams to resolve issues within tight deadlines

Environment: SOAPUI 4.0,Web Services, Oracle SQL Developer, Informatica Power monitor, LDAP JXplorer, SQL, Squirrel SQL Client, WINSCP, Mercury Quality Centre, Rally, WSDL,XML, Windows, MS Office, Text Pad, WebSphere AppServer.

Confidential, Pasadena CA

Sr. Functional Tester

Responsibilities:

• Analyzed the business requirements and Functional Specs for developingTest Plan and the Test Strategy.
• Created test plans based on the requirements.
• Ensure that all-critical areas are covered in Test Plans created and updated as necessary
• Involved in Client Interactions and worked as a QA SME.
• Prepared test cases for positive and negative scenarios.
• Walkthrough the test cases with business users, developers, project managers and got approvals in every release.
• Prepared test data to meet different test scenarios.
• Performed Functional, Data Validation, Integration, Web Services, Regression, User Acceptance, End to End and security testing’s.
• Extensively worked with XML, text files and performed data validation
• Worked with TOAD, IBM DB2 client to connect to DB2 Database to validate data loading.
• Extensively used SQL queries to perform backend database testing.
• Used SFTP (secured FTP) to transfer files.
• Performed integration and end to end testing between PSP, CARS and Print Vendor (Image Provider) systems.
• Performed SOA / Web Services testing between CARS and Membership systems.
• Worked closely with business analysts and program developers to ensure application development meets to user expectations.
• Extensively worked with HP Quality Center for organizing test cases, requirements and defect tracking.
• ExecutedQTP regressionautomation scripts and reported the defects in QC
• Debugged the test scripts and analyzed the test results in QTP.
• Performed data driven testing using QTP.
• Thoroughly worked in production deployment shakedown testing in every release
• Responsible for Regression testing after bug fixes and verified those fixes.
• Responsible for testing the Production issue after the fix.
• Supported UAT team during the UAT testing period in every release.
• Handled daily defect calls and followed verified, tracked defects with business users, developers, testers and Project managers as needed.
• Reported the daily status of test cases executed/failed and weekly status of the projects to business and development teams.

Environment: IBM DB2, QUARTZ, VIGNETTE, TOAD, Mercury Quality Center 8.2, Ultra Edit, FTP, Java Technologies, Internet Explorer 5.5/6.0, Windows 2000 Professional

Confidential

Responsibilities:

• Created test cases and test plan as per the specifications
• Ensured that all-critical areas are covered in Test Plans and updated as necessary.
• Walkthrough the test cases with business users, developers, project managers and got approvals in every release.
• Created Test Scenarios to validate data from source
• Prepared test data to meet different test scenarios
• Performed ETL testing which consists data validation, data mapping and data transformation testing on the Input data (Text files, excel data).
• Validated the data that was populated in teradata data ware house tables through ETL process.
• Performed Functional, Data Validation, regression and UI testing in every release.
• Performed integration testing between EOB, Health Trans system, Pharmacy systems and print vendor.
• Validated Source and Target data mappings applying various transformation rules and Business Rules.
• Experience in data analysis and data testing and verified fields present in the reports are as agreed in the ETL specifications
• Extensively used SQL queries to perform backend database testing.
• Used SFTP (secured FTP) to transfer files.
• Prepared test data for UAT testing and supported UAT team during files loading, validation process.
• Used Quality Center as the test management tool for the maintenance of the test cases and to track the defects.
• Participated in meetings involving testers, developers and business teams to resolve various issues arising out of the testing process.
• Prepared weekly status reports, execution calendars for all testing modules
• Performed the Smoke testing, Functional testing, Ad Hoc testing and Regression testing of the application.
• Involved Extensively during UAT testing of various functionalities along with the implementation team, resolved the issues and problems.
• Submitted Status and Test Evaluation Reports to Project Lead on daily basis and constantly updated test deliverables.

Environment: Mainframe DB2, Teradata, Mercury Quality Center 8.2, MS-Office, MS Access, Ultra Edit, Ab-Initio, FTP, Windows 2000 Professional, XP, Internet Explorer 5.5/6.0.

Confidential

Responsibilities:

• Worked with the developers and the business users directly to understand the project testing needs.
• Analyzed the business requirements and Functional Specs for developingtest cases
• Wrote and executed the test cases according to the requirements.
• Prepared the test data as per the test cases
• Conducted functional, integration, end to end, regression testing on the AUT (Application under Test).
• Conducted Integration testing between PSP and CARS systems.
• Worked with TOAD, IBM DB2 client for validating data which is in DB2 Database.
• Used SQL queries to perform backend database testing and Audit trail.
• Worked with text, XML files and used SFTP(secured FTP) to transfer files
• Tested critical bug fixes and coordinated with developers in release of bug fixes meeting tight timeline.
• Did performance testing by importing bulk data into the system.
• Supported UAT team during the testing period in every release.
• Used Quality Center as the test management tool for the maintenance of the test cases and to track the defects
• Supported Testing team when executing the test cases.
• Involved in execution of test cases that are written by other team members.

Environment: IBM DB2, QUARTZ, VIGNETTE, TOAD, Mercury Quality Center 8.2,Ultra Edit, FTP, Java Technologies, Internet Explorer 5.5/6.0, Windows 2000 Professional.

Confidential

Responsibilities:

• Analyzed the requirements, Change requests, Issues and created test cases, test data for every release.
• Validated lead, opportunity, Account, contact, issue, security management modules.
• Responsible for membership data load validation in each month.
• Worked with SQL queries to validated NAM (National Account Management) reports.
• Performed Functional, Data Validation, Security, Regression and UI testing in every release
• Extensively worked in production deployment shakedown testing in every release
• Worked with development team to understand requirements for the purpose of developing test cases.
• Used Quality Center for test case management and defects management

Environment: Sales force CRM, Toad 8.0, Oracle 9i, Mercury Quality Center 8.2, MS-Office, SSRS, Sesame, Internet Explorer 5.5/6.0 and Windows 2000 Professional.

Confidential, Indianapolis, IN

QA Automation tester

Responsibilities:

• Analyzed Software Requirements document and Business Requirements document to get a better understanding of the system on both technical and business perspectives.
• Created test plan and test cases using BRD and FRD.
• Conducted Functional, Regression, Usability, Security tests on the AUT (Application Under Test)
• Conducted functional testing and then automated regression test scripts using Win Runner.
• Performed back-end database testing manually and using WinRunner by inserting Database Checkpoints.
• Tested various text-hyperlinks and image-hyperlinks of Home page and different pages using Win Runner
• Performed data driven test to handle the scenarios requiring multiple sets of data.
• Prepared Test Cases that provide a detailed list of conditions under which the system will be tested using Test Director.
• Setup connectivity between Test Director and WinRunner to seamlessly integrate the whole testing process.
• Performed regular backup of the test scripts so the rollback was smooth in case of unforeseen errors during the testing process
• Executed the test scripts to compare the results with the base line data and determine end result of the test
• Utilized Test Director for defect tracking, coordinating the defect resolution process and creating management reports
• Responsible for weekly status updates showing the progress of the automation testing effort and open issues to be resolved
• Attended design walkthroughs with the requirement and development teams
• Followed up, verified and tracked defects with senior developers, QA manager and Project managers as needed

Environment: WinRunner, Test Director, Oracle 9i, Java, JSP, Servlet, JDBC, EJB, WebSphere, SeeBeyond, Aion Rules Engine, Internet Explorer 5.5/6.0, Netscape 6, MS-Office, UNIX, Windows 2000 Professional.

Confidential, Chicago, IL

Sr. QA tester

Responsibilities:

• Designed and developed test scenarios from the Software Requirements specifications
• Participated in meetings involving testers, developers and stakeholders to resolve various issues arising out of the testing process.
• Identified gaps in automation testing by reviewing test cases and comparing them to existing automation scripts to verify and validate existing scripts
• Assisted the QA manager by providing time estimates to determine the hard freeze date
• Performed functional, regression, Usability testing, Involved in User Acceptance testing.
• Extended the testing capabilities of WinRunner by creating custom functions for frequently used test cases.
• Debugged test scripts in TSL by implementing exception handling and inserting breakpoints and watch lists
• Incorporated various GUI, Database, Object and Bitmap checkpoints within the test script, to detect even minor changes in evolving builds
• Executed a cluster of test scripts in batch mode to perform the testing in an unattended mode
• Setup connection between Test Director and WinRunner, so the defects could be publicized and tracked with much more ease.

Environment: WinRunner 7, Test Director, Java J2EE, DB2, WebSphere, SeeBeyond, TOAD, XML, Internet Explorer, Netscape, Windows 2000, UNIX.