Sql Server Data

Krishna J

Professional Summary:-

. Over *+ years of MS SQL Server Development experience with expertise

in MS SQL Server 2012/2008R2/2008/2005/2000 and Microsoft's suite of

products like SSIS, SSAS, and SSRS.

. Highly experienced in Creating, Configuring and Fine-tuning ETL

workflows designed between Homogenous and Heterogeneous Systems using

SSIS of MS SQL Server 2008R2, MS SQL Server 2008 and MS SQL Server

2005 respectively.

. Experienced in creating complex SSIS and DTS packages for ETL

purposes. Implemented complicated transformations to be used in SSIS

packages.

. Expertise in Data Conversion, Normalization and Data Modeling, Multi-

Dimensional Modeling and involved in creation of Fact Tables,

Dimension Tables, Star Schema and Snowflake dimensional schema using

Erwin Tool.

. Proficient in creating On-demand and Scheduled reports, handling sub

reports and defining query for generating drill down reports using MS

SQL Server Reporting Services 2008R2/2008/2005 (SSRS).

. Experienced with client server application where XML feeds were

consumed and Store Procedures were called using ADO.NET

. Experienced 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 2008R2/2008/2005.

. Strong experience in Stored Procedure, Formulated 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, views, indexes,

user profiles, Relational Database models, Data integrity, query

writing and SQL joins.

. Expert in using tools such as Bulk Copy (BCP).

. Extensive knowledge in developing and implementing Disaster Recovery

Model, and Replication Models.

. Having IT experience on IBM Mainframe environment working in

Development and maintenance applications.

. 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 and Certifications:

Bachelor in Computer Science

Business/Technical Skills:

MS SQL Server 2012/2008R2/2008/2005/2000/7, MS Access, SQL, Transact-SQL

(T-SQL), PL/SQL, C, C++, XML, MS SQL Server Integration Service (SSIS),

MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Service

(SSRS), SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning

Wizard, Visual Studio 2008/2005, DTS SQL Developer, ERWIN, Crystal

Reports 8.5, Windows Server- 2008/2003/NT/XP/2000, Windows vista.

Projects Summary:

Lincoln Financial Group,Philadelphia,PA

Feb 2013-Present

MS SQL Server Developer/SSIS/SSRS

The aim of the project is to design and develop Enterprise Data warehouse

and migrate the data from different sources into the databases using SSIS

and creating Store Procedures using T-SQL.

Responsibilities:

. Worked with business stakeholders, application developers,

production teams and across functional units to identify business

needs and discuss solution options.

. Agile methodology was used throughout the project, Performed pivotal

role in planning and developing as well as aligning with the assigned

sprints.

. Developed and deployed SSIS packages for ETL from OLTP and various

sources to staging and staging to Data warehouse using Fore Each Loop

Container, Execute Package task, Execute SQL Task, Sent Mail

task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly

Changing Dimension and more. Performed ETL mappings using MS SQL

Server Integration Services.

. Supported Production Environment with schedule the packages and make

the package dynamic with SQL Server Package Configuration.

. Wrote complex SQL queries using joins, sub queries and correlated sub

queries to retrieve data from the database.

. Created/Updated database objects like tables, views, stored

procedures, function, packages.

. Designed Change data capture to capture insert, update, and delete

activity applied to SQL Server tables, and to make the details of the

changes available in an easily

. consumed relational format.

. Rigorously tested and debugged the Stored Procedures and used Triggers

to test the validity of the data after the insert, update or delete.

. Deployed reports on Report Server and SharePoint Server also scheduled

reports using SSRS to generate all daily, weekly, monthly and

quarterly reports including current status.

. Developed and delivered dynamic reporting solutions using MS SQL

Server 2008 Reporting Services (SSRS).

. Involved in monitoring and tuning report performance by analyzing the

execution plan of the report.

. Generated Drill down, Drill through, Matrix Reports, parameterized

reports, cascading parameterized Reports using SSRS.

. Designed and developed monthly, quarterly and yearly reports at branch

and company level.

. Involved in table and index partitioning for performance and

Manageability.

. Identified, tested, and resolved database performance issues

(monitoring and tuning) to ensure database optimization.

. Monitored the overall performance of the database to recommend and

initiate actions to improve/optimize Performance.

. Used SQL Server Profiler to trace the slow running queries and the

server activity.

Tools & Technologies:

SQL Server 2012/2008R2, Server Integration Services 2012, SQL server

Reporting Service 2012, Microsoft Visual Studio, SQL Server Management

Studio, MS Excel, T-SQL,ERWIN 7.2, C#

INTEL Corp,Austin,TX

Sep 2012 to Jan 2013

MS SQL Server Developer/SSIS/SSRS

Intel Corporation designs, manufactures, and sells integrated digital

technology platforms worldwide. This project was to, extract data from

various heterogeneous sources and server locations and load into SQL Server

2012/2008R2 and create reports such as Aggregate Adverse Event Report,

Customer Detail Report, Account Report and Reports based on the company

progress.

Responsibilities:

. Created Star schema dimension modeling for the data mart using Visio

and created dimension and fact tables based on the business

requirement.

. Gathered report requirements and determined the best solution to

provide the results in either a Reporting Services report, Analytical

Cube or an Excel pivot table

. Designed SSIS packages to Extract data from different sources like SQL

server 2012/2008R2,MS Excel, MS Access, transform and then load

into Dimension and Fact tables in Data Warehouse using SSIS .

. Migrated data from Development to UAT servers and deployed packages to

different servers.

. Applied various data transformations like Slowly Changing Dimension,

Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and

Derived column etc.

. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup,

Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data

Flow Task, and Execute Package Task etc 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.

. Developed SSIS packages using for each loop in Control Flow to process

all excel files within folder, File System Task to move file into

Archive after processing and Execute SQL task to insert transaction

log data into the SQL table

. Produced operational reports in SSRS 2012/2008R2 i.e. drill-down,

drill-through, dashboard and matrix reports.

. Generated monthly and quarterly reports as bar charts for the

management using different techniques like data filtering, adding

interactivity, deploying reports to report server using SSRS

. Converted manual reports pasted together into parameter driven stored

procedures to be used with Microsoft Reporting Services 2012/2008R2

. Attained legacy data to use as a source to develop new reports

previously compiled and maintained manually

. Translated XML Input file data to another XML from consumed by UI.

. Developed functional and technical documentation to assist in the

design, development and/or maintenance of deliverables

. Created SSRS Data Model projects using Microsoft Visual Studio

2010/2008 and using Report Builder for report server to create reports

. Configured the report server and generated the report models for user

interactions

. Responded to ad hoc requests and special projects that require

immediate attention while at the same time maintaining deadlines on

existing requests.

. Developed and maintained system documentation, diagrams and

flowcharts.

. Worked with project manager and technical leads for resolution of

technical issues.

Tools &Technologies : -

MS SQL Server 2012/2008R2, SQL server Reporting Services 2012/2008R2, SQL

Integration Services 2012/2008R2, Microsoft Visual Studio 2010/2008, SQL

Server Management Studio, MS Excel, T-SQL, Visio.

McKinsey & Company NYC, NY

Nov 2011 to Aug 2012

MS SQL Server Developer/SSIS/SSRS

McKinsey & Company is an American global management consulting firm that

focuses on solving issues of concern to senior management. The project was

to use integration services to populate Data Warehouse and generate

parameterized reports from the database containing different types of

insurance policies and customers.

Responsibilities:

. Worked on the complete life cycle of the project from design to

implementation

. Translated user requirements into functional and technical

requirements in coordination with the Sr. Business Analyst

. Executed Store Procedures using ADO.NET framework.

. Analyzed the business requirement and functional specifications

provided by the data specialist

. Worked on SSIS for transferring data from Heterogeneous Data format to

SQL Server.

. Developed SSIS packages using Change Data Capture (CDC) functionality

using complex store procedures, Execute SQL Task and Data FLOW Task in

Control Flow and OLE DB Source, Script Component Transformation and

OLE DB Destination in Data Flow.

. Migrated few Oracle sources to SQL server development environment.

. Developed SSIS Packages using Look Up Values & implementing rules

provided by Business in the mapping document.

. Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for

data cleansing purpose.

. Used SSIS Variables for storing the values which are used in various

components of Data Flow Task.

. Developed Unit Test Plans for SSIS packages for checking the

functionality of each component.

. Modified the existing SSIS packages to meet the changes specified by

the users.

. Scheduled Jobs for executing the stored SSIS packages which were

developed to update the database on Daily basis

. Documented the complete data warehouse environment, including all

dimension and fact tables, the relationship between SSIS packages and

the target tables, which packages were valid and in use, the

relationship between the jobs and SSIS packages.

. Designed and maintained a wide variety of daily, weekly, and monthly

financial and analytical reports used by different departments within

the company.

. Accountable for making sure reports are scheduled and delivered in a

timely manner.

. Designed reports using proper text formatting, report headers and

footers, and page size to allow for printable reports.

. Created ad Hoc and parameterized various reports using SQL server

2008R2 reporting Services with data from SQL Server and MS Access as

data sources

. Created ad hoc SSRS reports in the test environment for data

validation

. Produced dynamic Reports from the cube using SSRS 2008R2, and stored

procedures.

. Troubleshoot the deployment of reports in the test and production

environment using SSRS.

. Cleaned the data and created fact and dimension tables, performed

calculations required for the reports using SQL Server 2008R2

environment and accomplished data modeling.

Tools &Technologies : -

MS SQL Server 2008R2, SQL server Reporting Services 2008R2, SQL Integration

Services 2008R2, SQL Analysis Services 2008R2,Microsoft Visual Studio, SQL

Server Management Studio, MS Excel, T-SQL,ERWIN.

Citigroup, Jersey City, NJ

Jan 2011 to Oct 2011

MS SQL Server Developer/SSRS/SSIS

Citigroup is a diversified financial services holding company, provides

various financial products and services, including consumer banking and

credit, corporate and investment banking, securities brokerage, wealth

management, and transaction services to consumers, corporations,

governments, and institutions worldwide. It is My Scope of work Populating

the dimension table, fact tables and Transfer the Data from source to

staging and applying transformation then move to Data ware house.

Responsibilities:

. Worked closely with business unit(s) to understand key business

drivers and then identify the individual business metrics and key

measures that support them

. Designed and configured, including parameters, settings, metrics, data

elements and objectives

. Worked with management to develop strategies to support company needs

. Resolved data conflicts and inappropriate use of data

. Wrote complex SQL queries using joins, stored procedures, used defined

functions to verify the data from the database to generate reports

based on the business requirement.

. Wrote SQL Stored Procedure for checking Insert and Update on

particular tables and created Transactions and Error Handling in it.

. Utilized SSRS reports from different source formats and satisfying

clients by representing reports and presentations

. Generated matrix reports, tabular, drill-down, drill-through, sub

reports, chart reports, multi parameterized reports

. Created ad Hoc and parameterized various reports using SQL server 2008

reporting Services

. Implemented multiple grouping into several reports using visibility

and toggle options

. Administrated and scheduled mailing subscriptions on SSRS reporting

server

. Developed dependant, dynamic menu objects to allow end-users selection

and data filtering capabilities

. Structured conditional formatting logic to control components behavior

and appearance

. Produced parameter driven, matrix, sub-reports and integrated report

hyper-link functionality to access external applications.

. Customized SQL queries to create RDL Datasets and create SQL reports.

. Created Tabular and Matrix Reports with all aggregate functions and

expressions

. Produced dashboard SSRS reports under report server projects and

publishing SSRS reports to the reports server.

. Developed functional and technical documentation to assist in the

design, development and/or maintenance of deliverables

. Created SSRS Data Model projects using Microsoft Visual Studio 2008

and using Report Builder for report server to facilitate Ad-hoc

reporting by the business users

Tools &Technologies :

SQL Server 2008, SSRS, SSAS, T-SQL, SSMS, BIDS, Visio, Excel 2003,

SharePoint

BlackRock,NYC, NY

Feb 2010 to Dec 2010

SQL Programmer/SSIS ETL/Analyst/Reports

BlackRock is an investment manager which provides its services to

institutional, intermediary, and individual investors. It also manages

accounts for corporate, public, union and industry pension plans, insurance

companies, third-party mutual funds, endowments, foundations, charities,

corporations, official institutions, and banks. The main objective of the

project was to collect data from various database sources to perform

analysis and then integrate them with the existing systems.

Responsibilities:

. Based on business requirement, developed the Complex SQL queries with

Joins and T-SQL, Stored procedure, Views, Trigger to implementing the

business rules and transformations.

. Data Analysis and Designed the logical and physical model architecture

for database.

. Interacted directly with the various SME for gathering the business

requirements.

. Involved in Design DW of Star Schema (Dimensional model and Fact

tables) based on business.

. Convert data from Legacy system to SQL Database.

. Used ETL SSIS to develop jobs for extracting, cleaning, transforming

and loading data into data warehouse.

. Prepared the complete data mapping for all the migrated jobs using

SSIS

. Data Migration from Flat files, CSV, MS-Access, Excel and OLE DB to

SQL Database.

. Using SSIS, loaded XML data to the Database tables.

. Generated XML files from Database tables.

. Created /modified and maintained the ETL packages- Extraction,

Transformation and Loading of data from various Database tables ie,

from Source Tables to Mapping the Target table in respective

databases.

. Collected data from Various Heterogeneous database/files like MS SQL,

DB2, ORACLE, Flat File, Access, Sybase, EXCEL sheets, CSV format and

used complex data conversion to target.

. Scheduling and monitoring the regular jobs and ETL packages.

. Involved in Query optimization, performance tuning and index creation.

. Developed custom selection of reports ordering using SQL Server

Reporting Services (SSRS)

. Used SSRS to create reports, customized Reports, on-demand reports.

. Database Backup and restoring the database.

. Worked in Database Security, Replication, Log shipping activities.

. Validating and Testing of the Database data, SQL codes and application

(White box and Black box)

. Prepared Documentation of the system.

Tools &Technologies :

SQL Server 2008, SSIS, SSRS, MS-Access, DB2/UDB, ERwin7.1, VB Script,

Windows 2003 Server.

Johnson & Johnson

June 2007 to Jan 2010

MS SQL Server Developer/ SSRS Developer

The primary scope was to modify and create new reporting portfolio on

Reporting Service SSRS and to generate different sorts of reports including

static, ad-hoc, and drill-down and drill-through.

Responsibilities:

. Involved in Installing SQL Server 2005 with latest service pack.

. Extensively worked in creating Database, database objects such as

view, table, stored procedure, trigger and function using T-SQL.

. Performance tuning of stored procedure.

. Wrote complex Join queries using T-SQL.

. Produced the Logical and Physical Data Model using Erwin tool.

. Created SSIS Packages to integrate the Business Logic and Data

Transformations

. Transformed data using SSIS packages, BCP utility and Bulk Insert

statement.

. Created and saved SSIS package according to requirements.

. Performance tuning of server and gave suggestion to senior developer.

. Produced and managed index.

. Involved in Performance Tuning activities including Query Tuning and

Index Maintenance.

. Monitoring the application and database performance using SQL Profiler

and Performance Monitor

. Used Index tuning wizard to get a better idea of implementing indexes

on the existing databases

. Designed Database Maintenance Plans for Database Backups, Re-indexing

and Data Integrity Checks

. Created SQL Server Jobs and Schedules for automated and timely

execution of Daily, Weekly and Monthly processes.

. Wrote Windows Admin Scripts to monitor Disk and Tape Backups, Disk

Space and Service Status for different servers and generate alerts.

. Created SQL Server Agent Alerts to monitor the SQL Server Events and

SQL Server Performance Alerts and notify the Administrators of the

critical situations.

. Designed Triggers to monitor activities on server as well as database

and generate alerts and notifications.

. Wrote Stored Procedures, User-Defined Functions, Ad-hoc Scripts and

Cursors on Development and Test servers for pre-deployment testing.

Tools &Technologies :

MS SQL Server 2005, Enterprise Manager, Query Analyzer, and System

Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard

and Data Transformation Services, T-SQL, Third party Application, Windows

2003/2000 server.

Touch Controls,Vadodara,INDIA

July 2006 To May 2007

SQL Server Developer

Manufacture and exporter of copy product from card, universal single

indicator, scanner, average indicator, enunciator, deviation band

indicator, data logger etc. The goal of the project was to maintain

database, Handling Performance issues, Query Optimization, Locking Issue,

creating SSIS Package and Documentation.

Responsibilities:

. Extensively involved in installing and configuring SQL server 2005.

. Transformed data using SSIS packages, BCP utility and Bulk Insert

statement as and when necessary.

. Improved Performance of databases by analyzing Indexes, Fill Factor

and Fragmentation issues

. Monitored server critical issues including Response Delay,

Locking/Blocking and Server Downtime.

. Created Scripts to monitor Backups, Drive Space, Log Size, Database

Size and Service Status monitoring.

. Involved in Creation and Management of Jobs, Schedules and Sending

Alerts using SQL Mail

. Gained expertise in Security Issues by creating Users and granting

Permissions on various Objects

. Performed Data validations by creating triggers as well as Server

level and Database level monitoring and Alert the users with the field

status changes.

. Created database and database objects such as index, Table, stored

procedure, view, trigger and function using T-SQL.

. Monitoring server performance by using Performance counter.

. Created complex Stored Procedures and Cursors to support applications

using T-SQL.

. Prepared Estimates for Database Files and Table size growth. .

. Generated Reports for the day-to-day as well as weekly/monthly

purposes.

. Created Distributed Partition views Using T-SQL.

Tools &Technologies :

MS SQL server 2005, Windows 2003/2000, Enterprise manager, Query analyzer,

SSIS, SQL profiler

Contact this candidate