Project Sql Server
Resume:
MADHURI YELURI
E-mail: ********@*****.***
Cell no: 224-***-****
Summary: 6+ years of QA / IT experience in testing Client /Server Applications and
Web-based Applications.
• Experienced in analyzing Business Requirements and Specifications.
• Worked with Development and Requirements Analysts to define Test Scenarios
and ensure that test requirements are correct and complete.
• Experience with QA Methodology and QA Validations to ensure the Quality
Assurance Control.
• Extensive experience in Manual Testing and Automated Testing.
• Experience in Functional Testing, GUI Testing, Database/ Backend Testing,
Regression Testing, Integration Testing in a multi-tiered environment.
• Experienced in XML testing.
• Extensive experience in writing Test Plans, Test Cases/Scenarios, Test
Procedures and analyzing Test Results.
• Expertise in developing Traceability matrix between requirements and test cases
to ensure adequate coverage.
• Extensive Experience in Writing of SQL Statements in Oracle and SQL Server
Databases.
• Excellent at Problem Solving, Root Cause Analysis, and Problem Solutions
based on Impact and Risk.
• Experienced in developing Test scripts for Manual as well as for Automated
testing
• Expertise in Problem solving and Bug tracking using Bug tracking Tools like Test
Director/Defect module and Quality Centre/ Defect module
• Involved in user acceptance testing(UAT) with client along with providing
training to end-users.
• Experienced in developing, executing and maintaining automated test scripts
using Quick Test Professional
• Experienced in designing automation scripts in VB to do functional testing using
QTP
• Experienced in using Test Director 7.6/8.0 and Quality Centre 9.0 as test
management tools.
• Experienced in working on Microsoft Commerce Server 2007 and Microsoft
Dynamics GP 10.0
• Experienced in creating and tracking work items in Microsoft Visual Studio
2008 Team Foundation Server
• Experienced in Agile SCRUM methodology.
• Experienced in handling multi tasks/ multi requirements simultaneously and
ability to work in a fast paced environment
• A very good team player and Enthusiastic with Excellent inter-personnel skills.
Technical Skills
Mercury suite QTP 8.2/9.2, TestDirector 7.6/8.0, Quality Centre 9.0
Languages C, C++, C#, PL/SQL, XML, ASP.Net and Java 2.0
Data Access ODBC, ADO, OLEDB.
RDBMS Oracle 8i/9i/10g, SQL Server 2000, 2005.
GUI VB 5.0/6.0, .Net
Operating System Windows N.T 4.0/2000, Windows XP, Windows server 2003,
Windows server 2008, Linux.
Servers Biztalk 2006 server, Microsoft Commerce Server 2007,
Microsoft Office Sharepoint Server, Microsoft Visual Studio
2008 Team Foundation Server
Packages Microsoft Dynamics GP 10.0
PROFESSIONAL EXPERIENCE
Dell/ License Technologies Group, Buffalo grove, IL Aug’08 – Feb’10
License Technologies Group, a division of Dell Inc., is the leading software licensing services provider for
software publishers and their partners with most effective ecommerce and software licensing solutions on the
market. I am involved in writing and executing detailed test plans and scripts to verify software functionality
and adherence to business requirements for the following projects.
o Microsoft OGA Online Storefront
o Dell Download Store
o SAP Business Objects n-Tier Distribution Project
Project: Microsoft OGA Online Storefront
QA Analyst
The purpose of Microsoft’s Office Genuine Advantage program (OGA) is to encourage
Office users with counterfeit Office software to obtain a genuine Microsoft Office
product. Users who fail validation will be referred to a DLTG hosted Web Store that will
enable users to obtain a license key and/or a valid copy of the software via electronic
software distribution (ESD).
Responsibilities:
• Understanding business requirements and business operating processes/
procedures in order to develop effective UAT deliverables impact business and
operational groups.
• Develop detailed test conditions, test cases and scripts, and related data to ensure
full coverage of the project’s functional business requirements
• Used Test Director for Project Management and scheduling
• Conducted Integration, System, Functional, GUI, Regression, Smoke, Database
Integrity, User-Acceptance (UAT) and Performance testing
• Designed Traceability matrix between Requirements and Test Cases to ensure
adequate coverage.
• Assisted Application developers in identifying and resolving problems.
• Designed automation test frame work.
• Creation and execution of low level scripts using variables in scripts and queries,
functions, descriptive programming for functional testing using QTP 9.2
• Creation of automation suite for the regression testing using QTP 9.2
Designed extensive descriptions of defects in Test Director 8.0 to communicate
•
effectively to developers and project managers.
• Execute testing assignments, document and provide testing results into defect
tracking system.
• Coordinated with the development team to resolve the open issues.
• Actively participated in bug tracking meetings with developers to re-create and
correct defects
• Executing test cases, reporting progress and issues in a timely and accurate
manner
Environment: QTP 9.2, Test Director 8.0, SQL Server 2005, Windows XP, Microsoft
Office Sharepoint Portal 3.0, C#, ASP.NET, IIS 7.0, .Net frame work 2.0
Project: Dell Download Store
QA Analyst
This ecommerce application built on Microsoft Commerce Server 2007 makes the
process of downloading software easy by consolidating a great collection of software
titles from a variety of publishers.
Responsibilities:
• Active participation in daily SCRUM meetings
• Creation and execution of Test plan and Test scripts for each Sprint
• Identifying the critical functionalities and areas of the application to be regression
tested and writing test cases and executing for each sprint
• Assisted in designing and ensuing overall integrity of the testing strategy.
• Performing Integration, System, Regression, Performance, GUI, Database and
User Acceptance testing of the application
• Verification of Daily, Weekly and Monthly Sales, Key Sales, Returns reports
• Execute testing assignments, document and provide testing results into defect
tracking system of TFS.
• Logging and Tracking work items in Team Foundation Server(TFS)
• Designed extensive descriptions of defects to communicate effectively to
developers and project managers.
• Coordinated with the development team to resolve the open issues.
• Actively participated in bug tracking meetings with developers to re-create and
correct defects.
• Ensuring that test objectives were met in a timely and cost-effective manner
• Involved in Usability testing of the application.
Environment: Microsoft Commerce Server 2007, SQL Server 2005, Windows Server
2003, Microsoft Visual Studio 2008 Team Foundation Server, Microsoft Office
Sharepoint Portal 3.0, C#, ASP.NET, .Net 3.5, IIS 7.0
Project: SAP Business Objects n-Tier Distribution Project
QA Analyst
This Supply chain application is developed and maintained by LTG to enable SAP
Business Objects in implementing an automated e-commerce system for order capture,
order processing, partner management, license management and performance
management for their volume business distribution channel encompassing distributors
and reseller channels. Distributor can enter their orders either by EDI or Partner portal
and have the ability to check on their orders in Portal and has a provision for both
Physical and Electronic fulfillments.
Responsibilities:
• Analysing business requirements to ensure that requirements are clearly defined
and testable.
• Designed, developed and implemented test plans, scripts using Design
Specifications and Business Requirements documents.
• Worked with business and technology leads to identify the appropriate data and
the acceptable range for test results and performance for testing, and prepared test
data for the test cases
• Assisting Application Developers in identifying and resolving problems
• Active participation in daily SCRUM meetings
• Creation and execution of Test plan and Test scripts for each Sprint
• Validating the Master data(Distributors and Resellers addresses, Price lists) in GP
• Creating EDI files for testing Business rules and User Acceptance testing
• Verifying that Order details fed into the system(through EDI/ Portal) are mapped
to the correct fields in database
• Verifying the flow of the orders in GP interface
• Verifying flat files data(Order details) being sent and received from IPC/
Moduslink warehouses
• Verification of XML string structure
• Performing Integration, System, Regression, Performance, GUI, Database and
User Acceptance testing of the Portal
• Logging and Tracking work items(PBIs, SBIs, Bugs) in Team Foundation
Server(TFS)
• Designed extensive descriptions of defects to communicate effectively to
developers and project managers.
• Creation of User manual for tracking Order in GP for Customer Care team
• Ensuring that test objectives were met in a timely and cost-effective manner
Environment: Microsoft Dynamics GP 10.0, Windows Server 2008, Biztalk 2006
Server, SQL Server 2005, Microsoft Visual Studio 2008 Team Foundation Server,
Microsoft Office Sharepoint Portal 3.0, C#, ASP.NET, .Net 3.5, IIS 7.0, Softshare
EDI Notepad 5.1
Noridian Administrative Services, Chicago, IL Jan’07 - Jul’08
Project: Claim Tracking
QA Tester
NAS is working for federal insurance for Medicare. This application enables providers
like doctors, medical facility centers and durable equipment suppliers registered with the
federal government to track the claims of beneficiaries eligible for Medicare benefits at
age 65 and above. This application enables providers to track their claims and provide
necessary data to NAS if required, to finalize claims smoothly.
Responsibilities:
Involved in quality assurance reviews on all stages of System Development Life
•
Cycle.
Analyzed business requirements, system requirement specifications, and
•
responsible for documenting functional requirements.
Developed, designed and wrote Test Plans and Test Cases from Design
•
Specifications and Business Requirements.
Developed Traceability matrix between test cases and requirements to ensure
•
adequate coverage.
Used Quality Centre 9.0 for Project Management and scheduling
•
Identified the critical functionalities and areas of the application to be regression
•
tested and wrote automation test plan.
Creation of automation suite for the regression testing using QTP 8.2
•
Conducted data driven testing using QTP 8.2
•
Creation of automation scripts in VB scripting using functions, variables,
•
descriptive programming.
Performing Integration, System, Regression, Performance, GUI, Database and
•
User Acceptance testing of the application.
Execute testing assignments, document and provide testing results into defect
•
tracking system in Quality Centre.
Designed extensive descriptions of defects to communicate effectively to
•
developers and project managers.
Coordinated with the development team to resolve the open issues.
•
Actively participated in bug tracking meetings with developers to re-create and
•
correct defects.
Ensuring that test objectives were met in a timely and cost-effective manner.
•
Served as liaison with project developers, business analysts and management
•
Environment: QTP 8.2, Quality Centre 9.0, Oracle 10g, LINUX, Websphere 6.1,
Toad 7.5, Java, J2EE
Thomson Financials, 195 Broadway, New York Nov’05 - Dec’06
Project: Merrill Lynch
Quality Analyst
Thomson Financial is the most complete source for integrated information and
technology applications in the global financial services industry. They worked in
partnership with Cap Gemini, Ernst & Young on the Merrill Lynch Project, a Web-based
financial project that catered to the needs of a broad spectrum of people like the Financial
Analysts, Administrators and people in the Advice Suite. I worked on the Research and
Tools division, which dealt with concise market information and tools for Investment
Research such as World Indices, Market Movements, Stock Splits, Quotes, Third Party
Reports, and Guides.
Responsibilities:
• Involved in full Functional Testing of the application based on application Use
Cases and Test Cases
• Involved in assimilating and maintaining the various scenarios across all the
stream related use cases.
• Involved in Manual Testing of the GUI with regard to layout, usability and
standards
• Based on use cases, translated the information to test cases and test procedures
and conducted manual testing
• Involved in Browser testing of the application across different browser
combinations.
• Performed functional testing of the workstation version of the application targeted
towards brokers and call center personnel
• Performed detailed smoke test of the weekly build of the application
• Involved in database testing by writing SQL queries and also using data base
functions for automation
• Conducted Regression Testing using QTP
• Developed and enhanced User scripts for the performance, stress and scalability
tests
• Developed SQL scripts to extract data from the target tables to prove the data
mapping
• Extensively used Test Director to access and maintain functional and browser
related use cases.
• Interacted with the developers to get the problem fixed on a day-to-day basis.
• Attended weekly defect meetings with Team manager for bug fixes on a day-to-
day basis.
Environment: QTP 6.5, Test Director 7.6, Visual Studio.NET, Java Script, J2EE,
SQL Server 2000, Windows XP/NT
Prudential Securities, Brook lawn, NJ Dec’04 - Oct’05
Project: Online Trading
QA Tester
Prudential is web-based application, which provides customers of Prudential Securities,
various financial services like Brokerage Services, Mutual Funds, Fixed Income
Investments and Annuities etc. The application enables the customers to check their
portfolios online, get breaking financial news, real time access to accounts, get electronic
copies of statements, trade the stocks along with providing real time quote information
etc.
Responsibilities:
Analyzed the product’s Business requirements to write down the Functional
•
specification document
• Performed extensive vertical testing on the application manually
• Developed Test scenarios, Test cases and automated the Manual Test cases
• Developed Test scripts, established the base line and verified with actual results
• Performed detailed smoke test of the weekly build of the application
• Conducted System and Regression Testing, identified application errors and
interacted with developers to resolve technical issues
• Participated in bugs and enhancement review meetings, assigning the bugs and
enhancement request to the developers and follow up
• Interacted with the developers to get the problem fixed on a day-to-day basis
• Documented test cases, test results, test procedure and reported to client
Environment: TestDirector 7.6, Java, C++, Windows NT/2000, SQL Server,
Weblogic, ASP, HTML, XML
FAS Consultants, Hyderabad, India Jun’03 – Nov’04
Project: Patient Care software
QA Tester
FAS consultants developed software to cater to the needs of Mediciti, a well-established
hospital in the heart of Hyderabad. The application gives provisions to develop various
patient records including insurance details, Diagnosis, Prescriptions. It also provides a
database for patient history, patient information and physician information. The
application was later extended to accommodate the medical needs of various countries
and function well within the existing parameters of the same.
Responsibilities:
• Involved in Manual Testing.
• Involved in analyzing required documents and writing test cases and test
scenarios.
• Performed GUI, Positive and Negative testing.
Environment: VB, SQL, Windows NT, TestDirector 6.02
Educational Qualification: B.S (Electronics)
Contact this candidate