OBJECTIVE:

• More than Eight years of strong understanding ofSoftware Quality Assurance.
• Seeking for a Software QA Analyst/Engineer/Tester position of a winning organization where creativity, sincerity, skill, and performances are the criteria for one's appraisal and recognition.

TECHNICAL SKILLS

Applications: ASP, .NET, Visual Basic, JIRA, AWS

Testing areas: Web Testing, Database Testing, Client Server Testing

Types of Testing: Black box testing, Integration testing, Regression testing, Compatibility testing, System testing, Functional Testing, End to End Testing, Sanity Testing, User Acceptance Testing, Domain Testing

Testing tools: Selenium, TestNG, Junit, JMeter, Unified Functional Testing (UFT), ALM 12.5, Postman, Gherkin, Cucumber, Jenkins, Azure

Methodologies: Agile, Waterfall, Iterative

Operating Systems: Windows, UNIX/Linux

Database: MS SQL Server 2012/2016, Microsoft Access, Oracle 11g, DB2

Programming Languages: JavaScript, HTML, CSS, C#, SQL/T - SQL, Python

PROFESSIONAL EXPERIENCE

Confidential, New York

Quality Assurance Data Analyst/ETL QA Analyst

Responsibilities:

• Extensively used SQL/T-SQL queries to access data from different database tables to verify changes in the database, web application and client server data in both Dev/Test environment and Production environment.
• Developed Microsoft SQL Server (MS SQL) automation scripts using library functions and stored procedures.
• Executed regression testing with Stored Procedures to ensure no unexpected changes have been pushed to the production environment without proper authorization.
• Analyzed millions of records being imported for data load and ensured all records being loaded complied to specified requirements.
• Verified imported data to the database and performed Data Driven testing with different Data sets for Reports, Disbursement Payments, Mailings/E-Blasts, Web/Paper Claims and Settlement Calculations in Microsoft SQL Server (MS SQL), Client Server and SSIS Packages.
• Conducted both Manual Testing and Automated Testing using Microsoft SQL Server (MS SQL) for Data Loads, Mailings, Mass Updates, Disbursements, Web Claims, Exception Reports and Calculations.
• Developed scripts using T-SQL to add to Initial Data Load Automation script to perform functional, non-functional and regression testing to improve quality of testing and reduce testing time.
• Created Test Cases and Test Plans from Functional and Technical Requirements Documents.
• Developed and organized Test Scenarios and Test Procedures and recorded all results in a spreadsheet from performing functional and nonfunctional testing on web applications.
• Assisted QA Lead with tracking and reporting defects for automated process run overnight. Analyzed stored procedures to track discrepancies found from scheduled tasks, bulk inserts, and web staging. Recorded and reported findings to Data Service managers.
• Extensively worked on cases involving Domain Testing for Web Applications and End to End Testing and UAT Testing for Client Server Application.
• Managed and facilitated AD-HOC Testing for reports for clients daily.
• Analyzed and reported the discrepancies, severity, bugs, and reporting through GitHub and Service Request.
• Created bug Service Requests to report defects found during test cycles and tracked the defects and retest fixed issues/modules to ensure quality of data pushed to production met company standards.
• Used Azure on daily bases to track scripts for continuous integration and delivery.
• Worked with Developers and Business Analysts in reviewing functional and technical requirements.
• Involved in Peer Reviews and mentoring onboarding new QA team members.
• Participated in Daily Stand-up meetings and coordinated tasks with managements and colleagues.
• Held presentations for QA team on new procedures for testing as training material for new members.
• Relentlessly worked on cases to meet client deadlines and requirements.

Environment: Microsoft SQL Server Management, Visual Studios, FileZilla, SQL Server, SSIS, SAP, Workday, Microsoft Suite, Excel, GitHub, Claims Matrix, Service Production System, Service Request, Client Server, Payment Viewer, SharePoint, Facilitator, Azure DevOps, Ranger Environment (HIPAA, SEC, FTC, CFPB), Power BI, Report Builder, Selenium, Azure, Remote Desktop.

Confidential, Washington, D.C

QA Analysis

Responsibilities:

• Involved in developing Test Cases, Test Plan for application, worked on Logging bugs in the ALM tracking tool.
• Reported the bugs, Email notifications to the developers using the ALM and Monitored ALM.
• Analyzed the Discrepancies, severity, tracking system and reporting through ALM.
• Used SQL to query the DB to verify application front end input value.
• Used SQL queries to access data from different database tables.
• Automated scripts were developed using Unified Functional Testing (UFT) to perform functional and regression testing.
• Developed Unified Functional Testing (UFT) automation scripts using library functions, Data driven tests and Regression tests.
• Involved in both Manual Testing and Automated testing using the automated tool Unified Functional Testing (UFT).
• Worked closely with developers in reproducing bugs reported.
• Analyzed Requirement documents to develop and Execute Test scripts and documented Test Cases corresponding to business rules.
• Developed test cases and test scripts for Functionality and Regression Testing using HP Unified Functional Testing (UFT).
• Imported data from the Database to the Data table and performed Data Driven testing with different Data sets for reports generation module in HP Unified Functional Testing (UFT).
• Responsible for performing web test using HP Unified Functional Testing (UFT) for checking page contents, broken links, web objects, frames, and tables.
• Insert Object Data Verification Check point on HP Unified Functional Testing (UFT) automation testing tools.
• Verify Back-end Data after interacted with front-end Automation Test scripts.
• Used HP Unified Functional Testing (UFT) for object repository creation and maintenance, used regular expression, re-usable actions, data table, checkpoints, and recovery scenario.
• Involved in preparing detailed and reviewed Test cases to cover all the requirements.
• Extensively worked with developer in reviewing the requirements.
• Involved in Peer reviewing the Team members test scripts also bug meeting.
• Involved in functional testing and verify the application according to the user perspective.
• Reviewed Business Requirement Documents and Functional Specification.
• Interfaced with subject matter experts and developers to resolve the problems while executing the test scripts and Test cases.
• Extensively involved in reviewing the scripts with the businesspeople.
• Responsible for reporting daily status and progress of testing to the project team.

Environment: Micro Focus Unified Functional Testing (UFT) 12.5, Micro Focus ALM 12.5 Windows, VB, .NET, ASP.NET, SOAP UI, SQL server, Oracle EBS, Mozilla, J2EE, Jenkins, SVN, Agile, Web, Ajax, CSS, GWT, Ext JS, Version One, HTML, ATI, Oracle on Demand, MDM, Web Services API, Siebel, .NET, People Soft, Environment Variable.

Confidential, Philadelphia, Pennsylvania

QA Engineer

Responsibilities:

• Developed and executed test plans and test cases based on business requirements and functional specifications.
• Involved in using JIRA for managing the defect. Performed manual Back-End testing by writing SQL Queries for validating user information in the tables.
• Used Quality Center as defect tracking and reporting tool.
• Strong Experience Atlassian tool administration knowledge on JIRA and Confluence.
• Strong Experience JIRA Administrator with experience customizing JIRA projects with various schemas, complex workflows, screen schemes, permission schemes, and notification schemes required and users while working in a JIRA environment.
• Strong Ability to construct custom dashboards using various filter types in JIRA.
• Experience Work with JIRA filters, reporting, dashboards, workflows, fields, and JIRA administration.
• Strong Ability to write custom JQL (Jira Query Language).
• Strong Ability to construct Confluence pages and integrate JIRA projects with Confluence pages.
• Strong Experience in performing Atlassian installations, migrations, and plugin installation.
• Worked on backend testing using SQL queries and web services testing.
• Extensively used SQL/PL-SQL statements to verify the data in the database.
• Performed Functionality Testing and Integration testing.
• Determined test approaches for various testing strategies like Functional, System, Regression, Usability testing, Alpha, Beta testing and executed.
• Worked extensively as Test Lead with the QA (Quality Assurance) team for designing and evaluating Test Plan, Test System, Test Data and Test Cases for the application.
• Performed manual and automated testing and maintain documentation on different types of Testing like Black Box, Regression, Integration, System and Acceptance testing.
• Responsible for QA test suite development, execution, and analysis.
• Involved in reviewing existing documentation for current systems to create AS-IS and TO-BE processes for Gap analysis.
• Tested Compatibility of application with Internet Explorer, Mozilla Firefox.
• Performed System and Integration testing by executing test cases.
• Organized test procedures and executing tests in Web and Client/Server Environments.
• Created test scripts for various testing stages like Functional Testing and Regression Testing.
• Analyzed system specification and developed Test plans for System and Integration Testing.
• Developed test scripts according to the program specification given.
• Reported defects found during test cycles and track the defects and retest fixed modules.
• Involved in Peer Reviews.

Environment: Quick Test Professional (QTP), MS Office Suite Agile, Web, Ajax, Java, SOAP UI, CSS, GWT, Visual Basic, Mozilla, J2EE, Ext JS, HTML, UNIX, ORACLE, BPT, .NET, Windows, VB Script.

Confidential, New York

Software Tester

Responsibilities:

• Created test plan and test cases from functional specification documents.
• Manually executed Test cases and Test Scripts after reviewing the business requirement document and technical specifications and responsible for updating existing test cases against the requirements.
• Actively participated in iteration planning meetings and reviews to review impacts on test plan and test strategy of any changes made and new functionalities added in new builds.
• Presented test cases at cross functional test cases review meetings with test team, system analyst and product management teams and have emphasized need for better change control process for critical user stories.
• Met with business analysts to understand business functionalities, requirements, and designed test cases to satisfy Client requirements.
• Worked in agile environment, attended daily morning stand up (scrum) meetings, updated daily status on what was done yesterday, what will be done today, and any blocking issues.
• Wrote SQL queries using SQL plus and SQL Developer for backend testing of the applications.
• Wrote, tested, and debugged complex SQL queries involving multiple joins and conditions on Oracle RDBMS.
• Developed test cases and test scripts for Functionality and Regression Testing using HP Unified Functional Testing (UFT).
• Imported data from the Database to the Data table and performed Data Driven testing with different Data sets for reports generation module in HP Unified Functional Testing (UFT).
• Responsible for performing web test using HP Unified Functional Testing (UFT) for checking page contents VB script, descriptive programming, web objects, frames, and tables.
• Responsible for creating the test cases in HP ALM and mapping them with the requirements.
• Analyzed Business Requirements and System Specification documents and created Test cases and executed Test cases in HP ALM.
• Provided defect status reports & test-case execution reports on weekly basis using HP ALM.
• Performed sanity, integration, regression, and system testing to verify incremental and existing functionality of various demand builds during each iteration.
• Executed test cases on development builds and did bug logging and defect tracking.
• Interacted with developers, system analysts, product management, external customers, user interaction and usability testing groups and customer support on a regular basis.
• Performed User Acceptance Test using different module of the application.
• Involved in project review meetings and discussed issues, status for tracking the progress with project teams.
• Prepared minutes of meetings and test summary reports to communicate the results of testing effort to higher management.
• Provided daily and weekly project status reports and escalated issues to the Manager as well as Providers as needed.
• Developed and documented testing processes, test plans and test cases.
• Extensively involved in GUI, backend Oracle testing.
• Assisted in definition, creation, and validation of test data.
• Worked closely with the development team to identify and fix defects and enhancements.
• Involved in documenting and analyzing defects and test results.
• Performed troubleshoot with UNIX and Database related problems.
• Performed necessary research to resolve defects.
• Worked in developing Shell scripts in UNIX.
• Communicated clearly and frequently the status of defects, and the steps to resolution with technical and business teams.
• Involved in peer reviews.
• Exercised good judgment within generally defined quality assurance practices, procedures, and standards.

Environment: MS Office, Oracle, Quality Center, Windows, XML, MS Project, XML SPY, SQL, and VBScript.