APARNA CHATTERJEE

248-***-**** aczbux@r.postjobfree.com

SUMMARY

Software Quality Assurance Analyst around 3.5 years of industry experience in Automation and Manual testing using tools such as HP Quality Center/(ALM),Selenium Web driver, SOAP UI and HP QTP and Automation testing of both front end and backend applications using Selenium and Java based Frameworks.

In depth knowledge of the Business process development using Software Development Life Cycle Waterfall, AGILE and testing using Software Testing Life Cycle (STLC).

Experience in Data modeling, Database Design, Programming, Testing, Development and Implementation of Client-Server Applications & Database Systems using MS SQL Server

Extensive knowledge on PL/SQL components like Procedures, Functions, Cursors, Packages, Triggers

Experience in using ETL tools for Extract, Transform and loading of the data from different sources to targets which includes relational source, flat files etc.

Experience in creating various type of reports such as Complex drill down & drill through reports, and Charts using SQL Server Reporting Services (SSRS) based on Relational

Expertise in designing and developing testing documents as Test Plan, Test Cases, Test Procedure.

In depth knowledge of the Business process development using Software Development Life Cycle Waterfall, AGILE and testing using Software Testing Life Cycle (STLC)

Experience in Front-End Testing and Back-End Testing, Performed Black Box Testing on Web-based application.

CORE TECHNICAL SKILLS

Internet & Web Technologies: HTML,CSS, JavaScript, JQuery,ASP.NET

Programming Language: Java, C#

Databases: MS SQL Server 2014, 2012, 2008 R2, 2005

ETL Tool: Informatica

Reporting Tool: SSRS

Testing Tool: Selenium, HP ALM, HP Quality Center, HP UFT/QTP, Load Runner, TestNG, MTM

EDUCATION

Master of Science, Information Systems, May 2015

Bachelor of Engineering, Computer Science and Engineering, May 2011

PROFESSIONAL EXPERIENCE

1.Company Name: AAVISPRO LLC, Somerset, NJ

Position : Quality Assurance Analyst

Client: Hunter Roberts Construction Group, NYC, NY

Start Date: April 2016 – January 2017

Tools & Technologies: HP ALM, Selenium Web Driver, JavaScript, HTML, XML, TestNG, Eclipse IDE, SVN, Github, ASP .NET, C#, JQuery, JIRA, SQL Server 2014.

Responsibilities:

oReview Business requirements and manual test scripts with Business SMEs, Created QTP (Quick Test Professional) scripts based off these requirements.

oDesigning Hybrid framework and automating regression cases using UFT.

oPerformed end-to end testing on applications manually with HP ALM.

oDesigned Jenkins job for continuous integration to kick start smoke test with no manual effort.

oInvolved in designing Hybrid and page object model framework using selenium web driver, maven and TestNG which involves multiple systems GUI, DB and web services.

oDeveloped T-SQL Queries, stored procedures and user defined functions; ensured optimal performance of the queries. Supported activities like Updating procedures, functions, triggers based on the change request from users and those arising from changing business needs.

oDesign and develop database solutions using tables, stored procedures, functions, views and indexes.

oProgramming using SQL and SQL/RDBMS utilities.

oInvolved in maintaining selenium automation code in SVN and GitHub.

oDesigned Jenkins job for continuous integration (CI/CD).

oInvolved in Defect Tracking and Management using JIRA tool.

oPrepare report for entire project and send status to stakeholders.

2.Company Name :Cognizant Technology Solutions, Chennai, India

Position: Quality Assurance Analyst

Start Date:January 2012

End Date: June 2014

PROJECTS

I.Client: ComputerShare(January 2013 – June 2014)

Role: Quality Assurance Analyst

Environment: HP ALM, REST, JIRA, REST, WSDL,Parasoft, Eclipse IDE, Java, Selenium IDE, SOAP-UI,SQL Server 2010.

Responsibilities:

oInvolved in reviewing Business Requirement Documents and Prepared Technical Specifications, Test Scenarios and Test Cases as per functional, business requirements using HP ALM.

oCarried out Functional testing in varied areas of: Front-end, System testing, Regression testing, UAT support.

oPerformed back end testing by writing and executing SQL queries to validate that data is being populated in appropriate tables and manually verify the correctness of the data with front-end values.

oInteracted with users by conducting User Acceptance Testing (UAT) to ensure that the total functionality of the application was met by complying with all the business requirements.

oInvolved in creating a Java framework for automation of SOAP and REST web services.

oInvolved in testing the WDSL and REST API services using soap-UI Pro.

oDiscussed with team lead and Project Manager regarding testing deadlines and post deployment validation.

oProvided test summary documentation and analyze test results, identifying trends and/or root causes of problems.

oInvolved in End to End of Test Reporting namely: Requirement Analysis, Preparation of Test Plan, Test Script and Test Data, Test Execution and Reporting, Defect Management using JIRA Assuring the quality of testing and deliverables, Providing Daily status to client.

II.Client: Bank of New York and Mellon(January 2012- December 2012)

Domain: Banking and Financial Services

Role: Quality AssuranceAnalyst

Environment: HP Quality Center 10,HP QTP,TestNG, MS SQL Server 2008, JavaScript, SOAP-UI,XML, CSS,Bugzilla.

Responsibilities: -

oInvolved in analyzing Business requirements, Functional Specification Documents and created Requirement hierarchy in HP Quality Center.

oDesigned test cases for manual testing, developed and maintained checklists for regression, functional and system testing.

oActively participated in scrum meetings, reviews and developed test scenarios in agile environment.

oInteract with developers to resolve technical issues and investigate software for defects.

oPlanning, designing, implementing and maintaining Hybrid framework using HP QTP.

oAutomating the QA stories using HP QTP at both sprint level and Regression level.

oAnalyzed the responses of the web service using SOAP UI and validating the data in backend.

oUsed HP QTP to run automation scripts on multiple platforms and multiple browsers.

oWorked with software testing methodologies with all phases of testing desired (Functional, System, Integration, Regression, Data Validation, GUI, User Acceptance and Automation testing).

oInteraction among team members, development team to resolve issues.

oInvolved in using Bugzilla for defect tracking and was responsible for bringing all severity bugs using to the notice of QA Manager and performing root cause analysis for the defects caught after implementation.

Contact this candidate