SANDEEP RANDHAWA

ace88r@r.postjobfree.com

551-***-****

Professional Summary

. Over 8 years of IT experience as a MS SQL Server Developer with SQL

Server 2012/2008R2/2008/2005/2000.

. Experience with Microsoft HyperV (2008), MS virtual server (2003), MS

virtual PC.

. Experienced in Database Design, Development, Maintenance and

Administration on SQL Server 2005/2008/2008R2/2012.

. Experienced in Installation, Upgrade and Configuration of Microsoft

SQL Server 2000/ 2005.

. Expert level skills in Data Modeling, Data Mapping, Data Staging, and

Database Normalization using RDBMS Concepts and Constructs.

. Experience in using SQL Server 2005, 2008, 2008R2 Management Studio

(SSMS).

. Experience in SQL Server Integration Services (SSIS), SQL Server

Reporting Services (SSRS).

. Experience in Database Administration activities like Configuration,

Backup & Recovery, Database Security, Data Transformation Services,

Database designing and Query optimization, log shipping, data

mirroring.

. Expert level skills in Data Modeling, Table Normalization,

Optimization and Performance Tuning.

. Expert in Transact-SQL (DDL, DML) designing dynamic store procedures,

cursor, triggers, functions, constraints.

. Expertise in writing T-SQL (DML &DDL) Code, Dynamic SQL, Query

optimization and performance tuning. Used SQL Profiler, Execution

plan, Performance Monitor and DBCC commands.

. Experience in migrating databases from SQL Server 2005 to SQL Server

2008.

. Expertise in Creating Cluster Index and Non Cluster Index, Covered

Index, and Indexed View to improve performance on Database side.

. Experience in Dimensional Modeling, ER Modeling using Erwin, Star

Schema / Snowflake Schema, Fact and Dimensional tables and Operational

Data Store (ODS).

. Extensive experience in importing and exporting the data between

homogenous and heterogeneous systems using Extraction Transformation

and Loading (ETL), SQL tools (Data Transformation Services (DTS), Bulk

Copy Program (BCP), and Bulk Insert).

. Extensive experience in SSIS Package configuration, Logging, Package

level and Data level error handling and Package deployment.

. Extensive use of ETL for data massaging/scraping, cleansing, scrubbing

and manipulating using various SSIS packages. Experience in staging in

data warehouse to get rid of null values and change data types. For

organizing data.

. Expert in data massaging, sorting using SSIS data flow tasks like

derived column, import column, conditional split, lookup, fuzzy

lookup, pivot and unpivot.

. Experience in Error logging and Event Handling: Precedence

Constraints, Break Points, Check Points and Logging.

. Extensive experience in handling data in various environments

(OLTP/OLAP, Data warehousing) using Microsoft BI Suite ( TSQL, SSIS,

SSRS and SSAS)

. Experience in Query Optimization, Client/Server connectivity and

Database Consistency Checks with the help of DBCC utilities.

. Strong Experience loading STAR and SNOW FLAKE schema DM and DW using

best practices. Strong coding experience to do Data reconciliation

using TSQL, SSIS and SSRS. Extensive experience creating CHART, GAUGE,

PARAMETERIZED, SUB, DRILL DOWN and DRILL THROUGH Reports.

. Working experience of writing MDX using SSMS to validate data between

table and cube.

. Strong team player as well as can work independently based on the

assignment.

Technical Skills

RDBMS/DBMS MS-SQL Server 2008, 2005,2000 MS Access

Database SQL Server Enterprise Manager, Management Studio, SQL

Technologies/Tools Profiler, SQL Query Analyzer, Index Analyzer, SQL Client

Configuration Utility, Data Transformation Services (DTS),

Integration Service (SSIS), Analysis Service (SSAS),

Reporting Service(SSRS), ODBC, ADO, Data warehouse

Operating Systems Windows Vista, XP, 2003, 2000, MS DOS

Programming C/C++, XML, Visual Studio, T-SQL, PL/SQL,.NET

Languages

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

Professional Experience

Clear Channel NYC, NY

09/2012-07/2014

Database Engineer/ ETL (SSIS)

With 243 million monthly listeners in the U.S. Clear Channel Media and

Entertainment has the largest reach of any radio and television outlet in

America. Clear Channel is a media entertainment company specializing

in radio broadcasting through subsidiary Clear Channel Broadcasting,

Inc. and division Clear Channel Media and Entertainment (Clear Channel

Radio). The goal was to develop an enterprise data warehouse(OLAP) code as

per the content team requirement, Create stored procedures(using Functions)

for HTML and Excel reporting, design ETL packages to load data from

heterogeneous sources like flat files and excel and loading to SQL

databases for analytic purposes.

Job Responsibilities

. Involved in Business Analysis and Requirements gathering from the

Business Users and Technical document design of these requirements.

. Participated in the creation of the logical & physical data models as

per the business requirements.

. Created database objects like tables, stored procedures, indexes,

views, triggers, functions and cursors using T-SQL statements, worked

with DML and DDL for retrieval and modification of the data.

. Created stored procedures, scripts and tested them on the test servers

and then moved them to production servers.

. Developed SSIS Packages with SQL Server Integration Services (SSIS) to

migrate data from Oracle 9i/10g, and DB2, SQL Server 2005 to SQL

Server2008 to support front end analysis system.

. SQL Server Integration Services (SSIS) was extensively used for

Extraction, Transformation and Loading (ETL) process of Flat Files,

Excel Spreadsheets to SQL Server 2008 and vice versa.

. Transformed data to and from various data sources by creating SSIS

packages. Used BCP command line utility for bulk data import/ Export.

. Performed data conversions from Flat Files to database structures and

loading data from FTP to Excel (XSLS).

. Developed various SSIS packages satisfying Business requirements for

different Interfaces like SOAP, web services, JSON and parsing XML

using XSLT, web using WSDL.

. Successfully increased the performance of the SSIS packages by 20% by

identifying the bottle necks and resolving them.

. Written Inline and Scalar User Defined Functions and implemented

Instead Of and after triggers and specified their order of execution.

. Designed and Implemented Performance Tuning, Query Optimization and

Maintenance plans for consistency checks, re indexing within defined

Maintenance Window.

. Created and modified Complex T-SQL queries, stored procedures,

Triggers to implement the complex business needs.

. Worked on archiving the data from large tables into zipped files to

release space.

. Performed Business Analysis, Designed, Developed, Tested and

Implemented packages using SQL Server Integration Services (SSIS)

for extracting the data from the sources.

. Worked on SQL Profiler, Tuning Adviser (DTA), and Systems Performance

Monitoring with various objects & Counters, DBCC commands to record

and enhance the performance.

. Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL

Queries and Resolving Deadlocking, Blocking and locking issues.

. Responsible in checking query plans and making sure each and every

query is using appropriate useful indexes.

. Loading data into GOOD DATA for royalty reporting filtered by stations

and markets.

. Used Omniture as analytical tool to import data from various sources

like video usage and mobile traffic based on calendar dates in Excel

or word format as hourly, daily or weekly.

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

SQL Servers. Detect, Diagnose, Repaired and Reported databases errors,

Application errors and Connectivity issues.

Environment: SQL Server 2005/2008 (SQL Server Management Studio, SQL server

integration services (SSIS),SQL Profiler

Reporting Services (SSRS)), XML, GOOD DATA,.NET

GAF Roofing Materials, WAYNE NJ

12/2011-

09/2012

BI Developer/SSIS

GAF is North America's largest manufacturer of commercial and residential

roofing. GAF success in growing the company has been based on unique

philosophy of helping supportive distributors and roofing contractors to

build their businesses and avoid hassles. The project included the

migration of data from PeopleSoft to project server Portal(OLTP) using

Microsoft SQL server 2008 R2 and SSIS with SQL server logging and XML

configuration, query optimization and performance tuning. TFS was the

common platform used for deployment.

Responsibilities

. Migrated DTS packages from SQL Server 2000 to SQL Server 2008

Integration Services (SSIS).

. Enhanced and modified SQL server 2005, 2008 production database

tables, views, stored procedures and ETL packages.

. Provided technical leadership and expertise in data mapping, database

design, and implementation and maintenance phases.

. Planned and executed database integration, consolidation and

modifications.

. Database monitoring and tuning.

. Checked Performance Tuning, Indexing, Query Optimization.

. Created and managed SSIS packages, and dynamic stored procedures.

. Used SSIS for data import and export data from SQL Server to Access,

text and EXCEL files.

. Designed and implemented a promotion process to deploy the SSIS

packages, configuration files on to different environments.

. Scheduled the SSIS Packages to be run on different environments and

monitored the process.

. Transferred flat files from the old system to the staging area by

using BCP and then to SQL Server 2008 R2..

. Created and altered database objects like tables, views, indexes,

stored-procedures, triggers, cursors.

. Converted various SQL statements into stored procedures thereby

reducing the Number of database traffic (since Stored Procedures

passes the whole block at one time).

. Ensured that SQL system improvements are successfully implemented and

monitored to increase efficiency.

. Developed and assisted with designing all systems integrations using

SSRS reporting and all SQL-based stored procedures and databases.

. Developed complex Queries & dynamic Stored Procs for creating

Maintenance Plans to

Generate Reports everyday for Server's Health check.

. Supported all departments with requests related to SQL database, such

as ad-hoc reports, parameterized, drill-down and drill-through

reports.

. Administer SQL server database environments and monitor site

performance. Facilitate the performance, aggregation, and analysis

of SQL databases and statistics reports, in coordination with

Operations and Information Technology.

. Implemented, maintained and responded to critical job notifications on

failure.

. Designed and implemented scripts in SSIS MS Visual Basic.

. Used Script task for creating customers invoice related emails.

. Upgraded SQL Server 2008 R2 with Service Pack 3 and implemented it

successfully in Development Environments.

Environment: SQL Server 2008 R2 (SQL Server Management Studio, SQL

Profiler, Integration Service (SSIS), Reporting Services (SSRS)), VB

6.0, .NET, TFS (Team Foundation Server), visual studio 2010/2008.

PINEBRIDGE INVESTMENTS,NYC,NY

05/2009 - 12/2011

SQL Server Developer/SSIS/SSRS

Pine Bridge Investments is one of the leading Assets Management Group. The

main business of the companies include Listed Equities like emerging

markets, Fixed Income and other alternative investments like Hedge funds

etc. The project involved migration of data from old system called Wealth

Management Services (WMS), that was based on SQL Server 2000, to the new

system called Fund Management Services (FMS) based on SQL Server 2008 R2

using SSIS for ETL and Reporting purposes; establishing backups and

recovery policies and procedures, Application tuning and performance

monitoring.

Responsibilities:

. Participated in both data design and data processing sessions for

assigned project and team.

. Developed and tested stored procedure to automate the database backup

and scheduling tasks.

. Created Linked Servers to move data from one server to another.

. Created migration/conversion designs that met the project's

business,(OLTP) system and data requirements.

. Worked for Designing and developing Transact-SQL processes, ETL

(Extract, Transform and Load) processes using Microsoft SQL Server

Integration Services (SSIS).

. Optimized the performance of queries with modification in TSQL

queries, removed unnecessary columns, eliminated redundant and

inconsistent data, normalized tables, established joins and created

clustered/non-clustered indexes wherever necessary.

. Created Database and Database Objects like Tables, Stored Procedures,

Views, Triggers, Rules, Defaults, user defined data types and

functions.

. Optimized ETL processes and T-SQL code performance using Microsoft SQL

Server best practices and query/index/table performance tuning.

. Created views as required by front end Java developer for easier

implementation on web pages, and triggers on those views to provide

efficient data manipulation.

. Used index tuning wizard to tune the indexes on various tables.

. Resolved Deadlocking, blocking and locking issues by looking into

Profiler Trace. Investigated the reason behind blocking and provided

detailed information and analysis to the application members.

. Installed and configured SSRS (SQL Server Reporting Services) deployed

reports using the web interface and configured subscriptions for the

reports.

. Generated Simple Reports, Parameterized Reports using SSRS (

Reporting Services)

. Responsible for creating SSRS reports using the wizard, list reports

and managing security.

. To respond to data design and/or data processing problems and finding

solutions in a timely manner.

Environment: SQL Server 2008 R2, T-SQL, SQL Server Management Studio, SSRS,

SSIS, Query Analyzer, SQL Profiler, Business Intelligence Development

Studio (BIDS).

St. Joseph medical group, Pune, India

02/2006 - 04/2009

SQL server Developer

St. Joseph Medical group develops medical technology and

services that focus on putting more control into the hands of those who

treat cardiac and chronic pain patients worldwide. The organization's

infrastructure included MS SQL Server, Oracle. This project(Disease

Specialist system) involved performance tuning, migration, creation of

database objects, as well as maintenance of SQL Server 2000.

Responsibilities

. Installed SQL Server 2005 on Windows 2003 Advanced Server, on pre-

production server.

. Monitored the performance of SQL Server 2005 on pre-production

servers.

. Planned and Tested to Upgrade SQL Server 2000 Databases with SQL

Server 2005

. Implemented Log Shipping successfully using SQL Server 2005.

. Participated in gathering user requirement and online system

specification.

. Designed Data Warehouse and data mart with snowflake schema.

. Disaster Recovery Plan, Testing and analyzing and continuous update of

documentation.

. Created Database Backup Plans for Full, Differential and Transactional

Database Backups with different recovery models (Simple, Full and

Bulk).

. Created SSIS packages for loading the data.

. Created stored procedures, scripts, cursors and tested them on the

test servers and then moved them to production servers.

. Enhanced the performance of the SSIS packages by Configuring the

MaxBufferSize, MaxBufferRows and MaxConcurrentExecutables options.

. Involved in Creating tables, indexes and designing constraints.

. Used system tables, system stored procedures and DBCC commands for

database maintenance.

. Actively participated in database optimization, performance monitoring

and index tuning.

. Reduced the Query Execution time by Monitoring and Tuning Indexes

using Index Tuning Wizard.

. Actively participated in SQL Server Integration Services (SSIS), SQL

Server Reporting Services (SSRS).

. Setting up SQL Database Mirroring.

. Created SSIS packages for loading the data.

. Created and modified Complex T-SQL queries, stored procedures,

Triggers to implement the complex business needs for generating new

customer number, account no, increasing, decreasing and setting credit

limit as per business policies, updating user profiles, transaction

processing, generating messages with code encryption.

. Generated reports using Parameterized reports and drilldown reports.

. Worked as a team member for 24X7 on call production support.

Environment:

SQL Server 2005, SSIS, SSRS, SQL Server 2000 Enterprise Edition, Windows

Server 2003, T-SQL

Educational Qualifications:

B.Tech I.T (2002-2006) from B.C.E.T Gurdaspur, Punjab, India-143521

RDBMS/DBMS

MS-SQL Server 2008, 2005,2000 MS Access

Database Technologies/Tools

SQL Server Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer,

Index Analyzer, SQL Client Configuration Utility, Data Transformation Services (DTS),

Integration Service (SSIS), Analysis Service (SSAS), Reporting Service(SSRS), ODBC,

ADO, Data warehouse

Operating Systems

Windows Vista, XP, 2003, 2000, MS DOS

Programming Languages

C/C++, XML, Visual Studio, T-SQL, PL/SQL

Business Tools

Word, Excel, PowerPoint, Access, Visio, Outlook

Contact this candidate