Sql Server Developer

SRIVIDYA KARNATAKAPU

************@*****.***

Ph. No. 484-***-****

PROFESSIONAL SUMMARY:

• Over Two years of experience in MS SQL SERVER DBA, Database Development.

• Extensive knowledge of Relational Database Management Systems.

• Extensive experience in installation and configuration of MS SQL Server

2005, 2008 and 2008R2 versions.

• Experience in implementing business logic using Triggers, Views, Functions and Stored procedures.

• Experience in MS SQL Clustering, indexing.

• Wide experience of Application development lifecycle including design, testing and implementation in accordance with timeline and budget.

• Excellent organizational, project management and resource management skills.

• Experience in performance tuning using SQL server profile and Database index tuning wizard.

• Experience in the maintenance of Database authentication modes, creation of users, configuring permissions and assigning roles to users.

• Experience in Code Optimization and Improving Efficiency in databases including indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.

• Good team player, strong interpersonal and communication skills.

TECHNICAL SKILLS:

Languages : C, C++, T-SQL

Operating Systems : Windows Server 2003, Windows 2008, Windows XP

and Windows 7

Data Bases : MS-SQL Server 2005/2008/2008 R2

IDES : Business Intelligence Studio, Visual Studio.

Data modeling Tool : Erwin, Microsoft Visio, ER Studio.

Source Control : Visual Source Safe, Team Foundation Server

PROFESSIONAL EXPERIENCE:

Project: Absolute Return

Client : TIFF, PA

Date : Nov 2011 to May 2012

Roles : Database Developer

As a database developer for as Investment Firm, achievements included:

• Helped in developing a web application for the Absolute Return Pool which replaced the existing Excel application.

• Designed the Physical and logical data model.

• Wrote User defined functions, views and stored procedure for reports and application pool performance screens.

• Migrated data from Excel sheets to database using bulk load.

• Wrote stored procedures in SQL server.

• Deployed database builds in Development and QA systems.

• Maintained database scripts in Team foundation.

Environment: Windows 2003, XP Professional, .NET Framework 3.5, Visual Studio 2008, MS SQL Server 2008, Team Foundation Server, Reporting Services (SSRS), SSIS.

Project : Virtual Inventory Management System

Client : SUNRx, PA

Dates : Mar 2011 to Nov 2011

Roles : Database Developer

For a Virtual Inventory Management System project, acted as a Database Developer on a web application which was developed to support the 340B program. The core components of system were health center and pharmacy set-up, user structure, pricing structure, formulary design, patient eligibility data load, generating pending orders based on claims utilization and threshold value, Purchase Order creation, drug shipment, invoicing and reconciliation. Duties included:

• Designed login and physical model for system using ER Studio.

• Wrote SQL job to generate pending orders using stored procedures.

• Wrote procedures for Health Center and pharmacy reports.

• Wrote User Defined Functions (UDF) required for application.

• Worked on performance tuning and maintained database and application.

• Wrote stored procedure to load data, drugs information, drug database.

• Created views for drug and package size calculation.

• Also responsible for stored procedures code review.

Environment: Windows XP Version, .NET Framework 2.0, Visual Studio 2005, IIS, SQL Server 2005, C++, SSRS.

Project : WACKI

Client : Prime Technologies, HYDERABAD, INDIA.

Roles : Database Developer

Date : Jan 2007 to Mar 2008

WACKI is a web-based corporate intranet application, which ties the whole company together and acts as a communication backbone. It is designed to manage and track project related activities, share white papers, post questions in discussion forums, manage documents and other files using document manager. Other highlights include news updates, live cricket scores, fun zone, poll meter (which allows the employees of prime Technology Group to post their opinions) and ample of other features, which prove to be not only entertaining, but also beneficial. Wacki also has a test engine integrated which allows one to take a quiz during any time of the day.

Responsibilities:

• Worked with team members to define requirements for applications.

• Created data model for new tables using VISIO tool.

• Created database schema as per requirements.

• Written stored procedures and user defined functions for document management, discussion forums, user registration modules.

• Created user defined data types.

Environment: Windows XP Version, .NET Framework 2.0, Visual Studio 2005, C#, IIS, SQL Server 2005

EDUCATION:

BACHELOR IN COMPUTER APPLICATIONS.

MASTERS IN BUSINESS ADMINISTRATION.

Contact this candidate