SUMMARY

• 13+ years of experience in QA Manual and Automation Testing.
• ETL and Data Testing, Webservice Testing and Cloud(SAAS) Testing.
• Working as Test Leadfor the past 3+ years.
• Domain expertise: Mortgage, Lending, Banking, Insurance, Healthcare Claims and Telecom Billing, Government, CRM.
• Well versed Agile and Scrum, Waterfall Methodologies in all the Phases of SDLC and Software Testing Life Cycle (STLC).
• Domain expertise: Mortgage, Lending, Insurance, Healthcare Claims and Telecom Billing, Government, CRM.
• Expertise in using Selenium WebDriver API to automate tests on cross browser and cross platform environment.
• Sound knowledge on Object Oriented Programming concept and Java Language. Used TestNG framework to run unit test and Maven to build the Project.
• Used Appium tool to testautomationtest scripts on both IOS and Android platforms for native andmobilewebsites onmobiledevices
• Implemented simulator forMobileApp Testing in Android Platform using APPIUM.
• Established the Environment set up for Mobile Automation using AppiumTool.
• Proficient in Mobile App testing oniOS and Android Platforms.
• Worked extensively with SoapUI, TFS, Version One, Selenium, ALM, Quality Center Clear quest, JIRA, Cloud(SaaS), TestNG,Maven,Jenkins, Cucumber, Web Services
• DevelopedPythonscripts to automate the test cases.
• Involved in System Testing, Integration testing, ETL testing, Compatibility, Pre - Release testing, Data Base Testing, Functional, Regression Testing.
• Knowledge of health information and health care services regulatory environment including HIPAA, Medicaid/Medicare, EDI and XML.
• Good understanding of ETL testing principles and concepts.
• Also worked ETL Test Plan, Test Cases, Test Results reviews and Reports, Status reports, validating the batch jobs inETL run during system, integration and UAT test runs.
• Coordinated with offshore testing teams resides across various locations.

TECHNICAL SKILLS

Testing Tools: QuickTestPro,ClearCase, SoapUI, CA Lisa, Rally, Version One, SOAP UI/Restful,Selenium,Jenkins,Maven,GitHub,TestNg,Cucumber

Defect Tracking Tools: Quality Center, Clear Quest, PVCS, Jira, ALM

Scripting Languages: VBScript, JavaScript, JASON, Shell scripts

Operating Systems: UNIX, Windows 95/98/2000/NT/XP

Database: MS SQL Server, Oracle, Teradata, My SQL, DB2.PL/SQL

Languages: HTML, SQL, XML, C, Java, Shell Programming,Python.

Net work Protocols: TCP/IP, HTTP, HTTPS, VPN, FTP, LDAP

ETL/DW Tools: Datastage, Crystal Reports, Business Objects, Cognose

Data Modeling: Erwin, Visio, Dimensional Model.

Project Management: MS Project, Excel

Others: MS Office, Remedy, Toad, SQL Navigator, SQL Assistant, Nexus, Share Point.

PROFESSIONAL EXPERIENCE

QA Test Lead

Confidential, Richardson TX

Responsibilities:

• Prepared Test Plan, test scenarios, test cases by analyzing functional requirement specification document.
• Participated in coordinated with multiple offshore Teams and directing quality assurance schedules and assignments, and monitoring project status.
• Take care of deliverables and single contact point offshore to other BA and QA teams as well as Stakeholders and members of the Team.
• As a member of the Agile Scrum team participated in daily standup meetings, project status meetings as well as retrospective meetings and iteration reviews.
• Created data migration check list and field mapping document.
• Performed integration testing, smoke testing, end to end2end testing of Cloud SaaS solutions
• Validated and verified 30 Integration check point for Aerial with downstream and upstream applications.
• Also done functional Testing, Integration, Usability Test in Cloud SaaS environment.
• Involved in compatibility testing using various browsers in SaaS environment.
• Prepared Test Metrics And generated monthly status reports for upper management review.
• Participated in various Gap Analysis meetings to discussed enhancement modification
• Tracking daily execution progress and reporting daily basis.
• Test Data setup and letter generation for Eloquence - letter upgrade
• As per migration requirement Updated test cases and test scenarios in ALM
• Involved in Mobile Automation usingAppiumautomation framework using Selenium WebDriver.
• Established the Environment set up for Mobile Automation usingAppiumTool.
• Developedautomationscript for Mobile Native applications (IOS, Android) using Appium, Java
• Used iOS simulator (on xCode) to make sure the app works on all devices.
• Development ofPythonscripts on daily basis and communicating with offshore team.
• Used Android SDK and set up mobile device Emulator to test application and to get log files.
• Prepared manual & function test cases on web and mobile applications (Apple & Android) as per requirements
• Provide Test Data inputs to generate deferent scenarios.

Environment: CLOUD SaaS, ALM 11.0, MS Access, MS Word, Agile and Scrum Methodologies, MS Excel, JIRA, ADOBE, Areal, ARIS, SDK, IExchange, IOS, Android Appium Medecision, Eloquence.

QA Test Coordinator/Automation Engineer

Confidential, Phoenix AZ

Responsibilities:

• Agile Test Planning/Strategy Preparation, contribution to Scrum Meetings and User stories
• Project Scope Analysis, Estimations, Scheduling, Tracking, Project Management
• Review Meetings and provide feedback to ensure that the system meets all primary requirements.
• Requirement gathering, Test case Walkthrough to Dev/BA teams to make sure sign off.
• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers andQAteam.
• Created and implemented Test Plan and Test Strategy Document outlining the scope, objectives, timeline and focus of software testing effort for functional, regression, user acceptance and stress testing.
• Design and Developed automated functional Test suite using Selenium WebDriver.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing, environment using Selenium WebDriver.
• Developed Selenium test cases using TestNG framework.
• Developed Automation scripts for new enhancements using Selenium WebDriver and TestNG.
• Involved in implementation of Test Automation Framework build using Selenium WebDriver, TestNG
• Maven technologies under Java platform utilizing industry leading harness design patterns and approaches Java programming skills using Eclipse IDE.
• Developed Maven Build scripts to run Sanity Test scripts developed in Selenium WebDriver.
• Used TestNG for testing framework. Implemented the script deployment in TestNG framework through command line and also integrated tests inJenkins(Continuous Integration tool).
• Wrote Maven build scripts to automate the compilation and execution of TestNG test cases/suites for Lens Measurement screen, Lens Type Screen, Aftercare screen and two eye replication screens.
• Used Java as Language and Eclipse as IDE, Maven as build tool,Jenkinsas CI tools.
• Involved in creation of automation framework in Selenium WebDriver using behavior driven approach like Cucumber. Parameterized test cases using different annotations.
• Validation of TSL request/reply via SOAP UI tool with XML/Schema Validation as per MTR transactions
• UsedPythonmodules to communicate with an existing SOAP server to execute and get the status of tests.
• SOA Integration (SIT) Web services Testing using SOAP UI using XML.
• Coordinate with Offshore teams to get the test execution status for each enhancement and report them in QC after reviewing the defects.
• Performing downstream basic Dash board validations by using MTR mapping document.
• Performing TSL application web service testing through Online/offline PNRs
• Performed End to End testing, Functional System testing and regression testing.
• Use Quality Center (ALM11.0) to organize and manage all phases of the software testing process, including planning and executing tests, and tracking defects.
• Daily Defect management call to track the defects across all engineering teams.
• Resource Allocation, Mitigation and Contingency planning, Coordination.

Environment: J2EE, Selenium WebDriver, TestNG, Cucumber,Jenkins, Maven, SOAP UI, Python, XPath, Eclipse, Fire Path, Firebug, Quality Center, HTML, JavaScript, CSS, XML, Subversion (SVN), agile, SQL and Windows.

Sr.QA Engineer

Confidential, McLean VA

Responsibilities:

• Review product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents.
• Work in the agile environment with frequently changing requirements and features set.
• Responsible creating the functional testing framework using TestNG and using Selenium WebDriver to automate the UI components.
• Used Selenium WebDriver API to automate tests on cross browser and cross platform environment.
• Sound knowledge on Object Oriented Programming concept and Java Language.
• Perform automated testing of a web-based application using Selenium WebDriver.
• Automated the Test cases using Selenium for Regression testing and TestNG for grouping the tests.
• Involved in Functional Testing as Unit test, Method test, Test Suite, Integration Testing using different TestNG methods.
• Used Maven to build and run the Selenium automation framework. Once the script got over, framework used to send the automation reports over email.
• Used Build tool like Maven to generate test report.
• Involved in development of Hybrid Test Framework using Selenium WebDriver, Maven and TestNG.
• Involved in creation of automation framework in Selenium WebDriver using behavior driven approach like Cucumber.
• Integrated the test suites toJenkinsto execute them automatically after every successful deployment.
• Integrated Automation scripts (Selenium WebDriver API) on Continuous Integration toolsJenkinsfor nightly batch run of the Script.
• Created Project plan onJenkins, configured scheduled using Cron job.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested aplication's GUI and in the testing, environment using Selenium WebDriver.
• Implemented the Agile methodology and attended the sprint meetings to discuss daily tasks and accomplishments.
• ALM tool for Requirements Tractability Matrix and mapping the requirements with Test Cases as needed.
• Participated in end-to-end, SIT testing of the application.
• Responsible for creating Test Environment forWeb Services testing.
• Used MISMO (xml schema), Xml query and X-Path to test UCD and CDM mapping.
• VerifyWeb services API request, response data validations in REST, SOAP protocols.
• Executed SIT test cases and procedures on different application build versions Responsible for defect management includes, defect logging, defect tracking
• Executed batch jobs and inbound files in the Unix environment to load the loan data into the database.
• Tracked and reviewed the requirements in Doors to make sure the functionality of the application is covered completely.
• Constructed complex SQL queries to validate the data in between Front-End Application and Back-End database.
• Involved in submitting weekly Bug Report and preparing test summary reports

Environment: SOAP UI, XML, Java, Selenium WebDriver,TestNG, Maven,Jenkins, Cucumber, SOAP UI, Eclipse, ALM, XPATH, HTML, CSS, agile, Internet Explorer, Chrome, Firefox, Oracle, SQL, UNIX.

UAT Analyst

Confidential, Plano, TX

Responsibilities:

• Involved Test Plan and peer reviews with Business stakeholders.
• Actively interacted with business team in clarifying complex requirements to avoid incorrect assumptions.
• Reviewed Test Cases with business users and other team members.
• Prepared Requirements Traceability Matrix (RTM) document to make sure that every business requirement has test case coverage.
• Prepared Test Data conditioning to validate all test scenarios.
• Performed UAT Testing, Regression Testing and End-to-End testing of LMA and Intellimods applications.
• Executed UAT Test Cases and updated the test results in HP ALM.
• Extensively used SQL queries for data validation.
• Provided daily testing status report to Project Manager.
• Used HP ALM for Defect Reporting and Defect Verification.
• All defects were thoroughly investigated and documented in HP ALM.
• Worked closely with business users and developers to resolve issues.
• Prioritized the test case functionality and Performed Regression testing for every major code change.
• Worked closely with development to resolve the defects.
• Lead the offshore team for multiple projects with testing activities.
• Working with LOB to get the UAT approvals
• Daily Tech Group meeting with Dev and Business Analyst.

Environment: HP ALM 11.0, PEGA - DW, IPortal, iSeries, SharePoint, Java, MS, iSeries/AS400, Java, SQL, UNIX, Source and target query auto tool

Sr.QA Analyst

Confidential, CT

Responsibilities:

• Involved in Preparing Test Plan, Test Cases for Med Pharmacy Claims.
• Worked in the environment of Agile methodology with regular sprint planning meetings.
• Involved in gathering Test Data and responsible for executing the Test Scripts.
• Coordinated with offshore onshore and set up the meetings and take care of the deliverables
• Coordinated with offshore testing teams resides across different locations.
• Provided Status Reports every week on the progress of the Projects to the higher management
• Implemented peer reviews and inspections to reduce defects in the requirements representations
• Involved in Data mapping to/from legacy that will be used to populate the oracle database.
• Involved in testing HIPAA EDI Transactions and mainly focused on 837 and 835.
• Involved in writing SQL queries in TOAD to validate the payment files.
• Performed UAT, System, Regression testing
• Responsible for QA status in release meetings.
• Worked in the environment of Agile methodology with regular sprint planning meetings.
• Used Quality Center for preparing the test case and for tracking defects.

Environment: COBOL II, EDI X12N 4010, TIBCO, DB2, CICS, OS/390, TSO/ISPF, File Aid, JCL, Agile, Scrum, Oracle, SQL, UNIX, Windows95/98/NT/2000/XP and Internet Explorer, Quality Center.

ETL QA Consultant

Confidential, Dearborn MI

Responsibilities:

• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Attending the client/ calls and updating the status of the Testing.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Prepared the test cases after thorough analysis of each requirement.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Used Clear Quest for Bug tracking.
• Reviewed the ETL mappings to ensure the transformation rules are applied correctly.
• Created and executed SQL queries to perform source to target testing on DB2 database.
• Coordinated with different users in UAT process.
• Did Unit Testing for all reports and packages.
• Tested the entire data reconciliation process for multiple source and target systems.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Involved in the application tuning of database by identifying the suitable Indexes.
• Worked on Autosys, which involved in creation of Autosys jobs, execution.

Environment: DataStage 8.5, Agile, Teradata, Oracle, Agile, Clear Quest, SQL, Business Objects, Server 2000, SQL, Shell scripting, PL/SQL, Toad, Autosys.

Sr.QA Engineer

Confidential, Addison TX

Responsibilities:

• developed Test Plans, Test Scenarios and Test cases.
• Involved in User Acceptance testing (UAT), SIT (System Integration) and CIT (Component integration Testing).
• Coordinated efforts between product development teams and offshore test team
• Used Oracle 2005 to verify database.
• Executed PL/SQL (stored procedure) to test CSDB.
• Defect logging, assignment and tracking through Quality Center.
• Attended Status Meetings, Query Log Meetings and project Release meetings.
• This application developed on Agile methodology.
• Attended daily stand-up calls, sprint review meetings, sprint retrospective meetings.

Environment: MS-Excel, PL/SQL, Oracle express Edison, FoxPro, Point, Java, VALIUMLogMinor, Quality Center, MS SQL Server 2005, VB.NET, ASP.NET, XML, Agile methodology.

Confidential, Sacramento, CA

Responsibilities:

• Reviewed the user requirement document and participated in preparing the detailed test plan and test cases.
• Used HP Quality center to execute functional scenarios, bug reporting and bug tracking and view and integrate requirements (tractability matrix).
• Enhanced automated steps for the update order component in business process testing (BPT).
• Conducted System tests to verify the existing functionalities
• Modified scripts for data driven tests to check how application performs with different sets of data.
• Participated in regression testing of the modified build.
• Functions to make the scripts reusable in QTP.
• Involved in User Acceptance Testing with end users.

Environment: Java, HP Quality Center 9.2, QTP 9.5, XML, SQL, TOAD, C, Agile, Scrum, UNIX, XML, Shell scripts, WebSphere.

Sr.QA Analyst

Confidential, Madison, WI

Responsibilities:

• Analyzed the Business requirements and the site specifications.
• Reviewed the User Requirements Document and participated in preparing the detailed Test Plan and Test Criteria.
• Involved in writing Test Scenarios, cases, Test conditions for various functionalities of application.
• This project developed on Water fall. methodology.
• Involved in testing in-Bound Transactions (837,276,834) submitted through Data-Exchange gateway.
• Used Requisite pro for requirement management.
• Involved in bug reporting and bug tracking using Clear Quest.
• Participated in Regression testing of the modified build.
• Involved in Extensively User Acceptance Testing with validations and verification.

Environment: Java, JavaScript, HTML, DHTML, Oracle, EDI X12N 4010, Clearcase, Rational Manager, Requisite pro, Agile/scrum, Clear Quest, Snagit, XML.

QA Analyst/Tester

Confidential, Raleigh NC

Responsibilities:

• This project is developed on Agile Methodology.
• Created test plan and test cases.
• Worked closely with development team to discuss the design and testing aspects of the applications to design the test plan and created and maintain well-defined test cases forETL testingusing HP Quality Center (QC)
• Tested complexETL dataloads and the data flow logic betweeninterfaces.
• UsedDB2 toolto extract data and verify database schemasand updated the schema by executingSQL queriesfordata manipulation.
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Tested objects in the Universe to ensure the correct mapping of the objects.
• Tested the Universe Structure to ensure that tables are properly uploaded
• Tested the Standard Reports by writing SQL based on the Reporting Requirement and comparing the data

Environment: Java, WebSphere 5.0, Oracle, PL/SQL, HP Quick Test Professional 8.0, Agile Quality Center 9.0, Windows XP, XML, UNIX, TOAD, and Oracle.

QA Analyst

Confidential, Chicago, IL

Responsibilities:

• Reviewed business requirements, created test plan test scenarios, test cases.
• Set-up the test QA environments for the integration, system and end-to-end testing.
• Quality center to test basic functionality of the application and reported the defects.
• Documented Test Metrics, Test Logs and various reports on the weekly basis for senior management.
• Automated the regression test scripts using Quick Test Professional and ran them for every build in UAT, QA and Pre-Production Environments.
• Extensively used PVCS for Defect Reporting and Tracking.

Environment: WebLogic, Teradata, SQL, Oracle, IMS, JAVA, JSP, UNIX, IIS, QTP 8.0, Quality Centre, 8.0, XML and COM+, UNIX, PVC

QA Tester

Confidential, San Ramon, CA

Responsibilities:

• Review High Level Design Document, Interface Agreement documents, Detailed Design documents.
• Trained the members of the team who joined during the testing phase of the project on project scope / functionality.
• Prepared the test environment for test execution and executing the test cases.
• Processed the IR (Invoice & Adjustment) files received from ICBS (Internal carrier billing system) through XACCT (Amdocs Mediation System).
• Processed the Invoice and Agreement files through Acquisition & Formatter Module (Amdocs Enabler).
• Validated that guided Invoices & Adjustments reached ODR (Operational Data Repository) & Amdocs Ensemble Billing systems.
• Used Quality Center to manage and track the test cases, test scripts, defects

Environment: WindowsNT/2K, ASP.NET, C#, .NET, XML, Putty server, UNIX, Amdocs, CRM, Crystal Reports 8.0/7.0, Oracle, Windows NT/2000, IE, PL/SQL, Quality Center 7.0

QA Tester

Confidential, San Antonio, Texas

Responsibilities:

• Involved in analysis of system requirements, business rules with Doors.
• Created test conditions and test cases using Doors and prepared test data for test execution.
• Used Test director for Test plan and executing of test cases manually.
• Involved in maintaining test documentation, defect metrics

Environment: Test Director 8.0, DOORS, .NET, Weblogic, SQL, STARTEAM, MS-Windows XP, CICS, IBM OS/390, IMS, XML, MS-Office.

QA Tester

Confidential, Oakland, CA

Responsibilities:

• Developed Test Cases bases on Functional Specifications and Design Documents for Med Pharmacy.
• Performed Smoke, Integration, functional, Regression, and system testing.
• Used Test Director for preparing the test case and for tracking defects.

Environment: COBOL II, EDI X12N 4010, TIBCO, DB2, CICS, OS/390, TSO/ISPF, File Aid, JCL, Oracle, SQL, UNIX, Windows95/98/NT/2000/XP and Internet Explorer, Test Director.