Sql Server Testing

Latha Nallamothu

Phone: 619-***-****, 858-***-****

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

Plano TX

Summary

As a graduate of Computer Science and Engineering with more than five years of Quality

Assurance experience, I am looking for a challenging opportunity in the area of Software Quality

Assurance that will utilize the skills I have obtained through professional training and work

experience. Furthermore, I have excellent experience in writing, executing, maintaining functional

test cases, and leading testing cycles. In addition, I possess excellent communicational,

organizational, strong, interpersonal, detail oriented testing skills as well as being an exceptional

team player.

Areas of Expertise

• Identifying the Test Requirements based on User Requirements and Design Specifications.

• Experience in working in waterfall model and agile methodology.

• Experience in Bug Tracking System Quality Center, ALM and TFS.

• Experience in preparing Test Plans Test case and Test summary, also excellent knowledge of

complete Testing Cycle

• Experience in Smoke, Regression, Integration, Functional, Negative, Cross Browser, Ad hoc testing,

Integration, Web service testing and User Acceptance testing.

• Experience in executing SQL Queries and have knowledge of DB concepts.

• Strong problem solving skills, extremely reliable, quick learner and able to work independently as well

as a team member.

• Knowledge in writing test cases, identifying and creating test data, execution of test scenarios,

analyzing the actual results against the expected results.

• Interaction with development teams for smooth problem resolution and error free rollouts.

• Lead QA in the production support activities and lead in projects.

• Performed smoke testing and regression testing of the application for every new build received.

• Tested product development as per requirement and verified even the minute details.

• Executed Automated QTP scripts from Quality Center, QTP knowledge.

• Actively participated in production support meeting, status meeting, daily standup and sprint planning.

• Exposure all stages of SDLC, STLC, and Bug life cycle and familiar with QA methodology.

• Have knowledge about the change management process.

Education

Bachelor of Technology (Computer Science and Engineering),

JNTU University, India

1

Technical Skills

Languages : SQL, PL/SQL, HTML, VB Script JavaScript, Java.

Operating Systems : Windows XP/2003, Window7, Linux.

Testing Tools : QTP, Test Director, Quality Center,ALM and TFS.

RDBMS : Oracle, SQL Developer, SQL server Management Studio.

GUI Tools : MS Word, MS Excel and MS PowerPoint.

Professional Experience

WOLFE MEDIA, SAN DIEGO, CA August 2013 – Current

Role: QA Analyst

Wolfe Media is a web development company. They have partnership with local media and develop the

web page for the customers who have contract for the commercials with the local media. They support

customers from USA and Canada. Myhomeimprovement.com is the home page, which links all other

states Pro’s home pages. Any home improvement queries from any part of the world are handled through

this site. Knowledge base is available for its users.

Responsibilities:

Functional testing, smoke testing, negative testing, ad hoc, regression testing, end to end testing

•

and performed simulated testing.

Writing test plans as required, providing work assignments, creating test report and providing the

•

daily report.

• Followed Agile/ Scrum methodology, analyzed System Requirement Specification (SRS),

Functional Requirement Specification (FRS) and design documents.

Analyzed the business requirements and wrote a Test Strategy and Test Plan.

•

Executed test cases as part of regression and reported the defects as it occurred.

•

Supporting the monthly releases and project releases.

•

Worked with developers as needed for an error free roll out.

•

Entered the defects in the bug tracking tool QC and tracked them.

•

Worked closely with BA’s and developers.

•

Executed automated test cases.

•

2

Interacted with Developers, Business & Management Teams and End Users.

•

Supported the UAT Testing.

•

Interacted with programmers to apprehend and resolve technical issues.

•

Trained beginners on testing methodologies.

•

Environment: Windows XP, Agile, Oracle, VB Script, HTML, ALM, QTP.

Choice one Bank, MI July 2011 – June 2013

Role: QA Analyst

Choice One Bank provides a comprehensive range of financial services: personal financial services,

commercial banking, corporate, investment banking and markets, mortgage, private banking, and other

activities. Integrated approach to managing risk that shifts the focus of the risk management function from

primarily defensive to increasingly offensive and strategic. Primary function was to reduce information

asymmetry regarding the firm's current and expected risk profile.

Responsibilities:

• Developing Test Cases and as per requirements.

• Tested functionality of the projects and verified if they were concurrent as per requirement.

• Submitted defects and followed up with the Developers and business analyst to get them fixed.

• Worked with developers to provide necessary details about the bugs as well as testing them.

• Attended the daily standup meeting to update the status of the Test.

• Testing includes Functional testing, ad hoc testing, integration testing, Regression testing,

Verification testing and validation testing.

• Supported the pilot release.

• Supporting the LIMS application testing

• Experience in testing integrated systems using web service call.

• Executed SQL queries as part of verification in SQL server management studio.

3

• Supported multiple projects.

• Written SQL queries to verify the results.

• Created Test plan, Test Report, and supporting documents.

• Followed Agile/ Scrum methodology, analyzed System Requirement Specification (SRS),

Functional Requirement Specification (FRS) and design documents.

Environment: Windows 7, Agile, Oracle, SQL, J2EE, Test Director.

SALTER LABS, ARVIN, CA Aug 2009 – June 2011

Role: QA Analyst

Salter Labs is a medical products manufacturing and distribution Company.

Responsibilities:

Executing the complete test cycle to test the functionality

•

Executed test cases to identify defects and reported the same in defect tracking system.

•

Involved in functional, sanity, and User Acceptance Tests.

•

Preformed regression tests after testing the fixed defects to verify previously passed test cases

•

that were not affected with the changes in the code.

Developed test cases from test requirements.

•

Executed SQL queries to extract data from the target tables.

•

Verified expected results with the actual results using SQL commands.

•

Worked with team Managers/Users to conduct user acceptance tests for Renewal system

•

application.

Participated in risk management to help determine best use of development and testing

•

resources.

Environment: SQL server, IAS, TFS, Windows, SQL server management studio, Linux

Genco (formerly Capital Returns), WI Jan 2009 Aug 2009

Role: QA Analyst

4

GENCO Supply Chain Solutions is North America’s second largest and a Global Top 50 third party

logistics provider and the recognized leader in Supply Chain & Reverse Logistics. Capital Return s, an

affiliate of Genco is the industry leader and innovator that have transformed pharmaceutical returns into a

data rich, systematic process that drives critical information and value back to manufacturers, pharmacies

and wholesalers.

Responsibilities:

Analyzed the Business, functional and System Requirement Documents and participated in all

●

phases of SDLC/ STLC cycle.

Created Business Process flow diagrams making use of MS Visio.

●

Involved in creating the test strategy documents that define the test environment, phases of testing,

●

entrance and exit criteria into different phases of testing and resources required to conduct the efforts.

Developed Test cases and Test data scenarios based on the User stories and acceptance criteria that

●

have been uploaded and performed Manual as well as Automation Testing for major functional areas.

Conducted Functional, Regression, Integration and System testing on different browsers (Cross

●

Browsers).

Formulated methods to perform Positive testing, Negative testing and Boundary Value

●

Analysis against requirements.

Tested various features like Releases, Requirements, Test cases creation, Scheduling, Test case

●

execution, Defects, Documents, Collaboration, Dashboards, Backups, Restore, Import and Export

and all aspects of Defect Tracking in HP Quality center.

Used Quality center for bug tracking and reporting, also followed up with the development team to

●

verify bug fixes and update bug status.

Understood core processes of the departments to provide input on re engineering or streamlining

●

opportunities.

Prepared/ presented progress reports, Audit packet, Executive Summary Report for each sprint

●

release.

Participated in weekly project status meetings and technical review meetings.

●

Environment: Oracle, Java, J2EE, HP Mercury Quality Center 10, Windows XP.

5

Contact this candidate