Post Job Free

Resume

Sign in

Test Cases Sql Server

Location:
Crofton, MD
Posted:
July 27, 2016

Contact this candidate

Resume:

Asadul Bakshi

*** ******* **, *** **, Crofton, MD

E-mail: acvv68@r.postjobfree.com

Phone: 443-***-****

SUMMARY:

Over 6 years of experience in Software Testing.

Experienced in both Manual and Automation testing of web based and client/server applications through the full SDLC.

Expertise in writing Test Scenarios, Test Cases- Functional and Integration Test cases, Reviewing Test cases and Estimating Test cases execution.

Proficient in applying application patch and database patch for every new build.

Experienced with projects through SDLC (Software development life cycle) and STLC (Software testing life cycle).

Strong Knowledge in Back-end, Negative, Positive, GUI, Functional, Regression and User Acceptance Testing.

Good in Maintaining of Test Scripts, Requirements & management of test suites using HP Quality Center/ALM.

Experienced in preparing the Test Execution reports using the HP Quality Center/ALM.

Experienced in logging defects and assigning the criticality of Defects, Root Cause Analysis, and Bug Verification using HP Quality Center/ALM.

Strong in performing backend testing to validate data using SQL queries.

Experienced in monitoring Web Servers and Application Servers and Database Servers such as SQL Server.

Experience on tools like Quick Test Pro/UFT.

Skilled in generating automated test scripts using Quick Test Professional/ UFT.

Experienced in writing programming scripts using VBScript in QTP/UFT.

Experienced in creating Data-driven, Keyword Driven and Hybrid Frameworks for GUI, Regression and System integration automated testing using UFT/QTP.

Experience in using cross browser testing projects to support Internet Explorer, Chrome Firefox, Safari and Opera.

Possess strong technical aptitude with strong analytical, problem solving and communication skills.

Ability to communicate effectively, committed team player, quick learner and rapid problem solver with commitment and a strong work ethic and ability to quickly adapt to new environments.

Excellent organizational skills and the ability to handle multiple assignments concurrently.

PROFESSIONAL EXPERIENCE:

Kaiser Permanente, Silver Spring, MD

Test Automation Engineer

Sep 2014 – Present

Responsibilities:

Involved in the execution of the overall Test strategy, ensuring Test plans aligning with Test strategy.

Involved in designing of Test scripts based on the System requirements from the business Analyst.

Prepare Test Plan and conduct review of Test plan with QA and Development team.

Analyze application to find out which part can be automated and which can be manually tested.

Perform GUI, Functional, Regression, System, Back-end, Negative, Positive, and User Acceptance Testing.

Work with ALM for creating Test Plans, Test Cases, Test Design, Test Inputs, Test Logs, and Test Summary Reports.

Report the bugs, e-mail notifications to the developers using the HP ALM.

Use ALM for defect tracking in different environments.

Write SQL queries for checking the Data Transactions and Database Integrity in both SQL Server and Oracle.

Upgrade of Manual Test scripts into HP ALM for automation using UFT.

Automate Smoke tests, Core-Regression tests and Functional tests by using UFT.

Modify the automate UFT Scripts for regular release screen changes and to support regular functional changes.

Use VB Script to develop a Hybrid Automation Framework in UFT.

Create progress reports to ensure appropriate test coverage and results.

Monitor Batch Run Execution during regression cycles and reported results accordingly.

Document overall framework for the purpose of maintenance and train manual testers who are involved in project to speed up overall testing process.

Generate problem and change reports and ensure the corrective action for these reports operate correctly.

Environment: SQL Server, MS Office, Windows, ALM, UFT, Java, J2EE, Java Script, VB Script, XML, UNIX.

Walgreens, Chicago, IL

QA Engineer

May 2012 – Aug 2014

Responsibilities:

Participated in the System Test Plan reviews, Test Scenarios, and Test Cases Review.

Involved in gathering the relevant Test data necessary for the Test cases, based on the Business Analysis, Requirement specs, Business process Procedures, Scenarios, Transactions and Test Conditions.

Configured Test environment for specific Test cases, created Test data.

Created scenarios and performed scenario based testing.

Designed, updated and reviewed Test Cases.

Created Test scripts for the Test Execution and Documented the Reports using HP Quality Center.

Ensured the actual results match expected results using Quality center.

Logged the defects in HP Quality Center and created Test Metrics to analyze the defects.

Responsible for documenting application related errors in Quality Center.

Wrote complex SQL queries to perform the Backend testing of the Database.

Responsible for triggering and monitoring weekly batch processes using QTP.

Used QTP for Regression testing and used script according to the functionality.

Involved in capturing, inserting verification points, verifying and replying user interactions automatically to identify defects using QTP.

Used Regular expressions in QTP using VB Script programming.

Created several Test scripts using QTP to create Batch tests and performed Exception handling.

Identified all windows, Pages, Objects, Methods and Properties and created Custom code Script with Parameterization, programming logic and data driven types using VB Script in QTP.

Performed User Acceptance Testing for the entire application.

Involved in Metrics collection for Iterations and Updated Release Notes.

Worked on testing status, reporting to the higher management and retesting the fixes.

Environment: HP Quality Center, QTP, VBScript, Java, Java Script, MS SQL Server, Web Services, Windows, UNIX.

Bank of America, Wilmington, DE

Software Tester

Jan 2010 – Apr 2012

Responsibilities:

Involved in working with Business Analysts, Programmers and Business users through the life cycle of the project.

Prepared Test estimation and Test metrics documents using MS Excel.

Involved in developing and executing comprehensive system Test plans and scripts, and facilitating testing across multiple departments.

Created manual Test cases and Test suites for different modules of the application.

Worked with the development team to create a suite of test data including both input files and expected results that fully exercise data validation.

Prepared and updated scripts using Quality Center.

Wrote the Test cases in Quality Center.

Involved in writing SQL Queries to check Data integrity.

Generated test scripts for Functional and Regression tests using QTP.

Designed and Generated Reusable Functions using VB Scripts in QTP.

Created Test scripts using QTP to create Data Driven Tests, Batch tests and performed Exception handling.

Generated Quick Test Pro master scripts and called different functions and checked for different properties for the recorded objects.

Introduced Synchronization functions, wait functions in the scripts using QTP.

Involved in testing configuration and customization like fields, page layouts, users, role hierarchy.

Responsible for designing and developing mockups for User Interface and prototype testing.

Attended weekly meetings on project status.

Environment: TOAD, Oracle, SQL Server, Windows, Quality Center, QTP, Java, Java Script, HTML, Agile, MS Office, UNIX.

EDUCATION:

M.S.S., Public Administration, University of Dhaka, Dhaka, Bangladesh

TECHNICAL SKILLS:

Testing Tools:

HP ALM, UFT, HP Quality Center, HP Quick Test Pro

Data Base:

DB2, Oracle, SQL Server, MYSQL

Operating System:

Windows

References available upon request



Contact this candidate