Test Cases Sql Server

ARCHANA AAGARAPU

Email: *********@*****.*** Phone: 310-***-****

Work Status: Green Card – EAD

Can legally work for any company in united states

PROFESSIONAL SUMMARY

Over 7 years of experience in Application Quality Assurance and Automation testing.

Comprehensive knowledge of Software Development Life Cycle (SDLC) and having thorough understanding of various phases like requirements, analysis, specifications, Design, Development and Testing.

Experience working with Waterfall, V and Agile software development methodology.

Experience in Automated testing tools like Selenium.

Proficient in analysing Business/ System Requirements documents and Use Cases.

Expertise in preparing Test Strategy, Test Plan, Test Cases and Test Scripts for automated and manual functional testing for Performance, Functional, UAT, Load, Stress, Database, and Smoke testing.

Expertise in preparing/maintaining Requirement Traceability Matrix.

Experience in dealing with clients, analyzing the feasibility of projects, identifying new process migration opportunities, and planning the strategy & implementation of new projects.

Experience is testing the REST full & SOAP web services.

Experience in Database Testing.

Extensive knowledge and work experience on Quick Test Professional, Test Director and Quality Center.

Extensive experience with ERP, Financial, Health Care and Information Systems applications.

Extensive knowledge and experience in every phase of Quality Assurance.

Experience in iPad and Mobile testing.

TECHNICAL SKILLS

Tools: Selenium, Test Director /Quality Center, Test Link, Test Rail, Redmine, JIRA, Tortoise SVN, Confluence.

Test Methods: Gray Box (Automated) Smoke End-to-End, Black Box (Manual) Functional Back End, Database testing

Test Skills / Knowledge: Automation, Creating & Executing Test Strategies / Plans / Cases / Scripts Summary Reporting, SDLC (Software Development Life Cycle) Agile, Requirements Analysis, Process / Functional Analysis.

Programming Languages: VB

Databases: MS Access, Oracle: (8i 9i 10g), SQL Server

Operating System: LINUX, UNIX, Windows: 7, 8, 10, And 2008, IOS, MAC Pro, Mac Mini.

PROFESSIONAL EXPERIENCE

Prime Focus Technologies, Inc, Culver City, CA

Sep 2012 – Current

QA Engineer

DAX Production Cloud: A secure online workflow solution that allows users to upload, manage, and securely distribute digital dailies, scenes, takes, scripts, call sheets, budgets, locations, costumes, and auditions. Production Cloud offers robust content control features to ensure secure, timely, and cost-effective delivery of production assets.

DAX: The DAX platform delivers media asset management applications and services to companies that produce, distribute and license audio-visual and rich media content, empowering the people that make it all happen. The objective from the enhanced DAX platform is to provide customers more advanced features and have a innovative in media market. It is a web, mobile, desktop and set top box media based Digital Asset Management application used to store, organize and customize the digital assets from recording through post production.

Responsibilities:

Developed Test Strategies, Plan and Scenarios for the application.

Handful of experience in writing test cases using Test Link and Test Rail tools.

Identified the test cases to be automated and performed data driven testing and GUI Check Points using Selenium and enhanced the overall functionality of the application.

Participated and performed agile testing methodologies.

Performed REST full web service testing.

Involved in end to end testing for web, iOS and STB applications.

Performed back end migration testing in Azure blob and

Worked with offshore Dev and QA teams

Attended weekly defect report meetings and presented progress updates.

Involved in weekly late-night deployments and post release testing.

Environment: JIRA, Windows 7, 10, iOS, Mac Pro, Mac mini, iPhone, iPad, Chrome, Safari, IE and Firefox, Redmine, Test Link, Test Rail, Confluence, Tortoise SVN.

Factset Research Systems Inc, Hyderabad, India

April’ 2010 – June 2011

Quality Analyst

Factset: It is a customized web application which provides financial Information for investment managers and investment bankers by which it provides solutions for Portfolio Analysis, Quant and Risk Analysis, Fixed Income analysis, security exposures etc.

Responsibilities:

Reviewed and analysed design and specification documents

Developed Test Strategies, Plan and Scenarios in conjunction with SMEs, development and other QA.

Written test cases based on Functional Design Document and Customer Support Feature Requests using HP Quality Center.

Used QTP automation tool for functional and regression testing on Factset web based application.

Used SQL queries and Joins for verifying the data in multiple tables.

Conducted functional, regression, and user acceptance rest (UAT).

Report, Track and Manage Bug Reports using HP Quality Center.

Involved in Onsite and offshore coordination, team meetings to discuss the issues evolved out of testing.

Performed browser compatibility testing in different operating systems, like Windows and UNIX.

Environment: HP Quality Centre 10.0, HP QTP 10.0, Microsoft Visual Studio 2010, C#.NET 2.0, SQL Server 2008, TFS, WCF, Windows XP, IE6 and above versions, Firefox 3.0 and above, Google Chrome.

Call Street Audio Acquisition and Transcription: This standalone application is used for conference and bridge calls which record both telephonic and webcast conversations. This application has a capability of recording multiple calls simultaneously. All the recordings will be tracked in a data file which is stored in a data base.

Responsibilities:

Interim QA lead for the whole application.

Involved in detailed study of the Software Requirement Specifications.

Documented the Functional, GUI, Regression, Scenarios for UAT.

Developed test cases based on Functional Design Document (FDD) and Business Requirement Documents (BRD) using Quality Center and internal tool Justifier.

Conducted regression testing using QTP.

Carried out extensive backend testing to ensure proper backup and restoring of data using SQL queries.

Conducted positive testing and negative testing for CAA and CTT standalone applications.

Performed Stress Testing to check the quality of the application in handling multiple business calls.

Estimated the testing efforts involved.

Identified the application defects and Reported defects using an internal tool “Request for Product Development Tool (RPD)”.

Involved in Peer review of test scenarios and test cases.

Generated Traceability matrix for Requirements vs. Test Cases.

Used Interactive tool “Status Web Page (SWP)” to provide the updated testing status to the development team.

Environment: Internal Reporting tools – RPD, Justifier, SWP, Quality Center, 10.0, QTP10.0, ASP.Net 2.0, JavaScript, IIS 5.0, SQL Server 2005, Windows XP.

Navayuga Infotech Pvt Ltd.

June 2009 – April 2010

Associate Software Test Engineer

Client: IncentOne, Lyndhurst, New Jersey

Health Power: IncentOne serves more than 62 customers who deal with providing incentives for their employees and business partners which again peruses with the eligibility and activity of their business rules. Since 1997, IncentOneSM has provided integrated incentive solutions to clients ranging from small businesses to the FORTUNE 500, including half of the FORTUNE 50.

Responsibilities:

Analyzed the system requirements.

Involved in identifying the test strategies and test scenarios.

Developed test plans for Functional, Integration and System Testing using.

Documented test procedures and test data requirements.

Involved in writing and grouping test cases using HP Quality Center into test suites.

Automated functional test cases using QTP automation tool.

Involved in performing back end testing by writing SQL queries to extract the data.

Used HP Quality Center for defect tracking and reporting.

Communicated with development team to verify defect fixes and update defect status.

Worked for project maintenance team and resolved customer facing issues.

Test case design using equivalent partition (EP) and boundary value analysis (BVA) techniques.

Participated in project meetings to discuss the enhancement and modification request issues.

Interacted with business and development teams for understanding the requirements and design documents.

Prepared daily and weekly status reports.

Environment: (HP Suite) Quality Center9.2, QTP 9.2, VB Script, VB.Net 2.0, ASP.NET 3.5, C#, BizTalk Server, SQL Server 2005, SSIS, SSRS, AS/400, Cold Fusion, Windows XP.

Client: Government of Namibia

Housing Financial Management System: HFMS is a web enabled application that can be used by the Directorate of Housing under Ministry of Regional and Local Government. It deals with housing loan policy initiated by the Namibia Government, targeting both urban and rural income groups.

Responsibilities:

Analysed the Business and User requirements and participated in the creation of the test plan, test specifications and test procedures for functional, GUI and load testing.

Developed functional test cases, UAT, regression test cases of various transaction types using internal tool “Integer”.

Assisted with technical writing for the application using “Robo Help”.

Performed browser compatibility testing.

Reported defects using internal test management tool “Integer”.

Performed verifications on fixes in multiple environments. Clearly documented and/or communicates fix success, failures and status updates, as appropriate.

Worked closely with Developers and Business Analysts to communicate QA issues, testing status and with the testing teams

Environment: Java, Windows XP, IE 6 and above, Firefox 3.0 and above, Integer, Robo Help.

Exensys Software Solutions Pvt Ltd., Hyderabad, India

Feb 2008 – June 2009

Associate Test Engineer

eXensys: eXensys Suite is a full-featured product with the core modules: Financials, Sales & Distribution, Procurement, Inventory Management, Human Resource & Payroll, Production, security services, POS, Process Manufacturing, Fixed Assets, Analytics, Consignment, Costing and Taxation.

Responsibilities:

Understanding the project requirements and functional specifications of the project.

Prepared and executed test cases as per System Requirements using Test Director.

Performed various black box testing methodologies like User Interface, Functional testing, Compatibility Testing, Re Testing and Regression testing.

Extensively involved in using Test Director to report bugs.

Prepared traceability matrix for requirements.

Monitored test director to close the bugs as and when developers fix the bugs.

Environment: VB.NET 2.0, Share Point, MS SQL Server 2005, Citrix, Windows, IE 5, 6 Firefox, Test Director, MS Excel.

EDUCATION:

Master in Computer Applications, Osmania University, INDIA, 2007.

Bachelor of Science, Maths & Chemistry, Osmania University, INDIA, 2004.

Contact this candidate