Sql Server Data

Raghuveer Goud

Email: ab8s01@r.postjobfree.com

Phone: 210-***-****

Professional Summary

> 7 years of extensive experience in IT industry as MS SQL Server

Developer and in depth proficient experience in OLTP, Data warehouse,

OLAP and Database technologies.

> Strong experience in Business Intelligence (BI) using Microsoft Visual

Studio 2008/2005.

> Exceptional hands on working knowledge and recent experience working

with SQL Server Integration Services (SSIS) and SQL Server Reporting

Services (SSRS).

> Extensive experience in developing Stored Procedures, Views, Triggers,Complex Queries on SQL Server 2000/2005/2008.

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

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

and Stored Procedures.

> Expert in developing T-SQL (DDL, DML) statements, Data Integrity

(constraints), Rules, Performance Tuning, Query Optimization and Data

Validation issues.

> Created, Built and deployed successfully dynamic SSIS packages into

SQL Server 2008/2005 databases and scheduled them according to

requirements.

> Skilled in error and event handling, precedence Constraints, Break

Points, Check points and Logging.

> Experience in enhancing and deploying the SSIS Packages from

development server to production server.

> Proficiency in using different ETL tools like DTS packages, BCP and

Bulk Insert as well as SQL Server Integration Services (SSIS).

> Experience in developing, configuring and deploying the SSIS packages

and providing security for the packages.

> Used SSIS to create ETL Packages to validate, extract, transform and

load data to data warehouse databases, data mart databases.

> Designing, developing and capacity planning for database, Expert in

creating SSIS packages and sending alerts using SQL Mail.

> Experience in Error handling and debugging coding issues and

troubleshoot production problems.

> Used Execution Plan, SQL Server Profiler to trace the slow running

queries and tried to Optimize SQL queries for improved performance and

availability.

> Experience in Integrating SQL Server Reporting Services (SSRS) with

Microsoft Office Share Point Server 2007.

> Experience in creating drill down, simple, matrix reports using SSRS.

> Excellent report creation skills using Microsoft Reporting Services

(SSRS) with proficiency in using Report Designer as well as Report

Builder.

> Expertise in Creating Report Models for building Ad-hoc Reports using

SSRS.

> Excellent hands on experience scheduling and the deployment of the

reports and uploading files to a report server catalog from the report

manager.

TECHNICAL SKILLS:

SQL Server Tools SQL Profiler, Query Analyzer, MS SQL Server Management

Studio, DTS, SSIS, SSRS

Database MS SQL Server 2008, 2005, MS-Access 2003/2005.

Language C,C++,TSQL,VB.NET,ASP,C#

Operating System Windows 7/NT/2003/2008, Unix, MS DOS

Tools Erwin Data Modeler, Access, Crystal Reports XI,R2

PROFESSIONAL EXPERIENCE

Computer Science Corporation, Overland Park, KS

Nov 2011-July 2012

SQL Developer/SSRS Developer

CSC has developed smart, technology-

enabled solutions to solve clients' toughest challenges, demonstrating a

commitment to excellence and a passion for exceeding expectations.

Responsibilities:

> Involved in moving data from Oracle server to SQL server CrossRoads

using SSIS Import/Export Wizard.

> Implemented different types of constraints like Primary key, Foreign

keys on tables.

> Responsible for converting the data using CTE's (Common Table

Expressions) and Merge Statement.

> Create joins and sub-queries for complex queries involving multiple

tables.

> Created Parameterized reports, Drill down reports & Summary reports by

Using SSRS.

> Gathered user requirements.

> Responsible for creating reports based on Report Definition Document

(RDD) using SSRS 2008 R2.

> Used Share-Point to gather RDDs and updated the RDDs.

> Responsible for Data Mapping the RDDs field Names to that of Source

Table Columns.

> Created Ad-Hoc Reporting with Report Builder and Programming Reporting

Services.

> Created data-related documentation (e.g., file descriptions and

definitions, entity relationships and attributes, etc.).

> Deployed and generated reports on to the Report Server to fine tune

the database objects and server to ensure efficient data retrieval.

> Developed Queries for generating reports in SSRS 2008.

> Used dynamic parameters in SSRS to enable/disable the parameters based

on user selection.

> Wrote Parameterized Queries for generating Tabular reports, Matrix

Reports and Sub reports using Expressions, and Functions, Sorting the

data.

> Identified and defined the Datasets and Data Sources for the report

generation

> Performed some aspects of database administration backups

and recovery.

Environment:

SQL Server 2008 R2, SSIS, SSRS, .Net Frame Work, XML, MS Access,

Excel, C#, ASP .Net, Share point Server 2007.

Fannie Mae, Washington D.C, D.C

Feb2010-Oct2011

SSIS/SSRS Developer

Description: Fannie Mae operates in the U.S. secondary mortgage market.

Rather than making home loans directly to consumers, they work with

mortgage bankers, brokers and other primary mortgage market partners to

help ensure they have funds to lend to home buyers at affordable rates.

Responsibilities:

> Created SSIS packages from scratch to move data from flat file, Excel

and OLE DB sources.

> Involved in Data Staging includes importing data, parsing, scrubbing

by using SSIS tools.

> Implemented Complex Logging in SSIS Packages.

> Generated parameterized/Drilldown/Subreports reports using SSRS.

> Generated Reports using Global Variables, Expressions and Functions

for the reports using SSRS.

> Used various transformations in SSIS like Lookup, Fuzzy grouping, Row

count Transformations.

> Build efficient SSIS packages for processing fact and dimension tables

with complex transforms and type 1 and type 2 slowly changing

dimensions.

> Perform ETL operations for Business Intelligence reporting solutions

using custom VBA and Excel web queries.

> Responsible for the creation and maintenance of Analysis Service

objects such as Cube, Dimensions, MDX queries, and KPI's.

> Scheduled SSIS jobs using SQL Server Agent and 3rd party scheduler

like CA and Autosys.

> Created complex SSIS packages (Master-child) with properties like

package configurations, SSIS loggings as well as custom loggings using

event handlers.

> Designed SSIS Packages to transfer data between servers, load data

into database, and archived data file from various sources such as SQL

Server, Oracle, Excel, CSV etc. on to a SQL server 2005.

> Migrated DTS packages to SQL Server Integration Services and modified

the existing packages by using the advanced features and tools (pivot

Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term

extraction, Aggregate).

> Extracted, cleaned and validated from XML file into database using

SSIS task (XML source).

> Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS

Packages.

> Created Report Snapshots to improve the performance of SSRS.

Environment:

MS SQL Server 2005/2008, Windows 2003/2005, SSIS, SSRS,

Management Studio, SQL Server Business Intelligence Studio, C#, ASP.Net, MS

Access 2003/2005.

Premier Bankcard Inc., Sioux Falls, SD

May2009-Jan2010

SQL Developer

PREMIER Bankcard Inc. is a leading credit card provider in the United

States, specializes in offering credit to help individuals establish or re-

establish their credit.

Responsibilities:

> Created Database Objects Schemas, Tables, Indexes, Views, User defined

functions, Cursors, Triggers, Stored Procedure, and Constraints.

> Extensively used Joins and Sub-Queries to simplify complex queries

involving multiple tables.

> Used various transforms in SSIS to load data from flat files to the

SQL databases.

> Worked as a developer in creating complex Stored Procedures, SSIS

packages, triggers, cursors, tables, and views and other SQL joins for

building various applications.

> Developed reports where the data extracted from SSAS cubes in SSRS.

> Designed reports using SQL Server Reporting Services (SSRS).

> Extract, Transform and Load (ETL) source data into respective target

tables to build the required data marts.

> Designed and developed data load jobs using SSIS package and scheduled

in SQL Agent.

> Wrote stored procedures and User Define scalar Functions (UDFs) to be

used in the SSIS packages and SQL scripts.

> Designed cubes with star schema using SQL Server Analysis Services

(SSAS).

> Migrated DTS packages to SSIS packages using Package migration wizard

and also tested all packages on development server.

> Extensively used SSIS Import/Export Wizard, for performing the ETL

operations.

> Worked on Event Handler to do Event handling on error at the package

and task level on error, on warning and configured it using send email

task and script task.

> Developed Aggregations, partitions and calculated members for cube as

per business requirements.

> Created efficient SSIS packages for processing fact and dimension

tables with complex transformations.

> Responsible for monitoring the progress of a SSIS packages and logging

progress to a text file, SQL Tables and windows event log.

> Generated reports using Global Variables, Expressions, and Functions

for the reports.

> Involved in generating Matrix reports, Sub reports and Complex reports

with multi value parameters for the analysis of Performance using

SSRS.

Environment:

MS SQL Server 2005, MS SQL Reporting Services 2005,

ASP.Net, MS Excel, MS Access 2003, Window 2000 Server.

APS Healthcare, White Plains, NY

July 2008-April 2009

SQL BI Developer

APS Healthcare has been dedicated to the design and delivery of specialty

healthcare services that focus on health improvement and improving quality

of life.

The project involved designing, developing, and testing a data

warehouse for APS Healthcare. The project scope was mainly focused on the

optimization of existing databases and ETL Strategies to promote the speed

and latency of various operational processes.

Responsibilities:

> Ensured project requirement and delivery with active interactions with

end users

> Redesigned and tuned stored procedures, triggers, tables, UDF, views,

recursive CTE, indexes and was successfully able to increase the

performance of the queries.

> Experience in creating multiple reports (SSRS) in Drill mode using

tables, cross tabs and charts.

> Created complex store procedures for data profiling process needed to

define the structure of the pre staging and staging area.

> Developed DTS packages to extract, transform and load into the

Campaign database from OLTP database using of SQL Server 2005

Integration Services (SSIS).

> Used SSIS control flow task Analysis service processing task to

individually process the partitions and the dimensions and updating

the cube as changes occurs in underlying data warehouse.

> Created automated backup of OLAP cubes as well as normal backup using

SQL server management studio and SSIS package.

> Extensively involved in all the phases of report life cycle

(Authoring, Managing, Delivering)

> Created ad-hoc reports, and complex Enterprise reports (drill down,

and drill through reports, Parameterized reports, cascading report)

using SQL Server Reporting Services and report manager. Created linked

reports using report builder.

> Involved in trouble-shooting of reports in Authoring, managing, and

delivery phases on multiple servers.

> Used Notification services to generate error messages and send them to

the user through e-mails.

Environment:

MS SQL Server 2005, Windows XP/2003, T-SQL, SQL Server Integration

Services, SQL Server Reporting Services, Erwin

Ranbaxy Laboratories Ltd, India

Jan07-May08

SQL Server Developer

Ranbaxy Laboratories Ltd. is the largest pharmaceutical company in India,

and one of the world's top 100 pharmaceutical companies. The system being

developed simplified the process of on-line ordering of its products. I

started my IT career with this project as an SQL developer.

Responsibilities:

> Gathered functional requirements and written the technical

specifications

> Designed logical / physical data models and defined primary key,

foreign key using Erwin tool.

> Wrote T-SQL statements using DML and DDL for retrieval of the data.

> Created complex stored procedures, triggers and cursors in SQL Server.

> Developed source to target specifications.

> Developed stored procedures, functions, views and triggers.

> Developed stored procedures to transform the data from enterprise data

warehouse to APT data mart to build dimensions and load data to fact

tables.

> Created DTS package to schedule the jobs for batch processing.

> Performance tuning to optimize SQL queries using query analyzer.

> Created indexes, constraints and rules on database objects.

Environment:

MS SQL Server 2000, MS Access, DTS, Erwin 4.1, SQL Query Analyzer, VB,

Crystal Report

Religare Technova Global Solutions Ltd, Bangalore, India

June 05-Dec 06

SQL Server Developer

Religare Technova Global Solutions Limited (RTGSL), formerly Asian CERC

Information Technology Limited, provides software solutions to the

financial services industry. The Company's primary business segments

include Trading Solutions (including customization, installation and

support services) and Information Services Division (subscription/data

content feed).

Responsibilities:

> Involved in the entire System study, analysis and Design.

> Installation, configuration of MS SQL Server 2000 for development and

testing purpose

> Involved in developing database objects such as triggers, constraints,

indexes and views.

> Used T-SQL to build dynamic stored procedures.

> Managed Database files, transaction log and estimated space

requirements.

> Developed Database Triggers to enforce Data integrity and additional

Referential Integrity.

> Developed SQL Queries to fetch complex data from different tables in

remote databases. using joins, database links and formatted the

results into reports and kept logs.

> Responsible for developing automation of maintenance jobs, tuning SQL

Server locks and indexes configurations, administering SQL Server

security.

> Designed and implemented several complex reports and administration

modules.

> Created DTS package to schedule the jobs for batch processing.

> Involved in Performance Tuning, Query Optimization, Database

consistency checks using DBCC utilities.

> Involved implementing Disaster Recovery for minimal downtime using

different types of database backups, restore, and replication.

Environment: Server 2000 Enterprise Edition, T-SQL, Enterprise manager, MS

Office and Windows 2000.

Contact this candidate