Manager Project

Mrudula Vara Prasad

Email ID: *******.**********@*****.*** Phone No: 646-***-****

PROFESSIONAL SUMMARY:

• 7+ years of experience in Business Analysis and Quality Assurance having key strengths like self-motivation, detail orientation, and team playing

• Expertise in Manual testing in all the phases, including test planning, test case development, test case execution, defect tracking, and evaluation of test results using tools like Win Runner along with bug Reporting tools like Test Director/Quality Center.

• Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases and Test Scripts, Test Procedure based on the User Requirement Document, System Requirement documents, and functional Requirement documents.

• Well versed in Software Testing Life Cycle (STLC) - phases include: Test planning, Test design, Test data identification and mock up, Risk and Impact analysis, Mitigation Planning, performing test, Defect Management and Root Cause Analysis (RCA).

• Familiar with both the Agile and Waterfall methodologies using Agile Project management tool called Versionone.

• Participated in planning, estimating, scheduling, retrospectives and any other team activities.

• Involved in testing Web services and XML with tool called ‘SOAP UI’

• Involved in UNIX file validation.

• Extensively worked in Testing ETL for supporting Data Validation using Informatica Power Center.

• Performed backend testing in Oracle /SQL Server My SQL database and analyzed the log files for different error codes

• Wrote many SQL/PLSQL scripts to verify data in the DB and verify consistency with application UI

• Strong experience with MS Word, MS Excel for writing Test Plans, Test Cases, weekly status reports

• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member

• Consistently recognized by both client and employers as a fast learner with excellent problem solving and technical troubleshooting abilities

SKILLS/TOOLS:

Languages C, C++, VB, Java, .NET, ASP and SQL, JCL.

Web Technologies ASP, HTML, DHTML, XML, WSAM

Case Tools UML.

Testing Tools Win Runner, Load Runner, Rational Team Test, Test Director/Quality Centre, Test Complete, Quick Test Pro.

Data Warehousing Tools Informatica 8.x/7.x, Cognos, Business Objects.

RDBMS Oracle 8.0/7.x, DB2, SQL Server 2008/2005, MS-Access, AQT

Hardware IBM Compatible PCs, Terminal Emulators, Pentium PCs, Intel based machines

Reporting Tools Test Director, Rational Clear Quest, Microstrategy

Operating System MS-DOS, Windows NT / 95 / 98 / 2000 / 2003 / XP,RedHat Linux, Solaris 2.x,

ERP PeopleSoft 8.9/8.4

Packages MS Word, MS Excel and MS PowerPoint

GUI Visual Basic, Developer/2000

Scripting Languages VBScript, JavaScript and TSL

PROFESSIONAL EXPERIENCE:

Client: Standard and Poor’s, NY March 2010 – Till Date

Role : Sr.QA Analyst

Arrow Global

Description:

Arrow Global is an application Developed by using the .Net, Java, J2EE technologies. The main functionality of Arrow Global is to Provide a centralized, global system to capture, store, analyze, forecast, and report on financial, operating, econometric, market, and other data Including (and/or integrate with) various tools and models used to forecast cash flow and earnings, predict probability of default, identify anomalous data, etc.

Responsibilities:

• Attended the Business and Functional Requirement Document (BRD) review meetings conducted by BA team to better understand the application functionality and to gather Functional requirement Document (FRD) to create the Test Plan and Test Scenarios.

• Participated in implementing detailed test-plans and test-cases according to the Acceptance Criteria provided by Business Analyst (BA)

• Involved in the Test Case walkthroughs to BA and assessment meetings.

• Involved in Release support – Release to QA, Involved in environment set up

• Proficient in working with testing tools and carrying out Functionality testing, GUI Testing, System Testing, Integration Testing and Regression Testing, Negative Testing, End to End Testing, Adhoc testing and UAT testing.

• Worked with Agile Project management tool called Versionone and provided daily updates to the Scrum Master.

• Showcase the User story to Concerned Product Owner for the Story Acceptance.

• Actively participated in showcasing all accepted stories to Business along with the Project Team (Product Owners, Business Analysts, DSO’s, Development team, Delivery Manager) each and every two sprints.

• Attending Daily SOS (Scrum on Scrum) and providing the Story status to the Business.

• Performed UAT cycles and prepared test scripts for User Acceptance Testing (UAT).

• Performed Smoke Testing on every new build of the application.

• Followed the Agile Methodology

• Recorded and Played back QTP scripts for manual test cases against front end screens by inserting different types of Checkpoints

• Attended SPE Training and QA Town hall meetings to get explored with Management updates, discussed improving test methodologies.

• Worked with Query Analyzer and Toad to write the SQL queries.

• Interacted with business analysts, Source data architects and Source application developer to test the data model and to prepare the Test Bed.

• Validated the source files like XML, CSV files in Informatica.

• Analyzed Informatica mappings and understood the business rules and logic of the mappings and tested the whole ETL Informatica process by connecting to the different database servers.

• Extensively worked on Informatica components like Admin console, Repository manager, Designer, Workflow manager, Workflow monitor.

• Studied the Transformations used in each mapping with by comparing with the mappings rules excel sheets.

• Ran the Informatica workflows and analyzed error log files

• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.

• Compared the data with source and target tables and validated data based on requirements.

• Experience in testing FIX Protocol environment.

• Involved in defect reporting and assigning the defects to development team through Quality Center.

• Installed and Loaded database with Test Data and validated the latest Build with new DB features checked in. Loaded Input Data file into database using SQL loader and validated the Data loaded in to tables by executing queries for checking integrity of databases (Oracle) update, deletions and insertions using TOAD.

• Understood the Entity relationship diagrams to build the SQL Queries for Database testing.

• Wrote many SQL queries to verify data in the DB and verify consistency with application UI and Performed database testing using SQL, executed various DDL and DML statements.

• Tested Java Post Load scripts(JPLS) through Web Services

• Involved in testing Web services and XML with tool called ‘SOAP UI’. I have been using this tool to locate WSDL file on internet, create Test cases, run them, do load testing.

• Attending Daily SOS (Scrum on Scrum) and providing the Story status to the Business.

• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.

• Involved in UNIX file validation.

• Communicated timely project status to appropriate levels of management.

Environment : Quality Center 8.2/9.2,.NET, Oracle, PL/SQL, C# Java, J2EE, XML, HTML, SOAP UI,Informatica Power center 8.6.1,Versionone.

Client: Comcast, NJ Mar 09’ to Feb 10’

Role : Sr.QA Analyst

Description: Comcast is one of the largest full service network domains in United States offering an unparalleled range of products and services. Worked as Sr. QA Analyst on different front end billing applications and extensively worked in Biller environments. The main functionality of the project is to test the end to end process of the wireless air card along with all other services provided by Comcast.

Responsibilities:

• Collected software requirements and specifications. Involved in reviewing Use Cases and Requirements.

• Written test plan and Created test cases as per business requirements

• Performed System and User Acceptance Testing.

• Regression testing was done for all the new builds released.

• Validated various database tables.

• Worked on web services using SOAP UI Tool.

• Tested all aspects of products and thoroughly reported issues in bug tracking systems using Web Tracker.

• Executed SQL Queries using the simple and complicated join.

• Worked very closely with client side managers and developers.

• Promptly updated the bug tracking system with results of testing.

• Initially performed manual testing end to end on both CSG and DDP billing systems.

• Used QC as bug tracking tool.

• Performed unit testing on Unix shell scripting modules

• Participated in regular project status meetings related to testing.

• Followed agile methodology and attended Scrum meetings

• Maintained documentation of test results to assist in debugging and modification of software.

• Analyzes test results to ensure existing functionality and recommends corrective action.

• As a Sr Team member attended user meetings communicated with the teams.

• Performed regression testing using QTP

• Interacted onsite and offshore team.

Environment: Quality Center 8.2/9.2, .NET, Oracle, PL/SQL, C, TOAD, SOAP UI , UNIX, VB, Java , J2EE, XML, HTML, VBScript, WebLogic, Server 8.1,UDB DB2

Client : United Parcel Services, NJ May 08’ to Feb 09’

Role : Sr. QA Analyst

Description:

Worked as a QA Lead, involved in testing of the applications that create shipment, shipping history, schedule a pickup, and calculate time and cost, zone maintenance and rate cards. This application enables the user to create shipment, schedule and track the packages. Responsibilities:

• Analyzing and reviewing the user/business requirements and functional specs documents

• Involved in System Testing for Manual Testing

• Developed end to end manual test cases for playback module

• Configured QA Environment for manual testing.

• Created Project, Requirements, Test Plans and Tests in Test Director

• Exported test cases from Excel and requirements from MS Word to Quality Center.

• Wrote test cases to test the application manually in Test Director for automating using Quick Test Pro

• Worked extensively on Agile Methodology.

• Participated in QA meetings using agile methodology and Scrum methodology.

• Used Clear Quest for defect reporting and tracking

• Reviewed the internal test plans and worked with developers for external review on test plans and test cases

• As a Sr.QA team member attended user meetings communicated with the teams.

• Connected to different source databases extracted the data into excel spread sheet.

• Executed SQL Queries by writing the simple and complicated join.

• Compared the data with source and target tables and validated data based on requirements.

• Validated Database calculation whether the right values are populating or not

• Unix file validation

• Coordinated with Team reviewed the weekly status reports

• Involved in Project Plan preparation and Status update meetings

• Attended business and developer meetings

Environment: Oracle, PL/SQL, Clear Quest, Test Manager, IBM Mainframes, BugZilla , DB2,telephony protocols, PVCS, C# Java, J2EE, VBScript, Web Logic, Server 8.1,Agile Methodology

Client : Capital One, Richmond, VA Oct 07’ to Mar 08’

Role : Sr. QA Analyst

Project: Fusion Integration

Description: Capital One is one of the Largest Financial Corporation, providing Credit Cards, Auto Finance, Direct Banking, and payment services products to consumers, businesses and institutions. Touch Point is the main module of Fusion Integration. Touch Point is a Web based application, which mainly deals with Online Deposit Account Opening. Touch Point contained different types of accounts namely Money Marketing Accounts (MMA), Certificate of Deposit (CD), and Individual Retirement Account (IRA).

Responsibilities:

• Analyzed and reviewed the software requirements, functional specifications and design documents for Credit Card Processing application.

• Co-ordination of testing effort involving Call Centre, Back Office, Operations and Data Management groups.

• Participated Business functionality review meetings.

• Involved in writing test plans and developing test cases from Business Requirements.

• Involved in Functional Testing, System Testing and Integration testing to ensure all aspects of the system are functionally correct.

• Involved in User Acceptance Testing by providing test data for users.

• Worked with SQL for testing database integrity.

• Wrote many SQL queries to verify data in the DB and verify consistency with application UI

• Used Test Director to develop and implement the Test cases.

• Used Test director for defect Management and bug tracking.

• Used PVCS Tracker for defect tracking.

• Analyzed, documented and maintained Test Results and Test Logs.

Environment: Windows XP, HTML, Java, IE 6.0, Java script, PVCS Tracker, Oracle9i, MS-Word, Ms-Excel, J2EE, and TestDirector 8.0.

Client : US Bank, MN Nov 05’ to Sep 07’

Role : QA Analyst

Description: The project involved developing an online money transfer system for customers. The system was designed for portfolio managers and financial analysts that helped them to take critical financial decisions. The system offered other services like model portfolio watch list, stock and company analysis. The system computed various financial parameters.

Responsibilities:

• Analyzed the user/business requirements and functional specification documents

• Maintained the Project Plans in Microsoft Project. Designed the Process by using Ms Visio

• Produce weekly project status reports for clients and higher management.

• Creating test plan, walk through, integration approach and strategy document, test cases, scenarios, conditions and scripts.

• Worked extensively on Online Banking & Electronic Bill Payments.

• Effectively interacted with end users, development personnel, QA team and various subject matter experts.

• Performed Functional testing, Integration Testing, Unit testing and System Testing.

• Facilitated weekly team meetings between business users, developers and tester where test status and defects were discussed.

• Conducted User Acceptance Testing (UAT) and Wrote test scripts for User Acceptance Testing (UAT).

• Wrote SQL queries to perform data validation, report validation and data integrity test effort

• Interacted with developers to report data related bugs and re-tested the fixed issues.

• Created Project, Requirements, Test Plans and Tests in Test Director

• Used Test Director for defect reporting and tracking

Environment: Test Director 8.0, Win Runner 7.6, Oracle, PL SQL, VB Scripting IBM Mainframes, ETL,DB2,PVCS, C# Java,J2EE,VBScript, SOAP

Client : Memorial Hospital, Hyderabad, India Apr 04’ to Aug 05’

Role : QA Tester

This system consists of several modules like patient treatment, processing and follow up. Query screens to verify patient medical history & patient address etc. The ICD code analysis, patient treatment history, treatment errors &follow up are in history module.

Responsibilities:

• GUI functionalities were tested according to guidelines of test cases.

• Writing, debugging & execute test scripts using win runner.

• Created test scripts for various testing stages like Functional, regression, system and end to end testing.

• Used SQL for querying & updating records for retrieving functions and procedures.

• Created & maintained test reports and found bugs & reported using Mercury Management Tool Test Director.

• Interacting with Developers & Business Analysts regarding requirements, test scenarios and defects.

• Defined & Implemented procedures for bug flow process to efficiently report and document problems, monitor and verify their fixes.

Environment: Test Director, Visual Basic, SQL Server

Education:

Bachelor’s in Computer Science Engineering (C.S.E) from JNT University, Hyderabad, India.

Contact this candidate