Professional Experience Test Cases

Manish Garg

Contact: +91-782*******

E-Mail: *************@*****.***

CAREER OBJECTIVE

To secure challenging positions in the Information Technology Industry with an organization that values talent and encourages growth. I am seeking a challenging position which provides the opportunity to further enhance my career. Based on my professional background and experiences, I believe that I will make significant contributions to your company.

PROFILE SUMMARY

Master of Computer Applications (MCA) in 2014 with 64% from DAV Institute of Management, Faridabad affiliated to Maharshi Dayanand University, Rohtak.

An innovative thinker with entry level experience in database administrator & software, database testing.

Abilities in analyzing & interpreting unique problems, with a combination of project experience and logical thinking to find the right solutions.

Good on monitoring database, SDLC (software development life cycle), STLC (software test life cycle).

Focused & goal driven with strong work ethics and commitment to offer quality work.

Excellent at assessing the resources and identifying the opportunities.

Excellent in coordinating with seniors.

Sound knowledge of Windows XP, 7 & 8, Windows Server, Red Hat Linux & SQL Language ACADEMIC DETAILS

Master of Computer Applications (MCA) in 2014 with 64% from DAV Institute of Management, Faridabad affiliated to Maharshi Dayanand University, Rohtak.

Bachelors of Computer Application (BCA) in 2010 with 63% from DAV Institute of Management,

Faridabad affiliated to Maharshi Dayanand University, Rohtak.

12

th

passed from N.I.O.S, Jind (Haryana).

10

th

passed from CBSE, Certified School, Jind (Haryana). IT SKILLS

Operating Systems: Windows 2000 / 2003 / XP, UNIX, Linux, Solaris, Windows Server Databases: ORACLE 9i, 10g, 11g

Languages: SQL

Application: Microsoft Office (Word, Excel & PowerPoint) Tools: Server network monitoring tool (solarwind), defect Management tool (Bugzilla), Oracle Enterprise manager console. Remote Management tools, Testing: Manual Testing of Web applications, bug tracking software and database testing. Familiar with SQL queries using complex joins, grouping, nested sub queries, cursors, etc. Good understanding of SQL queries, Database queries, operating system and networked system. User/Group Management, File/Folder Permissions management, managing sharing resources. Remote management Using tools like Remote Administrator, VNC Viewer and Remote Desktop. Creating / Managing and working with Virtual pc and virtual networking using tool Microsoft virtual machine, Vmware Workstations.

WORK EXPERIENCE

Working as Software test engineer (Manual+Database) in Janus Koncepts from Oct. 2016.

Worked as Software Test Engineer (Manual+Database) in Test Yantra Software Solutions India Pvt. Ltd. from

June 2016 - Sept 2016.

Worked as ORACLE DBA in M Intergraph System Pvt. Ltd. from Nov. 2015 - May 2016. PROFESSIONAL EXPERIENCE 1

Project Title: Online construction market

Duration: Oct. 2016 to till date

Database: Oracle Database

Platforms: Red Hat Linux, Windows

Role: Software Test Engineer

Description: Janus Koncepts is a well-established digital brand in Delhi, which is developing a online construction project.

Now it will comes with an exclusice marketplace for construction professionals and services It will Provide platform for all construction related activities like Project Management services, Planning,, budgeting and physical execution of projects. Roles & Responsibilities:

Understand project requirements and Involve in test planning and a detailed report of what kind of resources we need to execute the task.

Execute all test cases from a test suite and getting pass/fail results in excel sheets for each test case.

Perform SQL join queries to check the data from different-2 tables/databases, as a part from database testing.

Participate in Team meeting for the discussion of project completion task & test cases with the project team.

Interacting and coordinating with development team.

Handled responsibilities of supporting QA Analyst in fixing database issues to meet client requirement.

Responsible for raise the bug with the help of tool (bugzilla) in a disciplined manner for the understanding

of developer.

Coordination with development team for updates or defects. PROFESSIONAL EXPERIENCE 2

Project Title: MCD workbench (Municipal corporation of Delhi ) Duration: June 2016 – Sept 2016

Technology: Java, Oracle Database

Platforms: Windows XP, Windows 7, Windows 8,Windows 10 Role: Software Test Engineer

Description: MCD workbench is a web application used by Architect/Engineer/Supervisor for sanctioning of building plans with MCD, NOC application submission, select confirm documents, Editing the NOC application after refereed back by NOC department. NOC form application includes: Delhi Fire service, Chief Inspector of Factory, Delhi Metro Rail Corporation, National Monument Authority, Delhi Urban Art Commission. Roles & Responsibilities:

Execute the test cases in test suites and running all test cases from a test suite and getting pass/fail results in excel sheets for each test case.

Participate in Team meeting for the discussion of project completion task & test cases with the project team.

Allows parameterization of the test case’s request fields so that a test case can use different values from a table or database.

Creates test cases directly from the web method request and a test case will be created and added to a test suite.

Interacting and coordinating with development team.

Handled responsibilities of supporting QA Analyst in fixing database issues to meet client requirement.

Responsible for raise the bug with the help of tool (bugzilla) in a disciplined manner for the understanding of developer.

Responsible for test plan procedures by coordinating with QA Analyst.

Worked on the basics automation tool for testing developed by tech Mahindra’s.

Responsible for the count efforts in excel sheet for the work provided by Team Leads. PROFESSIONAL EXPERIENCE 3

Project Title: BSES

Duration: Nov. 2015 – May 2016

Client: BSES (Rajdhani Power Limited)

Technology: Visual basic 6.0, Oracle 9i Database

Platforms: Windows XP, Windows 7,Windows 8

Role: Database administrator

Description: BRPL distributes power to an area spread over 750 sq. Km with a population density of 2665 per, sq. Km It is over 21 Lakh customers are spread in 19 districts across south and west Delhi. BSES singular mission has been provide reliable and quality electricity supply. Roles & Responsibilities:

Worked with four Productions and their Standby Database of varying sizes 2 TB to 4 TB in Solaris, Linux and Windows Platform.

Database Monitoring – 24*7 monitoring of servers (Production and Standby Database servers).

Installation of Oracle Database and Client software on user system.

Responsibilities to make the defect sheet in excel.

Database testing while executing the positive or negative scenario through front hand & data is updated or not in backhand.

Worked with four Productions and their Standby Database of varying sizes 2 TB to 4 TB in Solaris, Linux and Windows Platform.

Identified all errors present in database and coordinated with DBAs and resolved all issues.

Database Monitoring – 24*7 monitoring of servers (Production and Standby Database servers).

Installation and Administrating High Availability – Data Guard (Standby Databases).

Monitoring of all server disk space or mount point & logs.

Checking for errors in Alert logs and Trace file.

Worked on Servers (Linux/Solaris/Windows Server) time to time when needed.

Check all archives on standby database servers whether applied or not

Database performance Monitoring through daily check of schema gather of all database.

Enforcing security by creating roles, granting system and object privileges on the tables and stored procedures.

Working with Oracle Enterprise manager console to operate database.

Taking Database Backup in magnetic tape like Data and LTO Ultrium using third party management

library tool Networker Legato Software.

Monitoring all server network status using SOLARWIND.

Managing NAS Server like user & folder creation, quota, access permission.

Archiving old records and Tablespace monitoring and reporting to automate database operation using crontab and database monitoring.

PERSONAL DETAILS

Name: Manish Garg

Father’s Name: Shiv Kumar Garg

Date of Birth: 01/07/1988

Languages Known: Hindi, English

Place: Faridabad

Marital Status: Single

Sex: Male

Contact this candidate