Sql Server Manager
Resume:
BHEESHMA
********.*********@*****.***
SQL Server Developer
Note: Available Immediately *** ONLY FOR A CONTRACT POSITION ***
=
Summary:
. Over 7+ of strong IT experience in Database Design, Development,
Administration, and Support of MS SQL Server 2008, 2005, 2000 and its BI
stack (SSRS/SSIS//SSMS/Crystal Reports) with various business domains
like Banking, Financials, pharmaceutical and Advertising.
. Proficient in MS SQL Server 2008/2005 installation and configuration as
well as migrating SQL Server 2000 databases into SQL Server 2005 and
2008.
. Extensively worked with database development writing stored procedures,
functions, packages, and data base triggers, User Defined Functions
(UDF's) using SQL, PL/SQL (DDL, DML,DCL) statements for various
applications.. Proficient in writing distributed queries between SQL
Servers by creating link servers.
. Strong experience working with Relational Database Management Systems,
including E/R Diagrams, Normalization, Constraints, Querying, Joins,
Keys, Indexes, Data Import/Export.
. Extensively used SQL Server tools like Query Analyzer, Enterprise
manager, profiler and management studio.
. Experience in optimizing the query by creating various clustered, non-
clustered indexes and indexed views.
. Comprehensive knowledge and exposure to different phases of Software
Development Life Cycle
. Generating DDL scripts and forward and reverse engineering databases.
. Good understanding and experience in SQL 2008 new features like Change
Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based
Management.
. Experienced in data Extraction, Transformation and Loading (ETL) using
various tools such as SQL Server Integration Services (SSIS), DTS, Bulk
Insert and Bulk Copy Program utility.
. Expert in working with SSIS for creating packages to transform data from
different OLEDB Providers like DB2, MS Access, Flat File, Excel, Oracle
and Automate the ETL.
. Successfully tested and implemented Log shipping for hot backup solution
for MS SQL Server 2000/2005 databases.
. Implemented new features of SQL Server 2005 like Data Partitioning,
Snapshot Isolation, Online Indexing, Data Base Snapshot, DDL triggers
and DMVs.
. Creates back-up, replication, and recovery plans. Performs quality
control and auditing of databases to ensure accurate and appropriate use
of data.
. Experience in designing Ad hoc reports and different types of Drill Down,
Drill Through reports, Tabular reports, Cross tabs, Matrix reports,
Custom reports, Sub reports, Parameterized reports in multiple formats
using multiple Data Sets and creating Charts using SSRS 2005/2008,
2008,XI/10.0/9.0, Crystal Enterprise, Business Objects, MS Reporting
Service.
. Experience in developing ASP.NET web applications with Crystal Reports
using C# language and working with Reports where data has been
shared across Sub-reports.
. Facilitated communication between developers and business users to ensure
that customer requirements are correctly translated to appropriate data
design specifications
. Communicated with business units when appropriate, utilizing advanced
written and oral skills in order to maintain system and/or product
credibility.
Technical Proficiencies:
DBMS & RDBMS SQL Server 2000/2005/2008, Oracle 9i/10gR2/11g
R1&R2, MS-Access, DB2, MYSQL
SQL Server Tools SQL Server Enterprise Manager, T-SQL, Data
Transformation Services (DTS), DBCC, BCP, SQL
Server Profiler, SQL Server Query Analyzer,
Import/Export tools, SQL Server Agent, (SSIS),
SQL Server 2005 Reporting Services (SSRS),oracle
enterprise manager and TOAD. SQL Jobs, SQL
Alerts and SQL Mail,, SQL Server Management
Studio, SQL Server Integration Services.
Programming Languages T-SQL, PL/SQL,C#, ASP.Net, VBA, C, C++, PHP,
Windows Power shell, MDX/DMX.
Operating Systems Microsoft Windows NT/95/98/XP, Microsoft Windows
2000/2003/2005 32bit &64bit, UNIX.
Reporting Tools SQL Server Reporting Services, Crystal Reports
XI/10/9, MS Excel
Office Tools MS office, Visio Word, Outlook
Web Technologies and VB Script, Java Script, CSS, HTML, DHTML, XML,
Software Adobe Dreamweaver, Adobe Flash, XAMP (software
bundle), Adobe Photoshop.
Education: Bachelor's of Technology in Electronics & Communication
Engineering from JNTU.
Professional Experience:
Contact this candidate