Hno:-2-147/2,Uppal,

DD.. VVII NNAAYY RREE DDDDYY

Hanuma Sai Colony, Email-id : dvrvinnu re d d y 98@ g mail.com Hyderabad. Mobile : 8519 999 598

Data Base Developer ( MSBI)

Having 2 years of Professional experience in IT industry, involved in Data Base(SQL SERVER 2008& MSBI )projects with extensive usage of ETL & Reporting tools like SQL Server IntegrationServices (SSIS) and SQL Server Reporting Service (SSRS).

Skills

MS-SQL server 2008 (STORED PROCEDURES, FUNCTIONS, VIEWS, SUBQURIES, CURSORS AND TRIGGERS) & SQL Server2008R2.

SQL, T-SQL & MSBI (SSRS, SSIS). ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server Reporting

Service (SSRS).

Technology

Software : BIDS(Business Intelligence Development Studio) & SSMS (Sql Server Management Studio). ETL Tool : SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services, SQL server).

Education

SSC (Holy Trinity High School)[Secondary School

Intermediate (Nalanda Residential College) [Board of Intermediate]

B.Tech in Computer Science from CVSR College of Engineering, JNTU (HYD) 2010.

Professional Experience

Wo r k Ex p er ienc e :- Worked as SQL SERVER2008 & MSBI Developer with Cat Technologies, Hyderabad from Jan

2011 – Feb 2013.

P r o ject 1

Project Duration : Nov 2011 to April 2012 Client : Dixon Retail Inc. U K Project Title : Sales Information System Role : BI Developer Environment : SQL Server Integration Services, SQL Server Reporting Services,

SQL server

D e s cr i p tio n : -

Dixon is a company in retail business of consumer electronic goods spread over United Kingdom (U.K).The Data warehouse has many applications and it has a high volume of transactions and data. Data warehouse has many functional and technical groups and ETL is one among them performing the development activities for Data warehouse.SIS is a database, which has lots of historical data. So Data Mart plays a major role in enabling various stores to view the data at a lowest level and help them to make decision to bring more revenue. Data was Extracted, Validated and Loaded into the Warehouse Database using SSIS Tool.

Contribu tion: -

Collected all the required specifications of input data. Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly to dump the

data in to SQL Database. Implementing Transformations in dataflow to clean data. Creating SSRS reports like tabular, matrix for the end user. Developed various packages to extract the data from different source like relational tables and flat

files. Used different destinations like OLE DB Destination, Flat file, Excel destinations and different

sources like Flat file and OLE DB Source, CSV files. Creation of work flows with Data flow, Execute Sql task, and Execute package tasks And

Containers. Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, Lookup, Sort, and Data Conversion.

P r o ject 1

Client : Tetra Group Ltd. Life Insurance USA Project Title : Sales Analysis System (SAS) Role : SQL Developer Environment : SQL server, SQL Server Reporting Services,

D e s cr i p tion : -

Tetra Group Ltd. Life Insurance is one of the leading super markets in North America. The project includes zonal wise analysis of sales, margins and annual growth is to be compared in a period of time. Data is extracted from different OLTP source systems, cleansed, transformed and loaded into warehouse.

We receive all modules data in the form of XML, Excel and flat files which need to be loaded into the Database schemas. The schemas are designed for the modules. All modules are logically related. For loading data into DB we are designing SSIS Packages and for data representation we are developing Reports by using SSRS.

Contribu tion: -

Involved in Creating Database Objects like Tables, Stored Procedures, Views, Triggers, and user defined functions for this project.

Gathered Requirements from the end user and involved in developing logical model and implementing requirements in SQL Server 2005

Responsible for creating reports based on the requirements using Reporting Services 2005. Identified the database tables for defining the queries for the reports. Identified and defined the Datasets for report generation. Wrote queries for drill down reports to get the dataset required to build the report. Deployed generated reports onto the Report Server to access it through browser. Development and Enhancements of Stored Procedures. Involved in Bug fixing in Stored Procedures.

DECLARATION

I declare that the information and facts stated above are true and correct to the best of my knowledge and belief.

Da t e :P la c e : Hyderabad. D.VINAY REDDY.