SANDEEP V

BI Consultant

916-***-****

ace6or@r.postjobfree.com

professional SUMMARY

. Over 5 years of experience in Database Administration and Microsoft

business intelligence Development under SQL Server environment, with

thorough knowledge of SQL Server 2008/2008R2/2012 databases.

Experienced in Insurance, Financial, Health Care and banking services.

. Experienced in upgrading SQL Server 2005/2008 to 2008/2012 and data

migration among versions.

. Extensive experience in developing and implementing Microsoft SQL

Server Integration Services (SSIS), Reporting Services (SSRS), SSAS

(analysis services).

. Excellent knowledge in RDBMS concepts and constructs along with

Database Objects creation such as Tables, User Defined Data Types,

Indexes, Stored Procedures, Views, User Defined Functions, Cursors and

Triggers.

. Expert in Extraction, Transforming and Loading (ETL) data flows using

SSIS; creating mappings/workflows to extract data from SQL Server and

Flat File sources and load into various Business Entities.

. Experience in DTS Migration and Metadata Management: Migrating DTS

packages to SSIS, Package Migration Wizard, and Storage Management.

. Experienced in the complete life cycle of DTS/SQL Server Integration

services (SSIS) Packages (Developing, Deploying, Scheduling,

Troubleshooting and monitoring) for performing Data transfers and ETL

jobs across different servers.

. Experience in Error and Event Handling: Precedence Constraints, Break

Points, Check Points, Logging.

. Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-

related sub queries, Dynamic SQL queries etc.

. Experience in Performance Tuning in SSIS packages by using Row

Transformations, Block and Unblock Transformations

. Experience managing and performance tuning both relational and star

(dimensional) schema databases

. Experience in developing reports using Report Builder and used

Metadata to define Fact & Dimension tables. Expert in designing

Enterprise reports using SQL Server Reporting Services (SSRS)

generated drill down reports, drill through reports, parameterized

reports, Cascaded reports, linked reports, sub reports, matrix

dynamics and filters, charts in SSRS.

. Expertise in .NET framework with great proficiency in creating

applications using Win Forms, Web Forms, Entity Framework, ASP.NET,

C#/VB.NET, ASP.NET MVC, ADO.NET, XML, AJAX toolkit, Cascading Style

Sheets (CSS), JavaScript, WCF, WPF, IIS7.0, SQL Server 2000 / 2005

/2008, LINQ and Visual Studio.NET.

. Perform complex data modeling, performance and integration testing and

builds interfaces for a variety of internal and external constituents.

. Monitor and employ source code control techniques and configuration

management.

Gather, analyze, prepare and summarize recommendations for approval

of system and programming documentation.

. Implemented changes in development, maintenance and system standards.

. Perform and coordinate data warehouse administration for development

and maintenance activities, including performance testing, tuning, and

troubleshooting of data warehouse processes

. Develop and implement new or enhanced utility components for the data

warehouse

Partner with technical team members to establish extract,

transformation, and data load designs and standards for a well managed

and well integrated data warehouse infrastructure

Interact with business users and Citizens Data Warehouse staff to

understand reporting requirements

. Design and implement Demoralized, Dimensional, and Star Data Warehouse

schemas

. Working experience of designing Ad-hoc reports for higher managers

using report model, providing them flexibility to create reports using

drag and drop functionality.

. Developed Cubes using SQL server Analysis Services (SSAS) and

Experience in Developing and Extending OLAP Cubes, Dimensions and data

source views.

. Created Dimensions with the cube wizard and generated named

calculations and named queries.

. Expert in calculating measures and dimension members using Multi-

dimensional expression (MDX), mathematical formulas, and user-defined

functions.

. Microsoft Certified Technology Specialist in SQL Server 2005 and SQL

Server 2008.

. Excellent communication and interpersonal skills. Highly motivated

with strong commitment to quality and customer service.

TECHNICAL SKILLS:

Operating System: Window 2000, Windows XP, Windows 2003, UNIX

Languages: C, C++, Java, VB6, VB.NET, C#, ASP.NET

Databases: MS-SQL Server 2000, MS SQL Server2005, MS SQL Server 2008, MS

SQL Server 2012

Data Warehouse Tools: SSIS, SSRS, SSAS

SQL Server Tools: Enterprise Manager, Microsoft Systems Center Operations

Manager,

SQL Server Management Studio, Profiler,

Query Analyzer, MS Visio

Web Technologies: HTML, DHTML, VB Script, Java Script, PERL and ASP

Professional Experience

NTT Data Inc

July 12

to Aug 13

Project: 1

BI Consultant

Client: National Life Group

Description: The current scripting process for LSW Annuities is handled by

Excel, and VBA coding. The solution proposed is to automate the scripting

process for PolySystems executions using new technology which can be easily

maintained, and managed within a controlled IT environment.

Responsibilities:

. Installation and Upgradation of SQL Server 2008 and SQL Server 2012 on

Production Environments.

. Involved in migrating data from SQL Server 2008/2008R2 to SQL Server

2012.

. Develop and implement production database backup strategies for MS-SQL

Server databases which enable maximum recoverability.

. Migrated data from different sources (text based files, Excel

spreadsheets, and Access) to SQL Server databases using SQL Server

Integration Services (SSIS).

. Involved in dimensional modeling with Star & Snowflake schemas and

created the Data Source Views (DSV) and Cubes using the identified

Fact and dimension tables.

. Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, SQL

Server 2008

. Created stored procedures, views, indexes and joins as needed.

Involved in Performance Tuning of databases to optimize existing

applications and processes.

. Worked with different Types of files like UPD, PCF, VMF, and RCF.

. Extensively utilized SSIS packages to create complete ETL process and

load data into database which was to be used by Reporting Services.

Creating jobs for scheduling the SSIS packages.

. Performed operations like sorting, merging on the source data in order

to clean the data and remove duplicates.

. Designed databases, tables, SQL functions, triggers in SQL Server

2008.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS,

ReportBuilder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler,

Replication, Logshipping, Mirroring, Windows XP/2000 and Windows 2003/2008

Server.

Project 2:

M*Modal, Atlanta GA

Feb 12 to June 13

BI Consultant

Description: M*Modal is a leading provider of clinical transcription

services, clinical documentation workflow solutions, advanced cloud-based

Speech Understanding technology and advanced unstructured data analytics.

We come to the challenges confronting healthcare today with a clear

understanding that at the core of quality care giving is the physician's

narrative-the telling and capturing of the complete patient story.

Everything is rooted here-from boosting quality at the point of care to how

healthcare organizations receive reimbursements

Responsibilities:

. TSQL Programming - writing new stored procedures, updating & enhancing

the existing code.

. Optimizing the queries and taking care of performance issues.

. Implementing Backup and recovery process and Replication process.

. Deploying the code, SSIS packages and SSRS reports in production

servers.

. Installing and configuring the SQL Server 2008 and SQL Server 2012 on

windows 7 servers.

. Creating New SSIS packages and Migrating SSIS packages from SQL Server

2008 to SQL Server 2012.

. Designing and modeling data warehouse and data marts, creating

database objects and applying optimization techniques.

. Exclusively worked on Script task (C#.NET, VB Scripting), File System

Task to read the excel files and updating the excel files in ETL

package.

. Effectively using various synchronous and asynchronous transformations

in ETL packages.

. Integrated third party components ACG Grouper and Milliman Grouper in

SSIS packages.

. Created various Medicaid and Medicare Claims data extract and loading

SSIS ETL packages.

. Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, SQL

Server 2008

. Created Stored Procedures/Functions/Triggers in SQL Server using T-

SQL.

. Automating various ETL jobs and sending notifications to the users.

. Created SSRS reports and taking care of deployment issues.

. Designing and deploying Adhoc reports for Business Process Management

by using Operational Data Source.

. Taken care of code and SSIS deployment and migration issues.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Report

Builder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler,

Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008

Server

Polaris Software Lab Oct 10 to

Feb 12

BI Consultant

Client: Citi Bank

Description: AIMS is a standalone e-billing and legal spend management

application that facilitates the approval and payment of invoices between

the corporate legal department and its legal service providers. AIMS

provide the ability to automatically enforce billing guidelines and reduce

invoice review time, thus driving cost savings and efficiency throughout

the legal department. And, with the comprehensive analysis and reporting

capabilities provided by AIMS, legal spend data becomes actionable

information that helps corporate counsel make well-informed, strategic

business decisions.

Responsibilities:

. Optimizing the queries and taking care of performance issues.

. Implementing Backup and recovery process and Replication process.

. Deploying the code, SSIS packages sin production servers.

. Installing and configuring the SQL Server 2008 and SQL Server 2012 on

windows 7 servers.

. Creating New SSIS packages and Migrating SSIS packages from SQL Server

2008 to SQL Server 2012.

. Designing and modeling data warehouse and data marts, creating

database objects and applying optimization techniques.

. Exclusively worked on Script task (C#.NET, VB Scripting), File System

Task to read the excel files and updating the excel files in ETL

package.

. Effectively using various synchronous and asynchronous transformations

in ETL packages.

. Integrated third party components ACG Grouper and Milliman Grouper in

SSIS packages.

. TSQL Programming - writing new stored procedures, updating & enhancing

the existing code. Created Stored Procedures/Functions/Triggers in SQL

Server using T-SQL.

. Automating various ETL jobs and sending notifications to the users.

Taken care of code and SSIS deployment and migration issues.

. Created SSRS reports and taking care of deployment issues. Designing

and deploying Adhoc reports for Business Process Management by using

Operational Data Source.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Report

Builder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler,

Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008

Server

Kansolves Technology, India

May 08 to July 10

BI consultant

Description: CIBER Data Warehouse acquires data from the various data

sources of the company and insert or update data into Data warehouse. This

data warehouse allows the Management for effective decision-making and to

transform product centric approach to customer centric approach to gain

competitive advantage by combining data from different sources. The company

has heterogeneous data stores and operational systems supporting its

operational infrastructure

Responsibilities:

. Query Optimization and tuning the query, creating Indexes to improve

the query performance.

. Bulk Insert and loading the data files which comes from various legacy

systems (Mainframes and Oracle database).

. Creating various Jobs, scheduling & running jobs and troubleshooting

the failed jobs.

. Expertise in Monitoring and Troubleshooting and resolving the SQL

Server Performance issues.

. Designing, developing and deploying various ETL packages for data

loading (SSIS).

. Creation and Execution of DTS and BCP utilities in SQL Server 2000.

. Effectively using DBCC commands, SQL Profiler, Trace Analysis and

Execution plans as part of trouble shooting and performance tuning.

. Creation and implementation of Database backup Restore and Recovery

plans.

. Replicating the database (Snapshot, Transactional and Merge

Replication) and providing greater autonomy to the users.

. Working on Log shipping, Mirroring and SQL Server Clustering

Databases.

. Developing, implementing, maintaining and exercising Disaster Recovery

processes.

. Building Data warehouse database, Designing Star Schema, Creating Fact

tables, Dimension tables and defining the relationship between them.

. Expertise in processing the Cubes, Hierarchies, and Measures putting

calculations and processing for Analysis Services (SSAS).

. Expertise in populating processed Analysis Cubes historical data into

excel file, ProClarity, various pie charts.

. Trouble shooting and fixing the issues in front end code (VB.NET,

ASP.NET, C#) when project needs.

Environment: Windows 2003, SQL Server 2008, Microsoft Visual Studio 2008,

SSIS, SSRS, Windows

XP, Windows 2003, Windows 2000

Education:

. Master of Science at University of Central Missouri, 2014

. Post Graduation diploma In Software Development, 2011

. Bachelor of Technology in Electronics, 2008

Contact this candidate