Test Cases Management

Apurva Joshi-Kulkarni

Contact: +91-860*******

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

OBJECTIVE

Seeking challenging assignments that would facilitate the maximum utilization and application of my broad skills and expertise in making a positive difference to the organization

KEY SKILL

Manual Testing, Database Testing, Customer Communication, Requirement Gathering & Analysis, Defect Management, Risk analysis, Documentation.

Oracle 9i, 10g, 11g, Grid Control 10g, 11g & 12c, SQL, PL / SQL, SQL Developer, Toad, Oracle Report server and Application Server

PROFILE:

Dedicated and versatile professional offering 4 years and 7 months of IT experience

Testing:

Completed DST (Diploma in Software Testing certification course from SQTL with A grade

Involvement in Requirements Management, Client Interactions, Test Planning, Test design, Test Execution, Defect Reporting & tracking, Regression & System Integration Testing, Test Status Reporting, Test Closure Activities.

Very good knowledge of Software Development life Cycle (SDLC), STLC, verification and validation, types of testing, configuration management, defect life cycle and Risk analysis.

Good knowledge of Black-box testing and White-box testing techniques.

Knowledge of various Testing Methodologies - Functional, GUI Testing, System Testing, Smoke Testing, Browser compatibility Testing, Regression Testing, Black box testing, designing high quality test cases, Reporting high priority defects, Retesting of fixed defects.

Proficient in detecting bugs & classifying them based on severity, priority and performing defect log management.

Manual, database and web based testing in post deployment activities for windows standalone and web based applications.

Basic knowledge of automation& test management and test execution tools QTP (Quick Test Professional), QC (Quality Center), LR (LoadRunner) and Selenium.

Oracle DBA

More than 3 years of extensive ORACLE Database Administrator experience in variety of complex business systems under Windows platform.

Strong experience in supporting Production, Development & Test databases.

Proficient in Creating Users, implementing Security and Integrity measures for Users, Monitoring and Dropping Users, Roles, Privileges and Profiles

Proficient with SQL, PL/SQL, Oracle Database Administration, Grid Control, Databases Creation, Database Configuration, Space management, Backup and Recovery, Performance Tuning and Database Maintenance, Oracle AS,Oracle ORS and EBS.

Good knowledge of Remedy/POB(ticketing tool) (Incident Management / Problem Management) and Contributed in preparing WSR MSR Monthly Reports

Involvement in Deployment processes of application and report server.

Highly articulate, demonstrates excellent relationship building within team, communication and interpersonal skills

Software Skills

Operating Systems : Windows XP, Windows 7

Database : Oracle

Testing Concept : STLC, Testing Levels, Testing Types, Test Management, Defect Management

Tools & Utilities : MS Office,QTP,QC,LR

Web Technologies :HTML

PROFESSIONAL EXPERIENCE

Projects accomplished during DST

Title

EMPDB (Standalone application)

Project Abstract

It is an Employee Database system application/software designed to maintain a database of employees in an organization

Responsibilities

Creating Test Scenarios of UI, positive & negative, Navigational and Functional Levels.

Participating in Peer Reviews

Understanding User requirement specification, designing of test case specifications, writing test cases.

Execution of the test cases.

Involved in Reviews

Bug logging and Bug Reporting in Quality Center.

Contributing in regular status meetings to state any bugs, problems and risks.

Co-operating with development group to resolve the difficulties came across in a test execution.

Documenting and communicating the test results.

Performed integration, functional & End to end testing, Regression testing.

.

Title

GMO Online catalog application(Web based application)

Project Abstract

The GMO website is a basic catalog application at a high level .With the GMO application user is able to

1. Catalogue with the product information.

2. Enter customer Ship to and Bill to information.

3. Complete the order with the receipt

Responsibilities

Creating Test Scenarios of UI, Browser compatibility, Navigational and Functional Levels.

Participating in Peer Reviews

Understanding User requirement specification, designing of test case specifications, writing test cases.

Execution of the test cases.

Involved in Reviews

Bug logging and Bug Reporting in Quality Center.

Contributing in regular status meetings to state any bugs, problems and risks.

Co-operating with development group to resolve the difficulties came across in a test execution.

Documenting and communicating the test results.

Performed integration, UAT, positive and negative, functional & End to end testing, Regression testing.

KPIT Technologies Ltd., PUNE since November’ 2010

Project Title : DBA Production Support

Client :Bestseller

Duration : April 2011- Present

Role : Associate DBA

Environment : Oracle Grid Control, Oracle E-Business Suite, Oracle Application server, Oracle Report server 10g, 11g Database Administration, Windows Platform

Team Size : 10

Project Details : Bestseller environment includes Oracle 12c, 11g, 10g databases, Grid control, E-Business suite, OAS, ORS, and Web-logic to support a big fashion brand industry. We perform regular DBA & Testing tasks:-

Testing Tasks: Manual and database, web- based testing in post deployment activities, Creating Test cases of UI, navigational and functional levels, understanding user requirement specification, client interaction, Test cases design and implementation, Contribution in regular status meetings and reviews,co-operating with developers in solving the defects, defect logging and reporting.

DBA tasks: - Code Deployment, Monitoring, Cloning, User issues and Performance Issues, Value Additions, Upgrades

Responsibilities:

As a Functional / Application DBA, responsible for handling Database Administration, handling gamut of tasks like Object level issues, Database Performance Issues and tuning, Deployments, User Management ensuring utmost customer satisfaction.

Manual and database, web- based testing in post deployment activities, Creating Test cases of UI, navigational, and functional levels, understanding user requirement specification, client interaction, Test cases design & implementation, Contribution in regular status meetings and reviews,co-operating with developers in solving the defects, defect logging and reporting

Accountable for handling Database Refresh / Cloning related activities from Production to Development/Test databases.

Responsible for identifying and troubleshooting all errors / issues related to the database / Grid Control / Application Servers / Report Servers along with maintaining logs and backups for the same

Managing database security, creating and assigning appropriate roles and privileges to users depending on the user activity.

Checking Backup issues, Space management, sending the Status report / Health Check Reports to client on daily/Weekly/Monthly basis.

OAS (ORACLE Application Server), ORS (ORACLE Report Server) and EBS (eBusiness Suite/ORACLE Apps) deployment scheduling and execution manually and with Grid Control,server maintenance activities,Heap dump analysis, Grid job execution & troubleshooting

PROJECTS ACCOMPLISHED (KPIT)

Title

Migration of Backup server

Responsibilities

1. Migrating various scripts related to server maintenance, Backup, deployments to the new virtual server.

2. Modification in batch scripts in order to make it generic and reduce number of jobs causing redundancy.

Title

Creation of Deployment related Jobs and setting notification rules in Grid control 12c

Responsibilities

Created all Production, Development and test deployment jobs with appropriate job definitions and set notification rules in GC.

PROFESSIONAL CERTIFICATIONS

Completed DST (Diploma in Software Testing certification course from SQTL with A grade.

Pursuing ISTQB certification from SQTL.

1Z0-052 – Oracle Database 10g SQL Administration-II(OCP)

EDUCATIONAL & PROFESSIONAL CREDENTIALS

B.Tech: Computer Science Engineering (2006-2010).

College/University: Maharashtra Institute of Technology (BAMU), Aurangabad, Maharashtra, India.

Result: First class with Distinction (80%).

Higher School Certificate

College/Board: S.B.College of Science, Aurangabad, Maharashtra, India.

Results: First class (68%).

Secondary School Certificate

School/Board: ShardaMandir Girls School, Aurangabad, Maharashtra, India.

Results: First class with Distinction (80%).

EXTRAMURAL ATTAINMENTS

Won State level Classical Singing competitions

Participated in various Dance and Music, Harmonium play Stage shows.

PERSONAL DOSSIER

Date of Birth :10th Nov, 1988

Linguistic Proficiency :English, Hindi and Marathi

Marital Status :Married

Passport : Yes, Valid till 2023 (Details can be provided if asked)

Contact this candidate