Test Cases Sql Server

Prashanth

Email: *****************@*******.***

Contact: +1-815-***-****

QA /SOFTWARE TESTING PROFESSIONAL

Offering around 4 years of experience

Summary:

Having around 3+ years of experience in Manual & Automated testing in different domain with client/server environment, Web based applications and also has worked in Retail, auto industry and Banking industry.

Excellent Knowledge of Database Systems – Oracle database11g, SQL Server and Data ware house concepts.

Developed automated scripts using Selenium Web Driver, Java, and Tasting in Eclipse IDE to perform functional for web based application.

have good knowledge and skills of programming languages like C,C++, .NET, java

Expertise in OLTP/OLAP System Study, Analysis and ER modeling, and Dimensional Modeling (Star schema and Snow flake schema)

Extensive experience in implementation of Data Cleanup procedures, transformations Scripts, Triggers, Stored Procedures and execution of test plans for loading the data successfully into the targets

Experience in automation of test cases using Mercury Tools (Test Director, Win Runner, QTP, Load runner)

Experience in QA methodologies like CMM and RUP

Proficient in different types of testing related to Black Box testing such as integration testing, system testing, stress testing, performance testing, usability testing, acceptance testing, regression testing and beta testing.

Expertise in Problem solving and Tracking Bug Reports using various Bug tracking Tools.

Good knowledge of Quality Assurance Methodologies like Agile, Waterfall, V-Model, Scrum, TDD. Perform duties of software Development Life Cycle (SDLC) and software Testing Life cycle (STLC)

Extensive knowledge in understanding SRS (Software Requirement Specifications) and AVC (Application Use Cases) . Expertise in maintaining requirement traceability metrics, (RTM)

Performed functional and regression testing of web-admin application. Manually performed the integration testing and user acceptance testing.

Extensive experience in automation framework outlining and script coding.

Participated in full life cycle of multiple automation projects from conception to completion - Initiation, Assessment, planning, analysis, design, scripting, execution, reporting and maintenance.

Solid experience in Agile methodologies and Scrum processes.

Plan and execute smoke, functionality, Ad HOC, GUI, browser compatibility, regression tests.

Experience in designing documenting and executing test plans, test harness, test scenarios / scripts and test cases for manual, Automated and Bug tracking tools.

Experience in working Agile Methodology (Scrum) and used JIRA. Extensive in working in glass box, grey box, and black box testing.

Effectively communicated and reported bug / defects, which are identified in different phases of testing. Generated defect reports, bugs validation with tools test director / quality center.

Attended several walk through meeting with the Business Analysis, project manager and developers and provided feedback accordingly. Punctual to provide timely and accurate feedback to management and development teams regarding product quality to achieve scheduled targets.

Effective in executing multiple tasks and Assignments. Dedicated team worker, high in energy work ethics and commitment with capability to handle new technologies and situations.

Technical Skills

Programming Languages

C, C++, VB .Net, C# .Net, perl, Core Java

Web Development skills

HTML, JavaScript, CSS, ASP .Net, JQuery

RDBMS

MS SQL Server (2008/2008R2, 2012, 2014), MS Project, MS Visio, MS Office, Oracle 11g, My SQL

Source Control

TFS

Operating Systems

Windows 2000/NT/XP, Linux, Unix

Defect Tracking Tools

HP ALM,

Business Intelligence Tools

MSBI Suite (SSRS, SSIS and SSAS Multi Dimension & Tabular Model), Cognos 10.x, Informatica 9.x, Tableau 8x and tableau 7x,

Frameworks

Data-driven, Keyword driven, Hybrid, TestNG, Junit

Testing Tools

Selenium IDE, Selenium Web Driver, Cucumber, Soap UI

IDE

Eclipse

Professional Experience

Intelnet Global, pune India September 2013 to April 2015

Automation Engineer

Responsibilities

Reviewed business requirements and technical specification documents and analyzed use cases, functional requirements to create detailed Test Scenarios and Test cases.

Locate web elements with the help of locators: ID, Name, Xpath, CSS Selectors.

Used TestNG framework to run unit test and Maven to build the Project.

Executing and logging and documenting the results.

Documented the issues for future purpose.

Daily status updates, execution status reports.

Escalating the issues on time to Team lead.

Worked on AWD server upgrade and Client upgrade.

Involved in preparation of Regression test suite for AWD.

Record Count and Data Integrity Check Between Source system and Target system

Data Quality Validation - Check for missing data, negatives and consistency. Field-by-Field data verification

Data consistency validation within the Staging tables to check all Mapping Rules / Transformation Rules are followed

Ensures the quality of data in Target from Source with multiple business scenarios.

In-depth knowledge of data warehouse technologies, data testing, and information systems.

Experienced in End to End Testing – testing the flow of data from the source files – Data warehouse – TRecs.

Identified regression test cases and prepared regression suite using selenium web driven Maven, Cucumber.

Scripted the test cases using java (Selenium).

Environment : Oracle Apps R12, Informatica, OBIEE, Infogix, Java and Oracle Database, Quality Center, ETL Testing, Data Warehouse, Autosys, Trecs, Financials Accounting

Gracious Soft Technoliges LLp, pune India March 2012 to july 2013

QA Tester

Responsibilities:

Responsible for analyzing business, functional and IT requirement documents and prepare complete Test Plans, Test Strategy and Supplementary Specification documents.

Integration Testing, UI Testing, UAT Testing & Test case mapping to RTM.

Involved in peer reviews for verification of test cases written by others providing the better product to the customer.

Ensured successful release of the product by creating and executing detailed application integration test case

Clear understanding on project architecture.

Validated the front-end screens – Functionalities: Policy Search, view the data, download the data.

Validated policy data load populated as per Reference tables.

Updated Quality Center accordingly upon the Test Execution and defects/Issues.

Demonstrated Strong listening, presentation, and interpersonal skills. Also very keen attention to detail.

Re-Testing and Regression Testing on the Logged Defects and update the new status.

Created SQL queries for backend testing

As per BR & FR documents created Test Plan, Test Strategy, and Test Cases.

Understood written requirements, including use cases and supplementary specifications to create test cases.

Responsible for UI Testing and functional testing using Black box techniques.

Conducted regular reviews to enhance the test cases

Involved in Run test Plan, Test cases & Test Execution

Interacted with other QA Team members to discuss the issues before reporting them to development.

Reported the defects to the development team in Quality centre.

Maintained Test Logs and Test Summary Reports

Identification of the bugs during testing and reported them using tool HPALM

Experience in relational database, database testing generating reports.

Hands on experience in Jira, SQL Server and Oracle, HP ALM, SharePoint, OneNote.

Document any problems, and work with the project team to resolve problems identified during the tests

Environment: SQL Server, HP-ALM, Java, .net, Windows XP, MS Excel, Outlook, perl, SharePoint and Mainframes

Z3 Technologies Inc. Aug 2016 – February 2016

Automation Engineer(Entry Level Intern)

• Worked with the QA and BA team to write test cases based on the Use Cases.

• Performed Functional, Performance, GUI and UAT Testing.

• Prepared the gap analysis document by analyzing both the requirement specification document and design specification document.

• Created Test Plan, Test Strategy, and Test Cases for complete requirement coverage.

• Performed manual testing to check the functionality of the application.

• Tracked and logged defects and coordinated meetings with developers and business analysts to prioritize the bugs and bug fixes.

• Mapped requirements to Test Cases and Test Cases to Requirements Traceability Matrix.

• Worked closely with development staff to resolve the defects and Testability issues throughout Software Test Life Cycle.

• Attended Change Control Process Meetings to document changes and implemented those changes to corresponding test plans

• Preparing Weekly Status Reports/Daily Status reports

Environment: QC, SQL Server, Outlook, MS Excel, Windows XP, Java, VB and SharePoint

Education

Masters in Computer Science, UCM, Missouri, USA 3.30/4.0 2016

Bachelor of Technology in Computer Science Engineering, NMIT, India 3.58/4.0 2011

Contact this candidate