Sign in

Test Cases Data

Dallas, TX
March 21, 2019

Contact this candidate




Name : Antara Dhar

Work Authorization : US Citizen

Address: Dallas,TX

Phone : 213-***-****

Email :

Education : Master’s in Science National University, Bangladesh

Total Years of IT experience : 4 Plus

LinkedIn URL :


Over 4 plus years of experience in IT as a Software QA Engineer and Analyst with extensive experience in performing manual and automation testing in Investment, Health Care, Insurance and Investment domain.

Involved in entire Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) – Requirement, Design and Analysis, Development, Testing, Deployment and Support phase. In-depth knowledge of software QA methodologies like Waterfall, Agile Scrum and Kanban.

Experts in writing SQL Queries and joins in Oracle Data Base to retrieve, verify and compare large amount of data in both base line and new code. Experienced in Validating Data Flow as per Data Mapping document, Source to target validation to ensure data integrity. Validates ETL logics using SQL quires and tools such as Informatica.

Experienced with API testing by using simulator with XML input and verifying output result.

Performed backend service testing using Swagger API and monitor response message and logs in UNIX environment.

Experienced in identifying the scope of automation and create regression test scripts using Selenium Katalon based on business priority and functional criticality of the Application.

Strong knowledge of Object Oriented Programing such as Java.

Hands on Experience in Cross Browser testing using Selenium Katalon.

Strong experience with Behavior Driven Development (BDD) and Behavior Driven Testing with Cucumber JVM to implement Test Driven Development (TDD).

Solid experience with Gherkin Language to create feature files and develop Behavior Driven Testing.

Experienced in analyzing and understanding Business specifications, testing requirements and developing detailed Test plans, Test cases, Test scripts, Test Scenarios.

Strong knowledge of Black box and Grey Box testing (Static and dynamic). Served as an SME and coordinated with multiple partner teams to perform a robust System Integration Testing before every release.

Experienced in providing project schedule, estimation and perform Test lead responsibilities for multi-phase testing like functional, regression, SIT, Official QA and UAT.

Create and maintain test artifacts like Master test plan, product test approach, Release Notes, Defect and Test Summery reports and user’s sign off for auditing purpose.

Experienced in creating Traceability Matrix to ensure comprehensive test coverage (both manual and automation) of requirements.

Identify risks and provide mitigation plan with effective communications.

Have worked on windows based, web based and client/server applications.

Expertise in conducting and participating different Types of Testing - System, Functional, SIT, GUI, Automate Regression, Performance, Sanity, Smoke and User Acceptance Testing (UAT).

Experienced in developing, trouble shooting and customizing Manual test case using HP Quality Center and JIRA. Identify Defects, analyze root cause and provide possible solutions.

Experienced in running Complex large Batch by executing Autosys Jobs, analyzing logs in Unix Platform and perform failure analysis.

Experienced with version control, configuration management and change control procedures by using tools such as SVN and Perforce. Highly experienced with configuration tasks like environment set up Data Base refresh.

Exposure to Remedy to create and monitor different types of request tickets.

Worked closely with end users to support, coordinate and demonstrate any release items for successful migration.

Experienced with software engineering standards like CMM (Capability Maturity Model). Participated CQM audits to ensure quality.

Hands on experience for mobile application testing on both IOS and Android platform.

3 Plus years of experience as a lead to work with Onsite-Offshore model.

Dynamic and assertive team player with a strong inclination to improve and optimize process development and implementation.

Excellent analytical skills with good communication and self-organizing skills and committed team player.

Professional Attitude to deal with different clients and steak holders to meet all expectations and deliver quality product as planned on time.


Test Management Tools: HP Quality Center, HP ALM, Test Director, JIRA

Test Automation Tools: HP Quick Test Professional (QTP), Selenium Katalon, Cucumber

Operating Systems: Windows, UNIX, Linux

Scripting Languages: SQL, HTML, XML, Java.

Databases: Oracle, MS-SQL Server, MySQL, MS Access

Data Validation Tool: DB Comparator, Informatica workflow.

Version Control Tools: StarTeam, Perforce, Sub Version

Productivity Software: MS Office, Photoshop, MS Visio, Autosys, Mind Map, Visual Studio, Hexawise.


Mercy, MO QA Specialist 02/2018-present

Working in a fast phase Agile environment with extensive collaboration with Developers, Business analyst and other QA members in order to complete planned and unplanned testing activities within the Sprint.

Participating different Agile ceremonies such as Daily Stand Up, Sprint Planning, Backlog Grooming, Retrospective to plan and execute test cases and monitor test progress.

Responsible for End to End testing by understanding and analyzing Business requirements, Creating test scenarios, Test cases, test data set up, execute test cases and document results, automated regression suits and testing the application in UAT.

Using open source web testing tool Selenium WebDriver to automate test suite to increase the automation coverage for regression test cycle.

Implemented wide range of functional testing using QA Automation Test Framework such as Behavioral Driven Testing concept to ensure the code reusability and code maintainability, which reduces the script development time.

Implemented Cross Browser and Cross Platform testing with Selenium Katalon.

Developed and implemented robust Page Object Model Framework with Selenium Katalon using Object Oriented Programing (Java).

Log, triage and manage defects using JIRA.

Using HP ALM to create and manage test cases, execute test cases and provide different types of test status and progress reports to management as requested.

Hands on experience in database testing to validate data flow from source to target by writing complex SQL queries and Joins in Oracle environment.

Activity participated UAT testing to certify application meets business requirements and provide signoff.

Contributed post production activities as required.

Performed other job duties as requested by the project to deliver a quality product as promised to the end users.

Environment: Agile, JIRA, HP ALM, Oracle, Microsoft SQL Developer, UNIX, Selenium web Driver, Cucumber, Test NG, Sub version, Java.

Reinsurance Global of America (RGA), MO QA Analyst/UAT Tester


Involved and participate each phase of SDLC from requirement gathering to Production Support as part of daily job duties. Participate Requirement gathering with stake holders and BSA’s to provide SMART requirement and identify clear acceptance criteria. Reviewed of Documents like Software requirement Specification (SRS), Rapid Design Document (RDD), High Level Design (HLD), Detail Design Document (DDD), Acceptance Test Cases (ATC), Integration Test Cases (ITC) and Unit Test Cases (UTC) to provide inputs.

Involved in identifying scenarios and creating Test Plan and Test Cases as per Requirements and FRD guide using Excel, MS Visio and Mind Maps.

Extensively used SQL queries for checking the Data Transactions and Database Integrity in Oracle. Worked as a backend tester to verify and validate data in both base line and new code to support migration projects.

Experienced in Data Flow validation to confirm lookup and data translation logic as per data mapping architectures.

Hands on experience on ETL tool like Informatica to load data from source file, view logs and debug issues.

Verified table structures, data types, data position, invalid data injections (negative testing) as part of daily job duties.

Coordinate with Automation integration team by performing environment setup, data setup and doing failure analysis.

Hands-on experience on 508 testing.

Execute large size autosys batch which includes more than eighteen hundred jobs, analysis logs and debug failures to identify root cause and provide solutions.

Coordinate with partner applications by performing environment and data set up, test case execution and result verification in SIT testing to ensure domain data flow.

Worked extensively with HP Quality Center for creating Test Plans, Test Cases, Test Design, Test Inputs, Test Logs, and Test Summary Reports and defect summery report.

Provide technical resolutions to overcome any project specific challenges. Manage and maintain KSM to support other QM team members.

Report stake holders and managers to track project improvement, identify and call out any potential risks and provide mitigation plan.

Reported the bugs, e-mail notifications to the developers using the Quality Center. Review and triage defects with Developers to monitor defects open and fix ratio.

Used Quality Center for defect tracking in different environments.

Provided Test Matrix to management when each project completed.

Developed and conducted system and user acceptance test plans on completion of system testing before installation of the application on user environment.

Provide estimation, cost and resource allocation for any upcoming projects.

Performed interactive walkthroughs of test scripts with developers, business users and Business Analysts.

Participated in the team meetings to discuss the issues arising out of testing.

Environment: Quality Center, QTP, HTML, VB Script, Visio, VB.Net, ASP.Net, SQL Server, Oracle, Windows.

Infosys,CA Technical Test Lead 04/2015 - 05/2017


Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.

Interacted with Business Analysts for requirements gathering and conducted review meetings for change requests for writing test cases.

Worked closely with software developers, engineers in defects tracking.

Performed Data Validation using SQL, Defect Resolution and Maintenance.

Extensively written SQL queries to perform back end testing.

Parameterized QTP scripts for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources).

Developed and maintained QTP scripts for Functional, Sanity and Regression testing.

Actively participated in test case automation using a structured, key word driven framework with QTP.

Worked with UAT testing team with users along with providing training to end-users.

Sent the reports to all team members with Daily Status to track the updates in testing.

Prepared test data and exported to a data pool in rational functional tester; carry out User acceptance testing and execution.

Monitored project plan execution and project metrics reporting.

Ensured the deliverables are in par with Client standards, prepared test data; carried out testing and execution.

Worked with development teams to investigate and correct software bugs and deficiencies based on testing results using Test Director.

Prepared status summary reports with details of executed, passed and failed test cases.

Involved with the Business and Development team to understand the requirements.

Analyzed the existing business scenario and business rules.

Created and executed Test scripts and Test cases based on the business requirements.

Documented test cases corresponding to business rules and other operating conditions.

Used HP Quality Center to design Test Documents, including Test Plan, Test Requirements, Test Cases and Test Procedures for functional and GUI testing.

Verified Meta data based on the complex mapping by scripting complex SQL queries. Executed DML, DDL, DML statements and complex joins to verify data as part of daily job duties.

Wrote test cases to test the application manually in Quality Center and automated using Quick Test Pro.

Reported and reviewed the defects with development team using Quality Center.

Responsible in consolidating the test results sent by the testers and updating the Quality Center.

Wrote complex SQL Queries for back end testing for both Oracle and SQL databases.

Involved in the conversion of Manual regression test cases to Automation Test Cases using QTP.

Involved in Regression testing on each build during various phases of application using QTP.

Tested the Application by inserting checkpoints and synchronization points in test scripts using QTP.

Planned and executed the Manual and Automation Testing for System Testing (Functional and Regression testing) and UAT.

Responsible in validating the functional test cases developed by QTP and planning them in executing in priority wise. Created the test results report.

Created Vuser Scripts for Performance and Stress testing using Load Runner.

Created Scenarios to simulate load and stress testing for multiple Vusers for various Enterprise services and systems.

Developed Test scripts using Load Runner by recording test cases and enhanced scripts by adding checkpoints, parameterization and correlation.

Generated Reports, Graphs, Summary data, and Collating execution results to help analyze the performance of the systems using Load Runner Analysis.

Involving in Risk Analysis, Root cause analysis, Walkthroughs and Release support.

Monitored the System &Windows Resources that include different hosts and servers.

Responsible in testing the site in all the windows flavors including the Windows 7 in order to check the compatibility of the site.

Environment: QTP, Load Runner, Manual Testing, Quality Center, MS-Excel, Windows, web logic server, C #, SQL and Oracle.

Contact this candidate