Testing Sql Server
Resume:
JHANSEE
E-Mail:********@*****.***
Summary:
. Over 7 yrs of experience in Manual and Automated testing of web based
and client/server applications.
. Deep understanding of various testing methodologies - Waterfall, Agile
and how testing practices change for each SDLC
. Experienced with test reports, managing defects through a defect
management life cycle, ability to identify process weaknesses and
opportunities for improvement
. Quality assurance test cases and scenarios -- manual, automated,
participated in whole SDLC process. Bug tracking software experience.
. Expertise in testing GUI Objects, Functionality, System testing
including Integration, Performance testing, Backend, Black box,End to
end and Regression Testing
. Proficient in using automated testing tools like Win Runner8.2,Quick
Test Pro, Test Director, Quality Centre, Test Manager and
rational Clear Quest for both client/server and web based applications
. Specialized in testing on WINDOWS and UNIX, Linux environments.
. Strong in Analyzing and understanding Business and user Requirements.
. Extensively worked on database testing (Oracle and SQL Server) and
validating the application against the database.
. Experience in writing and executed SQL queries for back end testing.
. Extensively worked on integrated system, Business Intelligence and
enterprise data warehouse systems
. Experienced in coordinating with multiple work streams within multiple
data environments
. Team player with excellent interpersonal skills and unlimited
willingness to learn new technologies.
Technical Skills:
Testing Tools : Win-Runner 8.2, LoadRunner 9.10, QTP, HP
QC, Rational Test Manager.
ETL Tools : Informatica, Business Object, Data Stage
CRM : Clarify, Salesforce.com
ERP : Oracle App's (Fico)
Defect Tracking Tools : Test Director/Quality Center, Rational Clear Quest.
Operating System : Win XP, UNIX, Linux and DOS.
Languages : C, C++, Java, HTML, ASP, SQL, and PL/SQL.
Database : Oracle 7.x/8i/9i/11i, MS SQL Server 2000, MS-Access,
Toad.
GUI : Oracle Forms 4.5, Crystal Reports 7.0, and Visual Basic
5.0/6.0.
Packages : MSOffice, MS Project, MSWord, MS Excel, PowerPoint.
Web Technologies : ASP, HTML, XML, VB Script, JavaScript, Shell Script.
Education:
Masters in Business Information Systems.
Bachelors in Computer Applications.
Professional Experience
Bank of America, NC
Dec'09 - Jun'10
QA Analyst
Responsibilities:
. Developed a road map by understanding the business logic and User
requirements for manual testing
. Involved in Functional, GUI, Regression and System testing, End-to-End
Testing.
. Conducted Performance testing manually, and Load Testing using Load
Runner.
. Involved in preparing the Test Plans, Test procedures, and Test
Scripts from the requirements using the QC.
. Interacted with developers and users to analyze business requirements
and functional specifications of the project.
. Created detailed test cases using Excel and imported them into Quality
Center.
. Extensively involved in testing the basic functionality of the
application manually using QC.
. Automated the functionality and interface testing of application using
QTP.
. Performed Manual Testing of the application, interacted with
developers to discuss the technical problems, and reported bugs using
QC.
. Generated automated test scripts for regression testing in Windows
platform using the Mercury's automated tool QC / QTP.
. Well experienced in developing Database Scripts and using to scripts
for Data Migration.
. Used various SQL queries to validate results for back-end test cases.
Written SQL Queries to define, Identify and validate data.
. Involved in preparing test scripts, test cases for unit and
Integration testing.
. Identified software errors and interacted with developers to resolve
technical issues.
. Attended QA meetings in deciding QA Test strategies, defining data
requirements for the testing and setting up QA Environment for
Testing.
Environment: Java Script, Quality Centre, QTP, .Net, HTML, XML, JSP, VB
Script, UNIX, Informatica.
Citi Group, NJ
Dec'08-Nov'09
QA/ Data Analyst
Responsibilities:
. Involved in Functional, Regression, System, End to End and User
acceptance testing
. Analyzed and reviewed Business, System & Functional requirement
documents.
. Analyzed and reviewed data architecture documents, technical
specifications documents and the data mapping documents.
. Created Test Plans, Test Cases, and Test Scripts as per the
requirement documents.
. Responsible for editing and modifying the existing test scripts in QTP
for regression testing.
. Automated test scenarios for GUI, Functionality, and Regression
Testing using QTP.
. Written & used SQL queries to identify & validate the code written for
the Business Object Reports & Extracts.
. Identified and logged defects using Quality Center and communicated
the recorded problems to the responsible development personnel.
. Interacted with Business analysts, System analysts, Functional
analysts, system staff and developers.
. Involved in providing project deliverables (Quality Control Test Plan,
Test cases/scripts, Issue logs &Test Results Turnover document).
. Participated in project meetings, walkthroughs, and defect report
meetings periodically.
. Well experienced in querying and writing SQL Server Queries and
scripts.
Environment: SQL, QTP, QC, UNIX Shell scripting, Java, Web sphere, HTML,
SQL Server, Windows XP and UNIX.
Cisco - San Jose, CA
Jan '07 - Oct '08
QA Analyst
Responsibilities:
. Designed and created various Test Plans, Test Cases and Test Scripts
based on the application requirements
. Involved in Back end, Functional, Regression, GUI, System &
integration testing
. Documented Defects found during test on the Test Director system and
communicated recorded problems to the responsible QA or development
personnel.
. Provided input and documentation to System Level Test Plan and
facilitated project deliverables
. Edited and modified test scripts for GUI, Functionality, and
Regression Testing using Win Runner.
. Used verification points and conducted Data Driven test with the Test
Data set and verified the contents of the website using Win Runner.
. Inserted new steps using the Step generator to enhance the application
after the application has been recorded.
. Involved in Testing Change Requests that is testing base enhancements
to the existing code before implementing in the Production.
. Used various SQL queries to validate results for back-end test cases.
Written SQL Queries to define, Identify and validate data.
. Performed validation tests to ensure that the developed functionality
meets the specifications prior to UAT testing.
. Participated in walkthrough and defect report meetings periodically.
Environment: QTP, JSP, JavaScript, HTML,Test Director, Internet, MS-SQL
Server, MS Access, SQL, MS Word and Windows NT/XP.
MoviusCorp - Atlanta, GA
Oct '05 - Dec '06
QA Tester
Responsibilities:
. Developed Test cases based on the requirement documents
. Performed Functionality, Regression Testing and system testing
. Documented and reported the defects to developers using the Test
Director.
. Formulation of trace ability matrix, test plan, test cases, test data
and test scripts.
. Responsible for updating existing test cases against the requirements.
. Automated the functionality and interface testing of application using
Win runner.
. Used checkpoints to check properties of various objects using
Winnrunner.
. Involved in system Integration testing (SIT), System Verification
Testing (SVT) and User Acceptance Testing (UAT)
. Used Toad for the purpose of writing and executing SQL queries and
scripts
. Participated in meetings to discuss the status and issues.
Environment: Windows NT Server, Oracle, Web Logic, Java, Rational Team Test, JSP, SQL Server, and Rational Robot, Clear Quest
RSA Securities, Boston, MA
May'05 - Aug'06 Software Tester
Responsibilities:
. Performed Functional and GUI Testing
. Created detailed test cases using Excel and imported them into Test
Director/Quality Center.
. Developed a road map by understanding the business logic and User
requirements for manual testing
. Developed Test scenarios based on the requirement documents
. Performed regression testing by executing the baseline scripts
. Used Test director to track and manage the defects and executing the
test cases
. Developed the Test Plans for the testing effort for the User Interface
of the application
. Involved in debugging the code and entered the bugs in the bug
tracking system
. Performed Integration Testing and Black Box testing of the application
from the end user's perspective
. Identified software errors and interacted with developers to resolve
technical issues.
. Extensively involved in testing the basic functionality of the
application manually using Test Director.
. Re tested the new build to make sure that the bugs have been fixed and
close them after the development team fixes them.
Environment: Test Director5.0, HTML/DHTML, JSP/Servlets, VB, Unix, Access,
MS Office, SQL, Java, Windows
Nagarjuna Financial Services, AP, India Nov'02
- Dec '04
QA Tester
Responsibilities:
. Analysis of user Requirements/ Initiatives and specifications.
. The whole testing framework is designed using Rational Robot.
. Conducted manual testing for usability and Compatibility.
. Executed Test Cases to verify actual results from the web page against
expected results.
. Conducted Integration Testing, System Testing, positive and negative
testing to make sure that the application is working as designed and
as expected.
. Automated Test Scripts for Regression testing using Rational Robot.
. Execution of the test scripts and logging the tracked defects in bug
tracking system and verified the test Results using Rational Clear
Quest.
. Manual Testing was done to perform functional testing on the User
interface.
. Attended meetings with developers and business analysts to discuss
about various enhancements for the application.
. Executed various SQL queries to extract the data from Database and to
validate the updates done in the front end.
Environment: J2EE, XML, HTML, Oracle7.1, Rational Robot, Clear Quest, VB
Script and Windows 98.
Contact this candidate