MarisettyAnuradha

adc6we@r.postjobfree.com

PH: 571-***-****

Summary:

Worked as a Software Quality Assurance Engineer for Eight years with diversified experience in Manual and Automated testing of software projects, database testing, Unit Testing. Well conversant with languages such as C++, Java, JavaScript, TSL, UNIX scripting. Proficient in tools such as TOAD, Rational ClearCase and automation tools such as WinRunner, Quick Test Professional, Test Director, Quality Center. Expertise in creating Test Plans, Test Cases and designing test strategies. Well conversant with all phases of software testing lifecycle. Possess extensive knowledge of problem solving techniques, excellent analytical skills coupled with good communication, interpersonal skills and known to be a team player.

Professional Expertise:

8 years of experience in both manual testing and test automation of financial applications

Experience in complete test life cycle - test analysis, test design, test planning, test execution and test reporting

Expertise in converting requirements documents to test plan and test cases and implementing Manual Testing Process based on the test plans and test cases.

Experience in both functional and non-functional testing

Experience in testing web applications, client-server applications and package implementations

Proficient in using QTP, Load Runner, Quality center and TOAD

Experience in creating Master Test Plan and identifying the scope and the complete life cycle of the testing effort of software projects and high level test strategy.

Involved in the Database Verification tasks such as Schema Verification, Trigger and Stored Procedure Verifications, Input / Output database verifications.

Involved in the writing SQL scripts for verifying the integrity and correctness of the backend database

Expertise in command line UNIX commands to manually test software applications.

Liaison with development team and business users

Ability to quickly Master new concepts and applications.

Technical Skills:

Languages

Java, TSL, PL/SQL, VBScript

OS

Windows 95/98/NT/2000/XP, Linux, Unix

Databases

Oracle 10g, SQL Server, MS Access, DB2

Testing Tools

Mercury : WinRunner 8.0, QuickTest Professional, Rational Suite

Test Management

Mercury : Test Director, Quality Center

Code Objects. May 2018 – Present.

QA Analyst.

Code Objects provide solutions to insurance companies and allows simplified, flexible, and more profitable insurance operations from quote to renewal.

Responsiblities:

Responsible for developing and executing formal test plans to ensure delivery of quality software applications.

Responsible for documenting to ensure operational and future maintenance capability and providing user training and interface for new and modified programs and/or systems.

Responsible in the preparation and review of Test Plan/Test Strategy/Test Scenario, Integration and System Test cases for Web based applications (front-end and back-end)

Involved in writing Test Cases, procedures, reports and approval of software release.

Responsible for execution of Test Cases Manually.

Responsible for generation of Data for execution of Test cases

Created test cases and scenarios for Unit, Regression, Integration, as well as Back-end, GUI and System testing.

Consulted with business staff to develop understanding of the varied and complex business needs supported by the system

Utilized QTP Automtion tool and have excuted test scripts as part of regression testing.

Extensively executed and verified SQL Queries on SQL Server.

Extensively used SQL statements to validate the front-end values with the backend of the application

Created and executed test scripts for functionality, black box, regression and system integration testing. Performed Security Testing on web and application servers and tested the application across different platforms like Windows NT, Windows 2000.

Created data requests for the Data Performance team. Designed and executed SQL Queries to pull data from Oracle using TOAD and SQL* PLUS. Generated reports to ensure data integrity and validated the business rules in Oracle database.

Involved in writing Test Cases, procedures, reports and approval of software release.

Created test cases and scenarios for Unit, Regression, Integration, as well as Back-end, GUI and System testing.

Used Test Tracker to track and report system defects and bug fixes. Writing modification request for the bugs in the application and helped developers to track the problem and resolve the technical issues.

Verified the rectified bugs by retesting the application after the defects are fixed.

Involved in maintaining the Requirements Trace ability Matrix (RTM) across the deliverables of a project

Attending daily stand-ups, interacting with developers to resolve issues.

Forms verification as per the requirements

Communicate project status to stakeholders, and receive formal signoff as appropriate

Write test cases and performed the execution of test cases and documented the test results with screen caps for all the test case steps.

Performed Verification at various environments like System test, Internal UAT and Production.

Involved in testing Cloud based web applications and executed batch jobs and validated backaend results .

Coordinate with end users to schedule and support User Acceptance Testing.

Environment: Quality Center, Rational Clear Quest, AWS,HTML, XML, SQL,Oracle 11g, WINDOWS XP, Unix Solaris 11, Web Services,SoapUI,JIRA.

Fanniemae, DC. Oct 2015, – May 2018.

UAT Tester.

Is the leader in today's secondary mortgage market. Fanniemae works with mortgage bankers, brokers, and other primary mortgage market partners to help ensure they have funds to lend to home buyers at affordable rates.

Responsiblities:

Involved in Fit Gap sections for AR and Billing Upgrade Project.

Arranged Meeetings with Business Users in collecting requirements for Billing Upgrade project.

Developed several Systems Integration test scripts based on requirements, business rules and use cases.

Developed test scenarios for the new functionalities in Billing,AR and AM in accordance with the Business Requirement Documents and Functional Requirement Document.

Executed a comprehensive suite of regression testing covering functionalities across Billing/AR/AM.

Tested Excel to CI bulk upload functionality used in Billing and AM module.

Extensively executed and verified SQL Queries on SQL Server.

Extensively used SQL statements to validate the front-end values with the backend of the application

Created or Updated queries using query manger and developed SQL queries based on user requests.

Created Test Plan,Test Summary Reports and generated test execution reports from Quality center.

Extensively worked on testing the applications response for positive and negative sets of data with data-driven testing procedures.

Experience interacting with actual business stakeholders to gather requirement, analyze requirements, and provide solutions to a tight deadline

Collected weekly test metrics that reflected the current status of the test execution and the state of the defects.

Supported business users by opening production tickets to technical team.

Executed Shell Scripts in UNIX to handle the different objectives of Start-of-Day, End-of-Day and Weekend Data Load processes.

Execute the test cases in Quality center,Logged in the Defects using Clear Quest.

Attended daily agile standup team meetings with developers and other team members to provide daily status and updates.

Involved in providing shakeout documents to business users and supported users in performing intial shakeout during the project implementation.

Created and set up test data in preparation for automatic and manual test script execution.

Used Regression suites for AR and Billing Modules and automated test scripts .

Environment: Quality Center, Rational Clear Quest, Requiste Pro,HTML, XML, SQL,Oracle 11g, WINDOWS XP, Unix Solaris 11, Peoplesoft 8.8 & 9.1, JIRA.

Freddiemac, VA. Sep 2012, – Sep2015.

QA Analyst.

Freddie Mac plays a vital role in helping families to buy home. Freddiemac role in secondary market is to connect borrowers, lenders and investors from around the world in a continuous cycle that makes home possible for millions of America's families.

Responsiblities:

Involved in analyzing Business Requirements and Functional Specification documents for developing and enhancing existing test cases.

Tested web applications based on the business rules related to HAMP,Std Mod and Alt Mod.

Executed UNIX Shell scripts by running Batch Jobs and Autosys Jobs and validated test results by checking logs and output.

Responsible for test planning,test case development and test script execution for System and Integration testing

Extensively used SQL statements to validate the front-end values with the database values of the application.

Tested different applications based on the business rules related to alternative to foreclosures like Standard Short Sale, Make Whole,Hafa Short Sale and Regular Short sale.

Designed and executed SQL Queries to pull data from database using TOAD and SQL* PLUS. Generated reports to ensure data integrity and validated the business rules in Oracle database.

Worked on enhancement projects for applications like Workout prospectus,Loss Mitigation Work Station and MPS Underwriting Appliaction.

Prepared SQL queries based on Physical data mapping and Logical Data mapping documents.

Responsible in writing detailed test cases based on the requirements. Generated Requirements Traceability Matrix (RTM) and Mapped test cases to baselined requirements.

Involved in performing Smoke testing, Functional testing,Data Base Testing Regression testing, Integeration Testing and End to End testing.

In depth understanding of Software Development Life Cycle, Software Testing Life Cycle and QA methodologies including Waterfall and Agile methodologies to ensure appropriate Quality Control.

Involved in creation and documentation of Test Plan with Test Lead.

Involved in analyzing and proposing solutions to the Production issues.Involved in Analysing and testing applications that has Production issues

Used Quality Center to track and report system defects and bug fixes. Writing modification request for the bugs in the application and helped developers to track the problem and resolve the technical issues.

Responsible to create execution status reports in HP Quality center and send to the manager/team on a daily basis.

Developed manual test cases for Positive, Negative, Functional and Performance Testing.

Peer review of the documents like Test plan and test scripts developed by the Team.

Uploaded files and excuted bypass batch jobs in UNIX and verified if loans are created.

Validated business rules by writing SQL queries and comparing data from source to destination

Tested compensation,Get actuals and EDR jobs in LMWS.

Tested MIAccess Application that involves manual claim creation and automatic claim generation for different MI Companies.

Loaded XML files data in to Oracle database.

Environment: UNIX, Windows XP, DOORS, SQL, DB2, Visio, .NET, DB2 v9,Oracle 10g,11g, MS SQL Server, HP Quality Center, Rational ClearQuest, XML.

Fanniemae, DC. Jun 2012, – Aug 2012.

UAT Tester.

Is the leader in today's secondary mortgage market. Fanniemae works with mortgage bankers, brokers, and other primary mortgage market partners to help ensure they have funds to lend to home buyers at affordable rates.

Responsiblities:

Involved in Testing upgradation of Billing and AR Applications from 8.8 to 9.1.

Developed several Systems Integration test scripts based on requirements, business rules and use cases.

Created and set up test data in preparation for automatic and manual test script execution.

Developed test scenarios for the new functionalities in Billing,AR and GL in accordance with the Functional Design Document and Technical Design Document.

Tested Approval workflow in Billing module for Billing Invoices.

Executed a comprehensive suite of regression testing covering functionalities across Billing/AR/GL.

Tested Draft and Dunning processes in Account receivables Module.

Created Invoices, Finalized invoices and tested invoice Print process

Involved in upgrade testing of PeopleSoft Modules Billing, Account Receivables and GL.

Extensively executed and verified SQL Queries on SQL Server.

Extensively used SQL statements to validate the front-end values with the backend of the application

Performed database testing by writing PL/SQL queries.

Extensively worked on testing the applications response for positive and negative sets of data with data-driven testing procedures.

Collected weekly test metrics that reflected the current status of the test execution and the state of the defects.

Tested the real-time and batch interfaces Like Direct debit.

Executed Shell Scripts in UNIX to handle the different objectives of Start-of-Day, End-of-Day and Weekend Data Load processes.

Execute the test cases in Quality center,Logged in the Defects using Clear Quest.

Involved in daily team meetings with developers to discuss the issues and to get estimates for Defect fixes

Environment: Quality Center, Rational Clear Quest, Requiste Pro,HTML, XML, SQL,Oracle 11g, WINDOWS XP, Unix Solaris 11, Peoplesoft 8.8 & 9.1, JIRA.

Halfaker and Associates Sep 2011-Jun 2012

QA Analyst

Halfaker and Associates, is a technology solutions firm, advises and assists government organizations and commercial clients.

Responsibilities:

Responsible for test planning, test case development and test script execution.

Created and executed test scripts for functionality, black box, regression and system integration testing.

Responsible in writing detailed test cases for the application and mapping the test cases to RequirementsTraceability Matrix (RTM)

Performed GUI interface testing for webapplications on client side.

Logged and traced defects in Quality center and created Test Metrics to analyze the defects

Created XML test files based on XML schema.

Responsible for execution of Test Cases Manually in Quality Center.

Worked with SQL & PL/SQL to test database integrity.

Involved in working closely with various teams in the Software Development Life Cycle including business teams, development,database administrators and system architecture in troubleshooting activities to identify business logic and coding errors.

Participated in defect review & go-no/go meetings.

Used TOAD extensively to manipulate oracle data and debug, test oracle procedures

and functions in SQL.

Regularly gave status updates to the Quality Manager on test execution

Tested the Unix Shell Scripts developed for file transfer, processes the return file, checked the server and database running on UNIX and performed database testing by writing and executing SQL queries.

Run the test scripts on multiple browsers like Netscape, Internet Explorer and reviewed results on various Platforms like UNIX, Windows NT, Windows 95/98.

Participated in weekly meetings for status updates and changes on the project

Performed Regression testing as fixes emerged

Responsible for White Box & black box Testing to test the application.

Created Test execution log, Test Defect log and Test evaluation Summary documents.

Created detailed UFT test cases and provided guidance in execution of UFT.

Environment: Quality Center, Asp.Net, Java Script, HTML, XML, Oracle 8i, SQL Server 2008, WINDOWS NT/2000.

TIAA-CREF Jan 2011-July 2011

QA Analyst

TIAA-CREF is a financial services company,TIAA-CREF offers a range of investment products and services to help investors achieve lifetime financial security.

Responsibilities:

Involved in Business meetings with SME’s for the walkthrough of requirements and application.

Created Test Plan from business requirements for System balance & controls project for Financial dataware.

Created Test Plan for Peopesoft Financials Cost-alignment project

Created Test cases for PS cost-alignment project for allocating expenses for Xerox,postage,Purchasing accruals, Performance compensation allocations.

Created and set up test data by creating journals for testing allocations in peoplesoft general ledger.

Collected weekly test metrics that reflected the current status of the test execution and the state of the defects.

Tested application engine and SQR process that were created in people soft general ledger like Rent and occupancy,performance compensation,copy and postage and Benefits allocations manually.

Used SQL Server management and verified data present in database by writing SQL queries.

Interacted with offshore team regularly and assigned work related to the projects.

Tested data flow from Omni application to Financial dataware house.

Proficient use of Quality Center to log and track defects and to keep track of the Business Requirements.

Verified the rectified bugs by retesting the application after the defects are fixed.

Extensively used SQL statements to validate the front-end values with the backend of the application.

Involved in tracking and updating of the Requirement Traceability Matrix, thereby linking the test cases with the business requirements as well as other associated test cases.

Created Application Understanding documents for Summary Prospectus project, System Balance and Controls project and peoplesoft Cost Alignment project which are used by On-site and offshore teams.

Performed back end testing using Query analyzer and Crystal reports

Involved in Integration testing and Regression testing of the people soft application

Participated in defect review and go-no/go meetings.

Verified the files that enters into CTLS are in correct format where these files will be used for loading data in FDW.

Environment:Windows XP,Quality center,Sql Servermanagement studio,People soft 9.0.

Academic Qualification:

Masters in Computer Applications (MCA) - Hyderabad,India

Contact this candidate