SUMMARY

• Over 8 years of progressive working experience in Software QA and Testing with diverse projects, clients and industry.
• Comprehensive knowledge and experience in all phases of Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile development methodologies.
• Performed planning and development of Test Plans, Test Cases and Test Scenario to meet product’s business requirements.
• Created ETL test data for all ETL mapping rules to test the functionality of the application.
• Expertise in querying and testing RDBMS such as Microsoft SQL Server, Oracle using T - SQL/ SQL for database testing.
• Expertise in Data Warehouse, ETL Verification, BI reports
• Good knowledge on Dimensional Modeling using Star schema and Snow Flake schema for faster, effective query processing.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate-wide-ETL solution usingInformatica 9.0.1/8.6 & SQL Server Integration Services(SSIS 2005,2008,2008R2)
• Experience in TestingBI applicationsusing Tableu, SSRS.
• Implemented Sanity Testing, Smoke Testing, Black Box Testing, GUI Testing, Functionality Testing, Positive and Negative Testing, Stress Testing, Integration Testing, System Testing, User Acceptance Testing (UAT) and Regression Testing of Web Based Applications and Client-Server Applications.
• Extensive experience in gathering, analyzing, and validating business / system requirements.
• Good skills for problem solving and Bug Tracking using Quality Center.
• Expertise in translating user requirements into technical specifications and mapping the process design, work flows for SDLC with documenting and managing business requirements.
• Ability to successfully manage multiple deadlines and multiple projects effectively through a combination of business and technical skills.
• Quick Learner and Excellent team player. Ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS

Testing Tools: Quality Center, Quick Test Professional

Databases: Oracle 10g, SQL Server 2008/12, DB2

ETL Tool: Informatica 9.1/8.x/7.x, SSIS 2005, 2008 R2, Data Stage

Other Tools: Toad, SQL+, DB Visualizer.

Programming Languages: PL/SQL, T-SQL,SQL

Operating Systems: Windows 200/XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Plano TX

Sr QA Engineer

Responsibilities:

• Understanding, Analyzing and Identifying scenarios from the requirement document.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL queries.
• Tested the ETL mappings from Source to Target.
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Responsible for creating test data for validating ETL loads.
• Validating manually ETL loads from source to target ensuring business transformation are applied as expected writing SQL queries.
• Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
• Attending requirement-gathering meetings with Project Manager, Business Analysts, Architecture team and Development team.
• Creating test cases based on Behavior-driven development (BDD) of the application and executed.
• Planning all the testing activities like Test Planning, Test Estimation and scheduling of QA activities, Test Strategy, Test Case Design, Requirements Traceability matrix, Review, execution and Reports.
• Planning and execution of, Functional, Regression, Integration, System, Compatibility, and User Acceptance testing.
• Reporting test results and working closely with project team members on issue resolution and process optimization.
• Participated in daily scrum meetings, requirements/story review meetings, and design reviews and preparing release notes for each sprint.
• Sending highlights to Test Manager and the Scrum master about issues that can or impacting the test phase.
• Tested Reports in SSRS functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.
• Reporting and tracking of the bugs using QC

Environment: MS Excel, XML, Quality Center, ICEDQ, SQL Server, SSIS, SSRS, Ab-initio, AgileScrum.

Confidential, Irving TX

Database Tester

Responsibilities:

• Created test cases based on Behavior-driven development (BDD) of the application and executed.
• Planning all the testing activities like Test Planning, Test Estimation and scheduling of QA activities, Test Strategy, Test Case Design, Requirements Traceability matrix, Review, execution and Reports.
• Planning and execution of, Functional, Regression, Integration, System, Compatibility, Cross Browser and User Acceptance testing.
• Reporting test results and working closely with project team members on issue resolution and process optimization.
• Performed data validation testing by writing SQL queries.
• Responsible for creating test data for validating ETL loads.
• Validating manually ETL loads from source to target ensuring business transformation are applied as expected writing SQL queries
• Reporting and tracking of the bugs using Quality Center.
• Performed for Cross browser testing on different operating systems to verify the compatibility of the application on operating systems like windows 2008, Windows 2012, XP, Vista, Mac to support different Web Browsers like Internet Explorer, Firefox, Chrome

Environment: QC, HTML, Excel, Oracle, Data Stage, SQL Server, Tableau, UNIX.

Confidential, Plano, TX

ETL Tester

Responsibilities:

• Involved in attending Scrum meetings and gather business requirements and coordinate with business analysts and developers to convert Sprints to testable requirements.
• Creation of templates for writing Test Plans, Test Scripts, Test Matrixes and Test Summary Reports
• Analyzed, reviewed Requirements, Design documents, understood system implementation, including process flows, screen layouts.
• Involved in all aspects of Software Development Life Cycle (SDLC) and Work in the agile development environment and participated on standup and retrospective meetings.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Run the modules for System Integration testing and Final Integration Testing
• Used descriptive programming to define the objects that appear in dynamic data frames.
• Performed Automation testing on Web based (Browser) application.
• Wrote SQL queries to set and validate the data.
• Planning on regression testing for needed modules based on the amount of defects.
• Involved in Performance Testing using Load runner and performed Spike, Endurance and Stress Testing.
• Defects were reported, tracked, and reviewed.
• Worked with development and business teams to define requirements and document decisions.
• Involved in Release support - Release to QA, involved in environment setup, testing the release process.
• Wrote Test Cases in Excel based on Technical Specifications, Functional Specifications and Business rules for online application system.
• Involved in creating logical and physical model of the database using Oracle9i.
• Manually tested the whole application before going for the automated testing.
• Involved in testing the conversion of the application into web application using XML web services.
• UAT testing performed along with call center managers to make sure that application meets their requirements.

Environment: XML, Oracle, Toad, UML, MS Office, Quality Center 9.0, Informatica, Agile.

Confidential

QA Engineer

Responsibilities:

• Understanding use cases and Designing manual test cases from use cases and prototype screens.
• Developed test scripts for function, system, regression, end-to-end Testing, and UAT testing.
• Performed positive and negative testing to identify the defects and report them to the business analyst using Quality Center.
• Created test cases to be automated and executed them in QTP.
• Inserted various checkpoints to check web pages, table contents, databases, bitmaps and text.
• Generated daily, weekly and monthly reports.
• Performed Integration testing and build verification testing.
• Executed test cases and documented test results using Quality Center.
• Participated in various meetings and discussed enhancement and modification requests.
• Created a table-driven testing for comparing baseline data with current data.
• Written SQL queries and Database checkpoints to verify data quality.
• Generated different types of reports using Quality Center.

Environment: Quality Center, QTP, XML, SOAP UI, Agile, MS office, Oracle