SUMMARY

. Around *+yrs of experience with database management, SQL development,

Software implementation.

. Around 3 years of experience in Health care industry.

. Good knowledge of RDBMS and experience with MS SQL Server 2012/2008/2005

. Good Experience working with BI tools SSRS, SSIS, SSAS.

. Worked with SSRS/Crystal Report/Tableau for creating complicated reports

including sub-reports, parameter based reports, graphical reports,

formula based, drill down reports, analysis reports.

. Created effective ETL strategies to Extract, Clean and Deliver Data to it

destinations.

. Good exposure to Informatica Power Center.

. Developed stored procedure, views, triggers and adding/changing tables

for data load and transformation, and data extraction and also to fetch

the data for the reports from different database.

. Good experience in Dimensional modeling using Star Schema/Snowflake

modeling concepts and Kimball strategies.

SKILLS

Programming Languages: T-SQL, PL/SQL, Basic programming in C#, C, C++

Database tools: SQL Server 2012/2008/2005/, Oracle 10g/11g, DB2, MS-

Access,

Internet Technology: Basic knowledge of ASP.Net, VB.Net, XML, HTML

Applications and Tools: SQL Server Management Studio, SQL Server

Integration(SSIS) Services,Qlikview Tableau, Informatica Power Center,SQL

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

Reports, Visual Studio 2005/2008, Visual studio Teamsystem,

Visio2007,SharePoint Server(MOSS 2007), MS Office.

WORK EXPERIENCE

SQL /Report Developer

Oct

2010 - Present

Netsmart Technology - Illinois

Netsmart/Sequest Technologies is a leading provider of Electronic Medical

Record (EMR) software solutions for behavioral health, correctional

healthcare, substance abuse and mental health treatment.

Responsibilities:

. Developed complex billing and clinical reports using SSRS 2012/2008

and Crystal Report

. Developed, published and automated reports using SSRS 2012/2008

. Designed and implemented Parameterized and cascading parameterized

reports using SSRS

. Create reports using SSRS and SSAS cube as data source.

. Developed highly interactive best in class Executive Dashboard

consisting of Drill down dynamic charts, business scorecards,, KPI

Grids with advanced drill down capability giving executives ability to

analyze sales, revenue and slice it by any region/store, time period

etc.

. Trained Business analysts and power users to create ad-hoc reports on

their own using Report Builder 3.0.

. Worked on various data migration projects to migrate the client legacy

data to new system using SSIS packages and stored procedures.

. Implemented Type I, II changes in slowly changing dimensions using

SSIS.

. Designing and building data load procedures, using MS SQL Server.

. Create visually compelling and actionable interactive reports and

dashboards using Tableau.

. Used Tableau Desktop to analyze and obtain insights into large data

sets.

. Created complex TSQL queries, stored procedures, Functions and views

used for reports and maintaining reporting database.

. Worked on writing the TDD after gathering the requirements from the

client.

. Worked on maintaining the good documentation so that can be used for

future reference

. Scheduled Jobs Using SQL Server Agent.

. Provided 24 by 7 Production Support for both local and global

facilities.

Recycler.com Los Angeles (SSRS Report /SQL Developer)

Jun 2010 -Aug 2010

Responsibilities:

. Installed and configured SSRS 2008 and report builder 2.0

. Designed and implemented the security model for the SSRS and Report

builder users

. Developed Complex SSRS involving Sub Reports (Matrix/Tabular Reports,

Charts and Graphs).

. Design, deployment, and maintenance of various SSRS in SQL Server

2008

. Designed and implemented Parameterized and cascading parameterized

reports using SSRS

. Created stored procedures, views, functions that are used by Reports

to fetch the data from database

. Created the Report Model according to business requirement that can be

used for Ad Hoc Reporting by the business users.

. Build asp.net web application using C# which show the dealers Ads

Upgrades to the user,

Dealer Ads Details, Revenue generated by the Customers, Network Lead for

the Dealer.

Farm Credit Bank of Texas (SSRS Report/SQL Developer)

May 2009 - May 2010

Responsibilities:

. Developed Complex SSRS/CRYSTAL REPORTS involving Sub Reports

(Matrix/Tabular Reports, Charts and Graphs).

. Design, deployment, and maintenance of various SSRS/CRYSTAL REPORTS

in SQL Server 2005/2008

. Designed and implemented Parameterized and cascading parameterized

reports using SSRS/CRYSTAL REPORTS.

. Added the different types of the charts according to business

requirement to enhance the functionality of reports using Crystal

Reports/SSRS

. Created scheduled ssis packages to load data from association to the

database

. Migrated DTS 2000 packages to SQL Server Integration Services (SSIS)

and modified the packages accordingly using the advanced features of

SQL Server Integration Service.

. Designed ETL packages dealing with different data sources (SQL Server,

Flat Files, and XMLs etc) and loaded the data into target data sources

by performing different kinds of transformations using SQL Server

Integration Services (SSIS)

. Develop Multidimensional cubes and perspectives according to business

requirement using SSAS

. Built MDX queries for Analysis Services & Reporting Services to set

the goals, status and trend of the project.

. Used Team Foundation Server in Visual Studio in order to track and

edit bugs been tracked.

. Developing stored procedures, triggers, views, and adding/changing

tables for data load and transformation, and data extraction.

Life Insurance Corporation (LIC), India (Software Developer)

Jan 2006 - April2007

Responsibilities:

. Involved in creating and managing schema objects such as tables,

views, indexes, procedures, triggers and maintaining Referential

Integrity.

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

database tables.

. Generated T-SQL scripts for application development.

. Developed SQL script to immigrate data from Excel sheet to sql server

7

EDUCATION

Illinois Institute of Technology, Chicago, IL

August 2007 - December2009

MS in Electrical and Computer Engineering

Dehradun Institute of Technology, Dehradun, India

August 2002 - July 2006

Bachelor of Technology in Electronics & Communication Engineering

Contact this candidate