Sql Server,MSBI

P.L.BALAJI

Contact no: +91-805*******,+91-784*******

Email-id: ************@*****.***

CAREER OBJECTIVE

To work in learning and challenging environment, utilizing my skill and knowledge to the best of my abilities and contribute positively to the growth of the organization as well as my personal growth.

WORK EXPERIENCE

Tenure : Oct-2015 to Present

Company : Psibertech Solutions Pvt Ltd

Designation : Database Developer

TECHNICAL SKILL SET:

Data Base : MS SQL Server 2005,2008,2012,2014,2016

Application Packages : MSBI (SSRS, SSIS, SSAS )

Tool Used : Voyager 11g

ACADEMIC QUALIFICATION:

2010-2014

B.Tech

Electronics and Instrumentation Engineering

Sreenivasa Institute of Technology and Management Studies,Chittoor, AP

Aggregate: 70.85 %

2008-2010

Higher Secondary Course (12th Standard)

P.C.R Govt. Jr. College, Chittoor, AP

Aggregate: 72 %

2007-2008

Secondary School Education (10th Standard)

B.Z.Govt. high School, Chittoor, AP

Aggregate: 77 %

Project 1#:

Client : Daiwa

Database : SQL Server 2012

ETL Tools : MSBI (SSIS, SSRS)

Using SSRS and Stored Procedures Created Multiple Reports

Using SSIS Packages and SQL Server Procedures Loaded Data From Different Sources like Excel,FlatFile,SQL Server to Different Destinations

Project 2#:

Client : Singapore Government (iLight)

Database : SQL Server 2012

It is a Singapore Government Project to control the Street Lights from an automated system.

Created and Dropped Tables,Views,Indexes

Written Stored Procedures,Triggers and Functions

Project 3#:

Client : 3M

Database : SQL Server 2000/2005

Tools : MSBI (SSIS, SSAS, SSRS), Voyager (Reporting Tool Developed for 3M only)

Developed the SSIS Packages to load the Data from Multiple Sources to Multiple Destinations Using Control Flow and Data Flow tasks.

Scheduled the Jobs to Update the Packages in a required time period.

From the Data warehouses built the CUBES using SSAS and generated the Reports using SSRS and Voyager.

Giving Multi level Accessing to the CUBE using Roles.

PERSONAL PROFILE:

Name : P.L.Balaji

Father’s Name : P.L.Lakshmanan

Date of Birth : 19 Sep 1992

Gender : Male

Address : #8-606, Thotapalyam, Chittoor, A.P.517001.

DECLARATION:

I hereby declare that the information mentioned above is true to the best of my knowledge.

PLACE:

DATE: P.L.BALAJI

Contact this candidate