Sql Server Manager

SHANKAR

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

512-***-**** [pic]

SQL Server Developer

Note: Available Immediately *** ONLY FOR A CONTRACT POSITION

*** WORK

EXPERIENCE:

. Over 7 Years of IT industry Experience in development of SQL Server

2000/2005/2008 with specialized skills in BI Suite SSIS, SSAS and SSRS.

. Solid Experience in RDBMS database design, installation, configuration,

performance tuning, optimization, backup, recovery, Software Development

Life Cycle (SDLC) Concepts and proven ability to normalize tables up to

Third Normal Form in SQL Server.

. Worked with end users/customers to understand business requirements,

recommended technical solutions and documented functional requirements

. Extensive experience in using Query Analyzer, Report Analyzer, SQL Server

Profiler, SQL Server Management Studio (SSMS), SQL Server Integration

Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server

Reporting Services (SSRS), Crystal reports

. knowledge on ETL tools like SSIS, Informatics, Data stage and AB Inito.

. Well-organized and highly-motivated professional with excellent

analytical and troubleshooting skills

. Ability to work on multiple tasks in a fast paced environment

independently and in a team.

T-SQL Experience:

. Expertise in writing complex T-SQL (DDL, DML, DCL & TCL) queries, Stored

Procedures, User Defined Functions (UDF's), CTE's, Database Triggers and

Exception Handlers

. Expertise in Normalization and De-Normalization techniques for both OLTP

and OLAP systems

. Debugging Stored Procedures, Views, User Defined Functions and Triggers

SSIS/DTS Experience:

. Extensive ETL experience using DTS/SSIS for Data Extractions,

Transformations and Loads

. Conversion of DTS packages to SSIS packages and Interfacing Legacy

components within SSIS for complex transformations and logic

. Experienced in extraction & migration of data from heterogeneous data

sources like Excel, MS Access, Sybase, DB2 to MS SQL Server by using

import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities

. Experience in creating jobs, Alerts and schedule SSIS Packages using SQL

Server Agent

. Experience in scheduling and monitoring ETL processes using DTS Exec

utilities and batch files

. Experience in performance tuning of SSIS packages by using Row

Transformations, Block and Unblock Transformations

SSAS Experience:

. Knowledge in creating dimensions and fact tables

. Knowledge in creating KPI's

. Expert in creating cubes using SSAS

. Familiar with upgrading or migrating Analysis Services

. Comfortable in writing Multidimensional Expressions (MDX)

SSRS Experience:

. Extensive knowledge in Designing, Developing and deploying various kinds

of reports

. Expert in creating Parameterized, Cascaded, Linked, Drill-through and

Drill-down reports

. Experience in creating reports from CUBES and Performance testing using

Report Analyzer

. Experienced in creating dashboards, scorecards and analyzed the results

produced in the dashboard

. Integration of SSRS Reports with SharePoint Server (MOSS)

SQL DBA/Administration Experience:

. Experience in performance tuning, query optimization, client/server

connectivity, running database consistency checks using DBCC Utilities,

SQL Server Profiler, Index Tuning Wizard, Database Engine Tuning Advisor

(DTA), and SQL Server Agent

. Monitoring scheduled jobs and disk spaces on all servers

. Proven ability in database backup and recovery procedures

TECHNICAL SKILLS:

Operating System: Windows Server 2003, XP Professional, Windows 7

Databases: MS SQL Server 2008/2005/2000, MS Access, Oracle 9i, Sybase

Programming Languages: SQL, T-SQL, PL/SQL, MDX, C

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL

Profiler, SQL Alerts, Index Tuning Wizard, BCP,

DTS, Import/Export Wizard, SQL Mail, SQL Server

Management Studio, SSIS 2008/2005, SSAS 2008/2005,

SSRS 2008/2005, Index Analyzer, Report Analyzer,

SQL Client Utility

Reporting Tools: Reporting Services (SSRS) 2008/2005, Crystal Reports

ETL Tools: DTS 2000, SSIS 2008/2005,informatica

PROFESSIONAL EXPERIENCE:

Contact this candidate