Sql Server Manager

SANTU B

Phone: 650-***-****

Email: *****.***@*****.***

[pic]

PROFESSIONAL SUMMARY:

. 7+ years of experience in database design, development, analysis,

testing, performance optimization and documentation.

. Strong Business Intelligence experience with SQL Server

2000/2005/2008, SQL Server Reporting Services (SSRS), SQL Server

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

and Informatica ETL tools.

. Extensive experience in writing complex database queries, stored

procedures, functions, tables and views in MS SQL server, Oracle and

evaluating Execution plans.

. Experience in importing and exporting the data between homogeneous and

heterogeneous systems using various Extraction, Transformation and

Loading (ETL) packages in SSIS and also strong knowledge on ETL

architecture.

. Expert in Bulk Copy Program (BCP), Data Transformation Services (DTS)

and SSIS packages with MS SQL Server 2000/2005.

. Good experience in designing and developing reports in SSRS and

Crystal reports according to business requirements.

. Extensive experience in creating different types of reports including:

Ad hoc reports, Cross-tab, Conditional, Drill down, Top N, Summary,

OLAP, Sub reports and Parameter reports.

. Highly skillful in configuring and managing the reports on the Report

Server.

. Extensive experience in developing and publishing the reports using

Business Intelligence Development Studio (BIDS).

. Experience in Data Modeling (Logical and Physical design of

distributed databases).

. Experience in implementing different types of Replications like

Snapshot, Merge and Transactional

. Good expert in designing cubes in BIDS and also in defining

relationships, calculated members in SSAS.

. Strong Knowledge in editing various properties of a Cube, including

dimensions, measures and developing hierarchies and levels.

. Strong knowledge on Data Warehousing concepts.

. Experience in Performance Tuning, Query Optimization, Client/Server

Connectivity and Database Consistency Checks using DBCC Utilities.

. Good SQL Server Administration skills including creation of different

Database Objects, Normalization, Backup/Restore of databases, Jobs,

Alerts, SQL Mail Agent

. Extensive experience in managing the source code in Visual Source Safe

(VSS).

. Experience in all phases of the Software Development Life Cycle (SDLC)

including analysis, design, development, testing, implementation and

maintenance of client/sever database driven applications.

. Highly motivated and a conceptually strong individual with exceptional

analytical and design skills.

Technical Skills:

Tools SQL Server Integration Services(SSIS), SQL

Server Reporting Services(SSRS), SQL Server

Analysis Services(SSAS), Query Analyzer, SQL

* Plus, Enterprise Manager, BIDS,

Informatica

Databases SQL Server 2000, SQL Server 2005/2008,

Oracle 8i/9i, Informix, MS Access, Sybase

Languages and Scripts T-SQL, SQL, PL/SQL,, HTML, UNIX Shell

Scripting, C, C++, VB 5.0/6.0, ASP.NET,

VB.NET, JAVA script

Operating Systems Windows NT/2000/XP, Linux, UNIX, MS-DOS

Web Technologies HTML, XML

Data Modeling Tools Erwin 3.5/4.0, MS Visio-2003

Certifications and Achievements:

Oracle Certified Professional

PROFESSIONAL EXPERIENCE:

Client: Life Masters Supported Self Care

Location: South San Francisco, CA

Role: SQL Server Developer/Analyst

Oct 2007 - Till date

Description: Life Masters is disease Management Company with a sole mission

to help individuals achieve and maintain optimal health. This is by closing

the gaps between recommended and actual care, and encouraging participants

to adopt a healthy lifestyle.

Responsibilities:

. Responsible to collect requirements from business analyst, and other

involved in business.

. Designed data models using dimensional modeling to develop reports

database.

. Planned, defined, designed and uploaded data to the data warehouse

based on the business requirements to develop reports.

. Used ETL tools such as SSIS, DTS packages and Informatica to extract,

transform and load data between different sources including SQL

Server, Oracle and flat files.

. Wrote SQL Queries, Stored Procedures and Functions to retrieve data

from different databases.

. Designed and developed reports using XML and SSRS.

. Created and deployed report RDLs in the Visual Studio 2005 as per

requirements.

. Used VB expressions to customize colors, visibility, labeling and

various other aspects of the reports.

. Uploaded reports on to the report manager and organizing them in

folders. Provide security and roles to the reports.

. Responsible for monitor and tuning report performance.

. Designed and maintained data caching in report server by using SSMS

and Report Manager.

. Created and scheduled reports according to business requirement.

. Designed data driven subscription in SSRS.

. Created DTS packages and SSIS packages for the automation of reporting

processes.

. Created Pivot tables and Pivot charts to present large amounts of data

in meaningful form.

. Scheduled Packages and Procedures using SQL Server agent after

completion of daily ETL fact table updates.

. Involved in the creation of cubes using SSAS in Business Intelligence

Development Studio (BIDS) with multiple measures groups and dimension

hierarchies based on OLTP and OLAP report needs.

. Created reports from the cubes in the SSRS and Pro Clarity to analyze

the data.

. Involved in DBA activities like administering and maintaining the

reports database, Indexing Large Databases, and SQL Server agent.

. Developed Entity-Relationship modeling for OLTP system using MS Visio

2003.

. Involved in the migration of stored procedures, tables and packages

from 2000 to 2005.

. Used Visual Source Safe (VSS) for version maintenance.

Environment: SQL Server 2005/2008, Oracle 10g, SQL Server Reporting

Services (SSRS), SQL server Integration Services (SSIS), Informatica 8.1.1,

DTS, SQL Server Analysis Services(SSAS), T-SQL, PL/SQL, VB.net, ASP.net, MS

Visio 2003, MS Access, MS office, Excel, VSS, ProClarity, Windows Platform.

Client: Warner Chilcott,

Location: Dover, NJ

Role: BI Developer/Reports Developer

July 2006 - Sep 2007

Description: Warner Chilcott is a leading specialty pharmaceutical company

focused on developing, manufacturing and marketing and selling branded

prescription pharmaceutical products in women's healthcare and dermatology

in the United States. Responsible for creating complicated reports using

SSRS.

Responsibilities:

. Collected business requirements and accordingly designed data schemas

(Star/Snowflake) and data models.

. Designed and developed dimensional modeling and entity relationships

for the database using Microsoft Visio.

. Used New Management Studio for managing SQL Server 2005 databases.

. Created SSIS packages and used SSMS to migrate and integrate the data

from Oracle 9i, and SQL 2000 to SQL Server 2005.

. Created SSIS packages to load the data from OLTP to the data warehouse

on regular basis and also migrated SSIS packages from Development to

Production database.

. Filtered bad data or data cleansing using complex T-SQL statements,

and implemented various constraints for data consistency.

. Worked as a developer in creation of complex Stored Procedures, ETL

development packages using SSIS, triggers, tables, views, SQL joins

and statements for applications.

. Created reports by analyzing business data according to requirements.

. Created SQL server reports using SSRS 2005 for management.

. Developed several reports with consistent drill-down functionality

including Drilldown reports, Summary reports and Master detail

reports.

. Created simple query filters, prompted filters and complex filters to

restrict data in the reports.

. Created reports in SQL server 2005 and deployed them on local host for

remote access.

. Created and developed packages using SSIS in BIDS for automation of

reports.

. Performed all tasks which include defining the requirements, design,

development, testing, implementation and maintenance reports using

SSRS 2005 for management.

. Created the structure of model and cube using MS Analysis Services in

BIDS.

. Created calculated fields with MDX code to meet the additional

measures needs that are calculated from existing measures.

. Involved in developing front end with ASP.NET and VB.NET.

. Experienced in performance tuning using windows performance monitor

and SQL profiler of SQL server.

Environment:

MS SQL Server 2000/2005, SSIS, SSRS, SSAS T-SQL, PL/SQL, ASP.NET, VB.NET,

Enterprise Manager, Oracle 9i, SQL Server Migration Services (SSMS), VSS,

UNIX, Microsoft Visio 2003, MS-Access 2000 & Windows XP Professional, NT,

2K platform.

Client: Department of Labor

Location: Trenton, NJ

Role: MS SQL Server Developer

April 2005 - June 2006

The project involved migration of the existing database in MS Access to MS

SQL Server. Project was to plan & administer the entire migration. Tuning

aspects were to be achieved for an efficient & cost effective system.

Optimization of the existing SQL queries to improve the performance of the

system. Design reports for the accounts department.

Responsibilities:

. Logically and physically designed database for projects on basis of

user requirements using ERWIN.

. Migrated databases from MS Access to MS SQL 2000.

. Successfully loaded data from an EXCEL, Access, flat files into a SQL

Server database tables.

. Transformed data from various data sources using OLE DB connection by

creating various DTS packages.

. Tuned SQL statements using Indexes.

. Coded complex Stored Procedures & Functions in MS SQL 2000.

. Converted various SQL statements into Stored Procedures thereby

reducing the Number of database accesses (since Stored Procedures

passes the whole block at one time).

. Analyze the query plan and modify the scripts and/or objects to

enhance performance.

. Developed & executed several Optimized queries in SQL.

. Design and developed the reports for accounting using SSRS 2000.

. Creation of cubes using Microsoft analysis services 2000.

. Tested Performance & Accuracy related queries under SQL Server 7.0.

. Worked as part of development team in preparing Bill of Material

(BOM), MRP Run, Job Planning Schedule and many other modules of SW.

. Provided 24/7 Supports for Production, Development & Test Servers of

MS SQL Servers.

Environment:

SQL Server 7.0/2000, SSRS, MSAS, T-SQL, DTS, Enterprise Manager, Query

Analyzer, PL/SQL, Windows 2000 Server, MS Office 2000, Crystal Reports,

EXCEL, Access, Erwin.

Client: Wells Fargo Bank

Location: Los Angeles, CA

Role: MS SQL Developer/Analyst

Jan 04 - Mar 05

Description: Wells Fargo provides a full range of commercial and individual

banking products and services. The project was to create client solutions

that automate business process by sharing data with different systems in

the bank.

Responsibilities:

. Wrote and optimized Triggers and SQL queries.

. Created stored procedures to generate account statements for different

types of accounts.

. Designed DTS packages and used bulk copy program (BCP) to transfer

data from heterogeneous databases & different files formats (Text

file, Spread sheet) to SQL Server.

. Tuned SQL queries for better performance.

. Developed complex T-SQL code for the application.

. Designed and implemented stored procedures and triggers for automating

tasks.

Environment:

SQL Server 7.0/2000, Unix, Oracle 8i, T-SQL, Enterprise Manager, Query

Analyzer, MS Access, MS office 2000, MS Reporting Services, DTS, Erwin

3.0.

Client: City Central Library

Location: Mumbai, India

Role: MS SQL Developer

July 02 - Dec 03

Description: City Central Library offers a wide range of facilities,

services and reading materials including books, magazines, journals,

newspaper and electronic publications. The project involves developing,

managing and updating databases.

Responsibilities:

. Involved in the designing the database schema using third party tools

like Erwin.

. Involved in Logical and Physical database design.

. Created stored procedures, Functions, Views, Indexes etc. for the

business logic using T-SQL.

. Solved problems by re-configuring parameters, creating/rebuilding

indexes, running DBCC commands and recompiling stored procedures.

. Identified delays in data processing and fine tuned backend code to

speed up the processes.

. Imported data using BCP utility.

Environment: SQL Server 7.0, UNIX, Windows NT 4.0, VB 5.0, BCP[pic]

Contact this candidate