Test Cases Testing

SUBBA MARAMPUDI

**********@*****.***

Contact # (703) – 371 – 6929

Work status: US Citizen

SKILLS SUMMARY:

Over 9 years of experience in Health care, Mortgage, Financial domains as a Senior Software Tester/Quality Assurance Engineer in testing Client Server and Web based applications.

• Solid Knowledge of QA Testing Methodologies like Waterfall, Agile

• Proficiency in testing on various platforms including Windows and UNIX

• Strong Experience in developing Test Plans, Test Strategies, Test Scenarios and Test

Cases.

• Well versed in developing and maintaining Manual and Automated Test Scripts, creating test data, analyzing bugs, interacting with development team members to fix errors

Proficient in Creating test scenarios using Gherkin language to create automated test scripts to execute in eclipse, cucumber and Selenium framework

• Involved in developing Traceability metrics between requirements, test cases, and

defects

• Demonstrated ability to shape risk based testing approaches/plans

• Very proficient in using testing tools like Quality Center, ALM, Quick Test Professional, UFT, Software Planner, Jira, Rational Test Manager, Rational ClearQuest and Rational ClearCase, Selenium, Soap UI.

• Experienced in performing various testing like Sanity, Smoke, Unit, System, Functional, UI, Integration, End to End, Back end, Targeted, Regression, User Acceptance Testing, S508 testing, Responsive Design testing (testing on tablets and smart phones), Web Services testing

Hands on experience with COTS products testing

Well-versed in BDD process

Having working knowledge in ERP Packages like SAP Financial, SAP Business Intelligence

Familiar with ETL process and testing

• Extensive experience in executing batch jobs in UNIX environment

Proficient in working with IBM Mainframes

Knowledgeable in Security Testing

• Formulated and executed SQL queries to validate the database records for Microsoft SQL Server, Sybase, DB2 and Oracle Databases

• Experienced in creating XML files using XML Schema (XSD)

• Expertise on various defect tracking tools like Quality Center, ALM, Rational ClearQuest, Software Planner, Jira and Rally

• In depth knowledge and experience in using MS Word, MS EXCEL, Documentum, DOORS, Ensemble, Sharepoint

• Ability to work independently as well as in a team environment

• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Testing Tools: QuickTest Pro 10.0, Quality Center 10.0, Software Planner, Jira, UFT12.50

Power Designer, Rational Test Manager, SOAP UI, ALM 12.51

Bug Reporting Tools: Quality Center 10.0, Rational ClearQuest, Software Planner, Jira, Rally

Operating Systems: Windows, UNIX

Databases: SQL Server, Sybase, DB2, Oracle 11.0, MS Access 2000

Other tools: Visual Source Safe, Rational ClearCase, Ensemble, MS Visio, TOAD, Oracle SQL, Beyond Compare, Developer, SQL Navigator 4, DOORS, SnagIt, IBM Mainframes, WinSCP, Sharepoint, RestClient, Gems, JSON, Remedy, RapidSql

EDUCATION:

Masters in Science, Andhra University, India

Post Graduate Diploma in Computer Applications, Pondicherry University, India

PROFESSIONAL EXPERIENCE :

Client: Freddie Mac

Location: McLean, VA

Duration: Jan 2017 to June 2017

Role: Senior UAT Tester

Project: Selling System

The selling system is a web based system that integrates all secondary marketing functions such as pricing, contracting, loan entry, loan allocation, purchase edits, note certification, contract settlement and funding functions on one platform.

Responsibilities

Reviewed and Analyzed Business review documents to prepare the test scenarios

Generated requirements traceability matrix to identify the gaps between requirements and test cases

Conducted Smoke Testing, functional testing, Integration testing, Regression testing, Back- end testing, SOX testing, end to end testing

Created Mismo XML files for data creation

Utilized WinSCP to verify early funding extracts

Written SQL queries to retrieve data from database to validate the input data

Utilized ALM for test management, execution and defect Management

Executed Batch Jobs and analyzed the results

Tested web services using SOAP UI

Followed waterfall methodology

Worked closely with automation team for data support

Participated in testing when the application went live

Experienced in using Data Comparator tool for data comparison

Tested end to end Cash and Guarantor contracts functionality until funding

Utilized OIM (Organizational Individual Management) to assign roles for the sellers, to add warehouse lenders, to add wiring instructions and to expire wiring instructions

Copied the existing Master commitments from production and modified as per user needs in TPA (Terms, products and agreement)

Applied funding data correction in PFDC and verify the data in LAPP, CAPP, TDS and ODS

Executed the smoke test VB scripts and regression VB scripts in UFT

Environment: ALM, Sharepoint, Oracle, SQL, RapidSql, Doors, WinSCP, Non-Prod VDI,

UFT 12.02, Java, Data Comparator, SOAP UI

Client: Fannie Mae

Location: Herndon, VA

Duration: Aug 2014 to Oct 2016

Role: Senior UAT Tester

Project: Loan Delivery Next Generation (LDNG)

LDNG is a new business application platform that allows lenders to deliver loans that meet Fannie Mae approved eligibility requirements.

Responsibilities

Reviewed and Analyzed Stakeholder requirement documents, Solution spec, User stories to prepare the test scenarios

Transformed application business requirements into test cases and test scripts for

manual and automated testing

Created requirements traceability matrix in ALM

Executed automated regression test suite in Eclipse for the existing functionality

Conducted Smoke Testing, UAT testing, User Interface testing, functional testing, Integration testing, Regression testing, Back- end testing, UI testing, Parallel testing, Rules testing

Created Mismo files for data creation using XML Spy

Followed BDD process for automation

Used RestClient for testing Restful Web services

Utilized WinSCP for various configuration changes, to verify logs and to validate

various request and responses

Imported rules and created seller variance, Rule extension, Standard message and Transaction waiver in BRO

Written SQL queries to retrieve data from database to validate the input data

Created test scenarios using Gherkin language to create automated test scripts to execute in eclipse, cucumber and Selenium framework

Utilized Rally for defect Management

Used Gems for sending and Receiving messages

Used ALM for test management and execution

Utilized Remedy to open incident tickets

Validated Schedule of Mortgage reports

Executed Autosys Jobs and analyzed the results

Worked in Agile methodology

Verified the logs using WinSCP for any environmental issues and closely working with infrastructure team to resolve these issues

Worked closely with automation team to create and review the Gherkin keywords prior to writing automation scripts

Environment: ALM, Rally, Sharepoint, Gherkin, Selenium, Eclipse, Cucumber, Oracle 11g, SQL, Toad, XML Spy, Doors, WinSCP, Agile, Sybase, Oracle SQL Developer

Client: CGI Federal

Location: Fairfax, VA

Duration: Nov 2011 to Aug 2014

Role: Sr. QA Analyst

Projects: Medicare.gov, MyMedicare.gov, CMS.gov, Pecos

Medicare.gov allows consumers and beneficiaries to compare, select, and enroll in Medicare health and prescription drug plans, compare nursing homes, home health agencies, Supplier Directory, hospitals, physicians, HIOS, Medicare eligibility tool and more.

MyMedicare.gov is Medicare.gov's free and secure online service for accessing people's Medicare information.

CMS.gov administers the Medicare program and works in partnership with state governments to administer Medicaid, the State Children's Health Insurance Program (SCHIP), and health insurance portability standards.

PECOS allows most providers and suppliers to enroll in the Medicare program or make changes to their Medicare enrollment information via the Internet rather than through the paper form.

Responsibilities

• Reviewed and Analyzed business requirement documents, technical requirements and

functional specification of various functionalities, Use Cases.

• Analyzed the requirements and written the user stories along with Acceptance criteria

• Prepared Test Strategy Document, detailed Test Plans which specify testing

overview and testing approach depending on the Business and Technical requirements.

• Transformed application business requirements into test cases and test scripts for manual and automated testing

• Created requirements traceability matrix in software planner, Jira

Involved in Software testing and Web applications testing for Section 508 compliance

utilizing standard 508 testing tools (e.g. JAWS, NVDA, WAT, WAVE)

Updated the PAT document with must issues of Section 508 compliance testing

• Performed regression testing using QTP scripts for the existing functionality

• Conducted Sanity testing, Smoke Testing, System testing, Integration testing, Regression testing, Database Testing/Back-end testing, UI testing, Cross Browser testing, Responsive Design testing (testing on tablets and smart phones)

Used virtual machines for integration testing

Tested web services using SOAP UI

Created 855 forms and Validating extracts on IBM Mainframes

Created test scenarios using Gherkin language for Behavioral Development Process (BDD) to create automated test scripts and to be able to execute in Selenium

• Used Software Planer, Jira for test management and execution and defect tracking

• Performed Database testing by executing SQL queries using SQL Server Management Studio

Prepared and provided test status reports to the management on system status, system changes, problems and potential impacts.

Conducted meetings and walkthroughs with users, developers and Business Analysts to gather information about business process.

Worked with Project Management team for Production related activities

Followed Agile methodology with Scrum Process for the product development.

Environment: Software Planner, Jira, QuickTest Pro 11.0, Ensemble, Gherkin, Selenium, IBM Mainframes, JAWS, WAT, WAVE, SOAP UI, Windows XP, Oracle 11g, SQL, Siebel server, MS Visio, Agile

Client: Fanniemae

Location: Herndon, VA

Duration: April 2010 to August 2011

Role: Sr. QA Analyst

Project: HAMP

In addition to the HAMP program, through which loans can be modified, the IR2 system will also support the HAFA program. HAFA provides financial incentives to Servicers, Investors and Borrowers who utilize Short Sale (HMP5) or Deed-In-Lieu (HMP3) to avoid a foreclosure on an eligible loan under HAMP.

Responsibilities

• Involved in development and implementation of complete test cycle

• Analyzed the requirements and prepared the test scenarios

• Transformed application business requirements into test cases and test scripts for manual testing

• Created requirements traceability matrix using doors

• Performed black box testing includes functional, regression, UI, Integration, Back

end, Targeted testing

• Used Quality Centre for test management and execution

Utilized ClearCase for Revision Control of the application

• Utilized Rational Clear Quest for defect tracking

• Created complex SQL queries to retrieve data from database to validate the input data

• Created XML files based on XML Schema (XSD) for bulk uploading of data

• Supported execution of AutoSys batches in UNIX environment

• Actively involved for daily defects status meetings to provide accurate and updated status of the projects.

Environment: Quality Center 10.0, Rational ClearQuest, Rational ClearCase, Windows XP, Oracle 11g, XML, UNIX, TOAD, SQL, Java Web Server

Client: US Bank

Location: Boston, MA

Duration: January 2009 to Dec 2009

Role: QA Analyst

Project: Mortgage Loan Origination

This is a web based application. MLO deals with all the information about customer, approaching US Bank for Mortgage loan. MLO provides initial quotes to the customers. It has many screens in which the users enter all the personal information of the customers, start date, effective date, end date, and different types of plan ARMs and APR’s related calculators.

Responsibilities

• Reviewed, analyzed requirements and use case documents

• Created Work Flow Diagrams using MS Visio to visually represent information captured in the Use Cases

• Participated in creating test plans and requirements traceability matrices

• Prepared detailed Test Scenarios and Test cases according to the Business requirements

• Performed manual testing, automated testing and maintain documentation on different types of testing viz., Positive, Negative, security, System, Back end, web services testing and Regression testing

• Developed test scripts for QTP for System and Regression Testing

Validated, accepted and rejected transactions reports

• Used Quality Centre for test management, bug tracking and reporting

• Created XML files based on XML Schema (XSD) for bulk uploading of data

• Created and Executed SQL queries using TOAD for database (Oracle) testing

• Utilized ClearCase for Revision Control of the application

• Executed batch jobs in UNIX environment

Extensively tested Online Chat

• Developed test completion reports after each phase of testing

• Attended weekly meetings with fellow QA, Development, BA and Functional Analyst team members

Environment: QuickTest Pro 9.2, Quality Center 9.0, Windows XP, Oracle, DB2, XML, UNIX, TOAD, SOAP UI, SQL, Java Web Server, MS Visio

Client: TD Bank

Location: Toronto, ON

Duration: August 2008 to Dec 2008

Role: QA Analyst

Project: TSYS

The TSYS Collections and Recovery system is a web based application which properly manages both active and charged-off accounts. The recovery system complements the bank’s existing credit card billing system to provide powerful collection and recovery tools.

Responsibilities

• Reviewed and analyzed requirements and use case documents

• Participated in creating test plans and requirements traceability matrices

• Prepared detailed Test Scenarios and Test cases according to the business requirements

• Performed manual testing, automated testing and maintain documentation on different types of testing viz., Positive, Negative, Regression, Integration, GUI, System, Functional, and Back-End.

• Generated test data and verified the results against expected results

• Developed test scripts for QTP for Functional and Regression Testing

• Investigated software bugs and interacted with developers to resolve technical issues

• Created XML files for bulk uploading of data

Validated automatic collections systems reports

Verified and updated the Credit Card transactions in the database via IBM Mainframes

• Executed batch jobs in UNIX environment

• Created and Executed SQL queries using TOAD for database (Oracle) testing

• Used Quality Centre for test management

• Used ClearQuest for defect tracking and reporting bugs

• Utilized ClearCase for Revision Control of the application

• Developed test completion reports after each phase of testing

• Involved in user acceptance testing

• Utilized DOORS to map the requirements with the test cases imported from the Q.C

Environment: QuickTest Pro 9.1, Quality Center 9.0, UNIX, Windows XP, MS Office, Oracle 11.0, J2EE, Java Script, BEA Web Logic, XML, SQL, TOAD, Rational ClearCase, ClearQuest, DOORS, CMMI, IBM Mainframes

Client: Ministry of Transportation

Location: St Catherines, ON

Duration: Jan 2008 to July 2008

Role: QA ANALYST

Project: HICO

HICO Project is a Web based application, developed in C# as front end with the support of Internet Explorer web browser. Windows XP is used as operating system and Oracle 9i is used as a database. The HICO system interacts with the Capital Improvement Delivery System (CID), Electronic Bidding System (EBS) and Contract Preparation System (CPS).

Responsibilities:

• Analyzed Use Cases, Business Requirements, Functional Requirements and Design Documents

• Created Work Flow Diagrams using MS Visio to visually represent information captured in the Use Cases

• Determined various Test Strategies, Test Scenarios

• Created both positive and negative test cases according to the Business Rules and Business Strategies

• Identified and created test data for Test Scenarios and Test Cases

• Performed Functional, End to End and Regression testing

• Assisted performance testing team in creating and executing test cases

• Created and Executed SQL queries using SQL Navigator 4 for Database (Oracle 9i) testing

• Verified actual results against expected results after test execution

• Used Sybase Power Designer for Test Management and ClearQuest for defect tracking

• Utilized SnagIt for capturing the Screenshots

• Verified the “fixes” for the reported bugs

• Provided regular test and status reports to the QA Supervisor

Environment: Power Designer, Rational ClearQuest, C#, .NET Framework 3.5, SQL, Oracle 9i, SQL Server 2005, SQL Navigator 4, MS Visio, SnagIt, RUP, BEA Web Logic

Contact this candidate