[pic]

Sachin

201-***-****

Professional Summary

. Over 8 years of IT experience in the Analysis, Design, Development and

Administering Client/server application using Microsoft SQL Server and

BI suite (Development, UAT and Production Environment).

. Expert Knowledge of Integration Services (SSIS), Analysis Services

(SSAS) and Reporting Services (SSRS).

. Experience in Database Development, Modeling, Data Warehousing, Design

and Technical Management.

. Very good experience in Creating, deploying SSIS Packages.

. Extensive experience with data modeling techniques, logical and

physical database design.

. Expert at Dimensional Modeling and ETL design.

. Worked Extensively on ETL process using SSIS package.

. Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE

Schemas.

. Created shared dimension tables, measures, hierarchies, levels,

cubes and aggregations on MS OLAP/ Analysis Server (SSAS).

. SQL Server 2005 OLAP database development including KPIs, Data mining,

working with all types of slowly changing dimensions.

. SQL Server 2005/2008 RDBMS database development including T-SQL

programming.

. Experience in using variables, expressions and functions and

Proficiency in creating different types of reports such as Cross-Tab,

Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports,

and formatting them.

. Experience with adhoc reporting, Parameterized, Custom Reporting using

SSRS for daily reports and SSAS projects.

. Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling SSIS

Packages and Backup/Restore of a database.

. Experience in writing complex SQL queries involving multiple table

inner and outer joins, stored procedures.

. Proven ability in Performance Tuning, Query Optimization.

. Experience in creating indexed views, complex stored procedures,

effective triggers, and useful functions to facilitate efficient data

manipulation and consistent data storage.

. Involved in DBA activities such as backups, restores and replication.

. Excellent analytical, problem solving skills and a motivated team

player with excellent inter-personal skills and familiar with offshore

and multi site development.

EDUCATION

Bachelors in Electronics & Communications, VTU, Belgaum, India

CERTIFICATIONS

. 70-448 Microsoft SQL Server 2008 Business Intelligence - Development

and Maintenance.

. Certified in SQL Server 2008

TECHNICAL Skills

Languages T-SQL, PL-SQL

RDBMS MS SQL SERVER 2008 / 2005 / 2000, Oracle 9i/10g

ETL Tools SSIS, SSAS, Oracle Warehouse Builder 10g

Operating Windows 2007/XP/VISTA, UNIX

Systems

SQL Server Tools Enterprise Manager, SQL Server Management Studio,

SSAS, SSIS,SSRS

Reporting Tools MS SQL Reporting services (SSRS), SAP Business Object

XI R2 and Crystal Reports

PROFESSIONAL EXPERIENCE

GENPACT- JAWOOD Healthcare Solutions, Detroit, MI

Sep'11-Present

Role: MS SQL Server Developer

Client: Blue Cross Blue Shield of Michigan

Blue Cross Blue Shield of Michigan provides and administers health benefits

to more than 4.3 million members residing in Michigan in addition to

members of Michigan-headquartered groups who reside outside the state.

Responsibilities

. Collecting requirements from business users and transforming them into

logical and physical database designs.

. Create and maintain clearly written technical, user, and system

documentation.

. Creating and managing schema objects such as tables, views, indexes,

stored procedures, and triggers & maintaining Referential Integrity.

. Created complex queries which involve usage of Joins, Sub-queries,

Functions, Temporary tables etc.

. Involved in Performance tuning and Query Optimization of Stored

Procedures and queries using execution plan and profiler.

. Created User defined scalar and table valued functions and complex

stored procedures to implement business logic

. Used Analytical functions like Row_number,Rank and Dense_rank functions.

. Used new functions like Last_Valve, First_Value and Concat in Sql Server

2012

. Implemented error handling techniques like Try and catch,@@ error in

Stored procedures

. Extensively involved in designing the SSIS packages to export data from

flat file source to SQL Server database.

. Scheduling & Maintaining SSIS packages in terms of data validation and

consistency.

. Experience in using T-SQL for creating stored procedures, indexes,

cursors and function.

. Working with complex SQL, Stored Procedures, Triggers, cursors, and

packages in very large databases from various servers.

. Import/Export using MS Access, Excel and Text file to/from SQL Server.

. Designed SSRS 2008R2 reports with Cascaded Parameters, Gauges and

Interactive Charts etc.

. Using SQL server reporting services (SSRS) delivering enterprise, Web-

enabled reporting to create reports that draw content from a variety of

data sources.

. Designing and implementing a variety of SSRS reports such as

Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer

and Report Builder based on the requirements.

. Creating reports for users in different departments in different states

using web-enabled reporting by SQL server reporting services and Share

Point.

. Wrote several SQL Scripts such as finding long running queries, blocking

sessions, archiving data from production to archive server and

populating reporting data.

. Design report models based on users requirements, explain and train

users to use report builder to generate their own personalized reports.

. Successfully deployed reports in various sources like XML, Web browser

and PDF.

. Responsible for creating Crystal reports based on client

specifications.

. Stored procedures were executed and the data extracted was displayed

using Crystal Reports.

Environment

MS SQL Server 2008 R2/2012, SSIS, SSRS, SSAS, T-SQL, Crystal Reports, MS

Office 2010

UPMC, Pittsburgh, PA

Mar'10- Aug'11

MS SQL Server Developer(SSRS/SSAS)

UPMC offers health insurance to companies and their employees, as well as

recipients of government programs such as Medicare and Medical Assistance;

integrated workers' compensation and disability services; and coverage for

behavioral health services to Medical Assistance beneficiaries in 35

Pennsylvania counties.

Responsibilities

. Involved in physical and logical data modeling using Erwin along with

the architects.

. Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema in

SSAS.

. Pulling data on a daily basis from OLTP database to OLAP or staging

database using the SSIS packages.

. Worked on SQL Server Integration Services (SSIS) to integrate and

analyze data from multiple heterogeneous information sources (Oracle &

Sybase).

. Created packages in SSIS with error handling.

. Extensively used SSIS Import/Export Wizard, for performing the ETL

operations.

. Worked with different methods of logging in SSIS.

. Experience in creating complex SSIS packages using proper control and

data flow elements.

. Responsible for ETL operation using SQL Server Integration Services

(SSIS) and Worked with users in training and support and also have

experience in incremental data loading.

. Designed and developed SQL SSIS Packages to extract data from various

data sources such as Access database, Excel spreadsheet, and flat

files into SQL server 2008 for further Data Analysis and Reporting by

using multiple transformations provided by SSIS such as Data

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

. Performed database transfers and queries tune-up, integrity

verification, data cleansing, analysis and interpretation. Developed,

monitored and deployed SSIS packages.

. Building UAT and Test environments using Production backups.

. Developed stored procedures and triggers to facilitate consistent data

entry into the database.

. Wrote store procedures to generate account statements for different

types of accounts

. Worked with T-SQL to create Tables, Views, and triggers and stored

Procedures.

. Used indexes to enhance the performance of individual queries and

enhance the stored Procedures.

Environment

SQL Server 2008, MS Excel 2010, MS SQL Server Reporting Services, MS SQL

Server Analysis Services, Erwin

Alticor Inc, Ada, Michigan

SQL Server/Report Developer

May'09 - Feb'10

Alticor provides product development, sourcing, manufacturing, printing,

business opportunity, packaging, distribution, and logistic services.

Amway, which accounts for most of Alticor's revenues, sells more than 450

different products through some 3 million independent distributors.

Responsibilities:

. Involved in dimensional modeling to design data warehouse.

. Worked in OLAP environment where star schema is implemented, creating

and identifying fact and dimension tables and establishing proper

relations between them.

. Created SSIS package to load data to SQL Server, from Flat files or

excel spreadsheet.

. Implemented Extraction, Transformation and Load (ETL), Import,

Export activities by SSIS package.

. Performing the tasks of data conversions, adding derived columns,

sending results in mails is done by making use of various tasks in

SSIS.

. Created Jobs for various packages that run at specific schedule

every day based on some dependencies.

. Created reports and performed all Administrative activities. Also

Installed and maintained SQL Server Reporting Services (SSRS) 2008.

. Extensively used SQL Server Reporting Services to generate various

types of reports.

. Created multiple reports with drop down menu option having complex

groupings within the report.

. Scheduled the reports to run on daily and weekly basis in Report

Manager.

. Developed Stepped and Block reports using SSRS.

. Formatted the reports using the Global variables and expressions.

. Developed custom reports using SQL Server Reporting Services (SSRS)

to review score cards, business trends based on the data from

different retail locations.

. Performed data analysis to generate various trend reports.

. Generated Ad-hoc, matrix, tabular, parameterized and cascading

parameterized reports using SQL Server reporting services based on

customer needs.

Environment

MS SQL Server 2005/2008, SSIS, SSRS, SSAS, T-SQL and Visual Studio (BI)

Tool

Verizon, Freehold, NJ

Sep'08-Apr'09

Role: SQL Server Developer

Verizon is a communication company offering a range of wireless and wire

line communication products and services for individuals, business and

government customers. The project is to extract data from the databases

and to develop various reports for the various department based on their

requirement.

Responsibilities

. Conducted Data Analysis and performed Data Modeling and Created the

ER diagrams using Logical Schema and Star Schema.

. Identified and tracked the slowly changing dimensions, heterogeneous

Sources (SQL Server, flat files, excel, access) and determined the

hierarchies in dimensions.

. Extract Transform Load (ETL) development using SQL Server 2005, SQL

2005 Integration Services (SSIS).

. Experience in creating complex SSIS packages using proper control

and data flow elements with error handling.

. Enhancing and deploying the SSIS Packages from development server to

production server.

. Performed Documentation for all kinds of reports and DTS and SSIS

packages.

. Used various ETL tools like SSIS/DTS for data flow from source files

like XML, Excel, Tables, and Views to other databases or files with

proper mapping.

. Involved in the analysis and profiling of source data, creating

prototypes and sample reports to help with requirements and design.

. Used SSIS to unite data from existing system and performed

transformations on MS SQL 2005.

. Used DDL and DML for writing triggers, stored procedures to check

the data entry and payment verification.

. Used Lookup Transformation to get the data from reference data sets.

. Generated ad-hoc reports using MS-Excel and Crystal Reports.

. Created SQL Server Reports using SSRS 2005.Identified the data

source and defined them to build the data source views.

. Created reports in SSRS with different type of properties like chart

controls, filters, Interactive Sorting, SQL parameters etc.

Environment

SQL Server 2008, MS SQL, MS SQL Server Integration Services (SSIS), MS SQL

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

Axis Bank, Bangalore, India

May'06 -Aug'08

Role: SQL Server/ SSIS Developer

Axis bank is awarded one of the best banks in India which actively

involves in non-profit activity called community services banking. The

project was to maintain database for personal, Corporate, NRI and

International banking. The database system allows customers allover nation

to access Internet banking, mobile banking, and ATM services.

Responsibilities

. Involved in the complete data warehouse development life cycle.

. Actively supported business users for change requests.

. Designed dynamic SSIS Packages to transfer data crossing different

platforms, validate data during transferring, and archived data files

for different DBMS.

. Used proper error handling techniques like logging, checkpoints, and

event handler etc. to handle errors in the packages.

. Created Table, Stored procedures and defined functions. Created SQL

scripts for tuning and scheduling.

. Performed data conversions from Flat files into a normalized database

structure.

. Developed, modified, and optimized complex stored procedures, triggers

to handle complex business rules, history data and audit analysis

. Responsible for creating constraints, Indexes, and Views.

. Optimized the performance of queries with modification in T-SQL

queries, normalized tables, established joins and created indexes

wherever necessary.

. Rebuilding the indexes at regular intervals for better performance

. Created triggers, views, user defined functions to incorporate the

flow of business and called various stored procedures from DTS to make

the flow of DTS effective.

. Performance tuning of SQL queries and stored procedures using Index

Tuning Wizard.

. Configured Server for sending automatic mails to the respective people

when a DTS process fails or succeeds.

. Created Crystal Reports on daily, weekly and monthly basis for

manger's review.

Environment

SQL Server 2005/2000, T-SQL, MS Excel, MS Access, Crystal Reports, SSRS

and SSIS

TATA Consultancy Services, Bangalore, India

June'05- April'06

Client: TATA Sky Limited

ETL / Report Developer

ORS (Operational Reporting System) is a centralized reporting system which

has been built to cater to the operational reporting needs of Customer

Operations, MIS, Marketing, Finance, Sales and Field Services departments

of TATA SKY. The ORS database consists of the transactional data from all

source systems in scope. Lowest level granularity data in ORS will be used

for generating ad-hoc queries and operational reports.

Responsibilities

. Involved in different phases of Software Development Life Cycle (SDLC)

like requirements gathering, preparation of technical specification

documents designing and developing reports, unit testing and UAT.

. Interacted with the Business Users to analyze the business process and

gathered the requirements.

. Involved in implementation of ETL process which includes Data

Modeling, Data Extraction, Data Loading (Full /Delta Up-Load),

Scheduling, Monitoring, and Process Flows.

. Extensively worked in developing transformations and mappings using

OWB.

. Designed and scheduled process flows with multiple parallel paths by

understanding the criticality and dependency of all transformations.

. Responsible for developing Analytical Reports with multiple parameter

fields, multiple expressions and multiple grouping for hierarchy

levels and published them using the Business Objects Enterprise XI R2.

. Defined BO Classes, Objects, in the Universe, defined Cardinalities,

Contexts, Joins and Aliases and resolved loops in Universes using

Table aliases and contexts.

. Checked the Universes for Integrity and exported to the Repository to

make resources available to the users and groups and Created Adhoc

reports by accessing the Universe.

. Designing, developing and deploying using Universe Designer, Web

Intelligence, Info View and CMC.

. Created (Master/Detail, Cross tab, Chart templates) reports using

Crystal Reports.

. Worked on Hierarchy Levels and Developed hierarchies to support drill

down reports.

. Also involved in the production support, fixing bugs and daily ETL

Data load Monitoring of the ETL jobs.

. Experience in Performance Tuning - Improved data load and query

performance by doing indexing, converting full load transformation

into delta load.

. Extensive experience in creating reports with Charts (bar chart, Pie

chart), Cross-tabs and Sub reports.

. Resolved performance issues by writing stored procedures in PL/SQL.

Environment

Oracle 9i/10g, SAP Business Objects XIR2, Oracle Warehouse Builder 10g,

Crystal Reports, Toad, SQL, PL/SQL

Contact this candidate