KESHVI KHATRI

Quality Analyst

Cell: 952-***-****

E-mail: adba20@r.postjobfree.com

Sunnyvale, CA

PROFILE

Quality assurance professional with 6.5 years of experience in Database, ETL, Mobile, Web and Functional testing in e-commerce, health care, Enterprise Data Management and Finance domains

Hands on experience working with Agile and Waterfall models

Experience with standard testing fundamentals and ability to quickly acquire business and technical knowledge to come up with detailed test cases

Basic knowledge on warehouse management tools like Oracle, SAP, Magento and JDA

Ability to focus on customer service and communicate with technical teams

Ability to learn new technologies and implement successfully

Worked extensively on various SQL databases and ETL tools

Have lead QA teams and worked on offshore on-site models

Interacted with clients on a daily basis for requirement clarifications

Strong communication, analytical and problem solving skills

PROFESSIONAL EXPERIENCE

FYA GROUP - CLIENT: E-commerce

Quality Analyst Nov 2018 to Present

MyPetShop.in is an e-commerce platform that allows pet owners to meet their pet needs from birth. It supports complete supply chain, warehouse, inventory management and B2C.

Responsibilities:

Worked closely with the Business analyst and developers to create test scenarios based on the functional specifications

Creation of test cases and test data

Performed database testing using complex SQL queries to test inventory, order management and order processing work-flows

Performed functional and User interface testing for the website

API testing using REST and SOAP

Handson experience using POSTMAN for API Testing

Performed cross browser testing

Tracked defect closure and pre launch regression testing

Technologies and Tools: MySQL, Magento, Microsoft office tools

CITIUSTECH LTD. - CLIENT: Davita Dialysis

Quality Analyst Sept 2014 to Feb 2016

FA FlightDeck - Creation of initiatives by healthcare administrators within various dialysis centers and their tracking to closure.

Responsibilities:

Test lead activities:

Preparing Test estimates, test case review

Attended sprint planning, daily stand-ups and sprint reviews

Interacted with Product owner and Business Analyst to understand requirements

Testing activities:

Creation of Requirement clarification document after analyzing the user stories

Reviewing database schema document and creating test scenarios

Creation of test scenarios and test cases and uploading them to Quality center

Creation of test plan and test lab in Quality center

Developed complex SQL queries for data verification purposes

Executed stored procedures to verify data flow between source and target tables

Mobile testing on iPhone, iPad and Perfecto

Performing desktop and mobile based Smoke, Database, Functional, Regression, Adhoc and Integration testing using agile methodology

Performed browser compatibility testing

Technologies and Tools: SQL Server 2008, .NET, Perfecto, HP Quality Center, iPad, iPhone, Agile

TECHNOLOGICAL EXPERTISE

SDLC : Agile, Waterfall

Technologies: PL/SQL, ETL, HTML

Operating systems: Windows, UNIX

Test Management Tools: Quality Center, TestLink

Defect Management Tool: Bugzilla

ETL Tools: Informatica Powercenter 8.6.0, Oracle Data Integrator

Databases : Oracle 10g, Oracle 11g, Sybase 12.5.0, SQL Server 2008, MySQL

Mobile devices: iPhone, iPad

Mobile Tools: Perfecto, Appium

Project Tracking Tool: JIRA

ACHIEVEMENT S AND CERTIFICATION

ISTQB Foundation Level certification in Software Testing

NCFM ‘Financial Markets: A Beginners' Module’

Co-authored 2010 IEEE Publication - A decision support system utilizing a semantic agent

EDUCATIONAL QUALIFICATION

Bachelor of Engineering (Information Technology) June 2010

Sardar Patel Institute of Technology, Mumbai Aggregate: 70.44%

GOLDENSOURCE - Clients: Finance

Quality Analyst Apr 2013 to Sept 2014

Data Lineage- Verification of data coming from the vendor, being transformed through the mapping and loaded into the database based on certain pre configured rules. Verification of data on the user interface with the data loaded into the database.

Data Warehouse- ODI: Load the data into data warehouse tables from the GoldenSource data model.

Responsibilities:

Requirement gathering and scenario creation

Set up Test Lab and creating test cases in TestLink

Developed and used SQL queries in backend testing of databases

Testing ETL mappings and transformations for data loads into the data warehouse

Performing Database, ETL, Functional and Integration testing on Enterprise Data Management applications using agile methodology

Status reporting and maintaining traceability matrix

Verification of product documentation

Coordinate trainings for the QA team

Technologies and Tools: Oracle 11 g, Testlink, Oracle Data Integrator, Bugzilla

INFOSYS LTD. - Client: Capital Group companies

ETL/PL SQL Developer Aug 2010 to Mar 2013

RDM-IDH integration- Deals with the creation of ETL mappings using Informatica to cater flow of data between databases.

Asset Setup and Maintenance- ASM applications collect data from various third party data providers like Reuters, Telekurs, Bloomberg etc. or users create assets through the user interface provided to them.

Responsibilities:

Interpreting the customer requirements, creating detailed analysis report and estimation

Development, maintenance and testing of ETL mappings and workflows using Informatica Powercenter

Testing of Autosys jobs, Unix shell scripts and PERL scripts

Developing and testing stored procedures using PL/SQL

Creating test cases, test plan and managing them using Quality center

Create checklists for testing standards, application setup and execution documents

Regular interaction with on-site coordinator and presenting daily project updates

Technologies and Tools: Informatica Powercenter, Oracle 10g, Sybase 12.5.0, PL/SQL

Contact this candidate