Post Job Free

Resume

Sign in

Test Cases Sql Server

Location:
Ashburn, VA
Posted:
February 12, 2016

Contact this candidate

Resume:

Profile

*+ years of IT experience in manual and automation testing, good experience in large scale Web based applications and Windows applications.

Expertise in Black box Testing, Functional & Regression Testing, Database Testing, GUI Testing, Integration and System Testing & End to End Product Testing. Gained exposure in Defect tracking, verifying & validating user requirements.

Experience in using test management and defect tracking tools like Microsoft Test Management (MTM), Redmine, JIRA

Experience in e-commerce, Financial,Food and Banking Domains

Ability to write SQL queries

Hand of experience in Product Studio & VSTF

Experience on reviewing Test requirements to ensure accuracy and completeness prior to software development.

Experience in framing Test Conditions, writing Test Cases, Test Scenarios and executing test sets.

Experience on preparing Defect Reports, Test Summary and Test Reports, Tracking Defects and Validation of Defects.

Experience on different operating systems like Win2000/2003/XP/Vista/Win 7/Win8 and Mac : OS X Mavericks, OS X Yosemite,OS X EI Capitan

Ability to meet deadlines and handle pressure coordinating multiple tasks in the project environment.

Experience on programming and scripting languages such as C, T-SQL, SQL Server 2008, SQL Server Management Studio

Can do Adobe Photoshop

Experience testing banner ads

Experience testing promotional emails using litmus

Skilled in cultivating positive relationships with clients, colleagues and project teams

Good Team player with a strong work ethic and committed to hard work.

Skill Set

Operating Systems

Windows XP/2000, Win 8,Windows Vista, UNIX, Linux, OS X Mavericks, OS X Yosemite

RDBMS:

Browsers:

Test Automation:

Testing Tools:

Oracle, MySQL, MS SQL Server

Internet Explorer, Firefox, Chrome, Safari, Opera,Edge

Selenium, QTP, LoadRunner, JUnit, nUnit, SilkTest, Eclipse,Quality Center

JIRA, VSTS and Redmine

Virtualization

VMware Server, Virtual Box

Education:

B.Tech - JNTU Hyderabad India. – May 2008

Masters - SIUC Carbondale IL USA – Dec 2009

Professional Experience:

The Tombras Group, Knoxville, USA

June 2013 to Current

Responsibilities:

Cross browser and UI testing using Selenium Web Driver.

Developed selenium web driver scripts to work with IE8, IE9, IE10, IE11, Chrome, Firefox and Safari.

Email testing using litmus.

QA of banner ads using adobe flash player.

Cross browser tested HTML Banner Ads.

Experience using browser stack tool for cross browser testing.

Responsible for writing test cases.

Reporting and tracking defects.

Participate in status meetings.

Follow the Agile Testing Methodology, which involves direct interaction with developers.

I have been able to work for clients such as Farm Bureau Insurance, Med Hospital, McDonalds, Food city, Country Music Hall of Fame, Nashville EPB, ESPN, Metropolitan Bank, NHTSA,Michelin.

Testing Java web application projects.

Experience in using Redmine, JIRA for reporting defects.

Accenture Services Ltd.

Client -Microsoft Corporation, HYD, INDIA

Referral Tracking System

Aug 2011 to Nov 2012

Responsibilities:

Developed detailed Testing Strategy for the entire application, provides ROM estimate and developed test plans and test cases based on technical specifications and Requirements.

Actively participated in all phases of testing life cycle including document reviews, inspections, and project status meetings

Prepared complete Test Result Reports (TRR) in the MS-Word format for each build of the application.

Assisted automation teams in developing automation frame work, QTP test scripts and Identified Test Procedures that need to be automated during the regression testing.

Automated test cases for regression testing using QTP Automation tool.

Developed test harness by writing reusable functions in QTP.

Used Object repository for capturing objects and worked with different verification points like GUI checkpoints, Bitmap checkpoints and Synchronization points using QTP.

Executed Test Cases for batch programs. This testing involved running the shell scripts and executables at the command line and involved in UNIT testing.

Used Telnet command to login remote UNIX boxes and FTP command to upload/download the files to/from UNIX boxes.

Experience in testing of WCM (web content management) and responsible for creation of new contents and manage website contents.

Extensively used SQL and wrote complex SQL Queries for manual backend testing.

Write SQL queries to access the data in the mainframe DB2 database to execute back-end testing.

Used Embarcadero DB Artisan interface to write the SQL Scripts and queries to check the contents of the rows and constraints of the tables.

Use Quality Center as defect tracking system, including submitting and assigning defects to the application developers along with the release of defect aging reports.

Participated in weekly status meeting, coordinated with the developers and testers to resolve the defects and close them.

Accenture Services Ltd

Client-Microsoft Corporation, HYD, INDIA

Order Management

Jul 2010 to Jul 2011

Responsibilities:

Preparation of Detailed Test Plan, SFTD (Scenario Focused Test Design).

Managed all the phases of STLC, such as Test Conditions, Test Case Walkthroughs, Peer Reviews & Signoffs meetings individually

Prepare / review Test scenarios, Test cases Keep timely communication with Program Manager about any obstacles/issues faced that might hamper schedule or reduce scope of work.

Collaborated with Development for the release management activities and received builds as planned

Instrumental in Checking the Environment readiness and raised alarms as appropriate

Identifying gaps and coming out with Ramp up/KT plan

Review and validate each of the test artifacts.

Ensure all test cases are executed and Test Management tool is duly updated.

Metrics analysis and status reporting

Ensure to keep track of all items in PS/VSTS. (Bugs, test cases and assigned tasks)

Working on automation road path

Bug Reporting and Daily and weekly status reporting

Worked on Backend Database Testing using SQL Profilers, Services, Jobs, Store Procedures, Joins & Tables executing the Test Scripts, and analyzing the test results

Ensure to run all the automation scripts and analyze the test results

Good Team player with a strong work ethic and committed to hard work

Ability to meet deadlines and handle pressure coordinating multiple tasks in the project environment.

Skilled in cultivating positive relationships with clients, colleagues and project teams.

Southern Illinois University, Carbondale, USA ^BACK TO TOP

Research Assistant

Jul 2008 to Dec 2009

Responsibilities:

Worked on managing and maintaining SQL Server 2008 Relational Databases.

Install, Configure and deployed the SQL Server 2008 on various systems in the lab.

Managed student databases and developed designs for online and remote access.

Troubleshoot system and printer problems; assist faculty and students with desktop and server related issues.

Monitor department systems and respond to issues.

Perform miscellaneous duties as requested by the system administrators including software installation and compilation.

Document all changes to the systems.

Ensure compliance with department policies regarding computer usage.

Supervise a computer laboratory.

Assist a faculty member with a research project; engage in literature searches.

Configuration and management of servers used in the delivery of distance courses.

Assisting faculty in the development of new material for their courses.

Perform a variety of administrative tasks including preparation of Power Point presentations, data entry and analysis, web site development, collating marketing materials and presentations.



Contact this candidate