Post Job Free

Resume

Sign in

Test Cases Sql Server

Location:
Manassas, VA
Posted:
July 31, 2017

Contact this candidate

Resume:

Jahanara Buiyan

**** ********* **, ********, ** *0111

E-mail: ac1k07@r.postjobfree.com

Phone: 571-***-****

US Citizen with public trust security clearance

Summary:

11+ years of experience in Testing, Systems Analysis and Automation & Test Framework Design & Development for various Client/Server based Mobile/Internet/Intranet Applications.

Experience with TFS (Team Foundation Server) & (Microsoft Test Manager).

Expertise in Entire Software Development Life Cycle and Test Development Life Cycle.

Exposure to all stages of Software Development Life Cycle (SDLC).

Well versed with V Model, Agile and Scrum models.

Extensively experienced in test design, test development and implementation of test procedures in manual and automation testing.

Experienced writing Test suite using Selenium.

Experienced using web debugging tool like Fire Path and Firebug for finding elements locator.

Proficient writing test suite using Selenium IDE and WebDriver.

Used Java and JUnit test framework to write functional test.

Documented and Implemented Structured QA Methodologies.

Extensively experienced in the field of Software Quality Assurance and Application Testing.

Experienced in Ad-Hoc Testing, Smoke Testing, Functional, Regression, Integration, User Acceptance and Back end Testing.

Well experienced in Web testing, UNIX & DB testing.

Well Experienced in Mainframe Testing.

Experienced in using HP Testing Tools; like ALM/Quality Center, QTP & TestDirector.

Experienced in Black Box, Grey Box testing with a complete QA Life cycle- through Development, Analysis, testing, Defect logging, and verification of fixed bugs.

Proficient in using Bug tracking tools like ALM, Quality Center, TestDirector and Jira.

Experienced in preparing Requirements Traceability Metrics (RTM), Software Metrics, Defect Report, and Weekly Status Reports using HP ALM/ Quality Center.

Experienced in writing SQL queries for Back end testing.

Experienced in using PL/SQL for querying Oracle databases.

Expertise in automating test cases with QTP using VB scripts.

Experienced in developing automated test scripts using QTP, enhancing the scripts inserting checkpoints, parameters, synchronized the scripts and saving the same for regression testing.

Created and maintained high-end object repository for various functional and regression test using QuickTest Professional.

Experienced in using Regular Expression in QTP Scripts.

Experienced in executing, maintaining Test Scripts and Updated when the business rules change using QTP.

Experienced in developing a Keyword Driven Automation Framework in QTP.

Experienced on working with XML/SOAP UI (web services).

Experienced in developing and executing automation Regression testing and System testing using Selenium.

Experienced in performing Data driven testing to validate the components displayed on the website using Selenium.

Highly analytical in developing the methods and measures to meet requirements and solve any issues that arise during the project.

Possesses excellent communication, documentation and organization skills with the ability to adapt to a new environment & meet stringent deadlines.

Education:

Bachelor’s in Science from Chittagong University, Bangladesh in 1997.

Cisco Certified Network Associate (CCNA)

Microsoft Certified System Engineer (MCSE)

Microsoft Certified Professional in Internet Systems (MCP+I)

A+ Certified Computer Service Technician

Technical Acumen:

Testing Tools VersionOne,ALM, Quality Center, UFT, Selenium, QTP, TestDirector, SOAP UI,

Languages C/C++, SQL, PL/SQL, VB, Java, .Net, HTML, Java Script, XML

Databases SQL Server, Oracle, DB2

Operating Systems Windows, SUN Solaris, Linux

Web/App servers IIS, Apache, WebSphere, WebLogic

Professional Experience:

FEMA - DHS project, Mount weather, VA Dec 2016 to Present

IV & V Senior Test Engineer

Responsibilities:

Involved in working on Agile environment.

Involved in developing Test plans, designed Test cases including detailed expected results.

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.

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

Used ALM to manage and analyze stories & project wall.

Worked with development teams to investigate and correct software bugs and deficiencies based on testing results using ALM.

Involved in defect tracking using ALM.

Performed Data Validation using SQL, Defect Resolution and Maintenance.

Wrote SQL queries to perform back end testing.

Created and maintained Environmental variables using UFT.

Wrote VB Script, developed Custom Functions, Dictionary Objects, and Descriptive Programming by using UFT.

Used Regular expressions in UFT using VB Script programming.

Responsible for testing new features and performing regression testing using UFT..

Performed User acceptance testing for the entire application.

Used to coordinate with development team for Bug fix issues.

Recorded the deviations found during the development cycle and communicated to the client counterparts.

Responsible for tracking the defect ownership through the SDLC phases.

Provided training to other employees on testing best automation practices.

Environment: HP ALM, UFT, MTM, Oracle, SQL Server, HTML, XML, Windows, MS Office, MS Excel, UNIX/Linux, VBScript, Microsoft Visual Studio

CODIS - FBI project, Fairfax, VA Apr 2016 to Dec 2016

QA specialist

Responsibilities:

Involved in working on Agile environment.

Involved in developing Test plans, designed Test cases including detailed expected results.

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.

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

Used ALM to manage and analyze stories & project wall.

Worked with development teams to investigate and correct software bugs and deficiencies based on testing results using ALM.

Involved in defect tracking using ALM.

Performed Data Validation using SQL, Defect Resolution and Maintenance.

Wrote SQL queries to perform back end testing.

Created and maintained Environmental variables using UFT.

Wrote VB Script, developed Custom Functions, Dictionary Objects, and Descriptive Programming by using UFT.

Used Regular expressions in UFT using VB Script programming.

Responsible for testing new features and performing regression testing using UFT.

Used TFS to deploy new build to Client and Server and test.

Performed User acceptance testing for the entire application.

Used to coordinate with development team for Bug fix issues.

Recorded the deviations found during the development cycle and communicated to the client counterparts.

Responsible for tracking the defect ownership through the SDLC phases.

Provided training to other employees on testing best automation practices.

Environment: HP ALM, UFT, TFS, MTM, Oracle, SQL Server, HTML, XML, Windows, MS Office, MS Excel, UNIX/Linux, VBScript, Microsoft Visual Studio

.

HP, Herndon, VA - USPS Project Aug 2014 to Mar 2016

QA Analyst/Business Analyst/ Scrum Master

Responsibilities:

Analyzed Business, Functional Requirements, and Design Review Documents to develop Test Plan for projects involved and wrote Test Scripts.

Conducted End-to-End, Manual testing of the system and prepared and managed test cases using VersionOne.

Used VersionOne to track, report, and manage defect throughout the test cycle and attended Defect Status Meeting on daily basis during testing cycle.

Involved in data mapping of the project requirements, queried the database using SQL queries for data mining, data analysis and data modeling.

Extracted data from different department to flat files and load the data to the target Oracle and SQL server database.

Used complex SQL Quires to perform back-end data base testing.

Worked with XML/SOAP UI (web services).

Extensively used Groovy scripting for Soap UI frame works in API testing.

Implemented cross browser and cross platform web testing with Selenium RC and WebDriver.

Used Selenium to expand test scenarios to catch more bugs and improve quality.

Designed and developed automated scripts for functional, regression, sanity, and integration testing using Selenium.

Developed the test scripts and analyzed the results in various stages of the application including integration, regression, functional and acceptance testing using Selenium.

Identified the defects through Selenium and ensured that business processes deliver the expected results and remain reliable throughout the production release.

Generated Weekly Reports, Defect Reports and Customized Summary Reports.

Participated in various meetings and discussed Enhancements and Modification Request issues.

Customer Support: Tier II Support (Help Desk), Requirements Analysis,Story Development, Acceptance Criteria Development,

TSLC Documentation: Creation of new TSLC, TSLC CCB, TSLC RTM, TSLC Technical Analysis, TSLC Submission, SOX Documentation, SOX timeline awareness.

Agile Processes: Daily Standup, Weekly backlog grooming, VersionOne Tracking

Environment: VersionOne, Selenium IDE and Webdriver, 508 testing tool - Natural Reader, Soup UI, Mobile testing -mPOSE devise, SQL developer, Putty, Windows, UNIX.

Department of Justice, Washington, D.C Oct 2013 – Aug 2014

QA Analyst

Responsibilities:

Extensively used ALM for scheduling test and defect tracking.

Reported defects using ALM and interacted with the development team to resolve any defects/issues.

Managed Requirements, Test Plans, and Test Cases using ALM.

Convert QTP scripts to Selenium Script.

Create test scripts through selenium IDE and Convert to WebDriver.

Regression test cases were written and automated using Selenium IDE and WebDriver.

Update existing Selenium Scripts, if it fails or requirement changes.

Inspect web elements through Firebug and Firepath.

Worked with source version control tool such as Subversion (SVN).

Performed Positive and Negative Testing using Data driven tests.

Designed and implemented SQL queries for QA testing and report / data validation.

Performed Integration, Regression, Functional and Database testing.

Assisted with user-acceptance testing and defect tracking for release.

Tested extensive backend testing using SQL Queries to retrieve the data from the database and checked data integrity.

After completion of Final Regression cycles, concentrated on User Accepting testing (UAT) to correct feedback in two types of approaches such as Alpha Testing and Beta Testing.

Used Descriptive Programming using QTP.

Assured software meets all the requirements and expectations of final UAT test.

Prepared status summary reports with details of executed, passed and failed test cases.

Responsible for updating and maintaining ALM for all the defects found during functional and regression testing and follow up the bug life cycle.

Worked closely with the QA Manager and QA Lead to discuss/decide major activities, scopes and milestones in the QA life cycle.

Prepared Requirements Traceability Matrix.

Organized weekly Project status and Task Review meetings.

Environment: ALM, Clear Case, Quick Test Professional, Selenium IDE, Selenium Web Driver, JUnit, Firepath, Firebug, SVN, Oracle, XML Linux, Web server, XML, Java, Java Script

Micron-Godwin DR, Manassas, VA Dec 2011 – Sep 2013

Quality Assurance Analyst (Automation)

Responsibilities:

Gathered requirements with Customers and business analysts, to make sure the testing covers all different scenarios of testing.

Involved in creating Test plans, for different components within the project.

Created Test runs, Test cases, Mockups, Process Flow diagrams from the functional documents.

Created RTM Matrix, ensured the Test Planning, Testing Strategy, Test cases, Flows are capturing and covering all the Functional/Non Functional requirements.

Worked with the development team in creating environment and loading and migrating data.

Performed various kinds of testing, such as Exploratory, Smoke box, Regression, Integrated, System, Backend validation, End to End, UAT.

Used ALM/Quality Center for Test Planning, Test Case writing, Test Execution and Requirement Mapping with Test Cases.

Created Test Cases and scenarios for Defect tracking and reporting using ALM/Quality Center.

Logged new bugs; tracked and updated the status of previously filed bugs. Prioritized and retested the bugs in HP ALM/ Quality Center; Participated in the daily bug meeting.

Performed Back-end data base testing using SQL quires.

Created Regression suite for various test scenarios. Tested and executed the suite whenever a code was changed using QuickTest Professional (QTP).

Designed and involved in creating new architecture design using class methods to implement QTP scripts.

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

Generated QuickTest Pro master scripts and called different functions and checked for different properties for the recorded objects. Introduced synchronization functions, Wait functions in the scripts.

Developed Descriptive Programming and Maintained Local and Global Object Repository in QTP.

Developed a Keyword Driven Automation Framework in QTP.

Wrote basic commands in UNIX to start/stop services, copying and reading log files.

Uncovered defects and followed-up with development team and customers.

Environment: QTP, Quality Center, SOAP UI, MS Office, Oracle, MS-SQL Server, Java, UNIX and Windows.

Kaiser Permanente, Silver Spring, MD Mar 2009 – Nov 2011

Quality Assurance Engineer

Responsibilities:

Involved in gathering requirement and discussed with Development team to understand and analyze the Product Requirements thoroughly.

Involved in preparing Test Plan and conducted review of test plan with QA and Development team.

Designed Test Cases/Test scripts based on the System requirements from the business analyst.

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

Implemented HP Quality Center for Test Planning, Test Case writing, Test Execution and Requirement Mapping with Test Cases.

Performed defect tracking and reporting using Quality Center.

Used Quality Center to communicate and coordinate software bug fixes, change requests, and supports high level of communication among the testers, developers and managers

Performed white box testing on developer’s SQL code and wrote SQL verification scripts to test the result of deployment for correct business logic.

Performed Back end testing using SQL Quires.

Conducted GUI and Black Box Testing using QTP and interacted with developers to resolve issues.

Used QTP for automating manual test cases for Regression testing and for storing, execution of test cases and reporting results.

Developed Function libraries, Shared repository, Descriptive programming, Recovery scenarios using QTP.

Performed Data validation using QTP.

Developed both Data driven and Keyword driven Frameworks to automate the testing process of impotent modules.

Designed reports for communicating analysis of test data and metrics, and communicate the results to project team.

Interacted with the Business Users for User acceptance testing.

Verified readiness of the product for release through release review.

Environment: Quality Center, QTP, MS Office, SQL Server, Oracle, Windows, UNIX.

Export-Import Bank of the US, Washington, D.C Mar 2007 – Feb 2009

Test Engineer

Responsibilities:

Involved in creating project plan, test plans, estimations, and development and tracking projects.

Performed GUI, Functionality, System, Integration, Regression, UAT, Data Base, Ad-hoc testing.

Conducted End to End and Black box testing.

Documented the Test Cases using MS-Excel.

Involved in developing Activity Diagrams and sequence Diagrams for the same to formulate the end user interface navigation.

Coordinated with Project Team for test data, setting up test environment, backend interfaces and test data maintenance.

Developed the test scenarios from the product stories and created test cases for them and uploading them in TestDirector.

Managed Test activities by executing the test cases using TestDirector.

Reported bugs using TestDirector and worked closely with development team for the closure of these bugs before release.

Involved in Back end testing by using SQL Quires.

Performed functional regression testing using QTP.

Gave demo of the working product at the end of the first sprint to development team, product owners and customers.

Participated in the sprint retrospective meetings with onshore and offshore resources.

Assisted Test Engineers to interpret, and summarize the results of the analysis.

Participated in Reviews /Inspections with Business Users and Research Team.

Environment: QTP, TestDirector, MS Office, Visio, MS-SQL Server, Oracle, Java, Java Script, J2EE, .Net, C#, VB, and Windows.

References available upon request



Contact this candidate