SUMMARY:

• Over 10 years of professional ambidextrous experience in IT industry as a System Analyst, QA Engineer, and Business Analyst. Experience in creating and analyzing business requirement/specification documents, developing test plans, defining test cases, developing and automating test scripts.
• Skilled IT Professional with diversified specialization working with Healthcare, Insurance, Automobile, and Telecom industries in traditional and E - commerce consulting domains.
• Followed Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) methodologies in every phase of Quality Assurance Life Cycle (QALC).
• Quality Assurance: Experience in using Mercury Interactive Tools (Win Runner, Quick Test Pro, Load Runner and Quality Center), Itko Lisa, Rational suite (Clear Quest), JIRA, QAComplete.
• Experience in using QTP Integrated Environment (Step Generator, Synchronization, Actions, Recovery Scenarios and Methods etc.).Experience in Descriptive Programming using QTP.
• Good exposure to BDD with Selenium Cucumber.
• Experience in developing Test Plans, Test Cases, Automating Test Scripts, using Business requirements and Testing Strategies.
• Extensive experience in GUI, Functional, Integration, Regression, User Acceptance, System, Performance, Load, Stress, Smoke, Negative, White Box, Black Box, and End to End Testing.
• Experience in working with Mercury’s Business Process Testing, Waterfall, and Agile Testing Methodologies.
• Experience in analyzing Business Specification documents.
• Experienced in management of SOA related services using SoapUI.
• Expertise in testing applications developed in diversified technologies such as ASP.NET, VB.NET, C#, J2EE, Java, and JSP. Programming skills like VB Script, C, C++.
• Good knowledge of RUP methodologies and Proficient in using the rational tools such as Rational ClearQuest and Rational Test manager.
• Experienced in Back-End Testing and Validating data in Various Feeder Systems using SQL.
• Very good Confidential Bug Reporting and Bug Tracking using various tools (Test Director, JIRA and ClearQuest, QAComplete).
• Created installation, operation, and maintenance manuals; software user manuals; business system procedures; and technical proposals.
• Excellent Written/Verbal communication skills.
• Good presentation, communication and interpersonal skills.

TECHNICAL SKILLS:

Testing Tools: Quick test professional 10/9.5, HP Service Test 9.53, Load runner 9.1, Mercury Quality center/Test Director, Rational Clear Quest, Selenium RC, Itko Lisa 5.0.28, SoapUI 4.0.1.

Languages: Java, C,C++, VB.Net, SQL and PL/SQL

Scripting Languages: JavaScript, VB Script, TSL, Unix Shell Script (Korn, Bash, C-Shell), Perl

Markup Languages: HTML, XHTML, XML, DHTML, HL7V2.3, HL7V3, HL7GBO

Methodologies: OOA/OOD, Unified Modeling Language (UML), Waterfall, Agile iterative development methodologies, Total Quality Management (TQM), IEEE Standards.

Databases: Oracle 10g, 11g, 12c, MySQL 5.0, MS SQL Server 2005/2008/2014 , IBM DB2, UDB 8.1/7.2, Netezza

Operating System: Windows NT/2000, Windows 95/98/2k/XP/7, UNIX (Sun Solaris, HP-UX, IBM AIX, Linux (Ubuntu, RHEL4), Remote Desktop Connection, PuTTY.

IDEs: TOAD, SQL Developer, SQL * Plus, Tera data SQL Assistant 7.1, Rational Quest, Aginity.

Architecture: OOP, SOA, Client/Server, Web Server/Application

Web Browsers: Netscape 4.72/4.73, IE 4.x, 5.0, 5.5, 6.0, 7.0.

Infrastructure: PerlDesk, Wiki, XMLSpy

Source Control: CVS, Clearcase, SVN, Perforce

BUG Tracking System: DDTS, Rational ClearQuest, JIRA, BugZilla, Test Director, QAComplete

Software and Tools: Microsoft Office Suite, Microsoft Project, Microsoft Visio, MS Power Point, MS Share Point, Microsoft Visio, MS Word, MS Excel, Adobe Photoshop, Apache Tomcat, Adobe Photoshop, Macromedia Freehand.

PROFESSIONAL EXPERIENCE:

Confidential, Addison - TX

Sr. QA Engineer / Test Lead

Responsibilities:

• Participated in gathering Business Requirements to prepare Test Plan, Test Cases and attended Review meetings to better understand application needs.
• Worked with internal/external stakeholders to understand business needs and objectives.
• Created Test Plan, Test Scenario and Test Data for New Projects, Enhancements and/or Change Requests. Created Test Strategy and Test Result Summary documents, worked with Test Managers for Approvals prior to go-live.
• Leveraged Test Management Module of QA Complete (Smart Bear) for Test Cases, Test Sets, and Test Execution; Defect Management Module for defect tracking. Used CA Agile Central (Rally) to track defects for higher visibility.
• Expertise in QAComplete application; provided trainings to team members.
• Performed Sanity, UI, Functional, System, Integration, End to End, and Regression Testing in different tiers/environments. Test Driven Development (TDD) and Risk Based Testing for projects with tight timelines.
• Coordinator for Integration and End to End testing with multiple teams for upstream and downstream applications.
• Coordinated technology upgrades/migrations - Oracle, Datastage, Cognos, Tableau, and Windows, Netezza Oracle.
• Build POC (Proof of Concepts) and Mockup reports based on initial requirements.
• Assess business impact and severity of Incident Management tickets by performing detailed Root Cause Analysis (RCA) to avoid future problems. Performed gap analysis by collaborating with different projects.
• PHI Testing experience following HIPAA compliance for Data Security.
• Excellent understanding of HL7V2.3, HL7V3, and HL7 GBO messages. Validated v2.3 to v3 and v3 to GBO conversions. Created and modified HL7/XML messages as per test scenarios and performed functional and regression testing.
• Used IBM InfoSphere Fast Track to refer to mappings between HL7V3 and Database (Staging/Target table) fields.
• Used QDIB and AppWatch to drop/re-process the messages to the queue.
• IBM InfoSphere/DataStage: Validated mappings and extensive ETL transformations between source feeds and staging/target tables by creating/mocking up data based on business rules & requirements. Created/Executed SQL Scripts as part of Data Validation Process in multiple environments (DEV/QA/Pre-Prod/Prod).
• PEGA BIX file validation, transformation, ingestion into Netezza Database.
• Self capable of running ETL sequence/jobs without being dependent on development team.
• End to End Testing (Order to Report): Lab System HL7 ETL Database BI Reports.
• Developed and Executed SQL queries, functions, and triggers to perform the backend, data driven testing, complex stored procedures, KPI Extracts, and BI Reports validation for OADM, ODS, ODS to OADM Copy, CSDM, EDBR and Standardization Projects.
• Used SQL Developer, MS SQL Server 2014, and Aginity to access different databases (Oracle - Exadata, SQL Server, and Netezza).
• Validated Cognos and Tableau Reports with extensive calculations and business rules from both UI and backend perspective including dashboard style reports.
• Validated Partitioning and Purging of Data for different data marts.
• Experience testing legacy applications (QLS, QMPS, QPS) developed on MUMPS. Accessed using Power Term, executed automation scripts for regression testing.
• Participated in datamodel, architectural and solution sketch meetings with the team.
• In the spirit of true agile, attended typical standup, sprint planning, sprint demo and retrospective meetings. Used CA Agile Central (Rally) to burn down the progress on daily basis.
• Acted as a backup to scrum master for facilitating standup, sprint planning, sprint demo and retrospective, lessons learnt meetings.
• Create User Stories and tie to respective Features, Initiatives. Chunk the requirements by breaking them down to multiple User Stories in order to demonstrate the progress of each sprint.
• Held defect triage meetings to resolve critical show stopper issues for seamless releases.

Technologies: Cognos 10x/11x, Tableau, CA Software Manager, Java/J2EE, Java script, Oracle, Exadata, Netezza, JDBC, QAComplete, SQL Developer, Aginity, HL7V2.3, HL7V3, HL7GBO, XML, HTML, XML Spy, Agile Central (Rally), MS Excel, MS SQL Server, AppWatch, IBM InfoSphere 9.1/11.5, Remote Desktop Connection, Citrix.

Confidential, Madison - WI

Sr. QA Engineer / Analyst

Responsibilities:

• Analyzed the Business Requirement Document (BRD) to prepare Test Cases based on the Test Plan and attended Review meetings to better understand the applications.
• Participated in Walkthroughs with Team lead, Business Analyst, Architect, Project Manager and the Development team to discuss the outstanding defects and scope of change requests.
• Performed Smoke, Functional, Integration, Negative and Regression Testing. Also performed testing in Development, Integration, QA, Performance and Production tiers.
• Created test cases and test suits, test scenarios for both manual and automation testing using Excel sheet and AmFam standard templates.
• Created Test Plan and Test Strategy for New Projects as well as Change Requests.
• Used JIRA to log and track the defects.
• Performed Web Service/SOA testing using SOAP UI for CP (Customer Portfolio),CDH (Customer Data Hub), PPS (ProductPortfolioService), BPS (BillingPortfolioService), and CPS (ClaimsPortfolioService).Also performed Backend Testing to validate the results.
• Performed Functional and Integration Testing on both GuideWire Policy Center and Billing Center. Also performed SIT and AIT Testing.
• Written and executed SQL queries to access the database as a part of data driven test.
• Executed Lisa Scripts by using ITR (Interactive Test Run) option which is incorporated in LISA.
• Utilized different types of Assertions (XML, HTTP and Database ) in LISA for better Performance and Stress testing.
• Wrote many Test Suites of LISA which internally has group of test cases, Filters, Assertions, Data Sets.
• Involved extensively in web services testing using LISA.
• Utilized LISA based Http Proxy Recorder and DOM Events Recorder to test GUI based Applications.
• Analyzed Performance Summary Report, Functional Test Summary Report and Error Reports generated by LISA.
• Performed Mainframe testing on Legacy Systems such as AutoPlus and PropertyPlus. Also automated Mainframe scripts using Micro.
• Created/Modified XMLs as per the test scenarios. Performed functional testing using XMLs and Test Data in different regions/legs.
• Used HermesJMS to drop the messages in the queue.
• Created test data for various projects as per business needs.
• Tested ETL Informatica Mappings for various projects (Vantage, ABEST and Phoenix) and worked with Staging area to validate the data with SQL Queries.
• Verified that the ETL Data is transformed correctly according to the Business Requirement Document. Validated the results with both Test Data and Real Data.
• Created/Executed SQL Scripts as part of ETL Data Validation Process.
• Done extensive Data validation by comparing data values against downstream sources to confirm data retrieval and mapping.
• Ensure entrance and exit criteria for the QA test phases are completed.
• Co-ordinated with various teams as per the project need.
• Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data.
• Used WinSQL, SQL Developer and Informatica MDM to access different databases (Oracle, DB2).
• Followed Agile Methodology and attended Scrum meetings. Used Rally to burn down the daily/sprint tasks.
• Regularly met with team leads, other team members and developers to evaluate the project progress and outstanding defects.

Technologies: Itko LISA 5.0.28, SoapUI 4.0.1, CA Software Manager, Java/J2EE, Java script, Oracle, DB2, JDBC, JIRA, WinSQL, SQL Developer, Informatica MDM, Mainframe, Hermes JMS, XML, HTML, XML Spy, Rally, Agile, MS Excel.

Confidential, Raymond - OH

Sr. QA Analyst / Technical Writer

Sr. QA Analyst - Responsibilities:

• Analyzed the Business Requirement Document (BRD)and Functional Specification documents (FSD) to prepare Test Cases based on the Test Plan and Use Cases and attended Reviews meetings to better understand the applications
• Participated in Walkthroughs with Team lead, System Analyst, HCD Designer, Project Coordinator and the Development team to discusses the outstanding defects and scope change requests
• Analyzed test data and Conducted Database or Data driven testing under certain business rules for data population.
• Performed Smoke, Functional, GUI/design, Black Box, End to End, Navigational and Regression tests during the execution phase.
• Sole performance of API testing with different sub-systems as a part of Backend test.
• Written, Uploaded and Executed the Functional Test cases using HP Quality Center.
• Prepared and Executed Test Automation scripts using QTP.
• Involved in using QuickTestPro for some web-based applications for End to End Testing.
• Involved in writing the Project test plans for this test effort by using Honda Standard Templates and attempted in collecting the team meeting minutes.
• Used Rational Clear Quest Bug Reporting tool to log the defects and reporting purposes for developers to fix the defects.
• Written and executed SQL queries to access the database as a part of data driven test.
• Suggested/Created application scope Changes in this release.
• Tested applications like G2, SDP, and OMS system on new releases and updates.
• Followed Agile Methodology and attended Scrum meetings.
• Worked very closely with the Development team to analyze the application Confidential theBack end level and to describe the defects.

Technologies: Quality Center 10, QTP 10, Java/J2EE, Javascript, Bea Web Logic 10, Jdk 1.6, Oracle 10g, JDBC, RationalClear Quest, CARE/TLG Clients, Unix, Sun Solaris 10, Windows XP, Windows 2003 Server, Windows NT, Adobe Photoshop, Microsoft Visio, MS Word, MS Excel, Macromedia Freehand, XML, HTML.

Confidential, Richardson - TX

QA Analyst

Responsibilities:

• Reviewed all the requirements and use cases for the entire application.
• Involved in writing Test Plan for the testing effort of the PPA tool.
• Created test cases and test plans to perform end to end functional and regression testing using Quality Center.
• Performed transformation of manual test cases and use cases in to automated test procedures via HP Quick Test Professional, and was responsible for delivery of test-automation plan.
• Generated reusable, maintainable test-data repository, valid for environment specific and independent testing process via QTP.
• Performed End-to-End automated testing of business-driven workflow using QTP and custom regression data-repository.
• Conducted functionality testing manually for CSR App features related to Wired/Wireless customers.
• Performed Static testing, Unit testing, String testing, Regression Testing, Negative Testing and Functional integration testing (FIT), System Integration testing (SIT) and Client Acceptance Testing (CAT).
• Gathered requirements and prepared detailed load test plan for WSDL Web services testing.
• Involved in extensive testing of SOA testing component.
• Used SOAP UI to test WSDL file.
• Wrote test scripts for testing the LDAP Server.
• Tested SOAP 1.1/1.2 based PPA services which acts as interface between CSR deployed on External Server and Custom PPA App.
• Involved in monitory CPU Utilization, Memory usage, Java connection times for Web services load testing.
• Involved in authoring scripts for load testing of Web service using custom request.
• Tested ETL Informatica Mappings for Confidential &T Customer Data and worked with Staging area to validate the data with SQL Queries.
• Done extensive Data validation by comparing data values against downstream sources to confirm data retrieval and mapping.
• Ensure entrance and exit criteria for the QA test phases are completed.
• Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data.
• Performed the Backend integration testing to ensure data consistency by writing and executing SQL queries.
• Created high level and detailed level Test cases for system integration testing to test Optimum business functionality.
• Involved in performing Load and Stress Test on the application and server by configuring LoadRunner to simulate hundreds of virtual users.
• Performed functionality and regression testing on the new builds using LoadRunner.
• Documented the entire testing process, test cases and test results.
• Regularly met with team leads, other team members and developers to evaluate the project progress.

Technologies: Quality Center 9.2,QTP 9.5, LoadRunner 9.1, Java/J2EE, Web Services, SOAP 1.1/1.2, WSDL, Xquery, CSR, Unix, Solaris 10, VBScript, Oracle, DB2, SQL Server, MS Word, MS Excel, Internet Explorer, XML, HTML.

Confidential, Stamford, CT

QA Tester

Responsibilities:

• Analyze the test requirements and created Test Cases as per the requirements.
• Developed various test cases for different versions and applications using Test Director.
• Involved in Sanity Check Test/Smoke Test, whenever there is a new build and was responsible for communicating the results of new build to the team.
• Involved in Back End testing, tracking the status of the order placed by connecting to different Legacy systems.
• Developed SQL Queries to perform Back End Testing.
• Performed Functional, System & Regression testing.
• Involved in creating Project Plan/Test Plan for different applications, helped in updating the automation status.
• Created test cases and test data as per the Business needs.
• Identify research, realize, investigate, analyze, define and document business processes and Use Case Scenarios.
• Worked with the UAT team to validate that the developed application will meet the business requirements.

Technologies: Manual Testing, Test Director 8.0/7.6, DB2, Unix, Oracle10g/9i, VBScript, SQL Server, EJB, Web Services, XML, J2EE,WebLogic6.1, MS Word, MS Excel, Internet Explorer.