Project Test Cases

NITI PATEL

** ******* **. **********, ** ***** *******@*****.*** 732-***-****

SUMMARY

. Software Quality Assurance Analyst /Business Analyst with Proven

Experience in Testing ETL process, testing of Client Server

Applications, Front and Back End Testing with Unix and SQL, automation

testing with Selenium - Java Web driver API and Solid Skills Though

the Complete Q/A

Life Cycle.

. Excellent technical writing skills with hands on experience creating

Business Requirements, Functional Specifications, Mapping Documents, E-

R Diagrams, Test Plans, Test Scripts and Status Reports.

. Expertise in Process Management using Quality Center to document Test

Cases and conduct triage meetings to resolve issues.

. Experience working with huge volumes of data, analyzing record sets

for Data Quality, Data Validation and Metrics using SQL and / or

PL/SQL.

. Proficiency in customization & implementation of ETL processes and Web

applications.

. Proven ability to coordinate medium sized project from initial

conceptualization through implementation.

. Experience working with various software development methodologies

including Agile, Iterative and Waterfall.

. Excellent knowledge in Sybase, SQL server and Oracle Database Systems

and Unix Platform.

. Dynamic team player who is consistently motivated toward success and

completion of projects with an ability to work independently.

. A quick learner who can swiftly adapt to new challenges.

TECHNICAL SKILLS

. Software: MS Office 97/2000, MS Project, Excel

. Databases: Sybase, Netezza, Oracle 11g, SQL, SQL Server

. Platforms: Linux Unix,UNIX Solaris, AIX UNIX, HP UNIX, WebSphere

(Middleware),Apache, Tomcat.(Application Server, Unix Server, Linux

Server)

. Tools: Selenium - Java WebDriver, SoapUI 4.5.1, Informatica, Toad for

Data Analyst,QTP,

. ALM, Quality Center, Rational Clear Quest, SDM(for CR Ticket).

. Languages: JAVA, XML, HTML, PL/SQL,JIL (Autosys),Basic C, Korn

Shell Script

. Document Skills: Writing Test Strategy Plan, Test plan, High level

Test Scenarios, Test cases,Test Scripts for manual test and

automation test

. Testing expertise: Web API Testing, Black Box Testing, White Box

testing and Gray Box testing (Automation, Functional, SIT, UAT,

Sanity, Regression)

. Quality Standards : Six Sigma, ISO 9000

. Methodology - Agile, V model

EXPERIENCE

Standard and Poor's Capital IQ South Brunswick, NJ

October 2012 - Current

Lead Software QA Engineer - IPD and SDL

. Responsible for extensive client interaction in order to estimate

activities, design test plans/strategy and monitor the project QA

deliverables utilizing QA best practices.

. Created test strategy and test plan documents ultimately verifying the

traceability of test conditions to test cases.

. Reconciled data loads from source files into staging table and staging

table to target table by implementing tools such as SQL, Excel, and

UNIX.

. Defined entrance / exit criteria and provided continual risk

assessments to senior management.

. Defined ambiguities with the business and functional requirements in

order to clarify with Business Analysts.

. Provided test estimates for various phases of the project.

. Verified traceability of Test Conditions to Test Cases.

. Oversaw all phases of testing while coordinating with remote teams

based in Denver and India.

. Tested the Autosys job on UNIX server.

. Performed Web testing by using SoapUI 4.5.1.

. Created automated script in JAVA for Web API.

. Created automated test cases for regression phase by using SoapUI and

Selenium.

. Examined sample record sets for consistency, data corruption and

overall data quality.

. Developed and executed functional/system test cases to ensure product

meets functional and design specifications.

. Reported product bugs and bug isolations so that proper procedures

could be followed in order to rectify the bugs and issue appropriate

resolutions.

. Performed software quality management (SQM) process audits.

. Executed the duties of a change release coordinator.

. Created Change Release (CR) ticket based on CIP document (Change

Implementation Plan).

Merrill Lynch/Bank of America Jersey City, NJ

May 2012 - October 2012

Senior QA Analyst/ETL Tester (Contract)

. Responsible for building code in various environments including

QA/Autosys/UAT.

. Developed test cases and test scripts for data validation.

. Loaded data to various databases using SQL scripts and maintained a

repository for data loading scripts.

. Utilized shell scripts extensively for automation of file manipulation

and data loading procedures.

. Executed batch processing and verified job statuses and data in

database tables.

. Developed Tractability Matrix and Test Coverage reports.

. Managed and conducted System testing, Integration testing and

Functional testing.

. Extensively used the AutoSys jobs for the entire project.

. Deployed Application tag and DB tag in server and extract the data

file putting in appropriate folders by using UNIX various commands.

. Tracked the defects using Clear Quest and Quality Center and generated

defect summary reports.

. Interacted with developers, Business & Management Teams.

. Participated in regular project status meetings related to testing.

. Worked on SQL scripts to load data in the tables.

. Loaded data to different databases using SQL scripts and maintained a

repository for data loading scripts.

. Used Shell scripts extensively for automation of file manipulation and

data loading procedures.

. Worked on Apache and Tomcat to migrate new web application in QA

environment.

Standard & Poor's Rating New York, NY

August 2011 - March 2012

Senior QA Analyst (Contract)

. Worked on Data Warehouse Testing. Involved in BO report requirement

and performed business object report data validation by using SQL

quires.

. Tested all UAT release, find defects, analyzed defects, discussed

defects with assignees of defects, defect resolution, defect matrix

and re-test and regression testing.

. Expertise in gathering System Requirements from Analyst, Understanding

of Use Cases, business flow, technical Gaps.

. Assisted the project manager in developing the project schedule as it

related to Technical QA Analyst activities, dependencies and timelines

to facilitate accurate project schedules while following the

department software development life cycle (SDLC) and adhering to

standards and best practices in the department.

. Interacted with cross-functional team to install software, understand

application functionalities, resolved daily defects, blocking defects,

etc.

. Responsible for frequent communication and collaboration with

stakeholders with ability to respond quickly to the demands of

internal customers.

. Assisted the Project Manager in developing the project schedule as it

relates to Technical QA Analyst activities, dependencies and timelines

to facilitate accurate project schedules.

. Followed the department software development life cycle (SDLC) and

adhere to standards & best practices in the department.

. Performed migration testing on business object by comparing each

report for different version of BO.

. Documented UAT Test Plan/Test cases using Testing Methodology.

. Discussed Business Test Plan with internal Team and External Team.

. Reported test outcomes by collecting, analyzing, interpreting,

summarizing, and displaying data.

. Developed SQL Script to validate Data Transaction in Front End

Testing.

. Developed complicated and execute via Toad and saved Test Result.

. Utilized Unix Utilities like awk, grep, sed, vi, network, process,

file level, directory level, etc with Shell Scripting and executed all

test scenarios in minimal time.

. Worked on Web Server testing by using SOAPUI 4.0.1 and validate data

in XML

. Performed migration testing on business objective by comparing each

report for different versions of BO.

. Developed SQL script to validate data transactions in front end

testing.

. Worked on web server testing by using SOAPUI 4.0.1 and validated data

in XML.

Dow Jones & Company South Brunswick, NJ

February 2011 - June 2011

Senior QA Software Analyst (Contract)

. Responsible for validating Real -Time XML transaction to make sure all

data content is as per business requirement, identify all process

validation using UNIX utilities.

. Interacted with SDLC team to update each release QA Test Plan to cover

all business scenarios using Testing Methodology.

. Created and modifies test scripts (SQL) to validate system changes.

. Installed all new release in the multi Linux Server using network

commands and protocols.

. Loaded codes in various test servers.

. Validated real-time XML Earing feeds against broadcast studio to make

sure all data content was per business requirement.

. Validated GUI on different browsers, making sure the earning values

reflected as per broadcast feed.

Matrix Technology Group North Plainfield, NJ

July 2010 - February 2011

Senior QA Software Analyst (Contract)

. Responsible for testing Application with GUI interaction Application

Server (WAS 7.0) with Database Application in Oracle 11g on UNIX

Server (HP UNIX) via Real Time XML Transaction in http

request/response.

. Designed and developed QA Test Plan/Test Cases and provided Test

metrics.

. Developed SQL Script (Developed complicated SQL Script in Toad) to

validate data, automated UNIX based process (Using Unix Utilities like

awk, grep, sed, vi, network, process, file level, directory level,

etc.) with Shell Scripting and executed all test scenarios in minimal

time.

. Involved in key learning process after each release to implement

process in future as a part of QA process Management.

. Interacted with team to resolve daily issues in installation, code

delivery, documentation, and defects.

. Supported Change Control by reviewing impact of all modules planned

all release schedules, back out plan.

. Supported production support team in production issue to analyze root

cause of problems and resolved with team.

. Involved in different major and minor release testing by updating test

plan with testing methodology, reviewed test results and analyzed

defects and resolved with team.

TD Waterhouse Cherry Hill, NJ

April 2008 - March 2010

Senior QA Software Analyst (Contract)

. Responsible for various releases to validate testing using UNIX

utilities and SQL.

. Participated in multiple extract processes like billing Extract Error

detection report, External Party Management Report.

. Supported Ad-hoc project including production support enhancement and

delta changes to current product.

. Involved in testing of extraction process from database using back end

process and dump into data file of specific delimiter. Involved in

different release to validate testing using UNIX utilities and SQL.

. Involved in multiple extract processes like billing Extract Error

detection report, External Party Management Report.

. Support Ad-hoc project including production support enhancement and

delta changes to current product.

. Interacted with Business Analyst to understand Application Requirement

and gathered Major/Minor functionality of requirements.

. Communicated with Project Management to establish LOE of each phase of

SDLC and prioritized QA task.

. Developed SQL Script to validate Data Transaction in Front End

Testing.

. Developed complicated and execute via Toad and saved Test Result.

. Performed functional testing by deployment request, sanity testing,

prioritized QA Test Cases within project plan.

. Performed Defect Root Cause Analysis, interacted with related Team,

and tracked defects in a Test Director.

. Involved in Back End Testing using UNIX Utilities and automated

Regression Testing using Korn shell scripting.

. Assisted business and marketing teams in execution of UAT by providing

data.

. Involved in System Integration Testing with external/Internal

interface and understood overall customer business functionalities.

NJM Insurance Trenton, NJ

January 2006 - March 2008

QA Software Analyst (Contract)

. Responsible for testing of NJM Claim information System to keep track

of all Claim information related to accident including billing and

payment methods. Application had complicated GUI with Oracle/UNIX to

maintain all back end transaction.

. Interacted with business analyst team to understand business

requirement, customer expectation and experience and performed GAP

Analysis.

. Updated, maintained, and promoted Test Plans and Scripts to

Configuration Management for version control. Recorded and tracked

defects uncovered during the execution of tests scripts.

. Provided timely and accurate status defect information and appropriate

metrics to facilitate QA reporting. Reported individual status:

dashboard information, open issues, risk analysis.

. Used Quality Center to tack for defect cycle. Monitored the defect

tracking process and generated customized reports using Test Director.

. Used SQL Queries; Complicated SQL to validate Data constraints for

both Front End and Back End Testing.

. Performed back end testing like data file validation testing using

UNIX Commands. (grep, awk, sed, etc)

. Participated in test planning, test case design and test script

walkthroughs with QA Leads.

. Understood testing to be accomplished and suggested changes for

efficiencies within or between projects. Involved in QA, SIT, UAT

testing to complete release testing, sign off all interface testing

and review QA Results with team.

. Developed and sustained appropriate relationship with peers and other

project team members.

EDUCATION

SNDT, Mumbai, India - B. S. in Accounting

Professional Training - Coursework in Software Quality Assurance

Engineering

Oracle Certified In Introduction to Oracle 9i: SQL, Feb 2012

Contact this candidate