Sql Server Data

[pic][pic]

KAUMIL GANDHI 312-***-****

SQL Server Data Warehouse & Business Intelligence Developer

[pic]

Profile Summary:

> Over 5 years of experience in SQL Server with thorough knowledge of

various RDBMS concepts and applications using 2000/2005/2008/R2.

> 4 years experience in Database and Data Warehouse Development

> 4 years experience with SQL Business Intelligence Studio, SSIS, SSRS,

SSAS.

> Thorough Software Development life cycle (SDLC) experience including

development, designing, analysis, coding, testing and implementation.

Certification:

> MS SQL Server 2008, Implementation and Maintenance.

> MS SQL Server 2008 Programming from Brain bench.

SQL Analysis and Integration Services:

> Experience in using SSIS 2005 & 2008 (SQL Server Integration Services)

for data extraction, transformation and loading (ETL).

> Experience in DTS Migration, Upgradation and Metadata Management:

Migrating DTS to SSIS, Package Migration Wizard, and Storage

Management.

> Experience in Error & Event Handling: Precedence Constraints,

Break/Check Points, Logging.

> Thorough Knowledge of Various SSIS Objects such as Dataflow

Components, Control Flow Elements, Connections Managers, Log Providers

etc.

> Extensive Experience in Creating, Populating and maintaining Data

marts. Thorough knowledge of Attributes, Star & Snow Flake Schemas of

Data Marts.

> Experienced in Building Cubes & Dimensions with different

Architectures and Data Sources for Business Intelligence.

> Experience in Deploying Cubes on the Analytical Server and connecting

objects with various cubes.

Reporting Services:

> Experience in creating both forms of reporting like Ad Hoc as well as

Enterprise Reporting.

> Extensively worked on three stages of enterprise reporting like

Authoring, Management and Delivery using SQL Server reporting services

(SSRS).

> Experienced in creating various types of reports table, chart and

matrix report, web reporting by customizing URL Access.

> Worked on creating client reports and custom reports (On demand, Ad

Hoc Reports, Frequency reports, Summary Reports, Sub Reports, Matrix

Drill-down, Dynamic grouping, Cross-Tab, graphical, etc) using SSRS

2005 & 2008.

Education:

Master in Computer Science, IIT, Chicago - December 2009

Bachelor of Engineering in Computer Science, Anna University, India - May

2006

Technical Skills:

DATABASE SQL Server 2000,2005/2008/R2, Oracle 10g, SQL,

PL/SQL, MS Access

Languages C, C++, C#, JAVA, T-SQL, PL/SQL, MDX

Database SQL Management Studio, SQL Business Intelligence

Technologies/ Studio, SSIS, SSAS, SSRS, SQL Enterprise Manager,

Business SQL Server Profiler, DTA.

Intelligence Tools

Web Technologies ASP, ASP.NET, ADO.NET, VB.Net, HTML, OLEDB, IIS and

XML

Others MS Visio 2003/2007, ERWIN, UML, Visual Source Safe

Business Objects Crystal Report 9/10/11, MS Excel

Operating Systems Windows XP/Server 2008/2003/2000/NT4/98/95, Linux,

UNIX

Professional Experience

NRECA - Arlington, VA Aug '10 -

Till Today

Database Integration & Data Warehouse Developer

Working on Projects:-

- Crystal Reports Migration to SSRS 2008

- Common Data Management (SSIS & SSRS)

- EOB (Electronic Sign-up for NEB Application)

Responsibilities:

. Developed SSIS ETL Packages & also modified packages into different

environment (Development, Testing & Production), as ongoing

requirement changes.

. Extract/Load/Transformation data from different Source System like

BAS, BW, NEB, netFORUM, etc into Data Warehouse for Daily, Weekly &

Monthly incremental SQL jobs.

. Enhance SSIS packages to perform dynamic functionalities from static

configuration, and also changed many of the packages by using C#

coding for generic usage within the organization.

. Created & modified SSRS reports (2005 & 2008) depend on the

requirement on the priority basis from the DW & BW bug tracker

applications.

. Migrated existing rpt/Crystal Reports 9 to SSRS 2008 for Membership

Group application.

. Worked with Report Manager & Report Viewer to integrate with NEB & BW

Intranet Application.

. Worked closely with Hyperion Reporting Tool for converting existing

Brio reports to SSRS 2008.

. Deployed reports to SSRS 2005/2008 on Development and Production

Report Manager.

. Worked on the performance and high priority critical issues to meet

deadlines for SSIS package execution and also into for SSRS reports

rendering.

. Currently working with CDM project (nF Change Detection)for their Data

Warehouse Database process to in-corporate clean data storage from

different source systems, also working to integrated Reporting Server

with CDM portal using SharePoint Integrated mode.

. Used Subversion/Mercurial for centralized storage within the Data

Warehouse department.

. Used JIRA for tracking issues, default and enhancement for the legacy

tasks.

Environment: Microsoft Windows Server 2008/2003, SQL Server R2/2008/2005,

SSRS R2/2008/2005, SSIS 2008/2005, SSMS, BIDS, VS 2008/2005, Query

Profiler, ERWIN, SQL Sentry, Sub Version, Crystal Reports 9, Hyperion

Interactive Report Studio/Brio

First Solar Inc., Perrysburg, OH Aug

'09 - July '10

Data Warehouse and Business Intelligence Developer

First Solar is the largest manufacturer of thin film solar modules, having

expanded manufacturing capacity to an annualized run rate of 53.4MW per

line in the 4th quarter of 2009.

Worked on Projects:-

- MLDA (Module Lifecycle Data Analysis)

- DAX2BW Extracts

- DAX-SAP Migration

Responsibilities:

. Created stored procedures & triggers for the MLDA (Module Lifecycle

Data Analysis), where by changing the structures & data-type of the

existing objects with the requirements.

. Migrated package from different source system by using different

versions of MS SQL Server.

. Also worked with CRM & ERP database for pulling out data into SSIS for

the MLDA project.

. Extensively worked with hashing and filtered views of the CRM

database.

. Re-designing tables from flat de-normalized tables to star schema

normalized tables using fact and dimension scenarios for more

optimization & more productivity into the existing Data Warehouse.

. Dump & loaded Giga & Tera bytes of data from different environment

using SSIS package & also from different source system (DAX, MES, MIS,

CRM etc).

. Extensively created Package Configuration, In-build & Custom Logging,

Error & Event handling, & Email Notification for new as well as for

existing packages as per requirements.

. Also worked with staging database for load-balancing into production

environment.

. Optimize the Data Warehouse by compression database into Row & Page

Level Compression.

. Extensively worked with SSAS OLTP & OLAP cubes & also used KPI's, Data

Source, DSV, Calculated Members, Browsing the cube with one or

multiple fact & dimension tables.

. Worked with Snowflake & Star schema into SSAS, querying the cube with

MDX queries.

. Extensively worked with all different kinds of reports mainly with Sub-

report, Drill-down, Detailed, Matrix Drill-down, Ad-Hoc & Charts

reports.

. Deployed the reports to different environment using Report Server &

Report Manager. Also used Subscription (Standard & Data-Driven) to in-

corporate the features with FS SharePoint portal.

. Worked with creating reports from multi-dimensional cubes for

Managerial & End User.

. Engineering and Procure department using extensive Dashboards created

by DW group in SSRS using Matrix, Dynamics reports and great use of

Dundas Controls.

. Migrated reports from SSRS 2005 to SSRS 2008 using RS Scripter with

existing Subscriptions, History and Data Sources & also changed the

hieratical order.

. Participated in database Upgrade from SQL Server 2005 to 2008 in

support with the existing UI.

. Also worked with tracking tickets by using Track IT! 8.5 application

and Citrix, VMware 7 for remote as well as for virtualization servers

& used TFS (Team Foundation Server) environment for sharing &

deploying the project for the team development.

. Extensively worked with tracking, issuing & solving Change Request

into Production environment and DBA supporting VLDB (Very Large

Databases) in several business sectors.

Environment: Microsoft Windows Server 2008/2003, Microsoft SQL Server

2008/2005/2000, SSRS, SSIS, SSMS, MS Office 2007/2000, BIDS, Visual Studio

2008/2005, Query Profiler, DTS xChange, DTA, ERWIN

Nationwide Children's Care Hospital, Columbus, OH

Aug '08 - July '09

SQL Server Developer

Nationwide Children's Hospital in honor of a transformational gift from

Nationwide Foundation and the landmark impact it will have on the delivery

of world-class pediatric health care in central Ohio and beyond.

Responsibilities:

. Developed SSIS Packages to export data from Excel (Spreadsheets) to

SQL Server 2008 and get the reports, routinely, in the excel sheets,

required by the managers for analysis.

. Created SSIS packages to download the files from secure https websites

& stores them in database.

. Participated in designing Logical data models for the Data Warehouse.

. Design and develop OLAP components of these large Business

Intelligence Data Warehouse applications using SQL Server Analysis

Services (SSAS) versions 2008.

. Work on future initiatives to add data mining/data analysis

capabilities to OLAP/Reporting.

. Participated in the database Migration & Upgradation from SQL Server

2000 to SQL Server 2005/2008 for the support of CLR and .NET 2.0

Integration.

. Extensively worked on migrating DB from SQL Server 2000/2005 to 2008

by DTSX packages.

. Worked with JDBC (Java Database Connectivity), for using legacy

application using SQL Server.

. Participated in implementing the logical design to the physical design

by creating tables.

. Transferred flat files from different sources to the ETL tier by using

BCP.

. Created prototypes DTSX packages to show the functionality of FUZZY

LOOKUP and Merge Table tasks to the clients using SSIS.

. Used various types of Control Flow tools and Data Flow tools like

Container, Aggregate, Derived column and Conditional Splitting

according to need of Data scrubbing.

. Created and deployed different types of reports like Chart, Matrix,

List and others depending upon requirements by using SQL Server

Reporting Services.

. Developed and schedule reports for Daily, Weekly, Monthly reports

using SSRS.

. Reviewed the existing stored procedures and improved efficiency by

critically evaluating the code.

. Involved in Set up, configuration and maintenance of Transactional &

Merge Replication (Pull & Push) on MS SQL Server 2005.

. Created Backup and Scheduling Backups for Disaster Recovery, Used SQL

LiteSpeed.

. Performed Index analysis for tables and came up with more efficient

solutions to use Clustered and Non-Clustered Indexes for significant

performance boost.

Environment: Microsoft Windows Server 2008/200, Microsoft SQL Server

2008/2005/2000, SSRS, SSIS, SSMS, Microsoft Access 2000, XML, BIDS, Visual

Studio 2008/2005, Query Profiler, DTS xChange, DTA, Crystal Report 10/11,

Oracle SQL Developer, ERWIN, Upgrade Advisor.

RITVI, Vadodara, India July

'06 - Mar '07

SQL Server Developer/DBA

Ritvi is an Indian software services and consulting company. It provides

information technology and business process outsourcing services.

Responsibilities:

. Involved in design and development of application interface.

. Involved in Database Design, worked on Normalization and De

Normalization to come up with the optimum performance during design

phase.

. Design Complex Reports using Crystal Report & SSRS 2005.

. Unit testing with test data and live data & monitor functional,

Integration testing before deploying.

. Developed middle and front tier using ASP.NET and VB.NET.

. Established backup and recovery procedures for all application

production data.

. Export and import data from various MSSQL Server 2000, AS/400 and XL

data using DTS and BCP.

. Designed and validated the forms using the application using VB.

. Designed data models using Erwin.

. Developed physical data models and create DDL scripts to create

database schema and database objects.

Environment: Visual Basic 6.0, SQL Server 2005/2000, ERWIN, ASP.NET,

Crystal Reports

Contact this candidate