SUMMARY:

• Over 8 years of experience in the field of Software Quality Assurance and Testing (Manual and Automation) in various Web and Windows based applications.
• Experience in all phases of Software Development Life - Cycle (SDLC),STLC(Software Testing Life Cycle), Bug Life Cycle and software development methodologies, including Waterfall and AGILE methodologies.
• Certified in ISTQB(International Software Testing Qualifications Board).
• Expertise in all phases of Quality Assurance such as Test Plan, Test Strategy,Test Summary Reports, Test Cases, Test Scripts for Manual and Automated testing based on the User Requirements Document and System Requirements Document for the Functional, System, Integration, Regression, GUI, UAT, Security,Database, Smoke/Sanity testing.
• Efficient in creating high level & low level estimation plan, resource planning and on-boarding on time with required skill set.
• Expertise in writing SQL queries using SQL Server, DB2 in validating data into
• Strong working experience in the Data Analysis, Data verification and Validation of an ETL applications using Backend/Database testing.
• Expert on HPQTP Automation using VB Script and Descriptive Programming.
• Experienced in performing Data Driven testing using parameterization in Quick Test Pro, to test the application with different sets of data.
• Proficient in using QTP Scripts with Standard, Text, Bitmap, Table Checkpoints and Synchronization points.
• Experience in using HP ALM(Test Management Tool) and Star Team which is defect Management tool.
• Specialized in testing in both WINDOWS and UNIX environments.
• Full knowledge of testing process with technical understanding.
• Excellent judgment skills in identifying areas of high-risk, critical business areas, early in an application and prioritize my tasks to focus my testing effort when time is limited.
• Possess experience as test analyst in a Software Testing, for comprehensive 3rd party testing of a variety of applications and packages like BWise(Risk Management Tool) and Varicent Application(Reporting Tool).
• A good team player with excellent communication skills where I can communicate and interact well either in email or personally and have an ability to work in a team and individual environment.
• Taking the initiative to coordinate with team leaders to ensure test deliverables were completed of individual test plans.
• Experience in maintaining support documents, QA Sign off documents and maintaining Weekly Status Reports.
• Fast learner, ability to meet deadlines, self-directed and thrive to learn new skills and technology to improve productivity
• Handson experience on Production Defect validation.
• Demonstrated ability to be self-motivated and flexible within a fast-paced environment performing a variety of challenging tasks.

TECHNICAL SKILLS:

Operating Systems: Windows and Unix

Programming Languages: C, Dot Net, HTML

Methodologies: Agile, SDLC, STLC, Waterfall

Testing tools: HP ALM for Traceability of Requirements and Test cases, Quick Test Professional, Selenium

Defect Tracking tools: HP ALM, Star Team for defects logging and Management of defects

Web Browsers: Fire Fox, Google Chrome, Internet Explorer, Mozilla.

Database: DB2,SQL Server Management Studios R2 2008, Squirrel Client

Languages: SQL, PL/SQL, VB Scripting

Tools: and Applications: Excel Macros, PowerPoint, Project SharePoint, DVO tool(to handle transformation logics in database testing), Winscp

Reporting Tools: Varicent Tool, BO Reports

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TEXAS

Senior Quality Engineer

Responsibilities:

• Defined clear specifications and descriptions of functionality from a user perspective for assigned projects and provided estimates of testing effort to ensure sufficient time to test.
• Understanding the Requirements specified by client.
• Involving in the Requirements gathering sessions with the business and providing all the required inputs so that we can overcome the defects which could arise in the later stages due to the discrepancies in the requirements.
• Documentation of Test analysis and environment specifications.
• Preparation of Test Strategy document.
• Preparing Test Cases to cover all the requirements.
• Logical Analysis of the requirements and aid in development activities.
• Tracking the traceability matrix whether all the Test Cases are covered under the Requirements and logging the result in the Quality Center tool.
• Worked in Automation of application using QTP. Developed VB Scripts in QTP which was used later in the regression testing which made work easier as there were many HOT fixes in the Project.
• Collecting the required test data from different Source systems.
• Applying transformation conditions or logics using SQL Queries.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Running the batch jobs in UNIX environment and checking whether the data is properly loaded into the Target units.
• Documentation of the Test results.
• Logging of defects in the “Star Team”, can be assigned to the “Developer” and the same can be viewed by the Development team so that assigned defects can be fixed.
• Fixed defects will be Re-Tested and closed if working fine or Re-Opened, if it is Reproducible.
• Identified, Reported and Tracked Defects using Quality Center test management tool.
• Manually tested,verified and validated that the product meets user requirements.
• Performed Regression and Re-Testing following any updates or bug fixes by the development team.
• Performed Backend Testing to make sure the contents displayed on the UI as per requirements specifications.
• Communicated with developers regularly regarding defect resolution.
• Assisted QA lead in documenting User Acceptance Test reports.
• Used Excel Macros and DVO tool for developing the transformation logics to compare the Source with Target data.
• Involved in UAT Testing along with the business and provided required enhancements to the existing system so that they could be accomplished in future.

Environment: QTP, SQL, PL/SQL, UNIX, SQL Server Management Studio, DB2, Varicent Admin Client for Compensation Calculation & Reporting, HP ALM, Excel Macros, Star Team (Defect Management Tool), Squirrel Client, Beyond Compare, Control-M Enterprise Manager and Control-M Desktop Manager, Selenium, Winscp, DVO Tool

Confidential, Philadelphia, PA

Senior ETL Analyst

Responsibilities:

• Understanding the Requirements specified by client.
• Attended Daily standup meetings. Developed Test Plan and Test cases based on the user stories (Functional requirements)
• Collecting the required test data from different Source systems.
• Running the batch jobs in UNIX environment and checking whether the data is properly loaded into the Target units.
• Involved in Unit Testing so that all the major functionality defects would be identified early hence moving testing to the left.
• PerformedIntegration testing, System Testing to make sure the functionality as a whole is working as expected.
• Worked in Automation of application using QTP. Developed VB Scripts in QTP which was used later in the regression testing which made work easier as there were many HOT fixes in the Project.
• Created custom functions at the module level for verification and validation of objects using check points, standard check points, text check points, text area check points and output checkpoints in QTP.
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
• Wrote complex queries in SQL assistant to check the data from Source and Target.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Performed SQL tuning &debugging of ETL process.
• Documentation of the Test results.
• Logging & Managing the defects in the “Star Team”(Defect Management tool)
• The Fixed defects will be Re-Tested and Closed if it is working fine or will be Re-Opened, if it is Reproducible.
• Conducted Smoke Testing, Integration Testing, Functional Testing, System Testing, Regression Testing and User Acceptance Testing.
• Performed Regression and Re-Testing following any updates or bug fixes by the development team.
• Involved in UAT testing along with business and provided many suggestions to accomplish as future enhancements.
• Responsible for weekly status, attend the bridge meetings showing progress and future testing efforts.
• Communicated with developers regularly regarding defect resolution.

Environment: QTP, SQL, PL/SQL, UNIX, SQL Server Management Studio, DB2, Varicent Admin Client for Compensation Calculation & Reporting, HP ALM, Excel Macros, Star Team, Squirrel Client, Beyond Compare, Control-M Enterprise Manager and Control-M Desktop Manager, Excel Macros, Winscp, DVO Tool.

Confidential, San Jose, CA

AutomationEngineer

Responsibilities:

• Reviewed the Test Basis, designed and documented Test Strategies, Test Plan, Test Cases and executed test cases.
• Preparing the Functional Specification Documents and Test Specification Documents.
• Client Interaction on Design Discussions and test cases discussions.
• Automated all the test scenarios for creation of different kinds of Accounts, doing transactions, back end database testing using QTP Automation tool.
• Created custom functions at the module level for verification and validation of objects using check points, standard check points, text check points, text area check points and output checkpoints in QTP.
• Maintaining all the test cases and scripts in Quality Center, Test Management Tool.
• Automated the scripts to execute all the test cases in Quality Center.
• Conducted Smoke Testing, Integration Testing, Functional Testing, System Testing, Regression Testing and User Acceptance Testing.
• Performed End-to-End testing and responsible for identifying test cases for Automationfor Functional and Regression Testing.
• Updating the regression test specifications
• Preparation of test report for every release
• Communicated with offshore and onshore team to coordinate project status and updates.
• Maintaining Project documents in Common Folder.
• Identified, Reported and Tracked Defects using Star Team defect management tool.
• Managed the testing efforts and created the different metrics for non-functional requirements, which were observed for performance improvements within the application modules
• Provide training to the new team members on domain and testing.

Environment: QTP, SQL, PL/SQL, UNIX, SQL Server Management Studio, DB2, Star Team, Squirrel Client, Beyond Compare, Control-M Enterprise Manager and Control-M Desktop Manager, Excel Macros,STARS and PHASE3 (back-end databases which are used to check whether the Member accounts and the given data is been loaded into database), MAAC tool, Winscp, DVO Tool.

Confidential, Atlanta, GA

Senior Quality Assurance Analyst

Responsibilities:

• Understanding the Requirements specified by client
• Preparing the Functional Specification Documents and Test Specification Documents.
• Client Interaction on Design Discussions and test cases discussions.
• Facilitate the Testing Kick-Off Meetings, and prepare the PowerPoint presentation/Live meeting materials.
• Performed many different testing techniques on the website such as smoke, GUI, black & white box, Positive, negative and regression testing manually on web browsers such as IE, Safari and Fire Fox.
• Created custom functions at the module level for verification and validation of objects using check points, standard check points, text check points, text area check points and output checkpoints in QTP.
• Maintained central repository to determine the readiness of the application by combining Planning, Execution and Defect Tracking.
• Updating the regression test specifications
• Extensively involved inIntegration testing and System testing.
• Worked in Automation of application using QTP. Developed VB Scripts in QTP which was used later in the regression testing which made work easier as there were many HOT fixes in the Project.
• Provide in-depth analysis of test execution metrics and communicate with project teams to understand changes, impacts, discrepancies
• Validate and approve entry/exit criteria forms for System Integration and User Acceptance Testing
• Preparation of test report for every release
• Maintaining Project documents in Common Folder.
• Performed Multi-Browser testing.
• Responsible for weekly status, attend the bridge meetings showing progress and future testing efforts.
• Provide training to the new team members on domain and testing.

Environment: QTP Automation tool, DCT tool, HP ALM (Traceability between Requirements and ), Star Team(Defects Management), Excel Macros, DVO Tool, Selenium, Beyond Compare, Squirrel Client, Winscp, Unix, SQL Server Management Studio.

Confidential

DW-Data Analyst

Responsibilities:

• Analyzing the Requirements specified by client, responsible for creating complete test cases,test plans, test data and reporting status ensuring accurate coverage of requirements and business processes.
• Preparing the Functional Specification Documents and Test Specification Documents.
• Client Interaction on Design Discussions and test cases discussions.
• Modification of test cases based on the requirement changes.
• Developing Automated Test Scripts to perform Functional Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing.
• Created custom functions at the module level for verification and validation of objects using check points, standard check points, text check points, text area check points and output checkpoints in QTP.
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
• Wrote complex queries in SQL assistant to check the data from Source and Target.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Performed SQL tuning &debugging of ETL process.
• Updating the regression test specifications
• Preparation of test report for every release
• Creating traceability relationship between requirements in the same module and also between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Analyzing defects and finding out the root cause for the issues.
• Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner
• Maintaining Project documents in Common Folder.
• Responsible for weekly status, attend the bridge meetings showing progress and future testing efforts.
• Provide training to the new team members on domain and testing.

Environment: QTP, SQL, PL/SQL, UNIX, SQL Server Management Studio, DB2, Star Team, Squirrel Client, Beyond Compare, Control-M Enterprise Manager and Control-M Desktop Manager, Excel Macros, HP ALM, Winscp, DVO Tool.