Qa Tester Analyst

Senior QA Analyst

adrwit@r.postjobfree.com,610-***-****

Summary:

Around 8+ years of IT experience in the area of Salesforce, Extraction Transformation and loading(ETL) /Data warehouse/Functional testing in different domains like HealthCare, Telecom, Banking and Finance Solutions, Retail and Media Research.

Experience in Salesforce – Lightning and Classic Version.

Performed Back End Testing by executing SQL queries and performed data validation

Great experience in managing projects in Agile/Scrum and waterfall models

Areas of expertise are Effort estimation, Requirement Analysis, Test Planning, Requirement Traceability Matrix (RTM), Test Execution, Defect Tracking, Status Reporting, Training, Documentation, Creating User Manual for ETL and web based applications.

Experience in handling Google Spanner (Google Cloud Platform) Environment and validated the flow of data till Reports.

Extensive experience in GUI, Regression, Functional, Integration, System, End-to-End UAT, Sanity Testing

Extensive knowledge of SDLC (Software Development Life Cycle) and STLC methodologies.

Preparation of Defect Metrics and Productivity Metrics for the team, worked as back end tester worked in creating manual test cases in Quality Center/ALM

Experienced with SOA, Web Services, Java Script, SOAP, SoapUI, WSDL technologies.

Well versed with Exploratory Testing, Mobile testing, Database Testing SQL, Localization Testing

Extensively used SoapUI and Postman for API testing and have good Understanding of Web Services (REST and SOAP)

Completed ISTQB-ISEB Certified Tester – Foundation Level

Proficient in Web Service testing using SOAPUI tool and expert in reading and validating WSDL

Expertise in Test Management using the HPALM(Quality Center) and JIRA for requirements, Test Cases and Defect tracking

Participated in design walkthroughs and verified QC Test Scripts and results.

Excellent analytical, problem solving, presentation, and interpersonal skills.

Good team player with excellent communication skills, Client Management Skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment

Technical Skills:

Testing

ETL, Client Server, Selenium Web Driver, Postman, SOAP UI, Data Warehouse, Mobile, Functional, System, HP ALM, Jira, Bugzilla

Operating Systems

Windows 10, UNIX

ETL/CRM Tools

Salesforce, Informatica Power Center, Oracle Data Integrator(ODI)

Languages Known

Java, SQL, C, C++

Markup Languages

XML, UML, HTML, CSS,JSON

Databases

Netezza,Oracle 9i/ Oracle 10g, DB2

(Tools used: TOAD Data Point, SQL Developer)

Tools/Special Software

HP Quality Center 10.0,Rally, JIRA, ALM, Fitnesse(Semi-Automated Tool), Mastercraft 5.0 / Mastercraft 7

Reporting/Scheduling Tools

ActiveBatch V12 /Jasper Ireports 3.2/IBM Cognos Analytics

Educational Credentials:

Master of Computer Applications, India-2008.

Visa Status: Green Card

Professional Experience:

Client: Davita Jul 2019 – Till Date

Role: Senior Analyst, Quality Assurance

Responsibilities:

Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in Application lifecycle management (ALM).

Performed testing on Google Spanner (GCS) by running the SQL Queries and validated the flow of data to Target DB (Netezza) and to reports.

Used Informatica Power Center as an ETL Tool for extraction, transformation and loading (ETL) of data into the Enterprise Data Ware House (EDW).

Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables

Performed testing in Cognos Reports (IBM Cognos Analytics) by running the SQL Queries on the database by reviewing the report requirement documentation.

Involved with ETL test data creation/Identified for all the ETL mapping rules.

Performed various types of testing including Sanity Testing, Smoke Testing, Functionality Testing,

System Testing, Upgrade Testing, Positive and Negative Testing, Security Testing, Cross-Browser Testing, Integration, User Acceptance(UAT),Regression and End-To-End Testing (E2E)

Analyze application requirements and build the Interface design documents by Interacting with the Business Team(Users)

Acting as first point of contact for client/Users queries and calls

Worked on Informatica/Cognos Upgrade on continual basis.

Organization: Laksan Technologies Nov 2016 – Jun 2019

Role: QA Tester

Responsibilities:

Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in Application lifecycle management(ALM)

Used Oracle Data Integrator as an ETL Tool for extraction, transformation and loading (ETL) of data into the Enterprise Data Ware House (EDW) and Micro strategy as a reporting tool.

Used Firebug and Firepath to debug, edit and locate the objects based on ID, Name, Path, CssSelector, Link, Partial Link Attributes, and Tags

Extensively used XPATH, Regular expression, and classes to perform UI actions. Exported output/reports for all automated testing results

Extensively used SoapUI, Java Script and Postman for API testing and used all the web methods like GET, POST, DELETE, etc

Involved in validating functional, Integration and Regression test suites using Selenium and to check the request and response of the Web Services (SOA) through SOAPUI

Used SOAP UI for test data setup in Test Driven Development.

Used SOAPUI tool to test SOA based architecture application to test SOAP services

Involved in creating automation test suites for progression & regression testing in SOAPUI. The messaging formats included SOAP over HTTP based clients with XML payload

Logged the defects using HP Application Lifecycle Management (ALM) and assigned them to corresponding developers.

Performed CRUD operation and verification ACID Properties with SQL.

Client: AC Nielsen Project, India July 2011 – June 2014

Role: Senior QA Tester

Responsibilities:

Analyzed requirement documentation, functional specification, design documentation and translated the functional requirements into Test cases.

Developed Test Plan, Test cases, test scripts, complete the Peer review process, executes test cases execution records (TERs) record test results and attached test artifacts with applicable screen shorts in the RQM.

Extensively used IBM Rational Quality Manager (RQM)

Followed Agile Methodology to emphasize on real time communication over written documentation and to minimize risk by implementing software test effort in short time sprints or iterations.

Logged into the defects using KISAM and linked the defect with RQM assigned them to corresponding developers.

Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.

Reported outstanding bugs, followed up bug fixes, conducted review of existing test scenarios and assessed the need for their enhancement.

Client: Tata Communications, India March 2011 – July 2011

Role: Senior QA Tester

Responsibilities:

Developed detailed Test strategy, Test plan, Test cases and Test procedures using ALM for Functional and Regression Testing.

Worked with Business users and Assisted UAT & Development teams to mock up data to meet test scenarios.

Performed Semi-automated data warehouse testing using fitnesse tool & SQL to ensure data integrity and accuracy with respect to evolving requirements raising defects for any discrepancies in functionality.

Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.

Writing shell scripts in UNIX to check the data integrity during the data transfer.

Performed database validation using SQL queries which included complex joints in the UDB tables

Logged the errors, reported defects, determined repair priorities and tracked the defects using HP Quality Center.

Client: Interconnected Stock Exchange, India April 2010 – Sept 2010

Role: QA Tester

Responsibilities:

Created Test Scripts, Test Cases and Test Data in accordance with Software requirement specifications.

Performed Database testing by writing and executing SQL queries by using SQL & TOAD to validate that data is being populated in an appropriate table and manually comparing the results with front-end values.

Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from other technical teams.

Developed test scripts based on business requirements and processes, in line with defined workflows and use cases.

Responsible for DATA validation on data marts by using SQL queries.

Responsible for creating manual test scripts to include Functional Test, Regression Test, Compression test, UAT, Data Migration Test and Study Configuration Test.

Validated the count and data Scenarios through Data Validation Tool.

Logged the errors, reported defects, determined repair priorities and tracked the defects using HP ALM.

Worked on uploading all the Test cases to the HP ALM for the current and prior releases.

Client: Interconnected Stock Exchange, India Jan 2010 – March 2010

Role: QA Tester

Responsibilities:

Responsible for SDLC which includes design, document, planning, development, deployment & End to End testing.

Developed Test Plans based on Test Strategy. Created and executed Test Cases based on Test Strategy and Test Plans using ETL Mapping document.

Walk through of the Test Plan and Test Cases with Business users and Project Team to finalize the Testing approach.

Scheduled Control-M jobs for Data Migration across various environments.

Used complex SQL Queries in extracting data from Data Warehouse and Data Marts.

Maintained test cases and results in HP ALM. Tracked defects in IBM Rational Clear Quest (CQ). Performed Root Cause & GAP analysis to fix the defects found during testing.

Extracted Data from MDH, flat files, DB2 and other platforms using Oracle Data Integrator (ODI) to the target database.

Identified various Business and Data Test Scenarios based on Source to Target Mapping and assisted in the preparation of extensive set of validation test case to verify the data.

Worked with Business users and Assisted UAT & Development teams to mock up data to meet test scenarios.

Client: Kuwait Clearing Corporation, India Sep 2008 – Jan 2010

Role: Application Developer /Tester

Responsibilities:

Involved in Business requirements, IT Design documents and prepared Test Plans for all assigned project releases.

Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.

Understanding requirement and design documents

Documented test cases and performed peer reviews on the team mate’s work

Involved in Test data identification and gathering

Execution of manual test cases

Prepared Automation Test Design documents

Design and develop test automation scripts. Execute the automation test scripts and consolidate the test results

Automated the process of preparation of Input XML with valid test data and validation of response XML for various order types

Identified, analyzed, documented defects and closing of defects after retest

Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline.

Defects were tracked, reviewed, analyzed using Test Director.

Ensure that all the test cases are updated in the Test Director along with Master test plan.

Contact this candidate