Sql Server Management

THAMIL KADAVARAYAR

● ●

*****, ***** ****, ******, ***** 77302 t ********@*******.*** Phone: 281-241-

4344

INFORMATION TECHNOLOGY PROFESSIONAL

SQL Writer with experience using SQL Server Management Studio 2008 R2 and Visual Studio 2008

● H ighly analytical candidate with extensive and progressive experience in the design,

development and management of application systems. In-depth understanding of RDBMS.

● Solution-oriented working with teams and demonstrated excellence in building complex scripts

and queries.

● Proficient in creating complex functions and procedures. Skilled at building and deploying multi-

valued parameterized reports in SSRS.

T EC H N ICAL CO MPET ENC I ES

1

Database Management Skills:

Microsoft SQL Server 2008 R2 Advanced SQL Querying & Programming RDBMS Concepts

T-SQL O racle SQL and PL \SQL SSRS

(Reporting Services)

Tools:

SQL Server Management Studio

Business In telligence Development Studio (BIDS)

TOAD for Oracle

Software:

MS SQL Server 2008 Reporting Services (SSRS) Visual Basic Microsoft Office

E D UCAT ION & T RA I N I NG

1

MS SharePoint Designer 2007 Certificate

05/2011

Vispera Systems, Derby. U.K

SQL Server Administration Certificate

09/2008

Software Training Services, Derby, U.K

Oracle 10g SQL, PL \ SQL Certificate

05/2007

Oracle University, Manchester, U.K

Web Designing using Macromedia Certificate

09/2004

Tech College, Dumfries, Scotland. U.K

O racle Database Operator Certificate

04/2000

MSM Institute, TamilNadu, India

Oracle 8 and Visual Basic 6 Certificate

05/1997

SSI Institute, TamilNadu, India

DBASE I I I+ Certificate

04/1991

Sri RAM Computer, TamilNadu, India

MBA – Business Administration Post Graduate

I ncomplete

M adurai Kamaraj University, TamilNadu,India

MA – Economics Post Graduate

03/1995

M adurai Kamaraj University, TamilNadu,India

SQL EXPER I ENCE

1

SQL Server 2008 R2 Database Design, I mplementation and SQL P rogramming

● Created numerous simple to complex queries involving multiple tables, all type of joins,

correlated sub queries, CTE’s for diverse business requirements.

● Create schema including tables, Stored procedures, Functions, Views and implemented the

i mport and export of data using CSV and SSIS.

● Created various reports according to the business requirements in a team oriented

environment. Individually authored, installed, deployed and managed reports using SSRS.

● Individually designed reporting systems for frontend users, using Access as a frontend and SQL

Server 2008 Database as a backend to extract, compile and submit reports.

● Checked and Validated SQL queries to improve query performance, Created jobs in SQL Server

Agent to automate/Schedule tasks, Used subscription in Report Server to send automated

report to user through email, Performed data analysis to identify and advice of poor data

quality.

Contact this candidate