Sql Server Project

Bhaskar Reddy M

Phone: +91-890******* Email: *****************@*****.***

OBJECTIVE

Young, energetic and result oriented B.E professional offering 3.0+ Years

of experience, currently associated with Capgemini India, Bangalore as

Developer. Extended expertise in SQL Server 2008/2008R2, SQL Server

Integration Services, SQL server Analysis Services and SQL server Reporting

Services. Deep understanding of technology with focus on delivering

business solutions; Persuasive communicator with exceptional relationship

management skills with ability to relate to people at any level of business

and management; highly ethical, trustworthy and discreet.

> Dedicated and highly ambitious to achieve personal as well as

organizational goals

> Adroit at learning new concepts quickly, working well under pressure

and communicating ideas clearly and effectively

> Proficient in self adaptation within a dynamic environment

Summery

> 3.5 Years of experience in SSIS, TSQL and DWH

> Extensive experience in developing SSIS packages, Stored procedures,

Functions, Joins, Debugging the errors.

> Basic Knowledge in SSAS and SSRS.

> Strong knowledge in understanding of business Processes with good

experience in developing.

> Good knowledge in debugging and enrooting the packages to work

properly.

> Experience of client interaction and to deal with their requirements.

> Good in communication skills.

> Good in test case writing and executing in HP Quality Control

> Quick learner & self-directed to adopt new technologies.

> Good in coordination.

> Good in MS word and MS Excel.

> Having 3 years of domain knowledge in Retail.

Education Profile

> B.E from Sathyabama University with 84%

> +2/Inter from S.K.C with 93%

> 10th from H.H.S with 78 %

Competencies:

> Microsoft SQL Server 2008 Database programming

> Microsoft SQL Server Integration Services

> Performance / Troubleshooting SQL Server Objects & SSIS

> Data Warehousing

> Knowledge about Data Modeling with Ervin tool.

> Test cases writing according to the Business Requirement and executing

in HP Quality Control

> Strong in understanding the Business Requirements.

> Having thorough domain knowledge on US and Indian Retail Industry

Professional EXPERIENCE

Capgemini India Pvt Ltd., Consultant Bangalore (June 4th

2011 - Present)

PROJECT#1

Project Name: Iberia Kantar

Client Name: Coca-Cola

Project Duration: From September 2011 To August 2012

Role: Developer

Roles Performed:

> Designed dynamic SSIS Packages to transfer data crossing

different platforms, validate data during transferring, and

archived older data files.

> Designed SSIS Packages to extract, transfer, load (ETL)

existing data into SQL Server.

> Involved in the complete data warehouse development life

cycle. Actively supported business users for change

requests.

> Used SSIS to unite data from existing system and performed

transformations on MS SQL 2008.

> Extract Transform Load(ETL) development Using SQL server

2008,SQL 2008 Integration Services(SSIS)

> Designed and created the table schema and stored

procedures that will be used in Data QC.

> Used Joins and sub-queries for complex queries involving

multiple tables from different databases.

> Handling Errors and Debugging the ETL packages.

> Daily support of system wide replication tasks including

monitoring, alerting, and problem resolution.

> Responsible for documentation of system related activities.

> Provides technical documentation of the system

> Actively participated in interacted with users, team lead,

DBAs and technical manager to fully understand the

requirements of the system.

Environment: MS SQL Server2005/ 2008, SQL Server Integration Services

(SSIS),MS Visual Studio.NET# 2008, Visual Basic6.0/VB.net, VB Script and

Windows 2008 Server.

PROJECT#2

Project Name: Europe Household Panel

Client Name: Coca-Cola

Project Duration: From September 2012 To February 2013

Role: Developer

Roles Performed:

> Responsible for creating Deployment Support document for

the SSIS

> Performed Documentation for all kinds of SSIS packages.

> Created Packages in SSIS with error handling.

> Used various ETL tools like SSIS for data flow from source

files like Excel, Tables and views to other databases or

files with proper mapping.

> Extensively used T-SQL in constructing User defined

Functions, Views, Indexes, Relational Database Models, Data

Dictionaries, and Data Integrity.

> Created complex Stored Procedures, Cursors, Tables and

other SQL Joins and Statements for Applications by using T-

SQL.

> Created complex SSIS packages using proper Control and Data

flow elements.

> Used System Tables, System Stored Procedure for Database

maintenance.

> Migrated DTS packages from SQL Server 2005 to SQL Server

2008 as SSIS Packages.

>

Environment: MS SQL Server 2008 and 2005, T-SQL, SSIS Packages, Windows

2008 Server.

PROJECT#3

Project Name: CSE Fact Book

Client Name: Coca-Cola

Project Duration: From March 2013 To September 2014

Role: Developer

Roles Performed:

> Created database objects like tables, users, roles, stored

procedures.

> Write various T-SQL codes to implement the new business

logic in the existing framework.

> Writing unit test cases for various development activities.

> Created database objects like tables, users, roles, stored

procedures.

> Gathered requirements to identify and create database

objects such as tables, views and indexes.

> Created Views to enforce security and data customization.

> Created Non-Clustered indexes to improve query performance

and query optimization.

Environment: SQLServer2008, T-SQL, SSIS Packages, Windows 2008 Server.

PERSONAL DETAILS

Name : Bhaskar Reddy Maram

Date of Birth : 21st March, 1990

Preferred Location : Bangalore, Hyderabad

Languages Known : English, Telugu, Hindi, Tamil

Blood Group : O +VE[pic][pic][pic]

Contact this candidate