Sql Server Quality Assurance

Kiran Jaggavarapu 203-***-****(Cell)

SUMMARY:

. Over 12 years of experience that includes analysis, programming,

support, installation and database administration.

. Worked 7 years as a database administrator for MS SQL Server

databases, provided architecture/designing assistance and supported

applications with efficient back-end processing.

. Worked 5 Years as Programmer/ Analyst in MS SQL server,Visual

basic, Oracle, Java

. Good Knowledge in Application Support, software engineering

methodologies and quality assurance procedures.

. Have good communication skills, interpersonal relations,

hardworking and result oriented as an individual and in a team.

Specialization:

Database administration, database design and database development work with

SQL Server 7.0, 2000, 2005, 2008. Database administration and performance

tuning is one of my key skills

Education

Bachelor of Engineering

TECHNICAL SKILLS:

Operating Systems: Windows Enterprise 2000/2003/2008,Windows 2000

Professional/Windows XP Professional/NT 4.0 Server, UNIX

(Sun Solaris),

Programming Languages: C, SQL, PL/SQL, Java Script and VBScript

Internet: HTML, DHTML, ASP 2.0/3.0,

RDBMS/DBMS: Progress 8.0, MS-SQL Server 6.5/7.0/2000/2005/2008, Oracle

7.x/8.x/8i and MS-Access, Sybase 12.5

GUI: Visual Basic 5.0/6.0, Developer 2000, Forms5/6i, JBuilder3.0,

Rational Rose2000e, SQL Navigator and MS Office

Reporting Tools: Crystal-Reports, Reports 3.0/6I and Business

Objects, MS SSRS

Data Warehouse Tools: BusinessObjects, Informatica

ERP: MFG/Pro and Peoplesoft 7.5

Special Achievements

Microsoft Certified Professional.

Passed Designing and Implementing Databases with Microsoft SQL Server 7.0

Examination on January, 2001.

Microsoft Certified Technology Specialist.

Passed Microsoft SQL Server 2005 - Implementation and Maintenance

Examination on December, 2008.

PROFESSIONAL EXPERIENCE:

Title: SAC

Role: DBA /Analyst

Client: SAC Capital Advisors LP, Stamford CT

May '03 to Till date

The Client is a Hedge Fund Company.

Role and Responsibility:

. Managed 60 + Production SQL Servers from 10 GB to 6 TB Servers.

. Managed Replication, Log Shipping, Mirroring and clusters

environments.

. Participated in architecture /Database Designing with development

teams.

. Provide DBA knowledge assistance on database issues to developers on

daily basis.

. Reviewed and optimized SQL queries, stored procedures, views and

triggers from other developers to achieve maximum efficiency and

scalability.

. Setting up MS SQL Server and database configuration parameters.

. Configuring MS SQL Server Clients when needed.

. Installing and configuring MS SQL Server Service Packs applicable.

. Developing and implementing DBA maintenance plans like update

statistics, DBCC, Index fragmentation...etc.

. Daily monitoring of MS SQL Server activity, error logs, NT event logs,

space usage and security.

. Developing and testing a backup and disaster recovery Plan.

. Database Backups and Restores using SQLLiteSpeed and System databases

using Native backups.

. Configuring and auditing MS SQL Server security for SAS 70 compliance.

. Managing database object permissions, user accounts and passwords.

. Administering NT Security for MS SQL Server.

. MS SQL Server performance monitoring and optimization.

. Analysis of MS SQL Server long-term performance trends.

. Scheduling and managing jobs on MS SQL Server Agent.

. Monitoring jobs performance and impact on normal operations.

. Documenting MS SQL Server logical and physical design.

. Managed the installing and migration of SQL Server 2000 databases to

SQL Server 2005

. Managed the migration of SQL Server 2000/2005 databases to SQL Server

2008.

. Managed SQL server migrations from 32 bit to 64 Bit SQL server.

. Applying and testing the SQL Server Hot fix and patches.

. Developed, deployed and monitored SSIS Packages including upgrading

DTS to SSIS.

. Performed daily tasks by using SQL Server tools like SQL Server

Management Studio, SQL Server Profiler, SQL Server Agent, and Database

Engine Tuning Advisor

. Developed and optimized database stored procedures, views, triggers

and user-defined functions.

. Implemented partitioning to handle tables with millions of rows.

. Troubleshoot system issues, monitored scheduled jobs and set up

maintenance plans for proactively monitoring the performance of SQL

Server databases

. Applying the changes to UAT\staging and in production environments.

. Managing couple of Prod Sybase SQL servers on Unix and Linux and

windows environments.

. Provide SQL assistances to development teams on Sybase SQL server.

Environment: SQL Server 2000/2005/2008 Enterprise, Windows Enterprise

Server 2003/2008,IIS 6.0, .NET,Microsoft Visio 2003, Microsoft Reporting

Service, Sybase 12.5, Sun Solaris

Title: ReVision

Role: Programmer/ Analyst

Client: Guy Carpenter, NY. USA

Nov '01 to May '03

The Client is reinsurance Brokerage Company.

Environment: NT 4.0 Servers (with service pack 3), Citrix Server, Microsoft

SQL Server 6.5, 7.0 & 2000, Microsoft Visual Basic 6.0 (with SP3), MS

Office (with SP3) (Word & Excel), Right FAX, Lotus Notes R4 and R5, SMTP

service

Role and Responsibility:

As a Programmer Analyst the following were my contributions:

. Responsible for Maintenance of existing Applications

Responsible for the development as per the specifications.

Developed and maintained SQL queries and stored procedures.

. Developed and maintained ActiveX DLLs

Preparing test data for unit testing.

Responsible for relevant documentation.

Adhering to standards.

To conduct unit testing

Title: GRACE

Role: Programmer/ Analyst

Client: Hartford Life. CT. USA

Jun '01 to Oct '01.

The client is an Insurance Company.

Role and Responsibility:

As a Programmer Analyst the following were my contributions:

Responsible for the development as per the specifications.

Developed Packages using PL/SQL

Preparing test data for unit testing.

Responsible for relevant documentation.

Adhering to standards.

To conduct unit testing

Environment: Windows NT Work Station, Oracle 8.0, SQL Navigator, UML and

Rational Rose

Title: Solspark's Youth Payment System (SYPS)

Role: Programmer/ Analyst

Client: Solspark Inc. NY. USA

Feb '01 to May '01.

Solspark Inc. creates Internet-based financial products and services that

help financial institutions and businesses unlock new transactional

opportunities and forge targeted customer relationships.

Role and Responsibility:

As a Programmer Analyst the following were my contributions:

As a programmer involved in development application system

Responsible for the development as per the specifications

Developed interactive forms for this module using HTML and ASP

. Developed stored procedures.

. Involved in unit testing and reviews of the application.

Environment: Windows NT, SQL Server 7.0, T-SQL, ASP, VBScript, JavaScript,

Microsoft Visual Interdev, Microsoft Internet Information Server, Ration

Rose 2000e, Microsoft Exchange Server.

Title: Vianeta Desktop

Role: Quality Tester

Client: Vianeta Communications Inc, CA.USA Dec '00 to

Feb '01.

Service provider for Medical Transcription Industry.

Role and Responsibility:

As a Programmer Analyst the following were my contributions:

Involved in understanding the architecture of existing application.

Extensively used JavaScript in this module.

Involved in testing and documentation of the application.

Involved in integration testing of all modules in this application.

Involved in preparing the User Guides.

Environment: Windows NT, Visual Basic 6.0, COM Using VB, Rational Rose

2000e, XML, DHTML, Java Script and VC++, SQL Server 7.0

Title: SIL Corporate Intranet

Role: Programmer

Client: Sagarsoft (India) Limited

Jun 2000 - Nov 2000.

Role and Responsibility:

As a Programmer the following were my contributions:

. Played a key role in the development and maintenance

of the project

. As a programmer accumulated the functional requirements.

. Involved in system study, Database Design using Rational Rose

2000e.

. Wrote database-stored procedures.

. Developed interactive forms for this module using HTML and ASP

. Created the Website on IIS and hosted the application onto the

local server at Sagarsoft.

. Involved in unit testing and reviews of the application.

. Written the user guide

Environment: Windows NT, SQL Server 7.0, SQL, T-SQL, ASP, VBScript,

JavaScript, Microsoft Visual Interdev, Microsoft Internet Information

Server, Ration Rose 2000e, Microsoft Exchange Server.

Title: Integrated Hospital Management System (IHMS)

Role: Programmer

Client: Sagarsoft (India) Ltd.

Jan 2000 - May 2000.

Role and Responsibility:

As a programmer the following were my contributions:

Worked as a programmer involved in development application system

Data Entry Validation and Coding of Triggers, procedures & Functions

using PL/SQL

Developed the Triggers, procedures, functions and packages.

Developed the Front-end screens using Forms 4.5.

Developed Reports Using Pro*C.

Tested the forms based on the Design specifications.

Environment: Windows NT, Oracle 7.3, S Designer 5.1, Developer 2000

(Forms 4.5), SQL Loader, Pro *C.

Title: Marketing Management System

Role: Programmer

Client: NFC Limited (Marketing Division), India.

Sep 1999 - Dec 1999.

Role and Responsibility:

As a Programmer the following were my contributions:

As a programmer involved in development application system

Involved in the Requirement analysis and defining the scope.

Developed the front end screens using Visual Basic 6.0.

Developed DLLs and deployed on to the MTS.

Developed the stored procedures.

Reports were developed using Crystal Reports.

Environment: Windows NT server, Windows 95 client, Visual Basic 4.0, SQL

Server 6.5 and Crystal Reports.

Title: Inspection Report Processing System

Role: Programmer

Client: State Bank of India (Inspection & Auditing Division), India.

Jan 99 - Aug 99.

Role and Responsibility:

As a programmer the following were my contributions:

Worked as a programmer involved in development application system

Data Entry Validation and Coding of Triggers, procedures & Functions

using PL/SQL

Requirement analysis and defining the scope

Developed the Triggers, procedures, functions and packages.

Developed the Front-end screens using Forms 4.5.

Developed Reports Using Pro*C.

Tested the forms based on the Design specifications.

Environment: Sco Unix, Oracle 7.3, S Designer 5.1, Developer 2000 (Forms

4.5), SQL Loader, Pro *C.

Title: Implementation of Peoplesoft HRMS system and executive information

system (EIS)

Role: Programmer

Client: Sagar Cements Ltd., India.

May 98 - Dec 98.

Role and Responsibility:

As a programmer the following were my contributions:

Worked as a programmer involved in development application system

Understanding the Business processes of the client

Customizing the ERP Product.

Adding New add-on's to the product

Building reports for the finance users using SQR and Crystal Reports.

Testing of the code and Quality Assurance

Developing new workflow processes.

Environment: PeoplesoftHRMSV7.5, SQLServer 6.5, SQR, Crystal Reports, S-

Designer on Windows NT and windows95.

Other Activities during the Sagarsoft India Employment

Program undergone during Training Period:

Review Program for CIRM and CPIM Certification from APICS (American

Production and Inventory Control Society).

Microsoft Official Curriculum comprising of:

Windows- NT

MS-SQL Server 6.5

Progress 8.0

Peoplesoft HRMS 7.5

MANUFACTURING core functional area with specific emphasis on the

functionality of MFG/PRO Manufacturing Package.

Contact this candidate