EXPERIENCE SUMMARY:

• 10 years of total experience in Manual, Database,UI and ETL testing.
• Expertise in Web testing, Functional testing, Integration testing, Regression testing, Performance testing and End - to-End testing.
• Strong knowledge in design methodologies and good knowledge on software life cycle.
• Have full system development life cycle experience, including designing, developing and implementing Test strategy, Test plans, Test cases, Traceability matrix, Test processes and Test Results.
• Exposure to water fall and scrum development models.
• Strong understanding of testing concepts with expertise in requirement analysis, test case development, black box and white box testing.
• Expertise in creating, executing the test cases and log the bugs in bug tracking tools and report the bugs to respective teams and triage them on time.
• Interacts with development team and Business Analyst to understand the requirement and design documents to map the test cases with requirement and design.
• Highly efficient with building domain and functional knowledge.
• Expertise in Database Testing with good knowledge of SQL LOADER, PLSQL Procedures, Functions, Packages and Triggers.
• Expertise in writing complex data base queries.
• Exposure to PL/SQL development using Oracle.
• Possess good knowledge in Data Warehousing concepts.
• Well versed with data warehouse architecture, data modelling and ETL process.

AREAS/APPLICATIONS:

• Global Remote Services
• Marketing and Sales
• Confidential
• Confidential

COMPUTERS WORKED ON:

• UNIX,LINUX,Windows 7, XP - Professional, 2000 Professional.
• SQL,PLSQL,Unix Shell Scripting.
• SQL Developer, PL/SQL Developer, Toad, ETL,VSS,SVN,Putty, HP-QC, Visual Studio 2008.

PROFESSIONAL EXPERIENCE:

Confidential

Senior QA Analyst

Responsibilities:

• Analysis and validation of business/functional requirement documents.
• Designing the Test plan and Test cases.
• Peer Review of test cases, Traceability matrix.
• Verification and Validation of test results.
• Preparation of SQL scripts for metadata and data validation.
• UAT and Production parallel testing support to sustain team.
• Responsible for the overall quality and timeliness of the deliverable.
• Preparation of status summary reports with details of executed, passed and failed test cases.
• Performing the Back-End testing to ensure data consistency by writing and executing SQL queries on the Oracle database.
• Gathering Reports for tracking the defects and maintenance of the project in HP-ALM.

Confidential

Responsibilities:

• Designing the Test plan and Test cases
• Responsible for the overall quality and timeliness of the deliverable.
• Understanding/Discussing requirements with Business Team and Development team.
• Designing and execution of test cases.
• Performing the End-End testing to ensure data consistency by writing and executing SQL queries on the Oracle database.
• Preparation and execution of Test scripts.
• Verification and Validation of test results.

Hardware: PC

Operating System: Windows 7

Languages: PLSQL,SQL,ETL, Unix Shell Scripting

Special Software: SVN, PL/SQL Developer, Caliber,HP-ALM

Confidential, Detroit, MI

QA Analyst

Responsibilities:

• Interacting with Business, System Analysts, Designers and Developers in requirement gathering meetings and during all phases of the project life cycle.
• Designing the test cases.
• Preparation of status summary reports with details of executed, passed and failed test cases.
• Involvement in taking Reports for tracking the defects and maintenance of the project.
• Monitoring Test execution and Test Reports.
• Understanding/Discussing requirements with Business Team and Development team.
• Designing and execution of test cases.
• Performing the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database.
• Participated rigorously in end to end testing with various front end clients.
• Preparation and execution of Test scripts.
• Verification and Validation of test results.

Hardware: PC

Operating System: Windows 7

Languages: PL/SQL, SQL, ETL, VB.Net

Special Software: SVN, PL/SQL Developer, Visual Studio 2008, Informatica

Confidential, Minneapolis, MN

Senior QA Engineer

Responsibilities:

• Interacted with Business, System Analysts, Designers and Developers during all phases of the project life cycle.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Involved in taking Reports for tracking the defects and maintenance of the project.
• Monitoring Test execution and Test Reports.
• Prepared and reviewed Test scripts.
• Establishments data maintenance.
• Open Coverage Reserved Account Rules Maintenance.
• Temporary Assignment of Sales Territories
• Upload Account Rules
• Account Data Maintenance
• Understanding/Discussing requirements with Business Team.
• Analyzed and Evaluated the Business Requirement Documents, Functional/System Requirement Documents and Use Cases for the application to verify the testability and verifiability of the requirements
• Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database
• Participated rigorously in end to end testing with various front end clients.
• Raised defects and tracked them using “Share point” Bug tracker.

Hardware: PC

Operating System: Windows XP, Unix

Languages: PL/SQL, SQL, Unix shell scripting, ASP.Net, VB.Net

Special Software: SVN, PL/SQL Developer, Putty, MKS Integrity, Visual Studio 2008

Confidential

QA Engineer

Responsibilities:

• Involved in Business Requirement and Functional Requirement discussions.
• Functional Analysis and preparation of test scenarios.
• Executing the Regression Suite and analyzing the test results.
• Creating the bug report summary distinguishing the critical and non-critical bugs.
• Monitoring Test execution and Test Reports.
• Prepared status summary reports with details of executed, passed and failed test cases.
• End to End testing of the application from user’s perspective.
• Designing and execution of test cases.

Hardware: PC

Operating System: Windows XP, Unix

Languages: ASP.Net, C#, PLSQL,SQL

Special Software: PL/SQL Developer, Putty, SVN,Visual Studio 2008

Confidential

QA Engineer

Responsibilities:

• Liaise with the Development team to understand the Business Requirement Documents.
• Participated in regular project status meetings related to testing.
• Taking ownership of deployments into UAT environment and supported to pair wise testing team.
• Managed and conducted System testing, Integration testing and Functional testing.
• Reported and documented all defects and test results.
• Developed SQL scripts to load data into the tables.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Prepared & reviewed test cases and worked on the test plan to cover overall functionality of the application for Functional testing, GUI testing and System testing.
• Monitored & tracked bugs through "Share point" and categorized them based on severity and reported the same to Developers for prompt resolution.

Hardware: PC

Operating System: Windows XP, Unix

Languages: PL/SQL, SQL and Unix shell scripting

Special Software: PL/SQL Developer, Putty, VSS

Confidential

QA Engineer

Responsibilities:

• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing and Functional testing.
• Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Developed SQL scripts to load data into the tables.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Extensively used the AutoSys jobs for the entire project.

Hardware: PC

Operating System: Windows XP, Unix

Languages: PL/SQL, SQL and ETL

Special Software: PL/SQL Developer, Informatica

Confidential

Programmer

Responsibilities:

• Implementation of the code as per the design document and unit testing.
• Resolving MKS tickets
• Implementing change requests/enhancements in PL/SQL and Unix
• Involved in creating database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Written complex sqls using joins, sub queries and correlated sub queries.
• Involved in database programming and developed Stored Procedures.
• Developed PRO*C programs in Unix environment.

Hardware: PC

Operating System: Windows XP, Sun Solaris

Languages: Pro*C, SQL, PL/SQL

Special Software: VSS, PL/SQL Developer, Putty

Confidential

Tester

Responsibilities:

• Prepared and executed Test suites (Functional, Integration and Regression).
• Designed and execution of test cases.
• Reported and documented all defects and test results.
• Prepared and executed Test suites (Functional, Integration and Regression).
• Designed and execution of test cases.
• Reported and documented all defects and test results.

Hardware: PC

Operating System: Windows XP, Sun Solaris

Languages: Pro*C, SQL, PL/SQL

Special Software: VSS, PL/SQL Developer, Putty