Sql Server Manager

Professional Summary:

> *+ Years of IT experience which includes System Analysis and Design,

Development & Support of MS SQL Servers 2008 R2/2005/200 in Production,

QA and Development Environments.

> Strong experience with T-SQL(DDL & DML) in Implementing & Developing

Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User

Defined Functions, Indexes, User Profiles, Relational Database Models,

Creating & Updating tables and checking the database consistency by

executing DBCC Commands.

> Ability to work in all stages of System Development Life Cycle (SDLC).

> Experience in Error handling and debugging coding issues and troubleshoot

production problems.

> Extensive Experience in RDBMS concepts such as Tables, User Defined Data

Types, Indexes, Indexed Views, Functions, CTE's, Table Variables and

Stored Procedures.

> Experience in using tools like Database Engine Tuning Advisor, SQL

Profiler, Index Tuning Wizard and Windows Performance Monitor for

Monitoring and Tuning MS SQL Server Performance.

> Expertise in SQL Server 2005/2008 Reporting Services (SSRS), SQL Server

2005/2008 Integration Services (SSIS) and in SQL Server 2005/2008

Analysis Services (SSAS) in Business Intelligence (BI).

> Hands on experience with performing various SSIS data transformation

tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event

Handlers, Error Handlers etc.

> Transformed data from one server to other servers using tools like Bulk

Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL

Server Integration Services (SSIS) (2005/2008 R2).

> Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.

> Hands on experience in installing, configuring, managing, upgrading and

migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008

R2/2005.

> Experience in Managing Security of SQL Server 2005/2008 R2 Databases by

creating Database Users, Roles and assigning proper permissions according

to the business requirements.

> Experience in developing Dashboard, Ad-hoc and Parameterized Reports,

Create complex reports (ex: drill down reports using different objects)

using SSRS.

> Experience in Configure and maintain Report Manager and Report Server for

SSRS, Deployed and Scheduled the Reports in Report Manager.

> Integration of SSRS Reports using various web parts into SharePoint (MOSS

2007) and various delivery mechanisms.

> Experience in Interacting with Business users to analyze the business

process and transforming requirements into screens, performing ETL,

documenting and rolling out the deliverables.

> Strong Experience in Creating, Configuring, Deploying and Testing SSIS

Packages.

> Worked extensively on Extraction, Transformation, Loading data from

Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.

> Experience in .NET/C# application development environment to use SQL

Server Databases.

> Good experience in creating OLAP cubes using SQL Server analysis services

(SSAS).

> Good knowledge of Data Marts, Data warehousing, Operational Data Store

(ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star

Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS

Analysis Services.

> Good understanding of Normalization /De-normalization, Normal Form and

database design methodology Expertise in using data modeling tools like

MS Visio and Erwin Tool for logical and physical design of databases.

> Skilled in design of logical and physical data modeling using Erwin data

modeling tool.

> Worked with Business Analysts, Web development team, and users on

database solutions.

Education: Bachelor of Technology in Information Technology

Technical Skills:

Tools &Packages SQL Server Management studio, Enterprise Manager,

Profiler, SQL

Server Business Intelligent studio (BIDS), DTS, Report

Builder 9.0,

HP QC, ProClarity 6.2,SharePoint 2007, Team Foundation

Server

BI Tools SSIS, SSAS, SSRS.

Databases MS SQL Server 2000/2005/2008/2012, MS Access

97/2003/2005/2008.

Language T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)

Operating Systems Windows vista/XP/2003/2000, Windows Server

2000/2003/2008, UNIX.

Application MS Office Suite, MS Outlook, Windows SharePoint

Packages Services.

Data Modeling MS Visio, Erwin

Tools

Professional Experience:

Client: Blue Cross Blue Shield, Newark, NJ Jan

13 to Till Date

Sr. SQL Developer

BCBS is a health care company which provides different health insurance

solutions from health management, monitoring to diagnosis. It also provides

many health care products which treat infections, disorders and provide

remedy for chronic and solutions to clinical care. Work revolved around the

department which acts as liaison between the government and the health care

receivers. Worked in the department to help maintain and provide effective

solutions to manage the data.

Responsibilities:

> Requirement gathering, Functional & technical specifications for end user

and end client applications, Re-Engineering and capacity planning.

> Involved in database Schema design and development.

> Migrated Database from SQL Server 2005 to 2008.

> Experience in using T-SQL for creating stored procedures, indexes,

cursors and functions.

> Generated server side T-SQL scripts for data manipulation and validation

and created various snapshots and materialized views for remote

instances.

> Creating tables, indexes and designing constraints and wrote T-SQL

statements for retrieval of data and involved in performance tuning of T-

SQL Queries and Stored Procedures.

> Executed stored procedures using BATCH files.

> Developed stored procedures and functions for designing various reports.

> Increased the performance necessary for statistical reporting by 25%

after performance monitoring, tuning and optimizing indexes.

> Used Batch Files to Import Data from other Data Base.

> Used SSIS to create ETL packages (.DTSX files) to validate, extract,

transform and load data to data warehouse databases, data mart databases.

> Enhancing and deploying the SSIS Packages from development server to

production server.

> Wrote the ETL scripts to load the data into database from various source

files. Experienced in error handling and troubleshooting the scripts in

failure to load the data into database.

> Created SSIS Templates for developing SSIS Packages in such a way that

they can be dynamically deployed into Development, Testing and Production

Environments.

> Developed DTS packages to copy tables, schemas and views and to extract

data from Excel and Oracle using SSIS.

> Created packages in SSIS with custom error handling and worked with

different methods of logging in SSIS.

> Created SSIS packages to retrieve data from Legacy sources and also to

retrieve PII user data from the Flat files on monthly and weekly basis.

> Expert in SSIS Deploying and Scheduling

> Identified and Defined Key Performance Indicators in SSAS 2005/2008.

> Process SSAS cubes to store data to OLAP databases

> Integrate SQL Server 2005 reporting services with Microsoft Share point

Portal Server to deliver automatically generated reports to the Share

Point portal.

> Defined report layouts for formatting the report design as per the need.

> Developed Sub Reports, Matrix Reports, Charts, and Drill down reports,

using SQL Server Reporting Services.

> Generated Reports using Global Variables, Expressions and Functions for

the reports.

> Created reports and Dash boards using Microsoft Performance Point

service.

> Worked on querying data and creating on-demand reports using Report

Builder in SSRS reports and send the reports via email.

> In depth knowledge in SSRS for report generation to create various types

of reports and also to develop different SSIS packages.

> Administrated the created Reports by assigning permission to the valid

user for executing the reports.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, SSIS, SSRS, MS

PowerPoint, MS Project, Oracle, PL/SQL, C#,VB.Net, XML, Visual Studio

2008 & 2005,MS Visio 2007,TortoiseSVN.

The Private Bank, Chicago, IL Jun 2011 -

Dec 12

Sr SSRS Developer

This Project is to create integrated standalone Statements from Project

One. Initially these statements were generated via a different product

processor. Now after incorporating them in project one system, it will

enable the Private Bank to provide a consistent look and feel to statements

for yet another product category.

Responsibilities:

> Conduct meeting with clients/business analysts to gather requirements for

new developments or change requests.

> Developed datasets to perform reporting and created interactive Drill

Down, Drill Through, Tabular, Cross Tab, Parameterized, Cascaded and Sub-

reports using SSRS 2008/2005.

> Implemented SSAS Cubes, Facts and Dimension tables to perform analysis

and deploy OLAP cubes on Development server.

> Managed the historical data in the data warehouse from various data

sources and generated various drill down, drill through, matrix and chart

reports from SSAS cubes using SSRS 2008.

> Developed/modified Stored Procedures, Views for different reports and

performed optimization techniques for these database objects to improve

the performance.

> Responsible for fixing all the Production defects logged by the business

users

> Responsible for Report Deployment, documenting changes on VSTS for each

onsite delivery

> Document test cases and perform Unit testing for every change

requests/new developments.

> Knowledge transfer [Functional/Process flow] to the new team member

> Responsible for maintaining the different report versions using Team

Foundation Server (TFS)

> Extensive use of Visual Studio Team System (VSTS) for bug tracking

Environment: MS SQL Server 2008 R2/2005, BIDS 2008/2005, MS SQL Server

Integrated Service (SSIS), MS SQL Server Analysis Service (SSAS), MS Visual

Studio Team Suite, Team Foundation Server (TFS)

Genuine Parts Company, Atlanta GA Oct 2009 - May

2011

Sr MS SQL SSRS Developer

Genuine Parts Company (GPC) is a service organization engaged in the

distribution of automotive replacement parts, industrial replacement parts,

office products and electrical and electronic materials. Project objective

was about gathering requirements from end users, troubleshooting report

failures, create and review cubes, and prepared various reports for

management.

Responsibilities:

> Implemented Complex Stored Procedures and automated them using SQL Server

Agent

> Experienced using Sharepoint to enhance collaboration among the team

members.

> Programmed Triggers (Instead Of and After) for Auditing Purpose

> Played role in design of scalable, reusable, and low maintenance ETL

templates.

> Build efficient SSIS packages for processing fact and dimension tables

with complex transforms such as Lookup, Fuzzy grouping and Row Count

Transformations and type 1 and type 2 slowly changing dimensions

> Managing the security of the servers, creating the new logins and users,

changing the roles of the users.

> Used SQL Server Profiler to trace the slow running queries and tried to

Optimize SQL queries for improved performance and availability.

> Created SSIS packages for application that would transfer data among

servers and perform other data transformations.

> Generated country wise, region wise reports using global variables,

expressions and functions using SSRS.

> Scheduled the same SSIS packages by creating the corresponding job tasks

> Created Scorecards and added them to dashboard using Dashboard Designer

and deployed the dashboard to SharePoint.

> Defined report parameters and wrote queries and procedures for drill down

and parameterized reports using SSRS.

> Created and design the multiple dimensions and fact table for business

report purpose.

> Created Report Snapshots to improve the performance of SSRS

> Generated parameterized/Drilldown reports to enable/disable the

parameters based on user selection in SSRS

> Regular responsibilities for updating dimensional databases

> Performance tuning, writing stored procedures, indexes

Environment MS SQL Server 2008, T- SQL MS Excel 2007/2003, Microsoft SQL

Server Integration Services (SSIS), Microsoft SQL Server Reporting Services

(SSRS), VB, VB.NET, Microsoft SQL Server Analysis Services (SSAS),SQL

Server Data Tools.

AIM Specialty Health, Deerfield, IL Dec 2007

- Sep 2009

MS SQL Server Developer/ SSRS Developer

AIM Specialty Health is a system in Illinois offering full services of care

for several clients around the country. This is a Web based application

which is designed to benefit different health care clients. It has several

new products which have been launched recently such as Sleep Management

System, Radiology and Oncology. It offers two types of web services; Call

Center and Provider Physician.

Responsibilities:

> Created ETL packages using Heterogeneous data sources (SQL Server,

ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded

the data into destination tables by performing different kinds of

transformations using SSIS.

> Used different Transformations like Lookups, Derived Column, Merge Join,

Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all,

Script component and etc.

> Used Event Handlers for Custom Logging using Complex Store Procedures for

various events (On warning, On Pre and Post Execution, On Task Failed

etc.)

> Developed the packages with monitoring features and logging so that audit

information of the packages and their execution results are loaded in to

the audit table.

> Used Configuration files for changing variables and setting the priority

levels for those transcripts based on the level of urgency / requirement.

> Created OLAP models based on Dimensions and Facts for efficient loads of

data.

> Scheduled the reports to refresh and run on daily, weekly and monthly

basis in the report manager.

> Developed MDX Queries in order to perform drilldown reports and for

calculating measures and dimensions.

> Implemented perspectives and KPI using calculated measures based on

requirements.

> Identified and defined the datasets for Report generation.

> Built effective queries for high-performance reporting and rendered them

to HTML, XML, PDF and Excel format using Reporting Services.

Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Integration

Services (SSIS), SQL Server Data Tools, SQL Server Reporting Services (SSRS

2008), SQL Server Analysis Services (SSAS), Business Intelligence

Development Studio (BIDS), MS Excel.

Dell, India Aug 2006 - Nov

2007

SQL Server Developer

Dell Inc is one of the largest computer hardware companies. It is one of

the most admired companies in United States of America. The order

management dashboard is the tool used by Dell Project Managers and customer

care agents to check the status of multiple customer orders. Using this

dashboard, customer care agents were able to track and manage order status

of all customer purchases with visibility from order to delivery in a near

real-time manner.

Responsibilities:

> Installed SQL Server Management tools using SQL Server Setup Program.

> Tested the Installation of SQL Server.

> Worked on Client/Server tools like SQL Server Enterprise Manager and

Query Analyzer to Administer SQL Server.

> Created Database Maintenance Planner for the Performance of SQL Server

which covers Database Integrity Checks, Update Database Statistics and Re-

indexing.

> Worked on Complete Backing up of Database and Restored the Database from

Disaster Recovery.

> Worked on replication server and managed.

> Fine tuning of database objects and server.

> Worked on DTS Package, DTS Import/Export for Transferring data from

Heterogeneous Database.

> Data migration (import & export - BCP) from Text to SQL Server.

> Created Triggers to enforce data and referential integrity.

> Created stored procedures for maintaining SQL Server, Written Stored

Procedures for Application Developers.

> Used DTS to migrate the tables to the Data Warehouse. Handled Different

DSS (Decision Support System) for various applications.

> Extensively wrote MDX queries for calculating measures.

> Design/ developing SSIS (ETL)/SSAS (OLAP) MDX developing components.

> Manage customer expectations by clearly documenting and maintaining

project deliverables, plans, and status throughout life of the project.

> Used Report Builder for Ad-hoc reporting.

> To setup, implement, and maintain industry standards in database

management.

> Monitoring SQL server performance using profiler to find performance and

dead locks.

> Monitoring the servers using spot light third party Quest software.

> Recovering the databases from backup in disasters.

> Handled database objects with Enterprise Manager and Query Analyzer.

> Involved in developing logical and physical database using Erwin,

Normalization, Dimension Modeling and Enterprise Manager.

> Debugging PL/SQL packages to troubleshoot issues.

> Worked on EJB components related to J2EE.

> Writing (Back-end) PL/SQL code to implement business rules through

triggers, cursors, procedures, functions, and packages using SQL*Plus

Editor or TOAD.

> Maintaining the database consistency with DBCC at regular intervals

> Monitoring SQL server performance using profiler to find performance and

dead locks.

> Environment: SQL Server 2000/7.0, Transact-SQL, Enterprise Manager, Query

Analyzer, SQL Profiler, BCP, OSQL, DTS, Oracle 8i, MS-ACCESS

> Worked on making on the enterprise-wide use of XML applications, content

management systems, taxonomies, and search engine optimization.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Java, C#, VB.Net,

ASP.Net, Oracle, Pl/SQL, Enterprise manager, VBS, MSOffice & Windows 2K

platform.

Contact this candidate