Database Developer-TSQL,SSIS,SSRS,SSAS
Resume:
SANDEEP RANDHAWA
******.*******@*****.***
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