Syamala N [pic]

215-***-****

Edison, NJ (Open for Relocation)

accjkl@r.postjobfree.com

SUMMARY

. Over 6 years of experience in IT Industry as Microsoft SQL Server

Database Developer, Over six years of experience as database and data

warehouse developer using SSIS and SQL technologies. Specialized in

Business Intelligence and Data warehouse (SSIS) and Reporting (SSRS)

Design, development and support.

. Responsible for supporting and coordinating all Microsoft SQL Server

20012/2008/2005. This includes configuration, maintenance, tuning, sizing

and planning in production, testing, and development environments.

. Created complicated SQL procedures to meet the requirements of the

systems being developed.

. Extensive exposure to create data warehouse databases, objects, stored

procedures, triggers, security, SSIS (i.e. Import and Export), Bulk

Loading of Data, ETL operation, Transact-SQL, and SQL Server Agent and

SQL Server profiler.

. Thorough understanding and significant experience in ETL processes,

particularly SSIS.

. Experience in working extensively on system analysis, design,

development, testing and implementation of projects in Software

Development Life Cycle (SDLC).

. Experienced with scripting in T-SQL in constructing tables, joins, user

functions, views, indexes, triggers, synonyms and user profiles.

. Developed complex stored procedures and Queries for implementing business

logic and process in backend, for data extraction, reports and other

client interfaces.

. Created the Common table expressions, Temp tables & Table variables in

the stored procedure for different application.

. Experienced working on Normalized Databases and designed database/tables

and the requisite relationships, designed partition tables and partition

views.

. Implemented Performance Technique for rebuilding indexes.

. Hands-on working experience with analyzing query plans, managing indexes

and locks, troubleshooting deadlocks.

. Managed all database servers in development, staging, test and production

environments.

. Highly skilled in creating dynamic and customized packages for ETL from

various data sources using SSIS.

. Experienced in performing Incremental Loads and Data cleaning in SSIS.

Expert in handling errors, logging using Event Handlers in SSIS.

. Expert in creating weekly different types of reports like Tabular,

dashboards, Drill-Down, Drill through Parameterized and sub-reports

using variables in using Microsoft Visual Studio to design RDL Files.

. Expert in Report Subscriptions and Reporting Services Configuration

Manager Tool.

. Creation and maintenance of Databases, Creating Roles and Managing

User Permissions.

. Hands on installing, configuring, managing, monitoring and

troubleshooting SQL Server 2012/2008/2005.

TECHNOLOGY

Operating System Windows 2k, 2003 server, XP and Vista

T-SQL, PL/SQL, C++. T-SQL, PL/SQL, C++.

Databases SQL Server 2005, 2008 and 2012

Tools Visual Studio 2005, 2008, SQL Server Management

Studio, SQL Server Business Intelligence Development

Studio (SSIS/SSRS/SSAS), Reporting Services

Configuration Tool, Data Transformation Services, SQL

Server Profiler,SQL Server Agent, Erwin4.x,

Office Tools Ms-Access, Ms-Excel, Ms-Word, Ms-Outlook.

Scheduler SQL Server Agent

Version Control Team Foundation Server (TFS) and VSS

Systems

Gvy XML, HTML

Reporting Tools SSRS

ETL Tools MS SQL server Integration Services (SSIS)

CERTIFICATIONS & TRAINING

Microsoft SQL Server 2008 Database Development

EDUCATION

Masters of Sciences Osmania University

PROJECT EXPERIENCE

Project Title: OR Data Mart, Care Fusion and Nurse Call

Duration: July 2011-Present

Client: Mount Sinai Medical Center, NY

Role: MS SQL/SSIS/SSRS Developer

Project Description:

Mount Sinai Medical Center is a world class health care provider that is

committed to patient care, research, teaching and service to the community

locally and globally. I was involved in different projects to improve the

patient care by implementing Data Extraction Transformation Loading and

generate reports and alerts for Clinical Nurse Managers and Physicians and

pathologists using SSIS, SSRS.

Responsibilities:

. Transformed complex business logic into database design, creating

datawarehouseing schema's and maintaining it by using SQL objects,

stored procedures, user defined functions, views, T-SQL scripting

and jobs. Extensively worked in analysis of data and determine

relationships and dependencies from raw data.

. Interacted with Strategic Development Team, Business analyst and

Nurse Managers to analyze business needs and developed technical

specifications.

. Created databases, tables, views, Joins, triggers, functions,

union, Merge, indexes, constraints, stored procedures and SSIS

packages based on business requirements.

. Worked on different levels of ETL Loads like Extract Data from

Source System to Staging, preparing schema and then from Staging to

load data into Production Database Tables.

. Design and development of complex datasets and ETL operations using

SSIS. Experience in requirement analysis design and development of

a dimensional data model (star schema and Snowflake) and the

development of ETL processes using SSIS.

. Involved in complete SDLC, which includes requirement gathering,

analysis, design, development, testing and Implementation,

Extensively used Agile Methodology Performed unit testing and

Integrated testing successfully.

. Developed ETL's using transformations like OLE DB Source, OLE DB

Destination, Derived Column, Data Conversion, OLE DB command,

Slowly Changing Dimension, Union All, Script Task, Flat file

Source, Flat file Destination, Conditional Split.

. Deployed the SSIS Packages to DEV and QA Environments and then

deploy into Production.

. Scheduled SSIS jobs to run the Hourly, Daily, Monthly Using Sql

server agent jobs.

. Created, altered and Managed Databases Tables, Views, Indexes, and

Constraints as per business rules.

. Key responsibility is performance tuning including reading /

understanding query plans and alter queries and other database

objects.

. Conducting code review and design reviews for the components which

were created.

. Created Tabular, Matrix reports, Charts and graphs, Dashboards as

per customer requirements Using SSRS.

. Good understanding of SSRS with Report authoring, Report

management, Report delivery and Report security.

. Created and developed query for Drill Down, Drill through and AD

Hoc Reports using SQL SSRS.

Environment: SQL Server 2012, 2008, SQL Server Integration Service

2012, 2008, SQL Server Reporting Service 2012, 2008,

SQL Profiler.

Project Title: Claim data Process

Client: MetLife

Duration: May 2010 - June 2011

Bridgewater, NJ

Role: MS SQL Server/SSIS /SSRS Developer

Project Description:

The MetLife bank is a federally chartered bank that provides services like

checking, credit card services, student banking, online banking, mobile and

text banking. The project involved creation of data marts by extraction of

data through legacy systems and incremental dump by implementation of ETL

strategies.

Responsibilities:

. Involved in complete SDLC, which includes requirement gathering,

analysis, design, development, testing and Implementation.

. Transformed complex business logic into data warehouse database design

and maintaining it by using SQL objects, stored procedures, user defined

functions, views, T-SQL scripting and jobs.

. Design and modeling of Framework Meta data model, Schema's normalization

and indexing.

. Email notification & Schedule design and implementation.

. Created Integration Services (SSIS) to perform multiple data

extractions from different application.

. Helped to adapt the data load SSIS packages from heterogeneous

environment. The SSIS packages utilized variables, expressions,

loops, and scripts and Migrated 2005 SSIS packages to 2008.

. Creating dynamic Stored Procedures for Reporting in SSRS.

. Created store procedures to calculate net return and Gross return of

the Funds.

. Created Drill Down, drill through, sub and linked reports using the

SQL Server Reporting Services SSRS as well as managed the subscription

and authentication of these reports.

. Involved in Creating SSRS Dash boards and reports.

. Trouble shooting abstract data, profile, analyze and optimize data

Testing and Error handling.

. Monitor databases for errors and perform problem determination when

necessary.

. Documentations for design, testing, bug fixing status update, on call

if necessary.

. Conducting code review and design reviews for the components which

were created.

Environment: SQL Server 2008, 2005, SQL Server Integration Service 2008,

2005, SQL Server Reporting Service 2008, SQL Profiler, MS Excel.

Project Title: Pathology Data Mart

Client: Partners Health Care

Duration: Feb 2009- April

2010

Boston, MA

Role: SQL Server Developer/SSIS/SSRS

Project Description:

Partners Healthcare is a health care system that is committed to patient

care, research, teaching and service to the community locally and globally.

The aim of project was to improve the treatment of disease and delivery of

medical care. The project involved loading Clients information in data ware

house using SSIS and then created reports using SSRS.

Responsibilities:

. Transformed complex business logic into dataware house database design

and maintaining it by using SQL objects, stored procedures, user defined

functions, views, T-SQL scripting and jobs.

. Interacted with business analyst, Development Team and Managers to

analyze business needs and developed technical specifications.

. Analysis of data, creation of schema's database objects

. Design and development of SQL objects, stored procedures, user defined

functions, views, temporary tables, T-SQL scripting and jobs, performance

tuning of queries, analyze and fine tune query plans.

. Designed and developed SQL Server Integration Services (SSIS)

packages for data migration.

. Designed and implemented data warehouse environment, responsible

for ETL operation.

. Development of building blocks that involves business logic and control

flow.

. Testing and Error troubleshooting, documentations for design, testing,

bug fixing.

. Created and developed Parameterized, Drill Down and AD Hoc Reports

using SQL Server 2005 Reports Services (SSRS).

. Created lot of custom reports for the pathologist using complex stored

procedures.

. Created Sub Reports, Linked reports for Pathology department

management.

. Conducting code review and design reviews for the components which were

created.

Environment: SQL Server 2008, 2005, SQL Server Integration Service 2005,

2008, SQL Server Reporting Service 2008 .

Client: HDFC Bank New Delhi, India

Duration: March 2006-Nov 2008

Role: MS SQL

Project Description:

HDFC is a diversified financial service company. The company engages in

Branch Banking, Consumer Lending and Commercial Banking. Mission was to

clean and scrub the data to acquire its more granular form before loading

to data warehouse. The data warehouse will address HDFC Bank's need for a

business intelligence solution.

Responsibilities

. Monitored all activities of the server by monitoring the daily SQL

jobs, SQL Server error logs and Windows error logs.

. Using T-SQL statements, worked with DML and DDL for retrieval and

modification of the data.

. Created & used stored procedures for database transactions, union,

joins, Functions, Cursors, temporary tables in SQL Server.

. Developed backup & restore scripts for SQL Server as needed.

. Identified slow running query and optimization of stored procedures

and tested applications for performance, data integrity using SQL

Profiler and creating index, statistics and optimized queries by using

execution plan for performance tuning of the database.

Environment: MS SQL server 2005, T-SQL.

Contact this candidate