SUMMARY:

• Pursuing an opportunity in a challenging environment where I can effectively contribute my skills as a QA Test Analyst to synchronize my personal growth with that of my organization.
• Software ETL/QA Test analyst with 7+ years of experience in manual testing on web based and Data warehousing applications.
• Comprehensive knowledge of Software Development Life Cycle (SDLC) and Software Testing life cycle (STLC).
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in SQL queries to validate data. Used TOAD to execute SQL queries.
• Experience in Agile and Waterfall environments.
• Developed and executed Release Management in Agile environment
• Experienced in using various defect tracking tools like HP Quality Centre (ALM - Application Life Cycle Management)
• Experience in complete defect life cycle, Requirement traceability matrix (RTM)
• Monitoring Status of defects, performing "Root Cause Analysis"
• Expertise in Defect Tracking and Reporting.
• Worked with HP UFT in automating regression test cases and HP Load Runner for performance testing.
• Service testing experience with SoapUI tool.
• Validated Source and Target database in ETL process.
• Working experience in Mobile application testing
• Worked in Banking / Finance and Healthcare projects.
• Experience in Development and Implementation of Use Cases, Test Strategy, Test Designs, Test Scripts, Test Data and Test Cases.
• Experience in design and executing test cases.
• Experienced in regression testing, data driven testing, UAT (User acceptance testing), Integration testing, Unit Testing, Smoke testing, Functional testing etc.
• Experience in UNIX / Linux, FTP (file transfer protocol), Executing shell scripts.
• Proficient skills in testing mobile (IOS, Android, Windows), desktop (Windows, Mac) and Web-Based apps, With Analytical Thinking, Attention to Detail, Problem-Solving Skills, Proactive, Self-Motivated, Willingness to Learn New Technologies qualities.

PROFESSIONAL EXPERIENCE:

QA-ETL Tester

Confidential, Greensboro, NC

Roles & Responsibilities:

• Worked in an agile environment, attended SCRUM meetings and daily stand up meetings.
• Worked with Business Analyst and Project manager, technical architects and developers and Team lead to review the business requirements.
• Designed, executed and developed the Test plan, and test case strategies.
• Involved in ETL process testing using Informatica ETL tool.
• Written Requirement traceability matrix (RTM), status reports on test cases and defects.
• Implemented Test Driven Development (TDD) as a development technique.
• Executed SQL queries and joins using TOAD to validate the data.
• Tested Web Services (SOAP and Restful services), Validated XML request and response using SOAPUI tool.
• Found defects and worked with developers to resolve the defects.
• Worked on Linux environment to execute the shell scripts, to stop and start the application servers. FTP the log files from Linux to windows and emailed to developers to debug the issue.
• Tested the mobile version of POS application with HP UFT.
• Validated source and target database in ETL process to validate the reports.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Validated the web reports by executing SQL queries and joins in TOAD tool.
• Managed test case, defects and reports in HP Quality Center (ALM).
• Experienced in User acceptance testing (UAT)

Environment: Informatica Power center Designer 8.6.1, XML, Web Services (SOAP, Restful), SOAPUI tool, HP UFT, HP Quality Center, Microsoft Word, Excel, PowerPoint, Oracle Database, TOAD, Putty, Mobile testing tools.

QA-ETL Tester

Confidential, Raleigh, NC

Roles & Responsibilities:

• Reviewed all the application documents and created test plan.
• Analyzed application data using the SQL to identify the ETL processes
• Created test cases to perform Functional and Regression Testing.
• Performed manual testing using the test cases developed and reported to developers using Quality Center.
• Used QTP for Automation of Functional and Regression Testing Throughout the project life cycle.
• Wrote user defined functions in Quick Test Pro.
• Performed extensive database testing to verify the results generated by the batch applications.
• Wrote many SQL queries using SQL query analyser to query the data base tables for correct entries.
• Tested ETL batch processes using UNIX shell scripting.
• Creating test cases for ETL mappings and design documents for production support
• Used Quality Center to prepare Test cases, procedures and Requirements Traceability Matrix (RTMS).
• Performed Web testing, database testing, GUI testing, end to end testing, production assurance, System testing, functionality, Regression and User Acceptance testing (UAT) as a part of different quality activities such as bug tracking and control.
• Experienced in DB application testing by using SQL.
• Worked on SDLC methodology for testing Insurance application.
• Involved in converting Manual Test Cases into Automated Test Scripts by using Mercury Quick Test Pro (QTP).
• Involved in Execution of UAT Test Cases.

Environment: XML, QTP, Informatica power center. Quality Center, Microsoft Office, VB Script, MS Access, Oracle, MS Word, Excel, HTML, UNIX, SQL.

QA Tester- ETL

Confidential, Raleigh, NC.

Roles & Responsibilities:

• Performed Functional, GUI testing and Involved in Regression testing on each build during the various phases of the application.
• Developed and implemented test cases under the guidelines of senior ETL tester
• Application Development and Testing followed agile methodology with 4 weeks Sprint Cycle.
• Responsible for conducting Weekly Automation Status meetings, Monthly check Points, Defect Triage Meetings and representing QA in Weekly Project Status meetings, Bi-weekly Portfolio Meetings.
• Created the detailed test plan and test cases from the User Stories that are selected for implementing in the Current Sprint.
• Tested ETL mappings, mapplets and reusable transformations for daily data loads.
• Conducted and participated in meetings with business analyst as part of Daily Stands ups for requirements clarifications and with Development team for Issues/Defect Discussions. Identified Re-usable/Repeatable manual test cases for creating Regression Test Suite.
• Managed Requirements, Test plan, Test cases and Test automation scripts using HP Quality Center to facilitate Traceability.
• Developed and executed Test scripts Using QTP10.0.
• Developed automated test scripts using VB Scripts to perform Functional and Regression Testing.
• Created Data Driven and parameterized automated test scripts using QTP Actions and VB Script functions and worked with Check Points.
• Took the ownership for maintaining the QTP Object Repository.
• Created and executed SQL queries to fetch data from SQL developer database to validate and compare expected results with those actually obtained.
• Report and Track defects using Bugzilla.
• Coordinated with the developers for code walkthrough and inspection for static testing.
• Involved in various agile meetings and Demos as part of Agile Approach Includes Iteration planning meeting, Daily Scrum Meetings, End of Iteration meeting, Iteration Retrospective meetings and End of Iterations Demo.

Environment: Quick Test Professional11.0, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), Quality Center10.0, Agile (SCRUM), SQL developer, MSOffice, PL/SQL developer, SQLServer2008, Windows XP/Vista, Bugzilla2.1

Confidential

QA Test Analyst

Roles & Responsibilities:

• Participated in meetings with business, developers and testers for Requirements analysis, Business analysis, Use-Case analysis and Gap analysis.
• Created test plans, test requirements, test cases and involved in test execution, test report generation and defect tracking.
• Coordinated Onshore and Offshore test resources through the entire project life cycle.
• Wrote detailed procedures for performing comprehensive tests.
• Investigated the nature and probable cause of bugs. Entered clear description of bugs into HP Quality Center. Followed through to resolution. Tracked bugs, reported trends, and made recommendations for meeting completion dates.
• Used Quality Center as Test Management tool to enter requirements, test cases and test sets.
• Used Quality Center to run Manual, Automated (QTP and Load Runner) scripts. Also used Quality Center to create and track Defects.
• Organized defect review meetings with the team members and identified functionality gaps, designed and implemented custom reports
• Created automation scripts using QTP to verify the on-screen values and images, compare insurance policy pages and reports.
• Created performance scripts using HP Load Runner to check Server Utilization, Memory Utilization, Throughput and Average Hits/Sec.
• Used Microsoft Visual Source Safe (VSS) to control the version of test documents and test scripts.
• Responsible for setting up Test Environment which includes software and hardware setup.
• Responsible for overseeing the Quality procedures related to the project.

Environment: JAVA/J2EE, VB Script, HTML, XML, QTP, Quality Center, Load Runner, Oracle 10g, MS VSS, Windows XP

Confidential

QA Tester

Roles & Responsibilities:

• Involved in writing test scenarios and test cases for manual testing
• Created and executed Functional and System Test cases manually
• Performed GUI, Functionality, Regression Testing
• Identified Test scenarios and performed Functional Testing on Launcher and GDE
• Bug Reporting or Defect tracking using Quality Center
• Understanding SUT, performed Ad-hoc testing before doing the formal testing and documented the defects
• Written and executed the functional and regression tests
• Actively involved in the daily testing status meeting in which the defects identified were discussed
• Performed regression testing, identified software errors and interacted with developers to resolve technical issues
• Provided the management with Test Metrics, reports, timelines and schedules as necessary and participated in the design walkthroughs and meetings
• Analysed test results from a technical standpoint and isolate defects prior to escalating to the development team for resolution
• Track test coverage and other metrics contribute to the continuous advancement of current QA processes and maintain repeatable processes
• Work closely with the development team to develop automated and manual testing strategies
• Reports significant defects and tracks all defects and project issues

Environment: Windows XP, MS Excel, MS Word, Quality Center, .Net, Manual Testing

Confidential

QA Analyst intern

Roles & Responsibilities:

• Created the detailed test plan and test cases from the business requirements documents and meetings.
• Involved in test script development, test execution, test analysis, defect tracking.
• Executing test cases manually and reporting the results using QC
• Performed Black Box Testing by executing test cases manually and using QTP.
• Conducted User Acceptance Test (UAT) with users and Customers and wrote Issues log.
• Used Quality Center as a Test Management Tool for systematic control over the testing process.
• Used Quick Test Professional for best solution for regression test execution.
• Created queries to test the backend functionality of the application.
• Performed Positive & Negative testing for system validation.
• Found Defects and interacted with developers to resolve technical issues using Quality Center.
• Responsible for performing Regression testing on the Application for checking validity of functionality in different versions of the application using Quick Test Pro
• Provided feedback to the developers and the QA team on top priority issues.

Environment: Quick test professional 9.0, Quality Center, .Net, SQL, Windows XP, MS Office, XML, HTML.

TECHNICAL SKILLS:

Testing Tools: HP Quality centre (QC), ALM, HP UFT, HP Load Runner, Jira, Toad

Web Services: SOAP, Restful, Soap UI Tool, XML

Operating Systems: UNIX / Linux, Windows OS

Microsoft Tools: MS Word, Excel, PowerPoint, MS Access

Languages: Java, JSP, HTML

Database: Oracle, MS SQL, MS Access, IBM DB2

ETL Tools: Informatica Power Center 8/7.1.2.