SANGEETHA KOLLURU

adnlj3@r.postjobfree.com

Phone: 931-***-****

Over 5+ years of IT experience in Software Testing of web based and Client-Server applications.

Strong Knowledge of Software Testing Life Cycle (STLC), which includes Designing, Developing, and Execution of the entire QA Process and Documentation of Test plans, Test Cases, Test Procedures and Test Scripts.

Strong testing Quality Assurance experience within Agile environment.

Experience performing Black box testing, Gray box testing, End to End testing, System testing, Integration testing, UAT, Exploratory, Database Testing, regression etc.

Proven ability in designing and creating automation frameworks for web-based applications using Java, Selenium Web Driver and TestNG.

Good understanding of XPATH, CSS and used tools like Firebug to debug JavaScript.

Work experience in integrating Automation scripts (Selenium Web Driver API) on Continuous Integration tools Jenkins for scheduling batch run of the Script.

QA Automation expert with sound Java experience in writing automation scripts in Java for Selenium and TOSCA.

Experience in testing the Web application links functionality and Web reporting Data validation.

Setup the Automation framework using Selenium Web Driver to run test cases in multiple browsers and platforms.

Work experience in integrating Automation scripts (Selenium Web Driver API) on Continuous Integration tools Jenkins for scheduling batch run of the Script.

Expertise in Extraction Transformation Loading (ETL) process using Informatica consisting of administration, data transformation, data sourcing, mapping, conversion and loading.

Extensively used Source Qualifier, Connected and Unconnected Lookup on Flat File and Relational Table, Router, Filter, Expression, Aggregate, Stored Procedure, Sequence Generator, Sorter, Joiner, XML Source Qualifier, Java Transformation, Union transformations and Mapplets.

Writing test cases using Element locators, Web Driver Methods, Java Programming Features and Test NG Annotation.

Expertise in understanding and analyzing test requirements, Tracking Changes and Maintenance of Test Requirements.

Expertise in documenting defects with high level of detail, accuracy, and informative recreation steps using Quality Center.

Experience with testing on UNIX and Windows environments.

Experience in database query manipulation, SQL, PL/SQL statements, stored procedures, and triggers.

Strong expertise in lifecycle methodologies like Waterfall, Agile Models and TDD (Test Driven Development) methodology.

Very good experience in Testing Informatica Mappings / Mapplets and Workflows with Worklets & Tasks for Multiple Sources, Data Warehouse.

Experience in implementing complex functional tests that require an understanding of the application logic and excellent problem analysis and bug reporting.

Excellent experience with source version control tools such as Subversion (SVN).

Excellent experience in troubleshooting software applications for business functions in major areas of the business and enterprise-wide.

Ability to adapt to new environment quickly, strong team player, good communication, good analytical and computation skills, enthusiastic learner, confident, sincere and committed.

Proactive in learning new technologies and updating my skills.

TECHNICAL SKILLS

Testing Tools

Selenium IDE/WebDriver, MACROS, TOSCA, ATLAS

Languages

SQL, Java, C

Tools

SQL Developer, TOAD, Informatica Power center

Databases

Oracle 11g/10g

Operating systems

Windows 7/XP and UNIX.

Defect Trackers

HP Quality Center 10.0, HP ALM

Methodologies

Agile, Waterfall

ETL Tool

Informatica Power Center

Other Tools

JIRA, Putty, WinScp

EDUCATIONAL QUALIFICATION

Bachelors in Information Technology, JNTUK, India.

CERTIFICATION

ISTQB Certified Tester, Foundation Level

Tricentis-Automation Specialist Level 2

Tricentis-Automation Specialist Level 1

Microsoft Certified Azure Fundamentals

Database Tester, Infosys

Client: UBS Financial Services, NJ Dec’17-Sep’2020

Description:

Zeus is a application for credit risk which receives data legal agreements, trades, counterparty info, limits, sensitivity etc. from various upstream systems then process the data as per the required logic and stores it once all the information has been processed the data is sent to downstream systems (like IRIS and ZEUS MIS applications) for front end display and reporting purpose. Here as a Test Analyst validated the data from different upstream systems loaded in the stage environments after applying the business transformations the data is loaded in the target tables where the data will be sent to the downstream applications, the data can be validated through testing.

Environment: HP Quality Center, HP ALM, JIRA,TOAD, Unix Shell Scripting, Flat files, M.S.Excel, Oracle 11g, SQL, Macros, Agile, Windows 7, Putty, WinSCP, TOSCA, Atlas(Internal Automation Tool), Internet Explorer, Mozilla Firefox, Google Chrome, Safari.

Responsibilities:

Analyzed and Reviewed the Business requirement document and Technical specification document to understand the scope of testing.

Participated in Daily Scrum calls, Demo, Retrospectives, Stories Discussion etc for Agile.

Involve in Gathering the requirements by having discussion with BA’s during walkthrough meeting.

Analyze the requirement document and call out the gaps in requirement coverage based on the current business related to the project.

Involve in creation of Effort Estimation and schedule the effort.

Executing ETL tests per business requirement. Identify types of bugs or defects encountered during testing and make a report. It is important to detect and reproduce any defects, report, fix the bug, resolve, and close bug report.

Regularly interacted with management and product owners on project status, priority setting and sprint timeframe.

Created test plan, test cases and test scripts development and executed based on business and technical requirements.

Execute Test Scenarios and Test Cases in JIRA

Attending project status meetings with clients.

Monitor the progress of testing activities based on the scope and its schedules

Assess and report the quality and status of testing deliverables.

Coordinate with UAT team on supporting UAT Data.

Coordinate with Onsite-Offshore Testing team for end-to-end testing process.

Extensively worked on web-based testing for the ZEUS application.

Created test plan, test cases and test scripts development and executed based on business and technical requirements.

Participated in walkthroughs meetings with Business team.

Reviewed Functional Requirement Specifications for creating Test strategies.

Experience in testing the Web application functionality and Web reporting Data validation.

Created Test cases based on Test scenarios drawn from functional requirements in Jira/ALM/Quality Center.

Involved in Back-end and Front-end Testing of the applications.

Co-ordinated with developers for Black Box Testing.

Execute back-end data driven test cases.

Creating test cases for ETL tasks and also related applications which communicate with ETL technologies.

Validated data transfers and flat files.

Executed Tosca Automation test cased for validating backed data.

Validating PL/SQL code and identifying potential issues.

Validating transformation logic on data and perform record count after data moved from staging to data warehouse

Performed Database Testing by creating complex SQL queries.

Validated the source system data with the staging data using SQL

Extensively worked on the defect management tool JIRA for tracking the defects.

Performed Smoke Testing, System Testing, System Integration Testing, User Acceptance Testing, Database Testing and Regression Testing.

Extensively working with Infrastructure Team for executing prerequisite jobs.

Executed batch jobs and validated data against Oracle database using SQL queries.

Worked with Infrastructure Team to provide workaround for any job failures.

Analyzed and created the bug tracking reporting and summary report in the Quality Center.

Worked on Jira for requirements management, planning, scheduling, running tests, defect tracking, manage the defects and executing the test cases.

Executed SQL Queries and made sure that values entered in front end is stored successfully in the appropriate data tables.

Ensured Test Entrance and Exit Criteria is met and complete the Test Completion report for any Risks involved in promoting the code during migration of code in to production if any defects are not resolvable in the current Release.

TATA CONSULTANCY SERVICES Feb’13-Apr’15

Client: Bank of Montreal

QA Engineer

Description: The Bank of Montreal (BMO) financial group is diversified financial services provider that provides range of retail banking, wealth management and investment banking products and services in Canada and USA. It conducts business through operating groups, including Personal and commercial banking. BMO provides web base product to allow external and internal users to make mortgage & personal loan payments.

Project 1: OLBB Mar’14-April’15

In BMO started a major transformational programs journey to merge its US and Canada Based legacy applications as a Portal. This Implementation could help all four types of customers (US/Canada/Cross Border US/Cross border Canada) by serving needs to keep a track of Balance and Transaction and Other Account Information

The Account Information Reports serves as a platform for all customer displaying the Balances and transaction for all types of entitled accounts and services offered by Bank of Montreal (BMO). All the Reports are tested using Selenium Web Driver with multiple cross browsers.

Environment: HP ALM, JIRA, Quality Center, Microsoft Excel, SQL Developer, SOAPUI, REST Web services, Selenium WebDriver, Eclipse IDE, Java, Cognos, TIBCO Jasper, TestNG Framework, Jenkins, Oracle 11g, SQL, Agile, XML, Windows 7, Internet Explorer, Mozilla Firefox, Google Chrome, Safari.

Responsibilities:

Analyzed and Reviewed the Business requirement document and Technical specification document to understand the scope of testing.

Involved in designing and building automation frameworks in support of continuous integration in a test driven development (TDD).

Regularly interacted with management and product owners on project status, priority setting and sprint timeframe.

Involved in daily Agile standups, analyzing, estimating user stories and delivered them on time.

Worked closely with development team in creating automated scripts for the application using Selenium.

Created test plan, test cases and test scripts development and executed based on business and technical requirements.

Responsible for fixing and maintaining regression automation test scripts for end-to-end testing using Selenium WebDriver (using Java).

Responsible for creating and maintaining automation acceptance test suite using Selenium.

Also responsible for converting automation scripts to new framework using Selenium WebDriver and Java.

Designed and Developed Test Automation Framework using Selenium WebDriver.

Involved in Web Services Testing using SoapUI with REST to create and execute automated functional, regression, compliance, and load tests.

Involved in conducting tests on Web services transactions like automatic bill payment, wire transfers, batch payments and Account transfers sent over HTTP or HTTPS by inspecting every XML request and response using SoapUI.

Involved in testing Reports generated in OLBB Application.

Extensively worked with Onsite Team to coordinate the Testing of the application.

Performed Parallel and Cross Browser compatibility testing on different browsers like Internet Explorer, Chrome, Safari, and Firefox where multiple tests were run at the same time.

Performed Smoke Testing, System Testing, System Integration Testing, User Acceptance Testing, Database Testing and Regression Testing.

Performed Database Testing by passing SQL Queries and retrieved information from database.

Performed white box testing for all the modules including business service, controller and data service layer components.

Tested different detail, summary reports and on demand reports.

Involved in reviewing Test cases/ Test Plan with team members.

Implemented manual and automated testing methods to perform functional, load, Integration and regression testing using Selenium.

Executed system, integration, end-to-end and user acceptance test (UAT) test cases.

Analyzed and created the bug tracking reporting and summary report in the Quality Center.

Worked on HP ALM (Test Management software) for requirements management, planning, scheduling, running tests, defect tracking, manage the defects and executing the test cases.

Executed SQL Queries and made sure that values entered in front end is stored successfully in the appropriate data tables.

Conducted quality reviews to monitor the progress of project.

Ensured Test Entrance and Exit Criteria is met and complete the Test Completion report for any Risks involved in promoting the code during migration of code in o production if any defects are not resolvable in the current Release.

Project 2: Enterprise Wire Payments Feb’13-Feb’14

As part of this project, the main objective is to check the Payments data is migrated from BMO HARRIS TO BMO, EWP used to check the customers based on the Payment types. I performed ETL Testing after data is loaded from Source to staging all the business Functionality is validated by writing SQL QUERIES to check whether data is populated or not in target tables.

Environment: Informatica Power Center 9.1, SQL, HP Quality Center, SQL developer, Oracle 10g, MS Excel, Windows XP, Agile, Jira

Responsibilities:

Reviewed the Business Requirement Documents and the Functional Specification.

Developed Test Cases for Deployment Verification, ETL Data Validation.

Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.

Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.

Reviewed Informatica mappings and test cases before delivering to Client.

Worked as ETL Tester responsible for the requirements/ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.

Experienced in writing complex SQL queries for extracting data from multiple tables.

Testing has been done based on Change Requests.

Preparation of System Test Results after Test case execution.

Performed Functional, Regression, Data Integrity and System Testing.

Extensively used Informatica power center for extraction, transformation and loading process.

Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.

Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center.

Prepared Test status reports for each stage and logged any unresolved issues into Issues log.

Writing the test scripts for manual testing.

Involved with ETL test data creation for all the ETL mappings.

Preparing and supporting the QA and UAT test environments.

Communicated discrepancies determined in testing to impacted areas and monitored resolution.

AdvBackOffice Apr’12-Jan’13

QA Analyst

Description: Advanced Back Office Solutions offers comprehensive solutions to manage convenience store back office operations with unique software product offerings covering areas like – price book management, invoice management, inventory management, financial management, barcode label printing. The main achievement of this project is to check if the business is on track, identify the things which are going wrong, take and monitor corrective action

Environment: SQL, SQL developer, Oracle 9.2, HP QC

Responsibilities:

Involved in SDLC and STLC process.

Developed, implemented test plan, test strategies and Test Cases to ensure complete testing, stability and overall quality of all the applicants.

Experience in Writing test plans, test cases, test procedures based on business requirements.

Supported new and existing products by configuring and testing software products and software components of a website.

Wrote SQL queries and statements to test database for retrieving information.

Design, document, manage execute test cases and test suites.

Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.

Involved in extensive DATA validation using SQL queries and back-end testing.

Executed manual test case. Tracked defect using QC.

Planned and developed Functional, Integration, Regression and System level testing scenarios and Tested application manually.

Defined the test criteria and project schedules, and base lined the Test Plan with the help of project meetings and walkthroughs.

Prepared Requirement traceability matrix (RTM) for the application.

Parallel interaction with development team and members of Quality Assurance team for cross checking the correctness of the test results.

Contact this candidate