Test Cases Data

KAVITHA ANCHA

Email: ************@*****.***

Mobile: 774-***-****

https://www.linkedin.com/in/kavithaancha

SUMMARY

Nine Plus years of software testing experience in Functional Testing, User Acceptance Testing, Workflow Testing, Business Testing, Security Testing and Database Testing.

Extensive experience as business tester in capital markets - Investment banking middle office applications, Migrating the Investment Management operations from legacy systems to Enterprise System by providing end-to-end solution including Transaction management, Middle and Back Office Operations, Corporate Action Processing, Pricing, Valuations, Reference data and Asset Management and Custodial Services, Information Delivery and End Client Reporting.

Experience in creating test plans, defining test scenarios, test steps, test data and traceability matrix from requirement documents.

Expertise in Backed end testing, Black-Box testing, User Acceptance Testing (UAT),

Functional Testing, Positive/ Negative testing, System testing, Regression testing,

Integration testing, GUI Software testing, Boundary Value testing.

Hands on experience in developing DDL and DML queries in databases like Oracle and MS-SQL Server.

Experience in Integration, System & Regression Testing in BUAT, CUAT and PROD environments.

Set up Selenium tools from scratch and configured various other peripherals tools to perform Selenium test.

Performed automation of test cases for Regression Testing using UFT and Selenium, testing Functional, Acceptance and Limit validations.

Automation Frameworks – Hybrid, Keyword driven, Data driven frameworks.

Onsite – Offshore working model.

Proficient with all phases of software development life cycle (SDLC) and delivering projects in Waterfall methodology.

6+ years of experience in Agile-Scrum testing methodology.

Participate in preplanning meeting, daily scrum and end of iteration ceremonies for each iteration.

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

Testing and

Automation Tools

HP Quality Center, Jira, HP Quick Test Professional, AML UFT, Selenium WebDriver, Selenium IDE,

Operating Systems

Windows NT 4.0, Windows 98, Windows 2000, Windows XP and Windows 7.

Languages

VB Script, SQL, XML, CSS, XPath, Visual Studio,

Database

MySQL, Oracle 9i/10g/11g/12c

Database Test tools

Squirrel, TOAD

Agile Tool

Rational Test Concert

EDUCATION

Bachelor of Computer Science & Information Technology, JNTU, INDIA

PROFESSIONAL EXPERIENCE

State Street Corporation

Quincy, MA

Project 2 -AML-FID EDD Dec’17– May’19

SQA Lead

Responsibilities:

Participated in all phases of testing and documentation.

Reviewed functional specifications with client regarding new changes in FID & EDD.

Worked with project management team to design tests that will ensure release goals are met before final deployment of product.

Handling SQA team both offshore and onsite.

Identified and documented software discrepancies and prepared clear and concise reports on defects in the QA process

Verified the alerts and transactions between FID UI(UAT) and database for different scenarios from eleven multiple sources.

Verified the alerts and transactions between FID database and ESP categories through feed loads.

Identified test cases and automate them using Selenium WebDriver, TestNG and Java technologies (Eclipse IDE).

Contributed in framework creation.

Developed automated test strategies, and implemented automation procedures reviewing change request documents, defect description.

Worked closely with developers during test execution to ensure proper communication of defects to them.

Worked on functional, UAT testing and regression testing.

Reviewed test results, defects with the product owner and provide the status updated to the team.

Project 1-IMS Mar’16 – Nov’17

Business Tester

Responsibilities:

Extensively worked on ESP (Database) which includes Defining Data Elements, Outlining Filter Conditions/Logics, and Configuring Data Mapping between different Databases, Custom Feed Management and Assisting Dev Team to building up new Marts and Categories…Etc.

Worked with business and operations Team/Users to define the business requirement specifications and proactively communicate and collaborate with external and internal stakeholders to analyze information needs and functional requirements and deliver the following artifacts as needed: Functional/ Business requirement specifications documents (BRD and FSD), requirement traceability matrix, knowledge capture docs, use cases, change request, project metrics, Agile stories…etc.

Validated middle office activities like processing the transactions, settlement, matching and processing the corporate action, manual pricing, cash and FX processing.

Setting up and maintaining the securities reference data in the asset control and enterprise system from EDM.

Created QTP automation framework for BUAT, CUAT and PROD regression.

Created script for trade processed and report generation.

Performed trade data flow analysis through IMS Enterprise Applications like RKS, GTM, RMG & ESP

Created SQL queries and executed them using Squirrel tool.

Created macros to compare the Extracts.

Created OCF checks to check the performance of the marts.

Defect Management, business needs and project objectives via feedback sessions and client meetings in collaboration with all stakeholders.

Bank of America Jan’14 – Feb’16

Charlotte, NC

Sr. Test Analyst

Responsibilities:

Worked with the Equity Portfolio Managers, managements, and Trade-Ops to gather the manual entries and data points.

Designed and developed test plans / test cases and performed repeatable testing procedures -UAT Testing and processes, ensuring applications ran smoothly.

Gathered requirements, interacting with users and created requirement specification artifact.

Created business use case models and activity diagrams.

Analyzed business requirements and segregated them into high level and low-level use cases, using Rational rose per UML methodology.

Defining the data process models using business rules, business use-case model and business object model

Participated in Requirement Analysis of the application and performed GAP analysis.

Worked on SQL queries with joins on multiple tables

Ensured that logical and physical designs fit it with the overall application and data architecture

Performed backend testing using DDL queries to validate data for database.

Conducted reviews of test plans, cases with developers and delivery manager.

Used HP Quality Center for requirements traceability, maintain & execute test cases and to report test status.

Used JIRA to log the defects and issues found in the application and generated different kinds of reports to know the status of the testing.

UBS Nov’12– Dec’13

Weehawken, NJ

QA Analyst

Responsibilities:

Worked with business analyst in requirements analysis to identify functional gaps.

Designed product test strategy.

Coordinate user acceptance testing (UAT) and UAT Sign off from users across multiple business divisions.

Manage requirements in JIRA.

Report daily, weekly and monthly QM dashboards to project lead.

Worked in backend testing by writing sql queries in Oracle.

Mentor team on Quality Center, JIRA, quality processes, test methodologies and database concepts.

JP Morgan Chase Jan’11 – Oct’12

Dallas, TX

QA Analyst

Responsibilities:

Analyze business requirements and execute detailed test scenarios/test cases to verify bug fixes.

Developed and managed test cases for functional, UAT, Regression and Integration in Quality Center.

Interacted with developers and testing teams to identify and resolve application defects.

Worked in waterfall methodology

Participated in weekly status report meetings to update testing status across dev and QA.

Used Quality Center for defect tracking and defects report.

Con-Way Freight Jan’08 – Mar’09

Portland, OR

QA Analyst

Responsibilities:

Experience working with business analysts to define and design test plan and test cases.

Perform test case management and upload test cases using HP Quality Center.

Involved in Integration testing, Positive testing, Negative testing, Functional testing, Regression testing and UAT testing.

Extensively used SQL scripts/queries for data verification at the backend using Toad.

Execute test cases within deadlines.

Participate in defect /status review meetings with Developers/ Project and QA Managers.

Contact this candidate