Ashish pasawala

973-***-**** acp0gy@r.postjobfree.com

SUMMARY

Over 6 years of experience in Quality Assurance and Software Testing.

Expertise in several facets of Software Testing with over 6 years of

experience. Adept at working in fast-paced, timeline driven environments.

Highlights include:

. Worked in different stages of the Software Development Life Cycle

(SDLC), which involved gathering business requirements, developing use

cases, test cases, UAT support, Production Support.

. Software testing methodology and developing Test Plans, Test

Procedures, Test Case Design and Execution.

. Documentation, Review and Execution of manual and automated test

cases/test scripts.

. Types of Testing: Business Functionality, Integration, Migration,

Black Box, Smoke and Regression.

. Proficient in HP Quality Center, TestDirector, Clear Quest and other

quality analysis tools.

. Extensively used Quality Center for script executions and defect

management.

. SQL Single-row functions (Character, Number, and Date etc), Group

functions and sub queries.

. Executing SQL queries in order to view successful transactions of data

and for validating data.

. Developed complex SQL queries during End-to-End testing stage.

. Good understanding of Oracle Applications and other peripheral systems

that connect to Oracle.

. Excellent analytical skills in understanding of client business

process and its implementation.

. Organizational, Problem-solving, Written and Verbal communication

skills.

. Ability to quickly adapt to the client's requirements and always

focused on customer satisfaction.

.

PROFESSIONAL EXPERIENCE

TARGET CORPORATION,

Minniapolis, mn Dec 2010 -Sept 2014

Software QA Analyst

Provide lifecycle management of testing projects on software and large

database application like Managing USA wide Store Location Management

System (SLMS). Application is JAVA based GUI with complicated

functionalities to handle Target Role based user access, Capability, Role

Hours Management, Store Capability, Location information. Application

transaction is fetched with Real-time http XML Request/Response Transaction

from web server to application to Oracle database. Application is tested

with SQL validation and debugging process with UNIX utilities. E2E testing

includes System, SIT and UAT testing following Agile Process.

. Interacted with the project team to gain an understanding of the business

and technical requirements.

. Analyzed E2E flow of application with cross functional team to identify

key functionalities of application.

. Reviewed & validated business requirements.

. Responsible for getting scripts Reviewed/Updated/Approved.

. Setup data for testing and involved in documenting testing strategy

. Performed sanity testing with acceptance test cases and executed test

cases from Quality Center. Daily testing team meetings with lead to

identify gaps, defects and discussion with upcoming changes.

. Wrote basic SQL queries for database testing mapping of data, verifying

incoming and outgoing data.

. Support business users during User Acceptance Testing by providing data,

creating defects and interacting with the Development & Validation Teams to

address the defects.

. Collaborate with project team members on development and customer issues;

identify gaps and retest/ regression testing.

. Perform problem analysis and resolution, defect researching, and

resolution analysis of test results to resolve discrepancies escalate

issues.

. Adhered to established standards and methodologies. Utilized tools and

methodologies to improve individual effectiveness and to increase

efficiencies in the QA process.

. Involved in key learning process after each release to implement process

in future as a part of QA process

Management.

. Conducted manual testing using the standards, guidelines and structured

methodology in testing the application with use of SQL scripts and UNIX

utilities like AWK (AWK function), GREP, SED, VI editor, process and

network utilities.

. Reported, provide testing project feedback and archive testing assets in

order to verify completion of testing. Highly motivated, detailed oriented,

ability to work independently as well as a team member with excellent

technical, analytical and communication skills.

Ashish Pasawala

Page 2

973-***-**** acp0gy@r.postjobfree.com

WELLS FARGO,

Charlotte, NC Jan 2009

-Sept 2010

Software QA Analyst

Wells Fargo mortgage application was a web base application used by its

customers to get

Free mortgage rates & quotes. Users calculated the mortgage rates and

payments, registerd for free rate watch services, applied for a

mortgage online and received auto generated email notification of the

application status once an application was submitted. The application

required mortgage documents to be uploaded to finalize the application. The

user could download or save the application, register to get daily rates &

quotes via email and ability to float or lock their mortgage rates. All

testing was validated using SQL/UNIX with System Testing in multiple

releases.

. Reviewed requirement specifications and functional design documents for

completeness and testability as well as ambiguity and inconsistency.

? worked on scenarios for different application modules according to

functional requirements and business

Specifications.

? Taking a lead role in automation and manual testing by creating detailed

test plans & test cases.

? Responsible for conducting Smoke, Functional, Regression testing as well

as ad-hock testing.

? Created and updated Requirements Traceability Matrix (RTM) in Excel.

? Collaborated with Manual testers and Business Analysts as needed to

report data related issues,

Regression testing and determine the root cause of defects.

? Created test design by using Quality Center and tracked the defects and

reported the defects to the concerned persons.

? Tracked bugs using Quality Center and performed regression testing of the

entire application once the bugs were fixed. Frequently updated the

requirements using Quality Center.

? Identified, analyzed, and documented defects utilizing Jira as defect

tracking system and Confluence as

Knowledge and documentation management system.

? Developed complex SQL queries during End-to-End testing stage.

? Responsible for writing SQL queries to get real time data for testing

purpose. Back end Testing was performed using SQL queries.

? Participated in both internal and external process improvement projects

like QA, SIT, and UAT Testing with Business, Marketing and External

Vendors team.

? Strong Project Management skills like Test planning with LOE, test

estimation and resource planning.

? Expertise with testing tools like JIRA, Quality Center and third party

tool Toad, MQ Editor (IBM Queue Testing)

? Knowledge of relational databases like Oracle Database 10.0g to validate

data testing in back end using

Complicated SQL script using Oracle functions.

? Involved in User Acceptance Testing on later stages of SDLC.

Ashish Pasawala

Page 3

973-***-**** acp0gy@r.postjobfree.com

Sprint,

Nov 2007- Dec 2008

Cambridge, MA

Software Tester

Testing and Managing application for SPRINT Customer Legacy Data

Transferring System from dynamic database to static database, involving

testing of extract process; UNIX and SQL based validation including test

data creation, system and integration testing with external team.

. Analyzed the Business Requirement Documents and Functional specification

documents to prepare Test cases based on Test Plans.

. Performed quality understanding of the Business Requirements and

developed Test Cases to Test the complete Functionality of any Particular

Page/Report/Module.

? Communicated with Business Analyst on any issue clarifications and

performed GAP Analysis.

? Involved in all aspects of Test planning including developing Test Plans

& Test Cases, creation and execution of Manual test cases to test the

system.

? Actively participated in Smoke, Functional and Ad-hoc testing during SIT

phase.

? Worked on Black box, GUI, Integration, System & UAT Testing.

? Conducted Regression Testing during each release.

? Prepared Defect report by severity, defect status and assigned defects to

follow up during defect life cycle.

? Utilized Toad and SQL Developer applications as Oracle clients to perform

most of the DB activities.

? Wrote complex SQL queries, executed PL/SQL stored procedures for data

extraction and validation.

? Actively participated in all QA and testing activities during UAT and

PROD SDLC.

? Attended meetings and provided status to various cross-functional teams

including management.

? Trained team members to understand the project functionality.

? Supported team members to solve issues and guided during test

development.

EDUCATION

. Bachelor of Science

Mechanical Eng. (1983)

M.G.Science, Ahemedabad

. Chubb Institute- Networking 2001

CERTIFICATIONS

21CFR Part 11 Applied Training

Computer System Validation

New York Life Insurance

Agent : Feb 2015- Present

Contact this candidate