SUMMARY

• Over 6+ years of diversified experience in Information Technology with emphasis on Quality Assurance, Manual Testing, including Functional, Regression Testing of ETL, Data Warehouse Applications and client/server Applications. Very strong communication and judgment skills, team player, quick adaptability to the ever - changing technology and confidence are my strongest points.
• Experience in analyzing Business requirements, Functional and Technical specifications.
• Expertise in Preparing, reviewing and Executing Test Plans, Test cases and Test Scenarios, Test Reports for both manual and automated tests against technical design specifications and functional requirements documentation
• Have good experience in Integration, Functional, Validation, System and Regression Testing.
• Experience in Manual and Black Box testing of applications on Windows environment.
• Excellent understanding of the Software Development Life Cycle and role of QA.
• Experience in ETL methodology for support data extraction, Transformation and loading in a enterprise level ETL solutions using SSIS.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML).
• Extensive experience in running various kinds of tests such as Regression, Functional, Backend, User Acceptance Test (UAT) for Web and Client/Server Applications.
• Extensive experience in Back-end testing by writing SQL queries.
• Ability to learn quickly and improve the process and procedures of the application.
• Good team player and have ability to work independently.
• Possess excellent communication skills along with verbal and written skills.
• Expertise in Bug Tracking and using Bug Tracking tools like Quality Center.

TECHNICAL SKILLS

Tools: / Misc: Mercury Suite (Quality Center, Quick Test Professional (QTP) Test Director) HP ALM SQL Management Studio

Languages: VB Script, SQL

Operating Systems: Windows, UNIX

Databases: SQL Server, MS Access, MySQL

Reporting Tools: SSRS, Power BI

ETL Tools: SSIS

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL/ETL Tester

Responsibilities:

• Performed Integration, System, User Acceptance, Regression, Performance and Back end testing of an application.
• Performed functional testing, GUI testing, system testing, Integration testing, smoke testing, regression testing, performance testing and User acceptance testing (UAT).
• Involved in developing detailed Test plan, Test cases and Test scripts using QC
• Created and Executed automated test scripts using QTP to perform Functional and Regression testing.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Quality Center to track and report system defects and bug fixes.
• Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Participated in defect review meetings with the team members and developers.
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Involved in testing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using SSIS, T-SQL scripts.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Wrote various complex SQL Queries, joins, stored procedures, functions also created tables for backend testing.
• Performed ETL using Microsoft SSIS, to extract, transform and load test data on the test environment against the database along with performance testing.

Environment: SQL Server SSIS, SSRS,, HP Quality center 10.0MS Excel, XML.

Confidential, Columbus, OH

QA Analyst

Responsibilities:

• Developed, managed and executed functional test cases utilizing business requirements to ensure that the delivered product meets project requirements and handles claim center bug free
• Interacted with Business Analysts to discuss about the requirements and provided feedback to the business analysts
• Extensively involved in Ad-hoc testing, functional testing, high level testing, regression testing and smoke testing after every deployment
• Interacted with Developers to discuss about the requirements/status of the defects
• Tracks test execution results within HP Quality Center
• My responsibilities include defect management, including entering, updating and tracking defects using Quality Center.
• Investigated software bugs and interacted with developers to resolve technical issues.
• Created and Managed traceability matrix for all configuration requirements
• Participated in daily stand up meetings, Product Demo, Sprint planning meetings and Retrospectives.
• Provided estimates and the daily status to the QA lead on the amount of time needed to complete testing related tasks within a sprint.
• Raise an alert when a critical issue is likely to be discussed and report results to QA lead.
• Communicated with development team and project management for the technical issues, bug investigation, new features and enhancement suggestions and for release dead line.
• Performed the Back-End testing to ensure data consistency to the front and back end by writing and executing SQL queries to retrieve data from the database.
• Tested integration points between internal and external systems
• Extensively involved in DWS testing for the whole life cycle of automated and manual checks

Environment: SQL Server, SSIS, MS Excel, .Net, Quality Center 11

Confidential, OH

QA Analyst

Responsibilities:

• Analyzed User Requirements and provided feedback to the Business analyst.
• Developed system test cases and test scripts from business requirement documents using Quality Center.
• Attended test plan review meeting with Business analyst and Developers, ensure that test cases are correct and complete.
• Updating the test cases based on the story cards enhancements
• Responsible for performing Iteration/Functional Testing, System Testing and Parallel Testing for every release.
• Involved in export of the Iteration Test Cases form MS Excel to Quality Center and updating the test results.
• Performed back-end testing by writing SQL Queries directly to the database.
• Performed User Acceptance Testing (UAT) on each release of the project with the help of end user requirements.
• Manually performed Ad-hoc testing, End-to End testing.
• Met with the developers and Business analysts on a daily basis to update the requirements and test documents.
• Logged and tracked results using Quality Center.
• Investigated bugs and interacted with developers to resolve technical issues using Quality Center.
• Participated in defect review and status review meetings.
• Participated in Iteration Planning Meeting (IPM), Business sign off meetings and Weekly Status Meeting.
• Helpthe offshore team with the test data for theIntegration Testing and System Testing.
• Daily stand up meeting with the offshore team to communicate progress on the previous days work, gain commitment on the current day's work, and make visible of any blockers
• Attended daily status meetings with project management on testing update
• Written and executed test cases and verified actual results against expected results.
• Performed Regression testing and interacted with developers to resolve the issues.
• Participate in weekly project review meetings with the offshore team and manage open issues

Environment: .Net, C#, Web Services, Visual Studio, CICS, Quality Center 9.2, Windows XP Professional, Microsoft Office 2007, Quick Test Pro, Visual source safe 6.0, RTC,SSIS