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 wif 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 teh various phases of teh application using Selenium.
• Involved in implementing different automation framework from scratch like POM (Page Object Model) framework and Hybrid framework using teh help of Test NG Data Provider.
• Experienced in using Jenkins as a Continuous Integration server to configure wif Maven.
• Experienced in providing teh 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 TEMPeffective 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 teh Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on teh database applications.
• Experience working wif various bug reporting tools like IBM Rational Clear Quest, Test Director, Bugzilla, Bug Confidential, 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 wif 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

Responsibilities:

• Involved in prioritizing teh work, estimating teh effort of QA, delegating teh work to off shore team appropriately and delivering teh QA artifacts wifin deadlines.
• Understanding teh Business rules completely and tested teh data transformation.
• Did extensive work wif 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 teh initial load data completeness.
• Tested various source files vs CDL tables data for teh initial load data completeness
• Extensively used SQL queries for data validation and backend testing.
• Validating teh 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 wif test data for test scenarios and writing complex Test SQLs for teh reports and logging defects in JIRA.
• Worked closely wif teh 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' wif Database tables, logged teh defects and worked wif teh Database Modeling Team to resolve them.
• Provided Interns and junior QA’s wif basic training and appropriate supervision.
• Involved in all phases of agile process and helped Project Manager to track teh testing progress for each sprint and also gave valuable inputs to Project Manager to complete testing in time.
• Assists in teh 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, New York City, 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 teh Automation artifacts and Manual test cases.
• Assumed business analyst role during teh initial phase to collect teh 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 wat need to be done wif respect to QA
• Directly worked wif Clients Business Users and Development Teams in resolving issues and clarifications.
• Created test cases as per teh business requirements and got teh 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 teh integration between ECULID file, RDM and compliance template.
• Used Agile JIRA application for creating story cards, relevant acceptance criteria, and also track teh project velocity etc.
• Involved in prioritizing teh work, estimating teh effort of QA and automation, delegating teh work to off shore team appropriately and delivering teh QA/Automation artifacts wifin deadlines.
• Used Descriptive Programming to establish connections to DB and automated teh data verification process of backend.
• Assists in teh review and design of testing process, procedures, templates, and metrics.
• Tracks execution results and prepares test metrics to TEMPeffectively 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

Responsibilities:

• Majorly involved in driving QA.
• Involved in developing teh framework for teh Data driven Automation Framework, Automated several scenarios wif UFT.
• Involved in prioritizing teh work, estimating teh Effort for QA and Automation, delegating teh same to team members and delivering teh QA/Automation artifacts wifin deadlines
• Assumed role of Business Analyst in gathering teh requirements from teh business, converting them into technical requirements for teh developers and QA team.
• UsedQuality Centeras test management tools for storing teh Automation artifacts and Manual test cases.
• Used advanced techniques of Descriptive Programming to establish teh data base connections and verified teh 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 teh 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 teh manual testsfor various Originators which helped drastically reduce teh testing efforts
• Verify teh web based TPM application and make sure all teh originators information managed as expected
• Responsible for testing teh RESTful web service APIs using Postman.
• Verified JSON formatted files and using API rest calls posted teh 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 teh whole IWAY cycle thoroughly which replaced older system, including checking outbound files and matching teh records wif database values and making sure everything in synch. Verify teh MDCC reports against teh existing system to make sure that teh Confidential billing cycle amount did not impact wif teh 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

Responsibilities:

• Involved in analyzing teh applications and came up wif teh Automation Approach.
• Involved in driving teh QA/Automation team
• Performed Functional, Black Box, System and smoke testing, End to End, Regression testing.
• Worked on automating teh workflows involving various interfaces.
• Successfully led off shore testing team to develop various test cases and test scenarios, also distributing teh work
• Used Quality center as test management tool.
• Had given teh training sessions to teh Junior/new team on teh project and also automation scripts and also about teh business rules and helped them successfully completing teh test cases and tests on time
• Automated most of teh manual tests for various application across GOL which helped drastically reduce teh testing efforts
• Performed functional testing to identify various critical points in teh application and automated it by using Selenium WebDriver wif TestNG.
• Created various stress test scripts using load runner and performed stress tests for different scenarios and analyzed teh reports from Performance Center and recommended teh appropriate solutions to overcome teh Performance Issues..
• Complete Automation and Data Driven Testing through Excel Sheets using Selenium and Test NG
• Worked closely wif Business and Development teams to identify critical areas of business and technical requirements for test case prioritization and Automation
• Participated in gathering teh test data, functional requirements from various third party applications that GOL applications interact wif 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 teh whole DTCC cycle thoroughly which replaced older system, including checking inbound, outbound files and matching teh records wif database values and making sure everything in synch
• Involved in various testing such as Patch, SIT, DR testing, Printer certifications.
• Tested majority of teh 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

Responsibilities:

• Writing test specification and guidelines documents.
• Preparing auto run reports and tests for development and QA smoke tests.
• Involved in designing teh QTP scripts using Manual Test Cases.
• Responsible for integrating and running teh 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 teh RESTful web service APIs using SOAP UI.
• Working wif Business analysts to identify teh story card success criteria.
• Work wif business to prioritize defects based on business and technical requirements.
• Tested web services manually wif a UI and in house automation tool.
• Integrated QTP automation tools wif Quality Center and executed scripts via QC.
• Working on DB testing using SQL server 2005 management studio.
• Created out of teh box test plans and execution scenarios.
• Updating test plan repository and test case execution results in QC.
• Developed process flows for Confidential 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

Responsibilities:

• Performed Functional, Black Box, System and Regression testing.
• System Test cases development and execution.
• Involved in improving teh process of releases by enforcing a Change management process for teh smooth releases.
• Creating Test Cases as per Functional Requirements.
• Involved in various meetings wif Business Analysts and Updated Business requirement.
• Prepared Test data to enable teh software to be quality checked.
• Executed and updated wif teh test results for teh Test cases in QC under teh Test lab folder.
• Recording and playing back teh 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 wif Quality Center and executed scripts via QC.
• Involved in testing teh integration between Claims application and other applications like Providers, Drugs and Eligibility

Confidential, AZ

QA Analyst

Responsibilities:

• Creating Test Cases as per Functional Requirements.
• Involved in various meetings wif Business Analysts and Updated Business requirement.
• Performed Functional, Black Box, System and Regression testing.
• Prepared Test data to enable teh software to be quality checked.
• Executed and updated wif teh test results for teh Test cases in QC under teh 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 teh HIPAA implementation guide.
• Involved in HIPPA Complaint X12N 837 Transaction testing
• Involved in preparing teh 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 teh Batch adjudication system and validated teh full payment cycle process.
• Created different pricing rules and verified whether teh adjudication system is using teh rules while adjudicating teh claims.
• Created Data Driven Tests to process different sets of claims using QTP.
• Reported software defects in QC and interacted wif teh developers to resolve technical issues.
• Generated SQL queries to validate various reports, loads and extract processes.
• Involved in testing teh 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,.