SUMMARY

• More than 7 Years of experience in design, development and testing in Oracle database applications, web based applications.
• Expertise in testing Distributed Web - Based Applications, Client-Server, Java applications, .NET applications.
• Highly Proficient in different types of testing like Functional and Regression Testing, System Testing, Integration Testing, User Acceptance Testing, Performance Testing, Smoke & Sanity Testing, Exploratory Testing.
• Expertise in Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Configuration Management, Test Metrics.
• Expertise in both Manual and Automated Testing with Black Box.
• Extensively tested PL/SQL, HTML, XML, DHTML, Oracle, VB, VBScript, Java, JavaScript and dynamic Web pages, Test Director and Quality Center.
• Strong experience in SQL, PL/SQL.
• Basic experience of UNIX.
• Experience with Business Intelligence tools like Hyperion/Brio and Interactive Reporting.
• Extensively used Mercury Quality Center. Good Experience in automated testing tools such as QTP, Test Director etc.
• Adept in Back end testing and performed Data integrity/verification testing using SQL queries
• Extensive experience with Functional, GUI, Database, Stress, Volume, Regression, Load and Performance Testing. Experience in Preparing Test Strategy, developing Test Plan, Test Cases, writing Test Scripts by decomposing Business Requirements and developing Test Scenarios to support quality deliverables.
• Extensive work experience on Functionality Testing, GUI Testing, Regression Testing, Performance Testing, Stress Testing, Integration Testing, System Testing, User Acceptance Testing.
• Highly proficient in SQA methodologies for Waterfall, Agile.
• Excellent verbal, written and analytical skills. Self motivated with strong work ethics.
• Strong planning, analytical and problem solving skills.
• Excellent Written/Verbal communication skills.
• Experienced in working in a team or independently.

TECHNICAL SKILLS

Operation Systems: Windows 2003/2000/XP/NT/98/95

Language/Tools: SQL, PL/SQL, Java Script, Html, VB Script.

Internet Program/Tools: XML, HTML, VB Script

Database: Oracle, Teradata

Testing Tools: Load Runner 8.x/9.x, Win Runner, Quick Test Professional, Quality Center, Test Director, Test Complete

Version Management: PVCS and CVS

Defect Tracking System: Test Director, Rational clear quest and Quality Center

Applications: Web Based, Client/Server and Rules Engine.

IBM Tools: Rational Clear Quest, Rational Test manager

Test management Tools: Mercury Quality Center

PROFESSIONAL EXPERIENCE

Confidential, OH

QA Analyst

Responsibilities:

• Involved in the Analysis of the Business requirements, test planning, test development, and test execution
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams so that developers and other stake holders can understand the business process.
• Worked as a QA analyst for testing Facets and Membership solution web application.
• RUP methodology was used wherein its six best practices for iterative and incremental development were incorporated into the system.
• Preparing test requirements, Test Plan approach document and Test Cases
• Prepared test data as per requirements specifications document
• Set up test environment and conducted execution as per approved test cases and procedures
• Performed extensive Manual Testing to verify the application is complete and stable
• Performed data validation and testing extensively by using SQL queries including multi-table joins, aggregate functions and sub-queries
• Generated scripts for Automated Testing using QuickTest Professional
• Enhanced test scripts by inserting GUI checkpoints and Synchronization points
• Performed parameterization and correlation on data values
• Tested the application for web functionality, and verified online modules for broken links and orphan links
• Executed, analyzed, and verified test results and worked with developers to resolve issues
• Coordinated with the programmers for finding the application flow.
• Performed Regression Testing and updated test assets periodically
• Prepared Requirement Traceability Matrix (RTM) to establish trace ability between requirements and test cases and procedures
• Generated weekly QA reports using TestDirector
• Prioritized and reporting defects using TestDirector and generated weekly and monthly reports for managerial decision-making.
• Conducted internal and external reviews as well as formal walkthroughs, and participated in status meetings
• Performed functionality testing which involves verification of results with the available data.

Environment: Quick Test Professional, Test Director, Oracle, Java, XSL, XML, HTML, Web Sphere, Windows 2000, MS Office, Project and VISIO.

Confidential, Englewood

Developer/Analyst (SME)

Responsibilities:

• Created Business Objects Reports
• Documenting models with metadata
• Creating data mappings and data dictionaries
• Analyze the business requirements and develop a technical strategy or approach for data extraction.
• Written lot of PL/SQL programs, stored procedures and triggers for data loading and data validations.

Confidential

Responsibilities:

• Requirement analysis
• Report design and development
• Unit testing, System testing and release
• Publish, Schedule and Run Reports using EPM Portal
• Gather requirements and design docs from Business Analyst and Design team for System and UAT
• Participate in preparing the Test Plan and Test strategy for System and UAT
• Drafted test strategies, test cases, test plans and test scripts for the Installation, GUI, Functional, Security, Stress, Recovery, Performance and Integration testing.
• Implemented SDLC methodology and used its best practices in documenting the artifacts after every phase with proper distribution of workload.
• Managing all phases of testing for assigned components ensuring test plans and test cases are completed and met business requirements.
• Working with development teams investigating and correcting software bugs and deficiencies based on the testing results.
• Responsible for manual testing of the application to match with application requirements and write user manuals.
• Generated test execution reports and release status assessment report using Rational Clear Quest.
• Facilitated meetings between Stakeholders, Engineers, Developers, and with multi-functional team to identify and resolve issues, and integrate system enhancements.
• Worked on excel sheets for data comparisons and data calculations.
• Worked closely with end-users, developers to develop a detailed understanding of the opportunities for improvement and functionality, detect bugs and resolve them, provide feedback and improve the entire development process.
• Designed quality center test lab and test sets for easy tracking of overall test process for UAT
• Prepared and executed Test cases according to the specification using QTP
• Reviewing the documents to verify the functional coverage and types of testing like Acceptance, Smoke, Integration, Load, Stress, Regression and etc
• Setup the test environment for System and UAT
• Analyze business specifications and request clarifications
• Perform Functional, Integration, System and Regression Testing to check the stability of the Application
• Participate in the project status review meeting
• Prepare and updated RTM
• Analyze Test Results and Reported Bugs using QC
• Experience in testing various database applications in Oracle 8i, SQL Server, and MS Access

Environment: Hyperion IR, EPM, HPQC, QTP, DOORS, LDAP, OS/390, DB2, SQL Server, Windows, IE, QTP, XML, Java J2EE, Oracle, SQL, PLSQL, MS VISIO, MS Project, and MS Office.

Confidential, Englewood, CO

Developer/Analyst

Responsibilities:

• Requirement analysis
• Report design and development
• Unit testing, System testing and release
• Coordinating with Testing and Business team
• Developed and Tested numerous month end reports for the Accounting (Programming Payments, Tax).
• Developed and Tested reports for the Sales tax team that will help them claim money for equipments that have been re deployed.
• Developed and Tested reports for the Marketing, Internal Audit and Corporate Management Program.
• Tune queries and develop generic queries so that they can re use when needed.
• Thorough knowledge of the various databases and the data and how they can be manipulated to produce meaningful reports for the business.
• Modeled the business rules into a functional star schema database design and data modeling.
• Extensively used SQL Query, Joining tables, SQL functions in Queries.
• Involved in the finalizing the structure (Data Grain) of the input file for the above mentioned objectives.
• Supported Testing team by loading data for all possible scenarios.
• Responsible for creating test scripts, setting up QA data for various scenarios, tracking the QA defects.
• Having interacted closely with the various business units, I understand their requirements and am able to suggest ways to develop reports that would be more useful to the business.
• Trouble shooting, analyzing reports that do not produce the expected results and finding solutions or work around for them.
• Widely used Database objects like Views, Indexes, Stored Procedures, synonyms, Triggers and Global Links for reducing the load on ETL tools.
• Prepared Test Scripts, Test Cases based on requirements and functional specifications
• Performed the System Test Cases and verified actual results to expected results
• Performed Backend testing by using SQL on DB2 database for validating & retrieving the data used for various testing scenarios.
• Performed data driven testing for necessary data required for applications.
• Prepared Regression Testing suite of automated QTP scripts to do the Regression Testing and Build Acceptance Testing.
• Performed field validation with the data in the DB2 Database to make sure whether the application is pulling the correct data or not.
• Load all the function libraries using Library functions in QTP utilities.
• Created and executed various SQL quires for data and table structure changes.
• Created the test data for system testing, regression and UAT using EXCEL.
• Performed System, GUI, Integration, Functional and Regression Testing.

Confidential, Englewood

QA Analyst

Responsibilities:

• Developing test cases by analyzing the requirement specifications for functionality and regression testing and execute them against new builds.
• Test Trouble Tickets, Change Requests and Enhancements.
• System, UAT, Regression and Performance test.
• Performing back end data validations using SQL Server to ensure the expected configurations exist in the standard list of configuration tables in our system called NEPTUNE.
• Validating the feasibility of a new Call Plan or new Market by creating new Accounts and Telephone Numbers and assigning usage by going through all the transaction processes ( Confidential Digital Voice processing) right from the Switch to the billing including Mediation, Pricing and Billing using End to End Testing method.
• Submitting and Managing bugs in defect tracking tool. (Test Director)
• Worked closely with Development and Product / Project Management for the timely resolution of defects and verify defect fixes.
• Used to attend requirement discussion, design discussion, status update meetings and the Lesson learned meetings for various projects.
• Creating Data for System testing and User Acceptance Testing.
• Helping Users to understand the implementation of new interfaces and enhancements

Confidential

Responsibilities:

• Performed requirements and design inspection with Business user group and implementation groups.
• Created Master Test plan and release test plan, Test environment/data setup specs for Migration testing.
• Reported status to higher management during various phases of the Testing life cycle.
• Derived testing requirements from the functional, system and design specification.
• Responsible for creation of integration test plan, data mapping documents etc.
• Provided integration status updates and follow-ups with external vendors as well as internal stakeholders.
• Interacted with user groups, Business Analysts, vendors to understand detailed technical/business process flows, managed testing assets in Test Manager and Quality Center
• Created Requirements matrix, Use case in order to analyze and test critical areas of application, organized several brain storming sessions with Business Analyst and Clients in this process.
• Created Integration and System Test plans with SDLC standards, which adequately exercise functioning of the system and its various components are appropriately created and executed.
• Tested positive and negative testing for the rules associated with committing application
• Developed complete Test cases and scenarios including data required to adequately and thoroughly Test complex solutions on multiple operating platforms and appropriately consider, conceive, and apply technical Testing across multiple operation environments.
• Used Test manager and DOORs to maintain use case vs. test case requirements traceability matrix.
• Performed Black box, Functional Testing, GUI Testing, web Testing using Win Runner and Quick Test Pro. Performed end-to-end system Testing.
• Coordinated the Testing efforts during Integration, System and User Acceptance Testing phases.
• Managed defects through Clear Quest defect tracking. Assigned defect priority, follow up and retest defects over builds
• Created Risk Assessment document based on defect matrix to assess the risks associated in production environment.
• Created, maintained, and updated Testing documentation and deliverables with CMM standards.
• Worked closely with the Developers, Users, Business Analysts, and Users during all Testing phases. Obtain through understanding of functional business concepts and specific knowledge of the business/ technical processes. Suggested process improvements.
• Created technical document with all performance details based on requirements presented to project management and performance maintenance team.
• Created test coverage analysis Reports using Test Director for UAT

Confidential

Responsibilities:

• Involved in assisting the QA Lead and participated in planning and organizing the test schedules and test cases.
• Designed and executed Test Plans and Test Cases based on business requirements using the Citizens Standards. Executed Test Scripts and different Test scenarios.
• Developed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements.
• Involved in functionality testing, Integration testing, Smoke testing, Black Box testing, Usability testing and Regression.
• Prepared Test Cases document.
• Prepared the Requirement Traceability Matrix that maps the functional/business requirement to the test cases.
• Responsible for Functional (Progression) Testing for the release.
• Performed Regression testing on various modules.
• Responsible for conducting different level of reviews of Test Suite and get sign-offs.
• Performed Backend Testing using complicated SQL Queries and to test the application for business rules in huge volume of data.
• Co-ordinate with the Business Analyst to understand and implement the testing as per the business requirements.
• Supported in preparing Mock Data for Test Bed. Helped to identify the data required.
• Performed Product Acceptance Testing.
• Assisting the team with issues and support for testing.
• Involved in doing System testing of applications along with team members
• Verified and validated fixed bugs.
• Tested the application manually and reported and tracked the defects through the Test Director.

Confidential, Aurora, CO

QA Analyst

Responsibilities:

• Test case preparation and Test design.
• Requirement mapping against test cases using Rational tools.
• Execute test cases by manual and automated process.
• Preparation and Execution of Test Cases
• Involved in Functionality testing, Integration testing, Smoke testing, Black Box testing, Usability testing and Regression.
• Performing User Acceptance testing
• Involved in doing System testing of applications along with team members
• Verified and validated fixed defects
• Test reporting and Bug Tracking.

Confidential

QA Analyst

Responsibilities:

• Write test documentation including test suites, test cases, checklists, etc.
• Persistent in localizing software defects and make them reproducible.
• Involved in assisting the QA Lead and participated in planning and organizing the test schedules.
• Designed and executed Test Plans and Test Cases based on business requirements.
• Executed Test Scripts and different Test scenarios.
• Test Scenarios, for manual with some automation testing.
• Use Quality Center Application to track defects.

Confidential

QA Analyst

Responsibilities:

• Write and execute SQL queries for data validation.
• System test case preparation and testing.
• Set up and staged test data for all testing purposes and validated the results to conform functionality to requirements.
• Performed Positive and Negative Testing to ensure appropriate user authentication.
• Developed and Maintained Test Matrix to reflect the test progress