PROFESSIONAL SUMMARY:

• Around 6 years of experience in Software Quality Assurance Testing Data base, BI & Web applications.
• Good knowledge in Banking, Insurance, Health Care, Retail domains.
• Conversant with all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC).
• Worked in both Agile & Waterfall methodologies.
• Experience in Web/GUI functional testing and worked and tested SOA environments
• Experience in SQA , SDLC, project management processes, MS Visio.
• Skilled in creating test traceability matrix, test plan, test design, use cases, test cases, test procedures, test log, automated test scripts and defect reporting.
• Worked with discrete databases like Teradata, SQL Server, Oracle, DB2.
• Experienced with various ETL tools like SSIS, Informatica, data stage.
• Sound knowledge of Data Warehouse terminology.
• Hands on Experience in UFT/QTP testing with good exposure on testing procedures and tool.
• Skilled at VBScript, Python and Java for data validation & writing test automation cases in Unified Functional Testing (UFT), Eclipse and Visual Studio Environments
• Expertise in testing complex Business rules by using mapping documents.
• Experienced in using UNIX commands for shell scripting.
• Expertise in writing complex SQL queries.
• Expertise in RDBMS backend testing for data validation and data integrity using SQL.
• Extremely dedicated self - motivated Proactive and willing to assume responsibility.
• Good experience on Team Management for different projects.
• Personal skills include Excellent Communication, strong sense of Organization and Effective Time Management and the Ability to work in a team as well as independently.
• Executed negative and positive test cases to test application functionality against user requirements.
• Effectively manage multiple work assignments and priorities.

TECHNICAL SKILLS:

Test Tools: Quick Test Pro, Win Runner and Test Director and Rational Test Suite, UFT

Programming Language: C#. Net, XML & HTML

Database: Oracle, SQL Server, Teradata, DB2

Tracking Tools: Win Runner, Quality Center, Test Director, ALM and Bugzilla

Utilities: Visio, SQL Load, FTP, Telnet, Rational Clear Case, All Fusion

Operating Systems: Citrix, HP-UX, UNIX, DOS, Windows

Miscellaneous: MS DOS, Word, Excel, Power Point

ETL/BI Tools: Informatica 8.6.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Business Object, Crystal Reports, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

QA Analyst

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Performed Code review of Scripts and made comments for changes made in the script.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Assigned critical performance Defects to the developer using ALM.
• Generating Test Scripts using UFT.
• Creating, managing, tracking test automation resources.
• Used HP-UFT (Unified Functional Testing) Scripts with various checkpoints (Bitmap, Text, Tables) and parameterization to perform testing with different kind of data sets
• Performed Record and Run, Data driven framework, Checkpoint using UFT
• Used Unified Functional Testing (UFT) for Shared Object repository creation and maintenance, used regular expression, re-usable actions, data table, checkpoints and recovery scenario
• Created Unified Functional Testing (UFT) advance automation scripts using Descriptive programming, Modular approach, Custom Functions, Logics, and Looping for Regression testing.
• Developed Data Drive, Keyword Drive and Hybrid Frame Work using UFT
• Imported data from the Database to the Data table and performed Data Driven testing with different Data sets for reports generation module in Unified Functional Testing (UFT)
• Worked with the Business and Development team for gathering
• Analyzed the functionality needs to be automated based on the manual test cases and estimated time and efforts for the required functionality.
• Involved in Data migration and Data distribution testing
• Extensively used my SQL proficiency during data migrations to ensure data accuracy and integrity
• Weekly meeting with the management team and share the Status Report on the weekly basis.
• Tested to verify that all data were synchronized after the data is troubleshoot, and used SQL to verify/validate my test cases.
• Worked on ALM and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using ALM.

Environment: SQL Server, ALM, MS Office, IDD (Informatica Data Director) and UFT.

Confidential, Charlotte, NC

ETL QA Analyst

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Performed both Positive Testing and Negative Testing.
• Performed Code review of automation Scripts and made comments for changes made in the script.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Involved in Data migration and Data distribution testing
• Automated scripts on DB Fitnesse.
• Validated the web services by testing the WSDLs using SOAP UI.
• Used SQL queries to retrieve data from tables and to perform back end testing through TOAD for ORACLE and Teradata SQL Assistant for Teradata.
• Validated all the ETL mappings developed to fetch data from OLTP system to the data warehouse.
• Participated in SCRUM and SPRINT meetings.
• Created Scenarios as per business requirements with various user loads using Performance Center.
• Generated Automated test scripts and executed them.
• Used test automation tools like QTP, DB Fitnesse for Regression testing and functional testing.
• Assigned critical performance Defects to the developer using JIRA.
• Weekly meeting with the management team and share the Status Report on the weekly basis.
• Tested and validated data on Micro Strategy reports.
• Tested to verify that all data were synchronized after the data is troubleshoot, and used SQL to verify/validate my test cases.
• Used JIRA and TFS to groom, document and analyze user stories
• Worked on JIRA and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using JIRA.

Environment: Netezza, JIRA, MS Office, Informatica, MS SQL, Agile, Scrum, DB Fitnesse, QTP

Confidential, Richmond, VA

ETL/BI/ QA Analyst

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Involved in implementation of the Test plans, Test cases and Test Scripts.
• Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
• Tested the data and data integrity among various sources and targets.
• Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.
• Implement and develop automated test practices for both web and windows applications primarily using Visual Studio’s Coded UI module for both web and windows applications.
• Design and create test scripts using C# and/or VB.NET to address areas such as database impacts, software scenarios, regression testing, negative testing, bug retests, or usability in preparation for implementation.
• Involved in creating automation test strategy and test plan.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Tested to verify that all data were synchronized after the data is troubleshoot, and used SQL to verify/validate my test cases.
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, Functions, Cross Tab, Master/Detail and Formulas etc
• Reviewed Informatics mappings and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
• The reports that were created in Business Objects were testing by running the SQL statements
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Reviewed the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Involved in preparation of System Test Results after Test case execution.
• Designs, test scripts, for data driven test for Web- based pricing and underwriting system
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.

Environment: Informatica Power Center 8.1, MS SQL Server 2012, QTP, XML, TOAD 9.2, Oracle 9.2, HP Quality Center, Rational Suite, C#, .net, Visual Studio.