Sql Server Developer

Rashmi Ghosh *******@*****.***

Cell 312-***-****

Home 312-***-****

SUMMARY:

Over 7+ years of IT experience including SQL SERVER database design, development,

administration, query optimization /performance tuning, Analysis Services/Reporting Services

and Windows System Administration.

Experience in Software Development Life Cycles like

gathering requirements, design, development, testing

and production support.

Expert in complex coding in T-SQL for handling transactions, audit trail and dynamic

mappings .

Experience in calling stored procedures, functions, triggers from SSIS packages, .NET

programs through CLR extensions.

Experience in normalization of databases, maintaining entity relationship between tables,

manual table locking for multithread dealer processes.

Experience with SSIS performance tuning using counters, error handling through event

handlers.

Experience in admin activities like failover, clustering, backup, recovery, log shipping and

disaster recovery.

Experience in file processing, logging and SQL activities using custom tasks like (BFD) in

SSIS control flow.

Experience in client/server connectivity, Query Optimization, Performance Tuning and

database consistency checks using DBCC commands.

Experience in design and development of reports using Crystal reports 9.0 and SQL Server

Reporting Services (SSRS).

Experience in writing reports using MDX (Multi Dimensional Query) from dimension, hierarchy

and measure.

Worked on linked and remote servers to run distributed queries between SQL server and other

data sources like excel using ODBC, OLE DB drivers

Experience in data-warehouse tools like Ascential DataStage 7.0,Unix scripting, I-Series

Navigator and SmartFTP client tools for file lookups and loading to final tables.

CERTIFICATION:

Microsoft (MCTS) SQL Server 2005 Implementation and Maintenance 70-431

EDUCATION

Bachelor of Science in Computer Science, India

TECHNICAL SKILLS

RDBMS: MS SQL Server 2005/2000/7.0/6.5,Oracle 9i, MS Access 97/2000

BI Tools: SSIS, SSRS,SSAS,DTS

Reporting Tools: SQL Server Reporting services,Crystal Reports 9.0/8.0

Operating systems: Windows server 2003, Windows 2000 advanced server, Windows NT/95/XP, MS DOS

Languages :C,C++,T- SQL, VB.NET,C#

Web Applications: ASP.NET 2.0, SOAP, HTTP, IIS 6.0, FTP, TCP/IP, LAN, MS-Outlook Express

Other Tools: SQL Profiler, DataStage 7.0,DB2 Connect, Data Tuning Advisor, COM+, Visual Studio

2005,Query Analyzer, Command Line Utilities, MS Excel, Visual Source Safe

Scripts: HTML,Unix, JavaScript, VB Script, Perl Script, Batch Script (windows)

WORK PROFILE

The Warranty Group, Chicago July 08- Till Date

SQL/SSIS Developer

The Warranty Group is a Chicago, IL based Insurance Company have domain on claims and auto

Insurance. The project involves different stages like database design,data import in SSIS and interface

building using SQL Reporting Services.

Responsibilities:

Worked extensively on SSIS developments from scratch like file parsing, archiving, logging

and loading to tables using SQL tasks.

Extensively worked on Agile project management using SCRUM to meet deadlines and

documented the Software Project Design Document (SPDD) for Log Shipping and Database

design.

Experience in debugging, error handling, package deployment using DTUTIL in DEV and UAT

environments.

rd

Managing the use of disk space, memory and connections using DBCC Utilities 3 party tools

like RED GATE.

Back end Experience in MS SQL Server development, writing complex queries, stored

procedures, views, triggers, cursors, UDFs.

Experience in SQL joins, sub queries, tracing and performance tuning for better running of

SSIS packages.

Monitored SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks

/user counts and connections/locks etc.

Experience with MS Analysis services (SSAS), writing MDX to query cubes using measures, hierarchies.

Scheduled the backups for Databases and Transaction log Performed restores and

suggested backup strategies.

Experience with Snapshot Replication from Main-Frame to SQL Server 2005.

Production Support of Data Stage 7.0 jobs, running Unix Shell scripts, I-Series scripts for file

checks.

Worked on SQL Server Reporting Services to generate hierarchical reports and drill down

reports and tested using Management Studio in SQL server 2005.

Environment:

Vb.Net, Ado.Net, Asp.Net 2.0, SSRS, SSAS, SQL Server 2005,Unix, I-Series, DataStage 7.0,Red Gate,

DB2 (Main-Frame), Visual Studio, SQL Profiler,Active Directory and Windows XP platform.

Kentuky Farm Bureau, Louisville Oct 07 –Jun 08

SQL DBA/ Developer

Kentuky Farm Bureau is a Louisville, KY based Insurance company have domain on auto insurance. The

project was a migration from SQL 2000 to 2005 . The project involves dynamic mapping, unit testing and

production support.

Responsibilities:

Experience in full SDLC in Database Migration from SQL Server 2000 to 2005 using Bridging

Scripts, Column Mapping Tool and Team Foundation Servers.

Test backup and recovery strategies by simulating various recovery scenarios like loss of data

files, transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS).

Use case scenarios and wrote them according to specifications and Implemented UML

methodologies to design Context Diagram, Use Case Diagrams, Data Flow Diagrams, Activity

Diagrams, Sequence Diagram and ER Entity-Relationship.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and

Visual Basic(VB) scripts. .

Back end Experience in MS SQL Server development, writing complex queries, stored

procedures, views, triggers, cursors, UDFs.

Linked business processes to organizational objectives, performing critical path analysis,

analyzing ER diagrams.

Experience in SQL joins, sub queries, tracing and performance tuning for better running of

queries.

Wrote and maintained database documentation, including data standards, procedures,

definitions for the data dictionary and logical and physical models of the databases.

Environment:

MS SQL Server 2005, MS SQL server 2000, T-SQL,C#,VB.NET, Excel, SSIS, Data Analyzer, Visual Studio

2005, Advanced Windows 2000 Server, Microsoft Windows Active Directory 2000

Philadelphia Insurance Companies, Philadelphia,PA Feb 06 –Sep 07

BI Developer

Philadelphia Insurance Companies a Philadelphia, Pennsylvania based insurance company specializing in

Property and Casualty Insurance The Philadelphia Insurance focuses on providing the insurance

products mainly in the area of auto, homeowners and small-business.

Responsibilities:

Report writing based on tickets submitted from front end people using SQL Server Reporting

Services (SSRS) and Crystal Reports 9.0

Experience in ETL tools like SSIS for data flow from one source files like Excel, Tables,

Views to other databases or files with proper mapping.

Ad-hoc report design, grouping and sorting using Visual Studio, SQL Reporting

Services(SSRS) and Crystal reports 9.0 and also importing sub-reports into it.

Experience with stored procedure driven reports, building custom application on reports,

formula writing/editing in reports, Report Administration and performance tuning of reports.

Experience with writing MDX which multi dimensional queries and aggregate functions related

to cubes, measures, hierarchies, processing cubes and deployment of cubes.

Experience with Key performance Indicators(KPIs), design of star schema and snowflake

schema in MS Analysis Services(SSAS).

Created and Modified Triggers and Dynamic Cursors in T-SQL for maintaining SQL server

databases and assigned permissions to a role for Stored Procedures for Application

Developers

Implemented Security which included creating Logins, Users and granting permissions to

users.

Participated in developing Logical design of database incorporating business logic and user

requirement and building entity relationship (ER) diagrams.

Experience in Configuring IIS, Command line utilities ie rsconfig in host scripting, modifying

encrypted connection information and backup/restore of symmetric keys for future.

Environment:

Visual Studio.NET 1.1, IIS, ASP, C#, MS Analysis Services(SSAS), MS SQL Server 2005, T-SQL,, Excel,

Access, SQL Reporting Services(SSRS), SSIS, Data Analyzer, Visual Studio 2005, Crystal Reports 9.0

State Street,Boston, MA Nov 04–Jan 06

SQL Developer/DBA

State Street is Boston, MA based company have domain on Investment Banking and Trust and its offices

are globally located. It focuses on investors interest and building long term business relationships with

customers.

Responsibilities:

Determined the MS SQL Server 2000 installation options. Installed SQL Server Management

tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented

different security modes.

Installed and maintained database applications to improve processing performance including

applying upgrades, patches, and bug fixes in all database instances

Used Aggregation Design Wizard to decide best possible aggregation for a given amount of

disk space in MS Analysis services 2000.

Experience in DTS for data flow from one source files like Excel, Tables, Views to other

databases or files with proper mapping.

Implemented a successful security plan by creating statement permissions, linked servers and

encryption of connections by creating certificates.

Experience with Distributed transactions building linked servers, complex queries, error

handling using savepoints in OLTP transactions.

Creating distributed partitioned Views, debugging / troubleshooting Stored Procedures,

upgrading existing ones.

Configured Database Mail, created operators, jobs and alerts for automating databases .

Experience in creating, debugging DTS packages using Active X Task, dynamic properties

task to for file check, sending mails upon package completion, and file archiving.

Designed DTS package, with DTS Import/Export wizard for transferring data

Data migration (Import & Export – BCP) from text to SQL Server

Environment:

MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Analysis Services 2000, MS Access

2000 & Windows NT platform, Reporting Services, Crystal Report 8.0, DTS,Windows Active Directory

JP Morgan,India Apr 03- Oct 04

SQL/Sybase Server Developer

Worked for XCEL Energy as SQL Server developer. The key functional areas for XCEL Energy are

Power Generation, Distribution, and Transmission. Customer base reporting project: expand from business

to residential customers.

Responsibilities:

Added / Changed Tables, columns, triggers, and T-SQL code. Using Indexes, Views, Trigger

and Store Procedures for updating and cleaning the existing data and also the new data which

was to be added

Expertise in Rational Unified Process (RUP) methodology, Use Cases, Software Development

Life Cycle (SDLC) processes and OOAD Object Oriented Design Technologies.

Migrating MS Access / Sybase SQL Server 11.5 databases to SQL Server 11.9. Creating

new database / tables to put in the extracted data and rebuilding the relationship

Applying constraints and writing triggers to apply the business rules. Backing Up & Restoring

User Databases

Experience in Configuring IIS, Command line utilities ie rsconfig in host scripting, modifying

encrypted connection information and backup/restore of symmetric keys for future.

Environment:

Windows 2000/ XP, Sybase SQL Server 11.5, SQL Query Analyzer, SQL Developer edition.

Contact this candidate