Anitha Gade

Ph: 903-***-****

E-mail:acujft@r.postjobfree.com

Professional Summary:

Over 8 years of IT experience in Software Testing of web based and Client-Server applications with full understanding of Software Development Life Cycle (SDLC).

Extensive experience working in, Financial, Healthcare, Insurance applications

Well versed in manual and automation testing.

Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, Configuration testing, Interface testing, Stress and Performance Testing.

Extensive experience in testing reconciles (initial) and delta (daily) loads.

Proficient in using Quality Center/ALM.

Extensive experience in developing Test Plan, Test Strategy, Test Cases, Test Scenarios, Test Scripts, Test Metrics, Test Reports.

Good understanding with Business Requirement Documentation (BRD), Functional Documentation and System Requirement Specification (SRS).

Prepared Traceability Matrix for Test Coverage using QC.

Proficient in System Testing, Integration Testing, Functional, Regression, GUI, Stress, Smoke Testing, End-to-End Testing.

Performed Data validation testing and verification.

Experience in Database testing by using Oracle & SQL databases, SQL, Joins, and SQL Queries.

Worked on projects with SOA Architecture.

Worked on web service testing using SOAP UI Tool.

Good Exposure in testing SOAP Web services by using SOAP UI.

Excellent knowledge in testing applications developed in JAVA, JSP, XML, HTML, .NET and JavaScript

Meets Testing schedules and Project timelines and Ability to handle multiple tasks works independently and as well as in a team

Excellent Analytical, Problem solving, decision making and presentation skills. Can adapt to any newer technology or software at a greater pace. Able to define and fulfill the project’s goals.

Education:

Masters of Computer Applications(MCA), Osmania University

Technical skills:

ETL Tools

Informatica Power Center 9.5.1,

Data Stage 8.0, Ab Initio 3.0

QA Tools

HP – Quality Center, ALM, Quick Test Pro (QTP)

DBMS/Query Tools

TOAD, Rapid SQL, SQL Developer, SQL Navigator

Languages

SQL, PL/SQL, C, Java

Databases

Oracle11/g/10g, SQL Server 2008/2005/2000, DB2, Sybase

Teradata V2R6/V2R5

Requirements Tools

Doors, Rational Requisite Pro

BI / Reporting Tools

IBM Cognos 8.0, Business Objects BOXI, SSRS

Operating Systems

Microsoft Windows – Vista, XP, 98, 2000, NT 4.0

UNIX – Sun Solaris, HP-UX

Scheduling Tools

Autosys

Other Tools

TextPad, CompareIT, PuTTY, WinScp.

Professional Experience

Client : GEICO, MD, USA

Duration : Apr’15 – Till Date

Role : QA Analyst

Assignment and Scheduling Claim Handling:

Accident Tracking and Loss Assignment and Scheduling (ATLAS) is the name of our web-based claim system replacement project. The First Notice of Loss (FNOL) application is the first piece of the web-based claims systems to be implemented. This loss report tool delivers a single claim system for you to create a loss report.

The ability of ATLAS to consolidate these tasks within a single First Notice of Loss application provides for a more streamlined and efficient loss report process. Additional efficiency gains result from the automation of some tasks and the reduction of manual tasks to a single mouse click.

Responsibilities:

Developed the complete Test documents like Test Plan, Test Cases, and Test Scripts by analyzing Business requirement documents, Technical and functional design documents, Use cases.

Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.

Involved in validating claims, enrollments, and membership.

Validated reports for specific and aggregation accumulation data.

Extensively involved in System testing / Functional, Regression testing and Integration testing.

Prepared Test Cases for system testing and uploaded them into ALM; linked the test cases to the business requirements.

Ran the manual test cases from Quality Center Test Lab.

Wrote Complex SQL queries to support the test case results.

Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.

Performed Database (metadata) validation before loading the data in to the target tables.

Performed Data Validation by testing the delta/daily and reconcile/data loads.

Created SQL compare statements to validate Actual results with the Expected Results.

Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements to determine the feature coverage.

Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.

Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.

Verified ETL logs and reject/discard files for errors and reported them to development team.

Worked on Informatica Workflow Manager to run the workflows and Monitored the status and logs in Workflow Monitor

Provided support for Technical Integration and Prod Control teams for execution of ETL mappings.

Written several complex SQL queries for validating Business Objects Reports.

Extensively tested Business Objects reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.

Smoke testing the new builds for QA-acceptance

Responsible for defects management and driving to resolution and retesting the same.

Estimated level of effort (LOE) for testing effort and reported to Test Leads.

Performed Quality Assurance activities for data validation, data scrubbing, data profiling.

Created shell scripts and used Unix commands to manipulate input files for test execution

Created test data for all ETL mapping rules to test the functionality according to requirements.

Used Rational Clear Quest for defect management.

Ensured quality products delivered and installed as specified in the statement of work (SOW).

Environment: Informatica 9.5.1, SQL, PL/SQL, Remedy, Oracle 11g, TOAD, Rational Clear Quest, Doors, Putty, VB Script, ALM, Autosys, UNIX

Client : Fanniemae, VA

Duration : Aug’14– Mar’15

Role : ETL/Quality Analyst

Description: The objective of enterprise data quality tool is to check the data quality on the critical fields and produce the results in the form of reports to the business users, the tool is used by the serval different applications within organization.

Responsibilities:

Prepared Test Strategy Document and Test Case Document, Requirements Traceability Matrix to map the requirements with their respective test cases.

Designed and developed detailed Test Plans and Test cases which specify testing overview and testing approach depending on the Business and Technical Requirements.

Executed the jobs through Autosys.

Created the Autosys reports using JAWS tool.

Performed Functional Testing, System Testing, Integration Testing, Regression Testing. Tracked and managed defects using Mercury Quality center.

Worked on end to end executions using Autosys scheduling tool.

Created data quality rules and tested the rules using informatica data quality analyst tool.

Validated the messages using GEMS posted on the queue and topic.

Monitored the job executions using informatica workflow monitor and verified the logs.

Validated the data loaded into the target database.

Developed and modified Unix Shell scripts to automate QA execution process in Test environment.

Developed required SQL scripts for database testing and Performed Backend Testing, by executing the SQL queries. Wrote SQL Queries to extract data from the Tables.

Analyzed tables and indexes for performance tuning, optimizing database objects and streamlining applications.

Executed the Test Scripts on different releases and validated the actual results against the expected results.

Developed automation scripts using QTP and integrated the scripts with master script.

Involved in the automation of the Regression suite execution using QTP.

Involved in User Acceptance Testing by providing test data for users and by testing UAT defects in test environment before, the new code gets moved to UAT environment.

Created test Execution Report, Test Completion Report for Test Sign Off, documented the testing process and Test evaluation summary.

Involved in Code Review, Design Review, Test Case Review meetings with business analysts and developers.

Environment: Informatica9.5.1, ALM, Autosys, JAWS, Sybase, Oracle 11g, Toad, IDQ Analyst, QTP, UNIX, Rational Clear Quest, Doors.

Client : Bank of America, NY

Duration : Jan’12 – Jul’14

Role : Quality Analyst

Description: Bank of America is a major and independent leading provider of credit cards and deposit products to customers. Universal New Account System (UNAS) is used to manage applications and applicant information. UNAS is an enterprise wide credit card application processing system. Worked on the banking application. The customers can access Account details like the Checking and Saving Account details, can view, update mortgage information and can make the payments directly from the checking accounts.

Responsibilities:

Worked on Developing, executing and maintaining Test Plans, Test Scenarios, and Test Cases Documents in ALM (Application Lifecycle Management) based on business requirements.

Involved in designing the QTP scripts using Manual Test Cases

Developed the share repository using QTP Object Repository Manager

Testing process involved daily test activities through Agile Scrum 'stand-up' meetings.

Created and executed the test cases for various scenarios, and participated actively in system, integration, performance and regression testing for every new build released.

Used ALM to develop test cases, and executed them in test lab.

Created the UAT Test Plan by entering high-level requirements from the Statement of Need and Functional documents, as well as identified test scenarios, into the UAT Test document.

Ensuring the execution of UAT Test Cases and documentation of test results.

Entered the defects into ALM and manages the resolution and documentation of these defects.

Performed Development Integration, System Integration, End to End and User Acceptance Testing for the data services.

Good in database testing by using SQL queries retrieved the data from database for data validation.

Performed happy path and unhappy path testing scenarios.

Creating test case and test sets, tracing them to requirements and executing them in ALM.

Analyze all Report Bugs for continuous process improvement and keep tracking on the SDLC critical path.

Used SOAP UI to validate the response of web services with the data in Host.

Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT

Initiated and participated in conference calls, walkthrough and review meetings.

Environment: QTP 11, Load runner, ALM, VBScript, DB2, Unix, Shell Scripting, Oracle 11g, SQL Server 2008, MSWord, MS Excel, Windows XP/7.

Client : Cisco, San Jose, CA

Duration : Jul’08 – Dec’11

Role : Quality Analyst

Responsibilities:

Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.

Performed the data analysis and data mapping and designed and documented the conversion documents.

Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.

Supported go-live and post-go-live, which included code/process tracing for debugging and performance-tuning.

Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.

Participated in developing the file management and ftp process for transmitting the files, also scheduled the daily batch process.

Worked on issues with migration from development to testing.

Developed Requirement Traceability Matrix (RTM) by matching the requirements and test cases.

Performed Regression testing/system integration/integration testing/ System Integration testing/ Smoke testing.

Used Test Director for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.

Manually ran the test scripts in Test Director and documented the results.

Environment: Oracle, Toad, SQL, PL/SQL, Cognos, SQL Server 2000, SQL Navigator, Test Director, Windows, UNIX AIX, VI Editor, PuTTy.

Contact this candidate