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 teh different types of testing dat 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 teh 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 noledge 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 noledge on Test Coverage Analysis and Ability to mentor teams to meet teh deadlines.
• Expert in Using Quality Center/Test Director as repository for maintaining test cases, execution and tracking teh 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 dat 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 teh development of test plan and test strategy; performed functional and structural analysis for teh 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 teh 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 teh daily loads and handling teh reject data.
• Used SQL tools like SQL Navigator to run SQL queries and validate teh 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 teh new functionalities based on test cases and coordinated with teh development team in fixing teh issues.
• Created Traceability matrix to match teh 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 teh 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 teh testing procedure using Quick Test Pro.
• Tested teh database using SQL queries with teh 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 teh 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 teh 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 teh Dimensional Data Modeling and populating teh business rules using mappings into teh Repository for Meta Data management. Understand teh business needs and implement teh 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 teh 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 teh 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 teh SQL queries.
• Regression testing was performed on new version and on any new changes done by teh business partner.
• Also reviewing and retesting teh 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 teh defects and teh fixes teh 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 teh Business and System requirements for various modules of teh 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 teh data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Analyzed teh 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 teh 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 teh 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 teh features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Designing teh template and structure for data extraction and processing using SSIS and its different tools from different sources of Production server, Excel sheets.
• Prepared teh test data for positive and negative testing used in data driven testing.
• Co-Ordinated with an offshore team to develop teh 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 teh 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 teh 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 dat all teh test cases are updated in teh 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.