Sql Server Manager

Prasad

Software Engineer

___________________________________________________________

Phone: +91-903*******

E-mail: ********.****@*****.***

___________________________________________________________

Summary of Experience:

Having 3.2 years of experience in Business Intelligence and Customization of various Reporting tools.

2.8 Years of relevant Experience in SQL Server 2008 Integration Services, Reporting Services in development and implementation stages of the Project.

Skilled at Development of Mappings according to the ETL Specifications for the Staging Area Data Load.

Proven proficiency at Data Transformations like Derive Column, Conditional Split, Aggregate, and Sort & Execute SQL Task to load data into Data Warehouse.

Good Technical Knowledge on Microsoft Business Intelligence Tools like SQL Server 2008 Integration Services, SQL Server 2008 Analysis Services and SQL Server 2008 Reporting Service.

Extensive knowledge on SQL Server 2008.

Knowledge on Data warehousing concepts.

Involved in SSAS MDX Query writing and preparing reports

Software Exposure:

Operating Systems : Windows XP

Databases : SQL Server 2008

ETL Tools : SQL Server Integration Services

OLAP Tools : SQL Server Analysis Services

Reporting Tools : SQL Server Reporting Services

Education:

Bachelor of Technology from S.V University, Tirupati in 2008.

Work Experience

Currently working for SONATA SOFTWARES, Bangalore as a Software Engineer from Aug 2011 –Till Date.

Worked for VERIZON, Hyderabad as a software Engineer from Nov 2008 to July 2011

Professional Experience

Project #1:

Project : Retail Management System

Client : AHOLD

Environment : SSIS, SSRS, SQL Server 2008

Duration : Aug 2011 to till date

Ahold is an international group of quality supermarkets based in the United States and Europe. It also involves customizations of some existing reports, forms and development of some new reports to suit their business. They have a number one or number two position in the Netherlands and the Czech Republic, as well as in the ICA, Giant-Carlisle, Stop & Shop and Giant-Landover market areas. All of these businesses have significant potential for profitable growth.

Roles and Responsibilities:

• Involved in creating reports for Business Analysis Process.

• Extensively used Derive Column, Row Count, Data Conversion, Conditional Split and Aggregate.

• As per requirements developed the reports in the form of Matrix, Table and Chart Using SQL Server 2008 Reporting Services.

• Involved in the ETL phase of the project.

• Creating packages at SQL Server Integration Service platform.

• Involved in Package Deployment and Package Scheduling.

• Building and generating reports with the help of Report Builder in the Report manager.

• Generated the Reports Weekly and Monthly basis as per the Client Requirements.

• As per the client requirements, rendering the Reports in the form PDF, Excel and CSV formats.

Environment:

SQL Server Integration Services and SQL Server Reporting Services and SQL Server 2008.

Project #2:

Project : CIS [Customer Integration Service]

Client : USA

Environment : SSIS, SSRS, SQL Server 2008

Duration : Jun 2010 to July 2011

Customer Banking Systems contains Four major modules are counter module, Officer Module, Bank manager module; Reports module .Counter module includes all data entry forms for counter level transactions. The drop down menu appears ordering numbers of selections. This module handles the day-to-day financial transactions such as Voucher Generation, Account Details, and Ledger, Loan track& Loan extension, Interest Calculation. Officer module contains officer level transactions, like officer usually can only pass the Voucher or reject it. Bank manager module provides us all Master transactions as officer level and counter level Report module can generate various types of reports such as Daily Report of A/C closed and opened Transfer and statement of GL heads

Roles and Responsibilities:

• Involved in the ETL phase of the project.

• As per requirements developed the reports in the form of Matrix, Table Using SQL Server 2008 Reporting Services.

• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Execute SQL Task, Email Task and Data Flow Task

• Building and generating reports with the help of Report Builder in the Report manager.

• Creating packages at SQL Server Integration Service platform.

• Development of mappings according to the ETL specifications for the warehouse data load using SQL Server Integration Services & SQL Server 2008.

• Generated the Reports Weekly and Monthly basis as per the Client Requirements.

Environment:

• SQL Server Integration Services and SQL Server Reporting Services and SQL Server 2008.

Project #3:

Project : Advertise Management System

Client : After Work Deals LTD

Environment : SSIS, SSRS, SQL Server 2008

Duration : Mar 2009 to Apr 2010

This document sets out high-level specifications for an internet-based advertising system which employs premium SMS to deliver unique content (vouchers) to customers.

Our website will display text-based ads, each of which carries a unique identifier code (keyword). Customers can text this code to an SMS short code and receive a unique voucher (text-based) by mobile-terminated premium SMS reply. Generally for each advert on the site, there will be only a limited number of vouchers available each day.

Advertisers will be able to choose which day their advert is displayed, and SMS vouchers will only be available on the same day that the advert is displayed on the website. Accordingly, a keyword management system will be required to respond to each advert code sent in and issue one of a limited number of unique vouchers back to the sender. The system will need to generate a keyword for each advert, and only respond to that keyword on a pre-defined day or days set by the advertiser.

Roles and Responsibilities

• As per requirements developed the reports in the form of Matrix, Table Using SQL Server 2008 Reporting Services.

• Creating packages at Sql Server Integration Service platform by using Tasks, Containers, and Transformations.

• Extensively worked in data Extraction, Transformation and Loading from Source to Target System.

• Creating Drill down Reports, Sub reports, Drill through Reports.

• Involved in Package Deployment and Package Scheduling.

Environment:

• SQL Server Integration Services and SQL Server Reporting Services and SQL Server 2008.

Personal Details:

Mobile No: +91-903*******

Email Id: ********.****@*****.***

Material Status: Un-Married

Date Of Birth: 01-06-1987

Contact this candidate