Sql Server Data

SUSHMA K

Phone: 956-***-****

**************@*****.***

SUMMARY

Over 5+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server

****/******/**05/2000 with various business domains like Healthcare, Insurance, Finance in Development, Testing and

Production Environments

• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server

2012/2008/2005.

• Experience in Creating Tables, Joins, Views, Indexes, Triggers, Stored Procedures, User Defined Functions,

synonyms, collections, Exception handling, Query Tuning using query optimizer.

• Experience in writing T-SQL objects, stored procedure in SQL Server 2005 to SQL Server 2008 and SQL

Server 2008 to SL Server 2012.

• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering

index appropriately on data structure to achieve faster data retrieval.

• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using

Triggers and Primary and Foreign Keys.

• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.

• Strong Knowledge on concepts of Data Modeling Star Schema/Snowflake modeling, FACT & Dimensions

tables and Logical & Physical data modeling.

• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.

• Responsible for database development and performance tuning of the T-SQL queries using SQL

Profiler and Activity Monitor.

• Successfully implemented indexes on tables and views for optimum performance tuning.

• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points,

Logging.

• Expert Knowledge of Integration Services (SSIS) and Reporting Services (SSRS). Worked Extensively on

ETL process using SSIS packages.

• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources

(Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as

Data Conversion, Conditional Split, Bulk Insert, merge and union all.

• Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export

Utility, BCP (Bulk Copy Program) and DTS Packages.

• Responsible for designing ETL solutions/ framework with SSIS. Also responsible for the

performance tuning of the ETL packages.

• Responsible for Data Migration from SQL Server 2005 to SQL Server 2008 and SQL Server

2008 to SQL Server 2012 Databases.

• Migration of SSRS reports from SQL 2005 to SQL 2008. Migration experience with DTS to SSIS 2008.

Extensive experience with data modeling techniques, logical and physical database design.

• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance,

implementing technology solutions, and training end users.

• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports

like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports and formatting

them using both SSRS 2005/2008.Very good knowledge in scheduling and deploying reports on report manger.

• Developing reports on SSRS on SQL Server (2000/2005/2008). Sound Experience and understanding of SSAS,

OLAP cube and Architecture.

• Experience in Designing, Developing and Maintaining Web Applications using Visual Studio .NET,

ASP.NET MVC 3, C#, VB.NET, ADO.NET.

• Good communication with the project team throughout all stages of design, managing time effectively, and work

on multiple project timelines simultaneously in a demanding deadline driven environment.

TECHNICAL SKILLS

• : C#, C, C++, VB.NET, Visual Basic for Applications (VBA) and

Programming Languages

ASP.NET.

• : MS SQL Server 2012, 2008 R2, 2008/2005/2000, Oracle 8i/9i/10g,

RDBMS

MS-Access 97- 2007

• : SQL Server Management Studio (SSMS), Enterprise Manager, Query

SQL Server Tools

Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business

Intelligence Development Studio (BIDS), SSIS, SSAS, SSRS, Data

Transformation Services.

• : ERwin r7.3/7x/4.0, MS Office Visio 2003/2007.

Data Modeling Tool

• : Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51,

Operating System

Windows 3.x, Windows 9.x, Windows 95/98/XP.

• : Logical and Physical Database Design, Star Schema, Snow Flake

Methodologies

Model, UML, Database Design and Normalization.

: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB

• Other tools

visualize.

PROFESSIONAL EXPERIENCE

Assurant Solutions, Miami, FL Dec

2013 – Till date

Senior SQL Server BI Developer

Assurant Solutions is part of Assurant, a premier provider of specialty insurance products and related

services in North America, Latin America, Europe and select worldwide markets. The project involves

creating web applications, which involves front-end and back-end. I was involved in developing back-end

operations i.e. creating Conceptual and Logical Entity Relationship Diagrams to creating Database, Tables,

View, Triggers and Stored Procedures and executed SSIS packages to populate data from various data

sources.

Responsibilities:

• Created database objects like tables, complex Stored Procedures, Functions, Views, Triggers,

Indexes and T-SQL queries (DDL and DML) to meet the business requirements using T-SQL.

• Created Joins and sub-queries for complex queries involving multiple tables.

• Used DDL and DML for writing Triggers, Stored Procedures, and Data manipulation.

• Involved in writing SQL Stored Procedures to access data from MS Access. Developed SQL

queries to check the database.

• Created functions and developed procedures for implementing application functionality at the

database side for performance improvement.

• Pulling the data from T-SQL stored procedure to make the parameterized reports.

• Hands on MS SQL Server configuration, performance tuning, client/server connectivity, query

optimization, back-up/recovery, running Database Consistency Checks using DBCC using SQL

Server Profiler, Execution Plan and Performance Monitors.

• Generated packages using different Transformations like Lookups, Derived Column, Merge Join,

Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component.

• Responsible for Data Migration from SQL Server 2005 to SQL Server 2008 and SQL Server

2008 to SQL Server 2012 Databases.

• Experience in providing Logging and Error handling by using Event Handler and Custom Logging

for SSIS Packages.

• Deployed the created SSIS packages in Development and Testing environments.

• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse

databases and data mart databases.

• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)

version.

• Created SSIS package to automate maintenance, database back up, update statistics, re-build

indexes as well as create error log for event during data load.

• Used event handlers for accepting handling in SSIS packages. Involved in scheduling and

administering the SSIS packages.

• Used VB.Net and other .NET languages for Script task. Script task is primarily to control the flow

of SSIS package.

• Backing up, Restoring system & other databases as per requirements, and also scheduled those

backups.

• Developed Query for generating drill down, drill through, parameterized, cascaded reports in

Crystal Reports 2011.

• Worked on SQL Server Reporting Services (SSRS) and Report Builder Model to generate custom

reports.

• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.

• Created and Managed OLAP Cubes using SSAS.

Environment : SQL Server 2012, T-SQL, Crystal Reports 2011, MS SQL Server Integration Services

(SSIS), Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools,

Query Analyzer, SQL Server Profiler, SVN version controlling. ASP.NET Framework 3.5/4.0, C#, Visual

Studio 2012, AJAX, WCF, ADO.NET,

CPA State of Texas, Austin, TX Aug 2011–

Nov 2013

SQL Server BI Developer

CPA is a Financial firm which provides tax and accounting services in Austin and throughout Texas and is

responsive to the companies who choose this firm rely on competent advice and fast, accurate personnel.

CPA provides total financial services to individuals, large and small businesses and other agencies. The

objective of this project was maintenance and enhancement of a few databases for the tax and account

services department. The enhancement was planned by importing a few tables from different databases

(Finance), modifying the existing table structure, creating necessary views and temporary tables and loading

the data in to database.

Responsibilities:

• Developed SQL Queries to fetch complex data from different tables in remote databases using

Inner/Outer joins, sub-queries, accommodating complex filters and database links.

• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.

• Developed complex Stored Procedures to process prospective customer information and balanced

the processing load between front end and back end.

• Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Developed views using complex split week logics.

• Performed Data Modeling in the initial stages of the project.

• Worked in AGILE methodology using SQL Server 2008 R2.

• Experienced in developing stored procedure driven reports, building custom application on

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

• Optimized the performance of queries with modification in TSQL queries, removed unnecessary

columns, eliminated redundant and inconsistent data, normalized tables, established joins and

created clustered/non-clustered indexes wherever necessary.

• Successfully implemented indexes on tables and views for optimum performance tuning.

• Involved in query optimization and performance tuning.

• Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning

Advisor

• Implemented error handling in several existing Stored Procedures using Try Catch blocks.

• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition

Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to

generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text

file, MS Access and CSV files to data warehouse.

• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms

and type 1 & type 2 changes.

• Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.

• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using

subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.

• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and

Excel format using SSRS 2008.

• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on

Drill Down and Drill-through Reports, Tabular, Matrix etc.

• Handled complex financial data and large databases.

• Used ADO.NET for retrieving, querying, storage, and data manipulation.

• Implementation of client side validations using ASP.NET validation controls.

Environment: SQL Server 2008 R2/2008, T-SQL, Excel, MS Access, Microsoft BI, Windows Server 2008,

Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling,

ASP.NET, C# 3.5/2.0, .NET Framework 3.5/2.0.WebService, ADO.NET, HTML, CSS.

Birla Sun Life Insurance Company Limited, India Aug 2009-

July2011

SQL Server Developer

Birla Sun Life Insurance is one of India’s leading life insurance companies. Because of the strong investment

lineage of Birla group Birla Sun Life Insurance is able to offer a comprehensive variety of products and

services that suit the diverse needs and risk-return profiles of every investor. The Project started in 2003 with

a life Insurance Plan. The requirement here was assisting building database and also modifying when

required. Integrating different databases and finally giving report about the effective policies sales.

Responsibilities:

• Involved in Physical and Logical design of the databases.

• Developed DTS Packages to transfer the data between SQL server database and files.

• Created and maintained Data Transformation Service (DTS) packages for migrating data.

• Scheduled Jobs for DTS packages.

• Used BCP/Bulk Insert to publish table output to text files.

• Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User

Defined Functions and Stored Procedures.

• Responsible for database development and performance tuning of the T-SQL queries using SQL

Profiler and Activity Monitor.

• Used all Declarative Constraints for maintaining Data Integrity.

• Created Views to restrict access to data in a table for security.

• Involved in performance tuning of T-SQL queries and Stored Procedures.

• Implemented Auditing using triggers.

• Created schema objects, rules and granted roles to the users.

• Used SQL Profiler to debug T-SQL and slow running queries.

• Monitored the Database Performance using execution plans and Index tuning.

• Optimized the query performance with modifications in TSQL queries, removing unnecessary

columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary

joins.

• Involved in scheduling backups of databases and logs and restoring them when necessary.

Environment: MS SQL Server 2000, T-SQL, Windows 2000 server, Windows NT 4.0.

EDUCATION

• Bachelor of Science in Computer Science from JNTU, India.

Contact this candidate