Sql Server Data

Divya Rao

*********@*****.*** Ph: 818-***-****

____________________________________________________________________________

Summary:

> Over 7+ years of strong experience as a SQL Server BI Developer

including Database Design, Development and Implementation of business

applications in various industrial sectors like Insurance, Healthcare,

Finance and Retail.

> Experience in all phases of the Software development Life Cycle

(SDLC).

> Expertise in dealing with Relational Database Management Systems with

strong understanding of concepts like Normalization, Integrity

Constraints.

> Strong experience in generating DDL, DML, System functions, User

defined functions, Joins, Views, Triggers, Stored Procedures, Indexes,

Sub queries and writing complex T-SQL queries.

> Expertise in designing the Conceptual, Logical and Physical data

models.

> Expertise in Database Design, Development for OLTP (Batch Processing,

Online Processing), OLAP, ODS, Star and Snowflake schema, ETL, MDX,

Data warehousing, Data mining, bill inmon and ralph kimball DW and

Data Modeling.

> Proficient in data loads, database integration/conversions, SQL

performance tuning and query optimization.

> Extensive experience in working with Business Intelligence

applications such as MS SQL Server Integration Services(SSIS), MS SQL

Server Reporting Services(SSRS), MS SQL Server Analysis

Services(SSAS).

> Experience in generating SQL server Reports using SSRS 2005/2008.

> Hands on experience in creating different types of Tabular Reports,

Matrix Reports, Drill-Down, Cross Tab Reports, Ad-hoc reports and

distributed reports in multiple formats using SQL Server Reporting

Services (SSRS).

> Experienced in cascaded parameterized reports, formatting report

layout, sub reports using global variables, expressions and functions

using SSRS.

> Experienced in configuration of report server and report manager

scheduling, give permissions to different level of users in SQL Server

Reporting Services (SSRS).

> Expert in Migrating DTS packages to SSIS and SQL 2000 databases to SQL

2005 and SQL 2008.

> Expertise in developing SSIS Packages to Extract, Transform and Load

(ETL)/DTS data into the Data Warehouse from Heterogeneous data sources

such as Excel, MS Access, Oracle, Sybase and DB2 to MS SQL Server.

> Extensively worked with various legacy systems like SAP, Siebel, MS

Access.

> Extensive experience working with BCP, DTS, SSIS packages, creating

jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.

> Expert in designing and scheduling complex SSIS Packages for

transferring data manually from multiple data sources like MS SQL

Server 2000, Oracle Database, Excel and Flat file to Microsoft SQL

Server by using SSIS and DTS utility of SQL server 2000/2005/2008.

> Experience in managing and automating Control flow, Data flow, Events

and Logging programmatically using Microsoft .NET framework for SSIS

packages.

> Experience in providing Logging, Error handling by using Event

Handler, and Custom Logging for SSIS Packages, Performance Tuning in

SSIS packages by using Row Transformations, Block and Unblock

Transformations.

> Extensive experience in creating SQL server Analysis Projects using MS

SQL Server Analysis services 2005/2008.

> Excellent knowledge in defining and deploying Cubes using SQL Server

Analysis Services (SSAS).

> Working knowledge on generating the reports by using Quick view

reporting tool.

> Working knowledge on Database backups, restore and Database

maintenance plans.

> Experience in scheduling the jobs and alerts by using SQL Server

Agent.

> Experience in designing the applications in ASP.Net using C# and

VB.Net.

> Good knowledge on Agile and Scrum software development methodologies

for the project management.

> Highly skilled in designing and deploying software products to meet

the customer needs.

> Capable to deal with the team members smoothly by positive attitude

and strong communication skills.

Education Qualifications:

BS in Computer Science

Technical Skills:

Operating System Windows NT/98/2000/2003 Server XP/Vista

Languages C, C++, C#.Net, VB.Net, ASP.Net, Java Script, VB

Script, ASP HTML, XML, T-SQL

Database MS SQL Server 2000/2005/2008, MS Access, Oracle 9i,

MySQL

Data Warehouse MS SQL Server Integration Services 2005/2008, MS SQL

Tools Server Reporting Services 2005/2008, MS SQL Server

Analysis Services 2005/2008, Crystal Reports,

Business Objects, Quick view, Cognos.

Tools/Utility Enterprise Manager, SQL Server Management

Studio(SSMS) 2005/2008, Business Intelligence

Development Studio(BIDS),MS Visual Studio

2003/2005/2008, SQL profiler, Data Base Engine

Tuning Advisor, Query Analyzer, Data Transformation

Services(DTS).

Microsoft tools MS Office, Visio, Ms Excel, MS-Project 2000, MS.Net

framework 2.0/3.0/3.5

Adobe tools Adobe Dreamweaver, Adobe Photoshop, Adobe Flash,

Adobe Cold Fusion

Data Modeling tool Erwin 4.0,Visio 2003

Version Controlling Visual Source Safe, Clear Case

tools

Work Experience:

Client: Xerox Corporation, NY

Jan 2009-Present

Xerox was founded in 1906 in Rochester as "The Haloid Photographic Company"

which originally manufactured photographic paper and equipment. Xerox

Corporation is a Fortune 500 global document management company which

manufactures and sells a range of color and black-and-white printers,

multifunction systems, photo copiers, digital production printing presses,

computer peripherals and related consulting services and supplies and

employs around 130,000 people.

Role: SQL Server BI Developer

Projects Involved:

XTPS (Xerox task planning system)

PSDB (practical size data base)

'A' level schedule

SAP Integration

Responsibilities:

> Involved in Blueprinting, Business requirement gathering, and mapping

of the business AS-IS process with TO-BE process.

> Involved in Planning, Defining and Designing data based on the

business requirement and provided documentation.

> Involved in gathering data and documenting it for further reference.

> Developed, executed and maintained SQL queries/scripts and to validate

completeness, integrity and accuracy of data.

> Extensively wrote and edited existing Stored Procedures, User Defined

Functions, Views and Triggers using T-SQL.

> Analyzed and fixed bugs in stored procedures on the ongoing database

operations, as needed, to resolve business problems.

> Involved in Performance tuning of Queries, Indexes and Stored

Procedures.

> Designed and developed SSIS packages, stored procedures, configuration

files, tables, views, functions and implemented best practices to

maintain optimal performance.

> Transferred data from various OLTP data sources, such as MS Access, MS

Excel, Flat files, and .Csv files into SQL Server 2008.

> Designed packages which utilized tasks and transformations such as

Execute SQL Task, Data Flow Task, ActiveX script task, Sequence

Container and conditional split, data conversion, derived column, Bulk

insert task, multi casting, and slowly changing dimension.

> Developed packages to handle slowly changing dimensions, data

cleansing, loading multiple files and executing tasks multiple times

(using for each loop task).

> Developed the ETL Transformations on SAP related objects for SAP

Integration project (Material Master, Vendor Master, Customer Master,

BOM, Work center, Inventory).

> Involved in deploying the SSIS packages to an instance of SQL server

and also to the file system by creating the deployment utility.

> Used stored procedures, functions, tables, views and triggers and

worked in designing and developing Reports, Data warehouses, Data

marts and Business Intelligence using multi-dimensional models such as

Star Schemas and Snow Flake Schemas.

> Created complex SSAS cubes with multiple fact measures groups, and

multiple dimension hierarchies based on the OLAP reporting needs.

> Hands on experience in implementing Key Performance Indicator (KPI)

Objects in SSAS and Create Calculate member in MOLAP cube using MDX in

SSAS.

> Fixing the ETL related issues if any and provides the ETL Output file

to SAP Team.

> Analyzed database performance with SQL Profiler and Optimized indexes

to significantly improve queries.

> Tuned several slow running queries in Production. Implemented Indexes

and re-indexed to achieve time performance.

> Scheduled, monitored SSIS Packages using SQL Server agent.

> Developed Parent - Child packages to load data in batches, ensuring

restart ability anytime without having to manually delete partially

loaded data from the destination tables.

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

Builder in SSRS 2008.

> Designed, Developed and Deployed sub reports, tabular reports, drill

down reports in MS SQL Server environment using SSRS-2008.

> Used complex expressions to Calculate, Group, Filter, Parameterize,

and Format the contents of the report according to the requirement.

> Created standard report Subscriptions and Data Driven report

Subscriptions.

> Used conditional formatting to change the behavior of the report

depending upon the requirement..

> Involved in backups, restore and recovery of the databases.

> Involved in designing and implementing messaging applications using

Service Broker.

> Providing On Support for the Other Data Team/End Users to resolve

Critical Issues during Cut Over, Production and Year End Support.

> Demonstrated ability of good leadership, teamwork, and project

management / communication skills.

> Excellent analytical skills, Quick learner and willing to contribute

in a team environment.

Environment:

MS SQL Server 2000/2005/2008, MS SQL Server Integration Services 2008, MS

SQL Server Reporting Services 2008,MS SQL Server Analysis Services 2008,

BIDS, MS Office, Windows Server 2003, Integrated with SAP.

Client: Philadelphia Insurance Company Jan

2008 - Dec 2009

Philadelphia Insurance Companies is an A+ rated carrier that designs,

markets and underwrites commercial packages and professional liability

insurance for select target markets.

Role: SQL server Data warehouse Architect

Responsibilities:

> Effectively used SDLC methodologies to define the project; this

includes defining business, functional, technical requirements,

implementation and post production support.

> Created several materialized views, stored procedures, indexes, joins

and correlated sub queries to be accessed by the new front end

applications.

> Performance tuning, and optimization of procedures and queries.

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

they can be dynamically deployed into Development, Testing and

Production Environments.

> Developed High Level Design of ETL SSIS Packages for integrating data

using OLE DB connection from heterogeneous sources (Excel, CSV,

Oracle, flat file, Text Format Data) by using multiple transformations

provided by SSIS such as Data Conversion, Conditional Split, Bulk

Insert, Fuzzy lookup, merge and union all.

> Develop the Slowly Changing Dimension Transformation to maintain the

Historical Data.

> Involved in creating Drill Down and cascaded reports with interactive

sorting in SSRS 2005.

> Return the custom code in Reports to avoid the case statement in the

SQL stored procedure.

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

needs.

> Developed reports using SSRS 2005 and used table control, matrix

control for cross tab reports.

> Worked on parameters to generate cascaded parameterized reports along

with that extensively used global variables, expressions and

functions.

> Responsible for deploying reports to Report Manager and

Troubleshooting for any error occurs in execution.

> Involved in Analyzing, designing, building &, testing of OLAP cubes

with SSAS 2005 Identified and defined Fact relationships in SSAS.

> Created Perspectives to customize the view to the end users.

> Involved in Optimizing MOLAP Cubes by partitioning them, Designing

Aggregations, implementing Hierarchies and Calculated Members.

> Processed the SSAS cube in transactional and full deployment mode.

> Involved in migration of the DTS package to SSIS by Import wizard and

complete Rewrite.

> Monitored, optimized and Performance Tuning of Regression Servers

using Performance monitor, SQL Profilers, Activity Monitor.

> Used Visual Source Safe for version control.

> Running DBCC consistency checks, and fixing data corruption in

application databases.

Environment:

MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server

Integration services 2005, MS SQL Server Analysis Services 2005, BIDS, SQL

Query Analyzer, Visual source safe.

Client: AvMed, Miami, FL

Feb 2007 -Dec 2008

AvMed's mission is to improve the health of members, members with quality,

cost-effective plans and excellent member services. AvMed's vision is to be

the health plan of choice. AvMed was created in 1969 as a prepaid health

care system for pilots in Miami's aviation industry. As one of the state's

oldest and largest not-for-profit health plan, corporate culture is defined

by compassionate, collaborative and ethical behavior focused on delivering

superior member service.

Role: SQL server BI Developer

Responsibilities:

> Involved in all phases of System Development Life Cycle (SDLC).

> Solved various T-SQL issues using Query Analyzer and created T-SQL

adhoc queries.

> Involved in package migration from DTS to SSIS, running upgrade

advisor against DTS Packages before migration, troubleshooting issues

and conversion into SSIS through wizard or manually.

> Experience in SSIS script task, look up transformations and data flow

tasks using T- SQL.

> Experience with SSIS performance tuning using counters, error

handling, event handling, re-running of failed SSIS packages using

checkpoints and scripting with Active-X and VB.NET in SSIS.

> Involved in ETL Loads using SSIS/DTS Packages from various

heterogeneous source systems into the databases for Dashboard

Reporting on a daily basis.

> Involved in Complete Rewrite of the DTS package into SSIS.

> Implemented Error handling and utilized Event handlers for automated

notifications using SSIS.

> Identified the information needs in the data integration within and

across functional areas of an enterprise database upgrade and

scripting/data Migration with SQL server DTS.

> Used SSRS Reports to write complex formulas and to query the database

to generate different types of ad-hoc reports, drill down, and drill

through reports for Business Intelligence.

> Monitored, optimized and Performance Tuning using Performance monitor,

SQL Profilers, Query Analyzer.

> Involved in building an extensive OLAP data warehouse on SSAS (Cubes,

star schema)

> Understanding the OLAP processing for changing and maintaining the

Warehouse. Optimizing Dimensions, Hierarchies and adding the

Aggregations to the Cube.

> Tested applications for performance, data integrity, validation

issues, job scheduling and alerts.

Environment:

MS SQL Server 2000/2005, SSRS, SSIS, SSAS, SQL Query Analyzer, SQL

profiler, Business intelligence development studio (BIDS), SSMS, Windows

2003 Server.

Client: Campus Federal Credit Union, Baton Rouge, LA

April 2006 - Jan 2007

Campus Federal Credit Union is a major financial services company in

Louisiana. The project was about analyzing market potential, generating

various reports and analyzing the performances of branches in financial

sector.

Role: SQL server developer

Responsibilities:

> Created functional specification document and technical specification

document.

> Created and managed stored procedures, indexed views, user defined

functions, triggers, joins database constraints to meet business

requirements and policies.

> Migrating of the DTS packages to SSIS packages by Complete Rewrite and

Import wizard.

> Wrote complex queries, DDL, DML, functions, triggers, stored

procedures, and views for new and existing applications.

> Wrote stored procedures for report generation in SQL Server2005.

> Developed Tabular Reports, Matrix Reports, Drill down Reports and

Charts using SQL Server Reporting Services (SSRS).

> Generated various Report models on Views (due to security issues) and

deployed them on to the production reporting server and generated

various Report models and ad-hoc reports.

> Worked with scheduling and publishing of reports in SQL server

reporting services and integration with Microsoft Office tools like

automatically emailing reports in various formats such as Excel, PDF

etc.

> Administrated the created Reports by assigning permission to the valid

user for executing the reports.

> Fine tuned SQL Queries for maximum efficiency and performance.

> Documented test plans, test cases and validation results.

Environment:

MS Visual studio 2008, MS SQL Server 2005, ASP.Net, C#.Net, Crystal

Reports.Net, MS SQL Server Reporting Services 2005, MS SQL Server

Integration services 2005, BIDS, SQL Query Analyzer.

State Bank of India, India

June 2003 - February 2005

MS .Net and SQL Server Developer

State bank of India is 29th most reputed company in the world according to

forbes.

Responsibilities:

> Involved in designing, developing and implementing of web

applications using ASP.Net, C#.Net, VB.Net.

> Extensively used ADO.NET for data retrieving, querying, storage and

manipulation.

> Involved in writing Stored Procedures and Views in SQL Database.

> Client side validations and Server side validations using JavaScript

and ASP.

> Created Data Access Layer Class Using ADO.

> Involved in various stages like development, system Analysis and

design, and creating stored Procedures.

> Debugged and fixed the bugs.

> Developed all the required stored procedures, user-defined functions,

and triggers using T-SQL.

> Designed and Implemented the Stored Procedures and Triggers for

automating tasks.

> Performed Extraction, Transformation and Loading using DTS.

> Optimized the performance of queries with modifications in T-SQL

queries, removed unnecessary columns, and eliminated redundant and

inconsistent data.

> Normalized tables, established joins and created indexes whenever

necessary.

Environment:

Visual studio 2003, ASP.Net, C#, VB.Net,ADO.Net, Java Script, SQL Server

2000, DTS, Windows Server, MS Access, MS Excel.

[pic]

Contact this candidate