SUMMARY

• 8 years of extensive hands on Quality Assurance and ETL testing of Client/Server, Web Based Software applications using Manual and Automated Procedures.
• Knowledge on Agile methodology, Software Development Life Cycle (SDLC) and Web based life cycle experience predominantly working as Quality Analyst in the areas of Retail, Health Care and Banking Industry.
• Expertise Knowledge in testing Database, Web applications and Sales force applications.
• Sound Knowledge on Data base, Manual, Black Box, White Box, System, Regression, Integration, Functionality, nonfunctional and User Acceptance Testing in testing both client - server and Web-based applications.
• Good at understanding the Business Requirement Documents (BRD), Functional Specifications Document (FSD) and Technical Specifications Documents (TSD).
• Extract, Transform and load (ETL) software, which includes reading data from source, cleaning it up and formatting it uniformly, and then writing it to the target repositories. After extraction the data is transformed, modified, depending on specific business logic involved so that it can be sent to the target repository.
• Participated in status call during each release to update about the daily activities and issues to system test Manager.
• Writing Sql queries for various scenarios like count Test, Primary Key Test, DuplicateTest, Attribute Test, Default Check Test, Technical Data Quality, Business Data Quality.
• Followed the agile methodology for the multiple sprints for the entire project.
• Experience with creating Test Plans, writing and executing Test Cases, Manual/Back end Testing and Web Services Execution using Soap UI.
• Extensive Knowledge on testing Profit max Systems( Confidential Financial Application), PC Lender Application( Confidential Mortgage Application),Sales force CRM,Talend MDM,Siebel CRM, CIM, ATLAS,CorDaptix(Energy Billing Application).
• Working Knowledge on testing tools of HP Products like Application Life Cycle Management (ALM), Quality Center, TOP Team.
• Reported and tracked defects using Defect Tracking Tools like Qualitycenter, ALM and Micro Soft Test Manager.
• Experience in testing web applications, J2EE applications, Web Services, XML Web logic and Web sphere application servers and .Net, C# applications on IIS servers.
• Knowledge of Rational Unified Process (RUP) methodology, UML, QA Validations to ensure the SEI-CMM/ISO Quality standards, Quality Assurance Life Cycle (QALC) and QA Methodologies.
• Experience in testing database applications of RDBMS in ORACLE 11g, SQL Developer,SQL Server and MS Access.
• Good Knowledge in Comparing and validating data in Landing tables, base tables, rollup tables to make sure the data is populating correctly in all the tables.
• Able to effectively communicate with interfacing application areas to understand/resolve issues.
• Excellent coordination in working closely with End Users, Business analysts, Project Managers, Developers to understand requirements, business processes for Quality Assurance and led regular walkthroughs.
• A good team player with excellent communication and interpersonal skills and the ability to grasp new ideas and technologies quickly, to balance multiple short-term and long-term programming projects, and to effectively communicate with the staff members.

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/XP/7

Databases: Oracle 11g, Oracle SQL Developer,SQL Server 2007, MS-Access

Languages: Java, C, C++, COBOL, SQL, PL/SQL

Development Tools: Visual Basic, VB.NET

Internet Technologies: HTML, VB Script, Java Script, XML, JSP, ASP, and Java Applets.

Testing Tools: Win Runner, Load Runner and QTP

Defect Trackers: ALM 11.00, Test Director/ Quality Center10.00, Top Team, Rational Clear Quest, MTM/TFS.

Packaging & Deployment Tools: PC Lender Application ( Ally Mortgage Application), PROFITMAX ( Confidential Financial Application), Sales force CRM, Talend MDM,Siebel CRM,CIM, CorDaptix, ATLAS(Green Screens),CICS screens.

Other Skills: SOAP UI, Toad for Data Analyst 2.7

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL Test Analyst

Responsibilities:

• Create, Design and Execute Test plans, Test Scenarios & Test Cases.
• Primarily test Source data Extraction, Business Transformation Logic and Target Table loading.
• Verify the data reported with source data for consistency and accuracy at every time when they load data into data base.
• Creating sql queries to fetch and verify the data from source and target are matching.
• Data Quality Validation - Check for missing data, mismatch, negative and consistency.
• Field by field data verification need to be done to check the consistency of source and target data.
• Other validations like meaning full ness, extra characters, Accuracy of data in field by field.
• Verify the source column data and target column data after loading data into data base.
• Verify the source column data type& Length (csv) and target column data type and Length(DB table structure).
• Record count check- The objective of the count test scripts is to determine if the record count match the record counts in the target.
• Finding missing data and mismatched data between requirement document vs. LOS Extract.
• Attending daily status calls,SRS, BRD Documents review meetings and follow up with latest Updates.

Environment: Oracle Sql Developer, Oracle 11g,HPQualityCenter10.00,Purchase Lender(Mortgage Application)

Confidential, Charlotte, NC

ETL Test Analyst

Responsibilities:

• Participated in status call during each release to update about the day today activities and issues to system test Manager.
• Logging the defects and participating in defect review meetings.
• Validated the source data with the target data, Mapping source data values to the target data values via data base and application functionality
• Responsible for developing Traceability Matrix, worked on developing test plans, writing test cases, generated test scripts Involved in developing the test strategy.
• Conducted peer review meeting for Test Plan and Test Cases with Business team and got approval prior to the test execution cycle start.
• Work involves preparing test data and executes front end screens using tables data to make sure front-end and back-end data are in sync.
• Writing test cases/steps linking to requirements using ALM.
• Comparing Source (SIT) and Target (PROD) table’s data to find mismatched and missing data.
• Validating data in Landing tables, base tables, and rollup tables to make sure the data is populating correctly in all the tables.
• Developed QA Test plans for Functional, Regression and User Acceptance Testing (UAT).
• Used ALM to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports.

Environment: Profit max, Toad for data analyst 2.7 and Oracle 11g, HP Application Lifecycle Management 11.00(ALM)

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Followed the Agile methodology for with the multiple sprints for the entire project.
• Participated in status call during each release to update about the day today activities and issues to system test Manager.
• Created acceptance Criteria based on user stories.
• Logging the defects and participating in defect review meetings.
• Validated the source data with the target data, Mapping source data values to the target data values via data base and application functionality
• Work Environment involves with Agile and scrum methodology and tested the application in parallel to the development.
• Tested the Web Services Using SOAPs Prior to the Web services.
• Work involves preparing test data (Create Contact/Vendor/Search) based upon the Release SRD(System Requirement Document).
• Writing test cases/steps linking to requirements using Top-Team (Test Management tool).
• Responsible for developing Traceability Matrix, worked on developing test plans, writing test cases, generated test scripts Involved in developing the test strategy.
• Extensively used Top Team for test planning and test management.
• Developed QA Test plans for Functional, Regression and User Acceptance Testing (UAT).
• Performed Both Positive and Negative Testing in each phase of sprint.
• UsedQuality Center to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports.

Environment: Talend MDM (Open Source Management), .Net, SQL Server, Web services, XML Web Services & SSIS, Soap UI.

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Developed QA Test plans for Functional, Regression and User Acceptance Testing (UAT).
• UsedQuality Center to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports.
• Develop SQL Queries for checking the Data Transaction and Database Integrity.
• Data manipulation using SQL queries in Sql Server database.
• Verifying Data validity (good at writing SQL Queries), Data integrity (Checking referential integrity and different constraints), Data manipulation, Updates and Performances related to Data base.
• Observing Operations, which are operated on front end, is effected in back- end or not.
• Need to verify the same for delete and updates of data thru front end is also effecting Data base tables dynamically./after batch jobs.
• Verified the loaded data in Sql Server and compared the extracted data from Legacy system.
• Involved in data load testing checking the compatibility of Source and target and also verifying the total number of rows in source and target.

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Reviewing and analyzing the business requirements/Functional Requirements.
• Prepare the acceptance criteria based on the user stories.
• Prepare the test scenarios and test cases.
• Mapping test cases to user stories in Top - Team.
• Coordinating with the team members in preparation of System test cases.
• Conduct the business review and get the approval for the scenarios.
• Responsibility to coordinate the hands off calls.
• Logging the defects and participating in defect review meetings.
• Retest the defects that were fixed and closed/reopen the defects after verifying it.

Environment: Sales force, Empower ID, Tec sys, Sql Server,Event Ready and ONYX,Web services & SSIS.

Confidential, Salt lake city, UT

Qa Analyst

Responsibilities:

• Analyzed the Business and System Requirements, involved in the Manual/Automated Testing.
• Responsible for developing Traceability Matrix, worked on developing test plans, writing test cases, generated test scripts Involved in developing the test strategy.
• Extensively used Rational Clear Case for test planning and test management.
• Developed QA Test plans for Functional, Regression and User Acceptance Testing (UAT).
• Regression Testing is performed and the additional scripts are generated for each version.
• Develop Data Driven tests to handle the scenarios requiring multiples sets of data and parameterize the scripts to input varying data from MS EXCEL.
• Generated Data Driven scripts that access the backend database, Performed Both Positive and Negative Testing.
• Performed the tests and documented the results and bugs by using Rational Clear Quest.
• UsedQuality Center to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports.
• Develop SQL Queries for checking the Data Transaction and Database Integrity.
• Verified the loaded data in oracle and compared the extracted data from Legacy system
• Performed queries in the database using 'SQL' to check successful transaction using TOAD
• Checked the logs were written for each process that runs.
• Developed SQL Queries to perform Database testing.

Environment: QTP, Quality Center, .Net, Web services, TOAD, Oracle, XML, Test client & SSIS.

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Analyzed system specifications and involved in the development of Business Requirements and functional requirements specification Documents. Involved in technical writing of Traceability matrix.
• Attending Requirement Review meeting with clients.
• Preparation of High Level Test Plan, Test Planning with Team Lead.Reviewing business/functional requirements and technical specifications of the application.
• Developing Test Cases and Test Scripts from FRDs & BRDs and documenting them in Quality Center.
• Using Quality Center to organize Test Processing such as plan test scenarios, execution of test scenarios and tracking defects. And also using Team Track custom application for defect management.
• Performed manual testing on different modules of the application.
• Performed GUI, Functional, Regression, System Testing, Validation and User Acceptance testing.
• Performing Manual Testing using Siebel CRM, CorDaptix (CDX).
• Participating in developing Documents like Test Strategy Document, Exit Document, Down Time Document, and Test Status Document.
• Reported and tracked defects using Defect Tracking Tools like Test Director, and Clear Quest.
• Involvement and active preparation with client while giving Product Demos.
• Follow up with developers on defect status on a daily basis.
• Involved in Production Release Testing.

Environment: Siebel CRM, CorDaptix (CDX- Billing Application for Confidential - Energy),CIM,ATLAS.

Confidential, Dallas, TX

Quality Assurance Analyst

Responsibilities:

• Analyzed system specifications and involved in the development of Business Requirements and functional requirements specification Documents. Involved in technical writing of Traceability matrix.
• Preparation of High Level Test Plan, Test Planning with TeamLead.Reviewing business/functional requirements and technical specifications of the application.
• Developing Test Cases and Test Scripts from FRDs & BRDs and documenting them in Quality Center.
• Creating Traceability Matrix.
• Using Quality Center to organize Test Processing such as plan test scenarios, execution of test scenarios and tracking defects. And also using Team Track custom application for defect management.
• Performed manual testing on different modules of the application.
• Performed GUI, Functional, Regression, System Testing, Validation and User Acceptance testing.
• Performing Manual Testing using Siebel CRM, CorDaptix(CDX),CIM.
• Reported and tracked defects using Defect Tracking Tools like Test Director/Quality Center.
• Involvement and active preparation with client while giving Product Demos.
• Follow up with developers on defect status on a daily basis.
• Involved in Production Release Testing.

Environment: Siebel CRM, CorDaptix (CDX), ATLAS,CICS screens, Quality Center.