Sql Server Data

HETAL RAO

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

Phone: 973-***-****

C2C or Contract to hire

PROFESSIONAL SUMMARY:

● Over 8 years of extensive experience in database design, development, and administration with MS SQL

Server versions 2012/2008R2/2008/2005 using SSIS, SSAS, SSRS in Financial, Healthcare, Insurance,

and Manufacturing industries.

● Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis,

Design, Development and Implementation.

● Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server

Reporting Services, and MS SQL Server Analysis Services.

● Experience in Logical and Physical Database design & development, Normalization and Data modeling

using Erwin data model.

● Responsible for writing functional specifications, translating business requirements to technical

specifications, created/maintained/modified database design document with detailed description of logical

entities and physical tables.

● Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User

Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.

● Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data

warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.

● Extensive experience working with BCP, SSIS packages, creating jobs and linked servers for MS SQL

Server/Oracle/ Sybase databases.

● Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).

● Skilled in Creating and Deploying SSRS Reports on the portal for user accessibility.

● Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report

layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source

and subtotals for the reports using SSRS 2012/2008R2/2008/2005.

● Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well

into any environment, and working well under pressure.

● Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions,

views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.

● Expertise in working on all activities related to the development, implementation, administration and

support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP) and SQL

Server Integration Services (SSIS) with MS SQL 2012/2008 R2/2008/2005.

● Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.

● Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery

Strategy for application and database.

● Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for

monitoring and tuning SQL Server performance.

● Maintained positive communications and working relationships at all business levels.

● Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

.

EDUCATION

Master of Business Administration

Bachelor In Computer Science

TECHNICAL SKILL:

MS SQL Server 2012/2008R2/2008/2005, MS SQL Server Integration Service (SSIS), MS SQL Reporting

Services (SSRS), MS SQL Analysis Services (SSAS), Microsoft Access 2007/2003/8.0, Microsoft Word,

Excel, PowerPoint, Outlook, T-SQL, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, MS SQL

Profiler, Erwin Data Modeler 7.2/4.2/4.1/4.0,C#, ASP.Net,VB.Net Crystal Reports 8.5, MS SharePoint

Services 2007, MS Visio 2003.

PROFESSIONAL EXPERIENCE:

Client:State Farm Insurance, Concordville, PA

Duration: Feb 2014 – December 2014

Role: TSQL/SSIS/SSRS Developer The project involved designing new database schemas,

extracting & loading the data, performing analysis and then generating various types of reports. The

goal of project was to load data from OLTP server to Data Warehouse server.

Responsibilities:

● Planned, Defined and Designed data based on business requirement and provided documentation.

● Gathered data and documenting it for further reference.

● Designed Database using Erwin data modeler.

● Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting,

Cache Transform, Conditional Split and Derived column etc.

● Developed SSIS Packages using Lookup Values & implementing rules provided by Business in the

mapping document.

● Developed SSIS packages using Fuzzy Lookup and Fuzzy Grouping for data cleansing purpose.

● Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

● Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

● Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database

on Daily basis.

● Generated parameterized reports, sub reports, tabular reports using SSRS 2012

● Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012

● Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS

2012.

● Created reports to retrieve data using Stored Procedures that accepts parameters.

● Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

● Responsible for Monitoring and Tuning Report performance.

● Configured the report viewing security for various users at various levels using Report Manager

● Scheduled report and exported in PDF format.

● Fine-tuned SQL Queries for maximum efficiency and performance.

● Provided documentation for all kinds of reports and SSIS packages.

● Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools & Technologies:

MS SQL Server 2012, T-SQL, SSRS / SSIS, Window 2008 Server R2, Visual Source Safe, Microsoft Visio

2007, Microsoft Project 2007, XSLT.

Client: SunPharma/UrlPharma, Cranbarry, NJ.

Duration: Jan 2013 - Feb 2014

Role: SSRS Developer/SSIS Developer

The project also involved creating SSIS packages for transferring the data from different systems and also

creating the reports using SSRS 2008R2.

Responsibilities:

● Planned, Defined and Designed data based on business requirement and provided documentation.

● Gathered data and documenting it for further reference and designed Database using Erwin data

modeler.

● Created SSIS package to load data from Flat Files and SQL Server 2008 to SQL Server 2008R2 using

Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot

Transformation, and Slowly Changing Dimension.

● Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and

Data Mart Databases.

● Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

● Modified the existing SSIS packages to meet the changes specified by the users.

● Scheduled Jobs for executing the stored SSIS packages which were developed to update the database

on Daily basis using SQL Server Agent.

● Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.

● Worked in setup logging environment to track the status of the events like error raise, task fail.

● Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.

● Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.

● Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and

Parameterized reports using SSRS 2008R2

● Created reports to retrieve data using Stored Procedures that accept parameters.

● Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

● Responsible for Monitoring and Tuning Report performance.

● Created various database object like stored procedures, functions, tables, views

● Configured the report viewing security for various users at various levels using Report Manager

● Deployed the generated reports on to the server.

● Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database

Engine Tuning Advisor.

● Provided documentation for all kinds of reports and SSIS packages.

● Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools & Technologies:

MS SQL Server 2008 R2, T-SQL, SSRS / SSIS, Erwin v4.0, Win 2008 Server R2, Visual Source Safe,

Microsoft Visio 2007, SQL Profiler,C#.Net,VB.Net .

Client: Verizon Wireless, Warren, New Jersey

Duration: July 2011 - Dec 2012

Role: MS SQL Server /SSIS/SSRS Developer

This project was done by building an EDW based on MS SQL Server 2008R2 and its reporting services

which would provide space for growth and standardizing its forms and templates.

Responsibilities:

● Created SSIS packages to migrate data from different data sources to data warehouse.

● Successfully extracted transformed and load data into data warehouse.

● Created packages by testing and cleaning the Standardized Data by using tools in Data Flow

Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and

more) for existing/new packages and huge CSV file import from different data sources and other ongoing

tasks for mapping.

● Extensively designed the packages and data mapping using Control flow task, Sequence container task,

Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS

2008.

● Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple

servers and resources.

● Involved in enhancing and deploying the SSIS Packages from development server to production server.

● Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.

● Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and

Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.

● Defined report layouts including report parameters and wrote queries for drill down reports using SSRS

2008.

● Developed complex reports using multiple data providers, user defined objects, aggregate aware objects,

charts, and synchronized queries.

● Administered interface to organize reports and data sources, schedule report execution and delivery, and

track reporting history using SSRS 2008.

● Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and

Database Engine Tuning Wizard.

● Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs

and alerts.

Tools & Technologies:

MS SQL Server 2008/2008R2, Query Analyzer, SSIS 2008/2008R2, T-SQL, Excel, SSRS 2008/2008R2,

SQL Server analysis services(SSAS), Windows Server 2003, ERWIN, Visio, SharePoint server.

Client: Morningstar, Chicago, IL

Duration: April 2010 - Jun 2011

Role: MS SQL Server /SSIS/SSRS Developer

Morningstar offer an extensive line of products and services for individual investors, financial advisors,

asset managers, and retirement plan providers and sponsors. This Project was about designing and

developing an enterprise data warehouse, and to develop a daily basis feed for the DSR (Data Staging

Repository) and Asset Management Reporting using Microsoft Business Intelligence technology like

Integration service packages, analysis cube and reporting services

Responsibilities:

● Involved in Logical, Physical design and Development of the DSR (Data Staging Repository) for the

Database and AMS (Asset Management Reporting System) using Erwin.

● Defined Check constraints, Business Rule, Indexes and Views.

● Worked with data modeling product support team on tool features, functionality and maintenance.

● Installed and configured MS SQL Server 2008R2 along with Visual Studio on a network domain system.

● Designed develop SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to

AMS database.

● Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions and

more using T-SQL to provide structure to store data and to maintain database efficiently.

● Created SSIS Packages to perform filtering operations and to import the data on daily basis from the

OLTP system, DSR to SQL server.

● Scheduled Jobs to run SSIS package in night feed to AMS for fresh day data. Load data form AMS

database to Data warehouse using SSIS packages.

● Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure

test results matched back to expected results based on business requirements.

● Generated reports using Global Variables, Expressions and Functions using SSRS 2008R2.

● Defined report layouts, report parameters and wrote queries for drill down reports using SSRS 2008R2.

● Created parameterized, drill down and aggregation reports using SSRS 2008R2.

● Administered interface to organize, schedule report execution, delivery, and track history using SSRS

2008R2.

● Responsible for the Performance tuning.

● Responsible for Backup and Recovery Strategy and Planning.

Tools & Technologies:

SQL Server 2008R2, ETL/SQL Server Integration Services (SSIS), Management Studio, MS SQL Query

Analyzer, SQL Profiler, Database Tuning Advisor, SSRS.

Client: Moore Stephens Business Solution, NY

Duration: Feb 2009 - March 2010

Role: MS SQL BI Developer

Moore Stephens International Limited is a global accountancy and advisory network. The project was

about the Data Center Migration Project which included up gradation and migration of SQL servers as

well as web servers to the new Data center

Responsibilities:

• Migrated from SQL Server 2005 to SQL Server 2008/2008R2.

• Designed and developed SSIS Packages to extract data from various data sources such as

Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and

Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional

Split, Bulk Insert, merge and union all.

• Responsible for performance tuning of existing SSIS packages and introduced dynamic

configurations, custom logging, Error Handling etc.

• Created the workflow documents for all existing and new SSIS packages.

• Responsible for Troubleshooting Report Processing, Subscription, Delivery and Configuration

• Developed Query for generating drill down and drill through reports in SSRS.

• Generated and formatted Reports using Global Variables, Expressions and Functions for the

reports. Designed and implemented stylish report layouts.

• Reported solutions to improve asset management, incident management, system events support

and billing.

• Successfully migrated data between heterogeneous sources such as flat file, Excel and SQL

Server 2005 using SSIS, BCP and Bulk Insert.

• Created SSIS packages architecting the flow of data from various heterogeneous sources into

target.

• Designed database objects like indexes, views, user defined functions, triggers, stored procedure,

constraints, and roles and documented all the procedures involved in the database for future

reference.

Tools & Technologies:

MS SQL Server 2005/2008/2008R2, T-SQL, SSIS, SSRS, Import and Export Data Wizard, SQL Query

Analyzer, SQL Profiler.

Client: Express Scripts, Bensalem, PA

Duration: June 2007 - Jan 2009

Role: MS SQL Server Developer

The project involved creating a database schema to perform analysis of various facets of patient care,

including electronic referrals, patient record, lab results and registry reporting and to generate various

reports such as HSA, HRA, RRA and more using SSRS 2005 and designed Staging Database using

Erwin.

Responsibilities:

• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 and

Oracle 10g using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction,

Aggregate, Pivot Transformation, and Slowly Changing Dimension.

• Used SSIS packages to Validate, Extract, Transform and Load data to DW and Data Mart Databases.

• Created various Parameterized Reports, Drill through Reports using SSRS 2005.

• Generated ad hoc reports using MS Reporting services.

• Reports were scheduled to be delivered by Email and File. Created Dashboard reports using SSRS.

• Generated reports using SSRS that were used to send information to different Primary vendors,

Clients and managers.

• Formed and developed the stored procedures, triggers to handle complex business rules, data

conversion, historical data, and audit analysis.

• Implemented a well-planned backup and restore strategy that protects databases against data loss.

Tools & Technologies:

MS SQL Server 2005, SSAS, T-SQL, SSIS, SSRS, Erwin, MS Access, MS Word

Contact this candidate