SUMMARY

• Over eight years of experience in Software Quality Assurance, doing Manual and automated testing on Web based, Web services and Client - server applications.
• Proficient in using automated testing tools (Quick Test Pro /UFT, Soap UI, Load Runner, Performance center, Selenium and Test NG).
• Proficient in Integration, System, Functional, Regression, Smoke Testing, Performance, Database, Data Migration Testing, ETL Testing, User Acceptance testing.
• Proficient in mobile web application testing on various devices (iPhone, Android)
• Experience in dealing with onsite and off-shore teams and responsible for distributing work to off shore teams, mentoring junior testers, tacking deadlines and giving guidance to off-shore teams.
• Performed functionality and regression testing during the various phases of the application using Selenium.
• Involved in implementing different automation framework from scratch like POM (Page Object Model) framework and Hybrid framework using the help of Test NG Data Provider.
• Experienced in using Jenkins as a Continuous Integration server to configure with Maven.
• Experienced in providing the efficient locators strategy like XPATH and CSS to run WebDriver script in stable condition.
• Proficient in Load testing using Load Runner for client server and client only applications.
• Strong expertise in developing, executing and maintaining effective test plans, test scenarios, test cases /test scripts, Traceability Matrix.
• Excellent knowledge of Test scripting languages VB Scripting and experienced in keyword driven, data driven frameworks and Hybrid Framework in QTP.
• Well Versed on HIPAA regulations and requirements.
• Experienced in Agile, V-Model and Waterfall model (Software Development Life Cycle -SDLC) project development methodologies.
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on the database applications.
• Experience working with various bug reporting tools like IBM Rational Clear Quest, Test Director, Bugzilla, Bug TRAC, JIRA, Quality Center
• Strong experience in using HP Quality Center as Test Management tools.
• Experienced in testing XML based communications between interfaces in a client server web applications.
• Sound knowledge in SOA testing, web services, SOAP.
• Proven ability to support multiple projects, under tight deadlines, often with competing priorities and complexities.
• Strong test management, people management, business management, multitasking skills and experience in running large cross enterprise multi project testing initiatives.

TECHNICAL SKILLS

Testing tools: Quick Test Pro 10.0, 11, 12.01, rational tools, Quality center, Win Runner, Load Runner 11.50, 11.52, Selenium.

Bug reporting: IBM Rational Clear quest, Test Director, Bugzilla, Bug Tracker, and JIRA

Programming languages: Java, C/C++, SQL, TSL, VB-Script

Web technologies: HTTP, HTML, XML, Apache Tomcat, IIS

Operating System: Windows NT/2000/XP/2003/2012server, UNIX (Linux Ubuntu)

Databases: MySQL 5.0, Oracle 9i, 12C, SQL Server 2000/2005

Source and Version Control: CVS, Rational Clear Case, SVN

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Sr, QA

Roles and Responsibilities:

• Involved in prioritizing the work, estimating the effort of QA, delegating the work to off shore team appropriately and delivering the QA artifacts within deadlines.
• Understanding the Business rules completely and tested the data transformation.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source (such as Bigquery (Google cloud), social networks, ecommerce data from different sources, fCRMDB data from different source).
• Tested big query source file stage data Vs S3 bucket (AWS) file for the initial load data completeness.
• Tested various source files vs CDL tables data for the initial load data completeness
• Extensively used SQL queries for data validation and backend testing.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
• Played role in creation and testing of designed scalable, reusable, and low maintenance ETL templates.
• Performed System test on Tableau Reports for Redshift Data warehouse system (AWS) which involved analyzing functional specifications and writing test analysis, executing reports with test data for test scenarios and writing complex Test SQLs for the reports and logging defects in JIRA.
• Worked closely with the Development and Database Modeling teams for Integration, System, Functional, Regression and UAT testing of Redshift Data Warehousing. Main tasks performed included - Talend Data stage ETL job execution, test analysis, source file extraction, FTP processes, Smoke test and source file validation for relevant tables during Initial and Incremental Loads.
• Performed analysis of Mapping Documents and 'Schema Compare' with Database tables, logged the defects and worked with the Database Modeling Team to resolve them.
• Provided Interns and junior QA’s with basic training and appropriate supervision.
• Involved in all phases of agile process and helped Project Manager to track the testing progress for each sprint and also gave valuable inputs to Project Manager to complete testing in time.
• Assists in the review and design of testing process, procedures, templates, and metrics.
• Developed and execute test plans, test cases and scripts for back end and front end reports testing.

Environment: Windows 7, JIRA, Java Script, SQL Server Management Studio, Data warehouse, Amazon redshift, MS Access, Agile Methodology (Scrum), Reporting tools- Tableau, Google cloud-Big query.

Confidential, NY

Responsibilities:

• Involved in strategizing testing automation process for full system (back end jobs, data base and front end reports)
• Involved in software testing of backend/host systems which includes - inbound/outbound message structure analysis, data flow validations
• UsedQuality Centeras test management tools for storing the Automation artifacts and Manual test cases.
• Assumed business analyst role during the initial phase to collect the business requirements, rules and also gained sufficient knowledge in FINRA regulation related to LOPR requirements
• Majorly involved in leading teams, Involved in manual and automation testing (UFT) of backend system.
• Coordinates test planning and execution activities across multiple teams.
• Created GAP analysis document for existing project LOPR and given presentation on what need to be done with respect to QA
• Directly worked with Clients Business Users and Development Teams in resolving issues and clarifications.
• Created test cases as per the business requirements and got the approvals from all stake holders
• Involved in heavy data base testing for validating data in various scenarios, this includes writing lots sql queries.
• Involved in testing the integration between ECULID file, RDM and compliance template.
• Used Agile JIRA application for creating story cards, relevant acceptance criteria, and also track the project velocity etc.
• Involved in prioritizing the work, estimating the effort of QA and automation, delegating the work to off shore team appropriately and delivering the QA/Automation artifacts within deadlines.
• Used Descriptive Programming to establish connections to DB and automated the data verification process of backend.
• Assists in the review and design of testing process, procedures, templates, and metrics.
• Tracks execution results and prepares test metrics to effectively communicate testing progress.

Environment: Windows 7, Internet Explorer, UFT 12.01 and QC 12.01, JIRA, Visual Basic, ASP, Java Script, Mainframe, VB Script, XML, SQL Server Management Studio, ORCLE 12C, MS Access, Agile Methodology(Scrum), Perl script, Jenkins.

Confidential

Sr.QA

Roles and Responsibilities:

• Majorly involved in driving QA.
• Involved in developing the framework for the Data driven Automation Framework, Automated several scenarios with UFT.
• Involved in prioritizing the work, estimating the Effort for QA and Automation, delegating the same to team members and delivering the QA/Automation artifacts within deadlines
• Assumed role of Business Analyst in gathering the requirements from the business, converting them into technical requirements for the developers and QA team.
• UsedQuality Centeras test management tools for storing the Automation artifacts and Manual test cases.
• Used advanced techniques of Descriptive Programming to establish the data base connections and verified the data base table’s data against expected results.
• Data Validation andDatabase Integrity testingdone by executing DML statements for Back-end testing during automation.
• Involved in all phases of agile process and helped Project Manager to track the testing progress for each sprint and also gave valuable inputs to Project Manager to complete testing in time in retrospective meetings.
• Used UFT Tool for automating regression test suite and configuration test cases.
• Automated most of the manual testsfor various Originators which helped drastically reduce the testing efforts
• Verify the web based TPM application and make sure all the originators information managed as expected
• Responsible for testing the RESTful web service APIs using Postman.
• Verified JSON formatted files and using API rest calls posted the data into database and tested theJson data against data base table data.
• Created test scripts and manual test procedures for connecting to various internal and external web services
• Involved in backend testing which are involved writing sql scripts and database data validation etc.
• Tested the whole IWAY cycle thoroughly which replaced older system, including checking outbound files and matching the records with database values and making sure everything in synch. Verify the MDCC reports against the existing system to make sure that the trac billing cycle amount did not impact with the new system.

Environment: Windows 7, Internet Explorer, UFT 12.01 and QC 12.01, JIRA, Visual Basic, ASP, Java Script, VB Script, XML, SQL developer, ORCLE 12C,SOA, IWAY, DATA QUALITY, MS Access, ERP, Postman ( For REST calls), Agile Methodology(Scrum), Performance center, Jenkins.

Confidential, NY

Sr.QA

Roles and Responsibilities:

• Involved in analyzing the applications and came up with the Automation Approach.
• Involved in driving the QA/Automation team
• Performed Functional, Black Box, System and smoke testing, End to End, Regression testing.
• Worked on automating the workflows involving various interfaces.
• Successfully led off shore testing team to develop various test cases and test scenarios, also distributing the work
• Used Quality center as test management tool.
• Had given the training sessions to the Junior/new team on the project and also automation scripts and also about the business rules and helped them successfully completing the test cases and tests on time
• Automated most of the manual tests for various application across GOL which helped drastically reduce the testing efforts
• Performed functional testing to identify various critical points in the application and automated it by using Selenium WebDriver with TestNG.
• Created various stress test scripts using load runner and performed stress tests for different scenarios and analyzed the reports from Performance Center and recommended the appropriate solutions to overcome the Performance Issues..
• Complete Automation and Data Driven Testing through Excel Sheets using Selenium and Test NG
• Worked closely with Business and Development teams to identify critical areas of business and technical requirements for test case prioritization and Automation
• Participated in gathering the test data, functional requirements from various third party applications that GOL applications interact with and prepared test data for validation
• Created test scripts and manual test procedures for connecting to various internal and external web services
• Involved in backend testing which are involved writing sql scripts and database data validation etc.
• Involved in ETL testing for DTCC commission settlements for broker/dealers and other distribution firms
• Tested the whole DTCC cycle thoroughly which replaced older system, including checking inbound, outbound files and matching the records with database values and making sure everything in synch
• Involved in various testing such as Patch, SIT, DR testing, Printer certifications.
• Tested majority of the GOL applications (around 50) in various environments such as Windows 7, 8 (Metro and Standard View),xp- (32bit and 64bit), Different versions of IE, Chrome, safari bro Configurations
• Done test fix/release fix verifications and do digital sign and make them ready for patch management solution.
• Involved in mobile web application testing on various devices (iPhone, Android) and various browsers (Safari, Chrome etc.,)

Environment: Windows 8/7/2003/2000/XP, Rational Manual Testing Tools, Rational Clearquest, HP Performance center 11.0,11.53,11.52, SQL Server 2005/2008, VB Script, MS Office, Agile Methodology(Scrum), ASP, ASP.Net, Java, Citrix, Mainframe, UNIX, iOS and Android mobile OS, Selenium, Test NG, eclipse, Java maven

Confidential, Cleveland, OH

Sr.QA Analyst

Roles and Responsibilities:

• Writing test specification and guidelines documents.
• Preparing auto run reports and tests for development and QA smoke tests.
• Involved in designing the QTP scripts using Manual Test Cases.
• Responsible for integrating and running the automation tests for every new build in Staging
• Performed Functional, Black Box, System and, End to End, Regression testing.
• Created and enhanced automated scripts using Selenium IDE, RC to perform functional and regression testing for Web based application.
• Responsible for testing the RESTful web service APIs using SOAP UI.
• Working with Business analysts to identify the story card success criteria.
• Work with business to prioritize defects based on business and technical requirements.
• Tested web services manually with a UI and in house automation tool.
• Integrated QTP automation tools with Quality Center and executed scripts via QC.
• Working on DB testing using SQL server 2005 management studio.
• Created out of the box test plans and execution scenarios.
• Updating test plan repository and test case execution results in QC.
• Developed process flows for progressive testing methodologies and processes.
• System Test cases development and execution.

Environment: Windows 2000/XP/2003 server, SQL Server 2005, QTP 10, SOAP UI, Quality Center, CTH (In House Automation Tool), Agile Methodology(Scrum), VB Script, ASP.net, C#, Selenium, Eclipse, Java.

Confidential, AZ

QA Analyst

Roles and Responsibilities:

• Performed Functional, Black Box, System and Regression testing.
• System Test cases development and execution.
• Involved in improving the process of releases by enforcing a Change management process for the smooth releases.
• Creating Test Cases as per Functional Requirements.
• Involved in various meetings with Business Analysts and Updated Business requirement.
• Prepared Test data to enable the software to be quality checked.
• Executed and updated with the test results for the Test cases in QC under the Test lab folder.
• Recording and playing back the scripts for regression test modules using QTP.
• Involved in doing automation using QTP.
• Created Data Driven Tests to process different sets of claims using QTP.
• Integrated QTP automation tools with Quality Center and executed scripts via QC.
• Involved in testing the integration between Claims application and other applications like Providers, Drugs and Eligibility
• Creating Test Cases as per Functional Requirements.
• Involved in various meetings with Business Analysts and Updated Business requirement.
• Performed Functional, Black Box, System and Regression testing.
• Prepared Test data to enable the software to be quality checked.
• Executed and updated with the test results for the Test cases in QC under the Test lab folder.
• Involved in doing automation using QTP.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation
• Developed and implemented EDI applications to process Health Care transactions as per the HIPAA implementation guide.
• Involved in HIPPA Complaint X12N 837 Transaction testing
• Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice
• Written multiple Test Cases (Unit, System, Integration) for multiple transactions include 837I, 837P, 835, (both inbound and outbound) transactions
• Processed claims for the Batch adjudication system and validated the full payment cycle process.
• Created different pricing rules and verified whether the adjudication system is using the rules while adjudicating the claims.
• Created Data Driven Tests to process different sets of claims using QTP.
• Reported software defects in QC and interacted with the developers to resolve technical issues.
• Generated SQL queries to validate various reports, loads and extract processes.
• Involved in testing the integration between Claims application and other applications like Providers, Drugs and Eligibility.

Environment: Windows95/98/2000/XP, Internet Explorer, QTP and QC, Visual Basic, ASP, Java Script, VB Script, XML, SQL, MS Access, IIS Web server,.