Summary

Six years of experience as a QA Analyst/Tester in developing effective quality assurance strategies and testing methodologies for both Manual and Automated Software testing environments for Client/Server and Web-Based applications. Participated actively in all the stages of Software Testing Life Cycle. Proven skills in writing test scripts for Functional and Regression testing using Mercury Interactive and Rational suite tools. Consistent performer with excellent communication and professional skills.

Certification

ISEB / ISTQB Foundation certificate in Software Testing

Education

Masters of Business Administration (Information technology)
Bachelor of Computer Applications

Expertise In QA-Testing

• Extensive knowledge and experience in all stages of the Software Development Life Cycle (SDLC) beginning from initiation and definition to deployment and support.
• Involved in Manual Testing of applications on Windows and UNIX Environment.
• Supported all aspects of QA/QC and change management.
• Participated in testing during the SIT, UAT (QA testing).
• Rich experience in Manual Testing using HP Quality Center
• Experience in using Requirement and Test Approach Management tool – CALIBER RM
• Rich Experience in writing System Test plans, Defining test cases, Developing and Maintaining Test Scripts.
• Developed the test suites for UNIX, Windows
• Documented the functional requirements and worked with development and QA/QC to ensure proper implementation.
• Experience in Test Design, preparing Test Cases, Test Plans, Test Logs and bug reports.
• Experience in Testing Front-end applications, Back-end Databases and XML File Validations
• Experienced in Creating, Modifying, and Analyzing XML check points.
• Wrote XML Scripting methods for enhancing test scripts.
• Involved in Manual Testing of applications on Windows Environment and Powerbuilder Applications
• Core experience in developing full life cycle including requirement gathering, analysis, design, development, testing, implementation and maintenance of Data Warehousing and On-Line Analytical Processing(OLAP) Applications using ETL Tools.
• Worked on Windows 2000, SQL Server, Oracle, LDAP and IBM AIX.
• Familiar with Analytical Design Documents.
• Strong Knowledge of Data Warehousing and Data modeling Concepts.
• Analyzed Business/ System Requirement documents.
• Create QA Basic scripts in Rational Robot and TSL scripts in WinRunner to perform regression testing.
• Strong skills in backend testing SQL Queries on Oracle RDBMS.
• Familiar with Business Objects Tools Using a standard configuration, IBM and Business Objects set to demonstrate the accelerated query performance and reduced administration.
• Expertise in writing SQL queries to perform data driven tests.
• Involved in Database Testing using SQL Queries.
• Used Load Runner for stress test and performance/load tests.
• Participated in Business Process Management (BPM) used to improve the efficiency of key business and IT processes through automation, based on the priorities established by the business;
• Well versed in conducting different kinds of tests such as functionality, limit, positive, negative, smoke, integration, user acceptance, storage, performance, load, security, installation etc.

Technical Skills Testing Tools & Quality Center 9.0/8.2,WinRunner 7.5 Management: Test Director 8.0/7.0, SOAP UI, Rational SQA Robot, Rational Requisite Pro

Test Scripting: SQA Basic, TSL
Programming: C, C++, VC++, JAVA, Visual Basic5.0/6.0, SQL, PL/SQL
Web Technologies: HTML, XML, Java Script , VBScript, JSP
Web Servers: Tomcat 3.3, Apache 1.3, IIS 5.0, AS/400
RDBMS: MS SQL Server 7.x/2000, Oracle9i/8i, Sybase
Operating System: MS Windows NT 4.0/XP/2000/ME/95/98, UNIX, AIX, MS-DOS
Documentation: MS Project, MS Office, Visio 2000
Version Control Tools: PVCS, CVS, Visual Source safe

PROFESSIONAL EXPERIENCE

Confidential,NJ Jul’10 – Till Date

Project: Uniform Mortgage Data Program

Role: QA Analyst/Consultant

PHH Mortgage provides outsourced, private-label mortgage solutions to clients nationwide who are leaders in their fields of business, including financial institutions, real estate companies, credit unions, corporations and government agencies. Worked on following 3 critical projects
UNIFORM LOAN DELIVERY DATASET (ULDD) Under Federal Housing Finance Agency (FHFA) Direction, Fannie Mae and Freddie Mac worked together to develop Uniform Loan Delivery Data standards that create operational efficiencies, strengthen Risk Management capabilities and improve transparency in Lenders process. ULDD uses the industry recognized MISMO 3.0 standard, has been developed by Fannie Mae and Freddie Mac with a common GSE Approach to single Family Loan Delivery Data Requirements for all Mortgages that will be delivered to either GSE. This Project is developed in 3 Phases where first phase Readiness encompasses conversion of Fannie Mae files from 2K file to MISMO XML format. Phase 2 encompasses adding loan delivery data to “At Closing”, “At Modifications” buckets. Phase 3 Mandate adds new data items generated for delivery of MISMO XML file to FNMA, FHLMC.
EARLY CHECK as part of UMDP is created in response to Lender requests for assistance with identifying and correcting potential eligibility and/or data issues as early in the loan Processing as possible. The goal is to help Lenders identify potential problems by accessing this service in their process prior to Loan Delivery. This service is available across all underwriting methods – for DU Loans, Underwritten Loans, Non-DU AUS Loans.
UBS DATA/ASSET PULL is part of Client –Funded project in which an interface system is developed for UBS and PHH for the purpose of pulling borrower information, Client Profiling information and UBS Asset account data into Loan application.

Responsibilities:

• Developed Test Approach for Functional requirements in BORLAND CALIBER RM for ULDD and EarlyCheck Projects
• Created many Loan Scenarios from Origination to Closing in RETAILQA and PRODQA environments that are necessary to test new fields and functionality for all the Projects
• Involved in Test Strategy and Test Plan meetings to forecast timelines for Test script execution
• Export Test Approach to Quality Center in form of Scripts and executed the Test scripts in HP Quality Center
• Performed Manual Testing on CA$H, LOANSPAN front end changes and Data validations on MISMO file used in Loan Data Delivery
• As part ULDD Phase 1 – Tested Loan Delivery Dataset fields during conversion of 2K file to MISMO 3.0 XML format
• Worked with SSS team to create pool files and run the UI Export tool to generate MISMO file for the Loans in the pool to validate Data fields
• In ULDD Phase 2, tested the data delivered on export files via POWERSELLER database and validate the new data fields added to the new export files created in XML format for both GSE’s Fannie Mae and Freddie Mac
• During ULDD Phase 3, tested new fields and Logic involved in Origination Applications such as LOANSPAN, SOAR, Processing Systems such as Cendant Achieving Servicing Heights (CA$H) and other downstream systems such as SMARTS
• In EARLYCHECK project, tested a new service that enables access to Fannie Mae delivery data at any point in Lender’s business process and the user friendly report generated with messages highlighting issues that need to be resolved.
• Validated hard stops or Loan Delivery severities such as Fatal, Warning, Warning to Fatal edits and compared to that of the previously used DU compare report to facilitate smooth Loan Delivery process with minimal Post Closing issues
• Early Check has a client-server architecture, server being network-based distributed platform running SUN/Solaris with Oracle database and Web Sphere application servers running Java application (J2EE). Client included Java Servlets communicating with the server to perform various functions such as authentication, security and performance management from a web based UI.
• Executed Test scripts in RETAILQA and ProductionQA environments for UBS – ASSET PULL project where the following Deliverables were validated – Data Request from PHH, Data Lookup and data return from UBS, Client Profiling information and Data Pre-fill in PHH systems, New & updated reports, Product and Pricing changes, AUS impacts and New and Pipeline loan impacts
• Led the Defect Meetings by co-ordinating SQA and TPAT Teams to track and update the defects on a daily basis
• Maintained defects using HP Quality Center and involved in complete life cycle of Defect Management
• Performed Back-end Testing on CA$H, EARLYCHECK and POWERSELLER Databases using Complex SQL QUERIES on SYBASE InfoMaker
• Performed Regression Testing in PRODQA environment
• Performed Smoke Testing, System Testing, Integration Testing and User Interface Testing
• Participated in all Project Team meetings and interacted with BA team and Development team to discuss the requirements and Dev Approach for testing

Environment: MS Sql Server, JAVA, Power Builder, HP Quality Center, Sybase, Oracle, InfoMaker 10.5, Windows 2000/XP, MS Office, MISMO 3.0, Borland Caliber

Confidential,NC Feb’09 - Mar’10

Project: Quality Measures Reporter

Role: QA Analyst/Consultant

Confidential,Quality measures Reporter product provides a single solution for meeting regulatory requirements of the Joint commission and CMS. As one of Premier’s Clinical Advisor modules, QMR can submit quality measures data to most national, state and payer driven initiatives. Because the QMR tool was built with clinicians in mind, users may collect, report and abstract data in much less time.

Responsibilities:

• Created test data to do the validations in QA and production environments.
• Worked on Agile Methodology.
• Wrote Test cases in Mercury Quality Center and created test plans.
• Performed Unit testing, Smoke testing and Integration Testing.
• Mapped the Requirements to the Test cases.
• Worked on the application Web Data Collector.
• Performed Backend Testing by executing the SQL queries.
• Worked on the Transform application.
• Created Test data to test the Transform Application.
• Verified the data by running commands in UNIX.
• Performed testing on the Micro strategy reports.
• Validated the data on reports by running the queries in SQL.
• Used the tool, Beyond Compare to do the data compare and data manipulation.
• Involved in the complete cycle of defect management.
• Maintained the Defects using Defect Tracking System in Test Director.
• Performed testing in the UAT and Production environments.
• Conducted defect meetings with development and management teams to discuss bugs and other issues.
• Participated in all project team meetings and interacted with the BA’s and Development team.

Environment: Test Director, Java, .Net, Oracle, SQL 2000, Unix, Power Builder, Abinitio, Micro Strategy, Mercury Quality Center.

Confidential,KS May ’05 – Sep ‘07
QA Analyst/Tester
Project: Bill Order Management

The System involved building a Data Warehouse system to improve overall quality and productivity of existing processes and deploying reliable and accurate information. Extracting data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements using Ab Initio component container and loading into Oracle target database, by running the graphs. Worked as QA analyst in testing, billing and order management systems and also in validation of the converted data from conversion legacy billing system into Amdocs.

Responsibilities:

• Close interaction with designers and software developers to understand application functionality and navigational flow.
• Performed the Product testing for checking the functionality of the application.
• Provided intense unit testing followed by Quality Center (QC) test cycle and moving to production.
• Directed QC testing throughout the lifecycle of the product.
• Participated in QC/Black Box testing group. Wrote test plans, edited manuals, performed database management, implemented Debug scripts, performed hardware and software maintenance for project leads.
• Worked extensively on XML.
• Worked with the components of Data Warehousing like components model, ETL tools.
• Preparation of Test Reports and Test Logs.
• Validation of UNIX Shell Scripts to automate the bulk load & update Processes.
• Translated internal and customer requests into detailed functional requirements documentation, screen mockups, and use cases for development and QA/QC testing.
• Development of Actuate Reports/ SQL Server Stored Procedures.
• Analyzed business requirements and functional design documents to prepare master test plans to define objective, scope and strategy of the project.
• Created the strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required conducting the effort.
• Used Test Director Document Generator to create a report in Microsoft Word document containing a project’s requirements, planning, test list, test execution, and defect tracking data.
• Prepared test data for positive and negative test scenarios for Functional testing as documented in the test plan.
• Executed On-Line Analytical Processing (OLAP) of different applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data.
• Executed test cases manually to check GUI and Functional features of the AUT, compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution using Test Director.
• Automated test scripts for Functionality and Regression testing using WinRunner
• Involved in the user interface testing and integration testing using Test Director
• Performed browser compatibility testing on different platforms and JAVA based applications
• Used Business Objects Tools with a standard configuration to demonstrate the accelerated query performance
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on the database.
• Coordinated with users for User Acceptance test in production environment.
• Analyzed Defect Reports using Test Director and worked closely with Application Developers to fix defects .
• Environment: [TOOLS - WinRunner, Test Director, Load Runner], Windows 95/98/NT/ 2000/XP, Web sphere, Java, XML, NetMonitor, Visio, MS Office, DB2, MS SQL Server, SOAP UI, MS Access, Sonic, Unix Shell Scripts.

Confidential, May ’03– May ’04
Programmer/QA Analyst

Responsible for developing and testing the application of Inventory system for stores, in a leading Manufacturing Unit . Involved in analysis, development and testing of the software which includes the following modules. Stock Maintenance and Reports generation.

Responsibilities:

• Analyzed system specification and developed test plans, test cases and Test Scripts for Client/Server and Web.
• Responsible in integrating and modeling the development environments using Rational rose.
• Automated testing with SQA Suite (SQA Robot, SQA Manager).
• Involved In Unit Testing of Java Applications.
• Creating, maintaining, and modifying Test scripts in Client/Server and Web Based environment on both NT and UNIX platforms.
• Performed Regression, Functional, System, Integration and Performance testing.
• Interacted with Developers and Business Analyst regarding Test requirements and Defects.

Environment: SQA Robot, VC++, HTML, Java 1.1 SQL Server, Visual Basic 4.0, SQL, Rational Rose, Shell Scripts, I.E 3.0, Netscape Navigator, Win NT and UNIX.