SUMMARY

• Over 6 years of professional experience in system analysis, design development, and Quality Assurance in Client Server and Web Based Applications.
• Experience working in Health Care, Financial, Insurance and Banking Domains.
• Experience in software testing process which includes preparing Test Plans, Test Cases, Test Scenarios Executing Tests based on business requirements and functional requirements.
• Experienced in the different types of testing that include System testing, Integration testing, Functional testing, User Acceptance testing (UAT), Black Box Testing, Stress/Load Testing, Manual and Regression testing with automated testing tools.
• Strong in developing Test plans, Test cases, Test data, Defect Tracking & Reporting, Ability to perform under deadlines, good individual and team player
• Managed the process of data creation for testing purposes.
• Prepared new Datasets from raw data and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Experience in testing on Enterprise wide applications with multiple databases, and Ability to test backend applications by using SQL statements.
• Testing of database projects on Windows and UNIX Operating Systems.
• Defect Tracking for both Manual and Automated Testing.
• Involved in Complete Software Development Lifecycle (SDLC) of QA Software Development and Testing Methodologies.
• Working experience with Oracle, MS SQL Server, SQL Queries.
• Experience in creating QA testing environment using Integration, GUI, Functionality, Regression, and System Testing.
• Experience in test management and defect tracking tools like Quality Center, Clear Quest.
• Sound knowledge of Black Box, System Testing, Regression, Integration, Functionality and User Acceptance Testing, Database Testing.
• Working Experience with Agile Methodology - Scrum, V Model.
• Well versed in analyzing Results, Bug Tracking & Reporting, Detailed status reporting
• Good knowledge on Test Coverage Analysis and Ability to mentor teams to meet the deadlines.
• Expert in Using Quality Center/Test Director as repository for maintaining test cases, execution and tracking the defects.
• Developed Test scenarios and Test cases using Quality Center.
• Ability to understand Functional and Software Requirements Specification documents.
• Proficient in Manual (System, Black Box) & Automation testing.
• Excellent communication and interpersonal skills.
• Ability to work efficiently as Individual and in a Team.
• Committed, and Result Oriented with a quest and zeal to learn new technologies and undertake challenging tasks. Also hard working in nature to achieve that extra mile whenever required.
• Excellent ability to manage resources in mission critical, high-pressure projects.
• Specific expertise in writing Functional, Integration and System Test cases

TECHNICAL SKILLS

Testing Tools: Quality Center, Test Director, Win Runner, Load Runner, Quick Test Pro, Rational Suite (Clear Case, Clear Quest, PVCS Bug Tracking Tool) Compuware Tools (Team Track, Track Record).

Web Technology: HTML4, JavaScript, VB Script

GUI Tools: Visual Basic, Developer 2000, Crystal Reports.

Databases & RDBMS: Oracle, MS Access, DB2, SQL Server

Operating Systems: Windows (98/2000/2003 NT/XP) and UNIX, Linux.

ETL & Reporting tools: Informatica, Business Objects

Languages: C, C++, SQL, PL/SQL, Java, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

QA Analyst

Responsibilities:

• Analyzed functional requirement documents and business requirement documents and decided which part of application has to be tested manually and which part has to be tested using Automation tool.
• Executed test cases and verified actual results against expected results.
• Managed individual test cycles, reported bugs and worked with analysts and developers to resolve problems.
• Involved in the development of test plan and test strategy; performed functional and structural analysis for the same.
• Tested various business rules of data transformations using various Informatica transformations like Normalizer, Source Qualifier, Update Strategy, Look up (connected/unconnected/static cached/dynamic cached), Sequence Generator, expression, Aggregator, XML(source and generator), Stored Procedures.
• Updated database tables to support the testing of ETL functionality.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure Fast Load and Multi Load sessions.
• Solely responsible for the daily loads and handling the reject data.
• Used SQL tools like SQL Navigator to run SQL queries and validate the data in warehouse.
• Used workflow manager and work flow monitor to run and monitor jobs.
• Tested mapping parameters and variables to support SQL override.
• Involved in testing the new functionalities based on test cases and coordinated with the development team in fixing the issues.
• Created Traceability matrix to match the requirements with test cases.
• Involved in various phases of testing like development testing, System and Integration testing, Component level testing and User Accepting Testing.
• Performed multi-browser testing for all the external applications.
• Identified defects, reported and documented them using Quality Center.
• Analyzed performance test results and worked with appropriate IT personnel to resolve areas of performance.
• Wrote and recorded scripts for automating the testing procedure using Quick Test Pro.
• Tested the database using SQL queries with the related database platform.

Environment: Quality Center9.0,QTP, Web Logic, Windows 2000,2003 advanced Server, XP,HTML, JAVA, VB Script, SQL, VB, Oracle9i, Visual SourceSafe.

Confidential, Fairfield, NJ

QA Analyst

Responsibilities:

• Reviewing the Business specifications Documents, Attending Specification review meetings.
• Analyzed Business Requirement document and prepared Test cases for Unit Level, Functional and Integration Testing.
• Developed test cases in Quality Center using the functional specifications in Doors.
• Prepared new Datasets from raw data and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design
• Worked onInformaticaPower Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Involved in monitoring Informatica jobs/processes using Workflow Monitor.
• Co-coordinating with offshore team by assigning everyday task and reviewing the project status.
• Attending weekly status meetings and updating weekly status reports.
• Communicating with business team on change controls and specification changes, and updating Test cases accordingly.
• Reviewed and logged new defects using Quality Center during the Regression Testing.
• Writing test cases and reviewing test cases written by offshore team on various projects in Quality Center.
• Performed functional and backend testing by executing the SQL queries.
• Regression testing was performed on new version and on any new changes done by the business partner.
• Also reviewing and retesting the defects logged by offshore team in Quality Center to make sure they are valid by comparing with specifications.
• Coordinated with team to created test scripts/plans and test cases for resolving bugs, and provided end user training.
• Worked with developers to rectify the defects and the fixes the defects.

Environment: HP Quality Center 10.0, VBScript, Visual Elk, SQL Server 2005,MS Excel2007, MS Project2000, and Windows 7:Informatica Power Center 8.6.1, Java,SQL Server 2008.

Confidential, PA

QA Analyst

Responsibilities:

• Analyzed the Business and System requirements for various modules of the application.
• Created Test plan template, Test Design and responsible for implementation of Test cases as automated test scripts.
• Involved with requirement gathering and analysis for the data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Analyzed the source data coming from Oracle, Flat Files, and MS Excel coordinated with data warehouse team in developing Dimensional Model.
• Experience with Quality Center including administration, requirements, test planning/design, test lab/execution (i.e. Creating and executing complex test sets), and defect tracking.
• Quality Center customization of the Requirements, Test Plan, Test Lab, and Defects modules.
• Used HP Quality Center for testing activities.
• Involved in writing Test Plan and Testing Strategy.
• Developed various test scenarios based on ETL mapping document.
• Used Rational Clear Quest for bug tracking needs.
• Created SQL server Analysis Projects using MS SQL Server 2005.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica
• Developed various test scenarios based on ETL mapping document.
• Extensively used all the features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Designing the template and structure for data extraction and processing using SSIS and its different tools from different sources of Production server, Excel sheets.
• Prepared the test data for positive and negative testing used in data driven testing.
• Co-Ordinated with an offshore team to develop the application as per requirement.
• Worked very closely with developers to recreate defects found and also to verify fixes.

Environment: Quality Center, Quick Test Pro, Win 2000, JAVA, HTML, Java script, VBScript, SQL, ORACLE 9i.Unix.

Confidential

QA Tester

Responsibilities:

• Performed requirement analysis, testing and review of the components done by peer team members.
• Managed individual test cycles, reported bugs and worked with analysts and developers to resolve problems. Involved in writing and executing test cases based on the requirements.
• Performed End-to-End testing of full functionality.
• Experienced in using Mercury Quality Center as a defect tracking tool.
• Involved in Component Testing, Functional Testing, Integration Testing and Regression Testing.
• Ensure that all the test cases are updated in the Quality Center along with Master test plan.
• Conducted functional and regression testing using Quick Test Profession. in a tracker system, which is maintained in a database using Team Track.
• Defects were tracked, reviewed, analyzed and compared using Quality Center.
• Used to arrange meetings to discuss issues with developers and project managers. Worked very closely with developers to recreate defects found and also to verify fixes.
• Initiated and participated in Conference Calls, Walkthrough and Review Meetings and involved in supporting Production Releases.

Environment: Quick Test Pro, Quality Center, Apache, Java, J2EE,.Net, Java, JavaScript, VBScript, XML, Oracle, Linux, Windows 2000/NT/XP.