Sql Server Testing
Resume:
Rimku Patel
*******@*****.***
PROFESSIONAL SUMMARY
• 4+ years of extensive and diversified experience in Information Technology with emphasis on Development
Quality Assurance, GUI, Manual and Automation Testing, Web, and Client/Server based applications.
• Strong knowledge of Banking/Mobile/Electronics/Insurance Industry.
• Strong working experience with testing tools like Quality Center, Test Director, Clear Quest, Quick Test Pro( QTP),
Selenium, Soap UI, ALM.
• Experienced in testing applications utilizing technologies such as XML, XSLT, HTML, DHTML and JavaScript.
• Expertise includes manual and automated testing, QA methodologies, Risk management, Change & version management,
Requirement and Release management.
• Automating manual scripts by using Automation tools such as Win Runner, Quick Test Pro (QTP).
• Use Mercury Quality Center for test management and bug reporting.
• Extensive Experience in Black Box Testing.
• Experienced in Unified Modeling Language (UML), Test Lifecycle, Data Warehousing, Data Modeling, Data Analysis,
Service Oriented Architecture (SOA), Prototyping.
• Followed the Agile methodology and extreme programming concepts of project development. Analyzed and incorporated
User Stories in different release plans for the sprints in Scrum process.
• Good experience in implementing Service Oriented Architecture (SOA) and proficient in testing Web Services using
soapUI tool
• Experience in defect reporting and defect tracking using defect tracking tools like Quality Center, Clear Quest.
• Involved in writing programming scripts in TSL for Win runner, VB Script and test scripts for QTP and creating user-
defined functions.
• Hands-on Experience in Automation Testing using QTP (VB Scripting, Descriptive Programming)
• Reviewing of Business Requirement Analysis, and System Specifications Analysis.
• Writing positive and negative Scenarios and Test Cases for System & Web testing.
• Hands on experience testing Commercial Websites and business applications.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008.
• Written TSL script for Database and data driven testing for regression testing of business workflow.
• Extensive knowledge in writing and modifying T-SQL queries (DDL and DML)
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SQL Server Integration
Services (SSIS), BCP and DTS utility. Extracting, Transforming and loading(ETL) of data using SSIS and DTS
• Experience in managing Alerts and Jobs through SQL Server Agent in SQL Server.
• Experience in Deploying DTS/SSIS packages in SQL Server Integration services (SSIS).
• Good understanding of iterative software development methods.
• Strong analytical and problem solving, interpersonal and communication skills, self-starter, quick learner and able to
adopt new technologies as needed in rapidly changing IT environment.
TECHNICAL SUMMARY
Modeling Tools Rational Rose, Rational Portfolio Manager, MS Visio, ETL.
Testing Tools Mercury Quality Center 9/10.0, Test Director, Mercury Interactive Win Runner
7.5/8.2, Load Runner 7.8/8.1,Quick Test Pro 6.5/8.0/8.2/9.0/9.2, Test Director
7/7.6/ 8.2
Operating Systems Windows 98/NT/2000/XP, Windows Vista, UNIX, windows XP
Languages HTML, UML, SQL, PL/SQL
Databases Oracle, SQL Server 2000/2005, RDBMS, TOAD, MS Access 2000, DB2
Business Applications MS Office 2000 (Word, Excel, PowerPoint, Outlook),MS Visio, MS Project Suite
Methodologies SDLC, Object Oriented Analysis and Design (OOAD), Rational Unified Process
(RUP), Unified Modeling Language (UML), Rapid Application Development
(RAD), Joint Application Development (JAD)
PROFESSIONAL EXPERIENCE
Discover Financial Services, Houston, TX
Sept
2013 Till
Quality Analyst /Test Engineer
• Analyzing business requirements and functional specifications, and developing test plan according to Business
Requirement Document.
• Provided back end testing for database auditing and data validation using SQL queries.
• Managed requirements and developed Test Scripts and Test Cases using Quality Center.Assisted Quality Assurance
team by running SQL queries to extract data. Executed SQL queries for database verification. Implemented Ad-hoc
Reports, Extracting Data from an SQL Server database.
• Experience in testing the web services using the SOAP tool.
• Verified and validated the data transfer through web services calls as intended using soapUI.
• Worked with Web Sphere message broker for integration of the applications in SOA.
• Created LoadRunner Scripts to mimic real user behavior by enhancing the scripts with C / LR functions.
• Developed Automation Test Scripts using VB Script functions.
• Managed the automation by creating recovery Scenario. Also merged the Object repository for integration test.
• Created LoadRunner Scripts to mimic real user behavior by enhancing the scripts with C / LR functions.
• Responsible for raising defects using Mercury Quality Center and track them to closure.
• Writing test strategy and coordinating with the development team and product manager on different change requests.
• Preparing and executing automation test scripts using QTP.
• Prepared Automation Testing Framework for reducing manual intervention to zero for performing Smoke, Functional or
Regression testing.
• Conducted Load Testing using LoadRunner for response time monitoring.
• Extensive success in translating business requirements and user expectations into detailed specifications employing
Unified Modeling Language (UML) in an SOA environment.
• Developed test plan, test cases and performing manual and automated testing using Quality Center.
• Performed review activity for UAT.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Extensively used SQL to verify the integrity and consistency of the data in the database to perform backend testing using
TOAD for seed files and payroll files.
• Prepared Test Metrics and generated monthly status reports for upper management’s review.
Environment: Vb Script, Quick Test Pro10.0, MS Project Tracker, HP ALM, .Net 4.0, MS SQL Server 2005,
IE7,Termina Emulator, Windows7, HTML,XML,SOAPUI, UNIX.
Client: T- Mobile, Seattle, WA Apr 11 –
Aug 12
Test Engineer
Responsibilities:
• Working closely with Business Analysts to understand the requirements of T- Mobile services.
• Analyzing business and functional requirement documents to create test scenarios and Test cases for
customer connections and account management and billing.
• Used VBScript for scripting the automation. Involved in technical writing of high level automation Test
Plans, Test Cases, Test Scripts, and Test Scenarios in Selenium.
• Working with project team to define and create overall strategy and ensures that it is being achieved.
• Used HP ALM as repository for requirements and Test cases, Test plan.
• Involved in developing of Test Plans and Test cases based on the requirement documents.
• Involved in collecting the Test Data.
• Preparing and enhancing the test cases according to the functionalities to perform test execution.
• Performing Black Box Manual Testing using Boundary Value Analysis (BVA).
• Performing Functional Testing, Compatibility Testing, System Testing and Regression Testing, and DB
testing.
• Reporting defects and tracked the status of the defects with the development team and coordinated with all
the parties involved for retesting the existing defects after the new code deploys.
• Participated in review of requirements and interacted with business analysts for clarification of doubts and
also participated in defect review meetings.
• Communicating the test strategy to the Project Manager and Development Team regularly and also
effectively updating the management team of any changes.
• Verified the navigation of links through integrated testing.
• Maintained the requirement traceability matrix to ensure the requirement coverage.
• Verified the data stored in the database with the help of SQL queries for Database testing.
• Used SOAPUI to validate the responses of web services.
• Participated in all phases of the Software Testing Life Cycle.
• Created startup VB Scripts which involve shutting down all the instances of application running, starting
QTP and launching the application.
• Involved in recognizing the Objects using Shared Object Repository.
• Involved in enhancing the existing scripts using Check points, Synchronization etc.,
• Involved in identifying the broken links using Page check point.
• Working with QTP to write automation test scripts for regression testing.
• Using Data Driven approach tested the application with different sets of test data.
• Interacted and worked with the development team to solve the problems encountered in the test scenario
run.
• Involved in Agile Software Development model.
• Participated in Daily/Weekly Scrum meetings.
• Participated in reviews and peer reviews of Test Cases.
• Maintained the test case documents according to the changes done for reusability.
• Ensured Quality through technical competency.
Environment: ASP .net, Quick Test Pro10.0, MS Project Tracker, HP ALM 11.0, .Net 4.0, MS SQL Server 2005,
IE7,Termina Emulator, Windows7, HTML,XML,SOAPUI, UNIX.
Sony Electronics, San Jose
May
2010 March 2011
Test Engineer
Responsibilities
• Responsible for Functional, System, Integration, Regression and Load testing of the above mentioned applications
employing both manual as well as automated testing techniques provided by Mercury tools (Test Director/QTP/Load
Runner).
• Testing the application to meet the business requirements.
• Defect tracking is done using IValsun.
• Working with the development team for basic functionality testing (smoke testing) before the code is deployed in the QA
environment for regression testing
• Participated in Black Box Testing and Integration Testing in White Box testing approach.
• Conducted testing of the system End-End Testing manually.
• Perform Regression, UAT, Integration, User Interface, GUI, and Usability Testing.
• Created SQL Queries to Extract, Insert, and Delete data from Database including Inner and Outer Joins.
• Involved in developing testing strategies and designed Test plan to ensure that test cases reflects user needs using
Quality Center.
• Used Mercury Quality Center for tracking and reporting defects found during the functional and regression testing and
followed up on the bug life cycle.
• Used Mercury Quality Center for documenting requirements and planning tests.
• The test plan covered functional, integration, regression, performance and end-to-end testing.
• Converted the required manual tests into automated using Quick Test Professional.
• Developed QTP based automated test scripts using function libraries, conditional statements, loops and
parameterization. Used keyword driven framework.
• Responsible for reporting bugs to the corporate Bug Tracking System (Quality Center) & verifying known bugs
against new builds.
• Worked with developers & other QA Engineers to address testing issues in a proactive manner.
• Involved in conducting the Load, Stress and Performance testing using Load Runner and developed Vugen test scripts
and scenarios.
• Studied application performance and maximum scalability, critical parameter such as number of users, response times,
hits per seconds (HPS) and Throughput using Loadrunner.
• Created and executed SQL queries to verify the data against database.
• Performed web specific testing like Link Checking (external, internal), Browser page testing, Application testing, and
Security testing.
• Responsible for UAT testing.
Environment: Oracle, Unix, Bug tracking tool, SQL, Snag It, ASP.Net, HTML, Windows XP, MS Visio, MS
Project, MS Product Studio and MS Office suite
Education:
Bachelor in science from Cleveland state University, Ohio.
Contact this candidate