Quality Analyst Sql Server

Ruchika Sareen Modi

Phone: +1-405-***-****

E-mail: ***************@*****.***

Objective

To work in a challenging role in Software Testing that gives me an opportunity to use my knowledge, experience and skills for the benefit of organization and at the same time allows me to grow as a professional.

Summary

Worked in J P Morgan Chase as a Quality Analyst from March 2022-April 2023

Worked for 7 Years in Tata Consultancy Services as Quality Analyst, Java Developer and Production Support Engineer from November 2008 to March 2014.

1+ year of experience in Jmeter, Cypress, Selenium Automation tool for regression and functional testing

6+ Years of experience with full system development life cycle experience, including designing, developing and implementing test plans, test cases and test processes fueling swift corrective actions, significant cost savings and fault-free audits.

6 months of experience in Performance Testing with JMeter .

2 Years of Experience in developing Java based SOAP web services for mobile applications which are mobile platform independent, developed Push Notification feature using Quartz Trigger and other Java API’s.

2 Years of experience in leading the Middle ware team.

Following tools were used during testing: HP ALM, JIRA, SQL Developer 2.3, Perfecto Mobile, SQL Server- 2012, MS Office-2007 and SOAP UI 2.0, Jmeter-2.10, Java, Git Hub, Node.js

Education

Bachelor of Engineering (Information Technology)

Rajiv Gandhi Technology University, India

Certifications

SUN Certified Java Programmer (SCJP)SE 5

International Software Testing Qualifications Board (ISTQB) Foundation

Skills

Tools

Operating Systems: Windows-9X/NT/2000/XP/7, UNIX/LINUX

IntellJ Idea2021.3, GitHub, Jmeter 5.4.3, Eclipse 3.4, J Boss 4.2, Tomcat 6,

HP ALM- Quality Centre 11.0. JIRA, Perfecto Mobile.

Toad for My SQL, SQL Developer 3.1, MS SQL Server 2008,2012,Apache Jmeter

Open Office MS Excel 2007,2010

Remedy Ticket Management Tool

Professional Experience

Whole Sale Facility

Job Title

Client

Tools

Job Description:

Responsibilities

Duration

Quality Analyst

In House Application J P Morgan Chase

IntelliJ Idea, J meter, Git, Oracle Sql Server,Selenium,Cypress,Jira,Q Test

Worked in banking credit risk domain on policy based web application.

Perform Manual, Automation and API testing using Jmeter, cypress, selenium .

Understand business requirement, create a test approach, identify scope of testing with risk based approach for each feature or scope of work in a project effort identifying test environments, dependencies,constraints,prioritizing test cases and scheduling time for the testing

Responsible for enduring end to end testing methodology including all appropriate documentation and requirements.

Responsible for creating,executing and maintaining automated regression suite that contain more than 2000 test cases

Worked on Jira for requirement verification & logging testing activities also prepared test cases in qtest and linked that with jira.

Participate in requirement gathering sessions,UAT sessions, retrospective, sprint planning and release planning sessions.

Understand and prepared regression test scripts for integrated application using Cypress and selenium tool.

March 2022 – April 2023

TOP10 Mobile App

Job Title

Client

Tools

Job Description:

Responsibilities

Duration

Team Lead(Testing)

Nielsen (USA)

HP ALM- 11.0, Perfecto Mobile, Microsoft SQL Server Studio, MS Office.

TOPTEN is an iOS/Android application developed to get Top 10 entry details for different categories (Books, TV, Movies, Music, Websites, Products, Video Games and Mobile Apps). User can create his/her profile on app and can explore the Top 10 list based on the demographics entered while profile creation or at run time. User is also able to see the description and Images of each entity. User can also see the last day/week/month rank of the required entity.

Prepared Test Strategy Document, Test Summary Report

Estimates for all QA activities, as needed.

Resource management (allocation, monitoring, motivating, etc)

Design and development of test cases for regression, systems, integration and continuous testing during the development cycle

Develop and implement Testing suite as specified in technical specifications/software design documentation

Communicate with the development and support team issues found and build test cases to expose weaknesses in the software

Ensure projects are delivered according to project times .Ensure adherence to testing best practices and testing standards

December 2012 – October 2015.

POS Testing

Job Title

Client

Tools

Job Description:

Responsibilities

Duration

Tester

99 Cents Only Stores (USA)

POS, MS SQL Server 2008, SharePoint.

99 Cents Only Stores is a price-point retailer chain based in Commerce, California. The store offers products at $0.99 or more . This project involves testing of POS devices in Lab. Mainly it will cover functional, regression and performance testing. As the project is new the requirement gathering is still in progress.

Helped in preparing SOW for the project, Helped in preparing Estimation.

Helping in POS Test Lab setup, Understanding the requirement.

Helping in getting the Software’s (evaluation copies) on machines.

Understand the test cases and divide among offshore and onshore teams, Understand the business requirement,

Helped in audit activities. Prepared one PI project and helped in others PI project

Prepared a relationship site in SharePoint and customize it accordingly.

May 2012 – Dec 2012

Project Details:

International Shipping

Job Title

Client

Job Description:

Tools

Responsibilities:

Duration

Tester

ToysRUs (USA, Canada, Central Europe, France, Iberia)

The project provides the ability for customers shopping on the US TRU and BRU Web stores to ship purchased items to international addresses. The products will be picked and packed like normal orders (at a B&M store or FC) and then shipped to a third party vendor’s warehouse .The packages will then be exported and delivered to the guest at the international address.

SQL Developer 2.3, UNIX, HP ALM, MS Office, Sharepoint

Understand the business requirement, Prepared Test plan, Test data, and Map the functional and non-functional test cases to the business requirement, Prepared Traceability Matrix.

Execute Manual Test cases; setup HP ALM, log test case status in QC. Also log defects in QC.

Perform database testing manually mainly data validity and data integrity testing.

Validate the data in the feeds loaded correctly in database.

March 2011- May 2012

Project Details:

RiteAid Mobile App

Job Title

Client

Job Description:

Tools

Responsibilities

Duration:

Module Lead

Rite Aid (USA)

This application prepared for different mobile platforms where end user manage patient's pharmacy history 24/7,patients can get prescription reminders via phone, manage pharmacy transfer,prescriptions history, prescription details, online refills from bottle, Can get all of riteaid advertised weekly specials from Weekly Circular, Can locate drug store near to user. This application built on two mobile platforms Android 2.3 and I-Phone(4&5)

Eclipse 3.1, Axis 2 Engine, Toad for My SQL, MS SQL Server 5.1, SVN, Sharepoint,Selenium RC and Selenium Web driver

Prepared soap based web services in Java using axis 2 engine for following modules: Transfer Prescription from one store to rite aid, Checking medicine availability in CRM, Weekly Circular for page and product, Wellness Points.

Worked as a Module Lead, Managed team and allocated the modules in a proper way, Taken knowledge transition from web portal team.

Prepared security Module to implement security functionality

Perform Mobile - Web service integration testing and unit testing.

April 2009 – March 2011

References

References can be shared upon Request.

I hereby declare that the information furnished above is true to the best of my Knowledge.

Ruchika Sareen Modi

Contact this candidate