CHITRA GUPTA

Summary

• Having 9+ years of IT experience in manual and automated software testing.

• Extensive knowledge of quality assurance standards, methodologies and strategies with better
understanding of Software Development Life Cycle (SDLC), involved in various phases like
Requirements, Analysis/Design, Development and Testing.
• Extensive experience in Manual/Automated testing, Web application testing, Web Services testing, and
Database Testing.
• Experienced in test management tools HP Quality Center/ALM, Rally and JIRA.
• Experienced on automated tools such as Selenium IDE, Selenium WebDriver, Junit/TestNG, HP
QTP(UFT), and Appium.
• Worked on distributed test automation execution on different environments as part of continuous
integration process using selenium grid and Jenkins.
• Expertise in data warehouse concepts and tools. Involved in ETL processes where in organizations
were using informatica.
• Experience in creating test plans, developing test scenarios, writing and executing test cases, developing
test scripts, and test results reports for manual as well as automated testing for various applications to
ensure proper business compliance.
• Experience on GUI, Functional, Regression, Integration, System, end to end, User Acceptance and
performance testing.
• Experience in performing database testing and working with SQL queries and databases like Oracle
and SQL Server.
• Experience of working in SDLC methodologies such as waterfall and Agile/SCRUM development
environments.
• Has experience in Finance, Banking and Healthcare domains.
• Effective communication skills, especially with regards to presenting findings to both technical and
non-technical audiences.
• Ability to build and maintain strong working relationship with all levels of management.

Project Experience:

Gain Capital Sep’16 to till Date

Role: Sr. QA Analysis

Responsibilities:
• Reviewed Functional design document and Software Specification Requirements to achieve better
understanding of the Application.
• Extensively used XPATH, CSS locator to locate the element on the page.
• Involved in design and implementation of automation framework with TestNG, Selenium
WebDriver, Java and Maven.
• Implemented POM model to create the reusability of same objects for different tests.
• Implemented class read data from Excel file, and class for generate report.
• Tested applications in different types of browsers and versions, such as Internet Explorer, Firefox,
Google Chrome to simulate production environment.
 • Created script to tested application on Android mobile device.
• Worked closely with Agile Scrum team from several domains to ensure product testability while
running Regression tests in Selenium WebDriver using TestNG, and maintained test environments
used for white box testing during new product releases.
• Participated in daily SCRUM meetings and SPRINT meetings and discussed enhancement and
modification request issues and defects in the application.

Environment: Java, Selenium WebDriver, Appium, TestNG, Maven, Jenkins, JavaScrip, Google Chrome,
Safari, Mozilla Firefox, MS Excel, JIRA.

ADP Jul’15 - Aug’16

Role: Quality Assurance Specialist

Responsibilities:
• Created Effective Test Data and Test cases to ensure the successful execution of the data loading
processes, Created SQL scripts to verify test cases from source to target database oracle.
• Extensive experience in testing slowly changing dimensions of Type 2 to populate current and
historical data to Dimensions and Fact tables in the data warehouse.
• Responsible for validating the ETL mappings, against the pre-defined ETL design standards.
• Extensively used SQL and PL/SQL coding in Data stage jobs for processing data.
• Performed Smoke, Functional and Regression testing using QTP.
• Involved in preparing Test Plans and Test cases based on the business requirements Document in
the Quality Center.
• Involved in writing the test cases based on Requirements, Executing the test cases, Defect
Reporting.
• Opened Defects in Rally and tracked the status until defect is closed.

Environment: ETL- Informatica, Agile, Rally, Oracle PL/SQL, Java, JavaScript, QTP, Rally

Bank of America Jan’13 – Mar’15

Role: QA Engineer

Responsibilities:
• Prepared Test Plan, test Cases, Test scripts and Test data for the application as well as for the
database verification based on the functional requirements.
• 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, TestNG and Jenkins.
• Extensively used Selenium (data-driven, XPath locator) and WebDriver to test the web
application.
• Reported software defects in JIRA and interacted with the developers to resolve technical issues.
• Performed back end testing on Oracle Database by writing SQL queries.
• Followed Agile testing methodology, participated in daily SCRUM meetings and testing each
SPRINT deliverables.
• Participated in QA weekly meetings and various other meetings and discussed enhancement and
modification request issues and defects in the application.

Environment: Java (J2se), Selenium, TestNG, Maven, Jenkins, Oracle, IE / Chrome, MS-Excel
Partner’s Healthcare April’11– Dec’12
Role: QA Engineer

Responsibilities:
• Analyzed the user requirements, functional specifications and Use Case documents and created
the Test Plans, Test cases for Functional testing.
• Involved in providing the Testing Effort estimates and provided the timely feedback on progress
of the testing activity.
• Created Automation test framework using Selenium Web Driver.
• Designed and developed Page Objects using Page Object Design Pattern and Selenium
WebDriver.
• Involved in the Selenium Automation Hybrid framework development.
• Configured Selenium WebDriver, Maven tool and created Selenium automation scripts in java
using TestNG prior to agile release.
• Examine the results of test to pinpoint defects in the application using JIRA.
• Successfully Completed User Acceptance Testing (UAT) on each release of the project with the
help of end user requirements.

Environment: Java, J2EE, Selenium WebDriver, Selenium IDE, TestNG, JIRA, JavaScript, MS-Excel

Citigroup Dec’09– Mar’11

Role: ETL /DatabaseTester

Responsibilities:
• Created test cases and queries to test the data move for business card data to load from Stage to source
and source to Data management area [DMA].
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report,
Weekly Status Reports and SQA Report using Quality Center.
• Validated data for completeness and quality when moving complete deposit data from files to Stage
and then to source data.
• Extensively used Excel and WinSCP to move data and compare the source to target.
• Wrote SQL scripts and PL/SQL queries using Oracle SQL Developer to query DBs and analyzed the
results.
• Tested the reports from source layer [to meet the immediate need].Also, tested the final reports that
were generated data warehouse.
• Prioritized and identified regression test cases based on the dependency for each of the data move.

Environment: Informatica power center, Quality Center, Agile, Oracle SQL developer, Unix

Technical Skills:

Automation Tools Selenium Suite (IDE, RC, WebDriver), HP QTP, Appium

Data Warehousing/ ETL Informatica PowerCenter 9.x/8.x
Oracle 11g/10g/8.x, DB2 UDB 8.5, SQL Server, Oracle Sql
Databases & Tools
developer11.1, TOAD.
Test Framework Cucumber, TestNg, Junit, Hybrid Framework, POM
Programming Languages Unix Shell Scripting, SQL, PL/SQL
Education:
College: Jai Narain Vyas University, Jodhpur, Rajasthan, India
Education: Undergrad (Computer Science)
College: Jai Narain Vyas University, Jodhpur, Rajasthan, India
Education: MCA

Working Status: US Citizen