Test Cases Quality Assurance

NIYATI DESAI

** **** ******, *******, ** *****

******.*****.***@*****.*** t 404-***-****

QUALITY ASSURANCE SPECIALIST

Improve Product Quality by leveraging Agile and best SDLC Practices

Senior QA Analyst/Business Analyst with strong analytical skills and attention to detail to improve product quality. Over 15 years of experience in software development life cycle including development, writing requirements, creating test cases, and test data. Strengths include manual and automated regression testing. Accomplished trainer and mentor. Quick learner, dedicated, loyal, team player and hardworking employee.

COMPUTER SKILLS

Languages and Tools

Operating Systems

Relational Database

Visual Basic 3.0, 4.0, and 5.0

C

TSL

Java 1.6

Win-Runner 7.X-8.X

XML

SoapUI 4.5.3

QTP

Quality Center 8.0

Excel, Word, MS Project

VISIO

VSS

Subversion

Target Process

TFS

ALM

Windows 3.1, 95, NT 4.0, 2000, XP

Working knowledge of UNIX

MS SQL Server, ORACLE, SYBASE

EXPERIENCE

SIU, Inc. Alpharetta, GA April 2017 – August 2017

Business/System Analyst (Consultant)

Analyzed requirements for AIM system upgrade

Performed impact analysis for all the applications, services and related modules

Identified all the stored procedures, reports which would interface with AIM DB

Created SQL queries to verify all the information in AIM DB based on all stored procedures

Responsible for creating and monitoring AIM upgrade project & test Plan

Responsible for verifying all scenarios and SQL queries for AIM upgrade

EY, Alpharetta, GA January 2015 – February 2017

Senior Consultant

User Acceptance Test Lead for Strategic Client Onboarding for one of the biggest wealth and investment banking firm.

Assisted my manager with scoping, planning & estimation activities for several releases that included some of the key client projects

Understood project requirements by referring BRDs, and SRS and existing test cases

Created test plans, test scenarios, test cases and enforced ALM process

Executed complex test cases

As a team lead of 7 testers, assigned tasks, provided guidance and oversight to my team on their daily activities

Ran defect triage calls with all stakeholders - Business, IT, QA and Operations

Managed scope changes during regression test cycles and ensured delivery dates and client expectations are met

Provided training and knowledge transfer to off-shore team members. Mentored off-shore team members by clarifying all their questions and giving them timely and constructive feedback on their performance

Created detailed daily status report for EY client to review

SIU, Inc. Alpharetta, GA June 2014 – October

Business Analyst (Consultant)

Gathered requirements for new HO3 application for R and Q carrier

Wrote requirements for new HO3 application for R and Q carrier

Created test cases, test data for HO3 (R and Q) and successfully tested new HO3 (R and Q) application

Updated requirements for new ALIS system for HO3 rater, and Agency portal

Responsible to test HO3, Garage, and Mobile home

Worked with offshore team and onsite team whenever required.

Participated in UAT testing

TMX Finance, Alpharetta, GA March 2013 – Jan. 2014 Sept. 2010 – May 2012

QA Engineer (Consultant)

Created test cases, SQL queries for ATLAS, TLPro, & QFund reports using Agile approach.

Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process using SQL Server Integration Services (SSIS 2008R2)

Tested the ETL mappings from Source to Target.

Writing SQL Queries to retrieve data from data base.

Tested all the dumps using csv files

Worked with offshore team on daily bases to meet tight deadlines.

Active participant in daily scrum meeting.

21st Century Insurance and Finance Services, Alpharetta, GA 2004–2009

Business Analyst (2007–2009)

Key interface between systems area and business area; ensured business needs were met accurately and in the most cost-effective fashion. Oversaw all tasks involved in projects from data gathering through post-implementation.

Prepared functional requirements for Dynamic Rating System, both eRater new business and endorsement application. Maintained all compliance related data (forms) for quality assurance to cross-check against product and for developers to ensure that functionality met product requirements.

Performed initial data mapping of front end to mainframe interface. Maintained data transformation documentation, which was key documentation for development team.

Participated in user acceptance testing and verified XML data for eRater system

Coordinated and monitored onsite and offshore development and QA, DB, and installation team sign-offs, ensuring timely user acceptance testing and product implementation.

Sr. Quality Assurance Analyst (2004-2007)

Created test data, test cases and testing applications. Within a year moved to automation team to support automation scripts.

Provided testing for DRS from levels 1-6 and executed test cases where database knowledge was required.

Reviewed product specifications and developed product knowledge and determined issues to be discussed during specification review meetings.

Analyzed business and system requirements and created thorough test cases, meeting extremely tight deadlines and resulting in reducing the number of defects, multiples passes, and production fixes and ultimately increasing revenue.

Managed script creation for rate matching and rule validation using Win Runner for all the Auto, MC, RV and CV products.

Supported IQA lab ensuring that all daily automation scripts were running successfully.

Maintain test data using excel spreadsheet for data-driven automation scripts.

Mentored junior QA analysts in automation testing as it relates to maintaining test data and scripts.

Identified, reported and tested defects using the Test Director bug tracking tool; developed database of defects as an effective reference tool for stakeholders driving the quality of the project.

Revenue Technologies, Atlanta, GA 2003–2004

Sr. Quality Assurance Analyst

Served as Sr. QA Analyst to provide quality product.

Created test cases for very complex web application involving C++, Java, Strut and Oracle 9.2 for sales people to manage and close agreements.

Created Excel spreadsheets and maintained test data prior to actual testing phase, resulting in thorough and effective product test results.

Administered defect tracking system.

Attachmate, Alpharetta, GA 1997–1998

Software Test Engineer

Served as QA Analyst to provide quality product.

Successfully created and tested test cases for ODBC API to test QuickDB application.

QuickDB is a middleware that lets user access data residing in several different databases including MS SQL Server 6.5, ORACLE, and DB2 from their desktops using VB 5.0, RDO.

Administered SQL Server database for test team.

OTHER WORK EXPERIENCE

Xpanxion, Alpharetta, GA – Senior Software Test Engineer

Compris Technology, Kennesaw, GA – Programmer

Brock International Inc, Atlanta, GA – Quality Assurance Representative

Atul Products Limited, Atul, India – Programmer

Mukand Iron and Steel, Bombay, India – Trainee Programmer

EDUCATION

Master of Science in Computer Science with 3.92 GPA

Southern Polytechnic State University Atlanta, GA

Post Graduate Diploma in Computer Science and Applications

SNDT University Bombay, India

Bachelor of Science in Mathematics

University of Bombay Bombay, India

Certification

ISTQB – Foundation Level Certified Software Tester

Courses

Oracle DBA (11G)

Technology Center Inc. Norcross, GA

Contact this candidate