Test Cases Project

Soumya G

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

Summary:

Nearly * years of professional experience as a Software QA Engineer/Analyst in reviewing product requirements, analysing designs, creating test plans and test cases, maintaining documents, demonstrated ability to communicate and work with co-workers at all levels

Good knowledge and understanding of the SDLC and STLC.

Strong skills in manual testing and Automation testing of web-based applications.

Ability to work on Agile, SDLC, Scrum and challenging environments with focus on product delivery

Actively involved in various phases of testing life cycle such as web services, functional, regression, integration, system, automation and User acceptance testing.

Expertise in automating the software testing environment with open-source tools like Selenium IDE/RC/Grid, WebDriver, and Firebug.

Experience in Selenium test scripts using data driven and keyword driven framework.

Experience in parallel testing using Selenium WebDriver and TestNG.

Have clear understanding and experience with Validation of BI reports and Business Intelligence concepts

Extensively used Test Management tools like ALM Quality Center, Rational Clear Quest, and Rational Requisite Pro, Quick Test professional.

Performed the Back-End testing to ensure data consistency on front-end by writing and executing the SQL queries on Oracle database.

Worked in various domains including Sales, finance, Banking and Retail industries.

Performed GAP analysis of business rules, business and system process flows, ensuring accuracy and deadlines were met.

Experience in mapping analysis, test case preparation, test execution, defect reporting, and regression testing and final documentation. Excellent communication and interpersonal skills with problem solving abilities.

Handled offshore team to drive project execution and coordinated with onsite clients on requirement gathering and was responsible for overall project delivery for QA.

Technical Skills

Testing Tools Selenium RC, Win runner

Languages XML, JAVA, Visual Basic 6.0, VB Script

Web Technologies HTML, DHTML, XSTL, WSDL, SOAP, XML

Databases SQL Server2000, Oracle 10g, MySQL, MS SQL

Operating Systems Windows, UNIX/LINUX, Mainframes, MAC

Browsers Safari, Firefox, Chrome, Internet Explorer

Reporting Tools Bugzilla, Quality Center, MS Excel, Rational SODA, Clear Quest, JIRA

Test Management Tools Quality Center (ALM), TRAC, SharePoint, Bugzilla, Citrix, PVCS Tracker, Confluence

Other Software’s VMware, Data stage, SoapUI, TOAD, OmniGraffle, Wiki, Informatica

Education & Certifications:

Bachelors in Technology, Jawaharlal Nehru Technological University, India - 2003

HP certified professional in QUICKTEST PROFESSIONAL 9.2 SOFTWARE

HP certified professional in QUALITY CENTER 9.2 SOFTWARE (ID: SR6317658)

Performant Financial Corporation, Livermore, CA May 16 – Nov 18

QA Engineer III

Performant works with various government corporations. Performant is IRS partner in providing Private Debt collection program services. Performant recovery services improve, simplify, and automate the process of recovering debt.

Project1: iTanium Migration project is about developing new server and migrating programs from old server (PA-RISK) to iTanium. QA team is responsible to run programs at both server sides and compare.

Responsibilities:

Write test cases on MS Excel and get reviewed by the QA team.

Approved test cases will be uploaded directly from MS Excel Add-in using HP Quality center.

Setup environment/access for servers and Run the shell script in UNIX.

Monitor issues, logs, exceptions, reports, processing time and execution process throughout job runs.

Execute SQL queries on multiple tables in Informix database using joins.

Validate the data processed after running jobs and capture results.

Log issues for any unexpected results in JIRA and track them.

dfStatus update under iTanium project page on weekly basis in Confluence.

Attending QA meetings on weekly basis to discuss issues and status of the project.

Coordinate and communicate with QA team, developers and QA Lead about issues and execution time.

Environment: Putty, Informix database, UNIX, WinSCP, WinSQL, Confluence, JIRA, ALM, MS Excel

Project2: Artiva implementation project is about validating programs which can convert data files into new accounts/ updated accounts. Performant is now including Artiva application for all clients. Artiva application is developed by Ontario Corp and Artiva has front-end, where multiple programs can be executed and updated account information can be viewed.

Responsibilities:

Understand each requirement and note down User stories during System users meeting.

Develop and communicate process changes, enhancements, and modifications, verbally and through written documentation, to management, peers, staff, and other employees so that issues and solutions are understood.

Request for test bed on virtual machine i.e., Artiva application, Artiva database.

Prepare test data for multiple programs like monthly debt payment, address update, new account creation etc

Document all test cases, review them with the team, get approved through developer.

Track the relationship of the project requirements to the design, documentation, development, testing and release of the project/product in Excel sheet (Requirement traceability matrix /RTM)

Process the data file on Artiva application and data file goes through approval process.

Run the Queries on the Cache database using multiple joins to validate accounts data.

Developed Functional tests in Java using Selenium WebDriver and TestNG framework.

Implemented keyword Driven and Data driven tests using TestNG annotations.

Prepared automated test cases and saved test scripts for future reference.

Upload test cases, supporting documents, SQL Queries to Quality Center

Validate different letters templates triggered when account is created/updated/modified.

Update daily status and get clarifications from QA Lead/developer/BA on regular basis.

Attend stand up meeting to track project status, new code drop, release dates, issues blocking the testing

Connect to Bi-weekly call for defect approval/status tracking meeting with QA team, BA, Clients and Ontario team.

Environment: Artiva Application, Cache Database, Selenium IDE, Selenium Webdriver, Quality Center, SharePoint, Java SDK, Eclipse, Chrome, TestNG, Agile development

Federal Reserve Bank of San Francisco, CA Nov 15 – Apr 16

Sr. QA Analyst

Data Analyst

Fed Cash Central (FCC) project is a data migration project replacing Legacy systems. As part of implementing new system and mapping to new data models, Data analyst role is responsible to generate BI Reports and perform data analysis to compare new system to legacy system

Responsibilities:

Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.

Reviewed technical design documents prepared by developers for Data model, Data formats and report prototypes

Created Ad-hoc SQL queries to compare data between new system and legacy stem and created gap analysis reports

Attended defect triage meeting and scrum meeting daily with Managers, Developers and BA.

Worked with Business analyst and developers for query resolutions every day on Q&A sessions.

Upload the results for each test case on ALM and completed the execution as per deadlines.

Environment: SQL Developer4.0, ALM 12.0, SharePoint, Microsoft Excel 2007, SAP Business Objects launch pad, SQL Server Management Studio2008, Window.

Wells Fargo, Fremont, CA Aug 13 - Dec 13

QA Analyst

COPS II is extension of Wells Fargo’s Compliance Operational Processing System (COPS), is an existing application which streamlines account opening, customer due diligence, operational risk processes, management oversight, and regulatory reporting of compliance and risk management program. Purpose of the project is to provide an interim solution to the Wells Fargo Wholesale bank customer due diligence effort and enhance the current user-base of COPS from 2,500 users to approximately 4,000 users.

Responsibilities:

Analyzed COPS II Requirement documents and COPS test plan document.

Interacted with business analyst and developers in requirements analysis, testing and documentation for application developed

Developed Methodology, Test Plans, Test Matrixes, Test Cases and Test scripts for functional testing

Executed sanity, functional, Cross browser and regression test cases to verify business requirements.

Used Quality Center as a central repository for test assets during all levels of IT testing cycle.

Coordinated efforts with QA team and developers during the project.

Executing SQL queries on SQL server for verifying data.

Attending Daily status meeting and updating the testing status with QA Lead

Logged defects into QC and tracked throughout the project.

Participated weekly Defect review meeting with project team members.

Environment: VMWare, IIS Web Server, SQL Server 2008, Quality Center, UNIX, Windows

Infosys, Fremont, CA May 10 – Jul 13

Test Analyst

Consulted various clients through Infosys as Test Analyst/Lead covering different domains i.e. Retail, Financial, and Banking. Primary responsibilities were Designing Test Strategies, writing Test Plans, Test Scenario Documents, Back end Testing (writing SQL and Data Analysis), GUI Test Automation (QTP), offshore co-ordination, Publishing Test results reports, managing defect Tracking and Version controlling systems.

Projects Included:

PG&E (Infosys), San Francisco, CA Sep 12 – Dec 12

PG&E HCP project is intended for HCP users to use the existing functionality built into HCP portal in terms of capturing the survey results in SAP and reporting. Project is separated into three parts in terms of software development Non-SAP, Bio Assessment to GIS and MARS.

Responsibilities:

Prepared Test model, test scripts and test reports for Integration testing based on system requirement specification document

Full life cycle experience including requirement analysis, test strategy, test cases design, testing, release new version of product and End-to-end testing.

Responsible in Preparation and Execution of Integration Test cases for all three parts of HCP project using High Level Design documents

Scope of testing included functionality, performance, GUI, usability, regression, builds acceptance, and Browser Compatibility

Analyzed Business and Technical requirements and worked closely with Business Analysts and developers for clarification of ambiguities

Performed functional and regression testing of the application

Prepared Test Model and test scripts for UAT testing

Assisted business users with UAT effort; application demo, walk through, data collection

Served as a coordinator for all testing activities on a project.

Worked on HP Quality Center set up and uploaded test scripts for execution using MS Excel Add-in

Logged defects and tracked them on Quality center

Organized bug review meeting with developers to discuss open issues, assign/ re-assign the tasks and bug resolution.

Prepared Test data bed for test case execution and wrote lot of SQL queries to validate data and report bugs on the issues

Apple Inc (Infosys), Cupertino, CA Jun 12 – Aug 12

Apple Joint Venture Project is a Retail business annual membership program aimed at small to medium sized businesses growing beyond 5 or more employees.

Responsibilities:

Worked with client to establish and maintain a consistent test methodology and to resolve questions during the testing process. Served as a coordinator for all testing activities on a project.

Prepared Test deliverables - Test cases, execution Plan and Test reports.

Created High Level Test Scenarios based on the Business Requirements/Use Cases and presented to the project team for approval

Created detailed test cases based on the Business and Technical Requirements, reviewed with the Business Analyst for approval

Involved end to end testing of complete web-based site.

Executed and performed SIT, Sanity and Browser compatibility testing.

Logged issues and linked to test cases in RADAR tool.

Prepared Test Data and performed data analysis using SQL

Onsite co-ordinator and managed team of 4 at offshore to drive project execution

Prepared Requirement traceability documents to ensure 100% coverage of requirements

Uploaded documents to confluence (Wiki) and managed document versioning.

Apple Brickhouse (BK-ART) project. Jul 11 – Nov 11

The Brick house project implementing would give customers more flexibility to utilize both Apple Online and Retail to purchase products for pick-up at a local retail store, ship to selected destinations, and make additional product purchases, and process returns and exchanges.

Responsibilities:

Coordinated with developers for SRS walkthrough and query resolutions.

Prepared Test Deliverables/Test Cases- BK & ARE Regression Cases, Query Tool, Revalidation, BK Vendorfeed and BK IT Test cases.

Developed Test Plans and presented to the project team for approval

Managed all test deliverables in RADAR and Confluence.

Performed Mobile and Regression testing on Brickhouse code.

Performed Integration and functional testing on Query tool.

Prepared Test Reports daily to track the Test completion in Excel sheet.

Logged issues and linked to test cases in RADAR tool.

Prepared project layout design using OmniGraffle drawing tool.

Organized documents on Wiki online tool.

Apple Back-To-School (BTS-ART) project. Apr 11 – Jul 11

BTS project is based on promo eligibility period and an eligible customer gets Gift code. Customer has to Retrieve Gift code and can download free apps.

Responsibilities:

Preparing Test cases for BTS Integration and ART Expansion Phase I regression.

Prepared the Test Data by coordinating with AOS and POS team for BTS testing.

Uploaded Test cases to RADAR, relating issues to test cases and tracking them.

Performed System testing on BTS code.

Conducted Compatibility testing on MAC and windows.

Developed test cases and executed Mobile and Bluetooth test cases.

Prepared Test estimation for every Test Cycle using MS Excel.

Performed performance testing using Stubs.

Apple ART Expansion Phase I project Feb 11 – Apr 11

Apple Inc is the world leader in innovation and branding. Apple follows supply chain management. Apple Rebate Tool (ART) is a web application used by customers to claim rebates after the purchase of Apple's products. In EMEA, the current process with respect to rebates is for customers to complete a rebate application using an online rebate application tool.

Responsibilities:

Involved in SIT, Database, Compatibility, Mobile and Performance testing.

Analyzed the different services integrated with ART application like XCard, MRT, etc

Coordinated work with offshore team on weekly bases.

Prepared the Test Data and Test Plan for testing every new build.

Reviewed all deliverables preparation like Performance Test cases and Test reporting.

Performed performance testing ART application using FireBug tool

Follow up with issues and clarified them during offshore status calls.

Logged issues and tracked the issue status in RADAR tool.

Executed test cases manually and reported test progress to the management

Performed Smoke Testing, Functional Testing, and Regression Testing, and End-to-End Testing

Environment: JAVA, RADAR, SQL Developer, Oracle, Windows (IE), MAC (Safari, Firefox, Chrome), Confluence, IPad, Firebug, bluetooth

Wells Fargo, San Francisco, CA Sep 10 – Jan 11

Wells Fargo & Company is a diversified financial services company providing banking, insurance, investments, mortgage across North America and internationally. Wells Fargo is implementing the project “Retent Express”, to develop a front end for the sales agent to serve the Home Equity customers. This application is focused to expand the business with the customers and to retain them by providing Treatments to their accounts.

Responsibilities:

Coordinated with Infosys BA and dev teams for SRS walkthrough and query resolutions.

Analysed the different services integrated with Retent Express application like YODA, LSA, LAWS, SHAW etc

Provided Knowledge Transfer to Offshore Team regarding Retent Express changes and updates.

Performed Test planning and guided offshore team.

Assigned work to offshore team on daily bases and providing them all required deliverables.

Prepared the Test Data and Test Plan for testing every new build (R4.10, R1.11, and R2.11).

Reviewed all deliverables prepared by offshore team like test cases, test scenarios.

Managed all test deliverables in Quality Center and linked to requirements for traceability.

Prepared Test estimation for every Test Cycle using MS Excel.

Verified stability of every new build received by performing smoke testing.

Performed Functional testing, involves the UI validation of Retent Express application.

Validation of XML with Retent Express front end.

Performed performance testing for Quarterly release with Retent Express using Stubs.

Regression testing at the end of completes R4.10; R1.11 application will be done manually to ensure that the previous functionality is working fine.

Coordinate with WF Project manager, Requirement Manager and other testing teams for Test data and requirement queries.

Worked closely with other supporting teams like LSA, YODA, SFDC teams.

Follow up with offshore issues, defects and clarified them during offshore daily status calls.

Logged defects and tracked the defect status in Clear Quest tool.

Environment: JAVA, Salesforce.com, Quality Center, Oracle, clear quest, Windows NT/ 2000, Share point (Project Management), Citrix

GAP INC (Infosys), San Bruno, CA May 10 – Sep 10

GAP Inc. has global supply chain. Starts supply chain from material to till product goes to sales. GAP planned to implement RFID Technology in 105 BR stores replenished by Fresno Distribution Center. RFID Project includes development of RFID Scanner, which reads only RFID tags. RFID Data through Stores goes to RMS via RFID database.

Responsibilities:

Coordinated with GAP subject matter experts for project level discussions and query resolutions.

Analyzed the data flow from Product Download, Stores-VUE, Stores-PFI, VUE – PFI

Prepared the Test Data, Test Plan, Test Scenarios and Test Cases.

Offered walk through of business requirements to QA team for clarification

Organized test cases in Quality Center and linked to requirements for traceability.

Prepared Test estimation for every Test Cycle using MS Excel.

Providing Knowledge Transfer to Offshore Team about RFID components and data flow.

Responsible for Integration testing between all the 6 components of RFID i.e. Stores, RA, PFI/RMS, Prompt, VUE, RFID (ICOD)

Assigned work to offshore team on daily bases. Served as a coordinator for all testing activities

Requirement changes required re-estimation of the affected interface.

Worked with Datastage, Mainframes and Putty (Jobs, Scheduler and Events) by triggering the jobs.

Coordinated with multiple teams working on applications on daily status meeting.

Performed dry run of all Smoke Test Cases.

Worked closely with other supporting teams like Stores, POSAS, Revenue Accounting, PFI etc

Collaborate with gap lead to identify and manage testing risks proactively

Conducted Data Validation using Oracle SQL queries after running the jobs.

Logged and tracked the defect using Quality Center.

Environment: JAVA, Mainframes, Putty, Quality Center, DB2, Oracle, UNIX, Windows NT/ 2000, TOAD, Datastage, Share point (Project Management), Citrix

Auditude, Palo Alto, CA Feb 10 – May 10

QA Consultant

Auditude is a privately held, Online Media Industry. Auditude team comes from some of the top Internet, technology, and advertising companies in the industry, including Google, Yahoo! Ideallab, IDEO, Paypal, eBay, and DoubleClick. Auditude automate the process of taking you from content publishing to advanced video ad management and monetization. It has two products “Connect ad platform” and “Content ID Indexing system”.

Responsibilities:

Raised request for all the applications for testing purpose.

Arranged knowledge sessions with Test Lead with Test Team.

Analyzed the transaction workflows to develop test cases when new features get released.

Manually tested the ad platform application on every new release.

Test ad banners in various formats (JPEG, GIF, BMP, SWF, and PNG) and check in different versions of flash player.

Provided the feedback to Test Lead for daily assigned work.

Uploaded the test cases in TRAC (Project Management system).

Performed functional test execution on the online video applications.

Performed backend testing to ensure the correctness of the workflow

Conducted Data Validation using SQL queries.

Filed bugs in a defect tracking tool and verify fixed bugs in every new release.

Submitted Test results to Test Lead and uploads to TRAC.

Worked closely with Test Lead and developers in discussing the Issues/Defects.

Environment: Windows NT/ 2000, MySQL, TRAC (Project Management)

Contact this candidate