Sql Server Data

JAYRAJ PARSA

Professional Summary:

> Around * years of MS SQL Server Development experience with expertise

in MS SQL Server 2000 and MS SQL Server 2005/2008 suite of products

like SSIS, SSAS, and SSRS.

> Experienced in Data Extraction, Transformation and Loading (ETL)

between Homogenous and Heterogeneous Systems using DTS and SSIS of MS

SQL Server 2000 and MS SQL Server 2005 respectively

> Expert in Creating, Configuring and Fine-tuning ETL workflows designed

in DTS and MS SQL Server Integration Services (SSIS).

> Experienced in generating On-demand and Scheduled reports for Business

Analysis or Management decisions using MS SQL Server Reporting

Services 2005/2008 (SSRS).

> Expert in writing Parameterized Queries for generating Tabular reports

and Sub reports using Global variables, Expressions, and Functions,

Sorting the data, Defining Data sources and Subtotals for the reports

using SSRS 2005.

> Strong experience in Stored Procedure/TSQL coding, Performance tuning,

and Query Optimization.

> Highly proficient in the use of T-SQL for developing complex Stored

Procedures, Triggers, Tables, User Defined Functions, Relational

Database models and Data integrity, and SQL joins.

> Experienced in Logical and Physical Database design & development,

Data Conversion, Normalization and Data modeling using Erwin and SQL

Server Enterprise manager.

> Excellent experience in Designing, Maintaining & Tuning various RDBMS

like T-SQL & MS SQL Server 2000/2005, MS Access databases and strong

knowledge of SDLC principles.

> Involved in all phases of software development life cycle: design,

implementation and testing.

> Extensive knowledge in developing and implementing Disaster Recovery

Model, and Replication Models.

> Expert in using tools like MS SQL Profiler, Index Tuning Wizard,

Windows Performance for monitoring and tuning SQL Server performance.

> Excellent communication and inter-personal skills with ability to

develop creative solutions for challenging client needs using agile

methodologies.

> Ability to handle multiple tasks and responsibilities independently as

well as a proactive team member

Education Qualifications:

MS in Computer Science

Skill Set:

MS SQL Server 7/2000/2005/2008, SSIS, SSAS, SSRS, T-SQL, PL/SQL, MS Access,

Windows NT/2000/XP/2003 server, MS SQL Profiler, SQL Query Analyzer, MS

SQL Server Index Tuning Wizard, Visual Studio 2005/2008, Erwin Data

Modeler, Crystal Reports 8.5/9/10, C, HTML, XML, VBScript, Oracle 8i/9i/10g

Certifications:

70-431 Microsoft SQL Server 2005 - Implementation and Maintenance

70-445 Microsoft SQL Server 2005 - Business Intelligence and Maintenance

Projects Summary:

American International Group (AIG)/Chartis, NJ

11/2009 - Present

MS SQL Server/Business Intelligence Developer

Responsibilities:

> Involved in gathering and analyzing business requirements for

reporting purpose

> Analyzed & designed the business rules for data cleansing that are

required by the staging & OLAP and OLTP databases.

> Extracted data using SSIS packages (ETL) from different server

locations and data sources.

> Worked with integration services for transferring and reviewing data

from heterogeneous sources like Excel, CSV, flat file, Text Format

Data.

> Designed ETL architecture for overall data transfer from the source

server to the Enterprise Services Warehouse which encompasses server

name, database name, accounts, tables and direction of data flow,

Column Mapping, Data dictionary and Metadata.

> Creating, loading, and modifying a new package or an existing package

or add and configure components, making changes object by using

Control Flow Tools and Data Flow Tools and then verify it.

> Designed and implemented Parameterized and Cascading Parameterized

reports using SSRS.

> Deployed generated reports of each quarter onto the Report Server to

access it through browser.

> Created various geographical and time dimension reports of fiscal

year, quarter month, week and daily reports for all domains and

published through Report Server.

> Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click

through, Drill down, Drill through, Sub reports for students

registering with different schools.

> Retrieving data from SQL Server databases using VB.net

> Used Visual Source safe for repository and maintaining versions.

> Worked as a developer in creating Complex Stored Procedures, Triggers,

Functions, Indexes, Tables, Views and other T_SQL code and SQL joins

for applications.

> Conducted user training sessions and supported the requests for

enhancements, modifications and new reports.

Hardware/Software:

MS SQL Server 2005/2008 Analysis Services (SSAS), Reporting Services

2005/2008 (SSRS), Integration Services 2005/2008 (SSIS), T-SQL, Microsoft

Performance Point Server, C#, MS Access and Excel.

Department of Education, NY

02/2009 - 11/2009

MS SQL Server/Business Intelligence Developer

Responsibilities:

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

requirements and provided documentation.

> Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach,

Back up & Recovery and by Replication.

> Incorporated the DTS Packages into MS SQL Server 2005 Integration

Services by using Package Migration Wizard and Execute DTS 2000

Package task.

> Created SSIS packages to extract data from OLTP to OLAP systems and

Scheduled Jobs to call the packages and Stored Procedures.

> Created Alerts for successful or unsuccessful completion of Scheduled

Jobs.

> Used various SSIS tasks such as Conditional Split, Derived Column etc,

which did Data Scrubbing, including data validation checks during

Staging, before loading the data into the Data warehouse.

> Used ETL to implement the Slowly Changing Transformation, to maintain

Historical Data in Data warehouse.

> Created Error and Performance reports on SSIS Packages, Jobs, Stored

procedures and Triggers.

> Created Views to reduce database complexities for the end users.

> Created Sub-Reports, Drilldown-Reports, Summary Reports, and

Parameterized Reports in SSRS.

> Performed T-SQL tuning and optimization of queries for reports that

take longer execution time using MS SQL Profiler, Index Tuning Wizard

and SQL Query Analyzer in MS SQL Server 2005.

> Generated reports using SSRS that could be used to send information to

different Primary Vendors, Clients, and managers.

> Migrated DTS packages to SSIS.

> Performed Documentation for all kinds of reports, DTS and SSIS

packages.

> Designed and implemented Stored Procedures and Triggers for automating

tasks.

> Maintained the table performance by following the tuning tips like

Normalization, Creating Indexes etc.

> Used the HTML code to make the Report Manager more functional and

customizable.

> Evaluated database performance and performed maintenance duties such

as Tuning, Backup, Restoration and Disaster Recovery.

> Ensured best practices are applied and integrity of data is maintained

through security and documentation.

Hardware/Software:

MS SQL Server 2000/2005, T-SQL, MS SQL Server Integration Services 2005, MS

SQL Server Reporting Services 2005, MS SQL Profiler, SQL Query Analyzer,

SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin v4.1, Windows XP,

MS Office 2003/2007, MS Access, Crystal Reports 9/10.

Vaptech Inc, NJ

08/2008 - 01/2009

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

> Involved in requirements gathering, analysis, design, development,

deployment and user training.

> Created numbers of complex formulas in sub reports using different

type of variables likes shared variable and retrieved them from master

report.

> Involved in writing Custom Functions to be used in other Functions.

> Understood an existing system and designed modifications to the system

to support new requirements.

> Designed, developed and tested processes, which include the creation

of SQL views, scripts, stored procedures and DTS packages.

> Created Sub-Reports, Drilldown-Reports, Summary Reports, and

Parameterized Reports in SSRS.

> Created numbers of complex formulas in sub reports using different

type of variables likes shared variable and retrieved them from master

report.

> Involved in writing Custom Functions to be used in other Functions.

> Migrated DTS packages to SSIS.

> Understood an existing system and designed modifications to the system

to support new requirements.

> Designed, developed and tested processes, which include the creation

of SQL views, scripts, stored procedures and DTS packages.

> Extracted data using Query Analyzer and DTS packages.

> Tuned and optimized SQL statements, stored procedures and views.

> Wrote complex SQL queries and could quickly understand requirements

for complex queries and procedures.

> Configured, patched, tested, and supported all MS SQL Server database

instances.

Hardware/Software:

MS SQL Server 2000, MS SQL Server 2005, DTS, SSIS(SQL Server Integration

Services), SSRS(SQL Server Reporting Services),Windows NT/ 2000, Erwin

v4.0, MS SQL Server Profiler, Crystal Reports 8.5.

Grape soft Solutions, India

6/2005 -

7/2006

MS SQL Server Developer

Responsibilities:

> Involved in entire project life cycle including database design,

development, testing, optimizing, deploying on development and

production servers

> Actively involved in Normalization of database

> Created and managed schema objects such as Tables, Views, Indexes,

Stored Procedures, Clusters, Triggers and maintaining referential

integrity

> Involved in performance tuning of TSQL queries and Stored Procedures

> Wrote T-SQL statements for retrieval of data

> Involved in writing SQL batch scripts.

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

tables

> Used DDL and DML for writing triggers, stored procedures, and data

manipulation

> Performed daily database backup & restoration and monitored the

performance of Database

Server

> Optimized query performance by creating indexes

> Trouble shooting problems by using SQL server profiler

> Pro actively identified the problems before user complaints

Hardware/Software:

MS SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server

Query Analyzer, SQL Profiler

Contact this candidate