Engineer Sql Server

S.Saravana Bhavan

Flat No. *, Sai Krishna Residency, 10th A 998-***-****

Main, Devarachikkanahalli Main Road, Bangalore *********@*****.***

- 76.

Career Objective

Seek a challenging position as a Software QA Engineer/Lead in a competitive

and growing environment that will give me opportunities of leveraging my

professional skills towards achieving the organizations goal.

Summary of Experience

. Around 4 years experience in Product and Web based applications Testing.

. Well-versed with all stages of Software Development Life Cycle (SDLC),

Software Testing Life Cycle (STLC) and Agile Testing Process.

. Well-versed in Test Environment setup. (Installation and Configuration

of Oracle, SQL, IBM Websphere and Oracle Weblogic Application Servers

and Deployment of Build)

. In depth knowledge of creating and maintaining Virtual servers using

both VMWare and Oracle Virtualbox.

. Proficient and Extensive work experience in Manual Testing.

. Performed Smoke, System, Sanity, Regression, Ad-Hoc, End-to-End

functional and User Acceptance Testing.

. Hands on experience in preparing Test cases, Test data and reviewing and

executing the same.

. Expertise in analyzing the results and reporting suggestions and defects

. Good Exposure on Bug Life Cycle.

. Hands on experience with SQL Queries.

. Worked closely with development and Technical support teams to resolve

quality issues.

. Ability to work under tight deadline with multiple release handling.

. Skilled on Problem solving and Trouble shooting, experienced on test

issue and root cause evaluation.

. Led a team of QA Engineers through the entire project life cycle.

Verified the project goals met current and long term corporate

objectives.

. Excellent People management skills including evaluating suitability or

resource for project, performance monitoring & feedback, mentoring,

motivation, people development and interviewing people.

Technical Skills

Testing Skills : Manual Testing

Operating Systems : Windows 95, 98, XP, 2000, 2003, NT, and MAC 10.4 &

10.6

Bug Tracking Tool : NEWTS - In-house tool

Databases : Oracle, SQL Server and MS-Access

Application Servers : Oracle BEA WebLogic v9.2 & 10.3 and IBM WebSphere

v6.1 & 7

GUI Application : VB.Net, ADO.Net, Visual Basic 6.0.

Web Technologies : ASP.Net 2005, HTML.

Browsers : IE, Netscape, Google Chrome and Safari

Packages : QuarkXpress 5 & 7.3, Adobe InDesign CS3 & CS4, Adobe

Photoshop, Illustrator.

Certification

. Successfully cleared ISTQB Foundation Level Certificate in Software

Testing in the year 2008.

Educational Qualification

. M.Sc IT - (Master of Science in Information Technology) - Manonmaniam

Sundaranar University (Currently Pursuing).

. BCA - (Bachelor of Computer Applications) - Chhattisgarh University.

Work Experience

. Working as Process Lead - QA with Yell Adworks India Pvt Ltd., -

Bangalore since May 2009 to till date.

. Worked as QA Engineer with Yell Adworks India Pvt Ltd., - Bangalore

from June 2007 to

April 2009.

. Worked as Team Lead - Graphics with Yell Adworks India Pvt Ltd., -

Bangalore from

August 2005 to May 2007.

Responsibilities

As a Process Lead - QA, I am involved in,

. Responsible in handling a Team size of 5 QA Engineers.

. Responsible in handling 3 Projects with two Platforms (Windows and

MAC).

. Responsible for the Sanity Check, Regression Testing, Adhoc, GUI,

Compatibility and Functional testing on every new build of the

application.

. Planning and scheduling the Testing activities with respect with co-

ordination of onsite and offshore manager.

. Arranging the Hardware and software requirement for the Test Setup and

Setup the test environments.

. Installation and Deployment of the application. Creation and

Maintenance of multiple Database accounts.

. Allocation and Co-ordination of the work to all the team members as

per schedule.

. Check / Review / Prepare / Update the Test Cases document for testing

the application from all aspects.

. Reviewing / Discussing bug-finding and record defects in the defect

tracking system.

. Conducting team meetings, involved in solving the issues raised by the

team members.

. Coordinating with the onsite team for resolving dependencies.

. Analyzing the customer reported issues and guiding the team members to

replicate the issue.

. Organizing the status meetings and sending the Status Report (Daily,

Weekly, etc.).

. Check / ensure the timely delivery of different testing milestones.

. Keep track of the new requirements / change in requirements of the

Project.

. Pioneered innovated team building and cross-functional training

programs to expedite workflow, simplify process and reduce operation

cost.

. Support to User Acceptance Testing.

Project Details

1. AgilityCMS (Content Management System)

Client : Pindar (www.pindar.com)

Testing Approach : Manual Testing

Application Servers : Oracle BEA Web Logic v9.2 and 10.3 and

IBM Web Sphere v6.1 and 7.

Platforms : Windows XP, Mac OS (10.4 and 10.6)

Technologies : Java/J2EE

Database : Oracle 10g and 11g, SQL Server 2005.

Role : QA Engineer / Lead - QA

Duration : From June 2007

Description:

Agility CMS is a master data management platform that drives your

multi-channel commerce. The out-of-the box functionality of Agility CMS is

unsurpassed, the data modeling is highly flexible and the system can be

easily integrated with other enterprise applications (QuarkXpress and

InDesign) to more efficiently gather, manage and communicate product

information to internal business users and external customers through the

channel of your choice. It enables efficient management of all product data

(structured and unstructured) on the web and across all print media. It

includes catalogue management, digital asset management and web content

management related to products and promotions. It can be integrated

seamlessly with DTP applications, as well as, POS, e-Mail, web content

management and

e-commerce systems. It is used by some of the most successful distributors,

manufacturers, mail order companies and multi-channel merchants in Europe

and North America.

Responsibilities:

. Complete test bed setup.

. Installation and Deployment of the application, Creation and

Maintenance of multiple Database account.

. Involved in designing test cases based on S.R.S, Functional Documents

and Reviewing the same.

. Involved in Sanity, Regression testing, GUI, Compatibility and

Functional Testing on every new build of the application

. Involvement in Test Execution, Results Analyzing and Defect Reporting.

. Monitoring Defect tracking Process till closure using NEWTS.

. Performed Database Testing using SQL in order to check the Data

Validation and Data Integrity.

. Involved in Solving Environmental and Technical problems.

. Preparation of Test Summary Report and Preparation of DSR (Daily

Status Report) for the Team.

. Importing customer dumps.

. Analyzing and Replicating customer reported issues.

. Support to User Acceptance Testing.

. Guiding the team members and handling the Risks.

2. Page Builder Interfaced with ACMS (InDesign and QuarkXpress)

Client : Pindar (www.pindar.com)

Testing Approach : Manual Testing

Application Servers : Oracle BEA Web Logic v9.2 and 10.3 and

IBM Web Sphere v6.1 and 7.

Platforms : Windows XP, Mac OS (10.4 and 10.6)

Technologies : Java/J2EE

Database : Oracle 10g and 11g, SQL Server 2005.

DTP Tools : InDesign CS3/CS4 and QuarkXpress 7/8.

Role : QA Engineer / Lead - QA

Duration : From June 2007

Description:

Pagebuilder (InDesign and QuarkXpress) tools are superior software

for the delivery of print, web and flash output and which are interfaced

with ACMS and this AgilityCMS Page Builder allows you to paginate

information from your ACMS Database onto Pagebuilder documents. You can

bring this information onto the page using generic designs which you can

then create the layout using the standard Page builder tools.

Responsibilities:

. Understanding the functional requirements and application workflows.

. Writing manual test cases and Requirement Traceability Matrix.

. Complete test bed setup and Deployment of the API Plugins/XT's.

. Test data preparation, test case review and modification.

. Preparing Test Evidence, Analyzing results and reporting defects in

NEWTS.

. Involved in Sanity, Adhoc testing, Compatibility and Functional

Testing on every new build of the application

. Involved in Solving Environmental and Technical problems.

. Preparation of Test Summary Report.

. Preparation of DSR (Daily Status Report) for the Team.

. Analyzing and Replicating customer reported issues.

. Support to User Acceptance Testing.

. Guiding the team members and handling the Risks.

3. AgilityCMS - Web Client

Client : Pindar (www.pindar.com)

Testing Approach : Manual Testing

Application Servers : Oracle BEA Web Logic v9.2 and 10.3 and

IBM Web Sphere v6.1 and 7.

Platforms : Windows XP, Mac OS (10.4 and 10.6)

Technologies : Java/J2EE

Database : Oracle 10g and 11g, SQL Server 2005.

Role : QA Engineer / Lead - QA

Duration : From February 2009

Description:

AgilityCMS Web client is a multi user complete web based Content

Management and Publishing Solution covering all the functions of a

publication platform. It is highly parameterized to support constantly

changing customer and regulatory requirements. It is also highly secure and

provides support for different authentication mechanisms. Being web-based,

it gives an organization truly any time, anywhere access.

Responsibilities:

. Understanding the functional requirements and application workflows.

. Executing manual test cases.

. Involved in Tests Scripts Execution, analyzing results as per client

requirements and Reporting Defects Using NEWTS.

. Involved in Peer reviews (Test Design).

. Clear look on updating concepts and finding defects, sending it with

suggestions.

. Involved in Project meetings and interacted to other team members in

order to resolve the problems.

Additional Skills

Software Development:

Ability to develop software using .Net and SQL/MS-Access. Developed the

"Time Tracker" software using ASP.Net and SQL which is extensively used by

Pindar in both India and US.

Graphic Designing:

Having around 10 years of experience in Graphic designing field as various

positions such as Faculty, Graphic designer, Team Leader.

Web Designing:

Hands on experience to create websites using HTML, DHTML, ASP, CSS and

Flash.

Hardware:

Computer Assembling, Hard Disk Partitioning and OS as well as Software

Installation, Trouble Shooting (Both PC & MAC) and Hands on experience with

Networking.

Awards:

. Received "Special Award" for the Time Tracker Software in the year of

2007.

. Received "Management Special Award" for Quality and Team handling in

the year of 2009.

International Exposure:

Visited UK during November 2007 for project related training.

Personal Information

Name : S.Saravana Bhavan

Father's Name : S.Sankaranarayanan

Date of Birth & Age : 20-06-1972 & 39

Marital Status : Married

Languages Known : English & Tamil

Passport Details : E8719057 - Tiruchirappalli, India (Valid upto

July 2014)

Hobbies : Photography, Reading, Listening to Music

Declaration

I hereby declare that all the information mentioned above is true to the

best of my knowledge.

Yours faithfully

(S.Saravana

Bhavan)

Contact this candidate